# 23. Pandas: Groupby, Melt, Stack/Unstack, Crosstab, Get Dummies in Python - 11 | Tutorial

Показать описание

The video discusses several data reshaping methods in Python.

Timeline
(Python 3.7)

00:00 - Welcome
00:08 - Outline of video
01:11 - Open Jupyter Notebook
01:24 - Data
02:20 - .melt()
04:20 - .wide_to_long()
06:44 - .groupby()
08:16 - Create a multi-index DataFrame
12:03 - MultiIndex GroupBy - Level=1; Axis=1 (i.e. column indexes)
13:40 - MultiIndex GroupBy - Level=0; Axis=1 (i.e. column indexes)
14:21 - MultiIndex GroupBy - Level=0; Axis=0 (i.e. row indexes)
15:15 - MultiIndex GroupBy - Level=1; Axis=0 (i.e. row indexes)
16:10 - MultiIndex Stack/Unstack - Level=1; Axis=1 (i.e. column indexes)
19:25 - MultiIndex Stack/Unstack - Level=0; Axis=1 (i.e. column indexes)
20:44 - MultiIndex Unstack/Stack - Level=1; Axis=0 (i.e. row indexes)
23:07 - MultiIndex Unstack/Stack - Level=0; Axis=0 (i.e. row indexes)
24:22 - Get Dummies - convert single column
26:20 - Get Dummies - prefix in a list
26:46 - Get Dummies - convert multiple columns
27:27 - Get Dummies - prefix in a dictionary
28:12 - Get Dummies - drop_first=True
29:34 - Crosstab - Frequency or counts
31:20 - Crosstab - aggfunc = sum or mean etc.
32:44 - Ending notes