Parse DateTime from Object with Pandas

Question

I would like to parse the year column to datetime.

    name    id  nametype    recclass    mass (g)    fall    year                    
0   Aachen  1   Valid       L5         21.0         Fell    01/01/1880 12:00:00 AM

... reclat      reclong     GeoLocation
... 50.77500    6.08333    (50.775000, 6.083330)

df['year'].apply(dateutil.parser.parse) and that parses as 1880-01-01 00:00:00 but i can use that for selecting dates. Do anyone have a tip for me?

jezrael · Accepted Answer · 2018-06-10 18:34:27Z

2

I think need to_datetime:

df = pd.DataFrame({'year':['01/01/1880 12:00:00 AM']})

df['year'] = pd.to_datetime(df['year'])
print (df)
        year
0 1880-01-01

edited Jun 10, 2018 at 18:34

answered Jun 10, 2018 at 18:25

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

akilat90 · Accepted Answer · 2018-06-10 18:42:44Z

0

Since you have converted the year column to datetime, you can use:

df['year'] = df['year'].dt.date
# year    
# 1880-01-01

However, for datetime casting, note that pandas has an inbuilt datetime parser that is easy to use than dateutil IMO.

edited Jun 10, 2018 at 18:42

answered Jun 10, 2018 at 18:37

akilat90

5,7367 gold badges30 silver badges44 bronze badges

2 Comments

Martin Bachtold Over a year ago

Thanks but this didnt work. Can only use .dt accessor with datetimelike values

akilat90 Over a year ago

You mentioned that you did df['year'].apply(dateutil.parser.parse) which makes the year column a datetime column. This assumes that it is the case.

Collectives™ on Stack Overflow

Parse DateTime from Object with Pandas

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related