wos中国家字段处理
一般主要是处理国家:
1、所有国家字段:
1)按照[分列C1字段;
2)提取所有国别公式:
=IF(B1="","",IFERROR(MID(F2,FIND("@",SUBSTITUTE(F2,",","@",LEN(F2)-LEN(SUBSTITUTE(F2,",",""))))+1,LEN(F2)),""))
之前只提取国家,有空白后就会停掉,if函数可以直接去掉空白,不用一个个去下拉空白区域了;
3)
=IF(A2<>"",A2&",","")&IF(B2<>"",B2&",","")
4)把数据组合成
20=[“Germany”,“Peoples R China”,“Peoples R China”,“Germany”,“Germany”,“Peoples R China”,“USA”]
print(list(set(20)))
就会变为去重后的数据,例如:
a=[“1”,“3”,“4”,“2”,“3”]
会变为:
a=[“1”,“2”,“3”,“4”]
数据组合方法二:
import re
list1=[“South Korea”, “South Korea”]
list2=[]
for