/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 vote327 views4 answers
Pip django graphql
Python Django
-2 votes310 views1 answer
Whole loop in python
Python
0 vote362 views1 answer
How to install pandas for aws sam local
Python
0 vote294 views1 answer
Hebrew range
Python
14 votes417 views3 answers
ModuleNotFoundError: No module named 'pandas_profiling'
Python
0 vote353 views1 answer
Python mongodb connection
Python
1 vote300 views1 answer
Les librairies python a maitriser pour faire du machine learning
Python
71 votes338 views4 answers
Saving a pandas dataframe as a csv
Python
3 votes322 views1 answer
Python insert image
Python
2 votes335 views1 answer
How to create a loop in python turtle
Python