Merging rows into one with same column cells and keep data from all into the merged row using python script
<p>I need to merge more rows into one but in the way i can keep all data in all columns into the merged row in my .csv file. The rows which i need to merge are one who have same email cells. The first table in the picture is how i have now and the second how should be.</p>

<p><a href="http://i.stack.imgur.com/tgpuh.png" rel="nofollow">enter image description here</a></p>

<p>I need to do this with Python script. Can anyone help me?</p>

<p>Thank you Igor</p>

<p>my idea: start at row 1, take the email and store it in a list. </p>

<p>Now compare each entry of the the hole email column with the email from row 1. If its equal then find out which fields in your row are empty and if the found entry has one of these filled out. </p>

<p>Write the concatenated row down and go on with the second row/email. </p>

<p>Dont forget to check if the new email has already checked (see if there is a entry in the list from start) and go on.</p>

<p>A bit of work but very low level, im pretty sure there is a smarter solution, but this should work too.</p>

python csv merge rows