Split a dataset into multiple smaller datasets based on a specified column or condition. This is useful when you want to analyze or visualize different parts of your data separately.

  • Property: In the context of a query, a property typically refers to a specific attribute, column, or feature of the dataset that you want to filter or manipulate. For example, it could be the 'age' or 'city' column in a dataset containing customer information.
  • Operator: An operator is a symbol or keyword used in a query to define the relationship between the property and the value. Common operators include equal (==), not equal (!=), greater than (>), less than (<), greater than or equal to (>=), and less than or equal to (<=). Operators allow you to create a condition in the query to filter or manipulate data based on specific criteria.
  • Value: The value is the specific data point you want to compare the property against using the operator. It can be a constant or variable, such as a specific number, text, or date. Values are used in conjunction with properties and operators to create conditions in queries.

Example

Dataset:

DepartmentSales
HR100
Finance200
HR150
IT300
Finance250

Split by Department:

makefile
HR:
HR 100
HR 150

Finance:
Finance 200
Finance 250

IT:
IT 300