Skip to course content
Free course

Data Analysis and Visualization with Python / Module 6

Module 6 check

Module 6 Assessment: Summary and Reshape Check

Assessment ID: DAV-M06-QA01 Estimated active time: 30-40 minutes

Part A: Short answers

  1. What does grain mean?
  2. What are the three parts of split-apply-combine?
  3. When is a pivot table useful?
  4. Why is long-form data often useful for plotting?
  5. What is the difference between agg and transform?

Part B: Code check

Write pandas code to:

  1. Group by course_name.
  2. Count unique learners.
  3. Sum minutes_spent.
  4. Calculate average minutes_spent.
  5. Build a pivot table with course_name as rows and week_number as columns.
  6. Melt a wide weekly table into long form.

Rubric

LevelEvidence
PassSummary tables are correct, named clearly, and include grain explanations.
ReviseCode produces output but row meaning or column names are unclear.
Not yetCode creates summaries without explaining what one result row represents.