title: Rpy2: How to convert list of dictionaries to R data frame
body: <p>I have a Python list of dictionaries as follows (coming from a sqlite3 row factory):</p>
  
  <pre><code>obs = [{'ave': 0.027, 'pap': 0.277}, 
  {'ave': 0.29, 'pap': 0.333}, 
  {'ave': 0.25, 'pap': 0.5}]
  </code></pre>
  
  <p>I would like to convert this to an R data.frame in order to use it with <code>rpy2</code> (Version 2.3.6), so that it looks like this</p>
  
  <pre><code>    ave   pap  
  
  1 0.027 0.277 
  2 0.29  0.333
  3 0.25  0.5
  </code></pre>
  
  <p>I am able to convert a single "row" to a data.frame, as follows:</p>
  
  <pre><code>robjects.DataFrame(obs[0])
  
      ave   pap 
  
  1 0.027 0.277 
  </code></pre>
  
  <p>Using <code>robjects.DataFrame(obs)</code> does not work... ValueError: obj can be either an instance of an iter-able class(such a Python dict, rpy2.rlike.container OrdDict or an instance of rpy2.rinterface.SexpVector of type VECSXP</p>
  
  <p>I've also tried to convert it to an OrdDict using <code>rpy2.rlike.container.OrdDict(obs)</code> but got ValueError: too many values to unpack</p>
  
  <p>I think there are many different techniques to achieve this, and the multitude of data structures in both rpy2 and Python confuses me. </p>