Python in Excel: Getting Started with Data Analysis
1h 40mIntermediate2024-03-12
Authors
Joe Marini
Senior Developer Advocate at Google, Developer
Course details
Are you looking to take a deeper dive into the key features and functions of Python in Excel? This hands-on course covers the basics of working with data using Python in Excel including data structures, DataFrames, functions, and more. Join instructor and industry expert Joe Marini as he prepares you to get more out of these two leading technologies by wielding their respective strengths in tandem. Along the way, test out your new skills and technical know-how in the exercise challenges at the end of each section. Throughout the course, Joe highlights a handful of practical Python-in-Excel examples such as fixing dates with dateutil, generating a random sequence, creating a scatter plot with Seaborn, creating a Gantt chart, and extracting data using regular expressions.
Skills covered
SpreadsheetsMicrosoft ExcelPythonData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceMicrosoftSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Two great technologies together at last
- 02 - What you should know
- 03 - Getting set up
1. The Basics
- 04 - A simple example
- 05 - Python vs. Excel data types
- 06 - The xl() function
- 07 - Understanding row-order execution
- 08 - Debugging
- 09 - Challenge - Basics
- 10 - Solution - Basics
2. Working with Data
- 11 - Introduction to DataFrames
- 12 - Exploring DataFrame content
- 13 - Manipulating DataFrames
- 14 - Interoperating with Python
- 15 - Challenge - DataFrames
- 16 - Solution - DataFrames
3. Practical Python-in-Excel Examples
- 17 - Fixing dates with dateutil
- 18 - Generate a random sequence
- 19 - Scatter plot with Seaborn
- 20 - Create a Gantt chart
- 21 - Extract data with regular expressions
Conclusion
- 22 - Next steps