Results of 1 - 6 of about 6 for seed (0.005 sec.)
- Samples 13124
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
...USING SAMPLE 10 PERCENT (reservoir); Select a sample of exactly 50 rows of the table using reservoir sampling with a fixed seed (100): SELECT * FROM tbl USING SAMPLE reservoir(50 ROWS) REPEATABLE (100); Select a sample of approximately 20% of the tab...le using system sampling with a fixed seed (377): SELECT * FROM tbl USING SAMPLE 20% (system, 377); Select a sample of approximately 20% of tbl before the join with...mpling a fixed number of rows. Samples are probabilistic, that is to say, samples can be different between runs unless the seed is specifically specified. Specifying the seed only guarantees that the sample is the same if multi-threading is not enabl... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Multiple Python Threads 9029
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
...gs = (duckdb_con,), name = 'read_thread_' + str(j))) # Shuffle the threads to simulate a mix of readers and writers random.seed(6) # Set the seed to ensure consistent results when testing random.shuffle(threads) Run Threads and Show Results Now, kick... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Relational API 8518
- 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
...ject Alias of select() . rename Rename columns, given as old=new. sample A random subset: n rows, or percent of them, with seed repeating a draw. select Project the relation object by the projection in project_expr. select_dtypes Alias of select_type...───────────┴──────────┴────────────┴──────────┘ sample sample(self, n: int | None = None, *, percent: float | None = None, seed: int | None = None, method: str | None = None) -> DuckDBPyRelation A random subset: n rows, or percent of them, with seed...repeating a draw. See Samples for the sampling methods. A fixed seed gives the same sample on every run only when DuckDB runs on one thread. Parameters n : int, default: None The number of ro... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Numeric Functions 8353
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...even rule . Values s < 0 are allowed. round(v NUMERIC, s INTEGER) Round to s decimal places. Values s < 0 are allowed. setseed(x) Sets the seed to be used for the random function. sign(x) Returns the sign of x as -1, 0 or 1. signbit(x) Returns wheth...Description | Round to s decimal places. Values s < 0 are allowed. | | Example | round(42.4332, 2) | | Result | 42.43 | setseed(x) | Description | Sets the seed to be used for the random function. | | Example | setseed(0.42) | sign(x) | Description |... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Python Client API 7914
- 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
...tailed examples can be found at Relational API page . sample ( n : int | None = None , * , percent : float | None = None , seed : int | None = None , method : str | None = None ) → DuckDBPyRelation A random subset: n rows, or percent of them, with se... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Spatial Functions 7841
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...ified bounding box. Takes a bounding box ( min_x , min_y , max_x , max_y ), a count of points to generate and optionally a seed for the random number generator. Example SELECT * FROM ST_GeneratePoints({min_x: 0, min_y:0, max_x:10, max_y:10}::BOX_2D,... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work