Links

Conditional Agg

Pass in a list of filter rules, and aggregate rows that match.
If multiple rules are passed, they are combined and aggregated both together and separately.

Parameters

Name
Type
Description
Is Optional
rules
value_list
List of filter rules to use
​
agg_column
column
Column to aggregate
​
agg
agg
Method to use when aggregating the agg_column
​
distinct
boolean
When aggregating the agg_column, use TRUE to qualify with a DISTINCT
​

Example

customer = rasgo.get.dataset(55)
​
rules = [
"FIRSTNAME LIKE 'J%'",
"BIRTHDATE < '1970-01-01'",
"ENGLISHEDUCATION = 'Bachelors'",
"MARITALSTATUS = 'M'",
"GENDER='F'"]
​
ds2 = customer.conditional_agg(rules=rules,
agg_column='CUSTOMERKEY',
agg='COUNT',
distinct=True)
ds2.preview()

Source Code

Last modified 1yr ago