Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?

by

method 1 

sample.housing.eq('yes').mul(1)

method 2 

pd.Series(np.where(sample.housing.values == 'yes', 1, 0),
          sample.index)

method 3 

sample.housing.map(dict(yes=1, no=0))

method 4 

pd.Series(map(lambda x: dict(yes=1, no=0)[x],
              sample.housing.values.tolist()), sample.index)

method 5 

pd.Series(np.searchsorted(['no', 'yes'], sample.housing.values), sample.index)

All yield

0    0
1    0
2    1
3    0
4    0
5    0
6    0
7    0
8    1
9    1

timing
given sample

enter image description here

timing
long sample
sample = pd.DataFrame(dict(housing=np.random.choice(('yes', 'no'), size=100000)))

enter image description here

More Related Contents:

  1. error when applying function to a series object
  2. How to convert index of a pandas dataframe into a column
  3. Pandas filtering for multiple substrings in series
  4. df.append() is not appending to the DataFrame
  5. Combining two Series into a DataFrame in pandas
  6. Convert pandas Series to DataFrame
  7. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  8. how do I calculate a rolling idxmax
  9. Remove name, dtype from pandas output of dataframe or series
  10. Convert pandas data frame to series
  11. What is the fastest and most efficient way to append rows to a DataFrame?
  12. Compute the running (cumulative) maximum for a series in pandas
  13. Using replace efficiently in pandas
  14. Python Pandas iterate over rows and access column names
  15. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  16. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x
  17. How to deal with SettingWithCopyWarning in Pandas
  18. Pandas split column into multiple columns by comma
  19. How to deal with multi-level column names downloaded with yfinance
  20. Replace all occurrences of a string in a pandas dataframe (Python)
  21. Running get_dummies on several DataFrame columns?
  22. Python – How to convert JSON File to Dataframe
  23. replace column values in one dataframe by values of another dataframe
  24. Pandas expand rows from list data available in column
  25. Selecting/excluding sets of columns in pandas [duplicate]
  26. Reverse a get_dummies encoding in pandas
  27. pandas divide row value by aggregated sum with a condition set by other cell
  28. Updating a value in a pandas dataframe in an iterrows loop
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path

Leave a Comment