title: How to convert list of dictionary with multi same keys to dataframe?
body: <p>I have a list like this:</p>
  <pre><code>lst_link = [{'bed_room': ['link_a']}, {'bed_room': ['link_b']}, {'bed_room': ['link_c']} , {'living_room': ['link_d']}, {'living_room': ['link_e']}]
  </code></pre>
  <p>How to convert the list above to dataframe with a structure like this:</p>
  <pre><code>data = [
  ['bed_room', 'link_a'],
  ['bed_room', 'link_b'],
  ['bed_room', 'link_c'],
  ['living_room', 'link_d'],
  ['living_room', 'link_e']]
  result = pd.DataFrame(data, columns=['room','link'])
  </code></pre>
  <p>I tried the coding below but it does not work:</p>
  <pre><code>for d in lst_link:
      for k, v in d.items():
          dic[k].append(v)
  new_dict = dict(dic)
  result = pd.DataFrame(dict([(k,pd.Series(v)) for k,v in new_dict.items()]))
  trans_df = df.T
  </code></pre>