title: Read a csv file with column name as one column cell values
body: <p>Is it possible to read a CSV file in this format:</p>
  
  <pre><code>"name","foo"
  "class","9"
  "age","34"
  "gender","F"
  </code></pre>
  
  <p>into a resulting dataframe like this:</p>
  
  <pre><code>   name  class  age  gender
  0  foo     9    34    F
  </code></pre>