import pandas as pd
import matplotlib.pyplot as plt
# 遇到数据中有中文的时候,一定要先设置中文字体
plt.rcParams['font.sans-serif']=['SimHei']# 用黑体显示中文
path ='C:/Users/Administrator/Desktop/playground2/09.折线与柱状组合图.xlsx'
data = pd.read_excel(path)
w = plt.figure()#画布
a = w.add_subplot(221)#代表两行两列的