'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 1:[1]

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 not_speshal