
Learn data wrangling with Python by reading data, exploring data, and handling missing data and outliers, using a hands-on practice notebook and a project.
Learn to load datasets from csv and Excel, explore records, identify missing values and outliers, and export filtered results to csv and Excel on online platforms with no installation.
Learn data wrangling in Python by transforming raw data into analysis ready formats, covering reading, cleaning, missing data, outliers, duplicates, and merging sources for dashboards or machine learning models.
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 Python libraries for data wrangling, including pandas and numpy, and learn to run code cells and use libraries like matplotlib, seaborn, and scikit-learn for data manipulation tasks.
Learn to read data from csv or excel files using pandas read_csv, store it in a data frame, and preview records with head while understanding dataset structure.
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.
Demonstrate data standardization by renaming and cleaning column names to lowercase with underscores, handling semicolon separators, and converting height from inches to centimeters while normalizing data types.
Identify and fix syntax errors in datasets using the replace function to correct misspellings and the strip method to remove leading and trailing spaces.
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.