Pandas series of datetimes in python

Question

I have a series that is purely datetimes. Call it series1.

How can I extract the months from the series in the most efficient way possible to have a new series of just the months?

For example.

series1.month

does not work. But for every row, it would work.

Alex Riley · Accepted Answer · 2014-11-04 20:03:39Z

2

In Pandas version 0.14 and older, you can use apply to extract the dates from the datetime values:

series1.apply(lambda x: x.month)

In 0.15, a new datetime Series accessor makes the operation much simpler (thanks @chrisb):

series1.dt.month

answered Nov 4, 2014 at 19:56

Alex Riley

178k46 gold badges274 silver badges247 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

In 0.15 you can use the new dt accessor, like series1.dt.month

Thanks @chrisb - I haven't looked at 0.15 yet! I'll add a link to the documentation into the answer.