w3resource

Pandas: Add leading zeros to the character column in a pandas series and makes the length of the field to 8 digit


4. Add Leading Zeros to Characters

Write a Pandas program to add leading zeros to the character column in a pandas series and makes the length of the field to 8 digit.

Sample Solution:

Python Code :

import pandas as pd
nums = {'amount': ['10', '250', '3000', '40000', '500000']}
print("Original dataframe:")
df = pd.DataFrame(nums)
print(df)
print("\nAdd leading zeros:")
df['amount'] = list(map(lambda x: x.zfill(10), df['amount']))
print(df)

Sample Output:

Original dataframe:
   amount
0      10
1     250
2    3000
3   40000
4  500000

Add leading zeros:
       amount
0  0000000010
1  0000000250
2  0000003000
3  0000040000
4  0000500000

For more Practice: Solve these Related Problems:

  • Write a Pandas program to format a character series by padding each value with leading zeros until the length reaches 8.
  • Write a Pandas program to convert a text column to a uniform 8-character string with leading zeros added where needed.
  • Write a Pandas program to update a series of strings by prepending zeros to each entry so that the total length equals 8 characters.
  • Write a Pandas program to process a character column to add leading zeros dynamically based on the current length of each string.

Go to:


Previous: Write a Pandas program to add leading zeros to the integer column in a pandas series and makes the length of the field to 8 digit.
Next: Write a Pandas program to capitalize all the string values of specified columns of a given DataFrame.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.