Cleaning dirty data – Matching similar text strings

I once had the dubious pleasure of attempting to combine datasets where the only field in common is a free-text field containing slightly different representations of the same entity (eg: Company Name). The existing solution in place was to eyeball the records, and to manually create a mapping table to link the 2 datasets. The mapping table records are created only if the system fails (ie: reactive in nature). Here are some of my findings on how to auto-magically generate …

The Calendarific API for global holiday calendars

The Calendarific API provides an intuitive, limited-use API feed, providing access to global holiday calendars, for current, past, and future years. The data may be useful for certain scenarios:

  1. For HR or factory calendars, so that the system knows which are non-working days.
  2. For vacation planning. Since you can calculate the day-of-week from the holiday date, you can spot the possibilities to create long weekends by strategically planning your leave.
  3. Those from the travel, leisure, or tourism industries might be

Trade event data from Enterprise Singapore

Knowledge of trade event data in a specific market can be very helpful.

Use cases include: 1) Demand and capacity planning. Certain industries (eg: travel, hospitality, F&B) would benefit from knowing when demand for their services would peak, and alter their capacity and pricing accordingly. 2) Comparison against same event in the past. It is troublesome to search the internet for the exact dates of an biennial-recurring event (eg: Singapore Air Show) each time we need it.

Looking up the …

SGX high dividend stocks (non-REITs)

Pursuant to the earlier post about high yielding dividend REITs (, some people have requested for the dividend yields for non-REITs instead. Diversifying to other asset classes is a good idea, so with another snap of my magic programming fingers (a la Thanos), here is a list of non-REIT stocks which have a dividend yield of 5% or greater.

The dividend yield is calculated by taking the dividends given for each stock in 2018 (by exDate), divided …

SGX high dividend stocks (REITs and Business Trusts)

The SGX stock market has been falling since the start of May 2019, fueled by fears generated from the US-China trade war. Has value emerged from the falling stock prices? Here, we present a list of REIT and Business Trusts which have a dividend yield of 5% or greater, sorted in order from low to high.

The dividend yield is calculated by taking the dividends given for each stock in 2018 (by exDate), divided by the stock’s closing price …

SSB – Jul 2019


This month’s SSB rates are indicated by the purple line, which comes in at 1.93% for the first 3 years, 7 basis points (“bps”) above last month’s tranche at 1.88% for the first 3 years. It looks like SSB rates have started to move upwards again!

Although it’s only 7 bps, I found it peculiar that interest rates could conceivably go up with the US economy is poised to go down due to the tariff tan-trumps presently going …

Amos Archives Activated

I’ve finally got a bit of free time coming up, and what better way to spend it than to get my creative juices running again by activating, or rather, reactivating my long-dormant blog. You see, the state of web technologies (if it’s still called that these days) advances so rapidly that it is profitable and instructive for anyone in the technology field to keep up-to-date by dabbling with the latest types or versions of whatever technology that happens to be …