title: Python JSON to dataframe
body: <p>i have json in format</p>
  <pre><code>   {
     &quot;projects&quot;:[
        {
           &quot;author&quot;:{
              &quot;id&quot;:163,
              &quot;name&quot;:&quot;MyApp&quot;,
              &quot;easy_external_id&quot;:null
           },
           &quot;sum_time_entries&quot;:0,
           &quot;sum_estimated_hours&quot;:29,
           &quot;currency&quot;:&quot;EUR&quot;,
           &quot;custom_fields&quot;:[
              {
                 &quot;id&quot;:42,
                 &quot;name&quot;:&quot;System&quot;,
                 &quot;internal_name&quot;:null,
                 &quot;field_format&quot;:&quot;string&quot;,
                 &quot;value&quot;:null
              },
              {
                 &quot;id&quot;:40,
                 &quot;name&quot;:&quot;Short describe&quot;,
                 &quot;internal_name&quot;:null,
                 &quot;field_format&quot;:&quot;string&quot;,
                 &quot;value&quot;:&quot;&quot;
              }
           ]
        }
     ]&quot;total_count&quot;:1772,
     &quot;offset&quot;:0,
     &quot;limit&quot;:1
  }
  </code></pre>
  <p>And I don't know how to convert this Json &quot;completely&quot; to a dataframe. Respectively, I just want what's in <code>projects</code>. But when I do this:</p>
  <pre><code>df = pd.DataFrame(data['projects'])
  </code></pre>
  <p>Although I only get the dataframe from projects, in some columns (for example: <code>author</code> or <code>custom_fields</code>) the format will still remain undecomposed and I would like to decompose it in these columns as well.
  can anyone advise?</p>
  <p>I expect:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>author.id</th>
  <th>author.name</th>
  <th>author.easy_external_id</th>
  <th>sum_time_entries</th>
  <th>currency</th>
  <th>custom_fields.id</th>
  <th>custom_fields.name</th>
  <th>etc..</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>163</td>
  <td>MyApp</td>
  <td>null</td>
  <td>0</td>
  <td>EUR</td>
  <td>42</td>
  <td>System</td>
  <td>...</td>
  </tr>
  </tbody>
  </table>
  </div>