/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 vote130 views1 answer
List comprehension odd numbers python
Python
0 vote133 views1 answer
Knn example
Python
0 vote140 views1 answer
Run multiple function with multiprocessing python
Python
0 vote146 views1 answer
Spotify recommendations
Python
0 vote133 views1 answer
Argparse python sentence
Python
3 votes124 views2 answers
Multiple Regression in Python
Python
0 vote85 views1 answer
Left rotation in list
Python
0 vote118 views1 answer
User registration
Python
3 votes117 views4 answers
Django setup in windows
Python
0 vote127 views1 answer
To install a specific version, type the package name followed by the required version:
Python