In Pyton im tring to convert a whole dataset of hr:min:secs into seconds

Question

I'm trying to get the function i made to apply to columns I specified by separating in the iloc function

# Import useful packages for data science
import numpy as np
import pandas as pd
import os
import sys
import time
import datetime
import time

#setting the triathlone data set as TD

TD=pd.read_csv("/Applications/TriathloneData.csv")


TD

def hms_to_seconds(t):
    if(type(t) != str):
        return np.NaN
    else:
        h, m, s = [int(i) for i in t.split(':')]
        return 3600*h + 60*m + s

# first I'll separate each column I need to apply the function to
TDdf = pd.DataFrame(TD)
TDdfTime = TDdf.iloc[:,6:12]

TDdfTime

score 0 · Answer 1 · answered Apr 07 '22 at 19:18

0

You can do this pretty easily with the .apply() function available to pandas DataFrames. You can find your answer here: https://stackoverflow.com/a/34962199/8222441. Instead of using a lambda however, you can just pass your function. Hope this helps!

answered Apr 07 '22 at 19:18

Amit Maraj

344
1
5

I tried it but it didnt work – AcoffeePls Apr 07 '22 at 21:22
Do you mind sharing the code for this implementation? – Amit Maraj Apr 07 '22 at 22:20

score 0 · Answer 2 · answered Apr 08 '22 at 05:57

0

You can convert your date column to Datetime object and use total_seconds of timedelta object to get total seconds

df['date'] = pd.to_datetime(df['date'])
df['seconds'] = df['date'].dt.time.astype(str).apply(pd.to_timedelta).dt.total_seconds()

answered Apr 08 '22 at 05:57

Ynjxsjmh

28,441
6
34
52

In Pyton im tring to convert a whole dataset of hr:min:secs into seconds

2 Answers2