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 222e798d Publish built docs triggered by
b8dd97bc8eefcfecfa8dcc864c4898c654b236a9
222e798d is described below
commit 222e798d390d6e84303d96160330e87fbe7591c9
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Mar 17 14:43:24 2025 +0000
Publish built docs triggered by b8dd97bc8eefcfecfa8dcc864c4898c654b236a9
---
_sources/autoapi/datafusion/context/index.rst.txt | 6 +--
.../autoapi/datafusion/dataframe/index.rst.txt | 2 +-
_sources/autoapi/datafusion/expr/index.rst.txt | 5 +-
.../autoapi/datafusion/functions/index.rst.txt | 2 +-
_sources/autoapi/datafusion/index.rst.txt | 13 ++---
autoapi/datafusion/context/index.html | 6 +--
autoapi/datafusion/dataframe/index.html | 2 +-
autoapi/datafusion/expr/index.html | 6 +--
autoapi/datafusion/functions/index.html | 4 +-
autoapi/datafusion/index.html | 22 ++++----
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 62 +++++++++++-----------
user-guide/common-operations/basic-info.html | 46 ++++++++--------
user-guide/common-operations/functions.html | 20 +++----
14 files changed, 100 insertions(+), 98 deletions(-)
diff --git a/_sources/autoapi/datafusion/context/index.rst.txt
b/_sources/autoapi/datafusion/context/index.rst.txt
index f40f12e8..97b58483 100644
--- a/_sources/autoapi/datafusion/context/index.rst.txt
+++ b/_sources/autoapi/datafusion/context/index.rst.txt
@@ -421,7 +421,7 @@ Module Contents
Create and return a dataframe using the provided partitions.
- :param partitions: :py:class:`pyarrow.RecordBatch` partitions to
register.
+ :param partitions: :py:class:`pa.RecordBatch` partitions to register.
:param name: Resultant dataframe name.
:param schema: Schema for the partitions.
@@ -667,7 +667,7 @@ Module Contents
.. py:method:: register_dataset(name: str, dataset:
pyarrow.dataset.Dataset) -> None
- Register a :py:class:`pyarrow.dataset.Dataset` as a table.
+ Register a :py:class:`pa.dataset.Dataset` as a table.
:param name: Name of the table to register.
:param dataset: PyArrow dataset.
@@ -792,7 +792,7 @@ Module Contents
- .. py:method:: register_view(name: str, df: datafusion.dataframe.DataFrame)
+ .. py:method:: register_view(name: str, df: datafusion.dataframe.DataFrame)
-> None
Register a :py:class: `~datafusion.detaframe.DataFrame` as a view.
diff --git a/_sources/autoapi/datafusion/dataframe/index.rst.txt
b/_sources/autoapi/datafusion/dataframe/index.rst.txt
index e98160df..200e796e 100644
--- a/_sources/autoapi/datafusion/dataframe/index.rst.txt
+++ b/_sources/autoapi/datafusion/dataframe/index.rst.txt
@@ -115,7 +115,7 @@ Module Contents
- .. py:method:: __getitem__(key: str | List[str]) -> DataFrame
+ .. py:method:: __getitem__(key: str | list[str]) -> DataFrame
Return a new :py:class`DataFrame` with the specified column or columns.
diff --git a/_sources/autoapi/datafusion/expr/index.rst.txt
b/_sources/autoapi/datafusion/expr/index.rst.txt
index a2a89c8a..72d4cdc8 100644
--- a/_sources/autoapi/datafusion/expr/index.rst.txt
+++ b/_sources/autoapi/datafusion/expr/index.rst.txt
@@ -292,7 +292,7 @@ Module Contents
- .. py:method:: cast(to: pyarrow.DataType[Any] | Type[float] | Type[int] |
Type[str] | Type[bool]) -> Expr
+ .. py:method:: cast(to: pyarrow.DataType[Any] | type[float | int | str |
bool]) -> Expr
Cast to a new data type.
@@ -540,6 +540,7 @@ Module Contents
.. py:attribute:: _to_pyarrow_types
+ :type: ClassVar[dict[type, pyarrow.DataType]]
.. py:attribute:: expr
@@ -638,7 +639,7 @@ Module Contents
- .. py:method:: get_upper_bound()
+ .. py:method:: get_upper_bound() -> WindowFrameBound
Returns end bound.
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index a3219e79..21fa1d22 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -1847,7 +1847,7 @@ Module Contents
Returns the last ``n`` characters in the ``string``.
-.. py:function:: round(value: datafusion.expr.Expr, decimal_places:
datafusion.expr.Expr = Expr.literal(0)) -> datafusion.expr.Expr
+.. py:function:: round(value: datafusion.expr.Expr, decimal_places:
datafusion.expr.Expr | None = None) -> datafusion.expr.Expr
Round the argument to the nearest integer.
diff --git a/_sources/autoapi/datafusion/index.rst.txt
b/_sources/autoapi/datafusion/index.rst.txt
index 47e36559..84313ece 100644
--- a/_sources/autoapi/datafusion/index.rst.txt
+++ b/_sources/autoapi/datafusion/index.rst.txt
@@ -487,7 +487,7 @@ Package Contents
- .. py:method:: cast(to: pyarrow.DataType[Any] | Type[float] | Type[int] |
Type[str] | Type[bool]) -> Expr
+ .. py:method:: cast(to: pyarrow.DataType[Any] | type[float | int | str |
bool]) -> Expr
Cast to a new data type.
@@ -735,6 +735,7 @@ Package Contents
.. py:attribute:: _to_pyarrow_types
+ :type: ClassVar[dict[type, pyarrow.DataType]]
.. py:attribute:: expr
@@ -1335,7 +1336,7 @@ Package Contents
- .. py:method:: get_upper_bound()
+ .. py:method:: get_upper_bound() -> WindowFrameBound
Returns end bound.
@@ -1456,22 +1457,22 @@ Package Contents
.. py:attribute:: _udwf
-.. py:function:: col(value: str)
+.. py:function:: col(value: str) -> expr.Expr
Create a column expression.
-.. py:function:: column(value: str)
+.. py:function:: column(value: str) -> expr.Expr
Create a column expression.
-.. py:function:: lit(value)
+.. py:function:: lit(value) -> expr.Expr
Create a literal expression.
-.. py:function:: literal(value)
+.. py:function:: literal(value) -> expr.Expr
Create a literal expression.
diff --git a/autoapi/datafusion/context/index.html
b/autoapi/datafusion/context/index.html
index 828509f5..7715d6a4 100644
--- a/autoapi/datafusion/context/index.html
+++ b/autoapi/datafusion/context/index.html
@@ -1628,7 +1628,7 @@ a query against a CSV data source using the <code
class="xref py py-class docuti
<dl class="field-list simple">
<dt class="field-odd">Parameters<span class="colon">:</span></dt>
<dd class="field-odd"><ul class="simple">
-<li><p><strong>partitions</strong> – <code class="xref py py-class docutils
literal notranslate"><span class="pre">pyarrow.RecordBatch</span></code>
partitions to register.</p></li>
+<li><p><strong>partitions</strong> – <code class="xref py py-class docutils
literal notranslate"><span class="pre">pa.RecordBatch</span></code> partitions
to register.</p></li>
<li><p><strong>name</strong> – Resultant dataframe name.</p></li>
<li><p><strong>schema</strong> – Schema for the partitions.</p></li>
</ul>
@@ -1944,7 +1944,7 @@ selected for data input.</p></li>
<dl class="py method">
<dt class="sig sig-object py"
id="datafusion.context.SessionContext.register_dataset">
<span class="sig-name descname"><span
class="pre">register_dataset</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">dataset</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span cla
[...]
-<dd><p>Register a <code class="xref py py-class docutils literal
notranslate"><span class="pre">pyarrow.dataset.Dataset</span></code> as a
table.</p>
+<dd><p>Register a <code class="xref py py-class docutils literal
notranslate"><span class="pre">pa.dataset.Dataset</span></code> as a table.</p>
<dl class="field-list simple">
<dt class="field-odd">Parameters<span class="colon">:</span></dt>
<dd class="field-odd"><ul class="simple">
@@ -2099,7 +2099,7 @@ which returns a PyCapsule that exposes a <code
class="docutils literal notransla
<dl class="py method">
<dt class="sig sig-object py"
id="datafusion.context.SessionContext.register_view">
-<span class="sig-name descname"><span
class="pre">register_view</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">df</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="referen [...]
+<span class="sig-name descname"><span
class="pre">register_view</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">df</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="referen [...]
<dd><p>Register a :py:class: <cite>~datafusion.detaframe.DataFrame</cite> as a
view.</p>
<dl class="field-list simple">
<dt class="field-odd">Parameters<span class="colon">:</span></dt>
diff --git a/autoapi/datafusion/dataframe/index.html
b/autoapi/datafusion/dataframe/index.html
index bffbbf69..2ed6116b 100644
--- a/autoapi/datafusion/dataframe/index.html
+++ b/autoapi/datafusion/dataframe/index.html
@@ -1087,7 +1087,7 @@ those in the DataFrame.</p>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.dataframe.DataFrame.__getitem__">
-<span class="sig-name descname"><span
class="pre">__getitem__</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">key</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span><span class="w"> </span><span
class="p"><span class="pre">|</span></span><span class="w"> </span><span
class="pre">List</span><span class="p"><span class="pre">[</span></span><span
class="pre">st [...]
+<span class="sig-name descname"><span
class="pre">__getitem__</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">key</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span><span class="w"> </span><span
class="p"><span class="pre">|</span></span><span class="w"> </span><span
class="pre">list</span><span class="p"><span class="pre">[</span></span><span
class="pre">st [...]
<dd><p>Return a new :py:class`DataFrame` with the specified column or
columns.</p>
<dl class="field-list simple">
<dt class="field-odd">Parameters<span class="colon">:</span></dt>
diff --git a/autoapi/datafusion/expr/index.html
b/autoapi/datafusion/expr/index.html
index 6636d167..ae120734 100644
--- a/autoapi/datafusion/expr/index.html
+++ b/autoapi/datafusion/expr/index.html
@@ -2063,7 +2063,7 @@ element index begins at <code class="docutils literal
notranslate"><span class="
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.expr.Expr.cast">
-<span class="sig-name descname"><span class="pre">cast</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">to</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">pyarrow.DataType</span><span class="p"><span
class="pre">[</span></span><span class="pre">Any</span><span class="p"><span
class="pre">]</span></span><span class="w"> </span><span class="p"><span
class="pre">|</spa [...]
+<span class="sig-name descname"><span class="pre">cast</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">to</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">pyarrow.DataType</span><span class="p"><span
class="pre">[</span></span><span class="pre">Any</span><span class="p"><span
class="pre">]</span></span><span class="w"> </span><span class="p"><span
class="pre">|</spa [...]
<dd><p>Cast to a new data type.</p>
</dd></dl>
@@ -2316,7 +2316,7 @@ type of expression, an error will be generated when <code
class="docutils litera
<dl class="py attribute">
<dt class="sig sig-object py" id="datafusion.expr.Expr._to_pyarrow_types">
-<span class="sig-name descname"><span
class="pre">_to_pyarrow_types</span></span><a class="headerlink"
href="#datafusion.expr.Expr._to_pyarrow_types" title="Link to this
definition">¶</a></dt>
+<span class="sig-name descname"><span
class="pre">_to_pyarrow_types</span></span><em class="property"><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="pre">ClassVar</span><span class="p"><span
class="pre">[</span></span><span class="pre">dict</span><span class="p"><span
class="pre">[</span></span><span class="pre">type</span><span class="p"><span
class="pre">,</span></span><span class="w"> </span><span
class="pre">pyarrow.DataType</span><span class="p [...]
<dd></dd></dl>
<dl class="py attribute">
@@ -2431,7 +2431,7 @@ parameter must be set.</p></li>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.expr.WindowFrame.get_upper_bound">
-<span class="sig-name descname"><span
class="pre">get_upper_bound</span></span><span class="sig-paren">(</span><span
class="sig-paren">)</span><a class="headerlink"
href="#datafusion.expr.WindowFrame.get_upper_bound" title="Link to this
definition">¶</a></dt>
+<span class="sig-name descname"><span
class="pre">get_upper_bound</span></span><span class="sig-paren">(</span><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span> <span class="sig-return-typehint"><a
class="reference internal" href="#datafusion.expr.WindowFrameBound"
title="datafusion.expr.WindowFrameBound"><span
class="pre">WindowFrameBound</span></a></span></span><a class="headerlink"
href="#datafusion.expr.WindowFrame.get_upper_bound [...]
<dd><p>Returns end bound.</p>
</dd></dl>
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index a3f490d2..05ced227 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -3175,7 +3175,7 @@
<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.right" title="datafusion.functions.right"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">right</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the last <code class="docutils literal notranslate"><span
class="pre">n</span></code> characters in the <code class="docutils literal
notranslate"><span class="pre">string</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.round" title="datafusion.functions.round"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">round</span></code></a>() → datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.round" title="datafusion.functions.round"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">round</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Round the argument to the nearest integer.</p></td>
</tr>
<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.row_number"
title="datafusion.functions.row_number"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">row_number</span></code></a>(→
datafusion.expr.Expr)</p></td>
@@ -5164,7 +5164,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.round">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">round</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">value</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 [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">round</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">value</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion [...]
<dd><p>Round the argument to the nearest integer.</p>
<p>If the optional <code class="docutils literal notranslate"><span
class="pre">decimal_places</span></code> is specified, round to the nearest
number of
decimal places. You can specify a negative number of decimal places. For
example
diff --git a/autoapi/datafusion/index.html b/autoapi/datafusion/index.html
index 43d12118..7e5257ec 100644
--- a/autoapi/datafusion/index.html
+++ b/autoapi/datafusion/index.html
@@ -2042,16 +2042,16 @@ See <a class="reference external"
href="https://datafusion.apache.org/python";>ht
<h2>Functions<a class="headerlink" href="#functions" title="Link to this
heading">¶</a></h2>
<table class="autosummary longtable table autosummary">
<tbody>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.col" title="datafusion.col"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">col</span></code></a>(value)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.col" title="datafusion.col"><code class="xref py py-obj
docutils literal notranslate"><span class="pre">col</span></code></a>(→
expr.Expr)</p></td>
<td><p>Create a column expression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.column" title="datafusion.column"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">column</span></code></a>(value)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.column" title="datafusion.column"><code class="xref py py-obj
docutils literal notranslate"><span class="pre">column</span></code></a>(→
expr.Expr)</p></td>
<td><p>Create a column expression.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.lit" title="datafusion.lit"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">lit</span></code></a>(value)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.lit" title="datafusion.lit"><code class="xref py py-obj
docutils literal notranslate"><span class="pre">lit</span></code></a>(→
expr.Expr)</p></td>
<td><p>Create a literal expression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.literal" title="datafusion.literal"><code class="xref py
py-obj docutils literal notranslate"><span
class="pre">literal</span></code></a>(value)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.literal" title="datafusion.literal"><code class="xref py
py-obj docutils literal notranslate"><span
class="pre">literal</span></code></a>(→ expr.Expr)</p></td>
<td><p>Create a literal expression.</p></td>
</tr>
<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.read_avro" title="datafusion.read_avro"><code class="xref py
py-obj docutils literal notranslate"><span
class="pre">read_avro</span></code></a>(→
datafusion.dataframe.DataFrame)</p></td>
@@ -2471,7 +2471,7 @@ element index begins at <code class="docutils literal
notranslate"><span class="
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.Expr.cast">
-<span class="sig-name descname"><span class="pre">cast</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">to</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">pyarrow.DataType</span><span class="p"><span
class="pre">[</span></span><span class="pre">Any</span><span class="p"><span
class="pre">]</span></span><span class="w"> </span><span class="p"><span
class="pre">|</spa [...]
+<span class="sig-name descname"><span class="pre">cast</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">to</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">pyarrow.DataType</span><span class="p"><span
class="pre">[</span></span><span class="pre">Any</span><span class="p"><span
class="pre">]</span></span><span class="w"> </span><span class="p"><span
class="pre">|</spa [...]
<dd><p>Cast to a new data type.</p>
</dd></dl>
@@ -2724,7 +2724,7 @@ type of expression, an error will be generated when <code
class="docutils litera
<dl class="py attribute">
<dt class="sig sig-object py" id="datafusion.Expr._to_pyarrow_types">
-<span class="sig-name descname"><span
class="pre">_to_pyarrow_types</span></span><a class="headerlink"
href="#datafusion.Expr._to_pyarrow_types" title="Link to this
definition">¶</a></dt>
+<span class="sig-name descname"><span
class="pre">_to_pyarrow_types</span></span><em class="property"><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="pre">ClassVar</span><span class="p"><span
class="pre">[</span></span><span class="pre">dict</span><span class="p"><span
class="pre">[</span></span><span class="pre">type</span><span class="p"><span
class="pre">,</span></span><span class="w"> </span><span
class="pre">pyarrow.DataType</span><span class="p [...]
<dd></dd></dl>
<dl class="py attribute">
@@ -3421,7 +3421,7 @@ parameter must be set.</p></li>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.WindowFrame.get_upper_bound">
-<span class="sig-name descname"><span
class="pre">get_upper_bound</span></span><span class="sig-paren">(</span><span
class="sig-paren">)</span><a class="headerlink"
href="#datafusion.WindowFrame.get_upper_bound" title="Link to this
definition">¶</a></dt>
+<span class="sig-name descname"><span
class="pre">get_upper_bound</span></span><span class="sig-paren">(</span><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span> <span class="sig-return-typehint"><a
class="reference internal"
href="expr/index.html#datafusion.expr.WindowFrameBound"
title="datafusion.expr.WindowFrameBound"><span
class="pre">WindowFrameBound</span></a></span></span><a class="headerlink"
href="#datafusion.WindowFrame.get_u [...]
<dd><p>Returns end bound.</p>
</dd></dl>
@@ -3543,25 +3543,25 @@ using `udwf` as a decorator.</strong></p></li>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.col">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">col</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">value</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span></span></em><span
class="sig-paren">)</span><a class="headerlink" href="#datafusion.col"
title="Link to this definitio [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">col</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">value</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span></span></em><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span> <s [...]
<dd><p>Create a column expression.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.column">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">column</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">value</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span></span></em><span
class="sig-paren">)</span><a class="headerlink" href="#datafusion.column"
title="Link to this def [...]
+<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">column</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">value</span></span><span
class="p"><span class="pre">:</span></span><span class="w"> </span><span
class="n"><span class="pre">str</span></span></em><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span> [...]
<dd><p>Create a column expression.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.lit">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">lit</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">value</span></span></em><span class="sig-paren">)</span><a
class="headerlink" href="#datafusion.lit" title="Link to this
definition">¶</a></dt>
+<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">lit</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">value</span></span></em><span class="sig-paren">)</span> <span
class="sig-return"><span class="sig-return-icon">→</span> <span
class="sig-return-typehint"><a class="reference internal"
href="expr/index.html#datafusion.expr.Expr" title="datafusion. [...]
<dd><p>Create a literal expression.</p>
</dd></dl>
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.literal">
-<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">literal</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">value</span></span></em><span class="sig-paren">)</span><a
class="headerlink" href="#datafusion.literal" title="Link to this
definition">¶</a></dt>
+<span class="sig-prename descclassname"><span
class="pre">datafusion.</span></span><span class="sig-name descname"><span
class="pre">literal</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span
class="pre">value</span></span></em><span class="sig-paren">)</span> <span
class="sig-return"><span class="sig-return-icon">→</span> <span
class="sig-return-typehint"><a class="reference internal"
href="expr/index.html#datafusion.expr.Expr" title="datafus [...]
<dd><p>Create a literal expression.</p>
</dd></dl>
diff --git a/searchindex.js b/searchindex.js
index a782adfd..c718e6d9 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[15, null]], "Aggregate
Functions": [[20, "aggregate-functions"], [27, "aggregate-functions"], [29,
"aggregate-functions"]], "Aggregation": [[20, null]], "Alternative Approach":
[[16, "alternative-approach"]], "Arrays": [[22, "arrays"]], "Arrow": [[33,
null]], "Attributes": [[3, "attributes"], [5, "attributes"], [10,
"attributes"], [14, "attributes"]], "Available Functions": [[29,
"available-functions"]], "Avro": [[34, null]], "Basic Opera [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[15, null]], "Aggregate
Functions": [[20, "aggregate-functions"], [27, "aggregate-functions"], [29,
"aggregate-functions"]], "Aggregation": [[20, null]], "Alternative Approach":
[[16, "alternative-approach"]], "Arrays": [[22, "arrays"]], "Arrow": [[33,
null]], "Attributes": [[3, "attributes"], [5, "attributes"], [10,
"attributes"], [14, "attributes"]], "Available Functions": [[29,
"available-functions"]], "Avro": [[34, null]], "Basic Opera [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 8bd01f00..b2a89dcb 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -482,6 +482,8 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<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">Max</span> <span
class="n">Speed</span> <span class="o">|</span> <span class="n">Avg</span>
<span class="n">Speed</span> <span class="o">|</span> <span
class="n">Min</span> <span class="n">Speed</span> <span class="o">|</span>
<span class="o">+----------+-----------+-------------------+-----------+</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mi">121</span> <span class="o">|</span>
<span class="mf">72.75</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mi">95</span> <span class="o">|</span>
<span class="mf">90.0</span> <span class="o">|</span> <span
class="mi">85</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mf">54.23076923076923</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mi">105</span> <span class="o">|</span>
<span class="mf">86.28571428571429</span> <span class="o">|</span> <span
class="mi">60</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mi">115</span> <span class="o">|</span>
<span class="mf">67.25806451612904</span> <span class="o">|</span> <span
class="mi">15</span> <span class="o">|</span>
@@ -490,8 +492,6 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<span class="o">|</span> <span class="n">Psychic</span> <span
class="o">|</span> <span class="mi">150</span> <span class="o">|</span>
<span class="mf">99.25</span> <span class="o">|</span> <span
class="mi">42</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="mi">150</span> <span class="o">|</span>
<span class="mf">67.5</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="mi">130</span> <span class="o">|</span>
<span class="mf">103.75</span> <span class="o">|</span> <span
class="mi">80</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Dragon</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mf">66.66666666666667</span> <span class="o">|</span> <span
class="mi">50</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mi">121</span> <span class="o">|</span>
<span class="mf">72.75</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
<span class="o">+----------+-----------+-------------------+-----------+</span>
</pre></div>
</div>
@@ -574,15 +574,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">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">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">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">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">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">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</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">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Steel</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Poison</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</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">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</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">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="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">Dark</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="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>
</pre></div>
@@ -599,13 +599,13 @@ 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">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">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">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">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">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">Fighting</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="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">Flying</span><span
class="p">,</span> <span class="n">Water</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">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">Psychic</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">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Water</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Ground</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
@@ -615,15 +615,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">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">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">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">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">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">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">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Ice</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Flying</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">Water</span> <span
class="o">|</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">Fighting</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">,</span> <span class="n">Flying</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>
</pre></div>
@@ -701,20 +701,20 @@ aggregate function without filtering rows from the entire
DataFrame.</p>
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">20</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">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Avg</span> <span
class="n">Speed</span> <span class="n">All</span> <span class="o">|</span>
<span class="n">Avg</span> <span class="n">Speed</span> <span
class="n">Low</span> <span class="n">Attack</span> <span class="o">|</span>
-<span class="o">+----------+-------------------+----------------------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">72.75</span> <span
class="o">|</span> <span class="mf">52.8</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mf">90.0</span> <span
class="o">|</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mf">54.23076923076923</span> <span
class="o">|</span> <span class="mf">42.5</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mf">86.28571428571429</span> <span
class="o">|</span> <span class="mf">65.0</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mf">67.25806451612904</span> <span
class="o">|</span> <span class="mf">63.833333333333336</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mf">58.125</span> <span
class="o">|</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fighting</span> <span
class="o">|</span> <span class="mf">66.14285714285714</span> <span
class="o">|</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Psychic</span> <span
class="o">|</span> <span class="mf">99.25</span> <span
class="o">|</span> <span class="mf">81.75</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="mf">67.5</span> <span
class="o">|</span> <span class="mf">52.5</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="mf">103.75</span> <span
class="o">|</span> <span class="mf">80.0</span> <span
class="o">|</span>
-<span class="o">+----------+-------------------+----------------------+</span>
+<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">Avg</span> <span
class="n">Speed</span> <span class="n">All</span> <span class="o">|</span>
<span class="n">Avg</span> <span class="n">Speed</span> <span
class="n">Low</span> <span class="n">Attack</span> <span class="o">|</span>
+<span class="o">+----------+--------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="mf">66.78571428571429</span> <span
class="o">|</span> <span class="mf">46.0</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="mf">58.785714285714285</span> <span
class="o">|</span> <span class="mf">48.0</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="mf">98.88888888888889</span> <span
class="o">|</span> <span class="mf">72.5</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="mf">47.5</span> <span
class="o">|</span> <span class="mf">35.0</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">72.75</span> <span
class="o">|</span> <span class="mf">52.8</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mf">90.0</span> <span
class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mf">54.23076923076923</span> <span
class="o">|</span> <span class="mf">42.5</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mf">86.28571428571429</span> <span
class="o">|</span> <span class="mf">65.0</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mf">67.25806451612904</span> <span
class="o">|</span> <span class="mf">63.833333333333336</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mf">58.125</span> <span
class="o">|</span> <span class="o">|</span>
+<span class="o">+----------+--------------------+----------------------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index f9dd7832..434efed3 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -414,11 +414,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">209</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">658</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">243</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">767</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">208</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">290</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">587</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">779</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">124</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">696</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -429,8 +429,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">209</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">658</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">290</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">587</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -448,28 +448,28 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">to_pandas</span><span class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">8</span><span class="p">]:</span>
<span class="n">nrs</span> <span class="n">names</span> <span
class="n">random</span> <span class="n">groups</span>
-<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">209</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">658</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">243</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">767</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">208</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">290</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">587</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">779</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">124</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">696</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.describe"
title="datafusion.dataframe.DataFrame.describe"><code class="xref py py-func
docutils literal notranslate"><span class="pre">describe()</span></code></a>
shows a quick statistic summary of your data:</p>
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">9</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span class="n">describe</span><span
class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">9</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
-<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
-<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">417.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.8561892279521</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">208.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">767.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">243.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
+<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
+<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
+<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">495.2</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">278.02284078830644</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">124.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">779.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">587.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/functions.html
b/user-guide/common-operations/functions.html
index a1cdddfd..6bcfebfe 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -505,16 +505,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">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</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">03</span><span class="o">-</span><span
class="mi">17</span><span class="n">T14</span><span class="p">:</span><span
class="mi">43</span><span class="p">:</span><span
class="mf">14.557911249</span><span class="n">Z</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
</pre></div>
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
