title: Construct pandas DataFrame from list of tuples of (row,col,values)
body: <p>I have a list of tuples like</p>
  
  <pre><code>data = [
  ('r1', 'c1', avg11, stdev11),
  ('r1', 'c2', avg12, stdev12),
  ('r2', 'c1', avg21, stdev21),
  ('r2', 'c2', avg22, stdev22)
  ]
  </code></pre>
  
  <p>and I would like to put them into a pandas DataFrame with rows named by the first column and columns named by the 2nd column. It seems the way to take care of the row names is something like <code>pandas.DataFrame([x[1:] for x in data], index = [x[0] for x in data])</code> but how do I take care of the columns to get a 2x2 matrix (the output from the previous set is 3x4)? Is there a more intelligent way of taking care of row labels as well, instead of explicitly omitting them?</p>
  
  <p><strong>EDIT</strong> It seems I will need 2 DataFrames - one for averages and one for standard deviations, is that correct? Or can I store a list of values in each "cell"?</p>