Split

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:
Department | Sales |
---|---|
HR | 100 |
Finance | 200 |
HR | 150 |
IT | 300 |
Finance | 250 |
Split by Department:
makefile |
---|
HR: HR 100 HR 150 Finance: Finance 200 Finance 250 IT: IT 300 |
Updated 5 months ago