csv 将字典转换为数据框Pandas

jtjikinw  于 2022-12-25  发布在  其他
关注(0)|答案(2)|浏览(147)

我有多个dict as数组,要将其转换为 Dataframe

df= [{'Federal-gov': 0, 'Local-gov': 1, 'Never-worked': 2},
{'Divorced': 0, 'Married-AF-spouse': 1, 'Married-civ-spouse': 2, 'Married-spouse-absent': 3, 'Never-married': 4, 'Separated': 5, 'Widowed': 6}]

我想用这个做个这样的table

Federalgov 0
Local-gov 1
Never-worked 2
.
.
.
.
separeted 5
widowed 6

我试过这个

df.dropna()
df.head()
5ssjco0h

5ssjco0h1#

bfill填充Nan值,然后用transpose It填充。

df =  pd.DataFrame(df)
df= df.fillna(method="bfill")
df = df.dropna(how='any').T.astype(int)
print(df)

产出

Federal-gov            0
Local-gov              1
Never-worked           2
Divorced               0
Married-AF-spouse      1
Married-civ-spouse     2
Married-spouse-absent  3
Never-married          4
Separated              5
Widowed                6
>>>
zfycwa2u

zfycwa2u2#

试试看:

df = pd.DataFrame(item for rec in dicts for item in rec.items())

示例dicts的结果

dicts = [
    {'Federal-gov': 0, 'Local-gov': 1, 'Never-worked': 2},
    {'Divorced': 0, 'Married-AF-spouse': 1, 'Married-civ-spouse': 2, 'Married-spouse-absent': 3, 'Never-married': 4, 'Separated': 5, 'Widowed': 6}
]

0  1
0            Federal-gov  0
1              Local-gov  1
2           Never-worked  2
3               Divorced  0
4      Married-AF-spouse  1
5     Married-civ-spouse  2
6  Married-spouse-absent  3
7          Never-married  4
8              Separated  5
9                Widowed  6

如果要将dicts的键作为索引:
一个三个三个一个

相关问题