/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

15 votes311 views6 answers
Python string
Python
0 vote273 views2 answers
Removing rows dataframe not in another dataframe using two columns
Python
15 votes272 views6 answers
Google translation
Python
0 vote278 views1 answer
Python create a grid of points
Python
1 vote295 views1 answer
How to save an image with the same name after editing in python pillow module
Python
1 vote268 views2 answers
Python winsound
Python
0 vote270 views1 answer
What is type
Python
0 vote278 views1 answer
Argmin returns one value for 2d array
Python
1 vote351 views1 answer
How to add captcha in django forms
Python Django
7 votes274 views3 answers
Dictionary from two columns pandas
Python