title: Convert JSON to full table
body: <p>How with pandas convert shopify Json response</p>
  <blockquote>
  <p>pastebin.com/8Kf8FHf4</p>
  </blockquote>
  <p>to full Table without column included json child</p>
  <p>now i use this code</p>
  <pre><code>import pandas as pd
  import numpy as np
  import re
  import requests
  def get_all_orders():
      last=0
      orders=pd.DataFrame()
      while True:
          url = f&quot;https://{apikey}:{password}@{hostname}/admin/api/{version}/{resource}.json?limit=250&amp;fulfillment_status=unfulfilled&amp;since_id={last}&quot;
          response = requests.request(&quot;GET&quot;, url)
          
          df=pd.DataFrame(response.json()['orders'])
          orders=pd.concat([orders,df])
          last=df['id'].iloc[-1]
          if len(df)&lt;250:
              break
      return(orders)
  df=get_all_orders()
  </code></pre>
  <p>I want get rid of that childs in columns</p>
  <p><a href="https://i.stack.imgur.com/QsSzn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QsSzn.png" alt="enter image description here" /></a></p>