Relevance

Belated gong hay fat choy. Came across this pair of lucky dogs wandering the streets of SF last week during Chinese New Years.

I noticed something recently regarding my blog. I can write whatever I want, however I want. But people are clicking because of the kind of photos I post (shouts out to social media automation). Looking at my website’s traffic data, people like food or nature.

Having mostly original content, you’re not going to find my exact perspective anywhere else. So I’m glad you come to see my food/nature pictures. I’m appreciative of those who end up reading the rest of the article and start a conversation.

Enjoy this self reflection while I’m traveling. Catch up with y’all soon.

Fuzzy Lookups

McDonald's Hawaiian trash cans
In Hawaii, we are wealthy in culture but sometimes it creates challenges in managing data.

One of the projects I was working on for a few years involved cleaning up Address data for a customer database. I found out the admin did a lot of manually data correction. That works well for a customer base of less then 1,000, maybe even less than 500. In our situation, we had 40k customers at any given moment. That is a lot of tedious work.

When the admin was gone for vacations, I would take over the responsibility of maintaining the member’s database. Due to the restriction of having only x amount of hours in a day, I took some time to test out fuzzy lookups to manage the data.

The basic concept is that I can automate the computer to take a look at one list (in this case, the member’s database) and compare it to another list to see what are the strongest matches. Not being familiar with Hawaiian street names at the time, it was difficult to do it manually. So I decided I would try to compare a confirm address list and the customer list I had to maintain.

I never convinced the admin that this would help them with their job. I’m thinking it’ll be useful in the future to minimize “Lost in Translation” moments.

Anyway, to help you understand better, here’s a quick video on Fuzzy Lookups that I thought was useful: