in np.where if condition is true change another column data code example
Example 1: make a condition statement on column pandas
df['color'] = ['red' if x == 'Z' else 'green' for x in df['Set']]
Example 2: add a value to an existing field in pandas dataframe after checking conditions
# Create a new column called based on the value of another column
# np.where assigns True if gapminder.lifeExp>=50
gapminder['lifeExp_ind'] = np.where(gapminder.lifeExp >= 50, True, False)
gapminder.head(n=3)