Data Cleaning and Manipulating with Python in Excel

Focused View

1:53:27

0 View

01 - Introduction

01 - Leverage Python in Excel.mp4

00:36

02 - What you should know.mp4

00:44

02 - 1. Intro to Data Cleaning

01 - Dataframes.mp4

03:03

02 - Missing values.mp4

05:23

03 - Removing duplicates.mp4

05:39

04 - Correcting date types.mp4

03:56

05 - Challenge Data cleaning.mp4

01:04

06 - Solution Data cleaning.mp4

06:11

03 - 2. Advanced Data Cleaning Techniques

01 - Cleaning text data.mp4

05:11

02 - Time data.mp4

05:06

03 - Validating data.mp4

03:41

04 - Manipulating columns.mp4

04:49

05 - Challenge Advanced data cleaning.mp4

01:07

06 - Solution Advanced data cleaning.mp4

04:59

04 - 3. Data Manipulation

01 - Data aggregation.mp4

04:41

02 - Filtering and sorting.mp4

06:23

03 - Grouping data.mp4

05:15

04 - Manipulating text data.mp4

04:22

05 - Challenge Data manipulation.mp4

01:02

06 - Solution Data manipulation.mp4

05:26

05 - 4. Advanced Data Manipulation

01 - Merging and joining.mp4

07:00

02 - PivotTables.mp4

06:22

03 - Creating charts.mp4

06:19

04 - Data trends.mp4

05:40

05 - Challenge Advanced data manipulation.mp4

01:12

06 - Solution Advanced data manipulation.mp4

07:10

06 - Conclusion

01 - Your next steps with Python in Excel.mp4

01:06

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.