3 min
How to retrieve the last record in each group in SQL?
Problem You have a table with multiple rows of data for each group, and you want to select the last row from each group....
3 min
Problem You have a table with multiple rows of data for each group, and you want to select the last row from each group....
3 min
Problem From the test_scores table below, select the top 1 row in each group. For example, you have a table with data about ‘students’...
3 min
Problem You have a table with multiple rows of data for each group, and you want to select the first row from each group....
2 min
Problem How to transpose columns to rows in SQL? This essentially requires reshaping the table in such a way that certain columns of a...
2 min
Problem How to select only rows with max value on a column for each distinct value in another categorical column in MySQL? From Items...
13 min
SQL window functions exercises is designed to challenge your SQL muscle and help internalize data wrangling using window functions in SQL. The questions are...
5 min
SQL window functions is considered a ‘hard’ concept in SQL. This set of exercises is designed to challenge your SQL muscle and help internalize...
14 min
SQL window functions is one of the advanced concepts, understanding which will give you the ability to do complex data wrangling and transformations in...
7 min
SQL Subquery, also known as inner query or nested query, are used to query data from one or more tables and then used in...
25 min
SQL, short for Structured Query Language is a programming language used to communicate with databases and do various types of Data wrangling operations. This...
Cook’s distance is a measure computed to measure the influence exerted by each observation on the trained model. It is measured by building a...
Z score, also called as standard score, is used to scale the features in a dataset for machine learning model training. It can also...
Z score is one of the most important concepts in statistics. It is also called standard score. Typically it is used to scale the...
Let’s understand what are outliers, how to identify them using IQR and Boxplots and how to treat them if appropriate. 1. What are outliers?...
2 min
Pip is a widely used package manager for Python, allowing you to install and manage Python packages easily. In this blog post, we’ll explore...
Web scraping is the technique of extracting data from a specific website or web page. This has wide applications in: Research and publication purposes...
1. What is the purpose of adding Python to the PATH environment variable? Adding Python to the PATH environment variable in Windows allows you...
5 min
MICE Imputation, short for ‘Multiple Imputation by Chained Equation’ is an advanced missing data imputation technique that uses multiple iterations of Machine Learning model...
1 min
conda is a popular package management system that allows you to create isolated environments with different versions of packages and dependencies. In this one,...
1 min
conda is a popular package management system that allows you to create isolated environments with different versions of packages and dependencies. Earlier we saw...