/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 vote212 views1 answer
Vscode python workding directory
Python
6 votes169 views1 answer
Business logic in django
Python
4 votes282 views2 answers
Python print time difference
Python
4 votes208 views1 answer
Google colab how to upload a folder
Python
0 vote201 views2 answers
Python decimal remove trailing zero
Python
0 vote193 views1 answer
Check strict superset hackerrank solution
Python
1 vote194 views1 answer
Tkinter new line in text
Python
4 votes191 views2 answers
Django how to delete a db field
Python
0 vote231 views1 answer
Mechanize python XE #25
Python
0 vote201 views1 answer
Legend text color matplotlib
Python