title: Pandas Merge DataFrames without rows overlap
body: <p>I have two dataframes like these:</p>
  
  <p><a href="https://i.stack.imgur.com/N7KM9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N7KM9.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/S2aN4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S2aN4.png" alt="enter image description here"></a></p>
  
  <p>They have the same columns. </p>
  
  <p>Since I am broadcasting an API, they usually hava some overlap, which can be handled by the <code>tradeID</code> which is unique.</p>
  
  <p>I have tried some stuff like:</p>
  
  <p><code>
  df2 = df0.join(df1, how='outer', lsuffix='_caller', rsuffix='_other')
  </code></p>
  
  <p>and</p>
  
  <p><code>
  df2 = df0.merge(df1, left_index=True, right_index=True)
  </code></p>
  
  <p>But the results are respectively:</p>
  
  <p><a href="https://i.stack.imgur.com/527dO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/527dO.png" alt="enter image description here"></a></p>
  
  <p>and<a href="https://i.stack.imgur.com/gRKf5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gRKf5.png" alt="enter image description here"></a></p>
  
  <p>I am looking for a union without overlap, could someone help me?</p>