/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

6 votes278 views1 answer
Python sort
Python
9 votes285 views1 answer
Cannot acess stylesheets in static files
Python
-1 vote314 views2 answers
How to url encode using python django
Python Django
73 votes299 views6 answers
Reverse a string in python
Python
1 vote258 views1 answer
Replace all spacec column with underscore in pandas
Python
6 votes259 views3 answers
Python get dictionary keys
Python
0 vote275 views1 answer
Matplotlib x tlabels ax.set_xlabel
Python
1 vote244 views1 answer
Numpy take out elements equal to zero
Python
0 vote294 views1 answer
How to convert a matrix string back to a matrix python
Python
0 vote259 views1 answer
Choose a random snippet of text
Python