how to replace variables in a column [duplicate]

Question

i wanted to to replace the yes and no values in No-show column to be changed to 0 and 1 valuesenter image description here

Hi, perhaps use DataFrame.replace pandas.pydata.org/pandas-docs/stable/reference/api/… — IronMan
– IronMan, Commented Oct 8, 2020 at 22:54
Does this answer your question? Replacing column values in a pandas DataFrame — Anurag Reddy
– Anurag Reddy, Commented Oct 8, 2020 at 23:25

MECoskun · Accepted Answer · 2020-10-08 23:02:08Z

1

Here is a simple answer:

df = pd.DataFrame({'No-show':['Yes','No','No','Yes']})
df['No-show'] = df['No-show'].replace('Yes',1).replace('No',0)
df

output:

answered Oct 8, 2020 at 23:02

MECoskun

9098 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Series.replace also accepts a dictionary so you don't need to call it twice: df['No-show'] = df['No-show'].replace({"Yes": 1, "No": 0})