title: Comparing 2 CSV files & Outut differences to a CSV or Excel File
body: <p>There're 2 CSV files and i want to compare the contents of them and output it to another CSV or XLS file.</p>
  
  <p>CSV file 1</p>
  
  <pre><code>normal, vector, x-axis, y-axis, factor
  1552, 8743, 332, 2355, 99.03
  8800055, 322, 180, 443222, 555.005
  223, 44553, 88553, 88993, 100.004
  </code></pre>
  
  <p>CSV file 2</p>
  
  <pre><code>normal, vector, x-axis, y-axis, factor
  1552, 8743, 223, 2355, 99.03
  8800055, 322, 180, 443222, 200.005
  223, 44553, 88553, 1000, 100.004
  </code></pre>
  
  <p>As you see above the differences between the 2 are in 1st row x-axis, 2nd row factor and 3rd row y-axis.</p>
  
  <p>So basically am looking for a comparison and output that to a 3rd csv or xls file like this,</p>
  
  <pre><code>normal, vector, x-axis, y-axis, factor
  0, 0, 1, 0, 0
  0, 0, 0, 0, 1
  0, 0, 0, 1, 0
  </code></pre>
  
  <p>Basically 0's meaning no difference and 1's meaning there's difference.</p>
  
  <p>Right now, am using a comparison tool like Beyond Compare or something to do this comparison.</p>
  
  <p>Is there a way i can do this in Excel or something and then output the result as shown above?</p>