Skip to content
Advertisement

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

Advertisement

Answer

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
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement