/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

-1 vote195 views4 answers
How to loop over all dates in python
Python
0 vote223 views1 answer
Qpushbutton clicked
Python
2 votes245 views1 answer
Count the number of rows in a database table in Django
Python Django
21 votes175 views5 answers
Python download image from url
Python
2 votes217 views1 answer
Check corently installed epython version
Python
13 votes253 views3 answers
How to create tkinter window
Python
0 vote192 views1 answer
2checkout python
Python
0 vote192 views1 answer
How to find 2 similar words in atext python
Python
0 vote186 views1 answer
Old Handler API is deprecated - see https://git.io/fxJuV for details
Python
9 votes170 views1 answer
Mac upgrade python to 3.8
Python