How to create a reduced table

A reduced table is derived by the reducing operation on a parent table. The reducing operation is to compute the averages of a number of rows that have the same reducing character on each applicable column. The reducing character refers to same values on the reducing column(s).

Reducing on single column

To reduce on a single column, select the column, RightClick on the column header, and select Create reduced table in the popup menu.

For example, if reducing on the Epoch column, the reduced table will be the results of averaging the rows that have the same epoch number. Therefore, a 5-epoch table will be reduced to a table with five rows and each row contains the average values for each applicable column. Since only numerical columns can be averaged, only numerical columns will be kept in the reduced table.

Like a subset table, the reduced table will be shown as a new tab next to the original table on the navigation bar. The active tab is highlighted in yellow. You can see the new reduced table contains five rows representing five epochs. The columns are metric_avg. You can plot Epoch vs a metric column, which represents the averaged metric evolution of all samples over epochs.

Reducing on multiple columns

Reduction can also be done based on multiple columns. The averaging will be done on the rows that have the same combined values of the reducing columns. To reduce on multiple columns, select the columns, RightClick on one of the selected column headers, and select Create reduced table in the popup menu.

For example, if reducing on the Label and Predicted_Label columns, the reduced table will be the results of averaging the rows that have the same label-predicted label pair. Therefore, the Cifar-10 dataset will result to up to 100 rows in the reduced table. There are 99 rows in this example as one pair (automobile-deer) does not exist in this Run. You can create some confusion-matrix-like box charts in the reduced table. Please see How to create confusion matrix for how to make these charts.

Reduced chart vs Reduced table

In the How to tweak a chart tutorial, we introduced how to make a reduced chart with the Tweak chart dialog. It serves as a quick way to plot some reduced metrics without making a reduced table. It only computes the averages for the x/y/z columns in the chart. And also, reduced charts are dynamic, which means that the average values (i.e., locations of data points in the chart) will be dynamically changed if some data points are filtered in/out.

On the other hand, the reduced table computes averages for all applicable columns and is static once it’s created. You can always create another reduced table after applying some filters if needed.