利用Tushare数据接口获取

Question

利用Tushare数据接口获取中信特钢(00070
8.SZ)、抚顺特钢(600399.SH)、方大特钢(600507.SH)2020-2022年三张财务报表(资产负债表、利润表、现金流量表)的数据，并写入Excel文件。

Answer 1

让阿豪来帮你解答，本回答参考chatgpt3.5编写提供，如果还有疑问可以评论或留言

问题回答： 步骤1：导入Tushare库和Pandas库

import tushare as ts
import pandas as pd

步骤2：利用Tushare数据接口获取数据

zx = ts.get_fina_indicator(708)  # 中信特钢
fs = ts.get_fina_indicator(600399)  # 抚顺特钢
fd = ts.get_fina_indicator(600507)  # 方大特钢
zx_zcfzb = ts.get_balance_sheet(708)
zx_lrb = ts.get_income_statement(708)
zx_xjllb = ts.get_cash_flow(708)
fs_zcfzb = ts.get_balance_sheet(600399)
fs_lrb = ts.get_income_statement(600399)
fs_xjllb = ts.get_cash_flow(600399)
fd_zcfzb = ts.get_balance_sheet(600507)
fd_lrb = ts.get_income_statement(600507)
fd_xjllb = ts.get_cash_flow(600507)

步骤3：整理数据，并将数据写入Excel文件

# 中信特钢
zx_zcfzb = zx_zcfzb.loc['2020-12-31':'2022-03-31']
zx_lrb = zx_lrb.loc['2020-12-31':'2022-03-31']
zx_xjllb = zx_xjllb.loc['2020-12-31':'2022-03-31']
zx_zcfzb = zx_zcfzb.iloc[[0,1,-2,-6,-5,-4,-3],:]
zx_lrb = zx_lrb.iloc[[0,27,-3,-2,-1],:]
zx_xjllb = zx_xjllb.iloc[[0,13,-2,-1],:]
writer = pd.ExcelWriter('zx.xlsx', engine='xlsxwriter')
zx_zcfzb.to_excel(writer, sheet_name='资产负债表')
zx_lrb.to_excel(writer, sheet_name='利润表')
zx_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()
# 抚顺特钢
fs_zcfzb = fs_zcfzb.loc['2020-12-31':'2022-03-31']
fs_lrb = fs_lrb.loc['2020-12-31':'2022-03-31']
fs_xjllb = fs_xjllb.loc['2020-12-31':'2022-03-31']
fs_zcfzb = fs_zcfzb.iloc[[0,1,-2,-3,-4,-5,-7],:]
fs_lrb = fs_lrb.iloc[[0,17,-3,-2,-1],:]
fs_xjllb = fs_xjllb.iloc[[0,8,-2,-1],:]
writer = pd.ExcelWriter('fs.xlsx', engine='xlsxwriter')
fs_zcfzb.to_excel(writer, sheet_name='资产负债表')
fs_lrb.to_excel(writer, sheet_name='利润表')
fs_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()
# 方大特钢
fd_zcfzb = fd_zcfzb.loc['2020-12-31':'2022-03-31']
fd_lrb = fd_lrb.loc['2020-12-31':'2022-03-31']
fd_xjllb = fd_xjllb.loc['2020-12-31':'2022-03-31']
fd_zcfzb = fd_zcfzb.iloc[[0,1,-2,-3,-4,-5,-6],:]
fd_lrb = fd_lrb.iloc[[0,15,-3,-2,-1],:]
fd_xjllb = fd_xjllb.iloc[[0,8,-2,-1],:]
writer = pd.ExcelWriter('fd.xlsx', engine='xlsxwriter')
fd_zcfzb.to_excel(writer, sheet_name='资产负债表')
fd_lrb.to_excel(writer, sheet_name='利润表')
fd_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()

案例： 导入Tushare库和Pandas库

import tushare as ts
import pandas as pd

利用Tushare数据接口获取数据

zx = ts.get_fina_indicator(708)  # 中信特钢
fs = ts.get_fina_indicator(600399)  # 抚顺特钢
fd = ts.get_fina_indicator(600507)  # 方大特钢
zx_zcfzb = ts.get_balance_sheet(708)
zx_lrb = ts.get_income_statement(708)
zx_xjllb = ts.get_cash_flow(708)
fs_zcfzb = ts.get_balance_sheet(600399)
fs_lrb = ts.get_income_statement(600399)
fs_xjllb = ts.get_cash_flow(600399)
fd_zcfzb = ts.get_balance_sheet(600507)
fd_lrb = ts.get_income_statement(600507)
fd_xjllb = ts.get_cash_flow(600507)

整理数据，并将数据写入Excel文件

# 中信特钢
zx_zcfzb = zx_zcfzb.loc['2020-12-31':'2022-03-31']
zx_lrb = zx_lrb.loc['2020-12-31':'2022-03-31']
zx_xjllb = zx_xjllb.loc['2020-12-31':'2022-03-31']
zx_zcfzb = zx_zcfzb.iloc[[0,1,-2,-6,-5,-4,-3],:]
zx_lrb = zx_lrb.iloc[[0,27,-3,-2,-1],:]
zx_xjllb = zx_xjllb.iloc[[0,13,-2,-1],:]
writer = pd.ExcelWriter('zx.xlsx', engine='xlsxwriter')
zx_zcfzb.to_excel(writer, sheet_name='资产负债表')
zx_lrb.to_excel(writer, sheet_name='利润表')
zx_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()
# 抚顺特钢
fs_zcfzb = fs_zcfzb.loc['2020-12-31':'2022-03-31']
fs_lrb = fs_lrb.loc['2020-12-31':'2022-03-31']
fs_xjllb = fs_xjllb.loc['2020-12-31':'2022-03-31']
fs_zcfzb = fs_zcfzb.iloc[[0,1,-2,-3,-4,-5,-7],:]
fs_lrb = fs_lrb.iloc[[0,17,-3,-2,-1],:]
fs_xjllb = fs_xjllb.iloc[[0,8,-2,-1],:]
writer = pd.ExcelWriter('fs.xlsx', engine='xlsxwriter')
fs_zcfzb.to_excel(writer, sheet_name='资产负债表')
fs_lrb.to_excel(writer, sheet_name='利润表')
fs_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()
# 方大特钢
fd_zcfzb = fd_zcfzb.loc['2020-12-31':'2022-03-31']
fd_lrb = fd_lrb.loc['2020-12-31':'2022-03-31']
fd_xjllb = fd_xjllb.loc['2020-12-31':'2022-03-31']
fd_zcfzb = fd_zcfzb.iloc[[0,1,-2,-3,-4,-5,-6],:]
fd_lrb = fd_lrb.iloc[[0,15,-3,-2,-1],:]
fd_xjllb = fd_xjllb.iloc[[0,8,-2,-1],:]
writer = pd.ExcelWriter('fd.xlsx', engine='xlsxwriter')
fd_zcfzb.to_excel(writer, sheet_name='资产负债表')
fd_lrb.to_excel(writer, sheet_name='利润表')
fd_xjllb.to_excel(writer, sheet_name='现金流量表')
writer.save()