pandas change cell value based on condition code example
Example 1: change value in pandas dataframe cell
df.loc[row_or_index, column_name] = value
Example 2: pandas replace values in column based on condition
In [41]:
df.loc[df['First Season'] > 1990, 'First Season'] = 1
df
Out[41]:
Team First Season Total Games
0 Dallas Cowboys 1960 894
1 Chicago Bears 1920 1357
2 Green Bay Packers 1921 1339
3 Miami Dolphins 1966 792
4 Baltimore Ravens 1 326
5 San Franciso 49ers 1950 1003
Example 3: change column value based on another column pandas
df['is_electric']= df['type'].apply(lambda x: 'YES' if (x == 'electric') else 'NO')
Example 4: pandas update with condition
import pandas as pd
import numpy as np
df = pd.DataFrame({'value':np.arange(1000000)})
df['value'] = np.where(df['value'] > 20000, 0, df['value'])
df.loc[df['value'] > 20000, 'value'] = 0
df['value'] = df['value'].mask(df['value'] > 20000, 0)
df['a'] = df.where(df.a <= 20000, 0)
Example 5: replace values in a column by condition python
df.loc[df['employrate'] > 70, 'employrate'] = 7