/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 vote96 views1 answer
Set application taskbar icon
Python
0 vote106 views2 answers
Draw bipartite graph networkx
Python
0 vote104 views2 answers
Split column in exact spot python
Python
0 vote110 views1 answer
Spyder new instance
Python
0 vote137 views1 answer
Selenium python tkinter
Python
2 votes101 views1 answer
Python apply a function to a list inplace
Python
0 vote131 views1 answer
Server error 500 heroku django
Python Django
0 vote106 views1 answer
Djanog userformcreation message
Python
1 vote191 views1 answer
Flask clear session
Python Flask
0 vote68 views1 answer
Loop through words in a string python
Python