Filter dataframe based on 2 columns

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

>Solution :

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

Leave a Reply