March 26, 2018

Synopsis

Summary statistics and Exploratory analysis of Spur Afrika Clinic activity in Kibera, January 2018.

Data import and processing

Data collected by Spur Afrika medical team, local Kenyan medical staff and Australian guests, working in Kibera, Nairobi, Kenya.

Data imported from Airtable, 'cloud database'

Missing data and harmonising data

Redundant grade names consolidated

Average age and Form.Grade

Dubious age data

Age data corrected where simple and correctible errors have been made

Height data

Weight data

Children demographics

Age-Sex pyramid

Height vs Age

Height (z-score) vs Age

Weight vs Age

Weight (z-score) vs Age

Body Mass Index (BMI) vs Age

BMI vs Age by Gender

BMI (z-score) vs Age

Clinical Findings

Analyze clinical findings of children (by age Age.in.years). If no age is available, assume that all patients attending school Form.grade are children.

Clean up Findings Data

Finding types rationalized

Findings by category

Dental Findings

Management

Analyze management of children in ChildPatientData

Clean up Management Data

Management names rationalized

Management by Category

Dental management

Dental Management for children, ranked by frequency
DentalManage n
Filling 10
Dental review 7
Oral hygiene demo 7
Extraction 6
Scaling 4
Brush teeth 1
Paracetamol oral 1