'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 |
