title: pd.DataFrame(data, columns=[]). How to pass a data which is with nested dictionary?
body: <p>My data is like:</p>
  
  <pre><code>data = {'Sr.No.': Sr_no,
          'CompanyNames': Company_Names,
          'YourChoice1': ['45','45','45','45','45','45','45','45','45'],
          'YourChoice2': ['45','45','45','45','45','45','45','45','45'],
          'Bollinger Bands': {'Field1': ['45','45','45','45','45','45','45','45'],
                              'Field2': ['45','45','45','45','45','45','45','45'],
                              'Field3':['45','45','45','45','45','45','45','45']}
                             }
  </code></pre>
  
  <p>Which I am passing to the dataframe as:</p>
  
  <pre><code>df = pd.DataFrame(data, columns = ['Sr.No.','CompanyNames','YourChoice1','YourChoice2','Bollinger Bands'])
  </code></pre>
  
  <p>But I am receiving error as:</p>
  
  <blockquote>
    <p>ValueError: Mixing dicts with non-Series may lead to ambiguous ordering.</p>
  </blockquote>
  
  <p>Can anyone help me with this?</p>
  
  <p>The CSV file should look like:</p>
  
  <p><a href="https://i.stack.imgur.com/wlTAm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wlTAm.png" alt="enter image description here"></a></p>
  
  <p>I tried the 1st solution like this:</p>
  
  <pre><code>df1 = pd.DataFrame(data, columns = ['Sr.No.', 'CompanyNames','YourChoice1','YourChoice2'])
  bbands = data.pop('Bollinger Bands')
  df2 = pd.DataFrame(bbands)
  
  df = pd.concat([df1, df2], axis=1, keys=['','Bollinger Bands'])
  </code></pre>
  
  <p>But I have obtained the output as:</p>
  
  <p><a href="https://i.stack.imgur.com/gVRrF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gVRrF.png" alt="enter image description here"></a></p>
  
  <p>I want that 'Bollinger Bands' should be in only the first column not in all...'</p>
  
  <p>The desired output is:</p>
  
  <pre><code> |      |     |     |     |Bollinger Bands|        |        |
   |Sr.No.|Comp |     |     |Field1         |Field2  |Field3  |
  </code></pre>