Learn how to use Python for data analysis with Zane Goodman. This hands-on course covers essential libraries like pandas and matplotlib, helping you clean, transform, and visualize data like a pro.
In Learn With The Nerds – Python for Data Analysts, instructor Zane Goodman introduces you to the core Python skills every data analyst should know. This hands-on session focuses on using Python to clean, transform, and visualize data—all with practical examples that mirror real-world analysis. Whether you're just starting your Python journey or expanding your analytics toolkit, this course gives you a strong foundation in working with data programmatically.
Zane walks through essential libraries like pandas, NumPy, and matplotlib, showing how to manipulate datasets, perform calculations, and create visual insights. You’ll also explore how to integrate Python into tools like Power BI and how it compares to more traditional data platforms. If you're a data analyst looking to unlock the full power of Python, this is where to begin.
Course Outline ( Free Preview)
Module 00 - What You Need to Get Started
Before diving into Python, make sure your tools are ready. This module walks you through downloading the course notebooks so you can follow along without a hitch.
Module 01 - Introduction
Meet your instructor, Zane Goodman, and get an overview of the course structure. You'll learn what to expect, what skills you’ll develop, and how Python fits into the modern data analyst’s workflow.
Module 02 - Why Python?
Understand the advantages of using Python for data analysis. Zane explains why it's a go-to language for analysts and how it compares to Excel, SQL, and other tools when it comes to speed, flexibility, and automation.
Module 03 - Jupyter
Learn how to use Jupyter Notebooks, the most popular environment for writing and running Python code. You'll get familiar with the interface, running code cells, and organizing your analysis in a clean, readable format.
Module 04 - Content and Notebooks
Explore the structure of the course content and notebooks. Zane walks you through how the examples are laid out, where to enter your code, and how to use markdown for commenting and documenting your process.
Module 05 - Pandas
Get introduced to pandas, the core Python library for data analysis. This module shows you how to import datasets, inspect them, and begin working with real-world data using pandas’ intuitive commands.
Module 06 - DataFrames
Dive deeper into DataFrames, the foundational data structure in pandas. You’ll learn how to create, explore, and manipulate tables of data efficiently—perfect for analysts transitioning from Excel.
Module 07 - Filtering
Learn how to filter and subset your data based on conditions. Zane covers Boolean indexing, conditional logic, and techniques for narrowing down datasets to just the rows you need.
Module 08 - Functions
Explore built-in pandas functions and how to apply custom logic using Python’s apply() and lambda functions. This module helps you automate repetitive tasks and customize your analysis.
Module 09 - Grouping
Discover how to use groupby() to summarize and analyze data by category. This is where you’ll start unlocking real insights—whether you're calculating averages, counts, or trends by group.
Module 10 - Merging
Combine datasets with merging and joining techniques. Zane shows you how to align data from different sources, similar to a SQL join, so you can build complete and connected datasets.
Module 11 - Aggregations
Learn how to perform powerful aggregations to summarize your data. You'll use functions like sum(), mean(), and count() to break down large datasets into meaningful summaries.
Module 12 - Visualizing Data
Wrap up your analysis by turning data into visuals using libraries like matplotlib and pandas’ built-in plotting tools. You’ll learn how to create line charts, bar charts, and more to help tell the story behind the numbers.
Zane Goodman is a Trainer for Pragmatic Works specializing in the Power Platform. He's worked in skilled labor roles as well as the construction industry. Zane spent a lot of time in attics, on boom lifts, and in ditches making sure all the lights turned on properly. Now his primary focus is turning on the light for learning, helping our customers learn the ins and outs of Power Apps.