Page tree

Trifacta Dataprep


Contents:

On January 27, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

 

This example illustrates how to apply inverse (arc) hyperbolic functions to your transformations.

Source:

In the following sample, input values are in radians. In this example, all values are rounded to two decimals for clarity.


Y
-4.00
-3.00
-2.00
-1.00
-0.75
-0.50
0.00
0.50
0.75
1.00
2.00
3.00
4.00

Transformation:

The following transformations include checks for the valid ranges for input values.

Hyperbolic arcsine:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula round(degrees(asinh(Y)), 2)
Parameter: New column name 'asinhY'

Hyperbolic arccosine: 

Valid over the range (y > 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula if(Y>1,round(degrees(acosh(Y)), 2),null())
Parameter: New column name 'acoshY'

Hyperbolic arctangent: 

Valid over the range (-1 < y < 1)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula if(abs(y)<1,round(degrees(atanh(Y)), 2),null())
Parameter: New column name 'atanhY'

Results:

YatanhYacoshYasinhY
-4nullnull-120.02
-3nullnull-104.19
-2nullnull-82.71
-1.5nullnull-68.45
-1nullnull-50.5
-0.75-55.75null-39.71
-0.5-31.47null-27.57
00null0
0.531.47null27.57
0.7555.75null39.71
1nullnull50.5
1.5null55.1468.45
2null75.4682.71
3null101104.19
4null118.23120.02

This page has no comments.