Results of 1 - 2 of about 2 for CaseExpression (0.003 sec.)
- Expression API 11228
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...Helper Older constructor col(name) ColumnExpression(name) lit(value) ConstantExpression(value) when(condition).then(value) CaseExpression(condition, value) fn(name, *args) FunctionExpression(name, *args) star(exclude=...) StarExpression(exclude=...) sql_expr(t...).select(const).show() ┌─────────┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hello │ │ hello │ │ hello │ │ hello │ └─────────┘ Case Expression This expression is a CASE expression . when(condition).then(value) starts it, each further .when(condition).then(value) a...arge │ │ 21 │ medium │ │ 13 │ small │ │ 14 │ small │ └───────┴─────────┘ The older constructor builds the same expression: CaseExpression(condition, value) takes the first branch, .when(condition, value) adds one and .otherwise(value) closes it: from duckdb im... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Python Client API 7485
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...ation object to a Parquet file in ‘file_name'. Detailed examples can be found at Relational API page . Expressions duckdb. CaseExpression ( condition : object , value : object ) → Expression CASE WHEN condition THEN value , extended by .when(condition, value)...the connection's default holds until one is given. otherwise ( value : object ) → Expression The value of a CASE built by CaseExpression where no branch matches, NULL until given. over ( partition_by : Exprs | None = None , order_by : Exprs | None = None , *...mple variance. SQL: var_samp . when ( condition : object , value : object ) → Expression Another branch of a CASE built by CaseExpression , tried after the ones before it. where ( predicate : Expression ) → Expression Aggregate only rows where the predicate ho... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work