Skip to course content
Free course

Python Foundations / Module 8 / Data Project: Validate and Summarise Study Minutes

Module 8 lesson

Data Project: Validate and Summarise Study Minutes

Unit ID: M08-U08 Estimated active time: 55-75 minutes

Use the supplied fictional study_minutes.csv. Rows represent six learners and columns represent four weeks.

Required work

  1. Load only the four numeric columns.
  2. Confirm shape (6, 4), numeric dtype, finite values, and range 0 through 180.
  3. Preserve the loaded source array.
  4. Calculate totals per learner and means per week.
  5. Select learners with totals of at least 180 minutes.
  6. Convert minutes to hours with vectorised division.
  7. Apply a four-value weekly adjustment through broadcasting to a working copy.
  8. Prove that the source array did not change.

Expected evidence

  • learner totals: [180, 150, 235, 100, 250, 180];
  • weekly means: approximately [40.0, 43.33, 48.33, 50.83];
  • qualifying learner indices: [0, 2, 4, 5]; and
  • final message: MODULE 8 PROJECT: PASS.

Explain the result shapes and one decision about copies or views.