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 d4b79a1b Publish built docs triggered by
1ba8807cfd3ea878dbd866554a547da7148e2d4e
d4b79a1b is described below
commit d4b79a1b5603fc900367802727b34b964d3874f6
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Aug 25 13:08:27 2025 +0000
Publish built docs triggered by 1ba8807cfd3ea878dbd866554a547da7148e2d4e
---
_sources/autoapi/datafusion/expr/index.rst.txt | 2 +-
.../autoapi/datafusion/functions/index.rst.txt | 28 ++++++++---------
autoapi/datafusion/expr/index.html | 2 +-
autoapi/datafusion/functions/index.html | 28 ++++++++---------
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 36 +++++++++++-----------
user-guide/common-operations/basic-info.html | 34 ++++++++++----------
user-guide/common-operations/functions.html | 28 ++++++++---------
8 files changed, 80 insertions(+), 80 deletions(-)
diff --git a/_sources/autoapi/datafusion/expr/index.rst.txt
b/_sources/autoapi/datafusion/expr/index.rst.txt
index 81bb5b5a..c5a8d517 100644
--- a/_sources/autoapi/datafusion/expr/index.rst.txt
+++ b/_sources/autoapi/datafusion/expr/index.rst.txt
@@ -1032,7 +1032,7 @@ Module Contents
.. py:attribute:: raw_sort
-.. py:class:: Window(partition_by: Optional[list[Expr]] = None, window_frame:
Optional[WindowFrame] = None, order_by: Optional[list[SortExpr | Expr]] = None,
null_treatment: Optional[datafusion.common.NullTreatment] = None)
+.. py:class:: Window(partition_by: Optional[list[Expr] | Expr] = None,
window_frame: Optional[WindowFrame] = None, order_by: Optional[list[SortExpr |
Expr] | Expr | SortExpr] = None, null_treatment:
Optional[datafusion.common.NullTreatment] = None)
Define reusable window parameters.
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index 3b5f3b45..26a92da0 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -371,7 +371,7 @@ Module Contents
This is an alias for :py:func:`make_array`.
-.. py:function:: array_agg(expression: datafusion.expr.Expr, distinct: bool =
False, filter: Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: array_agg(expression: datafusion.expr.Expr, distinct: bool =
False, filter: Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Aggregate values into an array.
@@ -882,7 +882,7 @@ Module Contents
:param filter: If provided, only compute against rows for which the filter
is True
-.. py:function:: cume_dist(partition_by: Optional[list[datafusion.expr.Expr]]
= None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr]] = None) -> datafusion.expr.Expr
+.. py:function:: cume_dist(partition_by: Optional[list[datafusion.expr.Expr] |
datafusion.expr.Expr] = None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr] | datafusion.expr.Expr | datafusion.expr.SortExpr] =
None) -> datafusion.expr.Expr
Create a cumulative distribution window function.
@@ -953,7 +953,7 @@ Module Contents
Converts the argument from radians to degrees.
-.. py:function:: dense_rank(partition_by: Optional[list[datafusion.expr.Expr]]
= None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr]] = None) -> datafusion.expr.Expr
+.. py:function:: dense_rank(partition_by: Optional[list[datafusion.expr.Expr]
| datafusion.expr.Expr] = None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr] | datafusion.expr.Expr | datafusion.expr.SortExpr] =
None) -> datafusion.expr.Expr
Create a dense_rank window function.
@@ -1024,7 +1024,7 @@ Module Contents
The string list is a string composed of substrings separated by ``,``
characters.
-.. py:function:: first_value(expression: datafusion.expr.Expr, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None,
null_treatment: datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS)
-> datafusion.expr.Expr
+.. py:function:: first_value(expression: datafusion.expr.Expr, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None, null_treatment:
datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS) ->
datafusion.expr.Expr
Returns the first value in a group of values.
@@ -1082,7 +1082,7 @@ Module Contents
Returns true if a given number is +0.0 or -0.0 otherwise returns false.
-.. py:function:: lag(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Optional[Any] = None, partition_by:
Optional[list[datafusion.expr.Expr]] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: lag(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Optional[Any] = None, partition_by:
Optional[list[datafusion.expr.Expr] | datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Create a lag window function.
@@ -1110,7 +1110,7 @@ Module Contents
:param order_by: Set ordering within the window frame.
-.. py:function:: last_value(expression: datafusion.expr.Expr, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None,
null_treatment: datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS)
-> datafusion.expr.Expr
+.. py:function:: last_value(expression: datafusion.expr.Expr, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None, null_treatment:
datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS) ->
datafusion.expr.Expr
Returns the last value in a group of values.
@@ -1130,7 +1130,7 @@ Module Contents
Returns the least common multiple.
-.. py:function:: lead(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Optional[Any] = None, partition_by:
Optional[list[datafusion.expr.Expr]] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: lead(arg: datafusion.expr.Expr, shift_offset: int = 1,
default_value: Optional[Any] = None, partition_by:
Optional[list[datafusion.expr.Expr] | datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Create a lead window function.
@@ -1512,7 +1512,7 @@ Module Contents
This will use the same value for all instances of now() in same statement.
-.. py:function:: nth_value(expression: datafusion.expr.Expr, n: int, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None,
null_treatment: datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS)
-> datafusion.expr.Expr
+.. py:function:: nth_value(expression: datafusion.expr.Expr, n: int, filter:
Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None, null_treatment:
datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS) ->
datafusion.expr.Expr
Returns the n-th value in a group of values.
@@ -1528,7 +1528,7 @@ Module Contents
:param null_treatment: Assign whether to respect or ignore null values.
-.. py:function:: ntile(groups: int, partition_by:
Optional[list[datafusion.expr.Expr]] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: ntile(groups: int, partition_by:
Optional[list[datafusion.expr.Expr] | datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Create a n-tile window function.
@@ -1583,7 +1583,7 @@ Module Contents
extends for ``length`` characters with new substring.
-.. py:function:: percent_rank(partition_by:
Optional[list[datafusion.expr.Expr]] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: percent_rank(partition_by:
Optional[list[datafusion.expr.Expr] | datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Create a percent_rank window function.
@@ -1637,7 +1637,7 @@ Module Contents
Create a list of values in the range between start and stop.
-.. py:function:: rank(partition_by: Optional[list[datafusion.expr.Expr]] =
None, order_by: Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]]
= None) -> datafusion.expr.Expr
+.. py:function:: rank(partition_by: Optional[list[datafusion.expr.Expr] |
datafusion.expr.Expr] = None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr] | datafusion.expr.Expr | datafusion.expr.SortExpr] =
None) -> datafusion.expr.Expr
Create a rank window function.
@@ -1862,7 +1862,7 @@ Module Contents
``round(lit(125.2345), lit(-2))`` would yield a value of ``100.0``.
-.. py:function:: row_number(partition_by: Optional[list[datafusion.expr.Expr]]
= None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr]] = None) -> datafusion.expr.Expr
+.. py:function:: row_number(partition_by: Optional[list[datafusion.expr.Expr]
| datafusion.expr.Expr] = None, order_by: Optional[list[datafusion.expr.Expr |
datafusion.expr.SortExpr] | datafusion.expr.Expr | datafusion.expr.SortExpr] =
None) -> datafusion.expr.Expr
Create a row number window function.
@@ -1978,7 +1978,7 @@ Module Contents
This is an alias for :py:func:`stddev`.
-.. py:function:: string_agg(expression: datafusion.expr.Expr, delimiter: str,
filter: Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr]] = None) ->
datafusion.expr.Expr
+.. py:function:: string_agg(expression: datafusion.expr.Expr, delimiter: str,
filter: Optional[datafusion.expr.Expr] = None, order_by:
Optional[list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr] = None) -> datafusion.expr.Expr
Concatenates the input strings.
@@ -2163,7 +2163,7 @@ Module Contents
detailed usage.
-.. py:function:: window(name: str, args: list[datafusion.expr.Expr],
partition_by: list[datafusion.expr.Expr] | None = None, order_by:
list[datafusion.expr.Expr | datafusion.expr.SortExpr] | None = None,
window_frame: datafusion.expr.WindowFrame | None = None, ctx:
datafusion.context.SessionContext | None = None) -> datafusion.expr.Expr
+.. py:function:: window(name: str, args: list[datafusion.expr.Expr],
partition_by: list[datafusion.expr.Expr] | datafusion.expr.Expr | None = None,
order_by: list[datafusion.expr.Expr | datafusion.expr.SortExpr] |
datafusion.expr.Expr | datafusion.expr.SortExpr | None = None, window_frame:
datafusion.expr.WindowFrame | None = None, ctx:
datafusion.context.SessionContext | None = None) -> datafusion.expr.Expr
Creates a new Window function expression.
diff --git a/autoapi/datafusion/expr/index.html
b/autoapi/datafusion/expr/index.html
index 09568fc1..0b21f068 100644
--- a/autoapi/datafusion/expr/index.html
+++ b/autoapi/datafusion/expr/index.html
@@ -3734,7 +3734,7 @@ type of expression, an error will be generated when <code
class="docutils litera
<dl class="py class">
<dt class="sig sig-object py" id="datafusion.expr.Window">
-<em class="property"><span class="pre">class</span><span class="w">
</span></em><span class="sig-prename descclassname"><span
class="pre">datafusion.expr.</span></span><span class="sig-name descname"><span
class="pre">Window</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span [...]
+<em class="property"><span class="pre">class</span><span class="w">
</span></em><span class="sig-prename descclassname"><span
class="pre">datafusion.expr.</span></span><span class="sig-name descname"><span
class="pre">Window</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span [...]
<dd><p>Define reusable window parameters.</p>
<p>Construct a window definition.</p>
<dl class="field-list simple">
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index 148d655d..88f4b063 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -3486,7 +3486,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.array_agg">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">array_agg</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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">d [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">array_agg</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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">d [...]
<dd><p>Aggregate values into an array.</p>
<p>Currently <code class="docutils literal notranslate"><span
class="pre">distinct</span></code> and <code class="docutils literal
notranslate"><span class="pre">order_by</span></code> cannot be used together.
As a work around,
consider <a class="reference internal" href="#datafusion.functions.array_sort"
title="datafusion.functions.array_sort"><code class="xref py py-func docutils
literal notranslate"><span class="pre">array_sort()</span></code></a> after
aggregation.
@@ -4094,7 +4094,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.cume_dist">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cume_dist</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/i [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">cume_dist</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/i [...]
<dd><p>Create a cumulative distribution window function.</p>
<p>This window function is similar to <a class="reference internal"
href="#datafusion.functions.rank" title="datafusion.functions.rank"><code
class="xref py py-func docutils literal notranslate"><span
class="pre">rank()</span></code></a> except that the returned values
are the ratio of the row number to the total numebr of rows. Here is an
example of a
@@ -4178,7 +4178,7 @@ cumulative distribution:</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.dense_rank">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">dense_rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/ [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">dense_rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/ [...]
<dd><p>Create a dense_rank window function.</p>
<p>This window function is similar to <a class="reference internal"
href="#datafusion.functions.rank" title="datafusion.functions.rank"><code
class="xref py py-func docutils literal notranslate"><span
class="pre">rank()</span></code></a> except that the returned values
will be consecutive. Here is an example of a dataframe with a window ordered by
@@ -4259,7 +4259,7 @@ blake2b, and blake3.</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.first_value">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">first_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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" [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">first_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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" [...]
<dd><p>Returns the first value in a group of values.</p>
<p>This aggregate function will return the first value in the partition.</p>
<p>If using the builder functions described in ref:<cite>_aggregation</cite>
this function ignores
@@ -4328,7 +4328,7 @@ characters to lowercase.</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.lag">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">lag</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 [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">lag</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>Create a lag window function.</p>
<p>Lag operation will return the argument that is in the previous
shift_offset-th row
in the partition. For example <code class="docutils literal notranslate"><span
class="pre">lag(col("b"),</span> <span
class="pre">shift_offset=3,</span> <span
class="pre">default_value=5)</span></code>
@@ -4361,7 +4361,7 @@ functions on a simple DataFrame:</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.last_value">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">last_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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"> [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">last_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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"> [...]
<dd><p>Returns the last value in a group of values.</p>
<p>This aggregate function will return the last value in the partition.</p>
<p>If using the builder functions described in ref:<cite>_aggregation</cite>
this function ignores
@@ -4386,7 +4386,7 @@ the option <code class="docutils literal
notranslate"><span class="pre">distinct
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.lead">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">lead</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 [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">lead</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>Create a lead window function.</p>
<p>Lead operation will return the argument that is in the next shift_offset-th
row in
the partition. For example <code class="docutils literal notranslate"><span
class="pre">lead(col("b"),</span> <span
class="pre">shift_offset=3,</span> <span
class="pre">default_value=5)</span></code> will
@@ -4799,7 +4799,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.nth_value">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">nth_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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">d [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">nth_value</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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">d [...]
<dd><p>Returns the n-th value in a group of values.</p>
<p>This aggregate function will return the n-th value in the partition.</p>
<p>If using the builder functions described in ref:<cite>_aggregation</cite>
this function ignores
@@ -4819,7 +4819,7 @@ the option <code class="docutils literal
notranslate"><span class="pre">distinct
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.ntile">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">ntile</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">groups</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">int</span></span></em>, <em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span cla [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">ntile</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">groups</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">int</span></span></em>, <em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span cla [...]
<dd><p>Create a n-tile window function.</p>
<p>This window function orders the window frame into a give number of groups
based on
the ordering criteria. It then returns which group the current row is assigned
to.
@@ -4883,7 +4883,7 @@ extends for <code class="docutils literal
notranslate"><span class="pre">length<
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.percent_rank">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">percent_rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../exp [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">percent_rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../exp [...]
<dd><p>Create a percent_rank window function.</p>
<p>This window function is similar to <a class="reference internal"
href="#datafusion.functions.rank" title="datafusion.functions.rank"><code
class="xref py py-func docutils literal notranslate"><span
class="pre">rank()</span></code></a> except that the returned values
are the percentage from 0.0 to 1.0 from first to last. Here is an example of a
@@ -4948,7 +4948,7 @@ rank:</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.rank">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/index. [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">rank</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/index. [...]
<dd><p>Create a rank window function.</p>
<p>Returns the rank based upon the window order. Consecutive equal values will
receive
the same rank, but the next different value will not be consecutive but rather
the
@@ -5217,7 +5217,7 @@ decimal places. You can specify a negative number of
decimal places. For example
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.row_number">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">row_number</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/ [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">row_number</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">partition_by</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><a
class="reference internal" href="../expr/ [...]
<dd><p>Create a row number window function.</p>
<p>Returns the row number of the window function.</p>
<p>Here is an example of the <code class="docutils literal notranslate"><span
class="pre">row_number</span></code> on a simple DataFrame:</p>
@@ -5358,7 +5358,7 @@ the options <code class="docutils literal
notranslate"><span class="pre">order_b
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.string_agg">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">string_agg</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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"> [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">string_agg</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">expression</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"> [...]
<dd><p>Concatenates the input strings.</p>
<p>This aggregate function will concatenate input strings, ignoring null
values, and
seperating them with the specified delimiter. Non-string values will be
converted to
@@ -5573,7 +5573,7 @@ detailed usage.</p>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.window">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">window</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">name</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">str</span></span></em>, <em class="sig-param"><span class="n"><span
class="pre">args</span></span><span class="p"><s [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">window</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">name</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">str</span></span></em>, <em class="sig-param"><span class="n"><span
class="pre">args</span></span><span class="p"><s [...]
<dd><p>Creates a new Window function expression.</p>
<p>This interface will soon be deprecated. Instead of using this interface,
users should call the window functions directly. For example, to perform a
diff --git a/searchindex.js b/searchindex.js
index 4900c316..ef916557 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[18, null]], "Additional
Resources": [[36, "additional-resources"]], "Aggregate Functions": [[23,
"aggregate-functions"], [30, "aggregate-functions"], [32,
"aggregate-functions"]], "Aggregation": [[23, null]], "Alternative Approach":
[[19, "alternative-approach"]], "Arrays": [[25, "arrays"]], "Arrow": [[38,
null]], "Attributes": [[4, "attributes"], [7, "attributes"], [12,
"attributes"], [17, "attributes"]], "Available Functions": [[32, "av [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[18, null]], "Additional
Resources": [[36, "additional-resources"]], "Aggregate Functions": [[23,
"aggregate-functions"], [30, "aggregate-functions"], [32,
"aggregate-functions"]], "Aggregation": [[23, null]], "Alternative Approach":
[[19, "alternative-approach"]], "Arrays": [[25, "arrays"]], "Arrow": [[38,
null]], "Attributes": [[4, "attributes"], [7, "attributes"], [12,
"attributes"], [17, "attributes"]], "Available Functions": [[32, "av [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index fd1607b6..7e42e0b0 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -610,16 +610,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">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">Bug</span> <span
class="o">|</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="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="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="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="n">Fairy</span><span class="p">,</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">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</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="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">Poison</span><span
class="p">,</span> <span class="n">Fighting</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">Ice</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">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">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ice</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">Fighting</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">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">Data</span> <span class="n">truncated</span><span
class="o">.</span>
</pre></div>
@@ -634,14 +634,14 @@ 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">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">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">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">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">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">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">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">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">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">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="n">Dark</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="o">|</span>
+<span class="o">|</span> <span class="n">Water</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">Fighting</span><span class="p">,</span> <span
class="n">Ice</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="o">|</span>
<span class="o">|</span> <span class="n">Rock</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="n">Water</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>
@@ -653,15 +653,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">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">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">Bug</span> <span
class="o">|</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="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">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">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">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">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">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">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">Dark</span><span
class="p">,</span> <span class="n">Ice</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">Fighting</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">Flying</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">Psychic</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="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 ea968cbb..06e9a4ce 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -446,11 +446,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">664</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">578</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">989</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">776</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">248</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">656</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">630</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">289</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">984</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">130</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -461,8 +461,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">664</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">578</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">656</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">630</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -480,11 +480,11 @@ 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">664</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">578</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">989</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">776</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">248</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">656</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">630</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">289</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">984</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">130</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>
@@ -496,11 +496,11 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<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">651.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">272.84427793157033</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">248.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">989.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">664.0</span> <span class="o">|</span> <span
class="n">null</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">537.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">335.32402240221325</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">130.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">984.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">630.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/functions.html
b/user-guide/common-operations/functions.html
index f08416d0..f877fd7e 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -553,20 +553,20 @@ In here we will cover some of the more popular use cases.
If you want to view al
<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">select</span><span
class="p">(</span><span class="n">f</span><span class="o">.</span><span
class="n">now</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">now</span><span class="p">()</span>
<span class="o">|</span>
-<span class="o">+-----------------------------+</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">57</span><span class="p">:</span><span
class="mf">06.144107</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">+-----------------------------+</span>
+<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">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">25</span><span class="n">T13</span><span class="p">:</span><span
class="mi">08</span><span class="p">:</span><span
class="mf">16.377730945</span><span class="n">Z</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>
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
