Results of 1 - 2 of about 2 for intercept (0.001 sec.)
- Python Function API 11228
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...esired, you need to explicitly set this parameter to "special" . import duckdb from duckdb.sqltypes import BIGINT def dont_intercept_null(x): return 5 duckdb.create_function("dont_intercept", dont_intercept_null, [BIGINT], BIGINT) res = duckdb.sql("SELECT...dont_intercept(NULL)").fetchall() print(res) [(None,)] With null_handling="special" : import duckdb from duckdb.sqltypes import BIGINT de...f dont_intercept_null(x): return 5 duckdb.create_function("dont_intercept_special", dont_intercept_null, [BIGINT], BIGINT, null_handling="s... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Aggregate Functions 7485
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...where x is the independent variable and y is the dependent variable. regr_count(y, x) The number of non- NULL pairs. regr_intercept(y, x) The intercept of the univariate linear regression line, where x is the independent variable and y is the dependent v...pendent variable. | | Formula | - | regr_count(y, x) | Description | The number of non- NULL pairs. | | Formula | - | regr_intercept(y, x) | Description | The intercept of the univariate linear regression line, where x is the independent variable and y is... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work