看来你需要
to_dict先
dict于
json:
df = pd.Dataframe({"index": [ 0, 1 ,3 ], "col1": [ "250", "1" ,"3" ], "col2": [ "250", "1" ,"3" ]})print (df) col1 col2 index0 250 250 01 1 1 12 3 3 3print (df.to_dict(orient='list')){'col1': ['250', '1', '3'], 'col2': ['250', '1', '3'], 'index': [0, 1, 3]}import jsonprint (json.dumps(df.to_dict(orient='list'))){"col1": ["250", "1", "3"], "col2": ["250", "1", "3"], "index": [0, 1, 3]}由于尚未实现:
print (df.to_json(orient='list'))
ValueError:选项“ orient”的值“ list”无效
编辑:
如果index不是column,请添加
reset_index:
df = pd.Dataframe({"col1": [250, 1, 3], "col2": [250, 1, 3]})print (df) col1 col20 250 2501 1 12 3 3print (df.reset_index().to_dict(orient='list')){'col1': [250, 1, 3], 'index': [0, 1, 2], 'col2': [250, 1, 3]}


