使用熊猫如何创建下面提到的数据帧
输入文件
01 Jeff Thomoson 000 11-28-2018 Payments 2,400 Wire transfer
01 Jeff Thomoson 000 11-29-2018 Interest 100 account
01 Paul Simson 000 11-12-2018 Payments 1,000 Wire transfer
01 Paul Simson 000 11-18-2018 Payments 140 net banking
01 John Sans 000 11-28-2018 Payments 300 cheque
输出文件
TR USER NAME TR Mode Date Narration Amt Mode
01 Jeff Thomoson 000 11-28-2018 Payments 2,400 Wire transfer
01 Jeff Thomoson 000 11-29-2018 Interest 100 account
01 Paul Simson 000 11-12-2018 Payments 1000 Wire transfer
01 Paul Simson 000 11-18-2018 Payments 140 Net banking
01 John Sans 000 11-28-2018 Payments 300 cheque
戴兹有。您需要使用的是
pd.read_fwf
。对于示例数据,这是开箱即用的:若你们仍然有解析错误,你们可能需要在宽度上做一些调整
相关问题 更多 >
编程相关推荐