擅长:python、mysql、java
<p>不如直接在字典中工作(选择的答案做得很好):</p>
<pre><code> data = {
"fact": {
"UP": [{
"SCODE": "CNB",
"SNAME": "Kanpur Central"
}, {
"SCODE": "JHS",
"SNAME": "Jhansi Junction"
}],
"MP": [{
"SCODE": "BPL",
"SNAME": "Bhopal Junction"
}, {
"SCODE": "JBP",
"SNAME": "Jabalpur Junction"
}]
}
}
keys = data['fact']
(pd.concat([jn(data['fact'][key]) for key in keys],
keys = keys)
.droplevel(-1)
.rename_axis(index='fact')
.reset_index()
)
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>