Data Transformation Functions and Operators
Last updated August 14, 2024
Deltaray offers a wide array of functions and operators to transform and manipulate your data, enabling you to prepare it for analysis, create new features, and gain deeper insights. These tools provide a powerful and flexible way to tailor your data to your specific needs.
Data Transformation Capabilities
- Mathematical Operations:
- Arithmetic: Perform basic arithmetic operations (addition, subtraction, multiplication, division).
- Exponents and Roots: Calculate powers and roots of values.
- Trigonometric Functions: Apply trigonometric functions (sin, cos, tan, etc.).
- Logarithmic Functions: Calculate logarithms.
- String Manipulation:
- Text Conversion: Convert data to uppercase or lowercase.
- Substring Extraction: Extract specific portions of text strings.
- Concatenation: Combine multiple strings into a single string.
- Replace: Replace specific characters or patterns within strings.
- Date and Time Functions:
- Formatting: Convert dates and times to different formats.
- Calculations: Calculate differences between dates or times.
- Extraction: Extract components of dates and times (year, month, day, etc.).
- Logical Functions:
- Comparison Operators: Use comparison operators (>, <, >=, <=, ==, !=) to compare values.
- Conditional Logic: Use IF statements to perform actions based on conditions.
- Boolean Operators: Use AND, OR, NOT operators for logical operations.
- Aggregation Functions:
- Sum: Calculate the sum of values.
- Average: Compute the average of values.
- Min/Max: Find the minimum or maximum value.
- Count: Determine the number of values.
- Grouping and Sorting:
- Grouping: Group data by specific fields to perform summary calculations.
- Sorting: Sort data in ascending or descending order based on specific columns.
- Data Encoding:
- One-Hot Encoding: Create binary columns for categorical features.
- Label Encoding: Assign numerical values to categorical features.
- Hash Encoding: Convert categorical values into numerical hashes.
- Custom Functions: Create your own functions to perform specific data transformations tailored to your unique requirements.
Deltaray offers a user-friendly interface and visual tools to apply these functions and operators, making data manipulation intuitive and efficient. You can also write custom code in Deltaray to create more complex data transformations as needed.
Was this article helpful?