I have a dataframe like this :
| origin | destination |
|---|---|
| germany | germany |
| germany | italy |
| germany | spain |
| USA | USA |
| USA | spain |
| Argentina | Argentina |
| Argentina | Brazil |
and I want to filter the routes that are within the same country, that is, I want to obtain the following dataframe :
| origin | destination |
|---|---|
| germany | italy |
| germany | spain |
| USA | spain |
| Argentina | Brazil |
How can i do this with pandas ? I have tried deleting duplicates but it does not give me the results I want
Advertisement
Answer
Use a simple filter:
df = df[df['origin'] != df['destination']]
Output:
>>> df
origin destination
1 germany italy
2 germany spain
4 USA spain
6 Argentina Brazil