/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

75 votes271 views2 answers
Python write to file while reading
Python
4 votes310 views4 answers
Get file parent directory python
Python
14 votes312 views3 answers
Discord.py find user by name
Python
0 vote282 views1 answer
Use in in django while preserving order
Python
0 vote301 views1 answer
Autopy in python install
Python
2 votes278 views2 answers
Python program to print list vertically without using loop
Python
16 votes269 views3 answers
Python chunks
Python
1 vote281 views1 answer
How to urllib3
Python
1 vote233 views1 answer
Set window size with sizers wxpython
Python
0 vote265 views1 answer
How to format a matrix to align all rows python
Python