how to convert integer time to time object in python

Question

I have following pandas dataframe

  code     time
  1        170000
  2        70000
  3        123000
  4        120000

My desired dataframe is following

  code     time       new_time 
  1        170000     17:00:00
  2        70000      07:00:00
  3        123000     00:30:00
  4        120000     00:00:00

I am doing following in python

data['new_time'] = [time.strftime('%H:%M:%S', time.gmtime(x)) for x in data['time']]
data['new_time'] = pd.to_datetime(data['new_time']).dt.time

It's giving me some weird conversion. How can I do it?

Just to confirm: last two lines should not be 12:30 and 12:00 but rather 00:30 and 00:00? — rafaelc
– rafaelc, Commented Sep 19, 2018 at 18:46

sacuL · Accepted Answer · 2018-09-19 18:35:19Z

4

Use the format argument in pd.to_datetime (no need for the list comprehension or the time module):

data['new_time'] = pd.to_datetime(data.time, format='%H%M%S').dt.time

>>> data
   code    time  new_time
0     1  170000  17:00:00
1     2   70000  07:00:00
2     3  123000  12:30:00
3     4  120000  12:00:00

edited Sep 19, 2018 at 18:35

answered Sep 19, 2018 at 18:33

sacuL

51.6k9 gold badges88 silver badges115 bronze badges

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

8 Comments

sacuL Over a year ago

How would you differentiate between 12 pm and 12 am? Or is 12 in the hour always 00?

Neil Over a year ago

its giving me ValueError: time data 0 does not match format '%H%M%S' (match) error

piRSquared Over a year ago

If they are integers, make them strings

sacuL Over a year ago

There must be some times that don't match the format. You can also do pd.to_datetime(data.time, format='%H%M%S', errors='coerce').dt.time, which will return NaN in the rows where the format is not interpretable as a time

Neil Over a year ago

@sacul I have 0 in time column for which it should give 00:00:00

|

Collectives™ on Stack Overflow

how to convert integer time to time object in python

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related