CODEWITHSUNDEEP
pythonpandasdatetimedataframepandas-groupby
Keithx
Keithx

Reputation: 3158

Average difference in days between the values within a column in Pandas

I'm having such a datafrmae in Python Pandas: enter image description here

The "delivered_at" column is datetime while started_week is object column. I'm wondering, how can I using groupby() function will be able to receive the aggregation for a week for an average difference in days between the values in "delivered_at" column? Something like that:

started_week   avg_delivered
 2013-W03          7

Upvotes: 2

Views: 1073

Answers (1)

piRSquared
piRSquared

Reputation: 294506

Should be

df.groupby('started_week').delivered_at.apply(lambda x: x.diff().mean())

started_week
2013-W03   7 days
Name: delivered_at, dtype: timedelta64[ns]

Upvotes: 3

Related Questions