#对比分析
import pandas as pd
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif']=['SimHei']
df=pd.read_excel('car.xlsx')
#print(df)
x=df['车型']
y=df['1月销量']
plt.subplots_adjust(left=0.2) #调整图表距左的空白
plt.title('汽车销量')
plt.barh(x,y)
#同比分析 本期数据与历史同期数据对比
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df=pd.read_excel('JD2019.xlsx')
df=df.set_index('日期')
df1=pd.concat([df['2019-02'],df['2020-02']]) #数据合并
df1=df1[df1['商品名称']=='零基础学HTML5+CSS3(全彩版)']
df1=df1[['北京','上海','广州','成都','武汉','沈阳','西安']] #特定列
df2=df1.T #转置
x=np.array([0,1,2,3,4,5,6])
y1=df2['2019-02-01']
y2=df2['2020-02-01']
df2['rate']=((y2