|
Attribute
|
Value
|
|
Name
|
Transpose
|
|
Description
|
None
|
|
Function
|
None
|
|
Aim
|
Allow a data engineer (user) to create a new dataset by interchanging the rows and columns of a dataset
|
|
Context
|
This operation is used when the attribute (or column) present in the original/unrefined dataset are required in a row-wise representation or rows are required in a column wise representation, either for reformatting the dataset or a requirement to integrate with another dataset or create meaningful aggregates dependent on the analysis for which the dataset is being prepared for.
|
|
Rationale
|
switching a column into rows to prepare the dataset for subsequent intermediary operations of the wrangling process and the analysis the dataset is being prepared for.
|
|
Mechanisim
|
Switch dataset dimension by switching columns of attribute values to rows. This can be done by exploring the facilities found in GUI-based tools and programming language functions.
|
|
Formalisim
|
T(R) = {(t1,...,tm) | (a1, …, an) ϵ R and (t1,...,tm) ϵ RT, Where: R is a relation with n columns and m rows and RT is its transpose with m columns and n rows.
|
|
Relational Algebra (RA)
|
None
|
|
Type
|
Atomic
|
|
Class
|
None
|
|
Transformation_category
|
None
|
|
Inputs
|
| Inputs | Number of input datasets |
|---|
| None | None |
|
|
Outputs
|
| Outputs | Number of output datasets |
|---|
| None | None |
|
|
Used in stage(s)
|
Structuring2
|