Get day from pandas datetime variable

Asked Oct 01 '18 at 10:16

Active Oct 01 '18 at 10:24

Viewed 126 times

Hi I have a pandas datetime object that I want to extract the day, month, year out of it.

print(data)
1   2012-09-21
2   2012-09-28
3   2012-10-05
4   2012-10-12
5   2012-10-19
6   2012-10-26
Name: Date, Length: 143, dtype: datetime64[ns]

data.day
AttributeError: 'Series' object has no attribute 'day'

Any help on this one? Thanks

asked Oct 01 '18 at 10:16

Miguel Santos

1,806
3
17
30

1

Use `data.dt.day` – jezrael Oct 01 '18 at 10:17
@jezrael actually works.. Whats the dt? – Miguel Santos Oct 01 '18 at 10:19
It is accestor for convert columns, Series to datetimelike functions - [link](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.dt.html?highlight=dt#pandas.Series.dt) – jezrael Oct 01 '18 at 10:20
Thats nice, would you post the answer or it's not worth it? – Miguel Santos Oct 01 '18 at 10:22
I found better answer, so because already answering, rather not. – jezrael Oct 01 '18 at 10:25
I think [this](https://stackoverflow.com/q/28133018) – jezrael Oct 01 '18 at 10:25
I guess.. Btw congrats for your #2 of the year, such an amazing accomplishment. – Miguel Santos Oct 01 '18 at 10:26
Thank you very much! ;) – jezrael Oct 01 '18 at 10:27
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/181062/discussion-between-miguel-santos-and-jezrael). – Miguel Santos Oct 01 '18 at 10:28

Get day from pandas datetime variable

0 Answers0