Results of 1 - 2 of about 2 for LazyFrame (0.001 sec.)
- Integration with Polars 11228
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...ork. Installation pip install -U duckdb 'polars[pyarrow]' Polars to DuckDB DuckDB can natively query Polars DataFrames and LazyFrames by referring to their names as they exist in the current scope. DuckDB pushes the column selections of a query, and the f...ilters it can translate, into a LazyFrame, so Polars collects only the rows and columns the query needs. A DataFrame is converted in full and filtered afterwards. i...╪════════╡ │ 1 ┆ banana │ │ 2 ┆ apple │ │ 3 ┆ mango │ └─────┴────────┘ The optional lazy parameter allows returning Polars LazyFrames. df = duckdb.sql(""" SELECT 1 AS id, 'banana' AS fruit UNION ALL SELECT 2, 'apple' UNION ALL SELECT 3, 'mango'""" ).pl(la... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- Conversion between DuckDB and Python 7485
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...pe are not preserved. Polars pl() fetches the data of a relation as a Polars DataFrame, and pl(lazy=True) returns a Polars LazyFrame Object Conversion: Python Object to DuckDB Python objects are converted when they are passed as query parameters ( execute... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work