使用循环根据在其他列行中找到的内容填充python中新列的行

pip install pandas

import pandas as pd

# 创建一个示例DataFrame
data = {
    'A': ['foo', 'bar', 'baz'],
    'B': [1, 2, 3]
}
df = pd.DataFrame(data)

# 假设我们要根据列'A'中的值来填充新列'C'
# 这里只是一个示例逻辑，具体逻辑需要根据实际情况来定
for index, row in df.iterrows():
    if row['A'] == 'foo':
        df.at[index, 'C'] = 'Found foo'
    elif row['A'] == 'bar':
        df.at[index, 'C'] = 'Found bar'
    else:
        df.at[index, 'C'] = 'Other'

print(df)

     A  B         C
0  foo  1  Found foo
1  bar  2  Found bar
2  baz  3      Other

# 使用apply方法根据列'A'的值来填充新列'C'
def fill_column(row):
    if row['A'] == 'foo':
        return 'Found foo'
    elif row['A'] == 'bar':
        return 'Found bar'
    else:
        return 'Other'

df['C'] = df.apply(fill_column, axis=1)

print(df)