'%20stroke='%23C6EEFF'%20stroke-width='14'%20stroke-linejoin='round'%20d='M256%2052c86%200%20154%2068%20154%20154%200%2056-30%2092-60%20124-21%2022-33%2040-35%2066H197c-2-26-14-44-35-66-30-32-60-68-60-124%200-86%2068-154%20154-154z'/%3e%3c!--%20inner%20glow%20behind%20the%20filament%20--%3e%3ccircle%20cx='256'%20cy='250'%20r='104'%20fill='url(%23dpGlow)'/%3e%3c!--%20filament:%20glowing%20loop%20--%3e%3cpath%20fill='none'%20stroke='%23DFF6FF'%20stroke-width='18'%20stroke-linecap='round'%20stroke-linejoin='round'%20filter='url(%23dpSoft)'%20d='M212%20322v-52c0-30%2020-46%2044-46s44%2016%2044%2046v52'/%3e%3cpath%20fill='none'%20stroke='%23EAFBFF'%20stroke-width='9'%20stroke-linecap='round'%20stroke-linejoin='round'%20d='M212%20322v-52c0-30%2020-46%2044-46s44%2016%2044%2046v52'/%3e%3c!--%20glass%20sheen%20(reflective)%20--%3e%3cpath%20fill='%23FFFFFF'%20opacity='0.32'%20d='M150%20106c26-28%2062-44%2096-46-52%2016-84%2062-90%20118-4%2038%204%2074%2022%20106-40-24-66-64-66-116%200-24%206-44%2038-62z'/%3e%3c!--%20base%20cap:%20outlined%20like%20the%20glass%20so%20the%20plug%20end%20reads%20clearly%20--%3e%3crect%20x='210'%20y='398'%20width='92'%20height='20'%20rx='10'%20fill='url(%23dpCap)'%20stroke='%23C6EEFF'%20stroke-width='10'/%3e%3crect%20x='220'%20y='424'%20width='72'%20height='14'%20rx='7'%20fill='%231B3FA8'%20stroke='%23C6EEFF'%20stroke-width='8'/%3e%3crect%20x='228'%20y='444'%20width='56'%20height='14'%20rx='7'%20fill='%2316337F'%20stroke='%23C6EEFF'%20stroke-width='8'/%3e%3crect%20x='240'%20y='464'%20width='32'%20height='12'%20rx='6'%20fill='%2312307A'%20stroke='%23C6EEFF'%20stroke-width='7'/%3e%3c/svg%3e)
Data Analytics case 4: Share analysis for Healthcare
Scenario
You are a data professional. A public clinic group has an issue: leaders want to know what percentage each ward contributes. As a Data Analyst, you are tasked to solve it.
Question
Compute each group's share of the total as a percent.
Your task
- Read the problem
- Write your solution in the editor
- Press Check my answer
- Deliverable: Percentage share per group
- On success it is published as its own portfolio project
Data Analytics · Problem Solving & Root Cause Analysis — question 4 of 30
1. Choose your dataset
Pick an industry and a size. Your code and results change to match.
Data Analytics case 4: Share analysis for Healthcare
Compute each group's share of the total as a percent.
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
clinic_visits
The tiny starter data. Bigger data scrolls.
Fields
| visit_id | ward | wait_minutes |
|---|---|---|
| V1 | Kids | 20 |
| V2 | Adults | 45 |
| V3 | Kids | 15 |
| V4 | Elderly | 30 |
Healthcare data only.
$ Press “Check my answer” — results appear here.Your next steps
Each item turns green when your answer includes it.
- Percent of total