Chaoran Liu

Chaoran Liu

data science enthusiast

Recent posts

Tableau Intersection Filter Tutorial

less than 1 minute read

If you used Tableau before, you will know that the filters in Tableau are union/or selection.Let’s take the table below for example. If you are going to create a filter and select product a & b, tableau will show client A,B,C and E instead of A,C. It’s because the filters will show us the list of clients who purchased product a or b, instead of product a and b. the idea Firstly, create a variable to count the selection of products. Then create another variable to count the selection...

Job Hunting Like A Data Analyst (Part III)

6 minute read

Continued with previous post – Explore the Job Market, this week I am going to develop a simple recommender system to find a suitable job . Recommender Let’s talk some background of recommendation system. A typical example of recommendation could be product recommended in the sidebar at Amazon or people you may know in Facebook. Usually we can categorised recommender into two types: 1. Content Based Recommendation: Content-based could mean user-based or product-based and the choice is de...

Job Hunting Like A Data Analyst (Part II)

4 minute read

Continued with previous post, I’ve added some additional lines of codes to fetch the job description of each job post. This will take a bit longer time, which is about (1.5 hour) for me, because I set a delay of ~10 seconds between each request. This week I will continue with overview picture of the job market of Data Analyst and develop a simple recommender based on skill and experience requirement. 0. Tools python 2.7 python package: pandas python package: re 1. Job Market Overv...

Job Hunting Like A Data Analyst (Part I)

6 minute read

Motivation: I’m currently suffering a tough time in looking for a data analyst job. Instead of doing it in a traditional way, I am thinking why not do the job hunting just like a data analyst, by making use of the advantages of data science. Always, the first step to flight a battle is to know your enemy. As I’m looking for a job in Singapore/China, the first thing I would like to explore is the job market in these areas. I’m interested to know about: Who is hiring data analyst Which ...

Review on Stanford Machine Learning Course

5 minute read

I have been signed up for this course for a long time. And since last week, I finally managed to complete it with a good score. This course is taught by Andrew Ng, who is also the co-founder of Cousera. The content of the course spans from supervised learning to unsupervised learning, as well as some advice for the ML model improvement, special topics on pipeline setup and implementation on large scale data. I personally feel this course is very beneficial for the beginners like me. The f...