安装第三方库 pandas openpyxl(保存为excle用)
import pandas as pd
import openpyxl
# 数据
datalist = {
"姓名": ["张三", "李四", "王二", "赵五"],
"语文": [91, 82, 73, 65],
"数学": [99, 88, 77, 66],
"英语": [68, 78, 88, 98]
}
# 创建DataFrame对象并传入数据
dfscores = pd.DataFrame(datalist)
# 写入数据 encoding="utf-8-sig" 看情况而用哦
writer = pd.ExcelWriter("scores3.xlsx", encoding="utf-8-sig")
dfscores.to_excel(writer, "sheet1")
writer.save()
print("数据保存成功")
拓展: 利用第三方公司的数据(股票数据) 聚宽研究环境
下载股票数据到excle中
# 使用get_price()函数返回的就是DataFrame类型
# 平安银行
code_01 = get_price('000001.XSHE',start_date='2019-01-01',end_date='2019-11-28')
writer = pd.ExcelWriter("平安银行.xlsx")
code_01.to_excel(writer, "sheet1")
writer.save()
print("数据保存成功")
附:https://www.joinquant.com/research (聚宽研究环境入口)