/Python/Remove df rows if two column values are not matching

Remove df rows if two column values are not matching

Remove row if all are the same value pandas

print (df['S'] != df['T'])
0    False
1     True
2     True
3     True
4    False
5     True
6     True
7     True
8    False
dtype: bool

df = df[df['S'] != df['T']]
print (df)
   S  T  W           U
1  A  B  0  Undirected
2  A  C  1  Undirected
3  B  A  0  Undirected
5  B  C  1  Undirected
6  C  A  1  Undirected
7  C  B  1  Undirected

Source: stackoverflow.com

Remove df rows if two column values are not matching

    import pandas as pd
    #creating temp df for example 

    details = {
        'Name' : ['Ankit', 'Aishwarya', 'Shaurya', 'Shivangi', 'Priya', 'Swapnil'],
        'Nick_Name' : ['Ankit', 'Aish', 'Shaurya', 'Shiv', 'Priya', 'Lucky'],
    }
      
    # creating a Dataframe object 
    df = pd.DataFrame(details, columns = ['Name', 'Nick_Name',],index = ['a', 'b', 'c', 'd', 'e', 'f'])
      
    
    index_names = df[ (df['Name'] == df['Nick_Name'])].index
    
    df.drop(index_names, inplace = True)
    print(df)

Similar codes

2 votes139 views1 answer
Python check tuple length
Python
0 vote124 views1 answer
Gevent with flask
Python
0 vote142 views1 answer
Np where pandas with 3 choices
Python
10 votes142 views6 answers
Variable in python
Python
0 vote178 views1 answer
Python generalised eigenvalue problem
Python
1 vote130 views1 answer
Python how to set the axis ranges in seaborn
Python
0 vote153 views1 answer
All default datasets in seaborn
Python
0 vote136 views1 answer
PY | websocket - client
Python
0 vote188 views1 answer
How to check how many key value pairs are in a dict python
Python
0 vote156 views1 answer
Store user input in list
Python