Python: how to convert timestamp to date in a pandas column?

Question

I have a dataframe like the following

print (df)
            T
0  1573119509
1  1573119512
2  1573119517
3  1573119520

I would like to convert the column T to a date. This is what I am doing:

df['Td'] = pd.to_datetime(df['T']).apply(lambda x: x.date())

but it returns:

print (df)
            T           Td
0  1573119509   1970-01-01
1  1573119512   1970-01-01
2  1573119517   1970-01-01
3  1573119520   1970-01-01

jezrael · Accepted Answer · 2019-12-01 16:18:51Z

4

Use parameter unit='s' in to_datetime and then Series.dt.date:

df['Td'] = pd.to_datetime(df['T'], unit='s').dt.date
print (df)
            T          Td
0  1573119509  2019-11-07
1  1573119512  2019-11-07
2  1573119517  2019-11-07
3  1573119520  2019-11-07

answered Dec 1, 2019 at 16:18

jezrael

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

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

2 Comments

emax Over a year ago

I would like display also seconds and milliseconds. This i what I am doing df['Td'] = pd.to_datetime(df['T'], unit='s').dt.date. How can I show seconds and milliseconds for plotting all the different points?

jezrael Over a year ago

@emax I think you can use df['Td'] = pd.to_datetime(df['T'], unit='s') only, becase converting to dates remove times, also seconds and milliseconds. If need better precision only is necessary not rounding like in my previous answer and use df['Td'] = pd.to_datetime(df['T'], unit='ms') change s to ms

Collectives™ on Stack Overflow

Python: how to convert timestamp to date in a pandas column?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related