ZhiZhi Gewu

Sign in Subscribe

Latest

Predicting House Price in Hong Kong #3

Date: 13 July 2020 In part 2, we have talked about splitting data into a training set and testing set. In part 3, I would like to share some findings on the first data exploration. Big Problem: Missing Data I did not expect there are so many missing data in

Scraping Yahoo Finance Data into Google Sheet

Scraping Yahoo Finance Data into Google Sheet

Sample Google Sheet: https://docs.google.com/spreadsheets/d/1pu1VmBKFvtdJPb78eYNooHaVAucff8_9blQPUUWoW2k/edit?usp=sharing Very often, data on websites is in presentation format instead of a nicely formatted table. This makes analysis difficult. Therefore, the first step of doing any real-world data analysis is to gather data in a nice

Predicting House Price in Hong Kong #2

In part 1, we have talked about scraping transactional data of apartments. In part 2, let’s talk about splitting data into a training set and testing set. Why we need to split? The short answer is we want to prevent overfitting/memorizing and hope that the model trained can

Reading Math Symbols

Date : 7 July 2020 Sometimes, it is quite scary to read Maths. Just like learning a new language, we need to understand the symbols/ vocabulary first. In this post, I am going to talk about some common maths symbols. The following content is extracted from my YouTube video. Logic Symbols

Predicting House Price in Hong Kong #1

Date: 7 July 2020 Housing is still one of the greatest concerns of Hong Kong people. I think it will be fun to build a model to predict the house price in Hong Kong. Unlike, Kaggle competition, data is not readily available. So, the first step, which I am going

Why I sold my holdings on CCL and RCL?

Date written: 21 May 2020 I have sold all my holdings on CCL and RCL. The primary reason for selling is that I cannot see how the future of cruise ships will look like. And, what’s ironic is that I thought I can see the future of cruise ships

Scorecards: A General Overiew

…too many financial institutions and investors simply outsourced their risk management. Rather than undertake their own analysis, they relied on the rating agencies to do the essential work of risk analysis for them. Lloyd Blankfein, CEO Goldman Sachs Credit risk scoring is simply a statistical tool for evaluating the level