I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning.

Course description

Python comes with its own built-in software library for data manipulation and analysis. It’s called pandas, and it’s an extremely fast and powerful open-source tool that lets you analyze data more efficiently—right from a spreadsheet in Microsoft Excel.

Learn the basics of pandas analytics in this course designed specifically for Excel users, following advice from instructor and Excel MVP George Mount. Get up and running with your first moves in pandas, summarizing and visualizing data, working with rows and columns, cleaning data, and working with dates and times. Along the way, practice your skills using real-world data with an end-to-end analysis drawn from baseball.

Course outline

Introduction

• Python and Excel for analytics

First Steps with Pandas

• Why Pandas for analytics?
• Using Pandas DataFrames

Summarizing and Visualizing Data in Pandas

• Printing and exploring DataFrames
• Pandas plotting basics

Working with Rows and Columns

• Adding calculated columns
• Renaming and dropping columns
• Sorting rows
• Filtering rows

Cleaning Data

• Aggregating a DataFrame
• Merging two DataFrames
• Working with missing values
• Reshaping a DataFrame

Working with Dates and Times

• Aggregating by time period
• Creating window functions

Practice Your Skills

• Practicing with real data

Conclusion

• Continuing your Python journey

Get started

Use this link to view the course for free for 24 hours on LinkedIn Learning. Make sure to give it a like and share while you’re there! Thanks as always for supporting my content.

The post Pandas analytics for Excel users (LinkedIn Learning & Madecraft) first appeared on Stringfest Analytics.