Python in Excel: Working with pandas DataFrames.
(eVideo)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2024.
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Format
eVideo
Language
English
Notes
General Note
4/11/202412:00:00AM
Participants/Performers
Presenter: Felix Zumstein
Description
Learn when to use a DataFrame in Excel, how to load it, and how to do basic data analysis and visualization with it.
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.
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.
Citations
APA Citation, 7th Edition (style guide)
Zumstein, F. (2024). Python in Excel: Working with pandas DataFrames . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Zumstein, Felix. 2024. Python in Excel: Working With Pandas DataFrames. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Zumstein, Felix. Python in Excel: Working With Pandas DataFrames linkedin.com, 2024.
MLA Citation, 9th Edition (style guide)Zumstein, Felix. Python in Excel: Working With Pandas DataFrames linkedin.com, 2024.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
0538ae68-fdd8-9a86-0d6e-25c46c56fece-eng
Grouping Information
| Grouped Work ID | 0538ae68-fdd8-9a86-0d6e-25c46c56fece-eng |
|---|---|
| Full title | python in excel working with pandas dataframes |
| Author | zumstein felix |
| Grouping Category | movie |
| Last Update | 2024-04-15 10:54:20AM |
| Last Indexed | 2024-04-27 22:48:16PM |
Book Cover Information
| Image Source | sideload |
|---|---|
| First Loaded | Apr 20, 2024 |
| Last Used | May 1, 2024 |
Marc Record
| First Detected | Apr 15, 2024 10:55:38 AM |
|---|---|
| Last File Modification Time | Apr 15, 2024 10:55:38 AM |
MARC Record
| LEADER | 02386ngm a22003133i 4500 | ||
|---|---|---|---|
| 001 | LDC3816247 | ||
| 003 | LDC | ||
| 005 | 20240415154237.0 | ||
| 006 | m c | ||
| 007 | cr cna a | ||
| 008 | 240415s2024 cau107 o vleng d | ||
| 040 | |a linkedin.com|b eng | ||
| 050 | 4 | |a LDC3816247 | |
| 100 | 1 | |a Zumstein, Felix|e speaker. | |
| 245 | 1 | 0 | |a Python in Excel: Working with pandas DataFrames.|c with Felix Zumstein |
| 264 | 1 | |a Carpenteria, CA|b linkedin.com,|c 2024. | |
| 306 | |a 01h:47m:43s | ||
| 337 | |a computer|2 rdamedia | ||
| 338 | |a online resource|2 rdacarrier | ||
| 500 | |a 4/11/202412:00:00AM | ||
| 511 | 1 | |a Presenter: Felix Zumstein | |
| 520 | |a Learn when to use a DataFrame in Excel, how to load it, and how to do basic data analysis and visualization with it. | ||
| 520 | |a 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. | ||
| 538 | |a 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. | ||
| 655 | 4 | |a Instructional films.|2 lcgft | |
| 655 | 4 | |a Educational films.|2 lcgft | |
| 710 | 2 | |a linkedin.com (Firm) | |
| 856 | 4 | 0 | |u https://www.linkedin.com/learning/python-in-excel-working-with-pandas-dataframes?u=103732282&auth=true|z View course details on linkedin.com/learning |
| 856 | 4 | 2 | |3 thumbnail|u https://media.licdn.com/dms/image/D560DAQH4uk98MNH5IA/learning-public-crop_288_512/0/1712361684240?e=2147483647&v=beta&t=KbOjlW-6b017B_qvPBRuQpnDt0fjqH2_ZXsnAvhwqJ0 |