Question: Consider the two DataFrames shown below, both of which have Name as the index. Which of the following expressions can be used to get the

Consider the two DataFrames shown below, both of which have Name as the index. Which of the following expressions can be used to get the data of all students (from student_df) including their roles as staff, where nan denotes no role? student_df staff_df School Name James Business Mike Law Sally Engineering Role Name Kelly Director of HR Sally Course liasion James Grader pd. merge (staff_df, student_df, how='right', left_index=False, right_index=True) Opd.merge(student_df, staff_df, how='right', left_index=True, right_index=True) Opd. merge(student_df, staff_df, how="left', left_index=True, right_index=True) Opd.merge(staff_df, student_df, how="left', left_index=True, right_index=True)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
