← Lab 1 overview and setup
Lab 1 · Section 1 of 6
Look at the student table
Part 1 · TODO 1 and three explanations
First · connect to the lecture
The lecture defines a row and an identifier. Here you check that students has one row per person and choose the matching table.
Week 1: rows and measurement, PDF pp. 30–39
Your task
Inspect columns and ID uniqueness. Choose the one-student table for TODO 1. Name one column's measurement type.
Evidence to include
Record the actual student count, uniqueness result and a specific column example.
Notebook questions and code
Read here; run in your downloaded notebook. Start with its setup cells and run in order. Use your own ID and outputs where requested.
Download Lab 1 notebookPart 1: Look at the first table
Before running the next cell, predict:
- How many rows do you expect in students?
- Can the same student ID appear more than once?
- Which columns describe a student rather than identify a student?
Python · cell 5 — read here, run in your notebook
students.head()Python · cell 6 — read here, run in your notebook
print("Is student_id unique in students?", students["student_id"].is_unique)
print("Number of students:", len(students))
print("Columns:", list(students.columns))Explain after running
- What does one row in students represent? Write one sentence.
- Why is student_id an identifier rather than a useful numerical measurement? Write one sentence.
- Choose one column and name its measurement type: nominal category, number, or identifier. Write one sentence.
Python · cell 8 — read here, run in your notebook
# TODO 1 - Replace the blank with the table that has one row per student.
# Choose exactly one: students or enrolments
one_student_table = _____
one_student_table[["student_id", "programme", "study_mode"]].head()Saved only in this browser. This note doesn’t fill in the downloaded notebook; “reviewed” is a personal checklist, not a grade.