title: Read JSON file in Python Pandas
body: <p>I have the following part of a JSON file:</p>
  <pre><code>[{&quot;Date&quot;:&quot;2020-02-17&quot;,&quot;Rt_low&quot;:0.5,&quot;Rt_avg&quot;:1.93,&quot;Rt_up&quot;:4,&quot;population&quot;:&quot;hosp&quot;},{&quot;Date&quot;:&quot;2020-02-18&quot;,&quot;Rt_low&quot;:0,&quot;Rt_avg&quot;:1.74,&quot;Rt_up&quot;:4,&quot;population&quot;:&quot;hosp&quot;}]
  </code></pre>
  <p>I want to read this in Python Pandas as a dataframe with the 4 columns as headers:</p>
  <pre><code>L = ['Date','Rt_low','Rt_up','population']
  </code></pre>
  <p>I tried the  following:</p>
  <pre><code>df = pd.DataFrame(pd.read_json(file_name, lines=True))
  </code></pre>
  <p>Which gives me a [1 rows x 235 columns] for the whole dataset. I want to get 4 columns dataframe. How do I do this?</p>