How do I convert time from being an object to an integer in Python?

Question

I would like to convert a column from a large dataset that has the value of time as an object to an integer.

I would like to convert "Duration", "Talk Time" to int so I can perform some basic math such as the mean, the maximum and the minimum time recorded in the dataset.

	Duration	Talk Time
0	00:00:27	00:00:26
1	00:00:58	00:00:58
2	00:00:48	00:00:46
3	00:00:38	00:00:38
4	00:00:11	00:00:11

df['Duration'].astype(np.int64)

I get the error:

ValueError: invalid literal for int() with base 10: '00:00:27'

"The current time is display as 00:01:56." What integer do you want to get if you convert that time, and why? According to what logic? — Karl Knechtel
– Karl Knechtel, Commented May 19, 2022 at 21:22
Does stackoverflow.com/questions/54312802/… answer the question? — Karl Knechtel
– Karl Knechtel, Commented May 19, 2022 at 21:24
I would like to get the average time and some other calculations but I cannot do that because it's formatted as an object. — Leonardo
– Leonardo, Commented May 19, 2022 at 21:25
Thank you for the help Karl but that question does not answer my problem since I am not interested in dates. I am only interested about the time. — Leonardo
– Leonardo, Commented May 19, 2022 at 21:28
What does "average time" mean? What should the "average" of noon and midnight be - 6pm? 6am? something else? — Karl Knechtel
– Karl Knechtel, Commented May 19, 2022 at 21:29

Leonardo · Accepted Answer · 2022-05-20 19:21:37Z

0

Assuming you want to convert to seconds (and that is HH:MM:SS representation) and that is always an 8 digit string, the fastest way would be: ~~df['dur_in_secs'] = int(df['duration'][0:2])*3600 + int(df['duration'][3:5])*60 + int(df['duration'][6:8])~~

if it is not, try to isolate each part with

s_idx = df['duration'].rfind(':') # index to last part sec = int(df['duration'][s_idx+1:])

~~etc~~

Sorry about that, trying to be clever :-(

this has been tested

df["secs"] = df["duration"].apply(lambda x:int(x[0:2])*3600+ int(x[3:5])*60 + int(x[6:8]))

edited May 20, 2022 at 19:21

answered May 19, 2022 at 21:45

Leonardo

941 silver badge7 bronze badges

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

1 Comment

Leonardo Over a year ago

Thank you for your answer. I tried that code and I got this error: TypeError: 'float' object is not subscriptable

Collectives™ on Stack Overflow

How do I convert time from being an object to an integer in Python?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related