In this tutorial, we’ll learn how to clean our dataset by using Pandas functions like rename, replace, drop, and more! After this tutorial, you’ll have a solid understanding of how to modify your dataset in a way that makes it easier for you to analyze, which we will begin covering in the next couple of episodes!
This video is part of an 8-part course designed to give absolute beginners an idea of what Data Analysis looks like using Python.
What is Data Analysis? Data Analysis is the process of exploring, cleaning, transforming, and modeling data as a way to produce insightful conclusions or gather useful information. It is a field that is growing rapidly, along with Data Science, and one that is very high in demand. If you’re interested in taking that career route, or maybe just want to learn it as a skill, this course is for you!
AI Global Index Dataset: https://www.kaggle.com/datasets/kater...
Episode Timestamps:
00:00 - Intro
01:11 - groupby function
03:08 - Method Chaining
03:38 - Copying dataset
04:36 - Single data replacement
06:02 - replace function
07:19 - inplace argument
08:47 - Dropping columns
11:57 - Renaming columns
13:45 - dropna method
15:13 - fillna method
18:22 - Changing data types
20:08 - Dropping duplicates
21:11 - Creating new columns