Finding mean of a list of values for each year given a certain zip code

Question

I want to get the yearly mean of a list of values associated with a zip code the problem I get this error code, can you please help me out.

My code is:

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)})

The error is:

  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

Federico Baù · Answer 1 · 2020-12-22T19:46:04.120

0

You miss a coma between f'02/9/{x}' and :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)})

edited Dec 22 '20 at 19:46

answered Dec 22 '20 at 18:56

Federico Baù

6,013
5
30
38

Hello Federico this did not work – Khan Dec 22 '20 at 19:25
@Khan, I noticed now that there was a `:` so I correct it, try now – Federico Baù Dec 22 '20 at 19:27
File "", 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 – Khan Dec 22 '20 at 19:31
is if df2.loc a function then wrapp it in `()`brackets – Federico Baù Dec 22 '20 at 19:45
Try now, I change the code again and let me know, if it works remember to vote up my answer – Federico Baù Dec 22 '20 at 19:46
no it did not work! – Khan Dec 22 '20 at 19:57
Add the new code and the error please, to the Question and not as a comment otherwise is un readable – Federico Baù Dec 22 '20 at 19:57
I added it since yesterday – Khan Dec 23 '20 at 13:53
My man, you added it the first time, then I added my answer (and correct it twice because of the syntax error) despite this you stated that by Copyng my excact code in my answer you still get an error. So I asked you to update the Answer with the new error and then new code snippet, but it's clear that is the old one, otherwise My code and your code would look the same! – Federico Baù Dec 23 '20 at 14:25
To be honest when I pasted the code I pasted it wrong and then I tried yours which I used but it gave me the same result sorry for what happened, now is there any solution if possible? – Khan Dec 23 '20 at 16:13
Can you help please – Khan Dec 23 '20 at 18:24

Finding mean of a list of values for each year given a certain zip code

1 Answers1