Set value based on column

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

Set value based on column

df.loc[df['c1'] == 'Value', 'c2'] = 10

Rename rows pandas based on condiions

df.loc[(df.Event == 'Dance'),'Event']='Hip-Hop'
df

Source: kanoki.org

Similar codes

0 vote130 views1 answer
Django multiple search fields
Python
60 votes185 views6 answers
Python remove duplicates
Python
0 vote171 views1 answer
Setting urls
Python
0 vote152 views1 answer
Correlation between images python
Python
0 vote165 views1 answer
Sklearn model persistence
Python
0 vote173 views1 answer
Change each line color as a rainbow python
Python
0 vote183 views1 answer
Running code once in a while loop python
Python
0 vote163 views1 answer
Skcuda pip
Python
3 votes175 views1 answer
Python tkinter filedialog folder
Python
0 vote174 views1 answer
Numpy stack in new dimension
Python