Compare Lines on csv file : <p>I have this csv file which has an answer key in the top row and all of the students answers below it in a roll like so:</p>

<pre><code>First Name,Last Name,Student ID,Version,Score,1,2,3,4,5,6,7,8,9,10
Answer Key,,,p,75,j,c,g,c,g,d,f,a,j,c
Mark,Mueller,14697,p,35,j,c,f,c,d,f,a,j,c,j
Andruw ,Wittles,15674,p,75,a,c,d,f,h,g,a,d,j,d
Bob,Johnson,32423,p,36,d,a,j,i,d,a,b,c,j,d
John,Smith,12343,p,67,a,c,b,g,h,j,a,d,c,b
</code></pre>

<p>The problem is that I cant find a good way to compare the answer key and the students answers. If you could help me also give the student's id the score. (The 5 digit number after the name)</p>

<p>Thanks.</p>
