如何从带条件的其他行的字符串创建新的df列？

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie', 'David', 'Eve'],
        'Age': [25, 30, 35, 40, 45],
        'Condition': ['A', 'B', 'A', 'C', 'B']}
df = pd.DataFrame(data)

df['New Column'] = df['Condition'].apply(lambda x: 'Yes' if x == 'A' else 'No')

print(df)

      Name  Age Condition New Column
0    Alice   25         A        Yes
1      Bob   30         B         No
2  Charlie   35         A        Yes
3    David   40         C         No
4      Eve   45         B         No