/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

0 vote107 views1 answer
ModuleNotFoundError: No module named 'reportlab'
Python
0 vote104 views1 answer
Convert fisheye video to normal python
Python
1 vote91 views1 answer
How to get input from user in pyqt5
Python
1 vote102 views2 answers
Python error get line
Python
0 vote109 views1 answer
Pandas select only columns with na
Python
1 vote111 views2 answers
Python rgb colors
Python
2 votes101 views2 answers
Binary to text python
Python
0 vote105 views1 answer
Python global variable unboundlocalerror
Python
1 vote90 views1 answer
Django gunicorn static file not found
Python
0 vote104 views1 answer
Tkinter responsive gui
Python