Pandas group by date range of one column and apply values to list of a second column

Asked Aug 13 '20 at 03:46

Active Aug 13 '20 at 03:46

Viewed 36 times

I have set my index to be dates. I can group the dates per month and apply an aggregating function, but I cannot group the dates by month and apply(list) the values of another column (the column named "Stuff"):

df.resample('M')['Stuff'].apply(list)

This brings up an error message:

ValueError: Length of passed values is 64, index implies 65.

asked Aug 13 '20 at 03:46

Iri

2

`df['Stuff'].resample('M').apply(list)`? – Quang Hoang Aug 13 '20 at 03:47
It worked, thank you Quang, you an post it as the answer! – Iri Aug 13 '20 at 04:12

Pandas group by date range of one column and apply values to list of a second column

0 Answers0