Hi, I'm Xiangke

Thinking will not overcome fear but action will.

MLB Hall of Fame Prediction

Machine Learning, Predictive, Baseball, XGBoost

MLB - Hall of Fame Notes: The details of my implementation without many codes. This document is written for technical audience. So more code and logic details, please refer to mlb-data_challen...

Posted by Xiangke on April 19, 2020

A Crash in Causal Inference

Causal Inference, DID, RDD, Panel Data

A Crash In Causal Inference I leaned Causal Inference in my master program and found it’s interesting and used frequently in business world. I am pretty interested in it and decided to take anothe...

Posted by Xiangke on April 19, 2020

Window Functions

Mysql, Database

Window Functions row_number() / rank() / dense_rank() persent_rank() / cume_dist() lag() / lead() first_val() / last_val() nth_value / nfile() There is a frame window. Sometimes yo...

Posted by Xiangke on April 11, 2020

A/B Testing Common Questions

A/B Testing

A/B Testing Common Questions - original post time: 2020/02/09 - Update time: 2020/03/22 - Lasest Update time: 2020/03/31 General Questions General Questions You Should Be Aware Of: Wha...

Posted by Xiangke on March 31, 2020

Yelp Review Analysis

Text Mining, Tableau, Pyspark

Yelp Review Analysis This is our exploratory journey of yelp dataset. The main topic is about reviews’ topic modeling. Our team has Yi Zhu, Yili Yu, Boyang Wei, Lin Xu, Xiangke Chen and Yusha Wan...

Posted by Xiangke on February 27, 2020

Recruit Restaurant Visitor Forecasting

Time Series, Machine Learning, Python

*Github Detail Codes*: Link 1. Project Definition & Introduction When someone opens a restaurant, their focus is likely on making high-quality food that will make their customers happy. Howev...

Posted by Xiangke on February 26, 2020

Frequent Statistics Asked Questions

Data Analysis, Tips, Statistics, FAQ

Update time: - 02/03/2020 orginal post - 02/18/2020 update linear regression knowledge Conceptual Questions Prediction VS Forecasting Forecasting would be a subset of prediction. Any time you ...

Posted by Xiangke on February 18, 2020

SQL Summary

Mysql, Database

update history: - 2020/02/09 original post - 2020/02/14 update time functions Short Answers Join Table by Where vs by On link The ON clause defines the relationship between the tables. The WH...

Posted by Xiangke on February 14, 2020

Data Analysis Resource

data analysis

INTRO Here I want to summarize some important resources that are useful for data analytics or data science. Data Science/Analytics is usually a mixed area of data engineer, programming, stats .et...

Posted by Xiangke on January 17, 2020

FEATURED TAGS
Data Analysis SQL DataBase Statistics Projects Python Causal Inference
ABOUT ME

Goals determine what you going to be!

✉️ chen6789@umn.edu

FRIENDS