How to convert a column in pandas data frame as Time object

Question

I have csv file with the date and jobs runtime values, I need to convert the object to time format. Time value will be as follows:

00:04:23
00:04:25

pd.to_datetime(df[‘Time’], format=‘%H:%M:%S:’)

This returns the value with default date

1900-01-01 00:04:23
1900-01-01 00:04:25

How do I retain only the runtime as time data type in the column without date.

score 1 · Accepted Answer · answered Apr 08 '21 at 04:15

1

We can make use of to_timedelta function in pandas.

df['Time'] = pd.to_timedelta(df['Time'])

It will create time format of `timedelta64[ns]

answered Apr 08 '21 at 04:15

maney

Thanks timedelta works as per my expectation. – ajaay kannan Vr Apr 08 '21 at 05:21

score 0 · Answer 2 · answered Apr 08 '21 at 04:01

0

You can use pandas.Series.dt.time() to access time part.

print(pd.to_datetime(df['Time'], format='%H:%M:%S').dt.time)

'''
0    00:04:23
1    00:04:25
Name: Time, dtype: object
'''

answered Apr 08 '21 at 04:01

Ynjxsjmh

2 Answers2