title: Compare two csv files with python pandas
body: <p>I have two csv files both consist of two columns.</p>
  
  <p>The first one has the product id, and the second has the serial number.</p>
  
  <p>I need to lookup, all serial numbers from the first csv, and find matches, on the second csv. The result report, will have the serial number that matched, and the corresponding product ids from each csv, in a separate column
  i trued to modify the below code, no luck.</p>
  
  <p>How would you approach this?</p>
  
  <pre><code>import pandas as pd
      A=set(pd.read_csv("c1.csv", index_col=False, header=None)[0]) #reads the csv, takes only the first column and creates a set out of it.
      B=set(pd.read_csv("c2.csv", index_col=False, header=None)[0]) #same here
      print(A-B) #set A - set B gives back everything thats only in A.
      print(B-A) # same here, other way around.
  </code></pre>