Icon

02 Data aggregation

There has been no title set for this workflow's metadata.

There has been no description set for this workflow's metadata.

Game stats from all the players are combined, and the resulting data has been aggregated and summarized.

Top branch: total points are determined by GroupBy, calculated for each game (i.e. each data file). Then the play time is calculated by taking the difference between the beginning and the end time stamps.

Bottom branch: a pivot table is generated, with rows corresponding to games (i.e., data files) and the columns corresponding to response types (correct, incorrect, or no response). The missing values are imputed, and the counts data have been transformed to percentage.

Combining the branches: Both branches are combined by the Joiner node. Username and the beginning time stamp are retained as identifiers, rather than the file path. The total score, the play time, and the percentage of each response type are retained in the final data table

Session 4 - Loop

Workflow 02 Data Aggregation

Reading all game stats files
Table Reader
Converting 0,1,& 2 to incorrect, correct, & no response
Rule Engine
Aggregation by each player each session
GroupBy
Converting start & end time stamps to date&time datatype
String to Date&Time
Joining points, playtime, and response percentatge
Joiner
Calculating playtime
Date&Time Difference
Counting correct, incorrect, and no response for each play
Pivot
Filling in missing values
Missing Value
Converting to percentage
Math Formula (Multi Column)
Renamingcolumns
Column Renamer

Nodes

Extensions

Links