title: How to append json files to a dataframe?
body: <p>I have a large pandas data frame with over 300 columns. One of these columns is the product id. Each product is linked to a json file through the url:</p>
  
  <pre><code>"https://cws01.worldstores.co.uk/api/product.php?product_sku="+id
  </code></pre>
  
  <p>what I need to do is to load the information stored in json files and append to the row with the same product id all those values whose attribute key match a column in the dataset and fill blank those without a match</p>
  
  <p>json file attributes are fewer than columns in the pandas data frame so the dataset will be somehow sparse. </p>
  
  <p>I don't know how to get started. I wish I could do it in python. Any idea on how the tasks breakdown would be? many thanks</p>