I'm Jonathan Law Hui Hao, a fullstack developer based in Malaysia who works with tech stuff and enjoys learning and working on RPA and Machine Learning!

Matching 2 different sources of product reviews by Malaysian using fuzzy string matching, and a comparison between Jaccard and Levenshtein algorithm.

This scenario came when I had to match product reviews from a few Malaysian-based online shopping platforms. And what makes us Malaysian’s special is how we spell and give product reviews.

Amazon review (top) compared with reviews from Malaysians (bottom). Screenshot provided by the author.

I have decided to share this challenge that I came across, and together with a few scenarios that may…

Making sure all changes in Big Query are accountable for

Introduction

Working with teams using Big Query and creating views can get messy when people start changing views without informing other members of the team.

Snipper of comments on top of an SQL file
The snippet is taken from the author Big Query view

Some teams are accustomed to using comments on the top of the view, or even a spreadsheet to record changes. …

A counterintuitive use of data that might spread like wildfire as we move into the data-driven era.

While the use of data is not new, it has certainly been in the spotlight in recent years. To some extent, everyone (yes, including you) uses data in their daily lives. Companies are making decisions based on data, from projecting their revenue to optimizing their services and cost. …

Jonathan Law

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store