How to Use str.lower in pandas to Convert Text to Lowercase

In pandas, use Series.str.lower() to convert all string values in a column to lowercase. This method works on pandas Series containing text data and returns a new Series with all characters in lowercase.

Syntax

The str.lower() method is used on a pandas Series containing strings. It converts each string in the Series to lowercase.

• Series.str.lower(): Applies lowercase conversion to each string element.

python

Series.str.lower()

Example

This example shows how to convert a column of names in a pandas DataFrame to lowercase using str.lower().

python

import pandas as pd

data = {'Name': ['Alice', 'BOB', 'Charlie', 'dAvE']}
df = pd.DataFrame(data)

# Convert the 'Name' column to lowercase
s_lower = df['Name'].str.lower()

print(s_lower)

Output

0      alice
1        bob
2    charlie
3       dave
Name: Name, dtype: object

Common Pitfalls

Common mistakes include:

• Trying to use str.lower() directly on a DataFrame instead of a Series.
• Applying str.lower() on columns with non-string data without converting them first.
• Not handling missing values which can cause errors.

Always ensure the column is of string type or convert it using astype(str) before applying str.lower().

python

import pandas as pd

data = {'Mixed': ['Hello', 123, None, 'WORLD']}
df = pd.DataFrame(data)

# Wrong: This will raise an error because of non-string types
# df['Mixed'].str.lower()

# Right: Convert to string first
s_lower = df['Mixed'].astype(str).str.lower()
print(s_lower)

Output

0    hello
1      123
2     none
3    world
Name: Mixed, dtype: object

Quick Reference

Summary tips for using str.lower() in pandas:

• Use Series.str.lower() on string columns.
• Convert non-string columns to string first with astype(str).
• Handle missing values to avoid errors.
• Returns a new Series with lowercase strings; original data is unchanged unless reassigned.

Key Takeaways

Use Series.str.lower() to convert text data in a pandas Series to lowercase.

Ensure the column contains strings or convert it with astype(str) before using str.lower().

str.lower() returns a new Series; assign it back to modify the DataFrame column.

Handle missing or non-string values to avoid errors when using str.lower().