nuoleinyu Goto Github PK

I'm Nuo Lei (/nuə/ /leɪ/), a current Data Science graduate student at NYU Center for Data Science. Looking forward to doing interesting things with data science skills!

• Recommender system

  • Movie recommender with online demo: Basic model but fun application! Use KNN to complete rating matrix and use K-means clustering movies to three genres. Finally recommend movies in the same genre based on like-minded people's ratings.

• Classification

  • Loan default prediction on Kaggle notebook: Predict loan default on imbalanced dataset by SMOTE upsampling and Logistic regression, SVM, Random forest, LightGBM, XGBoost, achieving a best recall rate of 89%.

• Common ML mistake — Is it really numerical data?
• SQL join & where, which runs first?
• SQL Techniques: How to Deal with Date & Time?
• SQL Techniques: How to Calculate Median & Mode?
• SQL Techniques: How to Select from Snapshot Date?
• SQL Techniques: How to Do Permutations & Combination?
• SQL Techniques: How to Impute NULL with Only the First Row?
• SQL Techniques: How to Do Rolling Average?
• SQL Techniques: How to Do Calculations in One Column?
• SQL Techniques: How to Use Multiple Where in One Column?