title: How to remove rows from Pandas dataframe if the same row exists in another dataframe but end up with all columns from both df
body: <p>I have two different Pandas data-frames that have one column in common. I have seen similar questions on Stack overflow but none that seem to end up with the columns from both dataframes so please read below before marking as duplicate.</p>
  
  <p>Example:</p>
  
  <p>dataframe 1</p>
  
  <pre><code>ID  col1 col2  ...
  1    9    5
  2    8    4
  3    7    3 
  4    6    2
  </code></pre>
  
  <p>dataframe 2</p>
  
  <pre><code>ID  col3  col4  ...
  3    11     15
  4    12     16
  7    13     17
  </code></pre>
  
  <p>What I want to achieve is a dataframe with columns from both dataframes but without the ID's found in dataframe2. i.e:</p>
  
  <p>desired result:</p>
  
  <pre><code>ID  col1 col2  col3  col4
  1    9    5     -     -
  2    8    4     -     -
  </code></pre>
  
  <p>Thanks!</p>