Results of 1 - 2 of about 2 for eur (0.003 sec.)
- HTTP CSV Import 11228
- To load a CSV file directly over HTTP(S), the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL comman
...tly over HTTP and aggregates it, with no local download step: SELECT area, round(avg(sunbed_price), 0) AS avg_sunbed_price_eur, count(*) AS clubs FROM 'http://blobs.duckdb.org/data/beach-clubs.csv' WHERE sunbed_price IS NOT NULL GROUP BY area ORDER...BY avg_sunbed_price_eur DESC; ┌────────────────────────────┬──────────────────────┬───────┐ │ area │ avg_sunbed_price_eur │ clubs │ │ varchar │ do... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- Relational API 7485
- 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
..., item, category, price, in_stock) """) from duckdb import col, lit rel.with_columns(price=col("price") * 2, currency=lit("EUR")) Result ┌───────┬─────────────┬──────────┬───────┬──────────┬──────────┐ │ id │ item │ category │ price │ in_stock │ cur...boolean │ varchar │ ├───────┼─────────────┼──────────┼───────┼──────────┼──────────┤ │ 1 │ jeans │ clothing │ 40 │ true │ EUR │ │ 2 │ t-shirt │ clothing │ 16 │ false │ EUR │ │ 3 │ jacket │ clothing │ 130 │ true │ EUR │ │ 4 │ hammer │ tools │ 84 │ t...rue │ EUR │ │ 5 │ screwdriver │ tools │ 14 │ true │ EUR │ │ 6 │ drill │ tools │ 178 │ true │ EUR │ └───────┴─────────────┴──────────... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work