Advanced plus 4: Pivot into a heatmap
Scenario
You are a data analyst in the Conservation team, working with animal_counts data. A pivot table turns rows into a grid; a heatmap colours it.
Question
Write your code in the editor, press Check my answer, then try changing one small thing.
Your task
- Write each line of your code
- Press Check my answer
- Change one value and check again
Advanced · Record Counting & Duplicate Removal — question 14 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Advanced plus 4: Pivot into a heatmap
Write your code in the editor, press Check my answer, then try changing one small thing.
Your code cell is below. Press Check my answer to run the cell — the result appears as Out [1].
💡 Explain my whole code, line by line (hover any word in the editor for a tip)
🌈 In short — no coding words
Altogether: this script runs top to bottom, one line at a time, building up the answer step by step.
Dataset & schema
animal_counts
The tiny starter data. Bigger data scrolls.
Fields
| count_id | species | seen |
|---|---|---|
| A1 | Rhino | 4 |
| A2 | Lion | 7 |
| A3 | Rhino | 3 |
| A4 | Zebra | 12 |
Conservation data only.
$ Press “Check my answer” — results appear here.Your next steps
Each item turns green when your answer includes it.
- Uses pivot_table
- Uses sns.heatmap