Author: Daniela Q. Lépiz

Do our councillors attend enough meetings?

Now that elections are done and dusted, and results are pouring in, I wanted to take a step back and look at previous councillor performance, because how can we say our new councillors are doing a good job if we have nothing to compare them to? Just before the 2016 local government elections, I decided to take a look at the meeting attendance records of the City of Cape Town councillors. The Council, and its sub-councils, meet monthly, with the exception of December, according to the Independent Electoral Commission (IEC). I found that 70% of councillors have missed at...

Read More

Too much data? Using the command line

Too many files, too big, lots of data? Chaos. Finding trends over time usually means we need to combine different datasets from different years: files that are not designed for this purpose and are usually very big. We need to clean the data as fast as possible and do this perfectly accurately, but how? When the files are this big, copying, pasting and manually filtering the data we want is not the way to go, and this can also lead to accidental errors. So, I recently came across an incredibly useful tool for journalism (read: Code for South Africa...

Read More


Recent Tweets