Teradata Package for Python Function Reference | 20.00 - asin - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.
Teradata® Package for Python Function Reference - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.03
- Published
- December 2024
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-19
- dita:id
- TeradataPython_FxRef_Enterprise_2000
- Product Category
- Teradata Vantage
- teradataml.dataframe.sql.DataFrameColumn.asin = asin()
- DESCRIPTION:
Function computes the arcsine value of values in column.
The arcsine is the angle whose sine is the values in column.
Result values return an angle in the range -π /2 to π /2 radians, inclusive.
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
RAISES:
TypeError, ValueError, TeradataMlException
RETURNS:
DataFrameColumn
EXAMPLES:
# Load the data to execute the example.
>>> load_example_data("dataframe", "admissions_train")
>>>
# Create a DataFrame on 'admissions_train' table.
>>> df = DataFrame("admissions_train").iloc[:4]
>>> print(df)
masters gpa stats programming admitted
id
3 no 3.70 Novice Beginner 1
4 yes 3.50 Beginner Novice 1
2 yes 3.76 Beginner Beginner 0
1 yes 3.95 Beginner Beginner 0
# Example 1: Calculates arcsine value for the 'gpa column values / 10' and
# pass it as input to DataFrame.assign().
>>> result = df.assign(col = (df.gpa / 10).asin())
>>> print(result)
masters gpa stats programming admitted col
id
3 no 3.70 Novice Beginner 1 0.379009
4 yes 3.50 Beginner Novice 1 0.357571
2 yes 3.76 Beginner Beginner 0 0.385476
1 yes 3.95 Beginner Beginner 0 0.406068
# Example 2: Filter the rows where arcsine of values in 'gpa column values / 10' column
# are greater than 0.38.
>>> print(df[(df.gpa/10).asin() > 0.38])
masters gpa stats programming admitted
id
2 yes 3.76 Beginner Beginner 0
1 yes 3.95 Beginner Beginner 0