How to update/create column in pandas based on values in a list

by

You need numpy.where with condition with isin:

x['Continent'] = np.where(x['Country'].isin(europe), 'Europe', 'Not Europe')
print (x)
     Name Country  Income   Continent
0   Steve     USA   40000  Not Europe
1    Matt      UK   40000      Europe
2    John     USA   40000  Not Europe
3  Martin  France   40000      Europe

More Related Contents:

  1. How to write this code without using pandas?
  2. How to plot in multiple subplots
  3. Faster way to read Excel files to pandas dataframe
  4. How to reversibly store and load a Pandas dataframe to/from disk
  5. Format y axis as percent
  6. float64 with pandas to_csv
  7. How do I transpose dataframe in pandas without index?
  8. How to select all columns whose names start with X in a pandas DataFrame
  9. How to import a text file on AWS S3 into pandas without writing to disk
  10. Append column to pandas dataframe
  11. How do I round datetime column to nearest quarter hour
  12. How to plot and annotate grouped bars in seaborn / matplotlib
  13. Print the raw value of a column alone, in pandas?
  14. Pandas merge two dataframes with different columns
  15. Pandas filter dataframe rows with a specific year
  16. Divide multiple columns by another column in pandas
  17. Access index in pandas.Series.apply
  18. Python Pandas to_sql, how to create a table with a primary key?
  19. Pandas “Group By” Query on Large Data in HDFStore?
  20. Apply function to each cell in DataFrame
  21. Export Pandas DataFrame into a PDF file using Python
  22. Best way to join two large datasets in Pandas
  23. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  24. pandas – Merge nearly duplicate rows based on column value
  25. Pivot Tables or Group By for Pandas?
  26. Giving a column multiple indexes/headers
  27. Using regex matched groups in pandas dataframe replace function
  28. converting list of header and row lists into pandas DataFrame
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. How to get number of groups in a groupby object in pandas?

Leave a Comment