from flatten_json import flatten dic_flattened = (flatten(d, '.') for d in test_json['result']) df = pd.DataFrame(dic_flattened) df.shape (5, 160)