Removing Whitespace or Characters from a Dataframe Column

Python
Data Preprocessing

 1|  # remove whitespace from all strings in the Name column
 2|  df['Name'] = df['Name'].str.strip()
 3|  
 4|  # remove all commas from the Name column
 5|  df['Name'] = df['Name'].str.strip(",")
DETRO
1 Upvote
Tags: Whitespace | Strip
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

Pandas

4
Creating a Running Total Column in Pandas
Python
Data Preprocessing

Pandas

3
Pivoting Pandas Dataframes
Python
Data Preprocessing

Pandas

3
Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists
Python
Data Preprocessing

Rename

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

Headers

2
How to Create Different Aggregations Using GroupBy, Agg & Dictionaries
Python
Data Preprocessing

Groupby | Agg

2
Using Pandas GroupBy Transform Function
Python
Data Preprocessing

Transform | Groupby

2
Extract Date & Time Features From a Pandas Date Column
Python
Data Preprocessing

Dt | Dates

2