pandas.json_normalize の逆 - Qiita

import functools import pandas as pd def denormalize_json(df, sep="."): def _denormalize_series(sr): result = dict() def _default_dict(acc, x): if x not in acc: acc[x] = dict() return acc[x] for k, v in sr.items(): p = k.split(sep) d = functools.reduce(_default_dict, p[:-1], result) if not pd.isna(v): d[p[-1]] = v return result return [ _denormalize_series(sr) for _, sr in df.iterrows() ] In [2]: