Change date format in pandas dataframe

Question

I have this dataframe:

             date        value
1   Thu 17th Nov 2016   385.943800
2   Fri 18th Nov 2016  1074.160340
3   Sat 19th Nov 2016  2980.857860
4   Sun 20th Nov 2016  1919.723960
5   Mon 21st Nov 2016   884.279340
6   Tue 22nd Nov 2016   869.071070
7   Wed 23rd Nov 2016   760.289260
8   Thu 24th Nov 2016  2481.689270
9   Fri 25th Nov 2016  2745.990070
10  Sat 26th Nov 2016  2273.413250
11  Sun 27th Nov 2016  2630.414900
12  Mon 28th Nov 2016   817.322310
13  Tue 29th Nov 2016  1766.876030
14  Wed 30th Nov 2016   469.388420

I would like to change the format of the date column to this format YYYY-MM-DD. The dataframe consists of more than 200 rows, and every day new rows will be added, so I need to find a way to do this automatically.

This link is not helping because it sets the dates like this dates = ['30th November 2009', '31st March 2010', '30th September 2010'] and I can't do it for every row. Anyone knows a way to solve this?

You can do that with dateutil package.

Mohammad Yusuf
– Mohammad Yusuf

2016-12-14 16:29:23 +00:00
Commented Dec 14, 2016 at 16:29 — Mohammad Yusuf
– Mohammad Yusuf, Commented Dec 14, 2016 at 16:29

Mohammad Yusuf · Accepted Answer · 2016-12-14 16:26:35Z

2

Dateutil will do this job.

from dateutil import parser

print df
df2 = df.copy()
df2.date = df2.date.apply(lambda x: parser.parse(x))
df2

Output:

answered Dec 14, 2016 at 16:26

Mohammad Yusuf

17.1k12 gold badges60 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Change date format in pandas dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related