title: Dask parsing Nested Json file to dataframe
body: <p>I would really love some help with parsing nested JSON data using Dask.</p>
  <p>This is an example of the JSON file (input), the result array in the json shown can have more than 3 elements, the shown json is just for illustrating the structure:</p>
  <pre><code>{&quot;status&quot;:&quot;success&quot;,
  
   &quot;data&quot;:{&quot;resultType&quot;:&quot;matrix&quot;,&quot;result&quot;:
  
  [{&quot;metric&quot;:{&quot;data0&quot;:&quot;T&quot; ,&quot;data1&quot;:&quot;O&quot;},&quot;values&quot;:[[90,&quot;0&quot;],[80, &quot;0&quot;]]},
  
  {&quot;metric&quot;:{&quot;data0&quot;:&quot;K&quot; ,&quot;data1&quot;:&quot;S&quot;},&quot;values&quot;:[[70,&quot;0&quot;],[60, &quot;0&quot;]]},
  
  {&quot;metric&quot;:{&quot;data2&quot;:&quot;J&quot; ,&quot;data3&quot;:&quot;O&quot;},&quot;values&quot;:[[50,&quot;0&quot;],[40, &quot;0&quot;]]}]}}
  </code></pre>
  <p><strong>My Goals</strong> I would essentially want to get the data into the following data frames:</p>
  <p>1-</p>
  <pre><code>data0 | data1 | data2 | data3 |values
  </code></pre>
  <p>example output dataframe:</p>
  <pre><code>data0  | data1 | data2  | data3 | values
  &quot;T&quot;    |   &quot;O&quot; |    nan |    nan|   [90,&quot;0&quot;],[80, &quot;0&quot;]
  &quot;K&quot;    |   &quot;S&quot; |    nan |    nan|   [70,&quot;0&quot;],[60, &quot;0&quot;]
  nan    |   nan |    &quot;J&quot; |    &quot;O&quot;|   [50,&quot;0&quot;],[40, &quot;0&quot;]
  
  </code></pre>
  <p>2-</p>
  <pre><code>time | value | data0 | data1 | data2 | data3
  </code></pre>
  <p>example output dataframe</p>
  <pre><code>time | value |data0 | data1 | data2  | data3 
  90   |   &quot;0&quot; |   &quot;T&quot;|    &quot;O&quot;|   nan  | nan
  80   |   &quot;0&quot; |   &quot;T&quot;|    &quot;O&quot;|   nan  | nan
  70   |   &quot;0&quot; |   &quot;K&quot;|    &quot;S&quot;|   nan  | nan
  60   |   &quot;0&quot; |   &quot;K&quot;|    &quot;S&quot;|   nan  | nan
  50   |   &quot;0&quot; |   nan|    nan|   &quot;J&quot;  | &quot;O&quot;
  40   |   &quot;0&quot; |   nan|    nan|   &quot;J&quot;  | &quot;O&quot;
  
  </code></pre>
  <p>Also , if there are any ways to speed up this process using dask's parallelism capabilities , that would be great because the parsed json files are in gigabytes.</p>