Module 3 Activity: First Pandas Inspection

Estimated active time: 60-75 minutes

Task

Load a supplied fictional enrolment table and create a first inspection record.

Steps

1. Import pandas as pd.
2. Load the CSV file using a relative path.
3. Display the first five rows.
4. Record shape.
5. Record column names.
6. Use info() to inspect dtypes and non-null counts.
7. Use describe() for numeric columns.
8. Use value_counts() for at least two categorical columns.
9. Count missing values by column.
10. Draft a data dictionary with at least six columns.
11. Save an inspected copy to an output path without overwriting the source file.

Deliverable

• Import and inspection notebook.
• Data dictionary draft.
• One paragraph explaining the row meaning and the biggest data concern.

Quality bar

The activity is ready when another person can open your notes and understand what each important column means.