Find & Replace Equivalent with Pandas

Python
Data Preprocessing

In this example we replace each value 1 with 'A' and 2 with 'B' in the id column.

 1|  df.loc[df['id'] == 1, 'id'] = 'A'
 2|  df.loc[df['id'] == 2, 'id'] = 'B'
DETRO
1 Upvote
Tags: Pandas | Loc
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