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:
JavaScript
x
8
1
>>> df[df["city"].ne("Vienna")|df["Flow"]]
2
city Flow
3
0 Berlin False
4
1 Berlin True
5
3 Vienna True
6
5 Frankfurt True
7
6 Frankfurt False
8