/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

8 votes145 views4 answers
How to reverse a dictionary in python
Python
0 vote145 views1 answer
Python library automatic sort
Python
0 vote146 views1 answer
Python keyboard monitoring
Python
0 vote156 views1 answer
Python webdriver disable logs
Python
0 vote101 views1 answer
Scrapy csv output
Python
5 votes145 views1 answer
How to round to 2 decimals with Python?
Python
13 votes149 views6 answers
Range in python
Python
1 vote165 views1 answer
Display cv2 image in jupyter notebook
Python
24 votes144 views2 answers
Make an executable with visual studio python
Python
6 votes165 views1 answer
Load images pygame
Python