Unpivot
Performs a UNPIVOT operation, rotating a table by transforming columns into rows
Name | Type | Description | Is Optional |
---|---|---|---|
value_column | string | The name to assign to the generated column that will be populated with the values from the columns in the column list | |
name_column | string | The name to assign to the generated column that will be populated with the names of the columns in the column list | |
column_list | column_list | List of columns in the source table that will be narrowed into a single pivot column. The column names will populate name_column, and the column values will populate value_column. | |
internet_sales = rasgo.get.dataset(74)
ds2 = internet_sales.unpivot(
value_column="SALES_FEES",
name_column="PRODUCT",
column_list=["TAXAMT", "FREIGHT"]
)
ds2.preview()
Last modified 1yr ago