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()