for index, row in df2.iterrows():
if pandas.isna(row['单位']):
if pandas.notna(row['共享系统开票提单编号']):
key = row['共享系统开票提单编号']
if key in data_dict:
values = data_dict[key]
for col in range(2, 14 + 1):
col_name = chr(64 + col)
df2.at[index,col_name] = values[col - 2]
else:
print('key not in data_dict')