Write Pandas Series Vertically using to_csv
<p>I have a loop running that has a long series that needs to be printed vertically to a csv on each iteration.  Using the to_csv is just printing it horizontally. Is there a specific way this needs be done?</p>

<pre><code>Index        Value

 Age           25       
 Siblings      0
 Area Code     416
 ...etc

 Age           23       
 Siblings      2
 Area Code     401
 ...etc
</code></pre>

<p>This is an example of my series, I would like to have it output to a csv like this.  So I'm trying to print the indexes as columns and the values below it.</p>

<pre><code>  age                siblings             Area Code
  25                   0                    416
  23                   2                    401
</code></pre>

<p>Have you tried transposing the df and then outputting it? </p>

<pre><code>dfT = df.T 
dfT.to_csv('Vert.csv')
</code></pre>

<p>Something like that might give you what you want. 
Similar to this <a href="http://stackoverflow.com/questions/24412510/transpose-pandas-dataframe">question</a>. </p>

python pandas