/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

11 votes180 views3 answers
Pandas count values by column
Python
0 vote206 views1 answer
HumanName python
Python
0 vote167 views1 answer
Https://raw.githubusercontent.com/tim-yao/lighthouse-ci/d32f465bb6cda08ded4ce25c88c43a3103e4940a/.browserslistrc
Python
0 vote180 views1 answer
Print start time in python
Python
0 vote171 views1 answer
Python - exchange rate API
Python
8 votes275 views3 answers
Python split range into n groups
Python
1 vote177 views1 answer
Py exe tkinter
Python
0 vote172 views1 answer
Micropython free space esp32 esp2866
Python
9 votes172 views3 answers
How to make a random variable in python
Python
1 vote184 views1 answer
Seaborn plot set ylabel
Python