grouping rows of pandas dataframe inside a loop

Asked Dec 21 '18 at 03:57

Active Dec 21 '18 at 03:57

Viewed 12 times

I have the below dataframe test and my objective is to check if the time period repeats and if it repeats I want to group by and take a mean of repeated time rows

My desired output will be like

I have tried the below code

for i in range(len(test)-1):
    if test['time'][i] == test['time'][i+1]:

        test[i:i+1].groupby('time').mean().reset_index()
    else:

        break

But its not working as desired. Will appreciate any help. Thank you

asked Dec 21 '18 at 03:57

Ahamed Moosa

1,395
7
16
30

3

It's just `df.groupby('time', as_index=False).mean()` – cs95 Dec 21 '18 at 03:59
When you say not working as desired, what is it doing? Are you getting an error? – artemis Dec 21 '18 at 03:59
@coldspeed , Got it, I don't even have to run the loop. Thanks – Ahamed Moosa Dec 21 '18 at 04:04

grouping rows of pandas dataframe inside a loop

0 Answers0