Reshaping Data with pandas
Maria Eugenia Inzaugarat
Data Scientist
Concept of long and wide formats
Use .pivot()
method - columns as unique variables, index as individual observations
Create pivot tables
Learn the difference between .pivot()
and .pivot_table()
From a wide to a long format using:
.melt()
methodwide_to_long()
functionSplitting or concatenating string columns
Multi-level index
Use .stack()
and .unstack()
Handle generated missing data
Combine reshaping and grouping processes
List-like column transformation
Nested data in columns
Reshaping Data with pandas