Python Pandas -为各自过滤的单元格添加注释

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['Alice', 'Bob', 'Charlie', 'David'],
        'Age': [25, 30, 35, 40],
        'Gender': ['Female', 'Male', 'Male', 'Male']}
df = pd.DataFrame(data)

# 定义一个函数来添加注释
def add_comment(row):
    comment = f"This person's name is {row['Name']}, age is {row['Age']}, and gender is {row['Gender']}."
    return comment

# 使用apply方法添加注释列
df['Comment'] = df.apply(lambda row: add_comment(row), axis=1)

# 打印结果
print(df)

      Name  Age  Gender                                            Comment
0    Alice   25  Female  This person's name is Alice, age is 25, and gen...
1      Bob   30    Male  This person's name is Bob, age is 30, and gende...
2  Charlie   35    Male  This person's name is Charlie, age is 35, and g...
3    David   40    Male  This person's name is David, age is 40, and gen...