Generate a pandas dataframe from ordereddict? : <p>I am trying to create a pandas dataframe from an ordereddict to preserve the order of the values. But for some reason after creating the dataframe the fields are messed up again.</p>

<p>Here's the list of ordereddicts:</p>

<pre><code>[OrderedDict([
  ('key_a',
  'value_a'),
  ('key_b',
  'value_b'),
]),
OrderedDict([
  ('key_a',
  'value_c'),
  ('key_b',
  'value_d'),
])
]
</code></pre>

<p>Now how should I create a pandas DataFrame from these? What I am looking for is something like that (the important thing is the key_a and key_b etc column name order):</p>

<pre><code>  key_a    key_b
0 value_a  value_b
1 value_c  value_d
</code></pre>

<p>I have tried:</p>

<pre><code>pd.DataFrame.from_records(orderedDictList)
pd.DataFrame.from_dict(orderedDictList)
</code></pre>

<p>Feel free to ask any additional questions.</p>
