/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 vote194 views1 answer
Odoo 12 compute documentation
Python
5 votes221 views2 answers
Django password field
Python Django
3 votes197 views6 answers
2+2
Python
0 vote224 views1 answer
Remove all integers from list python
Python
5 votes195 views2 answers
Convert response to json python
Python
2 votes221 views1 answer
Argparse example python pyimagesearch
Python
0 vote186 views1 answer
Add key if not exists python
Python
3 votes215 views3 answers
Pygame python3.8
Python
0 vote188 views1 answer
How to take long input in python
Python
0 vote200 views1 answer
Convert from R to python
Python