title: verification existence of an row from a sheet in another one using python
body: <p>hello everyone i just want ask if anyone has an idea how i can check if row exist from one sheet in other one and if not it will highlight the row i found the issue with verfication line by line i try this code</p>
  <p><a href="https://i.stack.imgur.com/KYfU1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KYfU1.png" alt="enter image description here" /></a></p>
  <pre><code>old = old.set_index('id')
  new = new.set_index('id')
  resultTest = pd.concat([old,new],sort=False)
  result = resultTest.stack().groupby(level=[0,1]).unique().unstack(1).copy()
  result.loc[~result.index.isin(new.index),'status'] = 'deleted' # is not new old 
  result.loc[~result.index.isin(old.index),'status'] = 'added'     # is not old new
  idx = resultTest.stack().groupby(level=[0,1]).nunique() # cell changed  
  result.loc[idx.mask(idx &lt;= 1).dropna().index.get_level_values(0),'status'] = 'modified'
  result['status'] = result['status'].fillna('same')
  result[result[&quot;status&quot;] == 'deleted'].style.apply(highlight_max)
  </code></pre>