Changing the Case of String Columns in a Pandas DataFrame

Python

Data Preprocessing

In this example we convert the Name column within the df dataframe to upper case, lower case, title case (where the first letter of each word is uppercase) and finally we capitalise the string (make only the first letter of the entire string uppercase).

 1|  # uppercase
 2|  df['Name'] =  df['Name'].str.upper()
 3|  
 4|  # lowercase
 5|  df['Name'] =  df['Name'].str.lower()
 6|  
 7|  # titlecase (where the first letter of each word is uppercase)
 8|  df['Name'] =  df['Name'].str.title()
 9|  
10|  # capitalize (make only the first letter of the entire string uppercase)
11|  df['Name'] =  df['Name'].str.capitalize()

DETRO

1 Upvote

Tags: Cleaning | Strings

Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Normalize Windowed Time Series

Python

Data Preprocessing

Scaler | Normalize | Scale | Min-max

4

Convert All Non-numeric Columns to Category Data Types

Python

Data Preprocessing

4

Creating a Running Total Column in Pandas

Python

Data Preprocessing

3

Pivoting Pandas Dataframes

Python

Data Preprocessing

3

Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists

Python

Data Preprocessing

2

How to Remove Punctuation From Text with Python

Python

Data Preprocessing

Nlp | String | Punctuation

2

How To Set First Row of a Pandas Dataframe as Column Headers

Python

Data Preprocessing

2

How to Create Different Aggregations Using GroupBy, Agg & Dictionaries

Python

Data Preprocessing

2

Using Pandas GroupBy Transform Function

Python

Data Preprocessing

Transform | Groupby

2

Extract Date & Time Features From a Pandas Date Column

Python

Data Preprocessing

2