Pandas update with condition

import pandas as pd
import numpy as np

df = pd.DataFrame({'value':np.arange(1000000)})

# Solution 1 - Fastest :
df['value'] = np.where(df['value'] > 20000, 0, df['value'])

# Solution 2:
df.loc[df['value'] > 20000, 'value'] = 0

# Solution 3:
df['value'] = df['value'].mask(df['value'] > 20000, 0)

# Solution 4 - Slowest, note that df.where applies where condition is wrong:
df['a'] = df.where(df.a <= 20000, 0)

Pandas filter and change value

df.loc[df['dollars_spent'] > 0, 'purchase'] = 1

Similar codes

1 vote133 views1 answer
Backup django db from one database to another
Python Django
9 votes104 views2 answers
Python delete all data from file
Python
0 vote146 views1 answer
|safe django
Python Django
-2 votes122 views1 answer
Django e docker
Python Django
0 vote105 views1 answer
Python code pycharm
Python
3 votes110 views1 answer
Spark df shape
Python
0 vote124 views1 answer
Python logger printing multiple times
Python
3 votes110 views1 answer
Application of stack python
Python
2 votes102 views2 answers
Matplotlib measure the width of text
Python
0 vote103 views2 answers
Install python macos catalina
Python