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

Last update on September 09 2025 12:40:22 (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:

PREV : Add Leading Zeros to Characters.
NEXT : Count Substring Occurrence.

Python Code Editor:

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