English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 53m | 283 MB
In this specialized course, data analyst Chris French focuses on leveraging Python within Excel for efficient data cleaning and manipulation tasks. Explore data cleaning techniques, text and string manipulation, and numeric data cleaning. Hone your skills with advanced data cleaning challenges. Gain proficiency in using Python for data cleaning and manipulation tasks within Excel. Plus, master essential data cleaning techniques, including handling missing values and duplicates, standardizing data formats, and learning concepts to real-world datasets and scenarios to effectively clean and prepare data for analysis or reporting.
Table of Contents
Introduction
1 Leverage Python in Excel
2 What you should know
Intro to Data Cleaning
3 Dataframes
4 Missing values
5 Removing duplicates
6 Correcting date types
7 Challenge Data cleaning
8 Solution Data cleaning
Advanced Data Cleaning Techniques
9 Cleaning text data
10 Time data
11 Validating data
12 Manipulating columns
13 Challenge Advanced data cleaning
14 Solution Advanced data cleaning
Data Manipulation
15 Data aggregation
16 Filtering and sorting
17 Grouping data
18 Manipulating text data
19 Challenge Data manipulation
20 Solution Data manipulation
Advanced Data Manipulation
21 Merging and joining
22 PivotTables
23 Creating charts
24 Data trends
25 Challenge Advanced data manipulation
26 Solution Advanced data manipulation
Conclusion
27 Your next steps with Python in Excel
Resolve the captcha to access the links!