title: Python Pandas to_csv Output Returns Single Character for String/Object Values
body: <p>I'm attempting to output the result into a pandas data frame. When I print the data frame, the object values appear correct, but when I use the to_csv function on the data frame, my csv output has only the first character for every string/object value.</p>
  
  <pre><code>df = pandas.DataFrame({'a':[u'u\x00s\x00']})
  df.to_csv('test.csv')
  </code></pre>
  
  <p>I've also tried the following addition to the to_csv function:</p>
  
  <pre><code>df.to_csv('test_encoded.csv', encoding= 'utf-8')
  </code></pre>
  
  <p>But am getting the same results:</p>
  
  <pre><code>&gt;&gt;&gt; print df
        a
  0  us
  
  (output in csv file)
  u
  </code></pre>
  
  <p>For reference, I'm connecting to a Vertica database and using the following setup:</p>
  
  <ul>
  <li>OS: Mac OS X Yosemite (10.10.5)</li>
  <li>Python 2.7.10 |Anaconda 2.3.0 (x86_64)| (default, Sep 15 2015,
  14:29:08)</li>
  <li>pyodbc 3.0.10</li>
  <li>pandas 0.16.2</li>
  <li>ODBC: Vertica ODBC 6.1.3</li>
  </ul>
  
  <p>Any help figuring out how to pass the entire object string using the to_csv function in pandas would be greatly appreciated.</p>