##### Page tree

Contents:

Our documentation site is moving!

For up-to-date documentation of Dataprep, please visit us at https://help.alteryx.com/Dataprep/.

This example illustrates how to apply basic trigonometric functions to your transformations.

Functions:

ItemDescription
SIN Function Computes the sine of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
COS Function Computes the cosine of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
TAN Function Computes the tangent of an input value for an angle measured in radians. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

The following functions are computed using the above functions:

• Cotangent. Computed as 1/TAN.
• Secant. Computed as 1/COS.
• Cosecant. Computed as 1/SIN.

Also:

ItemDescription
ROUND Function Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.
RADIANS Function Computes the radians of an input value measuring degrees of an angle. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.

Source:

In the following sample, input values are in degrees:

X
-30
0
30
45
60
90
120
135
180

Transformation:

In this example, all values are rounded to three decimals for clarity.

First, the above values in degrees must be converted to radians.

Transformation Name `New formula` `Single row formula` `round(radians(X), 3)` `'rX'`

Sine:

Transformation Name `New formula` `Single row formula` `round(sin(rX), 3)` `'SINrX'`

Cosine:

Transformation Name `New formula` `Single row formula` `round(cos(rX), 3)` `'COSrX'`

Tangent:

Transformation Name `New formula` `Single row formula` `round(tan(rX), 3)` `'TANrX'`

Cotangent:

Transformation Name `New formula` `Single row formula` `round(1 / tan(rX), 3)` `'COTrX'`

Secant:

Transformation Name `New formula` `Single row formula` `round(1 / cos(rX), 3)` `'SECrX'`

Cosecant:

Transformation Name `New formula` `Single row formula` `round(1 / sin(rX), 3)` `'CSCrX'`

Results:

XrXCOTrXSECrXCSCrXTANrXCOSrXSINrX
-30-0.524-1.731.155-1.999-0.5780.866-0.5
00null1null010
300.5241.731.1551.9990.5780.8660.5
450.7851.0011.4141.4150.9990.7070.707
601.0470.5781.9991.1551.7310.50.866
901.5710-4909.8261-4909.82601
1202.094-0.577-2.0011.154-1.734-0.50.866
1352.356-1-1.4141.414-1-0.7070.707
1803.1422454.913-1-2454.9130-10