我想获取与邮政编码相关的值列表的年平均值,我得到这个错误代码的问题,你能帮我吗。
我的代码是:
np.random.seed(2020)
rng = pd.date_range('2/9/2017', '3/19/2019', freq='10T')
df2 = pd.DataFrame({'SCORE':np.random.randint(1000, size=len(rng))}, index=rng)
out = pd.Series({x: df2.loc({x: df2.loc[f'02/9/{x}', :f'03/19/{x+1}', 'SCORE'].mean()
for x in range(df2.index.year.min(), df2.index.year.max()+1)})
错误是:
File "<ipython-input-150-61dcc574e6e3>", line 1
out = pd.Series({x: df2.loc({x: df2.loc[f'02/9/{x}', :f'03/19/{x+1}', 'SCORE'].mean()
^
SyntaxError: invalid syntax
您错过了f'02/9/{x}'
和之间的昏迷:f'03/19/{x 1}'
:
np.random.seed(2020)
rng = pd.date_range('2/9/2017', '3/19/2019', freq='10T')
df2 = pd.DataFrame({'SCORE':np.random.randint(1000, size=len(rng))}, index=rng)
out = pd.Series({x: df2.loc({x: df2.loc(f'02/9/{x}', f'03/19/{x+1}', 'SCORE').mean()
for x in range(df2.index.year.min(), df2.index.year.max()+1)})