Sign in

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!

Everything you need to know about emoji in your database or dataset.

Header created by the author

Let us face it, it is 2021 and emojis are inevitable. You see it everywhere from chats to product reviews, and in some cases usernames. Today we will be answering some questions:

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


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. …

What does death means to me, to others, and death in different forms. Is death a curse or blessing?

Covid has not been lenient to mankind, and that is a fact. People experienced all kinds of deaths, from Covid related, suicides due to mental health, relationships torn apart, or even sufferings due to retrenchment and economy. And when we talk about literal death, people across different cultures and religions…

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