title: How to sort .csv file values by combining like strings using python3
body: <p>I'm still learning so please bear with me. I've been trying to figure this out for sometime now but have not found what im looking for. </p>
  
  <pre><code>My Product.csv file looks like this.
  
  111 ; Info1 ; Description 1 ; Remarks1
  123 ; Info1 ; Description 1 ; Remarks1
  156 ; Info2 ; Description 2 ; Remarks2
  124 ; Info3 ; Description 3 ; Remarks3
  
  I would like to combine entries that are similar like this.
  
  111, 123 ; Info1 ; Description 1 ; Remarks1
  156 ; Info2 ; Description 2 ; Remarks2
  124 ; Info3 ; Description 3 ; Remarks3
  
  From here i can manipulate my csv file in Excel using vba to insert into a quotation.
  </code></pre>
  
  <p>This is what i would like to achieve using Python. I'm stummped on where to start. I think I need to sart by opening the file and then reading the csv file. After that assign variable to #(i.e. 111) , info, Description, Remarks. Then sort thru the variables and combine like #'s. Then write it back to the file. Please let me know if you need me to calrify anything.</p>