/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

8 votes299 views6 answers
Python int to binary
Python
1 vote335 views1 answer
Flask form errors
Python Flask
15 votes309 views3 answers
Python random text generator
Python
2 votes312 views3 answers
Insert row at given position in pandas dataframe
Python
0 vote290 views1 answer
Micropython string to int
Python
2 votes305 views1 answer
Armstrong number python
Python
0 vote309 views1 answer
How to let something see on screen with python
Python
0 vote314 views2 answers
Convert outlook email to text file python
Python
0 vote288 views1 answer
Only split from third delimiter python
Python
0 vote331 views1 answer
Chi square test contingency table python
Python