Adding single leading zero to entire column based on length of value Python

Asked Feb 10 '19 at 03:37

Active Feb 10 '19 at 03:40

Viewed 27 times

I have a column that I want to add one leading zero to. The zfill() function seems to only allow me to fill to a certain width as shown below:

#numeric as string
df = pd.DataFrame({'ID':['1', '2', '33', '4', 'SS', '15', 'S1', 'A1']})

df['ID'] = df['ID'].str.zfill(2)
print (df)

  ID
0      01
1      02
2      33
3      04
4      SS
5      15
6      S1
7      A1

What I'd like is an ouput that looks like this:

So that no matter what length the string is the zero value added is adjusted to only add to the len(ID) + 1.

Is there an easy way to do this?

edited Feb 10 '19 at 03:40

asked Feb 10 '19 at 03:37

HelloToEarth

2,027
3
22
48

1

String addition would work here, df['ID'] = '0' + df['Section'] – Vaishali Feb 10 '19 at 03:40
I recommend checking out [my answer](https://stackoverflow.com/a/54392591/4909087) to the linked dupe if you are interested in more options. – cs95 Feb 10 '19 at 03:43
1

@coldspeed, you do have an ANSWER for every problem ;) – Vaishali Feb 10 '19 at 03:44
1

@Vaishali Not yet, but [I'm working on it!](https://github.com/Coldsp33d/stackoverflow-pandas-canonicals) – cs95 Feb 10 '19 at 03:45
1

@coldspeed, wow! – Vaishali Feb 10 '19 at 03:46

Adding single leading zero to entire column based on length of value Python

0 Answers0