title: How to compare two columns in two different pandas dataframes?
body: <p>I am running a selenium script which captures the office location and employee name and saves to a dataframe.</p>
  <pre><code>Employee   Office
  John Doe   Building One
  Kim Joe    Building One
  Harry P   Building two
  Harry P   Building Three
  
  CSV
     Employee   Office
      Kim Joe   Building One
      Harry P   Building two
      Harry P   Building Three
  </code></pre>
  <p>my code is below</p>
  <pre><code>df2 = df2.append({'Employee': emp.text,'Office': loc}, ignore_index=True)
  </code></pre>
  <p>I am reading the csv file into dataframe df1 and trying to compare the two columns in two dataframes, I tried the below code but it wont work because the indexes might be different</p>
  <pre><code>df2[df1.ne(self.df2).any(axis=1)]
  </code></pre>
  <p>What I am trying to do is want to get the employee:office which exist in df2 but not in df1, I am not sure how merge works, tried but didnt get the desired result, also tried using dictionary instead of dataframes but I guess it didnt work because of non unique keys, also open to other ways</p>
  <pre><code>Output
  John Doe   Building One
  </code></pre>