How to add 0 to pandas time column

Question

I've got a data set read from csv in pandas. It turns out that pandas drops the 0 - When the minute is single digit. when I do a .tail on the column this is what I get?

5196    15:58
5197    15:59
5198     16:0
5199     16:1
5200     16:2
5201     16:3

Is this just a pandas thing and I shouldn't worry about it? Is there a fix for displaying it properly?

My guess is that its his csv file that auto converted it, probably when he edited the data in excel or something — Rushabh Mehta, Jul 10 '18 at 20:02
can we see part of the actually csv (not how excel reads it)? — It_is_Chris, Jul 10 '18 at 20:03
Are you storing hour and minute in different columns in Excel, and then combining them in pandas? The only way I can see pandas dropping a 0 is if it's a numeric at some point. Possible duplicate: https://stackoverflow.com/questions/134934/display-number-with-leading-zeros — Acccumulation, Jul 10 '18 at 20:14

score 3 · Accepted Answer · answered Jul 10 '18 at 20:03

You can make it an explicit timedelta rather than a string:

In [11]: df
Out[11]:
       time
5196  15:58
5197  15:59
5198   16:0
5199   16:1
5200   16:2
5201   16:3

In [12]: pd.to_timedelta(df.time + ":0")
Out[12]:
5196   15:58:00
5197   15:59:00
5198   16:00:00
5199   16:01:00
5200   16:02:00
5201   16:03:00
Name: time, dtype: timedelta64[ns]

In [13]: df["time"] = pd.to_timedelta(df.time + ":0")

In [14]: df
Out[14]:
         time
5196 15:58:00
5197 15:59:00
5198 16:00:00
5199 16:01:00
5200 16:02:00
5201 16:03:00

How to add 0 to pandas time column

1 Answers1