برای استفاده کامل از سایت، جاوااسکریپت را فعال کنید.

JavaScript is required for the full experience. You can still browse these pages:

Data Cleaning and Manipulating with Python in Excel

1h 53mIntermediate2024-10-03

Authors

Chris French

Course details

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.

Skills covered

SpreadsheetsData EngineeringMicrosoft ExcelPythonData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Leverage Python in Excel
02 - What you should know

1. Intro to Data Cleaning

03 - Dataframes
04 - Missing values
05 - Removing duplicates
06 - Correcting date types
07 - Challenge - Data cleaning
08 - Solution - Data cleaning

2. Advanced Data Cleaning Techniques

09 - Cleaning text data
10 - Time data
11 - Validating data
12 - Manipulating columns
13 - Challenge - Advanced data cleaning
14 - Solution - Advanced data cleaning

3. Data Manipulation

15 - Data aggregation
16 - Filtering and sorting
17 - Grouping data
18 - Manipulating text data
19 - Challenge - Data manipulation
20 - Solution - Data manipulation

4. 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