/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 vote169 views2 answers
Pyttsx3 set volume
Python
0 vote160 views1 answer
Nlp.Defaults.stop_words.add spacy
Python
0 vote172 views1 answer
Sqlalchemy filter getattr
Python
8 votes169 views1 answer
Python ubuntu check if a key is pressed
Python
78 votes171 views6 answers
Python sort dict by value
Python
1 vote172 views1 answer
How to sort a list by the second element in tuple python
Python
1 vote178 views1 answer
How to generate random normal number in python
Python
0 vote197 views1 answer
Python on_mouse_down/collidepoint
Python
0 vote180 views1 answer
How to refer to all columns in pandas
Python
0 vote173 views1 answer
Loop append to list python
Python