按季度統(tǒng)計(jì)股票平均交易量和交易額主講人：xxXXXXXXXXXX學(xué)校問(wèn)題描述請(qǐng)統(tǒng)計(jì)貴州茅臺(tái)從2001年第四季度到2021年第二季度間每個(gè)季度交易量和交易額的總和及平均值，并繪制這些數(shù)據(jù)的折線圖，原始數(shù)據(jù)見(jiàn)表7.1.8。date交易量交易額2001-08-274063180014103471362001-08-28129647004634631362001-08-2953252001946896162001-08-3048013001775585602001-08-31232310086231000.........2021-07-12390102476587862282021-07-13299247159462872582021-07-14307706960118148802021-07-15421900583915062282021-07-1635407646958296858問(wèn)題描述輸出結(jié)果date交易量平均

總和交易額平均

總和2001-09-30966001003.864004e+0634521323301.380853e+082001-12-31592248009.708984e+0521271539063.487138e+072002-03-31741146001.482292e+0627774940155.554988e+072002-06-30291850004.946610e+0510693037131.812379e+072002-09-30192415002.960231e+056219812379.568942e+06...............2020-06-301628614002.760363e+062135520541443.619526e+092020-09-302467335003.738386e+064142097894406.275906e+092020-12-311905409003.175682e+063369741800965.616236e+092021-03-312748137584.738168e+065853278479381.009186e+102021-06-302036373523.393956e+064247974875727.079958e+09表7.1.9

貴州茅臺(tái)交易量和交易額表統(tǒng)計(jì)表圖7.1.3貴州茅臺(tái)交易量折線圖題前思考根據(jù)問(wèn)題描述，填寫以下表格問(wèn)題描述問(wèn)題解答如何對(duì)股價(jià)按季度進(jìn)行分組？

如何對(duì)各季度的數(shù)據(jù)進(jìn)行統(tǒng)計(jì)？importpandasaspdimportnumpyasnpfrompylabimportpltplt.rcParams['font.sans-serif']=['SimHei']#步驟一（替換sans-serif字體）plt.rcParams['axes.unicode_minus']=False#步驟二（解決坐標(biāo)軸負(fù)數(shù)的負(fù)號(hào)顯示問(wèn)題）df=pd.read_excel(r"D:\pydata\項(xiàng)目七\(yùn)股價(jià).xlsx",index_col=[0])①df=df.query('名稱=="貴州茅臺(tái)"').loc[:'2021-6',['交易量','交易額']]②df=df[['交易量','交易額']].resample('Q').agg([('總和',np.sum),('平均',np.mean)])③print(df)程序代碼讀入所有股票的股價(jià)數(shù)據(jù)，以第0列即日期作為行索引，日期作為行索引是時(shí)間序列的標(biāo)志。importpandasaspdimportnumpyasnpfrompylabimportpltplt.rcParams['font.sans-serif']=['SimHei']#步驟一（替換sans-serif字體）plt.rcParams['axes.unicode_minus']=False#步驟二（解決坐標(biāo)軸負(fù)數(shù)的負(fù)號(hào)顯示問(wèn)題）df=pd.read_excel(r"D:\pydata\項(xiàng)目七\(yùn)股價(jià).xlsx",index_col=[0])①df=df.query('名稱=="貴州茅臺(tái)"').loc[:'2021-6',['交易量','交易額']]②df=df[['交易量','交易額']].resample('Q').agg([('總和',np.sum),('平均',np.mean)])③print(df)程序代碼從所有股票價(jià)格中選出貴州茅臺(tái)的交易量和交易額數(shù)據(jù)。importpandasaspdimportnumpyasnpfrompylabimportpltplt.rcParams['font.sans-serif']=['SimHei']#步驟一（替換sans-serif字體）plt.rcParams['axes.unicode_minus']=False#步驟二（解決坐標(biāo)軸負(fù)數(shù)的負(fù)號(hào)顯示問(wèn)題）df=pd.read_excel(r"D:\pydata\項(xiàng)目七\(yùn)股價(jià).xlsx",index_col=[0])①df=df.query('名稱=="貴州茅臺(tái)"').loc[:'2021-6',['交易量','交易額']]②df=df[['交易量','交易額']].resample('Q').agg([('總和',np.sum),('平均',np.mean)])③print(df)程序代碼按季度對(duì)數(shù)據(jù)進(jìn)行重采樣，對(duì)每個(gè)分組分別對(duì)交易量和交易額求和及求平均。plt.rcParams['axes.unicode_minus']=False#步驟二（解決坐標(biāo)軸負(fù)數(shù)的負(fù)號(hào)顯示問(wèn)題）df=pd.read_excel(r"D:\pydata\項(xiàng)目七\(yùn)股價(jià).xlsx",index_col=[0])①df=df.query('名稱=="貴州茅臺(tái)"').loc[:'2021-6',['交易量','交易額']]②df=df[['交易量','交易額']].resample('Q').agg([('總和',np.sum),('平均',np.mean)])③print(df)df.loc[:,'交易量'].plot(style=['k-.','k-'],figsize=(16,9),secondary_y=['總和'],title='貴州茅臺(tái)季度交易量')④df.loc[:,'交易額'].plot(style=['k-.','k-'],figsize=(16,9),secondary_y=['總和'],title='貴州茅臺(tái)季度交易額')plt.show()程序代碼繪制交易量折線圖。程序代碼表7.1.11貴州茅臺(tái)交易量統(tǒng)計(jì)表

date總和平均2001-09-30966001003.864004e+062001-12-31592248009.708984e+052002-03-31741146001.482292e+062002-06-30291850004.946610e+052002-09-30192415002.960231e+05.........2020-06-301628614002.760363e+062020-09-302467335003.738386e+062020-12-311905409003.175682e+062021-03-312748137584.738168e+062021-06-302036373523.393956e+06任務(wù)小結(jié)1.描述Resample類常用方法的作用2.使用resample()方法按指定頻率對(duì)時(shí)間序列進(jìn)行重采樣并統(tǒng)計(jì)出結(jié)果一展身手按月統(tǒng)計(jì)貴州茅臺(tái)收益率的最大值、最小值、平均值和標(biāo)準(zhǔn)差（見(jiàn)表7.1.13），并繪制它們的折線圖（見(jiàn)圖7.1.5）。date最大值最小值平均值標(biāo)準(zhǔn)差2007-01-310.072360-0.0699650.0087540.0367602007-02-280.036661-0.096681-0.0110020.0361472007-03-310.099954-0.0295530.0038250.0292432007-04-300.052833-0.0392380.0007430.0243622007-05-310.070645-0.0663800.0051300.038580...............2021-02-280.059792-0.0699110.0008880.038071202