擅长:python、mysql、java
<pre><code>data = [
{
"a": "A1",
"b": "B1",
"c": [
{
"c1": "C111",
"c2": "C121",
"c3": ["C1131","C1132"]
}
]
},
{
"a": "A2",
"b": "B2",
"c": [
{
"c1": "C211",
"c2": "C212",
"c3": ["C2131","C2132"]
},
{
"c1": "C221",
"c2": "C222",
"c3": ["C2231"]
}
]
}
]
pd.io.json.json_normalize(data,"c", ['a', 'b',])
</code></pre>
<p>输出:</p>
<pre><code> c1 c2 c3 a b
0 C111 C121 [C1131, C1132] A1 B1
1 C211 C212 [C2131, C2132] A2 B2
2 C221 C222 [C2231] A2 B2
</code></pre>