python把数据变为数据框_python-将字典项转换为pandas数据框的行,其中...

您可以通过将键和值连接在一起来手动构建DataFrame的行,例如：

import pandas as pd

d = {("Sam", "Scotland", "23"): 25,

("Oli", "England", "23"): 28,

("Ethan", "Wales", "18"): 19}

df = pd.DataFrame([k + (v,) for k, v in d.items()], columns=['name', 'country', 'age', 'count'])

print(df)

输出量

name country age count

0 Ethan Wales 18 19

1 Sam Scotland 23 25

2 Oli England 23 28

或作为替代：

import pandas as pd

d = {("Sam", "Scotland", "23"): 25,

("Oli", "England", "23"): 28,

("Ethan", "Wales", "18"): 19}

df = pd.DataFrame(

[{"name": name, "country": country, "age": age, "count": value} for (name, country, age), value in d.items()])

print(df)

输出量

age count country name

0 23 28 England Oli

1 23 25 Scotland Sam

2 18 19 Wales Ethan

这个想法是将键值对转换成字典列表,然后将其传递给DataFrame.