title: How to read nested json file with python pandas
body: <p>i have a json structure as this one:</p>
  
  <pre><code>{"results":{"whatever_name":{"id":77},"another_name":{"id":89},"another_name":{"id":60}},"timestamp":123456}
  </code></pre>
  
  <p>the number of observations for each line is different, it might be 3 or whatever. I tried to use pandas pd.read_json but gives the obvious error, there are no common fields in the structure.
  Can anyone help me to read the file in a dataframe with four fields: name, id, value, timestamp.</p>