title: how to read json file with pandas?
body: <p>I have scraped a website with scrapy and stored the data in a json file.<br>
  Link to the json file: <a href="https://drive.google.com/file/d/0B6JCr_BzSFMHLURsTGdORmlPX0E/view?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0B6JCr_BzSFMHLURsTGdORmlPX0E/view?usp=sharing</a></p>
  
  <p>But the json isn't standard json and gives errors:</p>
  
  <pre><code>&gt;&gt;&gt; import json
  &gt;&gt;&gt; with open("/root/code/itjuzi/itjuzi/investorinfo.json") as file:
  ...     data = json.load(file)
  ... 
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 2, in &lt;module&gt;
    File "/root/anaconda2/lib/python2.7/json/__init__.py", line 291, in load
  **kw)
    File "/root/anaconda2/lib/python2.7/json/__init__.py", line 339, in loads
      return _default_decoder.decode(s)
    File "/root/anaconda2/lib/python2.7/json/decoder.py", line 367, in decode
      raise ValueError(errmsg("Extra data", s, end, len(s)))
  ValueError: Extra data: line 3 column 2 - line 3697 column 2 (char 45 - 3661517)
  </code></pre>
  
  <p>Then I tried this:</p>
  
  <pre><code>with open('/root/code/itjuzi/itjuzi/investorinfo.json','rb') as f:
       data = f.readlines()
  data = map(lambda x: x.decode('unicode_escape'), data)
  &gt;&gt;&gt; df = pd.DataFrame(data)
  Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  NameError: name 'pd' is not defined
  &gt;&gt;&gt; import pandas as pd
  &gt;&gt;&gt; df = pd.DataFrame(data)
  &gt;&gt;&gt; print pd
  &lt;module 'pandas' from '/root/anaconda2/lib/python2.7/site-packages/pandas/__init__.pyc'&gt;
  &gt;&gt;&gt; print df
  [3697 rows x 1 columns]
  </code></pre>
  
  <p>Why does this only return 1 column?</p>
  
  <p>How can I standardize the json file and read it with pandas correctly?</p>