[Conditionally update Pandas DataFrame column] It is equivalent to SQL: UPDATE table SET column_to_update = 'value' WHERE condition #python #pandas #datascience

conditional_update_pandas.py

# set 'column_to_update' to 0 when 'condition_column' is 0
df.loc[df['condition_column'] == 0, 'column_to_update'] = 0

# or with a if-then-else scheme
df["mycol"] = np.where((df.mycol2=="test"), 0, 1)
#                           condition     then else