python replace pandas df elements if they aren 27t in a list

Solutions on MaxInterview for python replace pandas df elements if they aren 27t in a list by the best coders in the world

Search
showing results for - "python replace pandas df elements if they aren 27t in a list"
Emilia
22 Jun 2016
1# Basic syntax:
2df.loc[~df['col_name'].isin(list_of_allowed_vals), "col_name"] = "None"
3
4# Example usage:
5# Build example dataframe:
6dataframe = pd.DataFrame(['ok','keep','wtf','ok'], columns=['col_name'])
7print(dataframe)
8  col_name
90       ok
101     keep
112      wtf
123       ok
13
14list_of_allowed_vals = ['ok', 'keep'] # Define list of elements to keep
15
16# Replace values that aren't the list of allowed values with "None":
17dataframe.loc[~dataframe['col_name'].isin(list_of_allowed_vals), "col_name"] = "None"
18print(dataframe)
19  col_name
200       ok
211     keep
222     None
233       ok
24
25# If you want to do this on all columns of the dataframe, run:
26dataframe[~dataframe.isin(list_of_allowed_vals)] = "None"
source
similar questions
pandas replace inf with 0pandas replace null values with values from another columnpandas dataframe replace infreplace value column by another if missing pandasreplace nan in pandas column with mode and printing itreplace nan in pandaspandas replace values from another dataframepandas replace nanreplace 22 22 for nan in dataframepandas unlist values and put in a rowpandas replace values based on conditionpandas replace string with another stringpandas replace colomns location replace pandas in for loophow to replace null values in pandaspandas replace substring in column namespandas replace nan with value abovepandas conditional replace values in a seriesreplace all nan values in dataframereplacing values in pandas dataframereplace cell pandaspandas replace data in specific columns with specific valuesrename rows pandas based on condiionsreplace values of pandas column
queries leading to this page
pandas add dataframe to the bottom of anotherstr replace in each column pandaspandas replacepandas replace with value if not in listreplace with 0 in pandaspandas replace by locationreplace dataframe items with listhow to replace value bench mark values in pandas dataframechange dataframe columns valuepandas replace isinreplace rows values with different values in pandashow to replace data in pandas data setpython replace pandas df elements if they aren 27t in a listhow to change data in pandas datasetreplace pandaschange values in column pandaspandas replace item in listreplace method pandaspandas iloc replace valuechange a value in a column and row in pandasreplace 25 in whole dataframepandas replace first five rowspd replace for a specific cellpython equivalent of pandas replacepandas replace column value with anotherreplace within list in dataframe pandaspandas df 5bkey 5d replace 28to replace 3dto replace lower 28 29 2c value 3dmain value lower 28 29 29python replace pandas df elements if they aren 27t in a list