title: Comparing two dataframes and getting the differences
body: <p>I have two dataframes.  Examples:</p>
  
  <pre><code>df1:
  Date       Fruit  Num  Color 
  2013-11-24 Banana 22.1 Yellow
  2013-11-24 Orange  8.6 Orange
  2013-11-24 Apple   7.6 Green
  2013-11-24 Celery 10.2 Green
  
  df2:
  Date       Fruit  Num  Color 
  2013-11-24 Banana 22.1 Yellow
  2013-11-24 Orange  8.6 Orange
  2013-11-24 Apple   7.6 Green
  2013-11-24 Celery 10.2 Green
  2013-11-25 Apple  22.1 Red
  2013-11-25 Orange  8.6 Orange
  </code></pre>
  
  <p>Each dataframe has the Date as an index. Both dataframes have the same structure. </p>
  
  <p>What i want to do, is compare these two dataframes and find which rows are in df2 that aren't in df1. I want to compare the date (index) and the first column (Banana, APple, etc) to see if they exist in df2 vs df1.</p>
  
  <p>I have tried the following:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/17095101/outputting-difference-in-two-pandas-dataframes-side-by-side-highlighting-the-d">Outputting difference in two Pandas dataframes side by side - highlighting the difference</a></li>
  <li><a href="https://stackoverflow.com/questions/19917545/comparing-two-pandas-dataframes-for-differences">Comparing two pandas dataframes for differences</a></li>
  </ul>
  
  <p>For the first approach I get this error: <strong><em>"Exception: Can only compare identically-labeled DataFrame objects"</em></strong>.  I have tried removing the Date as index but get the same error.</p>
  
  <p>On the <a href="https://stackoverflow.com/questions/19917545/comparing-two-pandas-dataframes-for-differences">third approach</a>, I get the assert to return False but cannot figure out how to actually see the different rows.</p>
  
  <p>Any pointers would be welcome</p>