title: Pandas - Empty Dataframe
body: <p>I am trying to load the following data into my <code>pandas</code> <code>dataframe</code>:</p>
  
  <pre><code>jsons_data = pd.DataFrame(columns=['playlist', 'user', 'track', 'count'])
  
  for index, js in enumerate(json_files):
    with open(os.path.join(path_to_json, js)) as json_file:
      json_text = json.load(json_file)
      #my json layout
      user = json_text.keys()
      playlist = 'all_playlists'
      track = [p for p in json_text.values()[0]]
      count = [p.values() for p in json_text.values()]
      print jsons_data
  </code></pre>
  
  <p>but I get an <code>empty dataframe</code>:</p>
  
  <pre><code>[u'user1']
  all_playlists
  [{u'Make You Feel My Love': 1.0, u'I See Fire': 1.0, u'High And Dry': 1.0, u'Fake Plastic Trees': 1.0, u'One': 1.0, u'Goodbye My Lover': 1.0, u'No Surprises': 1.0}]
  [[1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0]]
  [u'user2']
  all_playlists
  [{u'Codex': 1.0, u'No Surprises': 1.0, u'O': 1.0, u'Go It Alone': 1.0}]
  [[1.0, 1.0, 1.0, 1.0]]
  [u'user3']
  all_playlists
  [{u'Fake Plastic Trees': 1.0, u'High And Dry': 1.0, u'No Surprises': 1.0}]
  [[1.0, 1.0, 1.0]]
  [u'user4']
  all_playlists
  [{u'No Distance Left To Run': 1.0, u'Running Up That Hill': 1.0, u'Fake Plastic Trees': 1.0, u'The Numbers': 1.0, u'No Surprises': 1.0}]
  [[1.0, 1.0, 1.0, 1.0, 1.0]]
  [u'user5']
  all_playlists
  [{u'Wild Wood': 1.0, u'You Do Something To Me': 1.0, u'Reprise': 1.0}]
  [[1.0, 1.0, 1.0]]
  Empty DataFrame
  Columns: [playlist, user, track, count]
  Index: []
  </code></pre>
  
  <p>what is wrong with the code?</p>
  
  <p>EDIT:</p>
  
  <p><code>json</code> files are structured in this fashion:</p>
  
  <pre><code>{
  'user1':{
  'Karma Police':1.0,
  'Roxanne':1.0,
  'Sonnet':1.0,
  'We Will Rock You':1.0,
  }}
  </code></pre>