Summarize
Filter and then aggregate columns in a table
The filter is applied first to the table. If no filters are included, then the full table is selected. Next, the table is aggregated.
Name | Type | Description | Is Optional |
---|---|---|---|
filters | filter_list | Remove rows using filter logic on one or more columns | True |
summarize | column_agg_list | Columns to summarize | False |
group_by | column_list | One or more columns to group by A categorical column by which to pivot the calculated metrics. Including this argument will generate a new metric calculation for each distinct value in the group by column. If this column has more than 20 distinct values, the plot will not generate. | False |
internet_sales = rasgo.get.dataset(74)
ds1 = internet_sales.query(
summarize={
'SALESAMOUNT': ['COUNT', 'SUM'],
'CUSTOMERKEY': ['COUNT']
},
group_by = ['PRODUCTKEY'])
ds1.preview()
Last modified 7mo ago