Pandas: Capitalize all the string values of specified columns of a given DataFrame

Last update on May 02 2025 12:51:47 (UTC/GMT +8 hours)

5. Capitalize Specified Columns

Write a Pandas program to capitalize all the string values of specified columns of a given DataFrame.

Sample Solution:

Python Code :

import pandas as pd
df = pd.DataFrame({
    'name': ['alberto','gino','ryan', 'Eesha', 'syed'],
    'date_of_birth ': ['17/05/2002','16/02/1999','25/09/1998','11/05/2002','15/09/1997'],
    'age': [18.5, 21.2, 22.5, 22, 23]
})
print("Original DataFrame:")
print(df)
print("\nAfter capitalizing name column:")
df['name'] = list(map(lambda x: x.capitalize(), df['name']))
print(df)

Sample Output:

Original DataFrame:
      name date_of_birth    age
0  alberto     17/05/2002  18.5
1     gino     16/02/1999  21.2
2     ryan     25/09/1998  22.5
3    Eesha     11/05/2002  22.0
4     syed     15/09/1997  23.0

After capitalizing name column:
      name date_of_birth    age
0  Alberto     17/05/2002  18.5
1     Gino     16/02/1999  21.2
2     Ryan     25/09/1998  22.5
3    Eesha     11/05/2002  22.0
4     Syed     15/09/1997  23.0

For more Practice: Solve these Related Problems:

Write a Pandas program to capitalize every word in specified DataFrame columns and then verify by printing the head of the DataFrame.
Write a Pandas program to apply title case formatting to multiple string columns in a DataFrame using a lambda function.
Write a Pandas program to transform designated DataFrame columns to have each word capitalized and then output the updated DataFrame.
Write a Pandas program to change the case of specified columns to title case and then check for any discrepancies with the original data.

Go to:

Previous: 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.
Next: Write a Pandas program to count of occurrence of a specified substring in a DataFrame column.

Python Code Editor:

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