Filter dataframe based on 2 columns

Question

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

Does this answer your question? [how do you filter pandas dataframes by multiple columns](https://stackoverflow.com/questions/22086116/how-do-you-filter-pandas-dataframes-by-multiple-columns) — BigBen, Mar 31 '22 at 14:19

score 1 · Accepted Answer · answered Mar 31 '22 at 14:20

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

answered Mar 31 '22 at 14:20

not_speshal

22,093
2
15
30

Do you know how to perform this filter if flow was not a boolean – Datalearner Mar 31 '22 at 14:26
`df[df["city"].ne("Vienna")|df["Flow"].ne("False")]` – not_speshal Mar 31 '22 at 14:26

Filter dataframe based on 2 columns

1 Answers1