Xinqian ZhaiCracking MySQL: Self-Joins Made Simple with Leetcode ExampleIt’s time to solidify the “why” and “when” of using self-joins in SQL queries with Leetcode examples.Oct 11, 2023Oct 11, 2023
Xinqian ZhaiCreate ColumnTransformer & FeatureUnion in Pipelines with Code ExampleIn this post, we’ll show how ColumnTransformer & FeatureUnion differ, and how to build them in pipelines with python code examples.Jan 30, 2023Jan 30, 2023
Xinqian ZhaiSelect columns and add new columns in an ML pipeline with code examplehow to build classes to select and add new columns and combine them together in a pipeline with code example? Read this post.Dec 15, 2022Dec 15, 2022
Xinqian ZhaiCross Validation with Code ExamplesSummary: What is cross-validation? Why do we use it? What’re the common types? How to apply it? Overfitting, underfitting, and limitations?Nov 4, 2022Nov 4, 2022
Xinqian ZhaiHow to Choose Different Types of Linear Classifiers?Confused about different types of classification algorithms, such as Logistic Regression, Naive Bayes Classifier, Linear Support Vector…Aug 9, 2022Aug 9, 2022
Xinqian ZhaiA Picture Shows You the Most Common Supervised Machine Learning ModelsSupervised learning and unsupervised learning are two key types of machine learning problems. Supervised models are used to predict target…Jul 4, 2022Jul 4, 2022
Xinqian ZhaiHow to Choose Different Types of Linear Regression?Confused about different types of regression, such as Least-Squares Linear Regression, Ridge Regression, Lasso Regression, and Polynomial…Jun 20, 2022Jun 20, 2022
Xinqian ZhaiRetrieve Data from Twitter API and Explore Visualizations in PythonNote- This tutorial assumes that you have obtained your Twitter API key and Token credentials for authentication. If you haven’t already…Apr 1, 2022Apr 1, 2022
Xinqian ZhaiUS Airport Network Exploration and Visualization Using Networkx and BasemapToday, I’ll be using the Networkx and Basemap libraries to do some simple network exploration and visualization about the airports and…Jan 27, 2022Jan 27, 2022