Module 4 Assessment: DataFrame Operations Check
Assessment ID: DAV-M04-QA01 Estimated active time: 25-35 minutes
Part A: Short answers
- What is the difference between
locandiloc? - Why do multiple filter conditions need parentheses?
- Why should a derived column have a written rule?
- Why can chained assignment be confusing?
Part B: Code check
Write pandas code to:
- Select
learner_id,course_id,status, andminutes_spent. - Filter to active learners with less than 60 minutes.
- Sort by
minutes_spent. - Create
hours_spent. - Create a
needs_reviewcolumn that is True whenminutes_spentis less than 30.
Rubric
| Level | Evidence |
|---|---|
| Pass | Code uses clear selection, filters, sorting, vectorized derived columns, and documented rules. |
| Revise | Code works but rules or filter logic are hard to explain. |
| Not yet | Code manually loops through rows or creates columns without a clear purpose. |
