pandas + excel : 数据存储

数据：
data = [{1: 94, 3: 36, 7: 34},
 {1: 96, 3: 34, 7: 46},
 {1: 103, 3: 32, 7: 65},
 {1: 61, 3: 16, 7: 7},
 {1: 145, 3: 46, 7: 24},
 {1: 210, 3: 81, 7: 34},
 {1: 140, 3: 25, 7: 23},
 {1: 107, 3: 28, 7: 19},
 {1: 81, 3: 33, 7: 24},
]

import pandas as pd

df = pd.DataFrame(data)

第一步：创建一个Excel写入器

writer = pd.ExcelWriter('table.xlsx', engine='xlsxwriter')  # engine='openqyxl' 需要提前安装了 第三方模块：openqyxl

第二步：将数据写入Excel文件的第一个工作表

df.to_excel(writer, sheet_name='Sheet1', index=False)

# 保存Excel文件
writer.close()