title: Python Pandas ordering odd dataframe
body: <p>I am learning some Python and have come across Pandas. I have an ordered dictionary that I want to use Pandas to output in a more readable format.</p>
  
  <p>My ordered dict is a little weird, in that the format is as follows</p>
  
  <pre><code>{name:{Value1:float, Value2:float, Value3:string}}
  </code></pre>
  
  <p>where the name varies for each data input. Printing it using the standard python print function looks like this:</p>
  
  <pre><code>name1: {Value1:float1a, Value2:float1b, Value3:string}
  name2: {Value1:float2a, Value2:float2b, Value3:string}
  ...etc
  </code></pre>
  
  <p>Which is then ordered by Value3, then Value2.</p>
  
  <p>When i convert it to a DataFrame using lowdict as follows <code>df = collections.OrderedDict(sorted(ord_dict.items(), key=lambda x_y: (x_y[1]['Value3'], x_y[1][Value2])))</code> and then print(df) get the following output:</p>
  
  <pre><code>         nameA      nameB      nameC      ....
  Value1   value1a    value1b    value1c    ...
  Value2   value2a    value2b    value2c    ...
  Value3   value3a    value3b    value3c    ...
  </code></pre>
  
  <p>My question is How do I use pandas to rearrange the DataFrame to look like this when printed?:</p>
  
  <pre><code>NAME    VALUE1     VALUE2     VALUE3    
  nameA   value1a    value2a    value3a
  nameB   value1b    value2b    value3b
  ... etc for 270+ values
  </code></pre>
  
  <p>I've tried pivoting the dataframe but not really sure how that works with an Ordered Dict like I have.</p>
  
  <p>All help is much appreciated!</p>
  
  <p>Cheers</p>
  
  <p>Dan</p>