如何改写一个CSV文件
现在要对一个csv文件（其中数据冗余比较大）进行改写，可以理解为把原csv文件拉直，各位大牛帮忙看下有什么方法可以实现（由于原文件比较大，我可以发到各位邮箱），谢谢！
改写后格式为：SEDOL（序号，如656099），FPE（预测年份，包含FPE1：12/31/2011和FPE2:12/31/2012），Date（预测日期），BROKER（经纪人），EPS，BPS，DPS，TP。。。
改写后的格式如下：
SEDOL FPE Date BROKER EPS BPS DPS TP
656099 12/31/2011 03/10/2011 1171 1.07793 7.09544 0.213219 ...
656099 12/31/2012 03/10/2011 1171 1.1727 8.05493 0.23691 ...
改写前格式为：
656099^EPS_FPE112/31/2011
EPS_FPE212/31/2012
EPS_BROKER1117117881545
EPS_DATE103/10/201103/11/201103/16/2011
EPS_VALUE11.077931.066141.34071
BPS_BROKER1117177686
BPS_DATE103/10/201103/23/201103/23/2011
BPS_VALUE17.095449.860597.75888
DPS_BROKER1117114492143
DPS_DATE103/10/201103/22/201103/22/2011
DPS_VALUE10.2132190.2377280.225842
TP_BROKER11455211711746
TP_DATE1@NA03/10/201103/10/2011
TP_VALUE1NA1920.94
SALES_BROKER11171117114492
SALES_DATE103/10/201103/21/201103/22/2011
SALES_VALUE126326.625866.827824
NET_BROKER11171178814492
NET_DATE103/10/201103/11/201103/22/2011
NET_VALUE15273.64773.985518.73
EPS_BROKER2117117881545
EPS_DATE203/10/201103/11/201103/16/2011
EPS_VALUE21.17271.2321.6136
BPS_BROKER2117114377
BPS_DATE203/10/201103/22/201103/23/2011
BPS_VALUE28.054938.5463311.0485
DPS_BROKER2117114492143
DPS_DATE203/10/201103/22/201103/22/2011
DPS_VALUE20.236910.2733880.261501
TP_BROKER21455211711746
TP_DATE2@NA03/10/201103/10/2011
TP_VALUE2NA1920.94
SALES_BROKER21171117114492
SALES_DATE203/10/201103/21/201103/22/2011
SALES_VALUE229548.529098.631810.4
NET_BROKER21171178814492
NET_DATE203/10/201103/11/201103/22/2011
NET_VALUE25724.915549.96148.66
RATING_BR178815451169
RATING_DATE03/11/201103/16/201103/22/2011
RATING_VLOverweightBuyOverweight
CURRENCYHKD
B56FB9^12/31/2011
12/31/2012
117110515680
03/09/2011@NA04/25/2011
0.094786NA0.193
117110515680
03/09/2011@NA04/25/2011
1.24407NA1.034
117110515680
03/09/2011@NA04/25/2011
0NA0.048
117110515680
03/09/2011@NA04/25/2011
1.64NA1.2
117110515680
03/09/2011@NA04/25/2011
2645.72NA6202.78
117110515680
03/09/2011@NA04/25/2011
236.965NA481.056
117110515680
03/09/2011@NA04/25/2011
0.189573NA0.249
117110515680
03/09/2011@NA04/25/2011
1.74169NA1.221
117110515680
03/09/2011@NA04/25/2011
0NA0.062
117110515680
03/09/2011@NA04/25/2011
1.64NA1.2
117110515680
03/09/2011@NA04/25/2011
4723.91NA6826.55
117110515680
03/09/2011@NA04/25/2011
479.855NA619.881
1171156801377
03/09/201104/25/201104/26/2011
HoldSellSell
[解决办法]
csv可以理解为修改了后缀名的txt文件
直接操作就行了
