title: How to write a pandas Series to CSV as a row, not as a column?
body: <p>I need to write a <code>pandas.Series</code> object to a CSV file as a row, not as a column. Simply doing</p>
  
  <pre><code>the_series.to_csv( 'file.csv' )
  </code></pre>
  
  <p>gives me a file like this:</p>
  
  <pre><code>record_id,2013-02-07
  column_a,7.0
  column_b,5.0
  column_c,6.0
  </code></pre>
  
  <p>What I need instead is this:</p>
  
  <pre><code>record_id,column_a,column_b,column_c
  2013-02-07,7.0,5.0,6.0
  </code></pre>
  
  <p>This needs to work with pandas 0.10, so using <code>the_series.to_frame().transpose()</code> is not an option.</p>
  
  <p>Is there a simple way to either transpose the Series, or otherwise get it written as a row?</p>
  
  <p>Thanks!</p>