/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

0 vote169 views1 answer
Pandas corr get couple value
Python
0 vote123 views1 answer
Logout redirect url
Python
8 votes180 views4 answers
Count unique values numpy
Python
0 vote184 views1 answer
Pandas perform action on column
Python
0 vote154 views1 answer
Name 'q' is not defined in jupyter notebook
Python
16 votes186 views1 answer
Python reload file if changed
Python
0 vote154 views1 answer
Scatter plot points density color pandas
Python
0 vote157 views1 answer
Setting flask app environment variable
Python
0 vote167 views1 answer
Numpy roll
Python
0 vote165 views2 answers
Beautiful soup get specific class
Python