| | |
- sin(column_expression)
- DESCRIPTION:
Function computes the sine value of an argument.
The sine 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 hypotenuse.
The sine of argument returns values in radians in the range -1 to 1, inclusive.
PARAMETERS:
column_expression:
Required Argument.
Specifies a ColumnExpression of a numeric column or a numeric constant
on which sin() 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 sine value for the "gpa" column with help of SQLAlchemy.
# Import func from sqlalchemy to execute sin() function.
>>> from sqlalchemy import func
# Create a sqlalchemy Function object.
>>> sin_func_ = func.sin(admissions_train.gpa.expression)
>>>
# Pass the Function object as input to DataFrame.assign().
>>> df = admissions_train.assign(sin_gpa_=sin_func_)
>>> print(df)
masters gpa stats programming admitted sin_gpa_
id
5 no 3.44 Novice Novice 0 -0.293998
34 yes 3.85 Advanced Beginner 0 -0.650625
13 no 4.00 Advanced Novice 1 -0.756802
40 yes 3.95 Novice Beginner 0 -0.723188
22 yes 3.46 Novice Beginner 0 -0.313054
19 yes 1.98 Advanced Advanced 0 0.917438
36 no 3.00 Advanced Novice 0 0.141120
15 yes 4.00 Advanced Advanced 1 -0.756802
7 yes 2.33 Novice Novice 1 0.725384
17 no 3.83 Advanced Advanced 1 -0.635308
>>>
|