This post is about create a SQLite3 schema to store the Spotify data set in at least 3rd normal form (3NF), populate the tables and then using an example SQL query to find the names of all playlists that contain instrumentals. [Read More]

Note: This post is a step-by-step investigation into the Malaria Dataset from the different-income-entities perspective. You can check the Malaria Dataset Visualisation folder in my Github Repo ZhiQiu976/source-codes-tech-posts for detailed data processing and visualization making. [Read More]

This post will talk about some interesting programming problems in the famous Project Euler, which is a series of challenging mathematical 🧮 / computer programming ⌨️ problems that will require more than just mathematical insights to solve. As stated on the website, ‘although mathematics will help you arrive at elegant... [Read More]

This is a tutorial to show you how to construct a personal website using GitHub pages and Jekyll within 4 steps. It may be unconventional, but it is far more convenient than self-writing the whole web page. [Read More]