Razorthink AI Guide

Aggregate

Aggregate

This Block allows you to apply aggregate functions like average, sum, max, min and standard deviation on your mentioned columns.

Generate Aggregates

{
  "AVERAGE": {
    "columns": ["id"]
  },
  "SUM": {
    "columns": ["id"]
  },
  "MAX": {
    "columns": ["id"]
  },
  "MIN": {
    "columns": ["id"]
  },
  "STD_DEV": {
    "columns": ["id"]
  },
  "COUNT": {
    "columns": ["id"]
  }
}

Group By

This Block allows you to Group By your data on multiple columns with Max aggregate function.

GroupBy Configuration

{
  "GenerateGroupBy": {
    "columns": [
      "country",
      "population"
    ],
    "aggregate_on": {
      "AVERAGE": {
        "columns": ["id"]
      },
      "SUM": {
        "columns": ["id"]
      },
      "MAX": {
        "columns": ["id"]
      },
      "MIN": {
        "columns": ["id"]
      },
      "STD_DEV": {
        "columns": ["id"]
      },
      "COUNT": {
        "columns": ["id"]
      }
    }
  }
}

Quartiles

Calculates quartiles Q1, Q3, median, IQR for EDA.

Quartile Columns

{
  "column_names": ["test"]
}