/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

9 votes231 views6 answers
Jupyter notebook dark theme
Python
1 vote143 views1 answer
Python .nlargest
Python
0 vote131 views1 answer
Python readlines end of file
Python
0 vote136 views2 answers
C to python converter
Python
0 vote138 views1 answer
Load training data python from coco
Python
1 vote139 views1 answer
Create a generator from a list
Python
0 vote138 views1 answer
Blender python get current filename
Python
2 votes172 views2 answers
Print labels on confusion_matrix
Python
1 vote141 views1 answer
Removing features pandas
Python
2 votes130 views1 answer
When did guido van rossum create python
Python