这个函数用于提取多个列表的共同元素 def extra_same_elem(list1, list2): set1 = set(list1) set2 = set(list2) iset = set1.intersection(set2) return iset #这个函数用于提取多个列表的共同元素 def extra_same_elem1(lst, *lsts): iset = set(lst) for li in lsts: s = set(li) iset = iset.intersection(s) return list(iset) #两个cell相等,取出右边的单元格内容放入 def get_target_value(src_dict,tar_dict): #源数据放入字典src_dict for key1,value1 in src_dict.item(): for key2,value2 in tar_dict.item(): if value1==value2: tar_dict[key2+1]