Trying to convert a string into a time format using pandas

Question

i like to import a dataset with pandas, this is my code:

data = pd.read_csv(source + 'clustering_CB\\AAA_tableau_jan_oct_19_cardiologia.txt' ,sep='\t' , engine='python')

Column Col10 contains string values which let me know the duration of a web visit, here's an example

00:02:35

2 minute and 35 seconds. What i like to do is to import this columns as a time format in order to measure (in seconds or in minutes) the duration of the web visit.

use pd.to_timedelta.

Lambda
– Lambda

2019-10-29 09:59:50 +00:00
Commented Oct 29, 2019 at 9:59 — Lambda
– Lambda, Commented Oct 29, 2019 at 9:59

molybdenum42 · Accepted Answer · 2019-10-29 09:58:59Z

1

If I understand your question correctly, the column already contains timedelta values (in string format) - in this case, you can apply the pd.to_timedelta function to the column:

timedelta = pd.to_timedelta(df["Col10"])

answered Oct 29, 2019 at 9:58

molybdenum42

3731 silver badge9 bronze badges

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

2 Comments

Parsifal Over a year ago

yess, thank you but i was guessing if this could be possible while importing data

molybdenum42 Over a year ago

@lucapellerossapelles I think you can, using the converters keyword in the read_csv function call. I've never used it myself, but I think it should be able to do this as well. You can read more in the documentation

Collectives™ on Stack Overflow

Trying to convert a string into a time format using pandas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related