By Keith Yap

Things I've Learnt

Data visualisation with Python and Plotly – The Perth real estate market

Python is well known for its data science and analysis capabilities with packages such as Numpy, Matplotlib and Pandas. Each of these packages also offer a variety of graphing and visualisation tools, the majority of which is already very well… Continue Reading →

House Purchase Calculator – WA

The below spreadsheet can be used to check key metrics before purchasing a property. All cells in orange are to be filled in with your own values. Everything else is calculated.

Thomas Jefferson – The Art of Power

The life of Jefferson highlighted, amongst other things – the thirst for knowledge, the capacity to create, the love of family and friends, the hunger for accomplishment, the applause of the world, the marshaling of power, the bending of others… Continue Reading →

Remote connection to Raspberry Pi

Easy SSH when your computer and your PI are on the same network (wifi) Mac/Linux: Open the terminal Windows: Install Putty Ensure the pi is turned on and connected to network Find the ip address of the pi SSH into… Continue Reading →

PostgreSQL Beginner’s Cheat Sheet

Terminal commands: Launch PostgreSQL terminal – psql Copy table from one db to another – pg_dump -t table_name copyfrom_db_name | psql copyto_db_name   PSQL commands: List databases – \d List tables in current database – \dt List table structure – \d table_name List… Continue Reading →

Web Apps

Twitter sentiments – Looks up the 50 most recent tweets from any twitter user, classifies the sentiment of those tweets and outputs the result as a pie chart KS50 Finance – A simulated stock market portfolio tool, useful for learning the… Continue Reading →

Command line apps

The following are apps I’ve developed that currently only run from the command line. Many thanks to the excellent CS50 course for guidance with these. Caesar in C – Encrypts a user defined phrase using the caesar cypher method, and using a key… Continue Reading →

3 often forgotten rules of reporting dashboard design

A dashboard used to mean an array of physical instruments, arranged in front of an operator of some form of machine. The requirement for dashboards has evolved over time and they are now commonly used digitally by companies as a… Continue Reading →

Going Paperless

We’ve all heard this buzzword before, but what does it actually mean? What would a truly paperless working environment look like? To figure these questions out for myself, I decided to try it out first-hand. After a relatively smooth transition,… Continue Reading →

A Book Summary – Tuesdays with Morrie

A young man reconnects with his old university mentor after more than 15 years. Unfortunately, his mentor, Morrie, is slowly dying of a fatal, degenerative disease. Rather than lapsing into self pity however, Morrie chooses to spend what time he… Continue Reading →

« Older posts

© 2017 By Keith Yap — Powered by WordPress

Theme by Anders NorenUp ↑