/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 vote167 views1 answer
Code suggestion html not working in django-html
Python Django
0 vote145 views2 answers
C to python converter
Python
6 votes152 views2 answers
Decimal in python
Python
0 vote158 views1 answer
AttributeError: Can't get attribute '' on <module '__main__'> pickle
Python
2 votes144 views2 answers
Convert np shape (a,) to (a,1)
Python
0 vote144 views1 answer
End of statement expected python
Python
36 votes139 views6 answers
Remove part of string python
Python
-2 votes159 views1 answer
Start django project in windows
Python
0 vote187 views1 answer
Ip address finder script python
Python
0 vote188 views2 answers
Count items in a model django rest
Python Django