Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

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
Comment

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)
Comment

pandas replace values based on condition

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

replace pandas column values based on condition

d.loc[d["conditionDisplayName"] == "Brand New", "conditionDisplayName"] = 6
d.loc[d["conditionDisplayName"] != "Brand New", "conditionDisplayName"] = 4
Comment
PREVIOUS NEXT
Code Example
Python :: python convert remove spaces from beginning of string 
Python :: python moving average time series 
Python :: how to remove empty elements in a list python 
Python :: pandas filter on range of values 
Python :: how to get a row from a dataframe in python 
Python :: pandas replace column name from a dictionary 
Python :: convert number to binary in python 
Python :: how to increment date by one in python 
Python :: django is null 
Python :: python - make a copy of a df 
Python :: how to launch an application using python 
Python :: how to draw shape square in python turtle 
Python :: python get angle between two points 
Python :: pandas replace space with underscore in column names 
Python :: adding a pandas column with multiple conditions 
Python :: python program to display the current date and time 
Python :: select all columns except one pandas 
Python :: username nextcord interactions 
Python :: how to format integer to two digit in python 
Python :: python telegram bot send image 
Python :: docs.python.org 
Python :: pytohn epsilon 
Python :: discord.py get profile picture 
Python :: python- find multiple values in a column 
Python :: pandas print all columns 
Python :: find a file in python 
Python :: python convert string to date 
Python :: compute eigenvalue python 
Python :: while not equal python 
Python :: how to encrypt a string python 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =