Combine Pandas DataFrame DateTime Columns

Question

Supposely I have dataframes as below:

Year Month Day
2003 1     8
2003 2     7

How to combine the Year, Month, and Day in the newly defined column in the dataframe as such the dataframe would be:

Year Month Day Date
2003 1     8   2003-1-8
2003 2     7   2003-2-7

Any idea on this?

I am using pandas python dataframe

Thanks!

score 17 · Accepted Answer · edited Mar 12 '20 at 05:35

17

>>> from datetime import datetime
>>> df['Date'] = df.apply(lambda row: datetime(
                              row['Year'], row['Month'], row['Day']), axis=1)
>>> df
   Year  Month  Day                Date
0  2003      1    8 2003-01-08 00:00:00
1  2003      2    7 2003-02-07 00:00:00

Update 2020-03-12: The answer from sacul is better and faster:

%%timeit
df.apply(lambda row: datetime(
                              row['Year'], row['Month'], row['Day']), axis=1)

2.53 s ± 169 ms per loop (mean ± std. dev. of 7 runs, 1 loop each)

# use below, above is slow!!!
%%timeit
pd.to_datetime(df[['Year','Month','Day']])

14.4 ms ± 3.37 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

edited Mar 12 '20 at 05:35

ihightower

3,093
6
34
49

answered Sep 22 '13 at 14:51

Viktor Kerkez

45,070
12
104
85

Thanks! It's working. This is my first time using pandas. Your answer really cool! – Santiago Munez Sep 22 '13 at 15:08
please see answer by @sacuL below. That is better and faster. I have also updated this answer to reflect that. – ihightower Mar 12 '20 at 05:36

score 2 · Answer 2 · answered Dec 04 '18 at 01:55

2

Better use pd.to_datetime:

df['Date'] = pd.to_datetime(df[['Year','Month','Day']])
>>> df
   Year  Month  Day       Date
0  2003      1    8 2003-01-08
1  2003      2    7 2003-02-07

answered Dec 04 '18 at 01:55

sacuL

49,704
8
81
106

Combine Pandas DataFrame DateTime Columns

2 Answers2

Linked