Data Analytics case 13: Averages for Conservation
Scenario
You are a data professional. A marine turtle project has an issue: staff argue about what a "normal" seen is. As a BI Analyst, you are tasked to solve it.
Question
Find the average for each group.
Your task
- Read the problem
- Write your solution in the editor
- Press Check my answer
- Deliverable: Average per group
- On success it is published as its own portfolio project
Data Analytics · Problem Solving & Root Cause Analysis — question 13 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Data Analytics case 13: Averages for Conservation
Find the average for each group.
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.
- Group average