
Explore practical data wrangling concepts—reading, exploration, standardization, handling duplicates and missing data, filtering, sorting, splitting and merging, and exporting data—using notebooks with code and text cells, hosted on Google Colab.
Explore datasets with python by examining shapes, tails, and data types, practice with iris and DfE datasets, and validate numeric conversions like Fahrenheit to Celsius.
Drop the city column or other columns with axis and in-place updates, then use numpy where to create and filter a data integrity column.
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.