/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

1 vote327 views1 answer
ModuleNotFoundError: No module named 'lmdb'
Python
0 vote244 views1 answer
Drop colums whoose value are object type in python
Python
2 votes234 views2 answers
How to find a word in a string python
Python
3 votes245 views4 answers
How to Copy a File in Python?
Python
4 votes249 views3 answers
** in python
Python
0 vote228 views1 answer
Feature scaling in python
Python
29 votes253 views4 answers
Basic flask app python
Python
0 vote267 views1 answer
Return the key-value pairs in this RDD to the master as a dictionary.
Python
0 vote259 views1 answer
How to check if a cell is empty in openpyxl
Python
8 votes235 views3 answers
F.readlines python
Python