title: python reading json string with headers in initial part
body: <p>I am trying to grab output from a package (defined in the package documentation as 'jsonDICT') and eventually write it as csv.
  I will call this PackResult, and it is a dictionary.</p>
  
  <p>The first, and last, few characters of print(PackResult) looks like this:</p>
  
  <pre><code>{'startDate': '2019-11-01T00:00:00', 'endDate': '2020-03-31T00:00:00', 'timezone': 'UTC', 'groupBy': 'DAILY', 'numberOfDocuments': 34486, 'volume':  
  [{'startDate': '2019-11-01T00:00:00', 'endDate': '2019-11-02T00:00:00', 'numberOfDocuments': 0},  
   {'startDate': '2019-11-02T00:00:00', 'endDate': '2019-11-03T00:00:00', 'numberOfDocuments': 1},  
   {'startDate': '2019-11-03T00:00:00', 'endDate': '2019-11-04T00:00:00', 'numberOfDocuments': 0}  
  ...  
  {'startDate': '2020-03-30T00:00:00', 'endDate': '2020-03-31T00:00:00', 'numberOfDocuments': 1389}], 'status': 'success'}  
  </code></pre>
  
  <p>So the first part of the string contains "sample" column headers, and then once the left bracket is encountered, the actual values, with their respective column headers, are presented.</p>
  
  <p>I am trying to use pandas to do the heavy lifting, but I cannot seem to get it to read the first set of headers, and then the data. Essentially,  </p>
  
  <pre><code>import pandas as pand
  import json
  df = pand.read_json(json.dumps(PackResult),'records','series')
  print(df)
  </code></pre>
  
  <p>gives me this:  </p>
  
  <pre><code>startDate                                          2019-11-01T00:00:00  
  endDate                                            2020-03-31T00:00:00  
  timezone                                                           UTC  
  groupBy                                                          DAILY  
  numberOfDocuments                                                34486  
  volume               [{'startDate': '2019-11-01T00:00:00', 'endDate...  
  status                                                         success
  </code></pre>
  
  <p>and  </p>
  
  <pre><code>df = pand.read_json(json.dumps(PackResult),'records','frame') 
  </code></pre>
  
  <p>gives me:  </p>
  
  <pre><code>startDate              endDate timezone groupBy  numberOfDocuments                                             volume   status  
  0    2019-11-01T00:00:00  2020-03-31T00:00:00      UTC   DAILY              34486  {'startDate': '2019-11-01T00:00:00', 'endDate'...  success  
  1    2019-11-01T00:00:00  2020-03-31T00:00:00      UTC   DAILY              34486  {'startDate': '2019-11-02T00:00:00', 'endDate'...  success  
  2    2019-11-01T00:00:00  2020-03-31T00:00:00      UTC   DAILY              34486  {'startDate': '2019-11-03T00:00:00', 'endDate'...  success  
  3    2019-11-01T00:00:00  2020-03-31T00:00:00      UTC   DAILY              34486  {'startDate': '2019-11-04T00:00:00', 'endDate'...  success  
  4    2019-11-01T00:00:00  2020-03-31T00:00:00      UTC   DAILY              34486  {'startDate': '2019-11-05T00:00:00', 'endDate'...  success  
  </code></pre>
  
  <p>What am I missing?  </p>
  
  <p>Thanks in advance</p>