Apply uppercase to a column in Pandas dataframe

Capitalize first letter of a column in Pandas dataframe

Last Updated : 11 Sep, 2024

Analyzing real-world data is somewhat difficult because we need to take various things into consideration. Apart from getting the useful data from large datasets, keeping data in required format is also very important.

One might encounter a situation where we need to capitalize any specific column in given dataframe. Let's see how can we capitalize first letter of a column in Pandas dataframe.

Let's create a dataframe from the dict of lists.

Python

# Create a simple dataframe 

# importing pandas as pd 
import pandas as pd 


# creating a dataframe 
df = pd.DataFrame({'A': ['john', 'bODAY', 'minA', 'Peter', 'nicky'], 
				'B': ['masters', 'graduate', 'graduate', 
								'Masters', 'Graduate'], 
				'C': [27, 23, 21, 23, 24]}) 

df

Output:

There are certain methods we can change/modify the case of column in pandas dataframe. Let's see how can we capitalize first letter of columns using capitalize() method.

Method #1:

Python

# Create a simple dataframe 

# importing pandas as pd 
import pandas as pd 


# creating a dataframe 
df = pd.DataFrame({'A': ['john', 'bODAY', 'minA', 'Peter', 'nicky'], 
				'B': ['masters', 'graduate', 'graduate', 
								'Masters', 'Graduate'], 
				'C': [27, 23, 21, 23, 24]}) 

df['A'] = df['A'].str.capitalize() 

df

Output:

Method #2:

Using lambda with capitalize() method

Python

# Create a simple dataframe 

# importing pandas as pd 
import pandas as pd 


# creating a dataframe 
df = pd.DataFrame({'A': ['john', 'bODAY', 'minA', 'Peter', 'nicky'], 
				'B': ['masters', 'graduate', 'graduate', 
								'Masters', 'Graduate'], 
				'C': [27, 23, 21, 23, 24]}) 

df['A'] = df['A'].apply(lambda x: x.capitalize()) 
df['A']

Output:

imp1

Apply uppercase to a column in Pandas dataframe

S

Shivam_k

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Pandas Exercises and Programs

Pandas is an open-source Python Library that is made mainly for working with relational or labelled data both easily and intuitively. This Python library is built on top of the NumPy library, providing various operations and data structures for manipulating numerical data and time series. Pandas is

Different ways to create Pandas Dataframe

It is the most commonly used Pandas object. The pd.DataFrame() function is used to create a DataFrame in Pandas. There are several ways to create a Pandas Dataframe in Python.Example: Creating a DataFrame from a DictionaryPythonimport pandas as pd # initialize data of lists. data = {'Name': ['Tom',