Answers for "replace values in dataframe based on condition"

9

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
Posted by: Guest on May-14-2020
1

pandas replace values based on condition

df.loc[df['First Season'] > 1990, 'First Season'] = 1
Posted by: Guest on May-23-2021
1

set value based on column

df.loc[df['c1'] == 'Value', 'c2'] = 10
Posted by: Guest on July-30-2020
1

replace values in a column by condition python

df.loc[df['employrate'] > 70, 'employrate'] = 7
Posted by: Guest on July-15-2020
0

pandas replace values from another dataframe

In [36]:
df['Group'] = df['Group'].map(df1.set_index('Group')['Hotel'])
df

Out[36]:
         Date  Group  Family  Bonus
0  2011-06-09  Jamel  Laavin    456
1  2011-07-09  Frank  Grendy    679
2  2011-09-10   Luxy  Fantol    431
3  2011-11-02  Frank  Gondow    569
Posted by: Guest on May-14-2021

Code answers related to "replace values in dataframe based on condition"

Python Answers by Framework

Browse Popular Code Answers by Language