ค้นหาชื่อลูกค้าที่มีสินเชื่อทั้งสินเชื่อจำนองและรถยนต์
Find the name of customers who have loans of both Mortgages and Auto.
df_loan = pd.DataFrame(columns=['cust_id', 'loan_type']); df_cust = pd.DataFrame(columns=['cust_name', 'cust_id'])
df_cust[df_cust['cust_id'].isin(df_loan[df_loan['loan_type'] == 'Mortgages']['cust_id']) & df_cust['cust_id'].isin(df_loan[df_loan['loan_type'] == 'Auto']['cust_id'])]['cust_name']