擅长:python、mysql、java
<ul>
<li>使用OP中的<code>response</code></li>
<li>您必须创建另一个结构,因为<code>json_normalize</code>可用于词典列表,并且<code>fact</code>必须包含在其中:</li>
</ul>
<pre class="lang-py prettyprint-override"><code>new_response = [{"fact": rfact, **r} for rfact in response["fact"] for r in response["fact"][rfact]]
</code></pre>
<p>最后,您只需应用以下函数:</p>
<pre class="lang-py prettyprint-override"><code>final_result = pd.json_normalize(new_response)
fact SCODE SNAME
0 UP CNB Kanpur Central
1 UP JHS Jhansi Junction
2 MP BPL Bhopal Junction
3 MP JBP Jabalpur Junction
</code></pre>