/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 vote324 views1 answer
Pandas how to start read csv at a certain row
Python
37 votes355 views6 answers
Import beautifulsoup
Python
0 vote354 views1 answer
Sonido sfr200a
Python
15 votes341 views5 answers
Timer in python
Python
4 votes327 views1 answer
How to round the values in a list
Python
5 votes387 views1 answer
How to get all links from a website python beautifulsoup
Python
0 vote360 views1 answer
QuizListView login required django
Python
0 vote326 views1 answer
How to set default user group in django
Python
1 vote348 views1 answer
Delete turtle
Python
6 votes360 views6 answers
Install pip python 3.9
Python