Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 44 Minute(s)
Language
English
Taught by
Valentine Mwangi
Rating
3 views
Course Overview
Perform Data Wrangling with the Python Programming Language. Practice and Solution Notebooks included.
By the end of this course, you will be able to:
Load a local dataset from CSV and Excel files.
Import a dataset from CSV and Excel files via a URL.
Determine the size of a dataset.
Explore the first and last records of a dataset.
Explore the datatypes of the features of a dataset.
Check for missing data in a dataset.
Deal with missing data in a dataset.
Filter for records with certain values from a dataset.
Filter records with multiple filters from a dataset.
Filter for records from a dataset through the use of conditions.
Perform sorting in ascending and descending order.
Split a column in a dataset.
Merge data frames to form a dataset.
Concatenate two columns to one column in a dataset.
Export a dataset in CSV and Excel formats.
Course Content
- 10 section(s)
- 18 lecture(s)
- Section 1 Introduction
- Section 2 Learning Outcomes
- Section 3 Overview of Data Wrangling
- Section 4 Notebook Introduction
- Section 5 Prerequisites
- Section 6 Reading Data
- Section 7 Data Exploration
- Section 8 Standardisation
- Section 9 Syntax Errors
- Section 10 Irrelevant Data
What You’ll Learn
- To load a local dataset from CSV and Excel files.
- To import a dataset from CSV and Excel files via a URL.
- To determine the size of a dataset.
- To explore the first and last records of a dataset.
- To explore the datatypes of the features of a dataset.
- To check for missing data in a dataset.
- To deal with missing data in a dataset.
- To filter for records with certain values from a dataset.
- To filter records with multiple filters from a dataset.
- To filter for records from a dataset through the use of conditions.
- To perform sorting in ascending and descending order.
- To split a column in a dataset.
- To merge data frames to form a dataset.
- To concatenate two columns to one column in a dataset.
- To export a dataset in CSV and Excel formats.
Skills covered in this course
Reviews
-
MMuhammad Talha Javed Siddiqui
it was good but i am hoping for my certificate .. kindly provide it
-
WWalid Obaid
yes, it was a good match, I learned these new concepts in python which will help me in understanding data coding
-
MMarti
The course is a little outdated; due to library changes some of the example code no longer works without adjustments (NaN errors when trying to apply int64 to some fields, and some warnings about future deprecation in arrays.) The solution document is also not consistent with the challenge document and is missing several sections. However the content was clear, the examples mostly easy to follow (even without video guidance) and the challenges appropriate for learning different methods to perform data cleansing tasks in a Python notebook.
-
OOlajide Olawale Ogunbodede
Excellent
