Python: how to add zeros to the entries of a data frame column?

Asked Jul 19 '18 at 07:59

Active Jul 19 '18 at 07:59

Viewed 25 times

I have a data frame contains the information of some ids.

I would like to add some zeros before each ids in order to get ids of 8 digits, in order to get:

df  
    ID
0   00000034
1   00000756
2   00001090
3   00000003
4   00000045
5   00549020

asked Jul 19 '18 at 07:59

emax

Use `df['ID'] = df['ID'].str.zfill(8)` – jezrael Jul 19 '18 at 08:01
@jezrael should I convert the values as strings? – emax Jul 19 '18 at 08:10
1

Yes, try `df['ID'] = df['ID'].astype(str).str.zfill(8)` – jezrael Jul 19 '18 at 08:13

0 Answers0