import pandas as pd import numpy as np

读取数据

data = pd.read_excel(r'D:\pythonProject3\会员信息\附件二：会员信息数据.xlsx')

计算距离

data['距离'] = np.sqrt((data['商品GPS纬度'] - data['会员GPS纬度'])**2 + (data['商品GPS经度'] - data['会员GPS经度'])**2)

设置常量k和n

k = 1 n = 1

计算引力子y

data['引力子'] = (k * data['任务标价'] * data['预定任务限额']) / (data['距离']**n)

根据任务执行情况分为完成和未完成两类

completed_data = data[data['任务执行情况'] == 1] incomplete_data = data[data['任务执行情况'] == 0]

求完成的最小y和未完成的最大y

min_completed_y = completed_data['引力子'].min() max_incomplete_y = incomplete_data['引力子'].max()

输出结果

print("完成的最小y:", min_completed_y) print("未完成的最大y:", max_incomplete_y)