title: How to import JSON file into Pandas Dataframe
body: <p>I’ve been striking out on several different approaches to loading this data into Pandas. If anyone has any suggestions for these exceptions it would be much appreciated! The file name changes in some examples between tweet_json.txt and tweet_json.json as I was trying different methods.</p>
  
  <pre><code>with open('tweet_json.json', 'r') as f:
      data = json.load(f)
  df_3 = pd.DataFrame(data)
  </code></pre>
  
  <p>results in : <code>JSONDecodeError: Extra data: line 2 column 1 (char 3974)</code></p>
  
  <pre><code>df_3 = pd.read_json('tweet_json.json', lines = True)
  </code></pre>
  
  <p>results in : <code>ValueError: Unexpected character found when decoding object value</code></p>
  
  <pre><code>with open('tweet_json.txt') as file:
      status = []
      for line in file:
          data = json.loads(line)
  df_3 = pd.Dataframe(data)
  </code></pre>
  
  <p>results in: <code>JSONDecodeError: Expecting ',' delimiter: line 1 column 1626 (char 1625)</code></p>
  
  <p>The only time I had remotely any success was using json.dumps() but this just loaded it into a single column dataframe with nothing parsed, and being that the json looks like a multi level dictionary I would have no idea how to go about separating it:</p>
  
  <pre><code>data = []
  with open('tweet_json.json') as f:    
      for line in f:         
           data.append(json.dumps(line))
  df_3 = pd.DataFrame(data)  
  </code></pre>