/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

4 votes112 views2 answers
Django template for range
Python
0 vote114 views3 answers
Python with quick sort
Python
0 vote110 views1 answer
Getting vocab from a text file python
Python
0 vote109 views1 answer
How to add to end of linked list python
Python
7 votes137 views4 answers
How to get all the keys of a dictionary in python
Python
21 votes112 views6 answers
Remove columns from dataframe
Python
0 vote146 views1 answer
Tcs question
Python
0 vote130 views1 answer
Tick size colorbar python
Python
1 vote111 views1 answer
Python ndarray string array into int
Python
0 vote118 views1 answer
Django insert data into database foreign key view.py
Python