How to join pandas Series of numbers to make it one number

Question

I'm using Pandas library.

I have three columns in dataset named 'hours', 'minutes' and 'seconds' the picture shows the three columns

I want to join the three columns to make it in time format.

For e.g the first column should read as 9:33:09

How can I do that?

stackoverflow.com/questions/31869257/… Shows a similar Problem. — thomas
– thomas, Commented Nov 15, 2020 at 8:57

Tom Ron · Accepted Answer · 2020-11-15 08:41:17Z

0

Convert to timedelta and add -

pd.to_timedelta(df["hours"], unit='h') + pd.to_timedelta(df["minutes"], unit='m') + pd.to_timedelta(df["sec"], unit='S')

Viewing you example, I think that the sec column is actually microseconds, if that's the case use -

pd.to_timedelta(df["hours"], unit='h') + pd.to_timedelta(df["minutes"], unit='m') + pd.to_timedelta(df["sec"], unit='us')

answered Nov 15, 2020 at 8:41

Tom Ron

6,2413 gold badges28 silver badges43 bronze badges

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

Comments

Prathamesh Sahasrabhojane · Accepted Answer · 2020-11-15 10:09:04Z

0

You can use string operations and pandas for this.

import pandas as pd

# Read csv

data=pd.read_csv("data.csv")


# Create a DataFrame object

df=pd.DataFrame(data,columns=["hour","mins","sec"])


# Iterate through records and print the values.

for ind in df.index: 
  hour=str(df['hour'][ind])
  min=str(df['mins'][ind])
  sec=str(df['sec'][ind])

  sec=sec[:len(sec)-4]

  if(len(sec)==1):
    sec="0"+sec

  print(hour+":"+min+":"+sec)

Output: HH:MM:SS

It appends 0 if seconds are of 1 digit.

answered Nov 15, 2020 at 10:09

Prathamesh Sahasrabhojane

891 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to join pandas Series of numbers to make it one number

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related