double salary = wage = 9999.99错误

#薪资列将月薪和时薪转换为日薪： import pandas as pd import re # 读取数据 df = pd.read_excel('boss岗位.xlsx') # 定义薪资转换函数 def convert_to_daily(salary): if pd.isna(salary): return None # 匹配“X-YK·N薪” match1 = re.search(r'(\d+)-(\d+)K·(\d+)薪', salary) if match1: min_salary = int(match1.group(1)) max_salary = int(match1.group(2)) avg_monthly = (min_salary + max_salary) / 2 * 1000 daily_salary = round(avg_monthly / 22, 2) return f"{daily_salary}元/天" # 匹配“X-YK” match2 = re.search(r'(\d+)-(\d+)K', salary) if match2: min_salary = int(match2.group(1)) max_salary = int(match2.group(2)) avg_monthly = (min_salary + max_salary) / 2 * 1000 daily_salary = round(avg_monthly / 22, 2) return f"{daily_salary}元/天" # 匹配“X-Y元/天” match3 = re.search(r'(\d+)-(\d+)元/天', salary) if match3: min_salary = int(match3.group(1)) max_salary = int(match3.group(2)) daily_salary = (min_salary + max_salary) / 2 return f"{daily_salary}元/天" # 匹配“X-K”（单月薪值） match4 = re.search(r'(\d+)K', salary) if match4: salary_k = int(match4.group(1)) monthly_salary = salary_k * 1000 daily_salary = round(monthly_salary / 22, 2) return f"{daily_salary}元/天" # 无法转换的格式（如“面议”或纯文字） return salary # 应用函数到薪资列 df['薪资_统一'] = df['薪资'].apply(convert_to_daily) # 保存结果 df.to_excel('处理好的薪资列.xlsx', index=False) 帮我修改代码把薪资单位统一转换成**-**元/天