Leto
Reputation: 39
How to check if value is in another column
I have this dataFrame:
How can I filter column G, to exclude rows that the value is in column C? The result should look like this:
Upvotes: -2
Views: 55
Answers (2)
Celius Stingher
Reputation: 18367
You can use a mask in this case:
df_filtered = df[~df['G'].isin(df['C'])]
Upvotes: 2
Anna Semjén
Reputation: 787
Try df.loc with isin + ~ which negates it
df.loc[~df['G'].isin(df['C'].unique())]
Upvotes: 3
Related Questions
- How do I check if a value in column is present in other column in Python?
- find if the value in pandas column is in another column's list
- Check if string is in another column pandas
- pandas: how to check if a column value is in other columns in the same row
- Check if one column value is in another column and create column to indicate in Pandas
- Find if a value in a columns is in another column
- Check if Pandas column contains value from another column
- Check if one column value is in another column in pandas
- How to determine if elements of a column is in another column?
- Check if column value is in other columns in pandas