Sometimes data is best shaped where the data is in the form of a wide table where the description is in a column header, and sometimes it is best shaped as as having the data descriptor as a variable within a tall table. Continue reading “32. Reshaping Pandas data with stack, unstack, pivot and melt”
Pandas offers two methods of summarising data – groupby and pivot_table*. The data produced can be the same but the format of the output may differ.
*pivot_table summarises data. There is a similar command, pivot, which we will use in the next section which is for reshaping data. Continue reading “31. Summarising data by groups in Pandas using pivot_tables and groupby”