python规范化字符串,Python:json规范化“字符串索引必须为整数"错误

I am getting a type error as "TypeError: string indices must be integers" in the following code.

import pandas as pd

import json

from pandas.io.json import json_normalize

full_json_df = pd.read_json('data/world_bank_projects.json')

json_nor = json_normalize(full_json_df, 'mjtheme_namecode')

json_nor.groupby('name')['code'].count().sort_values(ascending=False).head(10)

Output:

TypeError

Traceback (most recent call last)

in ()

1 # Find the top 10 major project themes (using column 'mjtheme_namecode')

2

----> 3 json_nor = json_normalize(full_json_df, 'mjtheme_namecode')

4 #json_nor.groupby('name')['code'].count().sort_values(ascending = False).head(10)

TypeError: string indices must be integers

解决方案

According to pandas documentation, for data argument of the method json_normalize :

data : dict or list of dicts Unserialized JSON objects

In above, pd.read_json returns dataframe.

So, you can try converting dataframe to dictionary using .to_dict(). There are various options for using to_dict() as well.

May be something like below:

json_normalize(full_json_df.to_dict(), ......)