This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-staging
in repository https://gitbox.apache.org/repos/asf/datafusion-python.git
The following commit(s) were added to refs/heads/asf-staging by this push:
new 29402eb4 Publish built docs triggered by
b9a958e3893a9a208d67aac314a9ede97b370679
29402eb4 is described below
commit 29402eb4788e834d00cebfbe7fcbe510671352c2
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Mar 17 06:51:14 2026 +0000
Publish built docs triggered by b9a958e3893a9a208d67aac314a9ede97b370679
---
.../autoapi/datafusion/functions/index.rst.txt | 192 +++++++++++++++++++-
autoapi/datafusion/functions/index.html | 196 ++++++++++++++++++++-
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 36 ++--
user-guide/common-operations/basic-info.html | 46 ++---
user-guide/common-operations/functions.html | 20 +--
6 files changed, 429 insertions(+), 63 deletions(-)
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index a95aa5f5..02a0c3a1 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -277,10 +277,13 @@ Module Contents
Return the absolute value of a given number.
- Returns:
- --------
- Expr
- A new expression representing the absolute value of the input
expression.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [-1, 0, 1]})
+ >>> result = df.select(dfn.functions.abs(dfn.col("a")).alias("abs"))
+ >>> result.collect_column("abs")[0].as_py()
+ 1
.. py:function:: acos(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -836,11 +839,27 @@ Module Contents
Returns the cube root of a number.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [27]})
+ >>> cbrt_df = df.select(dfn.functions.cbrt(dfn.col("a")).alias("cbrt"))
+ >>> cbrt_df.collect_column("cbrt")[0].as_py()
+ 3.0
+
.. py:function:: ceil(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Returns the nearest integer greater than or equal to argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1.9]})
+ >>> ceil_df = df.select(dfn.functions.ceil(dfn.col("a")).alias("ceil"))
+ >>> ceil_df.collect_column("ceil")[0].as_py()
+ 2.0
+
.. py:function:: char_length(string: datafusion.expr.Expr) ->
datafusion.expr.Expr
@@ -1148,6 +1167,14 @@ Module Contents
Returns the exponential of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [0.0]})
+ >>> result = df.select(dfn.functions.exp(dfn.col("a")).alias("exp"))
+ >>> result.collect_column("exp")[0].as_py()
+ 1.0
+
.. py:function:: extract(part: datafusion.expr.Expr, date:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1160,6 +1187,16 @@ Module Contents
Returns the factorial of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [3]})
+ >>> result = df.select(
+ ... dfn.functions.factorial(dfn.col("a")).alias("factorial")
+ ... )
+ >>> result.collect_column("factorial")[0].as_py()
+ 6
+
.. py:function:: find_in_set(string: datafusion.expr.Expr, string_list:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1200,6 +1237,14 @@ Module Contents
Returns the nearest integer less than or equal to the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1.9]})
+ >>> floor_df = df.select(dfn.functions.floor(dfn.col("a")).alias("floor"))
+ >>> floor_df.collect_column("floor")[0].as_py()
+ 1.0
+
.. py:function:: from_unixtime(arg: datafusion.expr.Expr) ->
datafusion.expr.Expr
@@ -1210,6 +1255,16 @@ Module Contents
Returns the greatest common divisor.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [12], "b": [8]})
+ >>> result = df.select(
+ ... dfn.functions.gcd(dfn.col("a"), dfn.col("b")).alias("gcd")
+ ... )
+ >>> result.collect_column("gcd")[0].as_py()
+ 4
+
.. py:function:: in_list(arg: datafusion.expr.Expr, values:
list[datafusion.expr.Expr], negated: bool = False) -> datafusion.expr.Expr
@@ -1233,6 +1288,14 @@ Module Contents
Returns true if a given number is +0.0 or -0.0 otherwise returns false.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [0.0, 1.0]})
+ >>> result = df.select(dfn.functions.iszero(dfn.col("a")).alias("iz"))
+ >>> result.collect_column("iz")[0].as_py()
+ True
+
.. py:function:: lag(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Any | None = None, partition_by: list[datafusion.expr.Expr] |
datafusion.expr.Expr | None = None, order_by: list[datafusion.expr.SortKey] |
datafusion.expr.SortKey | None = None) -> datafusion.expr.Expr
@@ -1291,6 +1354,16 @@ Module Contents
Returns the least common multiple.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [4], "b": [6]})
+ >>> result = df.select(
+ ... dfn.functions.lcm(dfn.col("a"), dfn.col("b")).alias("lcm")
+ ... )
+ >>> result.collect_column("lcm")[0].as_py()
+ 12
+
.. py:function:: lead(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Any | None = None, partition_by: list[datafusion.expr.Expr] |
datafusion.expr.Expr | None = None, order_by: list[datafusion.expr.SortKey] |
datafusion.expr.SortKey | None = None) -> datafusion.expr.Expr
@@ -1561,21 +1634,55 @@ Module Contents
Returns the natural logarithm (base e) of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1.0]})
+ >>> result = df.select(dfn.functions.ln(dfn.col("a")).alias("ln"))
+ >>> result.collect_column("ln")[0].as_py()
+ 0.0
+
.. py:function:: log(base: datafusion.expr.Expr, num: datafusion.expr.Expr) ->
datafusion.expr.Expr
Returns the logarithm of a number for a particular ``base``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [100.0]})
+ >>> result = df.select(
+ ... dfn.functions.log(dfn.lit(10.0), dfn.col("a")).alias("log")
+ ... )
+ >>> result.collect_column("log")[0].as_py()
+ 2.0
+
.. py:function:: log10(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Base 10 logarithm of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [100.0]})
+ >>> result = df.select(dfn.functions.log10(dfn.col("a")).alias("log10"))
+ >>> result.collect_column("log10")[0].as_py()
+ 2.0
+
.. py:function:: log2(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
Base 2 logarithm of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [8.0]})
+ >>> result = df.select(dfn.functions.log2(dfn.col("a")).alias("log2"))
+ >>> result.collect_column("log2")[0].as_py()
+ 3.0
+
.. py:function:: lower(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1691,6 +1798,17 @@ Module Contents
Returns ``x`` if ``x`` is not ``NaN``. Otherwise returns ``y``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [np.nan, 1.0], "b": [0.0, 0.0]})
+ >>> nanvl_df = df.select(
+ ... dfn.functions.nanvl(dfn.col("a"), dfn.col("b")).alias("nanvl"))
+ >>> nanvl_df.collect_column("nanvl")[0].as_py()
+ 0.0
+ >>> nanvl_df.collect_column("nanvl")[1].as_py()
+ 1.0
+
.. py:function:: now() -> datafusion.expr.Expr
@@ -1823,6 +1941,19 @@ Module Contents
Returns an approximate value of π.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> import builtins
+ >>> result = df.select(
+ ... dfn.functions.pi().alias("pi")
+ ... )
+ >>> builtins.round(
+ ... result.collect_column("pi")[0].as_py(), 5
+ ... )
+ 3.14159
+
.. py:function:: pow(base: datafusion.expr.Expr, exponent:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1835,6 +1966,16 @@ Module Contents
Returns ``base`` raised to the power of ``exponent``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [2.0]})
+ >>> result = df.select(
+ ... dfn.functions.power(dfn.col("a"), dfn.lit(3.0)).alias("pow")
+ ... )
+ >>> result.collect_column("pow")[0].as_py()
+ 8.0
+
.. py:function:: radians(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1859,6 +2000,17 @@ Module Contents
Returns a random value in the range ``0.0 <= x < 1.0``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1]})
+ >>> result = df.select(
+ ... dfn.functions.random().alias("r")
+ ... )
+ >>> val = result.collect_column("r")[0].as_py()
+ >>> 0.0 <= val < 1.0
+ True
+
.. py:function:: range(start: datafusion.expr.Expr, stop:
datafusion.expr.Expr, step: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2164,6 +2316,14 @@ Module Contents
decimal places. You can specify a negative number of decimal places. For
example
``round(lit(125.2345), lit(-2))`` would yield a value of ``100.0``.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1.567]})
+ >>> result = df.select(dfn.functions.round(dfn.col("a"),
dfn.lit(2)).alias("r"))
+ >>> result.collect_column("r")[0].as_py()
+ 1.57
+
.. py:function:: row_number(partition_by: list[datafusion.expr.Expr] |
datafusion.expr.Expr | None = None, order_by: list[datafusion.expr.SortKey] |
datafusion.expr.SortKey | None = None) -> datafusion.expr.Expr
@@ -2268,6 +2428,14 @@ Module Contents
Returns the sign of the argument (-1, 0, +1).
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [-5.0, 0.0, 5.0]})
+ >>> result = df.select(dfn.functions.signum(dfn.col("a")).alias("s"))
+ >>> result.collect_column("s").to_pylist()
+ [-1.0, 0.0, 1.0]
+
.. py:function:: sin(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2307,6 +2475,14 @@ Module Contents
Returns the square root of the argument.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [9.0]})
+ >>> result = df.select(dfn.functions.sqrt(dfn.col("a")).alias("sqrt"))
+ >>> result.collect_column("sqrt")[0].as_py()
+ 3.0
+
.. py:function:: starts_with(string: datafusion.expr.Expr, prefix:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2550,6 +2726,14 @@ Module Contents
Truncate the number toward zero with optional precision.
+ .. rubric:: Examples
+
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1.567]})
+ >>> result = df.select(dfn.functions.trunc(dfn.col("a")).alias("t"))
+ >>> result.collect_column("t")[0].as_py()
+ 1.0
+
.. py:function:: upper(arg: datafusion.expr.Expr) -> datafusion.expr.Expr
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index c02ca01a..840d037c 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -3442,13 +3442,14 @@
<dt class="sig sig-object py" id="datafusion.functions.abs">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">abs</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Return the absolute value of a given number.</p>
-<section id="returns">
-<h3>Returns:<a class="headerlink" href="#returns" title="Link to this
heading">¶</a></h3>
-<dl class="simple">
-<dt>Expr</dt><dd><p>A new expression representing the absolute value of the
input expression.</p>
-</dd>
-</dl>
-</section>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="o">-</span><span class="mi">1</span><span
class="p">,</span> <span class="mi">0</span><span class="p">,</span> <span
class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">abs</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"abs"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4097,12 +4098,28 @@ detailed usage.</p>
<dt class="sig sig-object py" id="datafusion.functions.cbrt">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cbrt</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the cube root of a number.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">27</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">cbrt_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">cbrt</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
+<span class="gp">>>> </span><span class="n">cbrt_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"cbrt"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">3.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.ceil">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">ceil</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the nearest integer greater than or equal to argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.9</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">ceil_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">ceil</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
+<span class="gp">>>> </span><span class="n">ceil_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"ceil"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">2.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4459,6 +4476,14 @@ blake2b, and blake3.</p>
<dt class="sig sig-object py" id="datafusion.functions.exp">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">exp</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns the exponential of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">exp</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"exp"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4472,6 +4497,16 @@ blake2b, and blake3.</p>
<dt class="sig sig-object py" id="datafusion.functions.factorial">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">factorial</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusi [...]
<dd><p>Returns the factorial of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">3</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">factorial</span><span class="p">(</span><span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"a"</span><span
class="p">))</span><span class="o">.</span><span class="n">alias</span><span
class="p">(</span><span class="s2">"factorial"</span><span class="p"
[...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"factorial"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">6</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4517,6 +4552,14 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.floor">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">floor</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Returns the nearest integer less than or equal to the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.9</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">floor_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">floor</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span>< [...]
+<span class="gp">>>> </span><span class="n">floor_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"floor"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4529,6 +4572,16 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.gcd">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">gcd</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">x</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.expr. [...]
<dd><p>Returns the greatest common divisor.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">12</span><span class="p">],</span> <span
class="s2">"b"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">8</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">gcd</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"b"</span><spa [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"gcd"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">4</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4555,6 +4608,14 @@ characters to lowercase.</p>
<dt class="sig sig-object py" id="datafusion.functions.iszero">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">iszero</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Returns true if a given number is +0.0 or -0.0 otherwise returns
false.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">0.0</span><span class="p">,</span> <span
class="mf">1.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">iszero</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><s [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"iz"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4623,6 +4684,16 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.lcm">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">lcm</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">x</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.expr. [...]
<dd><p>Returns the least common multiple.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">4</span><span class="p">],</span> <span
class="s2">"b"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">6</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">lcm</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"b"</span><spa [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"lcm"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">12</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -4900,24 +4971,58 @@ filled with the given <code class="docutils literal
notranslate"><span class="pr
<dt class="sig sig-object py" id="datafusion.functions.ln">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">ln</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">arg</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><a class="reference internal"
href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.expr [...]
<dd><p>Returns the natural logarithm (base e) of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">ln</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"ln"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">0.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.log">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">log</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">base</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the logarithm of a number for a particular <code
class="docutils literal notranslate"><span class="pre">base</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">100.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">log</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">lit</span><span class="p">(</span><span
class="mf">10.0</span><span class="p">),</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class=" [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"log"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">2.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.log10">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">log10</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Base 10 logarithm of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">100.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">log10</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"log10"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">2.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.log2">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">log2</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Base 2 logarithm of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">8.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">log2</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"log2"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">3.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5054,6 +5159,17 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dt class="sig sig-object py" id="datafusion.functions.nanvl">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">nanvl</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">x</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.exp [...]
<dd><p>Returns <code class="docutils literal notranslate"><span
class="pre">x</span></code> if <code class="docutils literal notranslate"><span
class="pre">x</span></code> is not <code class="docutils literal
notranslate"><span class="pre">NaN</span></code>. Otherwise returns <code
class="docutils literal notranslate"><span class="pre">y</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="n">np</span><span class="o">.</span><span
class="n">nan</span><span class="p">,</span> <span class="mf">1.0</span><span
class="p">],</span> <span class="s2">"b"</span><span class="p">:</
[...]
+<span class="gp">>>> </span><span class="n">nanvl_df</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">nanvl</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">col</span><span
class="p">(</span><span class="s2">"b"</span><s [...]
+<span class="gp">>>> </span><span class="n">nanvl_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"nanvl"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">0.0</span>
+<span class="gp">>>> </span><span class="n">nanvl_df</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"nanvl"</span><span
class="p">)[</span><span class="mi">1</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5206,6 +5322,19 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.pi">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">pi</span></span><span
class="sig-paren">(</span><span class="sig-paren">)</span> <span
class="sig-return"><span class="sig-return-icon">→</span> <span
class="sig-return-typehint"><a class="reference internal"
href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span
class="pre">datafusion.expr.Expr</span></a></span>< [...]
<dd><p>Returns an approximate value of π.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="kn">import</span><span
class="w"> </span><span class="nn">builtins</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">pi</span><span class="p">()</span><span class="o">.</span><span
class="n">alias</span><span class="p">(</span><span
class="s2">"pi"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">builtins</span><span
class="o">.</span><span class="n">round</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"pi"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">(),</span> <span
class="mi">5</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="go">3.14159</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5219,6 +5348,16 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.power">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">power</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">base</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Returns <code class="docutils literal notranslate"><span
class="pre">base</span></code> raised to the power of <code class="docutils
literal notranslate"><span class="pre">exponent</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">2.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">power</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">dfn</span><span class="o">.</span><span class="n">lit</span><span
class="p">(</span><span class="mf">3.0</span><span class= [...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"pow"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">8.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5245,6 +5384,17 @@ column names or expressions.</p></li>
<dt class="sig sig-object py" id="datafusion.functions.random">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">random</span></span><span
class="sig-paren">(</span><span class="sig-paren">)</span> <span
class="sig-return"><span class="sig-return-icon">→</span> <span
class="sig-return-typehint"><a class="reference internal"
href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span
class="pre">datafusion.expr.Expr</span></a></sp [...]
<dd><p>Returns a random value in the range <code class="docutils literal
notranslate"><span class="pre">0.0</span> <span class="pre"><=</span> <span
class="pre">x</span> <span class="pre"><</span> <span
class="pre">1.0</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mi">1</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">random</span><span class="p">()</span><span class="o">.</span><span
class="n">alias</span><span class="p">(</span><span
class="s2">"r"</span><span class="p">)</span>
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">val</span> <span
class="o">=</span> <span class="n">result</span><span class="o">.</span><span
class="n">collect_column</span><span class="p">(</span><span
class="s2">"r"</span><span class="p">)[</span><span
class="mi">0</span><span class="p">]</span><span class="o">.</span><span
class="n">as_py</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="mf">0.0</span> <span
class="o"><=</span> <span class="n">val</span> <span class="o"><</span>
<span class="mf">1.0</span>
+<span class="go">True</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5601,6 +5751,14 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<p>If the optional <code class="docutils literal notranslate"><span
class="pre">decimal_places</span></code> is specified, round to the nearest
number of
decimal places. You can specify a negative number of decimal places. For
example
<code class="docutils literal notranslate"><span
class="pre">round(lit(125.2345),</span> <span
class="pre">lit(-2))</span></code> would yield a value of <code class="docutils
literal notranslate"><span class="pre">100.0</span></code>.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.567</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">round</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"r"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.57</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5716,6 +5874,14 @@ by default). If the string is already longer than length
then it is truncated.</
<dt class="sig sig-object py" id="datafusion.functions.signum">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">signum</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion. [...]
<dd><p>Returns the sign of the argument (-1, 0, +1).</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="o">-</span><span class="mf">5.0</span><span
class="p">,</span> <span class="mf">0.0</span><span class="p">,</span> <span
class="mf">5.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">signum</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><s [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"s"</span><span
class="p">)</span><span class="o">.</span><span class="n">to_pylist</span><span
class="p">()</span>
+<span class="go">[-1.0, 0.0, 1.0]</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -5758,6 +5924,14 @@ on the index.</p>
<dt class="sig sig-object py" id="datafusion.functions.sqrt">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">sqrt</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.ex [...]
<dd><p>Returns the square root of the argument.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">9.0</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">sqrt</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><spa [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"sqrt"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">3.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
@@ -6025,6 +6199,14 @@ HH:MM:SS.nnnnnnnnn;</p>
<dt class="sig sig-object py" id="datafusion.functions.trunc">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">trunc</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">num</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.e [...]
<dd><p>Truncate the number toward zero with optional precision.</p>
+<p class="rubric">Examples</p>
+<div class="doctest highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="gp">>>> </span><span
class="n">ctx</span> <span class="o">=</span> <span class="n">dfn</span><span
class="o">.</span><span class="n">SessionContext</span><span class="p">()</span>
+<span class="gp">>>> </span><span class="n">df</span> <span
class="o">=</span> <span class="n">ctx</span><span class="o">.</span><span
class="n">from_pydict</span><span class="p">({</span><span
class="s2">"a"</span><span class="p">:</span> <span
class="p">[</span><span class="mf">1.567</span><span class="p">]})</span>
+<span class="gp">>>> </span><span class="n">result</span> <span
class="o">=</span> <span class="n">df</span><span class="o">.</span><span
class="n">select</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">functions</span><span class="o">.</span><span
class="n">trunc</span><span class="p">(</span><span class="n">dfn</span><span
class="o">.</span><span class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><sp [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">collect_column</span><span
class="p">(</span><span class="s2">"t"</span><span
class="p">)[</span><span class="mi">0</span><span class="p">]</span><span
class="o">.</span><span class="n">as_py</span><span class="p">()</span>
+<span class="go">1.0</span>
+</pre></div>
+</div>
</dd></dl>
<dl class="py function">
diff --git a/searchindex.js b/searchindex.js
index 55b818c7..df32a631 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[19, null]], "Additional
Resources": [[37, "additional-resources"]], "Aggregate Functions": [[24,
"aggregate-functions"], [31, "aggregate-functions"], [33,
"aggregate-functions"]], "Aggregation": [[24, null]], "Alternative Approach":
[[20, "alternative-approach"]], "Apache Iceberg": [[35, "apache-iceberg"]],
"Arrays": [[26, "arrays"]], "Arrow": [[39, null]], "Attributes": [[4,
"attributes"], [5, "attributes"], [7, "attributes"], [12, "attr [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[19, null]], "Additional
Resources": [[37, "additional-resources"]], "Aggregate Functions": [[24,
"aggregate-functions"], [31, "aggregate-functions"], [33,
"aggregate-functions"]], "Aggregation": [[24, null]], "Alternative Approach":
[[20, "alternative-approach"]], "Apache Iceberg": [[35, "apache-iceberg"]],
"Arrays": [[26, "arrays"]], "Arrow": [[39, null]], "Attributes": [[4,
"attributes"], [5, "attributes"], [7, "attributes"], [12, "attr [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 45de1a6f..c2fbbf15 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -620,16 +620,16 @@ Pokemon set. Since there will be many entries of <code
class="docutils literal n
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="p">,</span> <span class="n">Grass</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Steel</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Grass</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Fairy</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Fairy</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ice</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">,</span> <span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Poison</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Rock</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
</pre></div>
@@ -644,15 +644,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Water</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Water</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Ground</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
@@ -663,15 +663,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Grass</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Grass</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Fairy</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Dark</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dark</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index 13bf320e..3e915d71 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -456,11 +456,11 @@
<span class="o">+-----+---------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">267</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">687</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
<span class="n">java</span> <span class="o">|</span> <span
class="mi">749</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
<span class="n">haskell</span> <span class="o">|</span> <span
class="mi">531</span> <span class="o">|</span> <span class="n">C</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="n">go</span> <span class="o">|</span> <span
class="mi">211</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">958</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">220</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
<span class="n">java</span> <span class="o">|</span> <span
class="mi">842</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
<span class="n">haskell</span> <span class="o">|</span> <span
class="mi">940</span> <span class="o">|</span> <span class="n">C</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="n">go</span> <span class="o">|</span> <span
class="mi">619</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -471,8 +471,8 @@
<span class="o">+-----+--------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">267</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">687</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">958</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">220</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -490,28 +490,28 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">to_pandas</span><span class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">8</span><span class="p">]:</span>
<span class="n">nrs</span> <span class="n">names</span> <span
class="n">random</span> <span class="n">groups</span>
-<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">267</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">687</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">749</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">531</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">211</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">958</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">220</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">842</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">940</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">619</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.describe"
title="datafusion.dataframe.DataFrame.describe"><code class="xref py py-func
docutils literal notranslate"><span class="pre">describe()</span></code></a>
shows a quick statistic summary of your data:</p>
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">9</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span class="n">describe</span><span
class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">9</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
-<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
-<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">489.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">std</span> <span
class="o">|</span> <span class="mf">1.5811388300841898</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">242.45411937106783</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span class="o">|</span> <span class="nb">min</span> <span
class="o">|</span> <span class="mf">1.0</span> <span
class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span
class="mf">211.0</span> <span class="o">|</span> <span
class="n">A</span> <span class="o">|</span>
-<span class="o">|</span> <span class="nb">max</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span
class="mf">749.0</span> <span class="o">|</span> <span
class="n">C</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">median</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">531.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
+<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
+<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">715.8</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">std</span> <span
class="o">|</span> <span class="mf">1.5811388300841898</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">308.2372462892828</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">min</span> <span
class="o">|</span> <span class="mf">1.0</span> <span
class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span
class="mf">220.0</span> <span class="o">|</span> <span
class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">max</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span
class="mf">958.0</span> <span class="o">|</span> <span
class="n">C</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">median</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">842.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/functions.html
b/user-guide/common-operations/functions.html
index 212c1352..8a02ede3 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -566,16 +566,16 @@ In here we will cover some of the more popular use cases.
If you want to view al
<span class="o">+-------------------------------+</span>
<span class="o">|</span> <span class="n">now</span><span class="p">()</span>
<span class="o">|</span>
<span class="o">+-------------------------------+</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">59.256571226</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2026</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T06</span><span class="p">:</span><span
class="mi">51</span><span class="p">:</span><span
class="mf">03.219331723</span> <span class="o">|</span>
<span class="o">+-------------------------------+</span>
<span class="n">Data</span> <span class="n">truncated</span><span
class="o">.</span>
</pre></div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
