Results of 1 - 5 of about 5 for DuckDBPyRelation (0.006 sec.)
- Python Client API 11674
- 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
...: str ) → bool Check if a filesystem with the provided name is currently registered from_arrow ( arrow_object : object ) → DuckDBPyRelation Create a relation object from an Arrow object. from_csv_auto ( * args : object , ** kwargs : object ) → DuckDBPyRelation C...reate a relation object from the CSV file in ‘name'. from_df ( df : object ) → DuckDBPyRelation Create a relation object from the DataFrame in df. from_parquet ( path_or_buffer : object , binary_as_string : bool = Fals...e , ** kwargs : Any ) → DuckDBPyRelation Create a relation object from the Parquet path(s) or file-like object(s) in ‘path_or_buffer'. from_query ( query : object... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Relational API 11177
- 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
...ate a relation object for the named view. from_arrow from_arrow(self: _duckdb.DuckDBPyConnection, arrow_object: object) -> DuckDBPyRelation Create a relation object from an Arrow object. Parameters arrow_object : object The Arrow object to create a relation from...│ a │ └──────┴─────────┘ from_csv_auto from_csv_auto(self: _duckdb.DuckDBPyConnection, *args: object, **kwargs: object) -> DuckDBPyRelation Alias of read_csv() . from_df from_df(self: _duckdb.DuckDBPyConnection, df: object) -> DuckDBPyRelation Create a relation...t from_parquet(self: _duckdb.DuckDBPyConnection, path_or_buffer: object, binary_as_string: bool = False, **kwargs: Any) -> DuckDBPyRelation Alias of read_parquet() . from_query from_query(self: _duckdb.DuckDBPyConnection, query: object, *, alias: str = '', param... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Export to Apache Arrow 7813
- All results of a query can be exported to an Apache Arrow Table using the to_arrow_table function. Alternatively, results can be returned as a RecordBatchReader using the to_arrow_reader function and results can be read one batch at a time.
...tional API Arrow objects can also be exported from the Relational API. A relation can be converted to an Arrow table using DuckDBPyRelation.to_arrow_table , and to an Arrow record batch reader using DuckDBPyRelation.to_arrow_reader . import duckdb # connect to a... - https://man.mtool.work/duckdb/2.0/guides/python/export_arrow.html
- Relational API on Pandas 7666
- DuckDB offers a relational API that can be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can poin
...table or write to a CSV. Please see the Relational API page for more examples and the available relational methods on the DuckDBPyRelation class .... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
- Expression API 7574
- 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
...ment of a list by position, counting from 1, or an entry of a map by key Order Operations When expressions are provided to DuckDBPyRelation.order() , which takes one expression, or to DuckDBPyRelation.sort() , which takes several, the following order operations... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work