一行拆多行，动态列

润乾软件

于 2021-10-15 09:16:21 发布

阅读量89

点赞数

分类专栏： JAVA计算文章标签：数据处理 java csv

本文链接：https://blog.csdn.net/raqsoft/article/details/120776827

版权

针对带有特定前缀的CSV文件，需要转换为新的CSV格式，包括小写化头衔、删除头衔前缀、合并共享部分名称的列，并保留原始行的特殊值。使用SPL语言可以实现动态转换，处理过程中需要处理未知数量和名称的列，同时确保具有特定标识（如'Inc'）的列在合并时得以保留。

摘要由CSDN通过智能技术生成

【问题】

I have a CSV file whose awful format I cannot change (simplified here):

Inc,a_One,a_Two,a_Three,b_One,b_Two,b_Three
1,1,1.5,"5 Things",2,2.5,"10 Things"
2,5,5.5,"10 Things",6,6.5,"20 Things"
Inc,a_One,a_Two,a_Three,b_One,b_Two,b_Three
3,9,9.5,"15 Things",10,10.5,"30 Things"

My desired output is a new CSV containing:

inc,label,one,two,three
1,"a",1,1.5,"5 Things"
2,"a",5,5.5,"10 Things"
3,"a",9,9.5,"15 Things"
1,"b",2,2.5,"10 Things"
2,"b",6,6.5,"20 Things"
3,"b",10,10.5,"30 Things"

Basically: