Filtering Pandas Dataframe using OR statement

Question

I have a pandas dataframe and I want to filter the whole df based on the value of two columns in the data frame   I want to get back all rows and columns where IBRD or IMF    0     alldata balance   alldata  alldata IBRD    0  or  alldata IMF    0     but this gives me a ValueError     ValueError  The truth value of a Series is ambiguous  Use a empty    a bool          a item    a any   or a all      So I know I am not using the or statement correctly  is there a way to do this

User · Accepted Answer

From the docs      Another common operation is the use of boolean vectors to filter the   data  The operators are    for or   amp  for and  and   for not  These   must be grouped by using parentheses    http   pandas pydata org pandas-docs version 0 15 2 indexing html boolean-indexing  Try   alldata balance   alldata  alldata IBRD    0     alldata IMF    0

User · Answer

You can do like below to achieve your result   import seaborn as sns import matplotlib pyplot as plt import pandas as pd import numpy as np            use filter with plot  or fg sns factorplot  Retailer country   data df1  df1  Retailer country     United States      df1  Retailer country     France     kind  count    fg set xlabels  Retailer country   plt show      also  and fg sns factorplot  Retailer country   data df1  df1  Retailer country     United States    amp   df1  Year     2013     kind  count    fg set xlabels  Retailer country   plt show

[python] Filtering Pandas Dataframe using OR statement

Examples related to python

Examples related to pandas

Examples related to filter

Examples related to dataframe