怎么把salary那一列数据换成平均值啊

Question

孩子试了好多次了 ，作业写不完了😭😭😭不会啊

Answer 1

写个函数计算平均值. 就像这样:

def convert_range_to_average(salary: str) -> str:
    if salary == "面议":
        return salary
    low, high = salary[:-3].split('-')
    low=int(low)
    high=int(high)
    average = int((low+high)/2)
    return f'{average}元/月'

然后

df2 = df.copy()
df2['salary'] = df['salary'].apply(convert_range_to_average)
df2