python - 将字典列表转换为 pandas DataFrame

Question

如何将字典列表转换为 DataFrame？给定:

[{'points': 50, 'time': '5:00', 'year': 2010}, 
 {'points': 25, 'time': '6:00', 'month': "february"}, 
 {'points':90, 'time': '9:00', 'month': 'january'}, 
 {'points_h1':20, 'month': 'june'}]

我想把上面的变成一个DataFrame:

      month  points  points_h1  time  year
0       NaN      50        NaN  5:00  2010
1  february      25        NaN  6:00   NaN
2   january      90        NaN  9:00   NaN
3      june     NaN         20   NaN   NaN

注意:列的顺序无关紧要。

Answer 1

如果 ds 是 dicts 的列表:

df = pd.DataFrame(ds)

注意:这不适用于嵌套数据。