| |
- tan(column_expression)
- DESCRIPTION:
Function computes the tangent value of an argument.
The tangent of an angle is the ratio of two sides of a right triangle.
The ratio is the length of the side opposite to the angle divided
by the length of the side adjacent to the angle.
The tangent of argument returns values in radians.
PARAMETERS:
column_expression:
Required Argument.
Specifies a ColumnExpression of a numeric column or a numeric constant
on which tan() is requested.
Format for the argument: '<dataframe>.<dataframe_column>.expression'.
Notes:
1. If the type of the column/argument is not FLOAT, column values are converted to FLOAT
based on implicit type conversion rules. If an argument cannot be converted, an
error is reported.
2. Unsupported column types:
a. BYTE or VARBYTE
b. LOBs (BLOB or CLOB)
c. CHARACTER or VARCHAR if the server character set is GRAPHIC
NOTE:
Function accepts positional arguments only.
EXAMPLES:
# Load the data to run the example.
>>> load_example_data("dataframe", "admissions_train")
>>>
# Create a DataFrame on 'admissions_train' table.
>>> admissions_train = DataFrame("admissions_train")
>>> admissions_train
masters gpa stats programming admitted
id
22 yes 3.46 Novice Beginner 0
36 no 3.00 Advanced Novice 0
15 yes 4.00 Advanced Advanced 1
38 yes 2.65 Advanced Beginner 1
5 no 3.44 Novice Novice 0
17 no 3.83 Advanced Advanced 1
34 yes 3.85 Advanced Beginner 0
13 no 4.00 Advanced Novice 1
26 yes 3.57 Advanced Advanced 1
19 yes 1.98 Advanced Advanced 0
>>>
# Example calculates tangent value for the "gpa" column with help of SQLAlchemy.
# Import func from sqlalchemy to execute tan() function.
>>> from sqlalchemy import func
# Create a sqlalchemy Function object.
>>> tan_func_ = func.tan(admissions_train.gpa.expression)
>>>
# Pass the Function object as input to DataFrame.assign().
>>> df = admissions_train.assign(tan_gpa_=tan_func_)
>>> print(df)
masters gpa stats programming admitted tan_gpa_
id
15 yes 4.00 Advanced Advanced 1 1.157821
7 yes 2.33 Novice Novice 1 -1.053811
22 yes 3.46 Novice Beginner 0 0.329623
17 no 3.83 Advanced Advanced 1 0.822662
13 no 4.00 Advanced Novice 1 1.157821
38 yes 2.65 Advanced Beginner 1 -0.535436
26 yes 3.57 Advanced Advanced 1 0.456695
5 no 3.44 Novice Novice 0 0.307592
34 yes 3.85 Advanced Beginner 0 0.856763
40 yes 3.95 Novice Beginner 0 1.047111
>>>
|