Python in Excel : Working with pandas DataFrames / with Felix Zumstein.

Format:

Video

Author/Creator:

Zumstein, Felix, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Physical Description:

1 online resource

Place of Publication:

Carpenteria, CA : linkedin.com, 2024.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn when to use a DataFrame in Excel, how to load it, and how to do basic data analysis and visualization with it.

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.

Participant:

Presenter: Felix Zumstein

Notes:

4/11/202412:00:00AM

Access Restriction:

Restricted for use by site license.