Python pandas – new column’s value if the item is in the list

by

Use isin for check membership:

df1["EU"] = np.where(df1["Country"].isin(EU), "EU", "Other")
print (df1)
      Capital  Country     EU
0  Washington      USA  Other
1      Berlin  Germany     EU
2      Moscow   Russia  Other
3      Warsaw   Poland     EU

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Converting between datetime, Timestamp and datetime64
  3. What is the difference between size and count in pandas?
  4. Fast Haversine Approximation (Python/Pandas)
  5. Pandas Timedelta in Days
  6. Conditionally fill column values based on another columns value in pandas
  7. Calculate weighted average using a pandas/dataframe
  8. How to remove blanks/NA’s from dataframe and shift the values up
  9. Comparing previous row values in Pandas DataFrame
  10. selecting across multiple columns with python pandas?
  11. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  12. Populate a Pandas SparseDataFrame from a SciPy Sparse Matrix
  13. Using numpy.genfromtxt to read a csv file with strings containing commas
  14. Counting unique values in a column in pandas dataframe like in Qlik?
  15. vectorize conditional assignment in pandas dataframe
  16. Create new dataframe in pandas with dynamic names also add new column
  17. How can I count the number of consecutive TRUEs in a DataFrame?
  18. Binning a column with pandas
  19. Convert numpy type to python
  20. Pandas Latitude-Longitude to distance between successive rows [duplicate]
  21. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  22. How to implode(reverse of pandas explode) based on a column
  23. Numpy isnan() fails on an array of floats (from pandas dataframe apply)
  24. Different std in pandas vs numpy
  25. Getting days since last occurence in Pandas DataFrame?
  26. Split Python sequence (time series/array) into subsequences with overlap
  27. Faster way to transform group with mean value in Pandas
  28. Add density curve on the histogram
  29. Bin values based on ranges with pandas [duplicate]
  30. Numpy.dtype has the wrong size, try recompiling

Leave a Comment