title: Convert list of dictionaries to csv file
body: <p>I have a list of dictionaries of this kind :</p>
  
  <pre><code>[
  {'site1':'data1'},
  {'site2':'data2'}
  ]
  </code></pre>
  
  <p>What would be the proper way to generate a csv file with the data in this order ? :</p>
  
  <pre><code>row 1      row2
  site1      data1
  site2      data2
  </code></pre>