dict字典格式数据转入csv文件中

方法一

import copy
dict_list = []
# deepcopy深拷贝
dict_list.append(copy.deepcopy(write_dict))
result = pd.DataFrame.from_dict(dict_list)
result.to_csv('policy_based.csv', index=False)

方法二

 import csv

 output_file = 'economic.csv'  # 指定输出文件的路径和文件名

 try:
# newline表示不换行
# filenames表示标题行
     with open(output_file, 'w', newline='') as csvfile:
         fieldnames = ['date', 'total_cost', 'total_income', 'total_revenue', 'station_name', 'station_id']
         writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
         
         writer.writeheader()  # 写入CSV文件的列名
         
         data_dict = {'date': data_els[0, 1], 'total_cost': system_cost, 'total_income': system_income, 'total_revenue': system_revenue, 'station_name': station_name, 'station_id': station_id}
         print(data_dict)
         writer.writerow(data_dict)  # 写入数据到CSV文件
         
         logging.info('输出数据成功写入CSV文件')
 except Exception as e:
     logging.error('输出数据写入CSV文件失败，错误原因为{}'.format(e))
     return 107