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…

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…

PDFs are widely used for various purposes, from official documents to online books. As PDFs are often shared through various platforms and devices, it is important to protect your files from unauthorized usage or copying. One of the most effective ways to protect your PDF documents is by adding watermarks. …

A Step-by-Step Guide for Beginners — PDF files are commonly used for documents that need to be shared and printed across different platforms. However, sometimes the orientation of the pages may not be correct, leading to a document that is difficult to read or print. In this blog post, we will explore how to use Python…