/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

6 votes166 views6 answers
Def python
Python
0 vote145 views1 answer
Standard streams with python3
Python
0 vote171 views1 answer
Python flatten one liner
Python
0 vote156 views1 answer
Heroku python heroku port issue
Python
0 vote162 views1 answer
2 distinct numbers random number generator python
Python
0 vote163 views1 answer
Cosh python
Python
1 vote184 views1 answer
Swap rows and columns pandas
Python
0 vote173 views2 answers
Unable to import wx
Python
0 vote174 views1 answer
Exponent function in python
Python
0 vote172 views1 answer
Are angles of a parallelogram equal?
Python