/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 vote336 views2 answers
How to add list as new row to pandas dataframe
Python
1 vote338 views1 answer
Displays unique data including null data
Python
0 vote360 views1 answer
Quicksort in Python site:stackoverflow.com
Python
-2 votes325 views1 answer
No connection could be made because the target machine actively refused it python
Python
1 vote304 views1 answer
Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaple
Python
29 votes338 views4 answers
Basic flask app python
Python
0 vote312 views1 answer
Df count zeros
Python
0 vote315 views1 answer
Fibonacci 10th
Python
0 vote257 views1 answer
Width and precision thousand separetor python
Python
0 vote332 views1 answer
Python first two numbers
Python