title: Transpose CSV using python
body: <p>I have a csv which as data for around 1500 locations and is in the below format:</p>
  
  <pre><code>LOCATION 10/23/2018 10/24/2018 10/25/2018 10/26/2018
  0001       350         351        500         600
  0002       400         200         400         250
  0005        250        200         300         400
  </code></pre>
  
  <p>and the list of location goes on an on for around 1500 locations.</p>
  
  <p>The desired output that i need is :</p>
  
  <pre><code>LOCATION    DATE         VALUE
  0001      10/23/2018      350
  0001      10/24/2018      351
  0001      10/25/2018      500
  </code></pre>
  
  <p>As can be seen from the above output , i need the python program to create two new fields ( DATE and VALUE) in addition to do transpose the fields. I literally dont know how to create it as a python as i have not worked on python much.</p>
  
  <p>Any help is highly appreciated.</p>
  
  <p>Thanks</p>