ค้นหาเพื่อนผู้หญิงของอลิซ
Find the female friends of Alice.
df = pd.merge(df1.assign(key=1),df2.assign(key=1),on='key').drop('key', 1)
df.loc[(df['name'] == 'Alice') & (df['gender'] == 'female'), 'friend']