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.
  • A unit of 1 radian identifies the angle of a circle where the radius of the circle equals the length of the arc on the circle for that angle. This value corresponds to approximately 57.3 degrees.
  • Input units are in degrees.
  • You can convert from radians to degrees. For more information, see DEGREES Function.

Basic Usage

Numeric literal example:

derive type:single value: ROUND(RADIANS(57.2728),4)

Output: Generates a column containing the computation in radians of 57.2728 rounded to four digits, which is 1.0000.

Column reference example:

derive type:single value: RADIANS(myDegrees) as: myRads'

Output: Generates the new myRads column containing the conversion of the values in MyDegrees column to radians.

Syntax

derive type:single value: RADIANS(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

For more information on syntax standards, see Language Documentation Syntax Notes.

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 literal10

Examples

Example - DEGREES and RADIANS functions

This example illustrates to use the DEGREES and RADIANS functions to convert values from one unit of measure to the other.

Source:

In this example, the source data contains information about a set of isosceles triangles. Each triangle is listed in a separate row, with the listed value as the size of the non-congruent angle in the triangle in degrees.

You must calculate the measurement of all three angles of each isosceles triangle in radians.

trianglea01
t0130
t0260
t0390
t04120
t05150


Transform:

You can convert the value for the non-congruent angle to radians using the following:

derive type:single value: ROUND(RADIANS(a01), 4) as: 'r01'

Now, calculate the value in degrees of the remaining two angles, which are congruent. Since the sum of all angles in a triangle is 180, the following formula can be applied to compute the size in degrees of each of these angles:

derive type:single value: (180 - a01) / 2 as: 'a02'

Convert the above to radians:

derive type:single value: ROUND(RADIANS(a02), 4) as: 'r02'

Create a second column for the other congruent angle:

derive type:single value: ROUND(RADIANS(a02), 4) as: 'r03'

To check accuracy, you sum all three columns and convert to degrees:

derive type:single value: ROUND(DEGREES(r01 + r02 + r03), 4) as: 'checksum'


Results:

After you drop the intermediate columns, you see the following results and determine the error in the checksum is acceptable:

trianglea01r03r02r01checksum
t01301.30951.30950.5238179.9967
t02601.04761.04761.0476179.9967
t03900.78570.78571.5714179.9967
t041200.52380.52382.0952179.9967
t051500.26190.26192.6190179.9967

Was this page helpful? Let us know how we did:

Send feedback about...

Google Cloud Dataprep Documentation