Results of 1 - 5 of about 5 for disc (0.009 sec.)
- Swift Client 12556
- DuckDB has a Swift client. See the announcement post for details. Instantiating DuckDB DuckDB supports both in-memory and persistent databases. To work with an in-memory database, run: let database = try Database(store: .inMemory) To work w
...ad the data from NASA's Exoplanet Archive : wget https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+pl_name+,+disc_year+from+pscomppars&format=csv -O downloaded_exoplanets.csv Once we have our CSV downloaded locally, we can use the follo...t URLSession.shared.download( from: URL(string: "https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=select+pl_name+,+disc_year+from+pscomppars&format=csv")!) // Issue our first query to DuckDB try connection.execute(""" CREATE TABLE exoplanets...me from the TabularData framework. ... import TabularData extension ExoplanetStore { // Retrieves the number of exoplanets discovered by year func groupedByDiscoveryYear() async throws -> DataFrame { // Issue the query we described above let result =... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/swift.html
- Aggregate Functions 9670
- 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
...orted before applying the function. Most aggregate functions are order-insensitive, and for them this clause is parsed and discarded. However, there are some order-sensitive aggregates that can have non-deterministic results without ordering, e.g., f...IST of FLOAT s, then the result is a LIST of the corresponding interpolated quantiles. quantile(x, pos) Alias for quantile_disc . quantile_disc(x, pos) The discrete pos -quantile of x for 0 <= pos <= 1 . Returns the greatest(ceil(pos * n_nonnull_valu...pos . This is Type 1 in Hyndman & Fan (1996). If pos is a LIST of FLOAT s, then the result is a LIST of the corresponding discrete quantiles. regr_avgx(y, x) The average of the independent variable for non- NULL pairs, where x is the independent var... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Relational API 8291
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...within the partition. product Returns the product of all values present in a given expression. quantile Alias of quantile_disc() . quantile_cont Computes the interpolated quantile value for a given expression. quantile_disc Computes the exact quanti...[float] = 0.5, groups: str = '', window_spec: str = '', projected_columns: str = '') -> DuckDBPyRelation Alias of quantile_disc() . quantile_cont quantile_cont(self, expression: str, q: float | builtins.list[float] = 0.5, groups: str = '', window_spe...─────────────────────────────┤ │ clothing │ 20.0 │ │ tools │ 42.0 │ └──────────┴────────────────────────────────┘ quantile_disc quantile_disc(self, expression: str, q: float | builtins.list[float] = 0.5, groups: str = '', window_spec: str = '', proje... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Jupyter Notebooks 7850
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
..., %sqlplot boxplot fails on a native connection of DuckDB's Python client 2.0 with Aggregate Function with name percentile_disc does not exist! . To plot a boxplot, connect via SQLAlchemy. Warning Variables are not recognized within a native DuckDB c... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- Python Client API 7537
- 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
...s the interpolated quantile value for a given expression. Detailed examples can be found at Relational API page . quantile_disc ( expression : str , q : float | builtins.list [ float ] = 0.5 , groups : str = '' , window_spec : str = '' , projected_co...a qualified name: col(“t”, “i”) is “t”.”i” . Every part is quoted whole, so any name works and none is split; a struct field is col(“st”)[“field”] . duckdb. ColumnExpression ( * names : str ) → Expression A column by name, or by the parts of a qualif...ValueOrExpr ) → Expression The value at a quantile, one of the values themselves. Pass the quantile, 0 to 1. SQL: quantile_disc . quantile_cont ( * args : ValueOrExpr ) → Expression The value at a quantile, interpolated. Pass the quantile, 0 to 1. SQ... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work