title: Python: How to turn a dictionary of Dataframes into one big dataframe with column names being the key of the previous dict?
body: <p>So my dataframe is made from lots of individual excel files, each with the the date as their file name and the prices of the fruits on that day in the spreadsheet, so the spreadsheets look something like this:</p>
  
  <pre><code>15012016:
  Fruit     Price
  Orange    1
  Apple     2
  Pear      3
  
  16012016:
  Fruit     Price
  Orange    4
  Apple     5
  Pear      6
  
  17012016:
  Fruit     Price
  Orange    7
  Apple     8
  Pear      9
  </code></pre>
  
  <p>So to put all that information together I run the following code to put all the information into a dictionary of dataframes
  (all fruit price files stored in 'C:\Fruit_Prices_by_Day'</p>
  
  <pre><code>#find all the file names
  file_list = []
  for x in os.listdir('C:\Fruit_Prices_by_Day'):
      file_list.append(x) 
  
  file_list= list(set(file_list))
  
  d = {}
  
  for date in Raw_list:
      df1 = pd.read_excel(os.path.join('C:\Fruit_Prices_by_Day', date +'.xlsx'), index_col = 'Fruit')
      d[date] = df1
  </code></pre>
  
  <p>Then this is the part where I'm stuck. How do I then make this dict into a dataframe where the column names are the dict keys i.e. the dates, so I can get the price of each fruit per day all in the same dataframe like:</p>
  
  <pre><code>          15012016   16012016   17012016   
  Orange    1          4          7
  Apple     2          5          8
  Pear      3          6          9
  </code></pre>