title: How do i extract specific excel rows based on column data from a different excel spreadsheet
body: <p>Just need pointed in the right direction or even told if its possible or not.</p>
  <p>So I have two massive excel files both over 700K rows.</p>
  <p>The goal: Find the delta</p>
  <p>The issue: too many unique data points to find a true delta without scraping most of the content of each files down to a simple claims number then running this...</p>
  <pre><code>    import csv
  
  fn1 = &quot;C:/Users/****/Downloads/Files (5)/Claims_*******_20210507.txt&quot;
  fn2 = &quot;C:/Users/*****/Downloads/Files (5)/Claims_**********_20210514.txt&quot;
  
  with open(fn1) as f1, open(fn2) as f2:
     header = next(f1)
     st = set(f1)
     with open(&quot;C:/Users/********/Downloads/Files (5)/out.txt&quot;, &quot;w&quot;) as out:
         out.writelines((line for line in f2 if line not in st))
  </code></pre>
  <p>**** found this code from this website its a peach!****</p>
  <p>To get the true delta...</p>
  <p>So my question... Now that i have the delta data (claims numbers) is there a way for me to use python to pull the rest of the data associated with that column (claims number).</p>
  <p>I would just suffer and do a vlookup on each column based against the claims number but each file is over 700k rows so putting the data together in one spreadsheet isnt happening.</p>
  <p>Outside of opening access which i dont want to do, can someone point me in the right direction of what i need to study or learn? or share their wisdom if this is even possible? I keep seeing something for panda but nothing to my specific needs.</p>