by Jason Lu | Jan 1, 2022 | Jason Lu
Before the meeting Before the meeting, background research must be conducted. First, look up the client on Linkedin. You will be able to gain an understanding of what they do and know what questions they will and will not be able to help with. Exploring the data and...
by Jason Lu | Dec 25, 2021 | Jason Lu
1. Retrieve the URLs and necessary tokens and keys. This is the first and most crucial step of the whole process and will establish the difficulty of the task ahead. Every API will have its own unique documentation. Some are clearer than others, some will require keys...
by Jason Lu | Dec 25, 2021 | Jason Lu
Are all your dashboards looking bright and vibrant? Do they immediately catch the attention of anyone scrolling through? Something that draws your attention may not for others. Not everyone sees colours in the same way. In fact, 1 in 12 men and 1 in 200 women are...
by Jason Lu | Nov 3, 2021 | Jason Lu
How I used Fuzzy Matching. When working with the dataset containing all Formula One driver names, all foreign names which contained letters with accents appeared as weird symbols. ä -> ä ö ->ö This issue can be fixed by applying a replace formula on each one...
by Jason Lu | Oct 10, 2021 | Jason Lu
Codeless data cleaning? Coming from a statistics background, a program for cleaning and wrangling data was essential for performing statistical analysis on data. I had primarily used R and the Pandas software library in python for data wrangling and cleaning. However,...
