รหัสพนักงานและเพศของพนักงานทุกคนที่มีตำแหน่งงานเป็นผู้จัดการแผนกคืออะไร?
What are the staff ids and genders of all staffs whose job title is Department Manager?
df_staff_department_assignments = pd.DataFrame(columns=['staff_id', 'job_title_code']); df_staff = pd.DataFrame(columns=['staff_id', 'staff_gender'])
df_staff[df_staff['staff_id'].isin(df_staff_department_assignments[df_staff_department_assignments['job_title_code'] == 'Department Manager']['staff_id'])][['staff_id', 'staff_gender']]