python将一组数据转化为列表_python-将列表从大量字典转换为数据框的问...

我以这种方式创建了一个字典：

数据如下所示：

GDS3:

ABC_1 ABC_2 BBB_1

cat elf 123

dog run 456

bird burp 789

GDS4:

ABC_3 ABC_4 BCB_a

beer yes 234

wine no 543

gin yes 743

GDS5:

ABC_5 ABC_6 BCD_c

lol yea 543

lmao NaN 446

asl NaN 777

#create a dictionary in which all columns that start with the same 3 characters will be grouped in the same key.

dict_2013 = {k: g for k, g in GDS3.groupby(by=lambda x: x[:3].lower(), axis=1)}

dict_2014 = {k: g for k, g in GDS4.groupby(by=lambda x: x[:3].lower(), axis=1)}

dict_2015 = {k: g for k, g in GDS5.groupby(by=lambda x: x[:3].lower(), axis=1)}

#start with year 2013:

global_dict=dict_2013

#if key in the new dictionary is in the old dictionary then

#add the values from the new dictionary key to the old dictionary key

#else if the new dictionary key does not exist in the old dictionary then add a new key with the new values

for key,val in dict_2014.items():

if key in global_dict:

global_dict[key]=[global_dict[key],val]

else:

global_dict[key]=val

for key,val in dict_2015.items():#to add items

if key in global_dict:

global_dict[key]=[global_dict[key],val]

else:

global_dict[key]=val

这是我想要的输出(每个键的数据框)

df_ABC:

ABC_1 ABC_2 ABC_3 ABC_4 ABC_5

cat elf beer yes lol

dog run win no lmao

bird burp gin yes asl

df_BBB:

BBB_1

cat

dog

bird

换句话说,我想将单个键转换为单个字典(对于所有键),因此我尝试了以下操作：

ABC_dataframe=pd.DataFrame(global_dict['ABC'])

当我这样做时,出现以下错误：

TypeError: Expected list, got DataFrame

这很奇怪,因为global_dict [‘ABC’]是一个列表. (我使用type(global_dict [‘ABC’]检查了).

我该怎么做才能纠正这个问题？我尝试拼合列表,但仍然遇到问题.