我以这种方式创建了一个字典:
数据如下所示:
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 d