# 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.

In the above, the tangent of angle A is computed as the following:

`tan(A) = x/y`

The cotangent of angle A is 1/tan(A), or:

`cot(A) = 1/tan(A) = y/x`

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

## Basic Usage

Numeric literal example:

`round(tan(radians(30)),3)`

Output: Returns the computation of the tangent of a 30-degree angle, which is converted to radians before being passed to the `tan` function. The output value is rounded to three decimals: `0.577`.

Column reference example:

`tan(X)`

Output: Returns the tangent of the radians values in `X` column.

## Syntax and Arguments

`tan(numeric_value)`

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column, Decimal or Integer literal, or function returning those types to apply to the function

### numeric_value

Name of the column, Integer or Decimal literal, or function returning that data type to apply to the function.

• Missing input values generate missing results.
• Literal numeric values should not be quoted. Quoted values are treated as strings.
• Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal`0.5`

## Examples

Tip: For additional examples, see How-to Guides.

### Example - Trigonometry functions

This example illustrates how to apply basic trigonometric functions to your transformations. All of the functions take inputs in radians.

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