/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

2 votes182 views1 answer
Add a list in python
Python
2 votes135 views2 answers
Pandas shift column up
Python
0 vote163 views1 answer
Can I convert python code to C++?
Python
0 vote178 views2 answers
Write a pseudo code for generating a fibonacci series starting with 0 and 1 for 10 values using while loop.
Python
0 vote168 views1 answer
Python largest common divisor
Python
0 vote170 views1 answer
Tree to tuple python
Python
1 vote215 views1 answer
Scatter plot of a dataframe in python
Python
0 vote257 views2 answers
Django models get all
Python Django
5 votes256 views1 answer
Python reverse linked list
Python
0 vote180 views1 answer
Multiple delimiters pandas
Python