The most common SQL functions you must know — SQL is one of the most popular programming languages for data science. Being able to write effective queries has become an essential skill for data science professionals. In this article, we will discuss the most commonly used SQL functions. Hopefully, this would be a helpful cheat sheet when writing SQL…

The most common Pandas functions for data wrangling — Undoubtedly Pandas is one of the most popular Python libraries for data science. Its versatility and functionalities make it a powerful tool for data wrangling and exploration. Getting familiar with Pandas has become an essential skill for data science professionals. In this article, we…

Predict home price with XGBoost using real-time sales data — Check out the Web App and the code on my GitHub and feel free to let me know if you have any questions! Project Background Whether you’re buying or selling a house, change in home prices will affect your housing plans. Keeping an eye on home prices can give you an idea…

Build a Recommendation System Using NLP and Sentiment Analysis — Check out the Web App and the code on my GitHub and feel free to let me know if you have any questions! Project Background Do you have the same experience as I do when you are shopping online? Your search for a product name on an E-Commerce website. Hundreds of products…

In this post, we will talk about the difference between Z-test and T-test in hypothesis testing and when and why one is more appropriate to use than another. Why do we need Z-test or T-test in Hypothesis Testing? Hypothesis testing is all about making informed decisions based on evidence from data. When we have collected data from experiments, surveys, or…

What exactly is hypothesis testing, and why do we need to differentiate between one-tailed and two-tailed tests? In this blog post, we will delve into one of the most useful concepts in statistics: one-tailed and two-tailed hypothesis tests. What is Hypothesis Testing? Before we dive into one-tailed and two-tailed tests, let’s start by understanding…

Understand the Fundamentals of Combinatorics in Simple Terms — Have you ever wondered what the difference between combination and permutation is? Do you find it challenging to calculate the number of ways you can arrange or select items? Don’t worry, you’re not alone! Many beginners in data science struggle with combinatorics. In this blog post, we’ll explain the difference…

Tips and Tricks for Cleaning Data — In data science, cleaning and preparing your data is a crucial step before analyzing it. One common problem is dealing with duplicate rows in their datasets. Duplicate rows can skew your analysis, leading to inaccurate insights and conclusions. Fortunately, SQL offers several ways to remove duplicate rows from your data…

Learn How to Use BeautifulSoup and Selenium to Extract Data from the Web — Are you a data enthusiast looking to extract data from websites, but don’t know where to start? Look no further! In this blog post, we’ll provide a comprehensive cheat sheet to web scraping using two popular Python libraries — BeautifulSoup and Selenium. Basis of HTML Before we dive into scraping website data in…