/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 vote143 views1 answer
Change each line color as a rainbow python
Python
7 votes179 views2 answers
Cv2 load image
Python
0 vote177 views1 answer
Import numpy as np import matplotlib.pyplot as plt index = 0 missClassifiedIndexes = [] for label, predit in zip(y_test, predictions): if label != predict: missClassifiedIndexes.append(index) index = +1
Python
1 vote150 views1 answer
Each line in a text file into a list in Python
Python
0 vote161 views1 answer
Rotate image pyqt5
Python
0 vote145 views1 answer
How to search a file in windows 10 using python
Python
0 vote128 views1 answer
Link_to class
Python
1 vote143 views1 answer
Mongodb python get all documents
Python
3 votes138 views2 answers
Discord.py make command admin only
Python
0 vote180 views1 answer
Django raw without sql injection
Python Django