Recently, I participated in the analysis for several marketing questionnaires in a row. Various typical grouping issues are encountered during the process. To share with the interested fellow in the same business, I classified and summarized these issues.
Grouping is to allocate the samples into several groups according to a specific flag. There is a difference between groups and the relative commonness shared by group members. The grouping plays an important role in statistical analytics. For example, the type grouping is used to differentiate the types of economy, society, sciences, and other phenomena. The structural grouping is used to study the internal structure, and the analysis group is used to analyze the coexistence relation between data.
As the mainstream structured data analysis language, both R language and esProc (download) provide the rich functions of grouping. Let's use some examples to have an idea of their difference. In these cases, we will use the Orders table from Northwind database as the sample data.
Basic grouping: group by a certain column, for example, view data by employee.
??R: orderByEmp
Grouping is to allocate the samples into several groups according to a specific flag. There is a difference between groups and the relative commonness shared by group members. The grouping plays an important role in statistical analytics. For example, the type grouping is used to differentiate the types of economy, society, sciences, and other phenomena. The structural grouping is used to study the internal structure, and the analysis group is used to analyze the coexistence relation between data.
As the mainstream structured data analysis language, both R language and esProc (download) provide the rich functions of grouping. Let's use some examples to have an idea of their difference. In these cases, we will use the Orders table from Northwind database as the sample data.
Basic grouping: group by a certain column, for example, view data by employee.
??R: orderByEmp