<blockquote>
<p><strong>Question</strong>: I need to format the output bit more so this can be exported to csv.</p>
</blockquote>
<p>无法使用<code>pyjp</code>进行测试,从<a href="https://pypi.org/project/pyjq/" rel="nofollow noreferrer">Project description</a>猜测,请尝试:</p>
<pre><code>pyjq.all('.base[].base[] | {"uid": .uid, "item-number":.item-number}', emp_data_parsed)
</code></pre>
<hr/>
<p>将JSON循环如下:</p>
^{pr2}$
<blockquote>
<p><strong>Output</strong>:</p>
<pre><code>{'uid': '2da21174-0af8-4b5b-b02e-2957a24d70e1', 'item-number': 1}, ... (omitted for brevity)
{'uid': 'fcc5a2c8-3a78-4cc5-9fd3-e7bd59eb36ba', 'item-number': 2}, ... (omitted for brevity)
{'uid': '4ecf6450-7307-466c-bf19-663ba2fbaf69', 'item-number': 3}, ... (omitted for brevity)
</code></pre>
</blockquote>
<p>输出已准备就绪,<code>csv.DictWriter</code>读取<a href="https://docs.python.org/3/library/csv.html#csv.DictWriter" rel="nofollow noreferrer">csv.DictWriter</a>,例如:</p>
<pre><code>import csv
with open('test.csv', 'w') as csv_file:
fieldnames = ['uid', 'item-number']
writer = csv.DictWriter(csv_file, fieldnames=fieldnames, extrasaction='ignore')
writer.writeheader()
for record in emp_data_parsed['base'][0]['base']:
writer.writerow(record)
</code></pre>
<blockquote>
<p><strong>Output</strong>:</p>
<pre><code>uid,name
2da21174-0af8-4b5b-b02e-2957a24d70e1,None
fcc5a2c8-3a78-4cc5-9fd3-e7bd59eb36ba,Tommy
4ecf6450-7307-466c-bf19-663ba2fbaf69,Sam
</code></pre>
</blockquote>