使用多个长度和长度不同的值(列表)的字典从字典中创建一个 pandas DataFrame [英] Creating a panda DataFrame from dictionary with multiple keys and value (list) of different lengths

问题描述

我有一个字典，其中包含多个键(其值(列表)的长度不同).我想将它们读入 Pandas DataFrame.我希望键是列名，值是我的行.假设我有一本具有多个键的字典，我尝试过:

I have a dictionary of with multiple keys with values(list) that do not have the same length. I would like to read them into a pandas DataFrame.I would like the keys to be the column names and the values to be my rows. Assuming that I have a dictionary with multiple keys, I tried:

dict
df=pd.from_dict(dict,orient="columns")

但是还是不行.我可以有什么选择?

But it does not still work. What alternative can I have?

推荐答案

使用情况:

import pandas as pd 
dataframe1 = pd.DataFrame(dict([(k,pd.Series(v)) for k,v in my_dict.iteritems()]))  

其中 my_dict 是您当前的字典.

这篇关于使用多个长度和长度不同的值(列表)的字典从字典中创建一个 pandas DataFrame的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！