<p>您可以使用<code>json_normalize</code></p>
<p><strong>例如:</strong></p>
<pre><code>from pandas.io.json import json_normalize
data = {'assignedTo': 'a5060ed2', 'automated': 'Not Automated', 'build': None, 'configurationId': 123,
'configurationName': 'Package 1.0', 'lastResultState': 1, 'lastRunBy': '', 'lastRunDuration': 0,
'mostRecentResultOutcome': 2, 'mostRecentRunId': 1234, 'outcome': 'Passed', 'state': 2,
'suiteId': 1234, 'suiteName': 'Name', 'testCaseId': 12345, 'testPointId': 12345, 'tester': 'Fred Smith',
'workItemProperties': [{'Key': 'System.Id', 'Value': 12345}, {'Key': 'System.Title', 'Value': 'Item Item'},
{'Key': 'System.IterationPath', 'Value': 'Path\Path'},
{'Key': 'System.ChangedDate', 'Value': '/Date(1554200489873)/'},
{'Key': 'System.ChangedBy', 'Value': 'Fred Smith'},
{'Key': 'Microsoft.VSTS.TCM.AutomationStatus', 'Value': 'Not Automated'}]}
df = json_normalize(data, "workItemProperties", ['lastRunDuration', 'tester', 'testPointId', 'lastResultState', 'configurationId', 'mostRecentRunId', 'suiteName', 'state', 'testCaseId', 'assignedTo', 'configurationName', 'suiteId', 'build', 'mostRecentResultOutcome', 'automated', 'outcome', 'lastRunBy'])
df["workItemProperties"] = df.pop("Key")
df.drop(["Value"], inplace=True, axis=1)
print(df)
</code></pre>
<p><strong>输出:</strong></p>
<pre><code> lastRunDuration mostRecentResultOutcome tester configurationId \
0 0 2 Fred Smith 123
1 0 2 Fred Smith 123
2 0 2 Fred Smith 123
3 0 2 Fred Smith 123
4 0 2 Fred Smith 123
5 0 2 Fred Smith 123
mostRecentRunId suiteName testCaseId lastResultState state suiteId \
0 1234 Name 12345 1 2 1234
1 1234 Name 12345 1 2 1234
2 1234 Name 12345 1 2 1234
3 1234 Name 12345 1 2 1234
4 1234 Name 12345 1 2 1234
5 1234 Name 12345 1 2 1234
build testPointId automated configurationName outcome assignedTo \
0 None 12345 Not Automated Package 1.0 Passed a5060ed2
1 None 12345 Not Automated Package 1.0 Passed a5060ed2
2 None 12345 Not Automated Package 1.0 Passed a5060ed2
3 None 12345 Not Automated Package 1.0 Passed a5060ed2
4 None 12345 Not Automated Package 1.0 Passed a5060ed2
5 None 12345 Not Automated Package 1.0 Passed a5060ed2
lastRunBy workItemProperties
0 System.Id
1 System.Title
2 System.IterationPath
3 System.ChangedDate
4 System.ChangedBy
5 Microsoft.VSTS.TCM.AutomationStatus
</code></pre>