flat one-line json to pandas datafame
Solution 1:
Use pd.json_normalize:
import pandas as pd
import json
with open('data.json') as fp:
d = json.load(fp)
df = pd.json_normalize(d)
Output
>>> df
ranking real_name aggregate thirdparty notes
0 11.1 Robert 3 none