/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

0 vote219 views2 answers
Remove repetitive characters from the specified column of a given DataFrame
Python
1 vote235 views1 answer
Scikit learn ridge regression
Python
1 vote221 views2 answers
Django queryset unique values
Python
2 votes242 views1 answer
Django and react url conflict
Python Django
3 votes233 views2 answers
Django timezone india
Python
1 vote214 views1 answer
Django httpresponseredirect
Python
3 votes228 views2 answers
Who invented python
Python
0 vote230 views1 answer
Python concatenate tuple to string
Python
1 vote232 views1 answer
Addition/subtraction of integers and integer-arrays with DatetimeArray is no longer supported
Python
0 vote218 views1 answer
Np.loadtext
Python