Yingfan Blog

「STOP EXISTING AND START LIVING」

SQL For Interview (Window Functions)

Study notes of Liuge's blogs

SQL study notes based on this blog. Common Window Functions sum()over(): 常用来多维度分组求和、求累加值等 count()over(): 常用来多维度分组计数、计算汇总计数等 min, max, avg()over(): 常用来计算指定分组列对应某指标的最大、最小、平均值 sorting by gr...

Posted by Yingfan on March 25, 2022

AB Testing Study Notes(1)

AB Testing Overview and Important Ethics

Overview A/B testing is a methodology for testing product changes. You split your users into two groups, show ‘control group’ your existing product and ‘experimental group’ your new versions. By g...

Posted by Yingfan on October 8, 2021

FEATURED TAGS
sql lecture notes machine learning model interview study notes neural network data analysis
ABOUT ME

段颖凡，芝加哥大学分析学硕士在读，数据科学爱好者。
An enthusiastic data scientist & statistical professional.

FRIENDS