Python in Excel: Working with pandas DataFrames

Focused View

Felix Zumstein

1:47:41

31 View

01 - Introduction

01 - Python in Excel and pandas DataFrames.mp4

00:39

02 - What you should know.mp4

01:28

03 - About Python in Excel.mp4

01:55

02 - 1. Introduction to pandas

01 - Hello World.mp4

04:32

02 - pandas DataFrame and Series.mp4

06:35

03 - Data selection.mp4

08:03

04 - Calculations, vectorization, and empty cells.mp4

06:24

05 - Row filtering.mp4

05:03

06 - Manipulating DataFrames.mp4

06:22

07 - Python editor and magic commands.mp4

04:23

03 - 2. Data Analysis

01 - Data cleaning.mp4

05:20

02 - Working with text data.mp4

05:54

03 - Combining DataFrames.mp4

06:26

04 - Data aggregation.mp4

03:53

05 - Plotting.mp4

05:01

04 - 3. Time Series Analysis

01 - Introduction to time series.mp4

04:49

02 - Time series analysis with pandas DataFrames.mp4

04:42

03 - Shifting and percentage changes.mp4

04:55

04 - Comparing time series.mp4

05:17

05 - Resampling and correlation.mp4

05:11

06 - Case study Sales dashboard.mp4

08:40

05 - Conclusion

01 - The next steps for learning more about Python in Excel.mp4

02:09

Description

Python and Excel are both some of the most popular “programming languages”, especially for data analytics/data science. Combined, they are even more powerful. In this course, author and Excel expert Felix Zumstein explains how to work with pandas DataFrames in Excel. pandas DataFrames are the backbone of every Python-based data analysis in Excel. Get a thorough introduction to DataFrames. Learn how to turn different sources—such as an Excel range, an Excel table, or a Power Query—into a DataFrame. Find out why and when it makes sense to use a DataFrame, as opposed to native Excel features like Power Query, Pivot Tables, or VLOOKUP formulas. Use a practical dataset to explore the basics of working with DataFrames, including an index, headers, filtering data, dropping duplicates, adding a new column, combining two DataFrames, and re-indexing. Plus, take a quick look at time series and visualizations.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Pandas

Excel

Felix Zumstein

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.