pandas Analytics for Excel Users

Focused View

George Mount and Madecraft

57:35

86 View

01 - Introduction

01 - Python and Excel for analytics.mp4

00:54

02 - 1. First Steps with pandas

01 - Why pandas for analytics.mp4

04:06

02 - Using pandas DataFrames.mp4

04:29

03 - 2. Summarizing and Visualizing Data in Pandas

01 - Printing and exploring DataFrames.mp4

03:07

02 - pandas plotting basics.mp4

03:58

04 - 3. Working with Rows and Columns

01 - Adding calculated columns.mp4

03:21

02 - Renaming and dropping columns.mp4

02:57

03 - Sorting rows.mp4

02:57

04 - Filtering rows.mp4

04:28

05 - 4. Cleaning Data

01 - Aggregating a DataFrame.mp4

02:51

02 - Merging two DataFrames.mp4

04:31

03 - Working with missing values.mp4

02:29

04 - Reshaping a DataFrame.mp4

03:50

06 - 5. Working with Dates and Times

01 - Aggregating by time period.mp4

04:04

02 - Creating window functions.mp4

04:24

07 - 6. Practice Your Skills

01 - Practicing with real data.mp4

04:04

08 - Conclusion

01 - Continuing your Python journey.mp4

01:05

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.

This course was created by Madecraft. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Data Analysis

Pandas

Excel

George Mount and Madecraft

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.