title: Extract multiple dataframes from dictionary with Python
body: <p>I'm using the pandas library in Python.</p>
  
  <p>I've taken an excel file and stored the contents in a data frame by doing the following:</p>
  
  <pre><code>path = r"filepath"
  sheets_dict = pd.read_excel(path,sheet_name=None)
  </code></pre>
  
  <p>As there was multiple sheets, each containing a table of data with identical columns, I used pd.read_excel(path,sheet_name=None). This stored all the individual sheets into a dictionary with the key for each value/sheet being the sheet name.</p>
  
  <p>I now what to unpack the dictionary and place each sheet into a single data frame. I want to use the key of each sheet in the dictionary as either part of a mulitindex so I know what key/sheet of each table came from or appended as a new column which gives me the key/sheet name for each unique subset of the dataframe.</p>
  
  <p>I've tried the following:</p>
  
  <pre><code>for k,df in sheets_dict.items():
      df = pd.concat([pd.DataFrame(df)])
      df['extract'] = k
  </code></pre>
  
  <p>However I'm not getting the results I want.</p>
  
  <p>Any suggestions?</p>