Efficiently select rows that match one of several values in Pandas DataFrame [duplicate]

by

You can use the isin Series method:

In [11]: df['Name'].isin(['Alice', 'Bob'])
Out[11]: 
0     True
1     True
2    False
3     True
4    False
Name: Name, dtype: bool

In [12]: df[df.Name.isin(['Alice', 'Bob'])]
Out[12]: 
    Name  Amount
0  Alice     100
1    Bob      50
3  Alice      30

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Why does concatenation of DataFrames get exponentially slower?
  5. Combine Date and Time columns using python pandas
  6. Pandas: How to easily share a sample dataframe using df.to_dict()?
  7. Pandas/Python: Set value of one column based on value in another column
  8. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  9. Pandas Timedelta in Days
  10. how to get ticks every hour?
  11. How to add value labels on a bar chart
  12. How to remove blanks/NA’s from dataframe and shift the values up
  13. Why does my Pandas DataFrame not display new order using `sort_values`?
  14. Difference(s) between merge() and concat() in pandas
  15. How can I see the formulas of an excel spreadsheet in pandas / python?
  16. Count distinct words from a Pandas Data Frame
  17. subsetting a Python DataFrame
  18. How to use Pandas stylers for coloring an entire row based on a given column?
  19. How to define format when using pandas to_datetime?
  20. python pandas groupby() result
  21. How to implode(reverse of pandas explode) based on a column
  22. How do I create a sum row and sum column in pandas?
  23. Python pandas cumsum() reset after hitting max
  24. How do I fill a column with one value in Pandas?
  25. Filtering pandas dataframe rows by contains str
  26. how to parallelize many (fuzzy) string comparisons using apply in Pandas?
  27. Pandas analogue to SQL MINUS / EXCEPT operator, using multiple columns
  28. plot different color for different categorical levels
  29. Pandas Groupby Agg Function Does Not Reduce
  30. Pandas groupby and make set of items

Leave a Comment