Pandas: Convert String column to timestamp

Question

I have Pandas dataframe with string column which contains timestamp as "20000530 172700" How to change elegantly such string to "2000-05-30 17:27:00" ? Dataframe contains > 10k rows. I don't want take each value,insert "-" and ":" to specified positions. Is there a solution using mask?

Take a look at .datetime(). The format your strings are currently in might make it more difficult though. — goalie1998
– goalie1998, Commented Jan 26, 2021 at 20:54

Pablo C · Accepted Answer · 2021-01-26 21:04:06Z

5

you can use pandas.to_datetime:

pd.to_datetime(df["my_column"])

If you want to customize it, you can use pandas.Series.dt.strftime, e.g.:

pd.to_datetime(df["my_column"]).dt.strftime('%d%b%Y')
#The format will be something like 30May2000

You can check all the datetime format codes here.

edited Jan 26, 2021 at 21:04

answered Jan 26, 2021 at 20:54

Pablo C

4,7612 gold badges10 silver badges26 bronze badges

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

1 Comment

harp1814 Over a year ago

Thanks, Pablo! Just pd.to_datetime(df["my_column"]) gave me wished result. Thanks again!

Collectives™ on Stack Overflow

Pandas: Convert String column to timestamp

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related