Results of 1 - 10 of about 10 for dict (0.008 sec.)
- Conversion between DuckDB and Python – DuckDB 12943
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..."test" ] Will become VARCHAR[] because 12345 can convert to VARCHAR but test can not convert to INTEGER . [ 12345 , test ] dict The dict object can convert to either STRUCT(...) or MAP(..., ...) depending on its structure. If the dict has a structure...similar to: import duckdb my_map_dict = { "key" : [ 1 , 2 , 3 ], "value" : [ "one" , "two" , "three" ] } duckdb . values ( my_map_dict ) Then we'll convert it t...ee} │ │ map(integer, varchar) │ ├─────────────────────────┤ │ {1=one, 2=two, 3=three} │ └─────────────────────────┘ If the dict is returned by a function , the function will return a MAP , therefore the function return_type has to be specified. Provi... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Types API – DuckDB 11495
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...type. Which can also be arbitrarily nested. import duckdb from typing import Union duckdb . typing . DuckDBPyType ( list [ dict [ Union [ str , int ], str ]]) MAP(UNION(u1 VARCHAR, u2 BIGINT), VARCHAR)[] dict[key_type, value_type] dict type objects m...ap to a MAP type of the key type and the value type. import duckdb print ( duckdb . typing . DuckDBPyType ( dict [ str , int ])) MAP(VARCHAR, BIGINT) {'a': field_one, 'b': field_two, ..., 'n': field_n} dict objects map to a STRUCT comp...osed of the keys and values of the dict. import duckdb print ( duckdb . typing . DuckDBPyType ({ 'a' : str , 'b' : int })) STRUCT(a VARCHAR, b BIGINT) Union[type_... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- Python Client API – DuckDB 9832
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...list ¶ Fetch the next set of rows from a result following execute fetchnumpy ( self : duckdb.duckdb.DuckDBPyConnection ) → dict ¶ Fetch a result as list of NumPy arrays following execute fetchone ( self : duckdb.duckdb.DuckDBPyConnection ) → Optional...ate a relation object from the named table function with given parameters tf ( self : duckdb.duckdb.DuckDBPyConnection ) → dict ¶ Fetch a result as dict of TensorFlow Tensors following execute() torch ( self : duckdb.duckdb.DuckDBPyConnection ) → dic...t ¶ Fetch a result as dict of PyTorch Tensors following execute() type ( self : duckdb.duckdb.DuckDBPyConnection , type_str : str ) → duckdb.duckdb.t... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- SQL on Pandas – DuckDB 8313
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...re regular tables within DuckDB. import duckdb import pandas # Create a Pandas dataframe my_df = pandas . DataFrame . from_dict ({ 'a' : [ 42 ]}) # query the Pandas DataFrame "my_df" # Note: duckdb.sql connects to the default in-memory database conne...aframe DataFrame table Documentation Guides Copy Markdown stored local variables queried they regular tables within Create dict query Note 関連するページ Import from Pandas Export to Pandas Relational API on Pandas Data Ingestion Jupyter Notebooks Gu... - https://man.mtool.work/duckdb/1.3/guides/python/sql_on_pandas.html
- Data Ingestion – DuckDB 8009
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...and scanners . See the Python guides for more examples. import duckdb import pandas as pd test_df = pd . DataFrame . from_dict ({ "i" : [ 1 , 2 , 3 , 4 ], "j" : [ "one" , "two" , "three" , "four" ]}) print ( duckdb . sql ( "SELECT * FROM test_df" )....This is useful when querying a DataFrame/Arrow object that is stored in another way (as a class variable, or a value in a dictionary). Below is a Pandas example: If your Pandas DataFrame is stored in another location, here is an example of manually...registering it: import duckdb import pandas as pd my_dictionary = {} my_dictionary [ "test_df" ] = pd . DataFrame . from_dict ({ "i" : [ 1 , 2 , 3 , 4 ], "j" : [ "one" , "two" , "t... - https://man.mtool.work/duckdb/1.3/clients/python/data_ingestion.html
- Relational API – DuckDB 7937
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ptional[str] Delimiter to use; defaults to comma. delimiter : Optional[str] Alternative delimiter to use. dtype : Optional[Dict[str, str]], Optional[List[str]] Data types for columns. na_values : Optional[str], Optional[List[str]] Additional strings...nal[List[str]] List of column names to use. lineterminator : Optional[str] Character to break lines on. columns : Optional[Dict[str, str]] Column mapping for schema. auto_type_candidates : Optional[List[str]] List of columns for automatic type infere...e-style partitioning. union_by_name : Optional[bool] Union files by column name instead of position. hive_types : Optional[Dict[str, str]] Hive types for columns. hive_types_autocast : Optional[bool] Automatically cast Hive types. connection : DuckDB... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Import from Pandas – DuckDB 7776
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...me thanks to replacement scans . import duckdb import pandas # Create a Pandas dataframe my_df = pandas . DataFrame . from_dict ({ 'a' : [ 42 ]}) # create the table "my_table" from the DataFrame "my_df" # Note: duckdb.sql connects to the default in-m... - https://man.mtool.work/duckdb/1.3/guides/python/import_pandas.html
- Relational API on Pandas – DuckDB 7705
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ort duckdb import pandas # connect to an in-memory database con = duckdb . connect () input_df = pandas . DataFrame . from_dict ({ 'i' : [ 1 , 2 , 3 , 4 ], 'j' : [ "one" , "two" , "three" , "four" ]}) # create a DuckDB relation from a dataframe rel =... - https://man.mtool.work/duckdb/1.3/guides/python/relational_api_pandas.html
- Python DB API – DuckDB 7633
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...tion to a database. This is done through the duckdb.connect method. The 'config' keyword argument can be used to provide a dict that contains key->value pairs referencing settings understood by DuckDB. In-Memory Connection The special value :memory:...c., it's also possible to supply named parameters, like $my_parameter . When using named parameters, you have to provide a dictionary mapping of str to value in the parameters argument. An example use is the following: import duckdb res = duckdb . ex... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Jupyter Notebooks – DuckDB 7633
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...kDB is able to find and query any dataframe stored as a variable in the Jupyter notebook. input_df = pd . DataFrame . from_dict ({ "i" : [ 1 , 2 , 3 ], "j" : [ "one" , "two" , "three" ]}) The dataframe being queried can be specified just like any oth... - https://man.mtool.work/duckdb/1.3/guides/python/jupyter.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work