Integer

This transform helps to performs arithmetic operation on the selected numerical column.

The Integer data transform performs arithmetic operations on numerical data by applying basic mathematical operations to each data point in a dataset. These operations include addition, subtraction, multiplication, and division. The purpose of these transformations is to modify or manipulate the data in some meaningful way, allowing for easier analysis, visualization, or computation.

• Addition (+): This operation involves adding a constant value to each data point in the dataset. It can be useful for tasks such as shifting the data along the axis or adjusting the data to a new reference point.

• Subtraction (-): Subtraction subtracts a constant value from each data point. In addition, it can be used to shift the data, but in the opposite direction.

• Multiplication (): Multiplication scales each data point by a constant factor. It can stretch or compress the data along the axis, altering its magnitude.

• Division (/): Division divides each data point by a constant value. It can be useful for normalizing the data or expressing it in relative terms.

• Modulus(%): The Modulus divides the given numerator by the denominator to find a result. In simpler words, it produces a remainder for the integer division.

These arithmetic operations can be performed on individual data points or entire datasets. The operations are straightforward and commonly used in data processing and analysis.

For example,

• Users can add a constant offset to calibrate the measurements when dealing with sensor readings.

• In financial analysis, you might multiply data by a scaling factor to adjust for inflation or currency conversions.

Check out the given walk-through on how to use the Addition, Subtraction, and Multiplication options under the Integer transform.

Steps to use the Integer Transform:

• Navigate to the Data Preparation workspace.

• Select a numerical/ Integer column from the dataset.

• Open the Transforms tab.

• Select the Add, Multiply, Subtract, Mod, or Divide transform provided under the Integer category.

  
• The Add, Mulitple, Subtract, Mod, or Divide dialog box opens.

• Provide the following information to apply the integer transform.

  • Enable the Create a New Column option using the checkbox.

  • Provide a name for the newly created column,

  • Operator: There are five arithmetic operations to choose from ( +, -, / , *, %). Select any one operator.

  • Use with: The operation can be performed between two columns and to a column based on a value. The user can select Value or Other Column from the Use with dop-down icon.

  • Operand/Column:

    • The arithmetic operation needs an operand if it is to be used with a value.

    • The arithmetic operation needs another column if the selected Use With option is Column.

Please Note: The first operand is one on which the operation is being performed. The second operand can either be a value or other numerical column based on the choice of use with an option.

• As a result, a new column gets added with the multiplied values of the Marks.

Check out the following illustrations with Addition, Subtraction, Mod, and Percentage operations.

Addition Operation

Subtraction Operation

Modulus Operation

Division Operation