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 48e15ed Publish built docs triggered by
0905f5fca4b763fc61e5e2093a85ad05e203d7fb
48e15ed is described below
commit 48e15ed3d3d562ffb52894c33fefb9819bc9c236
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Oct 16 12:44:44 2024 +0000
Publish built docs triggered by 0905f5fca4b763fc61e5e2093a85ad05e203d7fb
---
_sources/autoapi/datafusion/expr/index.rst.txt | 12 ++
.../autoapi/datafusion/functions/index.rst.txt | 6 +
_sources/autoapi/datafusion/index.rst.txt | 12 ++
autoapi/datafusion/expr/index.html | 30 ++++
autoapi/datafusion/functions/index.html | 158 ++++++++++++---------
autoapi/datafusion/index.html | 30 ++++
genindex.html | 18 ++-
objects.inv | Bin 5558 -> 5579 bytes
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 96 ++++++-------
user-guide/common-operations/basic-info.html | 34 ++---
user-guide/common-operations/functions.html | 22 +--
.../common-operations/select-and-filter.html | 2 +-
user-guide/common-operations/windows.html | 2 +-
14 files changed, 273 insertions(+), 151 deletions(-)
diff --git a/_sources/autoapi/datafusion/expr/index.rst.txt
b/_sources/autoapi/datafusion/expr/index.rst.txt
index 1abd3e6..3323112 100644
--- a/_sources/autoapi/datafusion/expr/index.rst.txt
+++ b/_sources/autoapi/datafusion/expr/index.rst.txt
@@ -331,6 +331,18 @@ Module Contents
+ .. py:method:: fill_nan(value: Any | Expr | None = None) -> Expr
+
+ Fill NaN values with a provided value.
+
+
+
+ .. py:method:: fill_null(value: Any | Expr | None = None) -> Expr
+
+ Fill NULL values with a provided value.
+
+
+
.. py:method:: filter(filter: Expr) -> ExprFuncBuilder
Filter an aggregate function.
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index 3ab0efe..916a16f 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -173,6 +173,7 @@ Functions
datafusion.functions.nth_value
datafusion.functions.ntile
datafusion.functions.nullif
+ datafusion.functions.nvl
datafusion.functions.octet_length
datafusion.functions.order_by
datafusion.functions.overlay
@@ -1487,6 +1488,11 @@ Module Contents
This can be used to perform the inverse operation of the COALESCE
expression.
+.. py:function:: nvl(x: datafusion.expr.Expr, y: datafusion.expr.Expr) ->
datafusion.expr.Expr
+
+ Returns ``x`` if ``x`` is not ``NULL``. Otherwise returns ``y``.
+
+
.. py:function:: octet_length(arg: datafusion.expr.Expr) ->
datafusion.expr.Expr
Returns the number of bytes of a string.
diff --git a/_sources/autoapi/datafusion/index.rst.txt
b/_sources/autoapi/datafusion/index.rst.txt
index 5a781a1..0e69c63 100644
--- a/_sources/autoapi/datafusion/index.rst.txt
+++ b/_sources/autoapi/datafusion/index.rst.txt
@@ -500,6 +500,18 @@ Package Contents
+ .. py:method:: fill_nan(value: Any | Expr | None = None) -> Expr
+
+ Fill NaN values with a provided value.
+
+
+
+ .. py:method:: fill_null(value: Any | Expr | None = None) -> Expr
+
+ Fill NULL values with a provided value.
+
+
+
.. py:method:: filter(filter: Expr) -> ExprFuncBuilder
Filter an aggregate function.
diff --git a/autoapi/datafusion/expr/index.html
b/autoapi/datafusion/expr/index.html
index fc0644b..3e03ad2 100644
--- a/autoapi/datafusion/expr/index.html
+++ b/autoapi/datafusion/expr/index.html
@@ -646,6 +646,24 @@
</code>
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#datafusion.expr.Expr.fill_nan">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ Expr.fill_nan()
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#datafusion.expr.Expr.fill_null">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ Expr.fill_null()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link"
href="#datafusion.expr.Expr.filter">
<code class="docutils literal notranslate">
@@ -2055,6 +2073,18 @@ set parameters for either window or aggregate functions.
If used on any other
type of expression, an error will be generated when <code class="docutils
literal notranslate"><span class="pre">build()</span></code> is called.</p>
</dd></dl>
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.expr.Expr.fill_nan">
+<span class="sig-name descname"><span class="pre">fill_nan</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">Any</span><span class="w"> </span><span class="p"><span
class="pre">|</span></span><span class="w"> </span><a class="reference
internal" href="#datafusion.expr.Expr" title="datafusion.expr.Expr"><span class
[...]
+<dd><p>Fill NaN values with a provided value.</p>
+</dd></dl>
+
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.expr.Expr.fill_null">
+<span class="sig-name descname"><span class="pre">fill_null</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">Any</span><span class="w"> </span><span class="p"><span
class="pre">|</span></span><span class="w"> </span><a class="reference
internal" href="#datafusion.expr.Expr" title="datafusion.expr.Expr"><span clas
[...]
+<dd><p>Fill NULL values with a provided value.</p>
+</dd></dl>
+
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.expr.Expr.filter">
<span class="sig-name descname"><span class="pre">filter</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">filter</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">Expr</span></a></span></em><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon"> [...]
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index 4d3025a..ca82cbd 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -1791,6 +1791,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#datafusion.functions.nvl">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ nvl()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link"
href="#datafusion.functions.octet_length">
<code class="docutils literal notranslate">
@@ -2928,214 +2937,217 @@
<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.nullif" title="datafusion.functions.nullif"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">nullif</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns NULL if expr1 equals expr2; otherwise it returns expr1.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.octet_length"
title="datafusion.functions.octet_length"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">octet_length</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.nvl" title="datafusion.functions.nvl"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">nvl</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<td><p>Returns <code class="docutils literal notranslate"><span
class="pre">x</span></code> if <code class="docutils literal notranslate"><span
class="pre">x</span></code> is not <code class="docutils literal
notranslate"><span class="pre">NULL</span></code>. Otherwise returns <code
class="docutils literal notranslate"><span class="pre">y</span></code>.</p></td>
+</tr>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.octet_length"
title="datafusion.functions.octet_length"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">octet_length</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Returns the number of bytes of a string.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.order_by"
title="datafusion.functions.order_by"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">order_by</span></code></a>(→
datafusion.expr.SortExpr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.order_by"
title="datafusion.functions.order_by"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">order_by</span></code></a>(→
datafusion.expr.SortExpr)</p></td>
<td><p>Creates a new sort expression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.overlay" title="datafusion.functions.overlay"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">overlay</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.overlay" title="datafusion.functions.overlay"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">overlay</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Replace a substring with a new substring.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.percent_rank"
title="datafusion.functions.percent_rank"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">percent_rank</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.percent_rank"
title="datafusion.functions.percent_rank"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">percent_rank</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Create a percent_rank window function.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.pi" title="datafusion.functions.pi"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">pi</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.pi" title="datafusion.functions.pi"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">pi</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns an approximate value of π.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.pow" title="datafusion.functions.pow"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">pow</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.pow" title="datafusion.functions.pow"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">pow</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns <code class="docutils literal notranslate"><span
class="pre">base</span></code> raised to the power of <code class="docutils
literal notranslate"><span class="pre">exponent</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.power" title="datafusion.functions.power"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">power</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.power" title="datafusion.functions.power"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">power</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns <code class="docutils literal notranslate"><span
class="pre">base</span></code> raised to the power of <code class="docutils
literal notranslate"><span class="pre">exponent</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.radians" title="datafusion.functions.radians"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">radians</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.radians" title="datafusion.functions.radians"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">radians</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Converts the argument from degrees to radians.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.random" title="datafusion.functions.random"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">random</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.random" title="datafusion.functions.random"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">random</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns a random value in the range <code class="docutils literal
notranslate"><span class="pre">0.0</span> <span class="pre"><=</span> <span
class="pre">x</span> <span class="pre"><</span> <span
class="pre">1.0</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.range" title="datafusion.functions.range"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">range</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.range" title="datafusion.functions.range"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">range</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Create a list of values in the range between start and stop.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.rank" title="datafusion.functions.rank"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rank</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.rank" title="datafusion.functions.rank"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rank</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Create a rank window function.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_like"
title="datafusion.functions.regexp_like"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regexp_like</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_like"
title="datafusion.functions.regexp_like"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regexp_like</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Find if any regular expression (regex) matches exist.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_match"
title="datafusion.functions.regexp_match"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regexp_match</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_match"
title="datafusion.functions.regexp_match"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regexp_match</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Perform regular expression (regex) matching.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_replace"
title="datafusion.functions.regexp_replace"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">regexp_replace</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_replace"
title="datafusion.functions.regexp_replace"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">regexp_replace</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Replaces substring(s) matching a PCRE-like regular expression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_avgx"
title="datafusion.functions.regr_avgx"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_avgx</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_avgx"
title="datafusion.functions.regr_avgx"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_avgx</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the average of the independent variable <code class="docutils
literal notranslate"><span class="pre">x</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_avgy"
title="datafusion.functions.regr_avgy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_avgy</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_avgy"
title="datafusion.functions.regr_avgy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_avgy</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the average of the dependent variable <code class="docutils
literal notranslate"><span class="pre">y</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_count"
title="datafusion.functions.regr_count"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_count</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_count"
title="datafusion.functions.regr_count"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_count</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Counts the number of rows in which both expressions are not
null.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_intercept"
title="datafusion.functions.regr_intercept"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">regr_intercept</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_intercept"
title="datafusion.functions.regr_intercept"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">regr_intercept</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the intercept from the linear regression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_r2" title="datafusion.functions.regr_r2"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">regr_r2</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_r2" title="datafusion.functions.regr_r2"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">regr_r2</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the R-squared value from linear regression.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_slope"
title="datafusion.functions.regr_slope"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_slope</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_slope"
title="datafusion.functions.regr_slope"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_slope</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the slope from linear regression.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_sxx"
title="datafusion.functions.regr_sxx"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_sxx</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_sxx"
title="datafusion.functions.regr_sxx"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_sxx</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sum of squares of the independent variable <code
class="docutils literal notranslate"><span class="pre">x</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_sxy"
title="datafusion.functions.regr_sxy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_sxy</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_sxy"
title="datafusion.functions.regr_sxy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_sxy</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sum of products of pairs of numbers.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.regr_syy"
title="datafusion.functions.regr_syy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_syy</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regr_syy"
title="datafusion.functions.regr_syy"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regr_syy</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sum of squares of the dependent variable <code
class="docutils literal notranslate"><span class="pre">y</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.repeat" title="datafusion.functions.repeat"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">repeat</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.repeat" title="datafusion.functions.repeat"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">repeat</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Repeats the <code class="docutils literal notranslate"><span
class="pre">string</span></code> to <code class="docutils literal
notranslate"><span class="pre">n</span></code> times.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.replace" title="datafusion.functions.replace"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">replace</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.replace" title="datafusion.functions.replace"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">replace</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Replaces all occurrences of <code class="docutils literal
notranslate"><span class="pre">from_val</span></code> with <code
class="docutils literal notranslate"><span class="pre">to_val</span></code> in
the <code class="docutils literal notranslate"><span
class="pre">string</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.reverse" title="datafusion.functions.reverse"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">reverse</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.reverse" title="datafusion.functions.reverse"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">reverse</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Reverse the string argument.</p></td>
</tr>
-<tr class="row-even"><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>
+<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-odd"><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-even"><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>
+<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>
<td><p>Create a row number window function.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.rpad" title="datafusion.functions.rpad"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rpad</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.rpad" title="datafusion.functions.rpad"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rpad</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Add right padding to a string.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.rtrim" title="datafusion.functions.rtrim"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rtrim</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.rtrim" title="datafusion.functions.rtrim"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">rtrim</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Removes all characters, spaces by default, from the end of a
string.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sha224" title="datafusion.functions.sha224"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha224</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sha224" title="datafusion.functions.sha224"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha224</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the SHA-224 hash of a binary string.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sha256" title="datafusion.functions.sha256"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha256</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sha256" title="datafusion.functions.sha256"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha256</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the SHA-256 hash of a binary string.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sha384" title="datafusion.functions.sha384"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha384</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sha384" title="datafusion.functions.sha384"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha384</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the SHA-384 hash of a binary string.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sha512" title="datafusion.functions.sha512"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha512</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sha512" title="datafusion.functions.sha512"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sha512</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the SHA-512 hash of a binary string.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.signum" title="datafusion.functions.signum"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">signum</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.signum" title="datafusion.functions.signum"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">signum</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the sign of the argument (-1, 0, +1).</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sin" title="datafusion.functions.sin"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sin</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sin" title="datafusion.functions.sin"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sin</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the sine of the argument.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sinh" title="datafusion.functions.sinh"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sinh</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sinh" title="datafusion.functions.sinh"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sinh</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the hyperbolic sine of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.split_part"
title="datafusion.functions.split_part"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">split_part</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.split_part"
title="datafusion.functions.split_part"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">split_part</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Split a string and return one part.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sqrt" title="datafusion.functions.sqrt"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sqrt</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sqrt" title="datafusion.functions.sqrt"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sqrt</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the square root of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.starts_with"
title="datafusion.functions.starts_with"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">starts_with</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.starts_with"
title="datafusion.functions.starts_with"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">starts_with</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Returns true if string starts with prefix.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.stddev" title="datafusion.functions.stddev"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">stddev</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.stddev" title="datafusion.functions.stddev"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">stddev</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the standard deviation of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.stddev_pop"
title="datafusion.functions.stddev_pop"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">stddev_pop</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.stddev_pop"
title="datafusion.functions.stddev_pop"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">stddev_pop</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the population standard deviation of the argument.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.stddev_samp"
title="datafusion.functions.stddev_samp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">stddev_samp</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.stddev_samp"
title="datafusion.functions.stddev_samp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">stddev_samp</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sample standard deviation of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.string_agg"
title="datafusion.functions.string_agg"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">string_agg</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.string_agg"
title="datafusion.functions.string_agg"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">string_agg</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Concatenates the input strings.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.strpos" title="datafusion.functions.strpos"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">strpos</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.strpos" title="datafusion.functions.strpos"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">strpos</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Finds the position from where the <code class="docutils literal
notranslate"><span class="pre">substring</span></code> matches 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.struct" title="datafusion.functions.struct"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">struct</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.struct" title="datafusion.functions.struct"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">struct</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns a struct with the given arguments.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.substr" title="datafusion.functions.substr"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">substr</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.substr" title="datafusion.functions.substr"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">substr</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Substring from the <code class="docutils literal notranslate"><span
class="pre">position</span></code> to the end.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.substr_index"
title="datafusion.functions.substr_index"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">substr_index</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.substr_index"
title="datafusion.functions.substr_index"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">substr_index</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Returns an indexed substring.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.substring"
title="datafusion.functions.substring"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">substring</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.substring"
title="datafusion.functions.substring"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">substring</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Substring from the <code class="docutils literal notranslate"><span
class="pre">position</span></code> with <code class="docutils literal
notranslate"><span class="pre">length</span></code> characters.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.sum" title="datafusion.functions.sum"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sum</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.sum" title="datafusion.functions.sum"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">sum</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the sum of a set of numbers.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.tan" title="datafusion.functions.tan"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">tan</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.tan" title="datafusion.functions.tan"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">tan</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the tangent of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.tanh" title="datafusion.functions.tanh"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">tanh</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.tanh" title="datafusion.functions.tanh"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">tanh</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns the hyperbolic tangent of the argument.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_hex" title="datafusion.functions.to_hex"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">to_hex</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_hex" title="datafusion.functions.to_hex"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">to_hex</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Converts an integer to a hexadecimal string.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp"
title="datafusion.functions.to_timestamp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">to_timestamp</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp"
title="datafusion.functions.to_timestamp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">to_timestamp</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Converts a string and optional formats to a <code class="docutils
literal notranslate"><span class="pre">Timestamp</span></code> in
nanoseconds.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_micros"
title="datafusion.functions.to_timestamp_micros"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_micros</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_micros"
title="datafusion.functions.to_timestamp_micros"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_micros</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Converts a string and optional formats to a <code class="docutils
literal notranslate"><span class="pre">Timestamp</span></code> in
microseconds.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_millis"
title="datafusion.functions.to_timestamp_millis"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_millis</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_millis"
title="datafusion.functions.to_timestamp_millis"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_millis</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Converts a string and optional formats to a <code class="docutils
literal notranslate"><span class="pre">Timestamp</span></code> in
milliseconds.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_seconds"
title="datafusion.functions.to_timestamp_seconds"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_seconds</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_seconds"
title="datafusion.functions.to_timestamp_seconds"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_seconds</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Converts a string and optional formats to a <code class="docutils
literal notranslate"><span class="pre">Timestamp</span></code> in
seconds.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_unixtime"
title="datafusion.functions.to_unixtime"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">to_unixtime</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.to_unixtime"
title="datafusion.functions.to_unixtime"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">to_unixtime</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Converts a string and optional formats to a Unixtime.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.translate"
title="datafusion.functions.translate"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">translate</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.translate"
title="datafusion.functions.translate"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">translate</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Replaces the characters in <code class="docutils literal
notranslate"><span class="pre">from_val</span></code> with the counterpart in
<code class="docutils literal notranslate"><span
class="pre">to_val</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.trim" title="datafusion.functions.trim"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">trim</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.trim" title="datafusion.functions.trim"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">trim</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Removes all characters, spaces by default, from both sides of a
string.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.trunc" title="datafusion.functions.trunc"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">trunc</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.trunc" title="datafusion.functions.trunc"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">trunc</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Truncate the number toward zero with optional precision.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.upper" title="datafusion.functions.upper"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">upper</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.upper" title="datafusion.functions.upper"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">upper</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Converts a string to uppercase.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.uuid" title="datafusion.functions.uuid"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">uuid</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.uuid" title="datafusion.functions.uuid"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">uuid</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Returns uuid v4 as a string value.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.var" title="datafusion.functions.var"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">var</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.var" title="datafusion.functions.var"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">var</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the sample variance of the argument.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.var_pop" title="datafusion.functions.var_pop"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">var_pop</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.var_pop" title="datafusion.functions.var_pop"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">var_pop</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Computes the population variance of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.var_samp"
title="datafusion.functions.var_samp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">var_samp</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.var_samp"
title="datafusion.functions.var_samp"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">var_samp</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sample variance of the argument.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.var_sample"
title="datafusion.functions.var_sample"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">var_sample</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.var_sample"
title="datafusion.functions.var_sample"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">var_sample</span></code></a>(→
datafusion.expr.Expr)</p></td>
<td><p>Computes the sample variance of the argument.</p></td>
</tr>
-<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.when" title="datafusion.functions.when"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">when</span></code></a>(→ datafusion.expr.CaseBuilder)</p></td>
+<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.when" title="datafusion.functions.when"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">when</span></code></a>(→ datafusion.expr.CaseBuilder)</p></td>
<td><p>Create a case expression that has no base expression.</p></td>
</tr>
-<tr class="row-odd"><td><p><a class="reference internal"
href="#datafusion.functions.window" title="datafusion.functions.window"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">window</span></code></a>(→ datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.window" title="datafusion.functions.window"><code
class="xref py py-obj docutils literal notranslate"><span
class="pre">window</span></code></a>(→ datafusion.expr.Expr)</p></td>
<td><p>Creates a new Window function expression.</p></td>
</tr>
</tbody>
@@ -4583,6 +4595,12 @@ and the associated n-tile function:</p>
<p>This can be used to perform the inverse operation of the COALESCE
expression.</p>
</dd></dl>
+<dl class="py function">
+<dt class="sig sig-object py" id="datafusion.functions.nvl">
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">nvl</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">x</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">datafusion.expr. [...]
+<dd><p>Returns <code class="docutils literal notranslate"><span
class="pre">x</span></code> if <code class="docutils literal notranslate"><span
class="pre">x</span></code> is not <code class="docutils literal
notranslate"><span class="pre">NULL</span></code>. Otherwise returns <code
class="docutils literal notranslate"><span class="pre">y</span></code>.</p>
+</dd></dl>
+
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.octet_length">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">octet_length</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">arg</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="../expr/index.html#datafusion.expr.Expr"
title="datafusion.expr.Expr"><span class="pre">dataf [...]
diff --git a/autoapi/datafusion/index.html b/autoapi/datafusion/index.html
index da8756c..408a64b 100644
--- a/autoapi/datafusion/index.html
+++ b/autoapi/datafusion/index.html
@@ -858,6 +858,24 @@
</code>
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#datafusion.Expr.fill_nan">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ Expr.fill_nan()
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#datafusion.Expr.fill_null">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ Expr.fill_null()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link" href="#datafusion.Expr.filter">
<code class="docutils literal notranslate">
@@ -2263,6 +2281,18 @@ set parameters for either window or aggregate functions.
If used on any other
type of expression, an error will be generated when <code class="docutils
literal notranslate"><span class="pre">build()</span></code> is called.</p>
</dd></dl>
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.Expr.fill_nan">
+<span class="sig-name descname"><span class="pre">fill_nan</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">Any</span><span class="w"> </span><span class="p"><span
class="pre">|</span></span><span class="w"> </span><a class="reference
internal" href="#datafusion.Expr" title="datafusion.Expr"><span class="pre">Exp
[...]
+<dd><p>Fill NaN values with a provided value.</p>
+</dd></dl>
+
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.Expr.fill_null">
+<span class="sig-name descname"><span class="pre">fill_null</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">Any</span><span class="w"> </span><span class="p"><span
class="pre">|</span></span><span class="w"> </span><a class="reference
internal" href="#datafusion.Expr" title="datafusion.Expr"><span class="pre">Ex
[...]
+<dd><p>Fill NULL values with a provided value.</p>
+</dd></dl>
+
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.Expr.filter">
<span class="sig-name descname"><span class="pre">filter</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">filter</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="#datafusion.Expr"
title="datafusion.Expr"><span class="pre">Expr</span></a></span></em><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span [...]
diff --git a/genindex.html b/genindex.html
index d8aedb4..526ae58 100644
--- a/genindex.html
+++ b/genindex.html
@@ -1253,6 +1253,18 @@
<td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.factorial">factorial()
(in module datafusion.functions)</a>
</li>
+ <li><a
href="autoapi/datafusion/index.html#datafusion.Expr.fill_nan">fill_nan()
(datafusion.Expr method)</a>
+
+ <ul>
+ <li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.Expr.fill_nan">(datafusion.expr.Expr
method)</a>
+</li>
+ </ul></li>
+ <li><a
href="autoapi/datafusion/index.html#datafusion.Expr.fill_null">fill_null()
(datafusion.Expr method)</a>
+
+ <ul>
+ <li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.Expr.fill_null">(datafusion.expr.Expr
method)</a>
+</li>
+ </ul></li>
<li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.Filter">Filter (in
module datafusion.expr)</a>
</li>
<li><a
href="autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.filter">filter()
(datafusion.dataframe.DataFrame method)</a>
@@ -1271,12 +1283,12 @@
</li>
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.floor">floor()
(in module datafusion.functions)</a>
</li>
+ </ul></td>
+ <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.WindowFrameBound.frame_bound">frame_bound
(datafusion.expr.WindowFrameBound attribute)</a>
</li>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.from_arrow">from_arrow()
(datafusion.context.SessionContext method)</a>
</li>
- </ul></td>
- <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.from_arrow_table">from_arrow_table()
(datafusion.context.SessionContext method)</a>
</li>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.from_pandas">from_pandas()
(datafusion.context.SessionContext method)</a>
@@ -1683,6 +1695,8 @@
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.nullif">nullif()
(in module datafusion.functions)</a>
</li>
<li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.SortExpr.nulls_first">nulls_first()
(datafusion.expr.SortExpr method)</a>
+</li>
+ <li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.nvl">nvl()
(in module datafusion.functions)</a>
</li>
</ul></td>
</tr></table>
diff --git a/objects.inv b/objects.inv
index ac41a85..4919a1a 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index 791c535..d4e7ddc 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[14, null]], "Aggregate
Functions": [[18, "aggregate-functions"], [25, "aggregate-functions"], [26,
"aggregate-functions"]], "Aggregation": [[18, null]], "Arrays": [[20,
"arrays"]], "Arrow": [[29, null]], "Attributes": [[3, "attributes"], [5,
"attributes"], [9, "attributes"], [13, "attributes"]], "Available Functions":
[[26, "available-functions"]], "Avro": [[30, null]], "Basic Operations": [[19,
null]], "Boolean": [[20, "boolean"]], "CSV" [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[14, null]], "Aggregate
Functions": [[18, "aggregate-functions"], [25, "aggregate-functions"], [26,
"aggregate-functions"]], "Aggregation": [[18, null]], "Arrays": [[20,
"arrays"]], "Arrow": [[29, null]], "Attributes": [[3, "attributes"], [5,
"attributes"], [9, "attributes"], [13, "attributes"]], "Available Functions":
[[26, "available-functions"]], "Avro": [[30, null]], "Basic Operations": [[19,
null]], "Boolean": [[20, "boolean"]], "CSV" [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 23a85cd..2eff372 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -421,7 +421,7 @@ to form a single summary value. For performing an
aggregation, DataFusion provid
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f7c7b48a490</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f4382979e10</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">6</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
@@ -467,20 +467,20 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">13</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">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">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>
-<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mi">120</span> <span class="o">|</span>
<span class="mf">58.125</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fighting</span> <span
class="o">|</span> <span class="mi">95</span> <span class="o">|</span>
<span class="mf">66.14285714285714</span> <span class="o">|</span> <span
class="mi">35</span> <span class="o">|</span>
-<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">Bug</span> <span
class="o">|</span> <span class="mi">145</span> <span class="o">|</span>
<span class="mf">66.78571428571429</span> <span class="o">|</span> <span
class="mi">25</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">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">Bug</span> <span
class="o">|</span> <span class="mi">145</span> <span class="o">|</span>
<span class="mf">66.78571428571429</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="mi">90</span> <span class="o">|</span>
<span class="mf">58.785714285714285</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="mi">140</span> <span class="o">|</span>
<span class="mf">98.88888888888889</span> <span class="o">|</span> <span
class="mi">45</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="mi">60</span> <span class="o">|</span>
<span class="mf">47.5</span> <span class="o">|</span> <span
class="mi">35</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>
+<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mi">120</span> <span class="o">|</span>
<span class="mf">58.125</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
+<span
class="o">+----------+-----------+--------------------+-----------+</span>
</pre></div>
</div>
<p>More than one column can be used for grouping</p>
@@ -491,20 +491,20 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">14</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">Type</span> <span class="mi">2</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">Fire</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span>
<span class="mi">100</span> <span class="o">|</span> <span
class="mf">96.66666666666667</span> <span class="o">|</span> <span
class="mi">90</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="n">Dragon</span> <span class="o">|</span>
<span class="mi">100</span> <span class="o">|</span> <span
class="mf">100.0</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="n">Poison</span> <span class="o">|</span>
<span class="mi">145</span> <span class="o">|</span> <span
class="mf">73.33333333333333</span> <span class="o">|</span> <span
class="mi">35</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="o">|</span> <span
class="mi">115</span> <span class="o">|</span> <span
class="mf">71.3076923076923</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="n">Fighting</span> <span class="o">|</span>
<span class="mi">70</span> <span class="o">|</span> <span
class="mf">70.0</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="n">Ground</span> <span class="o">|</span>
<span class="mi">70</span> <span class="o">|</span> <span
class="mf">42.5</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="n">Psychic</span> <span class="o">|</span>
<span class="mi">115</span> <span class="o">|</span> <span
class="mf">47.5</span> <span class="o">|</span> <span
class="mi">15</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="n">Psychic</span> <span class="o">|</span>
<span class="mi">55</span> <span class="o">|</span> <span
class="mf">47.5</span> <span class="o">|</span> <span
class="mi">40</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="n">Rock</span> <span class="o">|</span>
<span class="mi">40</span> <span class="o">|</span> <span
class="mf">32.5</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span>
<span class="mi">81</span> <span class="o">|</span> <span
class="mf">81.0</span> <span class="o">|</span> <span
class="mi">81</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">Type</span> <span
class="mi">2</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">Grass</span> <span
class="o">|</span> <span class="n">Poison</span> <span class="o">|</span> <span
class="mi">80</span> <span class="o">|</span> <span
class="mf">55.0</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span
class="mi">105</span> <span class="o">|</span> <span
class="mf">93.33333333333333</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="n">Ground</span> <span class="o">|</span> <span
class="mi">85</span> <span class="o">|</span> <span
class="mf">80.5</span> <span class="o">|</span> <span
class="mi">76</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span
class="mi">90</span> <span class="o">|</span> <span
class="mf">72.5</span> <span class="o">|</span> <span
class="mi">55</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="n">Grass</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span> <span
class="mf">27.5</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="n">Poison</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span> <span
class="mf">85.0</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="n">Steel</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span> <span
class="mf">57.5</span> <span class="o">|</span> <span
class="mi">45</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="n">Poison</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">Psychic</span> <span
class="o">|</span> <span class="n">Fairy</span> <span class="o">|</span> <span
class="mi">90</span> <span class="o">|</span> <span
class="mf">90.0</span> <span class="o">|</span> <span
class="mi">90</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span> <span
class="mf">100.0</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span>
+<span
class="o">+----------+--------+-----------+-------------------+-----------+</span>
</pre></div>
</div>
<section id="setting-parameters">
@@ -562,15 +562,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="n">Fairy</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Flying</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">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="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Steel</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Grass</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">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">Grass</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Flying</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dark</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span class="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">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">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">Poison</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">,</span> <span class="p">]</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
</pre></div>
@@ -587,13 +587,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">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">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">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">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">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">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">Ice</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">Flying</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">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ice</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">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>
@@ -604,14 +604,14 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<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">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">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">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">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">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">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">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">Flying</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">,</span> <span
class="n">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="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">Psychic</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span class="n">Ice</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">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>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index 50f0d64..9e988be 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -389,11 +389,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">926</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">53</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">279</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">733</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">334</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">244</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">613</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">87</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">898</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">722</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -404,8 +404,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">926</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">53</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">244</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">613</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -423,11 +423,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">926</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">53</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">279</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">733</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">334</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">244</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">613</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">87</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">898</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">722</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>
@@ -439,11 +439,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">465.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">355.61425730698704</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">53.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">926.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">334.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">512.8</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">std</span> <span
class="o">|</span> <span class="mf">1.5811388300841898</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">337.54362680992807</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">87.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">898.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">613.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 0af889e..80895bc 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -410,7 +410,7 @@ In here we will cover some of the more popular use cases.
If you want to view al
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f7c7b170650</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f43773c0910</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
@@ -484,16 +484,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">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">24.433658760</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">16</span><span class="n">T12</span><span class="p">:</span><span
class="mi">44</span><span class="p">:</span><span
class="mf">36.261948765</span><span class="n">Z</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/select-and-filter.html
b/user-guide/common-operations/select-and-filter.html
index d8f11ec..fe4e354 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -378,7 +378,7 @@
<span class="n">In</span> <span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="n">urllib</span><span
class="o">.</span><span class="n">request</span><span class="o">.</span><span
class="n">urlretrieve</span><span class="p">(</span><span
class="s2">"https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet"</span><span
class="p">,</span>
<span class="o">...</span><span class="p">:</span>
<span class="s2">"yellow_trip_data.parquet"</span><span
class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span>
<span class="o"><</span><span class="n">http</span><span
class="o">.</span><span class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f7c7b195790</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span>
<span class="o"><</span><span class="n">http</span><span
class="o">.</span><span class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f43773bf550</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
diff --git a/user-guide/common-operations/windows.html
b/user-guide/common-operations/windows.html
index c62c866..9be5ca6 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -428,7 +428,7 @@ provides a single value for multiple rows.</p>
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f7c7ad9bd50</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f4376fc4f90</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">6</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
