/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 vote134 views2 answers
Python: calculate number of days from today date in a data frame
Python
3 votes127 views3 answers
Python program to count vowels in a string
Python
1 vote74 views2 answers
Python list iterator
Python
0 vote134 views1 answer
Python Tkinter timer animation
Python
80 votes123 views6 answers
How to find python version
Python
0 vote117 views1 answer
Youtube upload python
Python
1 vote113 views1 answer
How to delete role discord py rewrite
Python
0 vote120 views1 answer
True Positive, True Negative, False Positive, False Negative in scikit learn
Python
10 votes130 views4 answers
How to know if python is 64 or 32 bit
Python
1 vote115 views1 answer
Pygame how to get surface lenght
Python