/Python/Change pandas column value based on condition

Change pandas column value 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

Source: stackoverflow.com

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)

Similar codes

0 vote223 views1 answer
Created by and updated by in django
Python
0 vote212 views1 answer
Window freezes after clicking of button in python GTK3
Python
0 vote217 views1 answer
Numpy euclidean distance matrix broadcasting
Python
0 vote262 views2 answers
What is mustafa nickname
Python
0 vote245 views1 answer
Django blog new post
Python Django
0 vote251 views1 answer
Then generate Django project from the project template of cookiecutter
Python Django
0 vote216 views1 answer
Mp.solutions.findhands not in python 3.8
Python
-2 votes216 views3 answers
Python substring count
Python
3 votes208 views1 answer
Np.array average row
Python
0 vote225 views1 answer
Selenium open inspect
Python