想问一下,如何读取又有缺失值,又有空格的数据,比如下面这个,理想的输出结果是,C_var1整列都是空格,但不会影响后面剩余变量的读取,求大神帮助!!
已知以下的变量和对应的数据分别为:
1) Account_ID 2) Revenue 3) Segment 4)N_var1 5) C_var1 6) Date 7) Location 8) Code 9) Amount
10001,5,G1,.,,2014-10-23,CHINA,APP_001,100
10002,6,G1,.,,2014-10-23,CHINA,APP_002,110
10003,.,G1,.,,2014-10-23,CHINA,APP_003,50
10004,10,G2,.,,2014-10-23,CHINA,APP_004,90
10005,15,G2,.,,2014-10-23,CHINA,CAN_005,12
10006,13,G2,.,,2014-10-23,CHINA,MAN_006,10000
10007,.,G2,.,,2014-10-23,CHINA,APP_007,10
10008,20,G3,.,,2014-10-23,CHINA,APP_008,100
10009,25,G3,.,,2014-10-23,CHINA,APP_009,200
10010,.,G3,.,,2014-10-23, ,REJ_010,100000
10010,.,G3,.,,2014-10-23, ,REJ_010,100000
10010,.,G4,.,,2014-10-23, ,REJ_010,100000
10010,.,G5,.,,2014-10-23, ,REJ_010,100000
10003,7,G1,.,,2014-10-24,CHINA,MAN_003,50000
10004,9,G2,.,,2014-10-24,CHINA,APP_004,90
10006,6,G2,.,,2014-10-24,CHINA,MAN_006,1000
10007,.,G2,.,,2014-10-24,CHINA,APP_007,10
10008,8,G3,.,,2014-10-24,CHINA,APP_008,100
10009,9,G3,.,,2014-10-24,CHINA,APP_009,200
10010,.,G3,.,,2014-10-24,CHINA,APP_010,100
10010,10,G4,.,,2014-10-24,CHINA,APP_011,101
10010,20,G5,.,,2014-10-24,CHINA,APP_012,102