Python BootCamp

Python BootCamp Updated 30 June 2017 1. Installation Installing OSX Open Terminal # install python brew update brew install python3 # install and upgrade some essential packages pip install --upgrade pip setuptools pipenv # optionally install some handy development tools pip install flake8 autopep8 ipython cookiecutter # data tools! pip3 install jupyter pandas Installing »

Setting up the Yeelight E27 Smart Light in Singapore

I came across this bulb on 23SGD including shipping. Smart light that seems to do everything other more expensive rivals do and more! I decided to give it a go. Packaging wise is kinda standard, not too flashy or bulky. Setup was easy. Download the Yeelight app »

Singapore Telegram Bot @ShiokBot

A little something I am building as a fun side project. Get the latest weather/psi/traffic data at your fingertips with the smart and easy to use Singapore Telegram Bot @ShiokBot. How to add Start a new message and search for ShiokBot Start chatting! Internals Using the awesome Telegram »

Getting Started With Python on Windows (Admin Permissions Not Needed)

The Python language is relatively easy to learn. What i found hard was getting it installed on Windows, especially when using it in the workplace. However, there is a way to get it on windows without admin permissions :) Firstly get the portable version of python. If »

Getting a US Netflix Account in Singapore (Works Jan 2017)

It's no secret that the content in Singapore is quite limited. Going from a US account to Singapore account in June because of the great Netflix DNS/VPN block made me realise this. According to this website Singapore has 10.21% the content of a »

Buying an Amazon Echo in Singapore

Currently Amazon does not ship the Echo to Singapore. The only way to get it is through freight forwarders. Option 1 : Amazon direct You pay all shipping and other charges. Approx US 180 + 50 SGD shipping Sign up for Borderlinx There are other websites that do this but I find »

Useful VBA Snippets (Constantly Updated)

Miscellaneous code Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'use with caution Application.EnableEvents = False 'YOUR CODE Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic Application.EnableEvents = True »