python将data文件转换为csv文件_Python将字典转换为dataframe并将其导出为csv文件

df = pd.read_csv('test.csv')

for i in range(len(df['name'])):

names.append(df['name'][i])

balances.append(df['balance'][i])

def acc_creation(name):

names.append(name)

dict = {'name': names, 'balance': balances}

new_df = pd.DataFrame.from_dict(

dict, orient='index', columns=['name', 'balance'])

new_df.to_csv('test.csv', encoding='utf-8', sep=',',

header=False, na_rep=0, index=True)

Traceback (most recent call last):

File "/Users/darkmbs/Desktop/python/test.py", line 9, in

balances.append(df['balance'][i])

File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/pandas/core/frame.py", line 3024, in __getitem__

indexer = self.columns.get_loc(key)

File "/Library/Frameworks/Python.framework/Versions/3.9/lib/python3.9/site-packages/pandas/core/indexes/base.py", line 3082, in get_loc

raise KeyError(key) from err

KeyError: 'balance'

name,balance

xyzz,0

abc,0

我得到的结果是:

name,xyzz,abcd

balance,0,0