In updating ProjectBASS.org IP address to Network Owner, I frequently encounter raw data where the IP addresses are expressed in terms of CIDR notation. Unfortunately, I need to get the starting IP and ending IP from this CIDR information.

For example: we might see one of Globe Telecom’s IP address…

Or why data analytics depends on data preparation.

I wanted to find the “Reach” of some Facebook groups. In my mind, it should have been a simple SUM calculation. It should have been an easy formula using Excel’s Sum Function. We can add all the values of “# of Members”…

A true story where one pandemic is solved by non-medical methods. Data analytics, visualization and Beer Drinking combined to ‘cure’ cholera.

The date is August 31st, 1854, you are John Snow, the Queen’s Anesthetist. You puzzle over one of the deadliest diseases to affect your country. From some accounts, a…

Wilson Chua

Data Analyst, Startup Founder, Tech Columnist

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