title: Writing heirarchical JSON data to Excel xls from Python?
body: <p>I want to write some data from python to xlsx. I currently have it stored as JSON, but it doesn't matter what it is going out of Python. Here's what the JSON for a single article would look like: </p>
  
  <pre><code>{ 
     'Word Count': 50
     'Key Words': { 
                    ['Blah blah blah', 'Foo', ... ] }
     'Frequency': {
                    [9, 12, ... ] }
     'Proper Nouns': { 
                    ['UN', 'USA', ... ] }
     'Location': 'Mordor'
  }
  </code></pre>
  
  <p>I checked out the XlsxWriter module but can't figure out how to translate hierarchical data that is not necessarily the same size (note the number of proper nouns between the two data "objects").</p>
  
  <p>What I want the data to look like:</p>
  
  <p><a href="https://i.stack.imgur.com/ntWbK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ntWbK.png" alt="Excel screenshot"></a></p>
  
  <p>Any pointers?</p>