dateframe

删除列值相同的两行

data = {'DataBase':['mysql','student','test','test','test'],'table':['user','student','course','sc','book']}
df = pd.DataFrame(data)
df.drop(df.loc[(df['table']==df['DataBase'])].index,inplace=True)
print(df)

　　

  DataBase    table
0    mysql     user
1  student  student
2     test   course
3     test       sc
4     test     book
  DataBase   table
0    mysql    user
2     test  course
3     test      sc
4     test    book