Python 宏观经济报告.docxVIP

Python 宏观经济报告 import matplotlib.pyplot as plt import matplotlib import pandas as pd import numpy as np import xlrd from mpl_toolkits.axisartist.parasite_axes import HostAxes,ParasiteAxes import matplotlib.dates as mdates from datetime import datetime io = D:\【ZW】交接材料2020.10.21\宏观\k1.xls data = pd.read_excel(io, header=0, # index_col=0, engine=xlrd) # 设置显示中文 plt.rcParams[font.sans-serif]=[SimHei] #显示中文标签 plt.rcParams[axes.unicode_minus]=False #这两行需要手动设置 # 看看数据张啥样 # print(data) x=data[指标名称] data[铜/金]=data[期货结算价(活跃合约):COMEX铜]/data[期货收盘价(活跃合约):COMEX黄金] data[油/金]=data[期货结算价(连续):WTI原油]/data[期货收盘价(活跃合约):COMEX黄金] y1=data[铜/金] y2=data[油/金] y3=data[美国:国债收益率:10年] # y4=data[美国:联邦目标利率] y4todo=data[美国:联邦目标利率] print(data[美国:CPI]) y5todo=data[美国:CPI:当月同比] y4=[np.nan] top=len(y4todo) for i in range(1,top): if y4todo[i]!=y4todo[i]: y4.append(y4[i-1]) else: y4.append(y4todo[i]) next y5=[np.nan] top=len(y5todo) for i in range(1,top): if y5todo[i]!=y5todo[i]: y5.append(y5[i-1]) else: y5.append(y5todo[i]) next # print(y4) # 画第一个图 def figdraw1(): # 创建图表 fig=plt.figure(figsize=(35,5), dpi=90) matplotlib.rcParams.update({font.size: 22}) plt.subplots_adjust(left=0.02, right=0.99, top=0.95, bottom=0.05) # 设置图形位置，[左，下，宽，高]左+宽应当小于1，下和高亦然 ax_mainy1=HostAxes(fig,[0.05,0.1,0.85,0.8]) # 设置y轴坐标 # 设置子图ax，设置共享x轴 ax_y2=ParasiteAxes(ax_mainy1,sharex=ax_mainy1) ax_y3=ParasiteAxes(ax_mainy1,sharex=ax_mainy1) ax_y4=ParasiteAxes(ax_mainy1,sharex=ax_mainy1) ax_y5=ParasiteAxes(ax_mainy1,sharex=ax_mainy1) # 为主图添加共享y轴的子图ax_y2、ax_y3 ax_mainy1.parasites.append(ax_y2) ax_mainy1.parasites.append(ax_y3) ax_mainy1.parasites.append(ax_y4) ax_mainy1.parasites.append(ax_y5) # 为子图设置固定的副轴 y2_axisline = ax_y2.get_grid_helper().new_fixed_axis y3_axisline = ax_y3.get_grid_helper().new_fixed_axis y4_axisline = ax_