ค้นหาชื่อลูกค้าที่อาศัยอยู่ในโคโลราโด?
Find the name of customers who are living in Colorado?
df_customer_addresses = pd.DataFrame(columns=['customer_id', 'address_id']); df_customers = pd.DataFrame(columns=['customer_name', 'customer_id']); df_addresses = pd.DataFrame(columns=['address_id', 'state_province_county'])
df_customers[df_customers['customer_id'].isin(df_customer_addresses[df_customer_addresses['address_id'].isin(df_addresses[df_addresses['state_province_county']=='Colorado']['address_id'])]['customer_id'])]['customer_name']