/Python/Pandas replace values based on condition

Pandas replace values based on condition

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

Source: stackoverflow.com

Pandas conditional replace values in a series

# np.where function works as follows:
import numpy as np

# E.g. 1 - Set column values based on if another column is greater than or equal to 50
df['X'] = np.where(df['Y'] >= 50, 'yes', 'no')

# E.g. 2 - Replace values over 20000 with 0, otherwise keep original value
df['my_value'] = np.where(df.my_value > 20000, 0, df.my_value)

Source: stackoverflow.com

Pandas replace values based on condition

df.loc[df['First Season'] > 1990, 'First Season'] = 1

Replace values in a column by condition python

df.loc[df['employrate'] > 70, 'employrate'] = 7

Source: stackoverflow.com

Similar codes

0 vote282 views1 answer
Get node name dynamo revit
Python
1 vote271 views1 answer
Jupyter notebook attach image
Python
1 vote284 views1 answer
How to give multiple option to the user and ask the same question again and again until the user tells one of the options
Python
15 votes284 views2 answers
Ansi colors
Python
0 vote283 views1 answer
Use of OfficeApi
Python
0 vote300 views1 answer
Bar chart with x-ticks
Python
5 votes275 views1 answer
Torch concat matrix
Python
0 vote301 views2 answers
Python convert array to linked list
Python
1 vote283 views1 answer
Python list all csv in dir
Python
4 votes238 views2 answers
How to drop a column in pandas
Python