⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 1.3 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 2 of about 2 for banana (0.015 sec.)
Integration with Polars – DuckDB 11228
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 ... in the current scope. import duckdb import polars as pl df = pl . DataFrame ( { "A" : [ 1 , 2 , 3 , 4 , 5 ], "fruits" : [ "banana" , "banana" , "apple" , "apple" , "banana" ], "B" : [ 5 , 4 , 3 , 2 , 1 ], "cars" : [ "beetle" , "audi" , "beetle" , "beet ... can output results as Polars DataFrames using the .pl() result-conversion method. df = duckdb . sql ( """ SELECT 1 AS id, 'banana' AS fruit UNION ALL SELECT 2, 'apple' UNION ALL SELECT 3, 'mango'""" ). pl () print ( df ) shape: (3, 2) ┌─────┬────────┐ ... │ id ┆ fruit │ │ --- ┆ --- │ │ i32 ┆ str │ ╞═════╪════════╡ │ 1 ┆ banana │ │ 2 ┆ apple │ │ 3 ┆ mango │ └─────┴────────┘ To learn more about Polars, feel free to explore their Python API Reference ...
https://man.mtool.work/duckdb/1.3/guides/python/polars.html
Text Functions – DuckDB 7485
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 ... ng, ...) Description Concatenates many strings, separated by separator . NULL inputs are skipped. Example concat_ws(', ', 'Banana', 'Apple', 'Melon') Result Banana, Apple, Melon contains(string, search_string) Description Returns true if search_string ... ns true if the entire string matches the regex . A set of optional regex options can be set. Example regexp_full_match('anabanana', '(an)*') Result false regexp_matches(string, regex[, options]) Description Returns true if string contains the regex , f ... alse otherwise. A set of optional regex options can be set. Example regexp_matches('anabanana', '(an)*') Result true regexp_replace(string, regex, replacement[, options]) Description If string contains the regex , re ...
https://man.mtool.work/duckdb/1.3/sql/functions/text.html
PREV 1 NEXT
DuckDB 1.3 Documentation / man.mtool.work