Typed Table Transformations

TL;DR

This paper introduces a novel approach to spreadsheet table transformations based on manipulating row and column types, aiming to improve data handling and transformation processes.

Contribution

It proposes a type-based framework for constructing and transforming spreadsheet tables, highlighting a new perspective on table manipulation.

Findings

Conceptual framework for type-based table transformations

Illustration of type-driven table construction and transformation

Identification of future research questions in type-based table processing

Abstract

Spreadsheet tables are often labeled, and these labels effectively constitute types for the data in the table. In such cases tables can be considered to be built from typed data where the placement of values within the table is controlled by the types used for rows and columns. We present a new approach to the transformations of spreadsheet tables that is based on transformations of row and column types. We illustrate the basic idea of type-based table construction and transformation and lay out a series of research questions that should be addressed in future work.