create a martix from a dataframe with a datetimeindex

Asked Aug 11 '20 at 13:16

Active Aug 11 '20 at 13:16

Viewed 10 times

I have a dataframe that has monthly data. The index is a datetimeindex & the other column is a numeric column.

What I want to do is create a matrix where I have the 12 months across the top and the years as rows and the numeric value as the elements of the matrix.

Is there a clever way to do this without me looping?

asked Aug 11 '20 at 13:16

mHelpMe

6,336
24
75
150

1

`df.groupby([df.index.month, df.index.year])['col'].first().unstack()` – Quang Hoang Aug 11 '20 at 13:18
@QuangHoang thank you for you help, if you post the comment as an answer I can mark it as correct – mHelpMe Aug 11 '20 at 13:31

create a martix from a dataframe with a datetimeindex

0 Answers0