Answers for "python pandas case when"

5

make a condition statement on column pandas

df['color'] = ['red' if x == 'Z' else 'green' for x in df['Set']]
Posted by: Guest on May-12-2020
1

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'})
Posted by: Guest on November-19-2020
2

if condition dataframe python

df.loc[df['age1'] - df['age2'] > 0, 'diff'] = df['age1'] - df['age2']
Posted by: Guest on May-20-2020

Python Answers by Framework

Browse Popular Code Answers by Language