v Quickly Change A Column Of Strings In Pandas - Python

Quickly Change A Column Of Strings In Pandas

Often I need or want to change the case of all items in a column of strings (e.g. BRAZIL to Brazil, etc.). There are many ways to accomplish this but I have settled on this one as the easiest and quickest.

# Import pandas
import pandas as pd

# Create a list of first names
first_names = pd.Series(['Steve Murrey', 'Jane Fonda', 'Sara McGully', 'Mary Jane'])
# print the column
first_names
0    Steve Murrey
1      Jane Fonda
2    Sara McGully
3       Mary Jane
dtype: object
# print the column with lower case
first_names.str.lower()
0    steve murrey
1      jane fonda
2    sara mcgully
3       mary jane
dtype: object
# print the column with upper case
first_names.str.upper()
0    STEVE MURREY
1      JANE FONDA
2    SARA MCGULLY
3       MARY JANE
dtype: object
# print the column with title case
first_names.str.title()
0    Steve Murrey
1      Jane Fonda
2    Sara Mcgully
3       Mary Jane
dtype: object
# print the column split across spaces
first_names.str.split(" ")
0    [Steve, Murrey]
1      [Jane, Fonda]
2    [Sara, McGully]
3       [Mary, Jane]
dtype: object
# print the column with capitalized case
first_names.str.capitalize()
0    Steve murrey
1      Jane fonda
2    Sara mcgully
3       Mary jane
dtype: object

You get the idea. Many more string methods are avaliable here