JSON データをDataframeに変換
pandas.json_normalize https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.json_normalize.html
Quick Tutorial: Flatten Nested JSON in Pandas https://www.kaggle.com/jboysen/quick-tutorial-flatten-nested-json-in-pandas
"dot notation" or "bracket notation"
Should you use "dot notation" or "bracket notation" with pandas? https://www.dataschool.io/pandas-dot-notation-vs-brackets/
json_normalizeを使用してjsonをネストされた配列で正規化するhttps://www.366service.com/jp/qa/cf3641157b7e0a13f1f4b1d9c384428f
サンプルコード
import pandas as pd data = [ { "col1": "value1_col1", "col2": { "col2-1": "value1_col2-1", }, "col3": [ { "col3-1": "value1_col3-1", "col3-2": "value1_col3-2" } ] }, { "col1": "value2_col1", "col2": { "col2-1": "value2_col2-1", }, "col3": [ { "col3-1": "value2_col3-1", "col3-2": "value2_col3-2" } ] }, ] result = pd.json_normalize( data, max_level=5, record_path='col3', meta=[ 'col1', 'col2', ] ) # 集計 result['col3-1'].value_counts()