How to convert string/float to time in python/pandas?

Question

I have a dataset which stores durations like 3 hours and 7 minutes in the format of, 3.11 as a string. I want to convert the column containing these values into datetime in a way that I get: 03:07.

When I do:

df["ConnectedDuration"] = pd.to_datetime(df['ConnectedDuration'])

I get: 1970-01-01 00:00:00.000000003 which is obviousely not what I want.

When I do:

df["ConnectedDuration"] = pd.to_datetime(df['ConnectedDuration'], format='%H:%M')

I get the following error: ValueError: time data '3' does not match format '%H:%M' (match)

Any help is highly appreciated

Benjamin · Accepted Answer · 2020-07-15 18:55:08Z

3

You want to convert this values to timedelta instead of datetime. Thus you should use the pd.to_timedelta method, like:

pd.to_timedelta(df["ConnectedDuration"].astype('float'), unit='h')

answered Jul 15, 2020 at 18:55

Benjamin

3,5082 gold badges35 silver badges42 bronze badges

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

1 Comment

leabum Over a year ago

Thank you very much! I will accept your answer once it's possible.

Collectives™ on Stack Overflow

How to convert string/float to time in python/pandas?

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