Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

pandas
python

How to use the upper() function in pandas

Maria Elijah

Overview

The upper() function of the pandas library in Python converts all characters in a string to uppercase.

Syntax

upper()

Note: The upper() function can’t be used on the entire column of a DataFrame.

Code example

The following code demonstrates how to use the upper() function in pandas:

import pandas as pd

# Create a DataFrame
df = pd.DataFrame({
    "name": ["Maria","Paul","Eva","Oliver","Sebastian","Camila"],
    "age":[20,22,32,26,29,30],
    "salary":[2000,2500,4000,3500,4200,3000],
    "gender":["female","male","female","male","male"
    ,"female"]
})

# Convert string to uppercase using upper()
print(df["name"][1].upper())

Code explanation

  • Line 1: We import the pandas library.

  • Lines 4–10: We create a DataFrame, df, from a dictionary.

  • Line 13: We use the upper() function to convert name at index 1 to uppercase. Then, we print the output.

Note: If we use the upper() method on the entire column, we will get an error.

RELATED TAGS

pandas
python
RELATED COURSES

View all Courses

Keep Exploring