/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 vote365 views1 answer
Plt.tick_params
Python
0 vote342 views1 answer
Python program to read a random line from a file.
Python
3 votes327 views1 answer
Delete a key value pair from a dictionary in python
Python
1 vote356 views2 answers
Delete the content from the entry form in tkinter python
Python
0 vote341 views1 answer
How to count a consecutive series of positive or negative values in a column in python
Python
4 votes350 views2 answers
List to json python
Python
0 vote369 views1 answer
Qmenubar pyqt
Python
0 vote349 views1 answer
Squre value of a column pandas
Python
0 vote399 views1 answer
Change marker border color plotly
Python
0 vote402 views1 answer
Get admin url of instance django
Python Django