- data2 = pd.read_csv('data2.csv', sep = ' ', encoding = 'gbk')
- print(data2.head(5))
- print(data2.shape)
- df2 = pd.DataFrame(data2)
复制代码 Index,CardNo,PeoNo,Date,Money,FundMoney,Surplus,CardCount,Type,TermSerNo,conOperNo,Dept117342773,181316,20181316,2019/4/20 20:17,3,0,186.1,818,消费,NULL,NULL,第一食堂 117344766,181316,20181316,2019/4/20 8:47,0.5,0,199.5,814,消费,NULL,NULL,第二食堂 117346258,181316,20181316,2019/4/22 7:27,0.5,0,183.1,820,消费,NULL,NULL,第二食堂 117308066,181317,20181317,2019/4/21 7:46,3.5,0,50.2,211,消费,NULL,NULL,好利来食品店 117309001,181317,20181317,2019/4/19 22:31,2.5,0,61.7,209,消费,NULL,NULL,好利来食品店 (519367, 1)- print(df2.columns)
- df2 = df2.drop(['TermSerNo', 'conOperNo'], axis = 1)
复制代码 Index(['Index,CardNo,PeoNo,Date,Money,FundMoney,Surplus,CardCount,Type,TermSerNo,conOperNo,Dept'], dtype='object')删除操作失败,KeyError: "['TermSerNo' 'conOperNo'] not found in axis"
|