← All topics
Quiz: groupby and merge: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. Students has 8 rows; a left merge with offers gives 9 rows. What is the most likely reason?
- Q2. Which join keeps only rows whose key exists in BOTH tables?
- Q3. How do you find students with no offer after a left merge?
- Q4. What does pivottable(index="company", columns="branch", aggfunc="count") show?
- Q5. Why keep each student's best offer before computing placement rates?
- Q6. What does this print? (code)
- Q7. What does this print? (code)
- Q8. Which join keeps every row from both tables, filling gaps with NaN?
- Q9. An offer has roll 109, but no student with roll 109 exists. What should the analyst do?
- Q10. What does named aggregation such as agg(avgcgpa=("cgpa", "mean")) give you?