Python Basics
Data Preparation
When your data is prepared effectively, all other aspects of analysis and performance become more efficient. This course lets you explore the different options for arranging and cleansing your data, from joins and unions to handling null and duplicate values.
Intermediate    13 Lessons    150 Minutes    CPD Credits
About This Course
Ensure your data is in the best shape possible. In this course, you will learn the different methods for arranging and cleaning your data using Python.
You will learn to bring together multiple datasets using joins and unions. You will use some of Python’s tools for cleansing your data. You will also touch on some advanced functionality, like error handling.
By the end of this course, you will be adept at wrangling data together, arranging and cleaning said data for more streamlined, efficient analysis.
Learning Outcomes
-
Learn about types of joins
-
Join and union separate dataframes
-
Aggregate data
-
Fix data type/range errors
-
Fix null values
-
Remove duplicate values
-
Fix incorrect value errors
Lessons
1. Course Introduction
2. Types of Joins
4. Outer Left/Right Joins
5. Data Granularity
6. Aggregating Data
Read More
7. Data Type Errors
8. Data Range Errors
9. Null Values
10. Duplicate Values
11. Categorical Value Errors
12. Inconsistent Data Errors
13. Cross-column Errors
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.