R Project – create line chart
The follow along R project in the YouTube video below shows how to load a spreadsheet into an R script, manipulate the data by pivoting columns, and then producing a line chart with data points. The spreadsheet used in the project can be found below. The original...
R Project – create bar chart using gglot2
The follow along R project in the YouTube video below shows how to load a spreadsheet into an R script, manipulate the data by removing column/variable, change variable name, and pivot columns, and then producing a bar chart. The spreadsheet used in the project can be...
Which colours make sense for expense movements?
Which makes more sense? The above two waterfall diagrams shows month on month movement of the three expenses which have been grouped together. The waterfall was created using Power BI and the default colours used by Power BI are shown in the top diagram...
RShiny – add catchment areas to a map using geoJSON
This example using RShiny shows how to add polygons to a map from a geoJSON file to show school catchment areas. The school locations are then plotted. The geoJSON file used in this project can be found at:...
Boolean Logic: A Guide to AND/OR Conditions
TRUE OR FALSE You are writing software code and into your code you put a condition, for example ‘if A is true or B is true then do X else do Y’. You then test the code output by inputting various values, some will cause A to be TRUE and some will cause A...
Data needs context – Context drives information
Anything can be data. My name is data. My age is data. My address is data. And so on and so on. Data is everywhere Data may be everywhere but if you look at data without considering its context, then it becomes meaningless. Context is an essential companion to data....
Please explain how an API could help me
API – Application Programming Interface Here’s a scenario – You don’t work in the field of data analysis but feel that there is more that could be done with the data you use in your field of work. If only you could access the data you require...
Which type of search might you perform?
I would like to know …. You are creating a digital product. What type of searches might you or your user be looking to perform? Let’s have a look at the different type of searches we may carry out in our day to day lives: You may be deciding what you will...