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
Introduction
- Leverage Python in Excel
- What you should know
Intro to Data Cleaning
- Dataframes
- Missing values
- Removing duplicates
- Correcting date types
- Challenge - Data cleaning
- Solution - Data cleaning
Advanced Data Cleaning Techniques
- Cleaning text data
- Time data
- Validating data
- Manipulating columns
- Challenge - Advanced data cleaning
- Solution - Advanced data cleaning
Data Manipulation
- Data aggregation
- Filtering and sorting
- Grouping data
- Manipulating text data
- Challenge - Data manipulation
- Solution - Data manipulation
Advanced Data Manipulation
- Merging and joining
- PivotTables
- Creating charts
- Data trends
- Challenge - Advanced data manipulation
- Solution - Advanced data manipulation
Conclusion
- Your next steps with Python in Excel