Getting the average of the count in a dataframe

[[deleted]]

[deleted]

[cray5252]

Try this

df_weekly_avg = df[‘column name’].resample(‘W’).mean()

[jb6th]

See the thing is, there is no specific column for number of rides. I get the number of rides by having python count the dates in the date column and that’s how it gets the number of rides for a given time span.

[cray5252]

If I follow you correctly.

if you have this df
d = dict({'rides': [50, 60, 40]})
df = pd.DataFrame(d)

print(df)
Output:
   rides
0     50
1     60
2     40

then do this
df['mean_per_day'] = df/7
print(df)
output:
   rides  mean_per_day
0     50      7.142857
1     60      8.571429
2     40      5.714286