title: JSON data to Pandas DataFrame
body: <p>Help I have a JSON file and I can't get it to load in to a python DataFrame.
  First  question should probably be is this actually a json file? Was the resulting file when a chart was rendered on a Web page and this was the back end data I pulled from chrome network inspection. </p>
  
  <p>It seems there is code in front that is not JSON or not a table so it messing up the import.</p>
  
  <p><a href="http://pastebin.com/ne4RRrgP" rel="nofollow">http://pastebin.com/ne4RRrgP</a></p>
  
  <p>Can you please help</p>
  
  <p>the below loads the file in to python </p>
  
  <pre><code>import json
  from pprint import pprint
  with open('data2.json') as data_file:
      data = json.load(data_file)
  </code></pre>
  
  <p>and </p>
  
  <pre><code>pprint(data)
  </code></pre>
  
  <p>does print the data but I can't then convert to a pandas dataframe</p>
  
  <p>edit</p>
  
  <p>Ok this must be javascript file that I think is JSON.</p>