问题Python Group by和Apply函数

import pandas as pd

# 创建示例数据
data = {'Name': ['Alice', 'Bob', 'Charlie', 'Alice', 'Bob'],
        'Age': [25, 30, 35, 25, 30],
        'Salary': [5000, 6000, 7000, 5000, 6000]}
df = pd.DataFrame(data)

# 按照姓名分组，并计算每个人的平均工资
grouped = df.groupby('Name')
result = grouped['Salary'].mean()
print(result)

import pandas as pd

# 创建示例数据
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
        'Age': [25, 30, 35, 40],
        'Salary': [5000, 6000, 7000, 8000]}
df = pd.DataFrame(data)

# 自定义函数，计算每个人的薪资增长率
def calculate_growth(row):
    prev_salary = row['Salary'] - 1000
    growth_rate = (row['Salary'] - prev_salary) / prev_salary
    return growth_rate

# 按行应用自定义函数，计算薪资增长率
df['Growth Rate'] = df.apply(calculate_growth, axis=1)
print(df)