ไวน์ใดบ้างที่มีราคาสูงกว่า 50 และทำจากองุ่นสีแดง?
What are the wines that have prices higher than 50 and made of Red color grapes?
df_wine = pd.DataFrame(columns=['Name', 'Grape', 'price']); df_grapes = pd.DataFrame(columns=['Grape', 'Color'])
df_wine['Name'][df_wine['Grape'].isin(df_grapes[df_grapes['Color']=='Red']['Grape']) & df_wine['price'] > 50]