Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch. 11 - Summarization (Functions (Count, Sum, Min, First, Max, Last,…
Ch. 11 - Summarization
Things to Note
also known as "group" or "group by"
join tables to create larger table for machine learning
How it works
one or more columns to group data; creates virtual "bucket" for each unique group
each row pertaining to certain unique ID will be placed in bucket
Can summarize by more than one column
Functions
Count
Sum
Min
First
Max
Last
Average
Mode
Median
Standard Deviation
Crosstab
Uses content inside columns to create new columns
"Skinny" data
Rows to column-form
Presents data in readable fashion
Creates new functions for machine learning
Rows become content for columns
Functions can be applied