/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 vote349 views1 answer
Cv2 reverse contrast
Python
0 vote350 views1 answer
Flask decoding base 64 image
Python
0 vote379 views1 answer
One small letter three big bodyguard
Python
9 votes345 views1 answer
Delete object from table django
Python Django
0 vote326 views1 answer
Django blog new post
Python
4 votes380 views2 answers
Python find the factors of a number
Python
0 vote362 views1 answer
Print the multiple data types in a single program in list data structures
Python
1 vote343 views10 answers
Recursion
Python
11 votes364 views6 answers
Drop null rows pandas
Python
0 vote328 views1 answer
Installing intelpython3_core using anaconda
Python