/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 vote296 views1 answer
Reate the "soup." This is a beautiful soup object:
Python
0 vote349 views1 answer
Np.all
Python
0 vote343 views1 answer
Pandas interpolate string
Python
1 vote303 views1 answer
Python get latest edited file from any directory
Python
0 vote343 views1 answer
Python access class variable by string
Python
0 vote345 views1 answer
Django app directory
Python Django
0 vote352 views2 answers
Matplotlib-Object oriented interface
Python
3 votes336 views1 answer
Python nested functions get variables from function scope
Python
0 vote275 views12 answers
Installez django-cruds-adminlte
Python Django
0 vote325 views1 answer
Como fazer print no python
Python