Home > OS >  Filter dataframe based on 2 columns
Filter dataframe based on 2 columns

Time:03-31

I have a big dataframe

city Flow
Berlin False
Berlin True
Vienna False
Vienna True
Vienna False
Frankfurt True
Frankfurt False

I want to remove only the rows where city and flow is Vienna and false using python

Resulting dataframe should be

city Flow
Berlin False
Berlin True
Vienna True
Frankfurt True
Frankfurt False

CodePudding user response:

Try:

>>> df[df["city"].ne("Vienna")|df["Flow"]]
        city   Flow
0     Berlin  False
1     Berlin   True
3     Vienna   True
5  Frankfurt   True
6  Frankfurt  False
  • Related