title: Writing lists of values to a csv file in different columns using Python
body: <p>I need help with writing values to a csv file. </p>
  
  <p>I have 4 lists of values that I would like to write to a csv file, but not in a normal way. I mean, usually the csv module write the values in the same row, but this time I would like to write the values of the lists in different columns, I mean one column and different rows for every list. In this way, all the list 1 data would be in the column A of Excel, all the list 2 data would be in the column B of excel, and so on. Now I was trying a lot of commands and I half did it, but not at all.</p>
  
  <p>My list's names are: It_5minute, Iiso_5min, IHDKR_5min and Iperez_5min.</p>
  
  <p>My actual commands:</p>
  
  <pre><code>with open('Test.csv', 'w') as f:
      w = csv.writer(f)
      for row in zip(It_5minute, Iiso_5min, IHDKR_5min,Iperez_5min):
          w.writerow(row)
  </code></pre>
  
  <p>With these commands I get the list values in the same column (instead of every list in a different column), each value separated by comma. I have attached an Excel image to clarify the problem. I want each list in a separated column, to be able of do operations with the data in an easy way. Can anybody help me? Thank you very much.</p>
  
  <p>PD: Would be nice to write the name of each list at the top of every column, too.</p>
  
  <p><img src="https://i.stack.imgur.com/ZFl73.png" alt="enter image description here"></p>