title: compare rows values of two different CSV files in c#
body: <p>I know there is more similar question but I was not able to find the answer to mine. I have two CSV files. Both files contain image metadata for the same images, however, the first file image IDs are outdated. So I need to take the IDs from the second file and replace outdated IDs with new ones. I was thinking to compare image Longitude, Latitude, and Altitude rows values, and where it matches in both files I take image id from the second file. The IDs would be used in the new object. And the sequence of lines in files is different and the first file contains more lines than the second one.</p>
  <p>The files structure looks as follows:</p>
  <p>First file:</p>
  <pre><code>ImgID,Longitude,Latitude,Altitude
  01,44.7282372307,27.5786807185,14.1536407471
  02,44.7287939869,27.5777060219,13.2340240479
  03,44.7254687824,27.582636255,16.5887145996
  04,44.7254294913,27.5826908925,16.5794525146
  05,44.728785278,27.5777185252,13.2553100586
  06,44.7282279311,27.5786933339,14.1576690674
  07,44.7253847039,27.5827526969,16.6026000977
  08,44.7287777782,27.5777295052,13.2788238525
  09,44.7282196988,27.5787045314,14.1649169922
  10,44.7253397041,27.5828151049,16.6300048828
  11,44.728769439,27.5777417846,13.3072509766
  </code></pre>
  <p>Second file:</p>
  <pre><code>ImgID,Longitude,Latitude,Altitude
  5702,44.7282372307,27.5786807185,14.1536407471
  5703,44.7287939869,27.5777060219,13.2340240479
  5704,44.7254687824,27.582636255,16.5887145996
  5705,44.7254294913,27.5826908925,16.5794525146
  5706,44.728785278,27.5777185252,13.2553100586
  5707,44.7282279311,27.5786933339,14.1576690674
  </code></pre>
  <p>How this can be done in C#? Is there is some handy library to work with?</p>