/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

9 votes174 views2 answers
Python get image dimensions
Python
0 vote162 views1 answer
Print choicefield data from database in django
Python
12 votes169 views2 answers
Convert torch to numpy
Python
0 vote173 views1 answer
Python count lines in string
Python
2 votes197 views2 answers
Np logical not
Python
0 vote166 views1 answer
Pycaw , Python Audio Control Lib
Python
-2 votes177 views1 answer
Center buttons tkinter
Python
4 votes174 views1 answer
Python int binary
Python
0 vote174 views1 answer
Create empty csv file in python
Python
2 votes168 views1 answer
How to call super class constructor in python two classes
Python