title: Creating n pandas dataframes based on user input in python
body: <p>Pretty new to python so any help is appreciated. I am trying to generate multiple pandas dataframes from separate excel spreadsheets. However when I try to reference the dataframe later it returns as a list:</p>
  <p>what I am trying is this</p>
  <pre><code>ref_dict = {}
  
  ... code to get the files open etc ...
          
          foo = []
          bar = []
          goo = []
          tar = []
          
          for z in range(40,c):
              foo_v = wb[n].cell(row=z, column=2).value
              bar_v = wb[n].cell(row=z, column=3).value
              goo_v = wb[n].cell(row=z, column=4).value
              tar_v = wb[n].cell(row=z, column=5).value
              foo.append(foo_v)
              bar.append(bar_v)
              goo.append(goo_v)
              tar.append(tar_v)
              d = {'Foo': foo, 'Bar': bar, 'Goo': goo, 'Tar': tar}
              df = pd.DataFrame(d)
              ref_dict[unique_ID] = []
              ref_dict[unique_ID] = [df]
  
  .... later on ...
  
  for i in ref_dict:
      print(type(ref_dict[i]))
  
  </code></pre>
  <p>The print type returns as a list and not a data frame - thus I cannot call columns etc. I could store multiple keys in a dict and assemble the dataframes later but it seems hacky and there should be a better way to do this?</p>