Element-wise logical OR in Pandas

by

The corresponding operator is |:

 df[(df < 3) | (df == 5)]

would elementwise check if value is less than 3 or equal to 5.

If you need a function to do this, we have np.logical_or. For two conditions, you can use

df[np.logical_or(df<3, df==5)]

Or, for multiple conditions use the logical_or.reduce,

df[np.logical_or.reduce([df<3, df==5])]

Since the conditions are specified as individual arguments, parentheses grouping is not needed.

More information on logical operations with pandas can be found here.

More Related Contents:

  1. pandas: multiple conditions while indexing data frame – unexpected behavior
  2. How can I obtain the element-wise logical NOT of a pandas Series?
  3. Pandas conditional creation of a series/dataframe column
  4. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  5. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  6. Get the row(s) which have the max value in groups using groupby
  7. Remove unwanted parts from strings in a column
  8. Combine Date and Time columns using python pandas
  9. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  10. Pandas Timedelta in Days
  11. how to get ticks every hour?
  12. How to add value labels on a bar chart
  13. How to remove blanks/NA’s from dataframe and shift the values up
  14. Why does my Pandas DataFrame not display new order using `sort_values`?
  15. python/pandas: convert month int to month name
  16. How to check if a column exists in Pandas
  17. Difference(s) between merge() and concat() in pandas
  18. Seaborn showing scientific notation in heatmap for 3-digit numbers
  19. Format certain floating dataframe columns into percentage in pandas
  20. How can I see the formulas of an excel spreadsheet in pandas / python?
  21. How to show a bar and line graph on the same plot
  22. “Series objects are mutable and cannot be hashed” error
  23. pandas: combine two columns in a DataFrame
  24. Pandas query function not working with spaces in column names
  25. better way to drop nan rows in pandas
  26. How do I create a sum row and sum column in pandas?
  27. How do “and” and “or” work when combined in one statement? [duplicate]
  28. Python pandas cumsum() reset after hitting max
  29. Remove NaN values from pandas dataframe and reshape table [duplicate]
  30. bash: Python import – Command not found for pandas

Leave a Comment