Author: Gemma Gatticchi
-
32 of South Africa’s prisoners are children
The number of young inmates in South Africa’s prisons – those under the age of 18 – has dropped by about 83% since 2015/16, according to data from the department of correctional services. In August 2022, the age of criminal capacity was raised from 10 years of age to 12. The Child Justice Act means…
-
School trip: Walking is the only option for two-thirds of SA’s learners
There are about 15.4-million school-going children in South Africa and almost two-thirds of them have to walk to school every day, according Statistics SA’s 2023 General Household Survey. Walking to school is not necessarily a bad thing but for many learners there are few alternatives. There is little in the way of school buses available to learners and public transport is equally limited…
-
Despite rising crime rate, SA has dire shortage of forensic experts
South Africa should ideally have 330 forensic pathologists, an expert says. Instead there are only about 50 working in the public sector.
-
Hands-on: 5 reasons to switch to OpenRefine to clean data
It has a pretty steep learning curve but it’s definitely worth the effort to learn OpenRefine if you need to clean large amounts of very messy data.
-
How we create custom charts using Flourish and Figma
At The Outlier we publish a lot of static graphics and we like to apply our own styles. Here’s how we do it using Flourish and Figma.
-
Simple guide to scraping data from PDFs
Papers, PDFs and poorly scanned documents are the way most data journalism projects begin. But instead of typing up a new spreadsheet, here’s how to use Adobe Acrobat DC to do all the hard work for you.
-
10 spreadsheet formulas we use to superpower our data analysis
Both Microsoft Excel and Google Sheets are powerful spreadsheet programmes for storing and sorting through mounds of data. Here are our favourite formulas for making sense of data.
-
The Outlier’s grocery basket: February 2023
Every month we take a look at the in-store prices of the same basket of goods across six major retailers – Shoprite, Checkers, Pick n Pay, Spar, Food Lover’s Market and Woolworths.