我有這個 df：
有
我想為每一行創建一個包含列名和資料的串列，如下所示：
[{'userid': '1', 'account_holder': 'Vince', 'broker': '1090', 'account_id': '807521'}, {'userid': '2', 'account_holder': 'Joana ', 'broker': '3055', 'account_id': '272167'}, {'userid': '3', 'account_holder': 'Dominique', 'broker': '5143', 'account_id': '37009 '}, {'userid': '4', 'account_holder': 'James', 'broker': '5522', 'account_id': '905527'}]
你能幫助我嗎？
我是 python 的新手并搜索了資訊但沒有找到任何相關資訊
uj5u.com熱心網友回復：
我們可以使用您的預期輸出來創建資料框
>>> import pandas as pd
>>> df = pd.DataFrame([{'userid': '1', 'account_holder': 'Vince', 'broker': '1090', 'account_id': '807521'}, {'userid': '2', 'account_holder': 'Joana', 'broker': '3055', 'account_id': '272167'}, {'userid': '3', 'account_holder': 'Dominique', 'broker': '5143', 'account_id': '37009'}, {'userid': '4', 'account_holder': 'James', 'broker': '5522', 'account_id': '905527'}])
>>> df
userid account_holder broker account_id
0 1 Vince 1090 807521
1 2 Joana 3055 272167
2 3 Dominique 5143 37009
3 4 James 5522 905527
DataFrame有一個to_dict方法，可以多種方式輸出。help(pd.DataFrame.to_dict)說
orient : str {'dict', 'list', 'series', 'split', 'records', 'index'}
Determines the type of the values of the dictionary.
- 'dict' (default) : dict like {column -> {index -> value}}
- 'list' : dict like {column -> [values]}
- 'series' : dict like {column -> Series(values)}
- 'split' : dict like
{'index' -> [index], 'columns' -> [columns], 'data' -> [values]}
- 'records' : list like
[{column -> value}, ... , {column -> value}]
- 'index' : dict like {index -> {column -> value}}
您可以呼叫to_dict“記錄”方向以獲得您想要的結果
>>> df.to_dict("records")
[{'userid': '1', 'account_holder': 'Vince', 'broker': '1090', 'account_id': '807521'}, {'userid': '2', 'account_holder': 'Joana', 'broker': '3055', 'account_id': '272167'}, {'userid': '3', 'account_holder': 'Dominique', 'broker': '5143', 'account_id': '37009'}, {'userid': '4', 'account_holder': 'James', 'broker': '5522', 'account_id': '905527'}]
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/536581.html