统计分析案例 同比，定比，环比

#对比分析
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