entityLink.py 39 KB

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