How to use groupby() to group categories in a pandas DataFrame
In this video we go over how to group categories of data using the grouby() operation in pandas. We use the popular Titanic data set commonly used when learning data science. We look at how to group on a single criteria on a single column. Then we move on how to group with multiple columns, then multiple groups, multiple groups and multiple columns, and how to look at multiple groupby functions in a single command. As a bonus, I'll show you a trick on how to minimize the number of groups which can improve the interpretability of you data.
Did you find this video helpful? Consider subscribing for weekly tips, tricks, and tutorials.
https://www.youtube.com/channel/UC17QKsysOmZ7oJepmmcUTvA?sub_confirmation=1
Link to Data
https://bit.ly/3kGDuKx
0:00 Intro
0:18 Data Overview
1:08 Groupby single col & function
1:55 Multiple cols grouped
2:40 Multiple grouping cols
3:20 Multiple functions flat df
3:43 Multiple functions
4:35 Quick tip
Видео How to use groupby() to group categories in a pandas DataFrame канала Chart Explorers
Did you find this video helpful? Consider subscribing for weekly tips, tricks, and tutorials.
https://www.youtube.com/channel/UC17QKsysOmZ7oJepmmcUTvA?sub_confirmation=1
Link to Data
https://bit.ly/3kGDuKx
0:00 Intro
0:18 Data Overview
1:08 Groupby single col & function
1:55 Multiple cols grouped
2:40 Multiple grouping cols
3:20 Multiple functions flat df
3:43 Multiple functions
4:35 Quick tip
Видео How to use groupby() to group categories in a pandas DataFrame канала Chart Explorers
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to filter a pandas DataFrame | 6 HELPFUL METHODS](https://i.ytimg.com/vi/ni9ng4Jy3Z8/default.jpg)
![Pandas Group By | Python Pandas Tutorial #4 | Split Apply Combine | Python Pandas Aggregate Date](https://i.ytimg.com/vi/Acld5O-WUsc/default.jpg)
![1000x faster data manipulation: vectorizing with Pandas and Numpy](https://i.ytimg.com/vi/nxWginnBklU/default.jpg)
![Daniel Chen: Cleaning and Tidying Data in Pandas | PyData DC 2018](https://i.ytimg.com/vi/iYie42M1ZyU/default.jpg)
![How to get list of column names | pandas](https://i.ytimg.com/vi/O9zkPwnddG4/default.jpg)
![Data Wrangling with PySpark for Data Scientists Who Know Pandas - Andrew Ray](https://i.ytimg.com/vi/XrpSRCwISdk/default.jpg)
![How do I apply a function to a pandas Series or DataFrame?](https://i.ytimg.com/vi/P_q0tkYqvSk/default.jpg)
![How do I use the MultiIndex in pandas?](https://i.ytimg.com/vi/tcRGa2soc-c/default.jpg)
![Solving real world data science tasks with Python Pandas!](https://i.ytimg.com/vi/eMOA1pPVUc4/default.jpg)
![Advanced Use of groupby(), aggregate, filter, transform, apply - Beginner Python Pandas Tutorial #5](https://i.ytimg.com/vi/DUgd48QYmfI/default.jpg)
![Python Pandas Tutorial (Part 8): Grouping and Aggregating - Analyzing and Exploring Your Data](https://i.ytimg.com/vi/txMdrV1Ut64/default.jpg)
![Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019)](https://i.ytimg.com/vi/1Kcco6koC34/default.jpg)
![Loop / Iterate over pandas DataFrame (2020)](https://i.ytimg.com/vi/CG3EV7UBELA/default.jpg)
![PYTHON: PIVOT TABLE | GROUP BY | PANDAS PLOT](https://i.ytimg.com/vi/jOrys_zgjpc/default.jpg)
![My top 25 pandas tricks](https://i.ytimg.com/vi/RlIiVeig3hc/default.jpg)
![Stack, Unstack, Melt, Pivot - Pandas](https://i.ytimg.com/vi/kJsiiPK5sxs/default.jpg)
![CHANGE COLUMN DTYPE | How to change the datatype of a column in Pandas (2020)](https://i.ytimg.com/vi/evKYySLSzyk/default.jpg)
![How do I apply multiple filter criteria to a pandas DataFrame?](https://i.ytimg.com/vi/YPItfQ87qjM/default.jpg)
![Complete Python Pandas Data Science Tutorial! (Reading CSV/Excel files, Sorting, Filtering, Groupby)](https://i.ytimg.com/vi/vmEHCJofslg/default.jpg)
![Drop / Remove duplicate data from pandas](https://i.ytimg.com/vi/JU1EhK89ThE/default.jpg)