Pandas dataframe datetime timestamp from string

Question

I am trying to convert a column in a pandas dataframe from a string to a timestamp.

Due to a slightly annoying constraint (I am limited by my employers software & IT policy) I am running an older version of Pandas (0.14.1). This version does include the "pd.Timestamp".

Essentially, I want to pass a dataframe column formatted as a string to "pd.Timestamp" to create a column of Timestamps. Here is an example dataframe

      'Date/Time String'  'timestamp'
0  2017-01-01 01:02:03        NaN
1  2017-01-02 04:05:06        NaN
2  2017-01-03 07:08:09        NaN

My DataFrame is very big, so iterating through it is really inefficient. But this is what I came up with:

for i in range (len(df['Date/Time String'])):
    df['timestamp'].iloc[i] = pd.Timestamp(df['Date/Time String'].iloc[i])

What would be the sensible way to make this operation much faster?

Check df['Date/Time String']=pd.to_datetime(df['Date/Time String']) — BENY
– BENY, Commented Nov 28, 2018 at 3:56

François B. · Accepted Answer · 2019-12-19 19:22:47Z

1

You can check this:

import pandas as pd

df['Date/Time Timestamp'] = pd.to_datetime(df['Date/Time String'])

Collectives™ on Stack Overflow

Pandas dataframe datetime timestamp from string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related