擅长:python、mysql、java
<pre><code>json = {
"data": {
"docs": [
{
"id": "1",
"col1": "foo",
"col2": "123",
"list": ["foo barr, fooo"]
},
{
"id": "2",
"col1": "abc",
"col2": "321",
"list": ["lirum epsum"]
},
{
"id": "3",
"col1": "foo",
"col2": "123",
"list": np.nan
},
]
}
}
pd.DataFrame(json["data"]["docs"]).set_index("id")
</code></pre>
<p>给你</p>
<pre><code> id col1 col2 list
1 foo 123 [foo barr, fooo]
2 abc 321 [lirum epsum]
3 foo 123 NaN
</code></pre>