CODEWITHSUNDEEP
pythonpandasdatabasedataframecode-analyst
Luan Brito
Luan Brito

Reputation: 19

Converting object into time

I have a database that I made the difference between two dates, then I changed the format to be like : HH:MM:SS.

df['start'] type: datetime64[ns] df['end'] type datetime64[ns]

df['time'] = df['end'] - df['start']

df['time'] = type: timesdelta64

Then

def formatehours(interval): seconds = interval.total_seconds()

duration = dt.datetime.utcfromtimestamp(seconds) formatted = duration.strftime('%M:%S')

return '%02d:%s' % (seconds / (60 * 60), formatted)

So:

df['time'] = df['time'].apply(formatehours)

df['time'] = type: object

df['time']:

02:19:36 08:56:46 01:59:51

I need to calculate the median of this duration, but I can't because it's an object after it's been formatted.

Upvotes: 0

Views: 56

Answers (0)

Related Questions