根据另一列的相应行重命名该列的行

import pandas as pd

# 创建一个示例数据集
data = {'Name': ['John', 'Alice', 'Bob', 'Emily'],
        'Age': [25, 30, 35, 40],
        'Country': ['USA', 'Canada', 'UK', 'Australia']}

df = pd.DataFrame(data)

# 根据Country列的值重命名Name列的行
df.loc[df['Country'] == 'USA', 'Name'] = 'John Smith'
df.loc[df['Country'] == 'Canada', 'Name'] = 'Alice Johnson'
df.loc[df['Country'] == 'UK', 'Name'] = 'Bob Brown'
df.loc[df['Country'] == 'Australia', 'Name'] = 'Emily Davis'

# 打印修改后的数据集
print(df)

           Name  Age    Country
0    John Smith   25        USA
1  Alice Johnson   30     Canada
2     Bob Brown   35         UK
3   Emily Davis   40  Australia