/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 vote333 views1 answer
Query first 5 element in django
Python Django
145 votes316 views5 answers
Create file python
Python
2 votes289 views4 answers
Urllib.request.urlretrieve
Python
1 vote295 views2 answers
Python alphabetical order
Python
1 vote310 views1 answer
Keras import optimizer adam
Python
0 vote288 views1 answer
Get return value of contract call in brownie
Python
0 vote334 views1 answer
Python send image in post request with json data
Python
0 vote314 views1 answer
Select values for row matching condition
Python
0 vote280 views1 answer
Origin in CORS_ORIGIN_WHITELIST is missing scheme or netloc
Python
0 vote294 views1 answer
Gdscript tween
Python