Page tree

Trifacta Dataprep


Contents:

 

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

  • Hyperbolic Sine. See SINH Function.
  • Hyperbolic Cosine. See COSH Function.
  • Hyperbolic Tangent. See TANH Function.
  • Hyperbolic Cotangent. Computed as 1/TANH.
  • Hyperbolic Secant. Computed as 1/COSH.
  • Hyperbolic Cosecant. Computed as 1/SINH. 

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
Parameter: Formula type Single row formula
Parameter: Formula round(radians(X), 3)
Parameter: New column name 'rX'

Hyperbolic Sine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(sinh(rX), 3)
Parameter: New column name 'SINHrX'

Hyperbolic Cosine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(cosh(rX), 3)
Parameter: New column name 'COSHrX'

Hyperbolic Tangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(tanh(rX), 3)
Parameter: New column name 'TANHrX'

Hyperbolic Cotangent:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, tanh(rX)), 3)
Parameter: New column name 'COTHrX'

Hyperbolic Secant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, cosh(rX)), 3)
Parameter: New column name 'SECHrX'

Hyperbolic Cosecant:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(divide(1, sinh(rX)), 3)
Parameter: New column name 'CSCHrX'


Results:

XrXTANHrXCOTHrXCOSHrXSECHrXSINHrXCSCHrX
-30-0.524-0.481-2.0791.140.877-0.548-1.825
000null110null
300.5240.4812.0791.140.8770.5481.825
450.7850.6561.5241.3240.7550.8681.152
601.0470.7811.281.60.6251.2490.801
901.5710.9171.0912.510.3982.3020.434
1202.0940.971.0314.120.2433.9970.25
1352.3560.9821.0185.3220.1885.2270.191
1803.1420.9961.00411.5970.08611.5530.087

This page has no comments.