entityLink.py 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820
  1. #coding:UTF8
  2. '''
  3. Created on 2019年5月21日
  4. @author: User
  5. '''
  6. import re
  7. import os
  8. import time
  9. import pandas as pd
  10. _time = time.time()
  11. from BiddingKG.dl.common.Utils import *
  12. from BiddingKG.dl.interface.Entitys import *
  13. import json
  14. from BiddingKG.dl.common.constDict import ConstDict
  15. def edit_distance(source,target):
  16. dp = [["" for i in range(len(source)+1)] for j in range(len(target)+1)]
  17. for i in range(len(dp)):
  18. for j in range(len(dp[i])):
  19. if i==0:
  20. dp[i][j] = j
  21. elif j==0:
  22. dp[i][j] = i
  23. else:
  24. if source[j-1]==target[i-1]:
  25. cost = 0
  26. else:
  27. cost = 2
  28. dp[i][j] = min([dp[i-1][j]+1,dp[i][j-1]+1,dp[i-1][j-1]+cost])
  29. return dp[-1][-1]
  30. def jaccard_score(source,target):
  31. source_set = set([s for s in source])
  32. target_set = set([s for s in target])
  33. if len(source_set)==0 or len(target_set)==0:
  34. return 0
  35. return max(len(source_set&target_set)/len(source_set),len(source_set&target_set)/len(target_set))
  36. def get_place_list():
  37. path = os.path.dirname(__file__) + '/../place_info.csv'
  38. place_df = pd.read_csv(path)
  39. place_list = []
  40. for index, row in place_df.iterrows():
  41. place_list.append(row[1])
  42. place_list.append('台湾')
  43. place_list.append('澳门')
  44. place_list.append('香港')
  45. # place_list.append('東莞')
  46. # place_list.append('廣州')
  47. # place_list.append('韩国')
  48. # place_list.append('德国')
  49. # place_list.append('英国')
  50. # place_list.append('日本')
  51. # place_list.append('意大利')
  52. # place_list.append('新加坡')
  53. # place_list.append('加拿大')
  54. # place_list.append('西班牙')
  55. # place_list.append('澳大利亚')
  56. # place_list.append('美国')
  57. place_list = list(set(place_list))
  58. return place_list
  59. place_list = get_place_list()
  60. place_pattern = "|".join(place_list)
  61. def is_short(shorter_cut, longer):
  62. '''
  63. 判断是否为简称
  64. :param shorter_cut: 简称
  65. :param longer: 全称
  66. :return:
  67. '''
  68. flag = 1
  69. for words in shorter_cut:
  70. if words in longer:
  71. longer = longer[longer.find(words) + len(words):]
  72. else:
  73. flag = 0
  74. break
  75. if flag:
  76. return 1
  77. else:
  78. return 0
  79. def get_business_data(enterprise_name):
  80. '''
  81. 获取指定公司名称是否有工商数据,有就返回True及相关招投标数据,没有返回False及{}
  82. :param enterprise_name: 公司名称
  83. :return:
  84. '''
  85. global ENTERPRISE_HUGE,SET_ENTERPRISE,POOL_REDIS
  86. # print("test",enterprise_name)
  87. if ENTERPRISE_HUGE:
  88. if POOL_REDIS is None:
  89. init_redis_pool()
  90. _db = POOL_REDIS.getConnector()
  91. try:
  92. _time = time.time()
  93. _v = _db.get(enterprise_name)
  94. POOL_REDIS.putConnector(_db)
  95. if _v is None:
  96. return False, {}
  97. else:
  98. _v = str(_v, 'utf-8')
  99. if 'have_business' in _v:
  100. # log("redis take %.5f of '%s' exists"%(time.time()-_time,enterprise_name))
  101. d = json.loads(_v)
  102. if d.get('have_business', '') == 1:
  103. return True, d
  104. return False, d
  105. else:
  106. return False, {}
  107. except Exception as e:
  108. traceback.print_exc()
  109. return False, {}
  110. else:
  111. if enterprise_name in SET_ENTERPRISE:
  112. return True, {}
  113. else:
  114. return False, {}
  115. def get_role(dic):
  116. '''
  117. 通过字典统计 招标、代理、中标公告数量 返回最大比例及对应类别
  118. :param dic: redics 获取实体的工商数据字典
  119. :return:
  120. '''
  121. if 'zhao_biao_number' in dic:
  122. zhaobiao = dic.get('zhao_biao_number', 0)
  123. daili = dic.get('dai_li_number', 0)
  124. zhongbiao = dic.get('zhong_biao_number', 0)
  125. bid = zhaobiao+ daili+ zhongbiao
  126. if bid > 100: # 总数大于100的才统计
  127. if zhaobiao>=daili:
  128. if zhaobiao>=zhongbiao:
  129. return 0, zhaobiao/bid
  130. else:
  131. return 2, zhongbiao/bid
  132. elif daili >= zhongbiao:
  133. return 1, daili/bid
  134. else:
  135. return 2, zhongbiao/bid
  136. return 5, 0
  137. def link_entitys(list_entitys,on_value=1):#on_value=0.81
  138. business_dic = {}
  139. for list_entity in list_entitys:
  140. range_entity = []
  141. short_entity = [] # 不包含工商数据实体
  142. long_entity = [] # 包含工商数据实体
  143. n = 0
  144. bus_dic = {} # 保存已查询包含工商数据实体 属于招标、代理、中标 何种类别及对应概率
  145. find_tenderee = False
  146. bus_tenderee = []
  147. for _entity in list_entity:
  148. if _entity.entity_type in ["org","company"]:
  149. ser = re.search('(?P<name>.{2,}(医院|大学|公司))(招[投议]?标|采购)(中心|办公室)$', _entity.entity_text) # 2024-06-07 规范单位名称,去除非必要字眼
  150. if ser:
  151. _entity.entity_text = ser.group('name')
  152. range_entity.append(_entity)
  153. if _entity.entity_text in bus_dic:
  154. have_bus = True
  155. else:
  156. if _entity.entity_text not in business_dic:
  157. have_bus, dic = get_business_data(_entity.entity_text)
  158. business_dic[_entity.entity_text] = (have_bus, dic)
  159. else:
  160. have_bus, dic = business_dic.get(_entity.entity_text) # 20240708 字典保存查询过的工商数据,避免重复查询redis
  161. if re.search('^\w{,5}[分支](行|公司)$|^\w{1,3}公司$|^\w{2,5}段$', _entity.entity_text):
  162. have_bus = False
  163. if have_bus:
  164. lb, prob = get_role(dic)
  165. bus_dic[_entity.entity_text] = (lb, prob)
  166. if lb == 0 and prob > 0.9 and re.search('医院|学院|学校|中学|小学|大学|中心|幼儿园|保健院|党校|研究院|血站|分校|红十字会|防治院|研究所', _entity.entity_text) and _entity.entity_text not in ['中华人民共和国', '营业执照', '人民法院','民办非企业单位','个体工商户','运输服务', '社会团体']:
  167. bus_tenderee.append(_entity)
  168. elif re.search('^\w{2,6}银行\w{2,10}[分支]行$', _entity.entity_text): # 2024/05/22 补充某些支行没收集到工商数据
  169. have_bus = True
  170. bus_dic[_entity.entity_text] = (0, 0.5)
  171. if have_bus: # 20231115 改为只判断是否有工商数据,没有就考虑替换
  172. long_entity.append(_entity)
  173. if len(_entity.entity_text)< 6 and re.search('(大学|医院)', _entity.entity_text) == None:
  174. short_entity.append(_entity)
  175. lb, prob = bus_dic[_entity.entity_text]
  176. if lb in [0,1] and prob>0.9 and _entity.label in [0, 1] and _entity.values[_entity.label]<0.55: # 如果工商统计概率较高,文中概率较低,换为统计类别,主要为标题及发布人等招标、代理划分不明确情况
  177. if _entity.label != lb:
  178. _entity.label = lb
  179. _entity.values[_entity.label] = 0.55
  180. else:
  181. _entity.values[_entity.label] += 0.05
  182. else:
  183. short_entity.append(_entity)
  184. if _entity.label == 0: # 找到招标人
  185. find_tenderee = True
  186. n += 1
  187. if n > 1000:
  188. break
  189. if find_tenderee == False and len(bus_tenderee)==1 and bus_tenderee[0].label==5: # 如果整篇都没招标人,工商统计只有一个高概率招标人把它作为招标人
  190. bus_tenderee[0].label = 0
  191. bus_tenderee[0].values[0] = 0.55
  192. range_entity = range_entity[:1000]
  193. #替换公司的逻辑有问题,先取消
  194. # for first_i in range(len(range_entity)):
  195. # _entity = range_entity[first_i]
  196. # for second_i in range(first_i+1,len(range_entity)):
  197. # _ent = range_entity[second_i]
  198. # # 2021/5/21 update: 两个实体标签互斥(一个是招标人、一个是代理人)且entity_text不相等时,跳过
  199. # if _entity.entity_text != _ent.entity_text and _entity.label != _ent.label and _entity.label in [0,1] and _ent.label in [0, 1]:
  200. # continue
  201. # _score = jaccard_score(re.sub("%s|%s"%("股份|责任|有限|公司",place_pattern),"",_entity.entity_text), re.sub("%s|%s"%("股份|责任|有限|公司",place_pattern),"",_ent.entity_text))
  202. # if _entity.entity_text!=_ent.entity_text and _score>=on_value:
  203. # _entity.linked_entitys.append(_ent)
  204. # _ent.linked_entitys.append(_entity)
  205. # print("=-===",_entity.entity_text,_ent.entity_text,_score)
  206. # #替换公司名称
  207. # for _entity in range_entity:
  208. # if re.search("公司",_entity.entity_text) is None:
  209. # for _ent in _entity.linked_entitys:
  210. # if re.search("公司$",_ent.entity_text) is not None:
  211. # if len(_ent.entity_text)>len(_entity.entity_text):
  212. # _entity.entity_text = _ent.entity_text
  213. if short_entity and long_entity: #
  214. for first_i in range(len(short_entity)):
  215. _entity = short_entity[first_i]
  216. if _entity.label == 0:
  217. for second_i in range(len(long_entity)):
  218. _ent = long_entity[second_i]
  219. if _ent.label in [0,1,5]:
  220. if len(_entity.entity_text)<len(_ent.entity_text) and is_short(_entity.entity_text, _ent.entity_text): # 简称顺序包含在工商名称内的替换
  221. if _entity.entity_text.endswith('大学'): # 修复 533357339 东北大学 替换为 中国银行沈阳东北大学支行
  222. continue
  223. _entity.entity_text = _ent.entity_text
  224. lb, prob = bus_dic[_entity.entity_text]
  225. if lb in [0, 1] and prob > 0.9 and _entity.values[
  226. _entity.label] < 0.55: # 如果工商统计概率较高,文中概率较低,换为统计类别,主要为标题及发布人等招标、代理划分不明确情况
  227. if _entity.label != lb:
  228. _entity.label = lb
  229. _entity.values[_entity.label] = 0.55
  230. else:
  231. _entity.values[_entity.label] += 0.05
  232. break
  233. elif len(_entity.entity_text)>len(_ent.entity_text) and _ent.entity_text in _entity.entity_text \
  234. and re.search('(医院|大学)$', _ent.entity_text) and re.search('[部处室科]$', _entity.entity_text): # 不包含工商数据实体完全包含工商数据实体名称的替换 20240520调整限定部门结尾才替换,防止出错
  235. _entity.entity_text = _ent.entity_text
  236. lb, prob = bus_dic[_entity.entity_text]
  237. if lb in [0, 1] and prob > 0.9 and _entity.values[
  238. _entity.label] < 0.55: # 如果工商统计概率较高,文中概率较低,换为统计类别,主要为标题及发布人等招标、代理划分不明确情况
  239. if _entity.label != lb:
  240. _entity.label = lb
  241. _entity.values[_entity.label] = 0.55
  242. else:
  243. _entity.values[_entity.label] += 0.05
  244. break
  245. # 2021/12/21 替换通过字典识别到的取长度最大的相似实体
  246. for _entity in range_entity:
  247. used_linked_entitys = []
  248. if not _entity.linked_entitys:
  249. continue
  250. _entity.linked_entitys.sort(key=lambda x: len(x.entity_text), reverse=True)
  251. for _ent in _entity.linked_entitys:
  252. if _ent in used_linked_entitys:
  253. break
  254. # print("_entity, _ent", _entity.entity_text, _ent.if_dict_match, _ent.entity_text)
  255. if _ent.if_dict_match == 1:
  256. if len(_ent.entity_text) > len(_entity.entity_text):
  257. # 判断两个公司地区相同
  258. match_list_1, match_list_2 = [], []
  259. for place in place_list:
  260. if place in _entity.entity_text:
  261. match_list_1.append(place)
  262. if place in _ent.entity_text:
  263. match_list_2.append(place)
  264. if str(match_list_1) == str(match_list_2):
  265. # print("字典替换", _entity.entity_text, "->", _ent.entity_text)
  266. _entity.origin_entity_text = _entity.entity_text
  267. _entity.entity_text = _ent.entity_text
  268. used_linked_entitys.append(_ent)
  269. # print(_entity.entity_text, _entity.if_dict_match, _ent.entity_text, _ent.if_dict_match)
  270. # 用于去重的标题
  271. def doctitle_refine(doctitle):
  272. _doctitle_refine = re.sub(r'工程|服务|询价|比价|谈判|竞争性|磋商|结果|中标|招标|采购|的|公示|公开|成交|公告|评标|候选人|'
  273. r'交易|通知|废标|流标|终止|中止|一笔|预告|单一来源|竞价|合同', '', doctitle)
  274. return _doctitle_refine
  275. # 前100个公司实体
  276. def get_nlp_enterprise(list_entity):
  277. nlp_enterprise = []
  278. nlp_enterprise_attachment = []
  279. dict_enterprise = {}
  280. business_dic = {}
  281. max_num = 100
  282. list_entity = sorted(list_entity,key=lambda x:(x.sentence_index,x.begin_index))
  283. for entity in list_entity:
  284. if entity.entity_type in ['org','company']:
  285. if entity.entity_text not in dict_enterprise:
  286. if entity.entity_text not in business_dic:
  287. have_bus, dic = get_business_data(entity.entity_text)
  288. business_dic[entity.entity_text] = (have_bus, dic)
  289. else:
  290. have_bus, dic = business_dic.get(entity.entity_text) # 20240708 字典保存查询过的工商数据,避免重复查询redis
  291. credit_code = dic.get('credit_code', '')
  292. in_text = 0 if entity.in_attachment else 1
  293. if entity.label in [0,1,2,3,4] or len(dict_enterprise)<=max_num:
  294. dict_enterprise[entity.entity_text] = {'in_text': in_text}
  295. if credit_code != "":
  296. dict_enterprise[entity.entity_text]['credit_code'] = credit_code
  297. else:
  298. in_text = 0 if entity.in_attachment else 1
  299. if in_text != dict_enterprise[entity.entity_text]['in_text']:
  300. dict_enterprise[entity.entity_text]['in_text'] = 2
  301. if not entity.in_attachment:
  302. if entity.entity_text not in nlp_enterprise:
  303. nlp_enterprise.append(entity.entity_text)
  304. else:
  305. if entity.entity_text not in nlp_enterprise_attachment:
  306. nlp_enterprise_attachment.append(entity.entity_text)
  307. return nlp_enterprise[:max_num],nlp_enterprise_attachment[:max_num], dict_enterprise
  308. ENTERPRISE_HUGE = None
  309. def getEnterprisePath():
  310. global ENTERPRISE_HUGE
  311. filename_huge = "LEGAL_ENTERPRISE_HUGE.txt"
  312. huge_path = getFileFromSysPath(filename_huge)
  313. if huge_path is None:
  314. if os.path.exists(filename_huge):
  315. log("enterprise path:%s"%(filename_huge))
  316. ENTERPRISE_HUGE = True
  317. return filename_huge,ENTERPRISE_HUGE
  318. else:
  319. log("enterprise path:%s"%(huge_path))
  320. ENTERPRISE_HUGE = True
  321. return huge_path,ENTERPRISE_HUGE
  322. filename = "LEGAL_ENTERPRISE.txt"
  323. real_path = getFileFromSysPath(filename)
  324. if real_path is None:
  325. real_path = filename
  326. log("ENTERPRISE path:%s"%(real_path))
  327. ENTERPRISE_HUGE = False
  328. return real_path,ENTERPRISE_HUGE
  329. DICT_ENTERPRISE_DONE = False
  330. POOL_REDIS = None
  331. ENTERPRISE_KEY_LEN = 3
  332. ENTERPRISE_PREFIX_LEN = 3
  333. ENTERPRISE_TAIL_LEN = 3
  334. SET_ENTERPRISE = set()
  335. SET_PREFIX_ENTERPRISE = set()
  336. SET_TAIL_ENTERPRISE = set()
  337. SET_PREFIX_ENTERPRISE_HUGE_FILE = "SET_PREFIX_ENTERPRISE_HUGE.pk"
  338. SET_TAIL_ENTERPRISE_HUGE_FILE = "SET_TAIL_ENTERPRISE_HUGE.pk"
  339. def getDict_enterprise():
  340. global DICT_ENTERPRISE_DONE,SET_ENTERPRISE,SET_PREFIX_ENTERPRISE,SET_TAIL_ENTERPRISE
  341. real_path,is_huge = getEnterprisePath()
  342. _ok = False
  343. if is_huge:
  344. if os.path.exists(SET_PREFIX_ENTERPRISE_HUGE_FILE) and os.path.exists(SET_TAIL_ENTERPRISE_HUGE_FILE):
  345. SET_PREFIX_ENTERPRISE = load(SET_PREFIX_ENTERPRISE_HUGE_FILE)
  346. SET_TAIL_ENTERPRISE = load(SET_TAIL_ENTERPRISE_HUGE_FILE)
  347. _ok = True
  348. if not _ok:
  349. with open(real_path,"r",encoding="UTF8") as f:
  350. for _e in f:
  351. if not _e:
  352. continue
  353. _e = _e.strip()
  354. if len(_e)>=4:
  355. key_enter = _e[:ENTERPRISE_KEY_LEN]
  356. SET_PREFIX_ENTERPRISE.add(key_enter)
  357. SET_TAIL_ENTERPRISE.add(_e[-ENTERPRISE_TAIL_LEN:])
  358. if not is_huge:
  359. SET_ENTERPRISE.add(_e)
  360. #仅在大文件情况下才使用缓存加载
  361. if is_huge:
  362. save(SET_PREFIX_ENTERPRISE,SET_PREFIX_ENTERPRISE_HUGE_FILE)
  363. save(SET_TAIL_ENTERPRISE,SET_TAIL_ENTERPRISE_HUGE_FILE)
  364. log("SET_PREFIX_ENTERPRISE takes memory:%.2fM size:%d"%(sys.getsizeof(SET_PREFIX_ENTERPRISE)/1024/1024,len(SET_PREFIX_ENTERPRISE)))
  365. log("SET_TAIL_ENTERPRISE takes memory:%.2fM size:%d"%(sys.getsizeof(SET_TAIL_ENTERPRISE)/1024/1024,len(SET_TAIL_ENTERPRISE)))
  366. log("SET_ENTERPRISE takes memory:%.2fM size:%d"%(sys.getsizeof(SET_ENTERPRISE)/1024/1024,len(SET_ENTERPRISE)))
  367. # for _e in ["河南省柘源","建筑工程有限公司"]:
  368. # if not _e:
  369. # continue
  370. # _e = _e.strip()
  371. # if len(_e)>=4:
  372. # key_enter = _e[:4]
  373. # if key_enter not in DICT_ENTERPRISE:
  374. # DICT_ENTERPRISE[key_enter] = set()
  375. # DICT_ENTERPRISE[key_enter].add(_e[4:])
  376. DICT_ENTERPRISE_DONE = True
  377. def init_redis_pool():
  378. from BiddingKG.dl.common.pool import ConnectorPool
  379. from BiddingKG.dl.common.source import getConnect_redis_baseline
  380. global POOL_REDIS
  381. if POOL_REDIS is None:
  382. POOL_REDIS = ConnectorPool(init_num=1,max_num=10,method_init=getConnect_redis_baseline)
  383. # 插入 Redis
  384. # def add_redis(company_list):
  385. # global ENTERPRISE_HUGE,POOL_REDIS
  386. # if ENTERPRISE_HUGE:
  387. # _db = POOL_REDIS.getConnector()
  388. # for enterprise_name in company_list:
  389. # _v = _db.get(enterprise_name)
  390. # if _v is None:
  391. # if isLegalNewName(enterprise_name):
  392. # _db.set(enterprise_name,1)
  393. # 新实体合法判断
  394. def isLegalNewName(enterprise_name):
  395. # head_character_list = ["[",'【',"(",'(']
  396. # tail_character_list = ["]",'】',")",')']
  397. # 名称开头判断
  398. if re.search("^[\da-zA-Z][^\da-zA-Z]|"
  399. "^[^\da-zA-Z\u4e00-\u9fa5\[【((]|"
  400. "^[\[【((].{,1}[\]】))]|"
  401. "^[0〇]|"
  402. "^(20[0-2][0-9]|[0-2]?[0-9]年|[0-1]?[0-9]月|[0-3]?[0-9]日)",enterprise_name):
  403. return -1
  404. if len(re.findall("[\u4e00-\u9fa5]",enterprise_name))<2:
  405. return -1
  406. if re.search("╳|*|\*|×|xx|XX",enterprise_name):
  407. return -1
  408. if re.search("^(省|自治[县州区]|市|县|区|镇|乡|街道)",enterprise_name) and not re.search("^(镇江|乡宁|镇原|镇海|镇安|镇巴|镇坪|镇赉|镇康|镇沅|镇雄|镇远|镇宁|乡城|镇平|市中|市南|市北)",enterprise_name):
  409. return -1
  410. if re.search("\d{1,2}:\d{2}(:\d{2})?|(rar|xlsx|zip|png|jpg|swf|docx|txt|pdf|PDF|doc|xls|bmp|&?nbsp)",enterprise_name):
  411. return -1
  412. if re.search("(招标|代理)(人|机构)|联系(人|方式)|中标|候选|第.名",enterprise_name):
  413. return -1
  414. if re.search("[a-zA-Z\d]{1,2}(包|标段?)|第.批"):
  415. return 0
  416. return 1
  417. # 过滤掉Redis里值为0的错误实体
  418. def enterprise_filter(entity_list):
  419. global ENTERPRISE_HUGE,SET_ENTERPRISE,POOL_REDIS
  420. if ENTERPRISE_HUGE:
  421. if POOL_REDIS is None:
  422. init_redis_pool()
  423. _db = POOL_REDIS.getConnector()
  424. remove_list = []
  425. try:
  426. for entity in entity_list:
  427. if entity.entity_type in ['company','org']:
  428. _v = _db.get(entity.entity_text)
  429. if _v==0:
  430. remove_list.append(entity)
  431. except Exception as e:
  432. traceback.print_exc()
  433. POOL_REDIS.putConnector(_db)
  434. for _entity in remove_list:
  435. entity_list.remove(_entity)
  436. return entity_list
  437. def is_enterprise_exist(enterprise_name):
  438. global ENTERPRISE_HUGE,SET_ENTERPRISE,POOL_REDIS
  439. # print("test",enterprise_name)
  440. if ENTERPRISE_HUGE:
  441. if POOL_REDIS is None:
  442. init_redis_pool()
  443. _db = POOL_REDIS.getConnector()
  444. try:
  445. _time = time.time()
  446. _v = _db.get(enterprise_name)
  447. POOL_REDIS.putConnector(_db)
  448. if _v is None:
  449. return False
  450. else:
  451. if _v:
  452. # log("redis take %.5f of '%s' exists"%(time.time()-_time,enterprise_name))
  453. return True
  454. else:
  455. return False
  456. except Exception as e:
  457. traceback.print_exc()
  458. return False
  459. else:
  460. if enterprise_name in SET_ENTERPRISE:
  461. return True
  462. else:
  463. return False
  464. import threading
  465. import time
  466. load_enterprise_thread = threading.Thread(target=getDict_enterprise)
  467. load_enterprise_thread.start()
  468. MAX_ENTERPRISE_LEN = 30
  469. def match_enterprise_max_first(sentence, business_dic):
  470. while True:
  471. if not DICT_ENTERPRISE_DONE:
  472. time.sleep(1)
  473. else:
  474. break
  475. list_match = []
  476. begin_index = 0
  477. if len(sentence)>4:
  478. while True:
  479. if begin_index+ENTERPRISE_KEY_LEN<len(sentence):
  480. key_enter = sentence[begin_index:begin_index+ENTERPRISE_KEY_LEN]
  481. if key_enter.find(',') > 0:
  482. key_enter = sentence[begin_index:begin_index + ENTERPRISE_KEY_LEN+1].replace(',', '') # 20241212 修复实体名称被分割问题 例:北,京千里马网信科技有限公司
  483. # if key_enter in DICT_ENTERPRISE:
  484. # _len = min(MAX_ENTERPRISE_LEN-ENTERPRISE_KEY_LEN+1,len(sentence)-begin_index)
  485. # for _i in range(_len):
  486. # enter_name = sentence[begin_index+ENTERPRISE_KEY_LEN:begin_index+_len-_i]
  487. # if enter_name in DICT_ENTERPRISE[key_enter]:
  488. # match_item = {"entity_text":"%s%s"%(key_enter,enter_name),"begin_index":begin_index,"end_index":begin_index+len(key_enter)+len(enter_name)}
  489. # list_match.append(match_item)
  490. # begin_index += (len(key_enter)+len(enter_name))-1
  491. # break
  492. if key_enter in SET_PREFIX_ENTERPRISE:
  493. _len = min(MAX_ENTERPRISE_LEN-ENTERPRISE_KEY_LEN+1,len(sentence)-begin_index)
  494. for _i in range(_len):
  495. enter_name = sentence[begin_index:begin_index+_len-_i]
  496. if enter_name.endswith(','):
  497. continue
  498. fix_name = enter_name.replace(',', '') # 20241212 修复实体名称被分割问题 例:北,京千里马网信科技有限公司
  499. enter_tail = fix_name[-ENTERPRISE_TAIL_LEN:]
  500. if re.search('[\u4e00-\u9fa5]', enter_tail) == None: # 20240111不包含中文后缀不要
  501. continue
  502. elif fix_name in ['黄埔军校', '五金建材', '铝合金门窗', '测试单位' ,'生产管理部', '华电XXX发电有限公司']: # '国有资产管理处',
  503. continue
  504. elif re.search('^\w{,3}(有限)?(责任)?分?公司$|^第[一二三四五六七八九十](工程|建筑)?分?公司$|交汇处$|大厦$|大楼$|^华电X{1,4}发电有限公司$', fix_name):
  505. continue
  506. if len(fix_name)<4: # 20240521 短于4个字的不要
  507. break
  508. if enter_tail in SET_TAIL_ENTERPRISE or re.search('(中心|中学|小学|医院|学院|大学|学校|体校|监狱|大队|支队|林场|海关|分局|商行)$', enter_tail):
  509. if fix_name not in business_dic:
  510. have_bus, dic = get_business_data(fix_name) # 20210124 改为有工商数据的实体才添加
  511. if have_bus == False and 'have_business' in dic and re.search('^(上海|云南|内蒙古|北京|吉林|四川|天津|宁夏|安徽|山东|山西|广东|广西|新疆|江苏|江西|河北|河南|浙江|海南|湖北|湖南'
  512. '|甘肃|福建|西藏|贵州|辽宁|重庆|陕西|青海|黑龙江|\w{1,5}[市县])[\w()]{2,15}[厂店铺市场行部城室馆中心站处社会狱所园关局司署段厅院队小学]$',fix_name): # 无工商数据有前面地址后面有关键词且在字典表的添加
  513. have_bus = True
  514. log('字典表补充无工商数据有关键词实体:%s'%fix_name)
  515. business_dic[fix_name] = (have_bus, dic)
  516. else:
  517. have_bus, dic = business_dic.get(fix_name) # 20240708 字典保存查询过的工商数据,避免重复查询redis
  518. if have_bus:
  519. # if is_enterprise_exist(enter_name):
  520. match_item = {"entity_text":"%s"%(fix_name),"begin_index":begin_index,"end_index":begin_index+len(enter_name)}
  521. # print("match_item",key_enter,enter_name)
  522. list_match.append(match_item)
  523. begin_index += len(enter_name)-1
  524. break
  525. begin_index += 1
  526. else:
  527. break
  528. # print("======",list_match)
  529. not_match_names = ['乌鲁木齐经济技术开发区(乌鲁木齐市头屯河区)市场监督管理局(区知识产权局、区市场监管综合行政执法队)', '政采云有限公司', '徽县发展和改革局', '徽县以工代赈易地搬迁办公室'] # 字典匹配不到的名称列表
  530. pattern = re.compile('|'.join(not_match_names))
  531. for it in re.finditer(pattern, sentence):
  532. match_item = {"entity_text": "%s" % (it.group(0)), "begin_index": it.start(), "end_index": it.end()}
  533. list_match.append(match_item)
  534. return list_match
  535. def calibrateEnterprise(list_articles,list_sentences,list_entitys):
  536. business_dic = {}
  537. for _article,list_sentence,list_entity in zip(list_articles,list_sentences,list_entitys):
  538. list_calibrate = []
  539. match_add = False
  540. match_replace = False
  541. range_entity = []
  542. for p_entity in list_entity:
  543. if p_entity.entity_type in ("org","company","location"):
  544. range_entity.append(p_entity)
  545. if len(range_entity)>1000:
  546. break
  547. for p_sentence in list_sentence:
  548. sentence = p_sentence.sentence_text
  549. sentence_entitys = [(ent.entity_text,ent.wordOffset_begin,ent.wordOffset_end) for ent in list_entity if ent.sentence_index==p_sentence.sentence_index and ent.entity_type in ['org','company']]
  550. list_match = match_enterprise_max_first(sentence, business_dic)
  551. # print("list_match", list_match)
  552. doc_id = p_sentence.doc_id
  553. sentence_index = p_sentence.sentence_index
  554. tokens = p_sentence.tokens
  555. list_match.sort(key=lambda x:x["begin_index"])
  556. for _match_index in range(len(list_match)):
  557. _match = list_match[_match_index]
  558. find_flag = False
  559. for p_entity in range_entity:
  560. if p_entity.sentence_index!=p_sentence.sentence_index:
  561. continue
  562. if p_entity.entity_type=="location" and p_entity.entity_text==_match["entity_text"]:
  563. find_flag = True
  564. p_entity.entity_type = "company"
  565. p_entity.if_dict_match = 1
  566. if p_entity.entity_type not in ["location","org","company"]:
  567. continue
  568. if _match["entity_text"] == p_entity.entity_text:
  569. p_entity.if_dict_match = 1
  570. #有重叠
  571. #match部分被包含则不处理
  572. if _match["begin_index"]>=p_entity.wordOffset_begin and _match["end_index"]<=p_entity.wordOffset_end:
  573. find_flag = True
  574. # 判断是否是多个公司
  575. if re.search('[分支](公司|中心|监狱|部|行)|^\w{4,15}公司\w{2,3}公司$'
  576. '|(大学|学院)\w{,2}附属\w{,6}医院$|(\w{2,5}办事处\w{2,6}$|^\w{2,6}银行\w{2,10}[分支]行$'
  577. '|\w{2,4}[省市县]\w{2,14}村)(股份)?经济(合作|联合)社$|国家税务总局\w{2,10}税务局$',
  578. p_entity.entity_text):
  579. continue
  580. if p_entity.entity_type == "location" and re.search('\d[楼室号]', p_entity.entity_text): # 明确地址不进行替换避免 类似 434052508 西宁市城西区西关大街128号山东大厦15楼1152室 更新为 西宁市城西
  581. continue
  582. for _match_j in range(_match_index,len(list_match)):
  583. if not list_match[_match_j]["end_index"]<=p_entity.wordOffset_end:
  584. _match_j -= 1
  585. break
  586. if _match_j>_match_index:
  587. match_replace = True
  588. match_add = True
  589. begin_index = changeIndexFromWordToWords(tokens,_match["begin_index"])
  590. end_index = changeIndexFromWordToWords(tokens,_match["end_index"]-1)
  591. list_calibrate.append({"type":"update","from":p_entity.entity_text,"to":_match["entity_text"]})
  592. p_entity.entity_text = _match["entity_text"]
  593. p_entity.wordOffset_begin = _match["begin_index"]
  594. p_entity.wordOffset_end = _match["end_index"]
  595. p_entity.begin_index = begin_index
  596. p_entity.end_index = end_index
  597. # 该公司实体是字典识别的
  598. p_entity.if_dict_match = 1
  599. for _match_h in range(_match_index+1,_match_j+1):
  600. entity_text = list_match[_match_h]["entity_text"]
  601. entity_type = "company"
  602. begin_index = changeIndexFromWordToWords(tokens,list_match[_match_h]["begin_index"])
  603. end_index = changeIndexFromWordToWords(tokens,list_match[_match_h]["end_index"]-1)
  604. entity_id = "%s_%d_%d_%d"%(doc_id,sentence_index,begin_index,end_index)
  605. add_entity = Entity(p_sentence.doc_id,entity_id,entity_text,entity_type,sentence_index,begin_index,end_index,list_match[_match_h]["begin_index"],list_match[_match_h]["end_index"],in_attachment=p_sentence.in_attachment)
  606. add_entity.if_dict_match = 1
  607. list_entity.append(add_entity)
  608. range_entity.append(add_entity)
  609. list_calibrate.append({"type":"add","from":"","to":entity_text})
  610. _match_index = _match_j
  611. break
  612. continue
  613. elif _match["begin_index"]<=p_entity.wordOffset_begin and _match["end_index"]>p_entity.wordOffset_begin:
  614. find_flag = True
  615. if _match["begin_index"]<p_entity.wordOffset_begin and _match["end_index"]<=p_entity.wordOffset_end:
  616. if p_entity.entity_type in ("org","company"):
  617. _diff_text = sentence[p_entity.wordOffset_end:_match["end_index"]]
  618. if re.search("分",_diff_text) is not None:
  619. pass
  620. else:
  621. match_replace = True
  622. begin_index = changeIndexFromWordToWords(tokens,_match["begin_index"])
  623. end_index = changeIndexFromWordToWords(tokens,_match["end_index"]-1)
  624. list_calibrate.append({"type":"update","from":p_entity.entity_text,"to":_match["entity_text"]})
  625. p_entity.entity_text = _match["entity_text"]
  626. p_entity.wordOffset_begin = _match["begin_index"]
  627. p_entity.wordOffset_end = _match["end_index"]
  628. p_entity.begin_index = begin_index
  629. p_entity.end_index = end_index
  630. p_entity.if_dict_match = 1
  631. elif _match["end_index"]>=p_entity.wordOffset_end:
  632. # 原entity列表已有实体,则不重复添加
  633. if (_match["entity_text"],_match["begin_index"],_match["end_index"]) not in sentence_entitys:
  634. match_replace = True
  635. begin_index = changeIndexFromWordToWords(tokens,_match["begin_index"])
  636. end_index = changeIndexFromWordToWords(tokens,_match["end_index"]-1)
  637. list_calibrate.append({"type":"update","from":p_entity.entity_text,"to":_match["entity_text"]})
  638. p_entity.entity_text = _match["entity_text"]
  639. p_entity.wordOffset_begin = _match["begin_index"]
  640. p_entity.wordOffset_end = _match["end_index"]
  641. p_entity.begin_index = begin_index
  642. p_entity.end_index = end_index
  643. p_entity.entity_type = "company"
  644. p_entity.if_dict_match = 1
  645. elif _match["begin_index"]<p_entity.wordOffset_end and _match["end_index"]>p_entity.wordOffset_end:
  646. find_flag = True
  647. if p_entity.entity_type in ("org","company"):
  648. match_replace = True
  649. begin_index = changeIndexFromWordToWords(tokens,_match["begin_index"])
  650. end_index = changeIndexFromWordToWords(tokens,_match["end_index"]-1)
  651. list_calibrate.append({"type":"update","from":p_entity.entity_text,"to":_match["entity_text"]})
  652. p_entity.entity_text = _match["entity_text"]
  653. p_entity.wordOffset_begin = _match["begin_index"]
  654. p_entity.wordOffset_end = _match["end_index"]
  655. p_entity.begin_index = begin_index
  656. p_entity.end_index = end_index
  657. p_entity.if_dict_match = 1
  658. if not find_flag:
  659. match_add = True
  660. entity_text = _match["entity_text"]
  661. entity_type = "company"
  662. begin_index = changeIndexFromWordToWords(tokens,_match["begin_index"])
  663. end_index = changeIndexFromWordToWords(tokens,_match["end_index"]-1)
  664. entity_id = "%s_%d_%d_%d"%(doc_id,sentence_index,begin_index,end_index)
  665. add_entity = Entity(p_sentence.doc_id,entity_id,entity_text,entity_type,sentence_index,begin_index,end_index,_match["begin_index"],_match["end_index"],in_attachment=p_sentence.in_attachment)
  666. list_entity.append(add_entity)
  667. range_entity.append(add_entity)
  668. list_calibrate.append({"type":"add","from":"","to":entity_text})
  669. #去重
  670. set_calibrate = set()
  671. list_match_enterprise = []
  672. for _calibrate in list_calibrate:
  673. _from = _calibrate.get("from","")
  674. _to = _calibrate.get("to","")
  675. _key = _from+_to
  676. if _key not in set_calibrate:
  677. list_match_enterprise.append(_calibrate)
  678. set_calibrate.add(_key)
  679. match_enterprise_type = 0
  680. if match_add:
  681. match_enterprise_type += 1
  682. if match_replace:
  683. match_enterprise_type += 2
  684. _article.match_enterprise = list_match_enterprise
  685. _article.match_enterprise_type = match_enterprise_type
  686. def isLegalEnterprise(name):
  687. is_legal = True
  688. if re.search("^[省市区县]",name) is not None or re.search("^\**.{,3}(分(公司|行|支)|街道|中心|办事处|经营部|委员会|有限公司)$",name) or re.search("标段|标包|名称|联系人|联系方式|中标单位|中标人|测试单位|采购单位|采购人|代理人|代理机构|盖章|(主)",name) is not None:
  689. is_legal = False
  690. return is_legal
  691. def fix_LEGAL_ENTERPRISE():
  692. unlegal_enterprise = []
  693. _path = getEnterprisePath()
  694. _sum = 0
  695. set_enter = set()
  696. paths = [_path]
  697. for _p in paths:
  698. with open(_p,"r",encoding="utf8") as f:
  699. while True:
  700. line = f.readline()
  701. if not line:
  702. break
  703. line = line.strip()
  704. if isLegalEnterprise(line):
  705. set_enter.add(line)
  706. if line=="有限责任公司" or line=='设计研究院' or line=='限责任公司' or (re.search("^.{,4}(分公司|支行|分行)$",line) is not None and re.search("电信|移动|联通|建行|工行|农行|中行|交行",line) is None):
  707. print(line)
  708. if line in set_enter:
  709. set_enter.remove(line)
  710. with open("enter.txt","w",encoding="utf8") as fwrite:
  711. for line in list(set_enter):
  712. fwrite.write(line.replace("(","(").replace(")",")"))
  713. fwrite.write("\n")
  714. # if re.search("标段|地址|标包|名称",line) is not None:#\(|\)||
  715. # _count += 1
  716. # print("=",line)
  717. # print("%d/%d"%(_count,_sum))
  718. # a_list = []
  719. # with open("电信分公司.txt","r",encoding="utf8") as f:
  720. # while True:
  721. # _line = f.readline()
  722. # if not _line:
  723. # break
  724. # if _line.strip()!="":
  725. # a_list.append(_line.strip())
  726. # with open("enter.txt","a",encoding="utf8") as f:
  727. # for _line in a_list:
  728. # f.write(_line)
  729. # f.write("\n")
  730. if __name__=="__main__":
  731. # edit_distance("GUMBO","GAMBOL")
  732. # print(jaccard_score("周口经济开发区陈营运粮河两岸拆迁工地土工布覆盖项目竞争性谈判公告","周口经济开发区陈营运粮河两岸拆迁工地土工布覆盖项目-成交公告"))
  733. #
  734. # sentences = "广州比地数据科技有限公司比地数据科技有限公司1111111123沈阳南光工贸有限公司"
  735. # print(match_enterprise_max_first(sentences))
  736. #
  737. # print("takes %d s"%(time.time()-_time))
  738. # fix_LEGAL_ENTERPRISE()
  739. # print(jaccard_score("吉林省九台","吉林省建苑设计集团有限公司"))
  740. print(match_enterprise_max_first("中国南方航空股份有限公司黑龙江分公司"))