擅长:python、mysql、java
<ul>
<li>必须使用<code>pandas.json_normalize</code>的<code>record_path</code>和<code>meta</code>参数</李>
<li>然后,这些列将是动物,它们被堆叠成一列</李>
</ul>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
# test data
list_of_dicts = [{'name': 'a', 'counts': [{'dog': 2}]}, {'name': 'b', 'counts': [{'cat': 1}, {'capibara': 5}, {'whale': 10}]}, {'name': 'c', 'counts': [{'horse':1}, {'cat': 1}]}]
# load and transform the dataframe
pd.json_normalize(list_of_dicts, 'counts', 'name').set_index('name').stack().reset_index().rename(columns={'level_1': 'Animal', 0: 'Frequency'})
# display(df)
name Animal Frequency
0 a dog 2.0
1 b cat 1.0
2 b capibara 5.0
3 b whale 10.0
4 c horse 1.0
5 c cat 1.0
</code></pre>