/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

68 votes206 views6 answers
Python open file
Python
1 vote216 views1 answer
Dont filter= true in scrapy
Python
0 vote218 views1 answer
13 pseudo random numbers between 0 to 3 python
Python
0 vote212 views2 answers
Javascript python
Python
2 votes210 views1 answer
Superscript print python
Python
2 votes170 views1 answer
How to turn list into dataframe inr
Python
1 vote206 views2 answers
Discord py get all channels in guild
Python
0 vote254 views1 answer
How to get a mock image in django?
Python Django
0 vote215 views1 answer
Pip install contractions
Python
1 vote200 views1 answer
Do you have to qualift for mosp twice?
Python