Apply uppercase to a column in Pandas dataframe

In Pandas, you can easily convert all text in a column to uppercase using either the .str.upper() method or .apply() with a lambda function. This helps standardize text data for analysis or reporting.

Load the DataSet:

To download the dataset used in this article, click here

Use .read_csv() method to load the csv file into a dataframe:

Method 1: Using .str.upper()

Output

Method 2: Using apply() with a lambda function

Output

Explanation:

• data.dropna(inplace=True): Removes rows with any missing values to avoid errors.
• data['College'].apply(lambda x: x.upper()): Converts all entries in the 'College' column to uppercase.

Related Articles:

• Pandas Tutorial
• How to lowercase strings in a column in Pandas dataframe