Case statement in pandas

# If the row value in column 'is_blue' is 1 
# Change the row value to 'Yes' 
# otherwise change it to 'No'
df['is_blue'] = df['is_blue'].apply(lambda x: 'Yes' if (x == 1) else 'No') 
# or you can use np.where
df['is_blue'] = np.where(df['is_blue'] == 1, 'Yes', 'No')
# You can also use mapping to accomplish the same result
# Warning: Mapping only works once on the same column creates NaN's otherwise
df['is_blue'] = df['is_blue'].map({0: 'No', 1: 'Yes'})

Pandas columns case when equivalent

df['c'] = np.select(
[
    (df['a'].isnull() & (df['b'] == 0))
], 
[
    1
], 
default=0 )

Source: stackoverflow.com

Similar codes

0 vote144 views1 answer
Pipenv installs
Python
0 vote117 views1 answer
Ipywidgets label text color
Python
20 votes133 views3 answers
Convert a number column into datetime pandas
Python
0 vote109 views1 answer
Matplotlib show percentage y axis
Python
2 votes112 views1 answer
Slicing in pandas
Python
0 vote136 views1 answer
Pandas resample fill missing values
Python
24 votes118 views2 answers
Make an executable with visual studio python
Python
29 votes112 views2 answers
Python 1 second delay
Python
5 votes119 views4 answers
Dropna for specific column pandas
Python
6 votes114 views1 answer
Angle names matplotlib
Python