<p>我想你的第二种方法就快到了</p>
<pre><code>import pandas as pd
Dictionary = [{'JournalLineID': 'XXX', 'AccountID': 'XXX', 'AccountCode': '200', 'AccountType': 'XXX', 'AccountName': 'XXX', \
'Description': '', 'NetAmount': -428.0, 'GrossAmount': -428.0, 'TaxAmount': 0.0, \
'TrackingCategories': [{'Name': 'Location', 'Option': 'SG', 'TrackingCategoryID': 'XXX', \
'TrackingOptionID': 'XXX', 'Options': []}, {'Name': 'Sales Rep/Dept', 'Option': 'HQ', \
'TrackingCategoryID': 'XXX', \
'TrackingOptionID': 'XXX', 'Options': []}]}, \
{'JournalLineID': 'XXX2', 'AccountID': 'XXX', 'AccountCode': 'XXX', 'AccountType': 'EXPENSE', \
'AccountName': 'Subscriptions - Software', 'Description': 'XXXX', 'NetAmount': 400.0, 'GrossAmount': 428.0, \
'TaxAmount': 28.0, 'TaxType': 'INPUT', 'TaxName': 'Purchases 7%', \
'TrackingCategories': [{'Name': 'Location', 'Option': 'SG', 'TrackingCategoryID': 'XXX', \
'TrackingOptionID': 'XXX', 'Options': []}, {'Name': 'Sales Rep/Dept', 'Option': 'HQ', \
'TrackingCategoryID': 'XXX', \
'TrackingOptionID': 'XXX', 'Options': []}]}]
df = pd.DataFrame(Dictionary)
df
</code></pre>
<p>结果如下:</p>
<pre><code> AccountCode AccountID AccountName AccountType Description GrossAmount JournalLineID NetAmount TaxAmount TaxName TaxType TrackingCategories
0 200 XXX XXX XXX -428.0 XXX -428.0 0.0 NaN NaN [{'Name': 'Location', 'Option': 'SG', 'Trackin...
1 XXX XXX Subscriptions - Software EXPENSE XXXX 428.0 XXX2 400.0 28.0 Purchases 7% INPUT [{'Name': 'Location', 'Option': 'SG', 'Trackin...
</code></pre>