Python in Excel: Working with pandas DataFrames Год выпуска: 2024 Производитель: Linkedin Сайт производителя: https://www.linkedin.com Автор: Felix Zumstein Продолжительность: 1ч 47м Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Просьба не уходить с раздачи,я не смогу поддерживать раздачу вечно. Курс на английском языке. Добавлены английские субтитры. 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.
Содержание
1. Introduction 2. Introduction to pandas 3. Data Analysis 4. Time Series Analysis 5. Conclusion
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
