title: Python record level comparision 2 large delimited files
body: <p>I have 2 large delimited files.</p>
  
  <p>Help needed in :</p>
  
  <p>a) I need to get the <strong>row count</strong> based on the <strong>key column</strong> for both the files</p>
  
  <p>b) finding the duplicates based on key column in both the files</p>
  
  <p>c) Get the <strong>duplicate count</strong> from both files.</p>
  
  <p>d) Duplicates should be created as <strong>separate file</strong></p>
  
  <p>e) get the <strong>common records</strong> in both the files.</p>
  
  <p>f) <strong>Sort</strong> ing both the files(common records)</p>
  
  <p>g) Comparing both files after sorting it and get the <strong>mismatch count</strong>.</p>
  
  <p>h) Mismatch records should be created as a separate file.</p>
  
  <p>Any help would be greatly appreciated.</p>