title: save dataframe to excel when each value is a dict
body: <p>Currently I am working on a project to read multiple excel sheet, parse the data, and save the combined dataframe back to an excel file.</p>
  
  <p>I read multiple excel table to dataframe, transform each to nested dict, and then combine all to a big nested dict (3-dimension of data), and at last transform back to dataframe.</p>
  
  <p>I have finished combining the data to a big dataframe. However, each value of the dataframe is a dict, thus after saving to excel using to_excel, the format is not good(as you can see below). What I want is to re-organize the data, so each excel cell only contains a key, an index item, or a single value.</p>
  
  <p>Here is the code I used to save data to excel:</p>
  
  <p><code>with ExcelWriter(dump_excel) as writer:
      DataFrame(DataFrame(new_dict)).to_excel(writer, sheet_name='yield_all')</code></p>
  
  <p><a href="https://i.stack.imgur.com/tu1JI.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tu1JI.jpg" alt="enter image description here"></a></p>
  
  <p>What I would want to get is something like below:
  <a href="https://i.stack.imgur.com/8y3yb.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8y3yb.jpg" alt="enter image description here"></a></p>