Create bool mask from filter results in Pandas [duplicate]

by

Your boolean masks are boolean (obviously) so you can use boolean operations on them. The boolean operators include (but are not limited to) &, | which can combine your masks based on either an ‘and’ operation or an ‘or’ operation. In your specific case, you need an ‘and’ operation. So you simply write your mask like so:

mask = (data['value2'] == 'A') & (data['value'] > 4)

This ensures you are selecting those rows for which both conditions are simultaneously satisfied. By replacing the & with |, one can select those rows for which either of the two conditions can be satisfied. You can select your result as usual:

data[mask]

Although this question is answered by the answer to the question that ayhan points out in his comment, I thought that the OP was lacking the idea of boolean operations.

More Related Contents:

  1. How to identify and label similar rows in a pandas data frame
  2. How do I read a large csv file with pandas?
  3. How can I use the apply() function for a single column?
  4. Pandas filtering for multiple substrings in series
  5. Python pandas insert list into a cell
  6. Pandas DataFrame Groupby two columns and get counts
  7. How can I display full (non-truncated) dataframe information in HTML when converting from Pandas dataframe to HTML?
  8. Pandas: conditional rolling count
  9. pandas: to_numeric for multiple columns
  10. group by pandas dataframe and select latest in each group
  11. Selection with .loc in python
  12. Access to table objects on Webpage Using Python Selenium
  13. How to flatten a hierarchical index in columns
  14. Add column to dataframe with constant value
  15. Check if string is in a pandas dataframe
  16. Most efficient way to sort an array into bins specified by an index array?
  17. Why is Apache-Spark – Python so slow locally as compared to pandas?
  18. splitting at underscore in python and storing the first value
  19. Background with range on seaborn based on two columns
  20. Add a sequential counter column on groups to a pandas dataframe
  21. Pandas: Shift down values by one row within a group
  22. Pandas max value index
  23. Opposite of melt in python pandas
  24. How to remove decimal points in pandas
  25. FutureWarning: The default value of regex will change from True to False in a future version
  26. Pretty print a pandas dataframe in VS Code
  27. Transpose the data in a column every nth rows in PANDAS
  28. Why doesn’t my pandas rolling().apply() work when the series contains collections?
  29. plotting value_counts() in seaborn barplot
  30. Convert a column of timestamps into periods in pandas

Leave a Comment