如何从列表中正确创建数据帧:所有列都合并到单个列“0”中

2024-03-29 07:32:34 发布

您现在位置:Python中文网/ 问答频道 /正文

我有以下代码:

print("body['csvData']", body['csvData'])

print("===============================")

csvData = pd.DataFrame([x.split(';') for x in str(body['csvData']).split('\n')])

print("TYPE csvData", type(csvData))

print(csvData.head())

它从React.js接收POST body请求的内容,并尝试将csvData转换为DataFrame

我得到这个输出:

body['csvData']
 NUM,AIRLINE_ARR_ICAO,WAKE,SIBT,SOBT,PLANNED_TURNAROUND,DISTANCE_FROM_ORIGIN,DISTANCE_TO_TARGET
1,AEA,H,2016-01-01 04:05:00,2016-01-01 14:10:00,605,9920.67,5776.89
2,AEA,H,2016-01-01 04:25:00,2016-01-01 06:30:00,125.0,10060.80,483.93
3,AVA,H,2016-01-01 05:05:00,2016-01-01 07:05:00,120.0,8033.86,8033.86
4,IBE,H,2016-01-01 05:20:00,2016-01-01 10:40:00,320.0,6000.00,8507.73
5,IBE,H,2016-01-01 05:25:00,2016-01-01 10:50:00,325.0,6698.42,6698.42

===============================
TYPE csvData <class 'pandas.core.frame.DataFrame'>
                                                0
0  NUM,AIRLINE_ARR_ICAO,WAKE,SIBT,SOBT,PLANNED_TU...
1,AEA,H,2016-01-01 04:05:00,2016-01-01 14:10:0...
2,AEA,H,2016-01-01 04:25:00,2016-01-01 06:30:0... 
3,AVA,H,2016-01-01 05:05:00,2016-01-01 07:05:0... 
4,IBE,H,2016-01-01 05:20:00,2016-01-01 10:40:0...

看起来csvData被转换为数据帧,但是所有列都被合并到一个名为0的列中

print(csvData.dtypes)

输出:

0    object
dtype: object

Tags: dataframetypebodynumsplitprintarrwake