แสดงชื่อลูกค้าที่มีทั้งสถานะคำสั่งซื้อเสร็จสมบูรณ์และสถานะคำสั่งซื้อชิ้นส่วน
Show the names of customers who have both an order in completed status and an order in part status.
df1 = pd.DataFrame(columns=['customer_name', 'customer_id']); df2 = pd.DataFrame(columns=['customer_id', 'order_status_code'])
df1[df1['customer_id'].isin(df2[df2['order_status_code'] == 'Completed']['customer_id']) & df1['customer_id'].isin(df2[df2['order_status_code'] == 'Part']['customer_id'])]['customer_name']