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 18abaee0 Publish built docs triggered by
85a3595444e7946dc4eaa166cb4843bee2bf2f07
18abaee0 is described below
commit 18abaee029d20f3f1f38143cd849b136c68bdb1f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Mar 19 02:49:59 2026 +0000
Publish built docs triggered by 85a3595444e7946dc4eaa166cb4843bee2bf2f07
---
.../autoapi/datafusion/functions/index.rst.txt | 117 +++++++++++++++------
autoapi/datafusion/functions/index.html | 117 +++++++++++++++------
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 36 +++----
user-guide/common-operations/basic-info.html | 34 +++---
user-guide/common-operations/functions.html | 20 ++--
6 files changed, 220 insertions(+), 106 deletions(-)
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index 6bff0a09..82210801 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -459,10 +459,6 @@ Module Contents
:param filter: If provided, only compute against rows for which the filter
is True
:param order_by: Order the resultant array values. Accepts column names or
expressions.
- For example::
-
- df.aggregate([], array_agg(col("a"), order_by="b"))
-
Examples:
---------
>>> ctx = dfn.SessionContext()
@@ -1572,9 +1568,18 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- cume_dist(order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1., 2., 2., 3.]})
+ >>> result = df.select(
+ ... dfn.col("a"),
+ ... dfn.functions.cume_dist(
+ ... order_by="a"
+ ... ).alias("cd")
+ ... )
+ >>> result.collect_column("cd").to_pylist()
+ [0.25..., 0.75..., 0.75..., 1.0...]
.. py:function:: current_date() -> datafusion.expr.Expr
@@ -1728,9 +1733,14 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- dense_rank(order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 10, 20]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.dense_rank(order_by="a").alias("dr"))
+ >>> result.sort(dfn.col("a")).collect_column("dr").to_pylist()
+ [1, 1, 2]
.. py:function:: digest(value: datafusion.expr.Expr, method:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -1852,9 +1862,15 @@ Module Contents
column names or expressions.
:param null_treatment: Assign whether to respect or ignore null values.
- For example::
+ .. rubric:: Examples
- df.aggregate([], first_value(col("a"), order_by="ts"))
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30]})
+ >>> result = df.aggregate(
+ ... [], [dfn.functions.first_value(dfn.col("a")).alias("v")]
+ ... )
+ >>> result.collect_column("v")[0].as_py()
+ 10
.. py:function:: flatten(array: datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2002,9 +2018,15 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- lag(col("b"), order_by="ts")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1, 2, 3]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.lag(dfn.col("a"), shift_offset=1,
+ ... default_value=0, order_by="a").alias("lag"))
+ >>> result.sort(dfn.col("a")).collect_column("lag").to_pylist()
+ [0, 1, 2]
.. py:function:: last_value(expression: datafusion.expr.Expr, filter:
datafusion.expr.Expr | None = None, order_by: list[datafusion.expr.SortKey] |
datafusion.expr.SortKey | None = None, null_treatment:
datafusion.common.NullTreatment = NullTreatment.RESPECT_NULLS) ->
datafusion.expr.Expr
@@ -2022,9 +2044,15 @@ Module Contents
column names or expressions.
:param null_treatment: Assign whether to respect or ignore null values.
- For example::
+ .. rubric:: Examples
- df.aggregate([], last_value(col("a"), order_by="ts"))
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30]})
+ >>> result = df.aggregate(
+ ... [], [dfn.functions.last_value(dfn.col("a")).alias("v")]
+ ... )
+ >>> result.collect_column("v")[0].as_py()
+ 30
.. py:function:: lcm(x: datafusion.expr.Expr, y: datafusion.expr.Expr) ->
datafusion.expr.Expr
@@ -2073,9 +2101,15 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- lead(col("b"), order_by="ts")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [1, 2, 3]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.lead(dfn.col("a"), shift_offset=1,
+ ... default_value=0, order_by="a").alias("lead"))
+ >>> result.sort(dfn.col("a")).collect_column("lead").to_pylist()
+ [2, 3, 0]
.. py:function:: left(string: datafusion.expr.Expr, n: datafusion.expr.Expr)
-> datafusion.expr.Expr
@@ -2629,9 +2663,15 @@ Module Contents
column names or expressions.
:param null_treatment: Assign whether to respect or ignore null values.
- For example::
+ .. rubric:: Examples
- df.aggregate([], nth_value(col("a"), 2, order_by="ts"))
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30]})
+ >>> result = df.aggregate(
+ ... [], [dfn.functions.nth_value(dfn.col("a"), 2).alias("v")]
+ ... )
+ >>> result.collect_column("v")[0].as_py()
+ 20
.. py:function:: ntile(groups: int, 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
@@ -2659,9 +2699,14 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- ntile(3, order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30, 40]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.ntile(2, order_by="a").alias("nt"))
+ >>> result.sort(dfn.col("a")).collect_column("nt").to_pylist()
+ [1, 1, 2, 2]
.. py:function:: nullif(expr1: datafusion.expr.Expr, expr2:
datafusion.expr.Expr) -> datafusion.expr.Expr
@@ -2761,9 +2806,14 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- percent_rank(order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.percent_rank(order_by="a").alias("pr"))
+ >>> result.sort(dfn.col("a")).collect_column("pr").to_pylist()
+ [0.0, 0.5, 1.0]
.. py:function:: pi() -> datafusion.expr.Expr
@@ -2878,9 +2928,15 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- rank(order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 10, 20]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.rank(order_by="a").alias("rnk")
+ ... )
+ >>> result.sort(dfn.col("a")).collect_column("rnk").to_pylist()
+ [1, 1, 3]
.. py:function:: regexp_count(string: datafusion.expr.Expr, pattern:
datafusion.expr.Expr, start: datafusion.expr.Expr | None = None, flags:
datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
@@ -3297,9 +3353,14 @@ Module Contents
:param order_by: Set ordering within the window frame. Accepts
column names or expressions.
- For example::
+ .. rubric:: Examples
- row_number(order_by="points")
+ >>> ctx = dfn.SessionContext()
+ >>> df = ctx.from_pydict({"a": [10, 20, 30]})
+ >>> result = df.select(
+ ... dfn.col("a"), dfn.functions.row_number(order_by="a").alias("rn"))
+ >>> result.sort(dfn.col("a")).collect_column("rn").to_pylist()
+ [1, 2, 3]
.. py:function:: rpad(string: datafusion.expr.Expr, count:
datafusion.expr.Expr, characters: datafusion.expr.Expr | None = None) ->
datafusion.expr.Expr
@@ -3549,10 +3610,6 @@ Module Contents
:param order_by: Set the ordering of the expression to evaluate. Accepts
column names or expressions.
- For example::
-
- df.aggregate([], string_agg(col("a"), ",", order_by="b"))
-
Examples:
---------
>>> ctx = dfn.SessionContext()
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index 00e4f0c3..2605b360 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -3659,10 +3659,6 @@ the option <code class="docutils literal
notranslate"><span class="pre">null_tre
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">df</span><span
class="o">.</span><span class="n">aggregate</span><span class="p">([],</span>
<span class="n">array_agg</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"b"</span><span class="p">))</span>
-</pre></div>
-</div>
<section id="id4">
<h3>Examples:<a class="headerlink" href="#id4" title="Link to this
heading">ΒΆ</a></h3>
<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>
@@ -4965,8 +4961,17 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">cume_dist</span><span
class="p">(</span><span class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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.</span><span class="p">,</span> <span
class="mf">2.</span><span class="p">,</span> <span class="mf">2.</span><span
class="p">,</span> <span class="mf">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">col</span><span class="p">(</span><span
class="s2">"a"</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">cume_dist</span><span class="p">(</span>
+<span class="gp">... </span> <span class="n">order_by</span><span
class="o">=</span><span class="s2">"a"</span>
+<span class="gp">... </span> <span class="p">)</span><span
class="o">.</span><span class="n">alias</span><span class="p">(</span><span
class="s2">"cd"</span><span class="p">)</span>
+<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">"cd"</span><span
class="p">)</span><span class="o">.</span><span class="n">to_pylist</span><span
class="p">()</span>
+<span class="go">[0.25..., 0.75..., 0.75..., 1.0...]</span>
</pre></div>
</div>
</dd></dl>
@@ -5134,8 +5139,13 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">dense_rank</span><span
class="p">(</span><span class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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">10</span><span class="p">,</span> <span
class="mi">10</span><span class="p">,</span> <span class="mi">20</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">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">functions</span><span class="o">.</span><span
class="n">dense_rank</span><span class="p">(</span><span
class="n">order_by</span><span class="o">=</span><span
class="s2">"a"</span><span class="p">)</span><span class="o">.< [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"dr"</span><span class="p">)</span><span
class="o">.</span><span class="n">to [...]
+<span class="go">[1, 1, 2]</span>
</pre></div>
</div>
</dd></dl>
@@ -5270,8 +5280,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">df</span><span
class="o">.</span><span class="n">aggregate</span><span class="p">([],</span>
<span class="n">first_value</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"ts"</span><span class="p">))</span>
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</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">aggregate</span><span class="p">(</span>
+<span class="gp">... </span> <span class="p">[],</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">first_value</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 c [...]
+<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">"v"</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">10</span>
</pre></div>
</div>
</dd></dl>
@@ -5436,8 +5452,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lag</span><span
class="p">(</span><span class="n">col</span><span class="p">(</span><span
class="s2">"b"</span><span class="p">),</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"ts"</span><span class="p">)</span>
+<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="mi">2</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">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">functions</span><span class="o">.</span><span
class="n">lag</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">default_value</span><span
class="o">=</span><span class="mi">0</span><span class="p">,</span> <span
class="n">order_by</span><span class="o">=</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">"lag"</span><span class="p">))</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"lag"</span><span class="p">)</span><span
class="o">.</span><span class="n">t [...]
+<span class="go">[0, 1, 2]</span>
</pre></div>
</div>
</dd></dl>
@@ -5460,8 +5482,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">df</span><span
class="o">.</span><span class="n">aggregate</span><span class="p">([],</span>
<span class="n">last_value</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"ts"</span><span class="p">))</span>
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</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">aggregate</span><span class="p">(</span>
+<span class="gp">... </span> <span class="p">[],</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">last_value</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 cl [...]
+<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">"v"</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">30</span>
</pre></div>
</div>
</dd></dl>
@@ -5516,8 +5544,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lead</span><span
class="p">(</span><span class="n">col</span><span class="p">(</span><span
class="s2">"b"</span><span class="p">),</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"ts"</span><span class="p">)</span>
+<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="mi">2</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">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">functions</span><span class="o">.</span><span
class="n">lead</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">default_value</span><span
class="o">=</span><span class="mi">0</span><span class="p">,</span> <span
class="n">order_by</span><span class="o">=</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">"lead"</span><span class="p">))</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"lead"</span><span class="p">)</span><span
class="o">.</span><span class="n"> [...]
+<span class="go">[2, 3, 0]</span>
</pre></div>
</div>
</dd></dl>
@@ -6130,8 +6164,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">df</span><span
class="o">.</span><span class="n">aggregate</span><span class="p">([],</span>
<span class="n">nth_value</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="mi">2</span><span class="p">,</span> <span
class="n">order_by</span><span class="o">=</span><span class="s2">"ts [...]
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</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">aggregate</span><span class="p">(</span>
+<span class="gp">... </span> <span class="p">[],</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">nth_value</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="mi">2</span><span class="p">)</span><span
class="o">.</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">"v"</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">20</span>
</pre></div>
</div>
</dd></dl>
@@ -6166,8 +6206,13 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">ntile</span><span
class="p">(</span><span class="mi">3</span><span class="p">,</span> <span
class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</span><span
class="p">,</span> <span class="mi">40</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">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">functions</span><span class="o">.</span><span
class="n">ntile</span><span class="p">(</span><span class="mi">2</span><span
class="p">,</span> <span class="n">order_by</span><span class="o">=</span><span
class="s2">"a"</sp [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"nt"</span><span class="p">)</span><span
class="o">.</span><span class="n">to [...]
+<span class="go">[1, 1, 2, 2]</span>
</pre></div>
</div>
</dd></dl>
@@ -6281,8 +6326,13 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">percent_rank</span><span
class="p">(</span><span class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</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">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">functions</span><span class="o">.</span><span
class="n">percent_rank</span><span class="p">(</span><span
class="n">order_by</span><span class="o">=</span><span
class="s2">"a"</span><span class="p">)</span><span class="o"> [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"pr"</span><span class="p">)</span><span
class="o">.</span><span class="n">to [...]
+<span class="go">[0.0, 0.5, 1.0]</span>
</pre></div>
</div>
</dd></dl>
@@ -6410,8 +6460,14 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">rank</span><span
class="p">(</span><span class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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">10</span><span class="p">,</span> <span
class="mi">10</span><span class="p">,</span> <span class="mi">20</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">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">functions</span><span class="o">.</span><span
class="n">rank</span><span class="p">(</span><span
class="n">order_by</span><span class="o">=</span><span
class="s2">"a"</span><span class="p">)</span><span class="o">.</span>
[...]
+<span class="gp">... </span><span class="p">)</span>
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"rnk"</span><span class="p">)</span><span
class="o">.</span><span class="n">t [...]
+<span class="go">[1, 1, 3]</span>
</pre></div>
</div>
</dd></dl>
@@ -6887,8 +6943,13 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">row_number</span><span
class="p">(</span><span class="n">order_by</span><span class="o">=</span><span
class="s2">"points"</span><span class="p">)</span>
+<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">10</span><span class="p">,</span> <span
class="mi">20</span><span class="p">,</span> <span class="mi">30</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">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">functions</span><span class="o">.</span><span
class="n">row_number</span><span class="p">(</span><span
class="n">order_by</span><span class="o">=</span><span
class="s2">"a"</span><span class="p">)</span><span class="o">.< [...]
+<span class="gp">>>> </span><span class="n">result</span><span
class="o">.</span><span class="n">sort</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">collect_column</span><span class="p">(</span><span
class="s2">"rn"</span><span class="p">)</span><span
class="o">.</span><span class="n">to [...]
+<span class="go">[1, 2, 3]</span>
</pre></div>
</div>
</dd></dl>
@@ -7171,10 +7232,6 @@ column names or expressions.</p></li>
</ul>
</dd>
</dl>
-<p>For example:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">df</span><span
class="o">.</span><span class="n">aggregate</span><span class="p">([],</span>
<span class="n">string_agg</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s2">"a"</span><span class="p">),</span> <span
class="s2">","</span><span class="p">,</span> <span
class="n">order_by</span><span class="o">=</span><span class= [...]
-</pre></div>
-</div>
<section id="id74">
<h3>Examples:<a class="headerlink" href="#id74" title="Link to this
heading">ΒΆ</a></h3>
<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>
diff --git a/searchindex.js b/searchindex.js
index 6469dd97..241f2dbe 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 98027828..f33bc66e 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -620,15 +620,15 @@ 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">Poison</span><span
class="p">,</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="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">Grass</span><span
class="p">,</span> <span class="n">Flying</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">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</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">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">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">Dark</span><span
class="p">,</span> <span class="n">Ice</span><span class="p">,</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">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</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">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="p">,</span> <span
class="n">Flying</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">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>
@@ -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">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">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">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">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="n">Poison</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">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">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">Flying</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">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">Rock</span> <span
class="o">|</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="n">Flying</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">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">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">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">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">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">Psychic</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="n">Ice</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">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">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">Ice</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">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 5d9df8ab..56d41a55 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">367</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">624</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">385</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">697</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">434</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">523</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">345</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">817</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">825</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">992</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">367</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">624</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">523</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">345</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -490,11 +490,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">367</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">624</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">385</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">697</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">434</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">523</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">345</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">817</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">825</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">992</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>
@@ -506,11 +506,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">501.4</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">149.5369519550268</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">367.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">697.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">434.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">700.4</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">260.7351146278537</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">345.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">992.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">817.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 912f21a0..44749694 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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">18</span><span class="n">T06</span><span class="p">:</span><span
class="mi">24</span><span class="p">:</span><span
class="mf">03.732884133</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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">19</span><span class="n">T02</span><span class="p">:</span><span
class="mi">49</span><span class="p">:</span><span
class="mf">46.512166882</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]
