title: Nested List to Pandas Dataframe with headers
body: <p>Basically I am trying to do the opposite of <a href="https://stackoverflow.com/questions/11811392/how-to-generate-a-list-from-a-pandas-data-frame-with-the-column-name-and-column">How to generate a list from a pandas DataFrame with the column name and column values?</a></p>
  
  <p>To borrow that example, I want to go from the form:</p>
  
  <pre><code>data = [['Name','Rank','Complete'],
                 ['one', 1, 1],
                 ['two', 2, 1],
                 ['three', 3, 1],
                 ['four', 4, 1],
                 ['five', 5, 1]]
  </code></pre>
  
  <p>which should output:</p>
  
  <pre><code> Name Rank Complete
    One    1        1
    Two    2        1
  Three    3        1
   Four    4        1
   Five    5        1
  </code></pre>
  
  <p>However when I do something like:</p>
  
  <pre><code>pd.DataFrame(data)
  </code></pre>
  
  <p>I get a dataframe where the first list should be my colnames, and then the first element of each list should be the rowname</p>
  
  <p>EDIT:</p>
  
  <p>To clarify, I want the first element of each list to be the row name.  I am scrapping data so it is formatted this way...</p>