ลูกค้าชื่อลินดาอาศัยอยู่ที่ไหน? แล้วอีเมลของเธอคืออะไร?
Where does the customer with the first name Linda live? And what is her email?
df_customer = pd.DataFrame(columns=['email', 'address_id', 'first_name']); df_address = pd.DataFrame(columns=['address', 'address_id'])
df_customer.merge(df_address, on='address_id')[df_customer['first_name']=='Linda'][['address', 'email']]