รหัสผลิตภัณฑ์สำหรับปัญหาที่รายงานโดย Christop Berge โดยได้รับอนุญาตจาก Ashley Medhurst คืออะไร
What are the product ids for the problems reported by Christop Berge with closure authorised by Ashley Medhurst?
df_staff = pd.DataFrame({'staff_id': ['id1', 'id2'], 'staff_first_name': ['Christop', 'Ashley'], 'staff_last_name': ['Berge', 'Medhurst']})
df_problems = pd.DataFrame({'reported_by_staff_id': ['id1'], 'closure_authorised_by_staff_id': ['id2']})
df_problems.loc[(df_problems['reported_by_staff_id'].isin(df_staff[(df_staff['staff_first_name'] == 'Christop') & (df_staff['staff_last_name'] == 'Berge')]['staff_id'])) & (df_problems['closure_authorised_by_staff_id'].isin(df_staff[(df_staff['staff_first_name'] == 'Ashley') & (df_staff['staff_last_name'] == 'Medhurst')]['staff_id']))]