这个python脚本读取一个excel文件2023Q1laomiao_fix_closexlsx然后提取这个文件里面的address和name作为参数循环调用上面的方法如果传入的参数name与address与腾讯接口返回的title和address信息编辑距离小于3则返回true否则返回false最后将返回值写入到文件的check字段。
由于缺少相关的方法和API,无法为您提供完整的Python脚本。不过,您可以参考以下示例代码来实现类似的功能:
import pandas as pd
import requests
from Levenshtein import distance
# 定义腾讯API请求函数
def get_tencent_info(name, address):
url = 'https://apis.map.qq.com/ws/place/v1/search'
params = {
'key': 'your_tencent_api_key',
'keyword': name,
'boundary': f'region({address},0)',
'page_size': 1
}
response = requests.get(url, params=params)
if response.status_code == 200:
data = response.json()
if data['status'] == 0 and data['count'] > 0:
return data['data'][0]
return None
# 读取Excel文件
df = pd.read_excel('2023Q1laomiao_fix_close.xlsx')
# 循环处理每个记录
for index, row in df.iterrows():
name = row['name']
address = row['address']
tencent_info = get_tencent_info(name, address)
if tencent_info is not None:
tencent_name = tencent_info['title']
tencent_address = tencent_info['address']
distance_name = distance(name, tencent_name)
distance_address = distance(address, tencent_address)
if distance_name < 3 and distance_address < 3:
df.at[index, 'check'] = 'true'
else:
df.at[index, 'check'] = 'false'
# 将结果写入Excel文件
df.to_excel('2023Q1laomiao_fix_close_output.xlsx', index=False)
需要注意的是,这段代码中的get_tencent_info函数需要替换为您自己的腾讯API调用方法。同时,您还需要安装pandas和Levenshtein库来运行这个示例代码。
原文地址: https://www.cveoy.top/t/topic/bv6A 著作权归作者所有。请勿转载和采集!