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()