我有一個像這樣的熊貓資料框
data = {"Name": ["Tom", "nick", "kish", "jack"], "Age": [20, 21, 19, 18]}
df1 = pd.DataFrame(data)
df1.to_json(orient="records", lines=True)
'{"Name":"Tom","Age":20}\n{"Name":"nick","Age":21}\n{"Name":"kish","Age":19}\n{"Name":"jack","Age":18}\n'
我想將 json 存盤到一個列中并有這樣的輸出。
Name Age json
0 Tom 20 {"Name":"Tom","Age":20}
1 nick 21 {"Name":"nick","Age":21}
2 kish 19 {"Name":"kish","Age":19}
3 jack 18 {"Name":"jack","Age":18}
uj5u.com熱心網友回復：
使用新行拆分并洗掉尾隨值：
df1['new'] = df1.to_json(orient="records", lines=True).strip().split('\n')
或者如果需要字典：
df1['new'] = df1.to_dict(orient="records")
print (df1)
Name Age new
0 Tom 20 {'Name': 'Tom', 'Age': 20}
1 nick 21 {'Name': 'nick', 'Age': 21}
2 kish 19 {'Name': 'kish', 'Age': 19}
3 jack 18 {'Name': 'jack', 'Age': 18}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/467364.html
標籤：熊猫
上一篇：如何在JavaScript中洗掉或關閉未關閉的HTML？
下一篇：為什么當BOOL_VAR為假時Makefile運算式“exportINTEGER_VAR?=$(if$(BOOL_VAR),2,5)”會導致INTEGER_VAR=2？