]如果可以将当天收盘价格视为当天股票交易的平均价格,当天成交量视为在该平均价格基础上的交易量。请利用JD.csv数据,分别计算JD股票的每周的平均价格。 参考输出结果:
{(2016, 33): 25.642582803928192,
(2016, 34): 25.692574403238215,
(2016, 35): 25.55068142834686,
(2016, 36): 26.550227231831688,
(2016, 37): 26.25731043215796,
(2016, 38): 26.225308611815784,
(2016, 39): 26.311983426202907,
…… }
对数据分组求平均
import pandas as pd
df=pd.read_csv('maotai.csv',encoding='utf-8')
df.date=pd.to_datetime(df.date)
df=df[df.date.dt.year==2020]
df.date=df.date.apply(lambda x:(x.year,x.week))
pa=df.groupby(['date'])['close'].mean()
print(pa)
F:\2022\py01>t13
date
(2020, 1) 1104.280000
(2020, 2) 1095.172000
(2020, 3) 1111.660000
(2020, 4) 1073.652500
(2020, 6) 1047.784000
(2020, 7) 1088.152000
(2020, 8) 1101.040000