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 ae2608b3 Publish built docs triggered by
7c1c08f8617ac97a2568eb0664e9d4ee30fceba9
ae2608b3 is described below
commit ae2608b33da153ed2fb2d7a30367083ad144b63c
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat Mar 15 11:39:47 2025 +0000
Publish built docs triggered by 7c1c08f8617ac97a2568eb0664e9d4ee30fceba9
---
.../autoapi/datafusion/functions/index.rst.txt | 9 ++
autoapi/datafusion/functions/index.html | 140 ++++++++++++---------
genindex.html | 6 +-
objects.inv | Bin 6195 -> 6199 bytes
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 72 +++++------
user-guide/common-operations/basic-info.html | 46 +++----
user-guide/common-operations/functions.html | 20 +--
8 files changed, 163 insertions(+), 132 deletions(-)
diff --git a/_sources/autoapi/datafusion/functions/index.rst.txt
b/_sources/autoapi/datafusion/functions/index.rst.txt
index beadff19..a3219e79 100644
--- a/_sources/autoapi/datafusion/functions/index.rst.txt
+++ b/_sources/autoapi/datafusion/functions/index.rst.txt
@@ -194,6 +194,7 @@ Functions
datafusion.functions.random
datafusion.functions.range
datafusion.functions.rank
+ datafusion.functions.regexp_count
datafusion.functions.regexp_like
datafusion.functions.regexp_match
datafusion.functions.regexp_replace
@@ -1656,6 +1657,14 @@ Module Contents
:param order_by: Set ordering within the window frame.
+.. py:function:: regexp_count(string: datafusion.expr.Expr, pattern:
datafusion.expr.Expr, start: datafusion.expr.Expr, flags: datafusion.expr.Expr
| None = None) -> datafusion.expr.Expr
+
+ Returns the number of matches in a string.
+
+ Optional start position (the first position is 1) to search for the regular
+ expression.
+
+
.. py:function:: regexp_like(string: datafusion.expr.Expr, regex:
datafusion.expr.Expr, flags: datafusion.expr.Expr | None = None) ->
datafusion.expr.Expr
Find if any regular expression (regex) matches exist.
diff --git a/autoapi/datafusion/functions/index.html
b/autoapi/datafusion/functions/index.html
index 00a76a61..a3f490d2 100644
--- a/autoapi/datafusion/functions/index.html
+++ b/autoapi/datafusion/functions/index.html
@@ -2005,6 +2005,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#datafusion.functions.regexp_count">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regexp_count()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link"
href="#datafusion.functions.regexp_like">
<code class="docutils literal notranslate">
@@ -3115,184 +3124,187 @@
<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>
<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-odd"><td><p><a class="reference internal"
href="#datafusion.functions.regexp_count"
title="datafusion.functions.regexp_count"><code class="xref py py-obj docutils
literal notranslate"><span class="pre">regexp_count</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<td><p>Returns the number of matches in a string.</p></td>
+</tr>
+<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_nanos"
title="datafusion.functions.to_timestamp_nanos"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_nanos</span></code></a>(→
datafusion.expr.Expr)</p></td>
+<tr class="row-even"><td><p><a class="reference internal"
href="#datafusion.functions.to_timestamp_nanos"
title="datafusion.functions.to_timestamp_nanos"><code class="xref py py-obj
docutils literal notranslate"><span
class="pre">to_timestamp_nanos</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-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>
+<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>
<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-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>
+<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>
<td><p>Converts a string and optional formats to a Unixtime.</p></td>
</tr>
-<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>
+<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>
<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-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>
+<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>
<td><p>Removes all characters, spaces by default, from both sides of a
string.</p></td>
</tr>
-<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>
+<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>
<td><p>Truncate the number toward zero with optional precision.</p></td>
</tr>
-<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>
+<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>
<td><p>Converts a string to uppercase.</p></td>
</tr>
-<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>
+<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>
<td><p>Returns uuid v4 as a string value.</p></td>
</tr>
-<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>
+<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>
<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.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-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>
<td><p>Computes the population variance of the argument.</p></td>
</tr>
-<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>
+<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>
<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.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-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>
<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.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-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>
<td><p>Create a case expression that has no base expression.</p></td>
</tr>
-<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>
+<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>
<td><p>Creates a new Window function expression.</p></td>
</tr>
</tbody>
@@ -4921,6 +4933,14 @@ associated rank.</p>
</dl>
</dd></dl>
+<dl class="py function">
+<dt class="sig sig-object py" id="datafusion.functions.regexp_count">
+<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">regexp_count</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">string</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">da [...]
+<dd><p>Returns the number of matches in a string.</p>
+<p>Optional start position (the first position is 1) to search for the regular
+expression.</p>
+</dd></dl>
+
<dl class="py function">
<dt class="sig sig-object py" id="datafusion.functions.regexp_like">
<span class="sig-prename descclassname"><span
class="pre">datafusion.functions.</span></span><span class="sig-name
descname"><span class="pre">regexp_like</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">string</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">dat [...]
diff --git a/genindex.html b/genindex.html
index 857ec9f8..6d65db2f 100644
--- a/genindex.html
+++ b/genindex.html
@@ -1973,6 +1973,8 @@
<li><a
href="autoapi/datafusion/record_batch/index.html#datafusion.record_batch.RecordBatchStream">(class
in datafusion.record_batch)</a>
</li>
</ul></li>
+ <li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.regexp_count">regexp_count()
(in module datafusion.functions)</a>
+</li>
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.regexp_like">regexp_like()
(in module datafusion.functions)</a>
</li>
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.regexp_match">regexp_match()
(in module datafusion.functions)</a>
@@ -1990,11 +1992,11 @@
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.register_listing_table">register_listing_table()
(datafusion.context.SessionContext method)</a>
</li>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.register_object_store">register_object_store()
(datafusion.context.SessionContext method)</a>
-</li>
- <li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.register_parquet">register_parquet()
(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.register_parquet">register_parquet()
(datafusion.context.SessionContext method)</a>
+</li>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.register_record_batches">register_record_batches()
(datafusion.context.SessionContext method)</a>
</li>
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.register_table">register_table()
(datafusion.context.SessionContext method)</a>
diff --git a/objects.inv b/objects.inv
index 440b43d4..b9458408 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index b711b312..a782adfd 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[15, null]], "Aggregate
Functions": [[20, "aggregate-functions"], [27, "aggregate-functions"], [29,
"aggregate-functions"]], "Aggregation": [[20, null]], "Alternative Approach":
[[16, "alternative-approach"]], "Arrays": [[22, "arrays"]], "Arrow": [[33,
null]], "Attributes": [[3, "attributes"], [5, "attributes"], [10,
"attributes"], [14, "attributes"]], "Available Functions": [[29,
"available-functions"]], "Avro": [[34, null]], "Basic Opera [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[15, null]], "Aggregate
Functions": [[20, "aggregate-functions"], [27, "aggregate-functions"], [29,
"aggregate-functions"]], "Aggregation": [[20, null]], "Alternative Approach":
[[16, "alternative-approach"]], "Arrays": [[22, "arrays"]], "Arrow": [[33,
null]], "Attributes": [[3, "attributes"], [5, "attributes"], [10,
"attributes"], [14, "attributes"]], "Available Functions": [[29,
"available-functions"]], "Avro": [[34, null]], "Basic Opera [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 5af7465b..8bd01f00 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -479,20 +479,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">9</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span
class="o">+----------+-----------+--------------------+-----------+</span>
-<span class="o">|</span> <span class="n">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">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> <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="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">Normal</span> <span
class="o">|</span> <span class="mi">121</span> <span class="o">|</span>
<span class="mf">72.75</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
+<span class="o">+----------+-----------+-------------------+-----------+</span>
</pre></div>
</div>
<p>More than one column can be used for grouping</p>
@@ -574,15 +574,15 @@ Pokemon set. Since there will be many entries of <code
class="docutils literal n
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</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">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Fairy</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">,</span> <span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Poison</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Grass</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Steel</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">Poison</span><span class="p">,</span> <span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Dark</span><span
class="p">,</span> <span class="n">Fighting</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Poison</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Dragon</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span class="p">,</span>
<span class="n">Ice</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">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>
@@ -597,14 +597,14 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Fairy</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">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">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">Psychic</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">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">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span
class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Poison</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Water</span><span class="p">,</span> <span
class="n">Ground</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
@@ -615,15 +615,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Fairy</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">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">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Dragon</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Fighting</span><span class="p">,</span>
<span class="n">Psychic</span><span class="p">,</span> <span
class="n">Ice</span><span class="p">,</span> <span class="n">Dark</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Ice</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">,</span> <span
class="n">Fighting</span><span class="p">,</span> <span
class="n">Flying</span><span class="p">,</span> <span
class="n">Dark</span><span class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">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>
@@ -704,6 +704,8 @@ aggregate function without filtering rows from the entire
DataFrame.</p>
<span class="o">+----------+-------------------+----------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Avg</span> <span
class="n">Speed</span> <span class="n">All</span> <span class="o">|</span>
<span class="n">Avg</span> <span class="n">Speed</span> <span
class="n">Low</span> <span class="n">Attack</span> <span class="o">|</span>
<span class="o">+----------+-------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">72.75</span> <span
class="o">|</span> <span class="mf">52.8</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mf">90.0</span> <span
class="o">|</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mf">54.23076923076923</span> <span
class="o">|</span> <span class="mf">42.5</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mf">86.28571428571429</span> <span
class="o">|</span> <span class="mf">65.0</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mf">67.25806451612904</span> <span
class="o">|</span> <span class="mf">63.833333333333336</span> <span
class="o">|</span>
@@ -712,8 +714,6 @@ aggregate function without filtering rows from the entire
DataFrame.</p>
<span class="o">|</span> <span class="n">Psychic</span> <span
class="o">|</span> <span class="mf">99.25</span> <span
class="o">|</span> <span class="mf">81.75</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="mf">67.5</span> <span
class="o">|</span> <span class="mf">52.5</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ghost</span> <span
class="o">|</span> <span class="mf">103.75</span> <span
class="o">|</span> <span class="mf">80.0</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Dragon</span> <span
class="o">|</span> <span class="mf">66.66666666666667</span> <span
class="o">|</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">72.75</span> <span
class="o">|</span> <span class="mf">52.8</span> <span
class="o">|</span>
<span class="o">+----------+-------------------+----------------------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index 29bfc238..f9dd7832 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -414,11 +414,11 @@
<span class="o">+-----+---------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">580</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">748</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">329</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">652</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">56</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">209</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">658</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
<span class="n">java</span> <span class="o">|</span> <span
class="mi">243</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">4</span> <span class="o">|</span>
<span class="n">haskell</span> <span class="o">|</span> <span
class="mi">767</span> <span class="o">|</span> <span class="n">C</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="n">go</span> <span class="o">|</span> <span
class="mi">208</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -429,8 +429,8 @@
<span class="o">+-----+--------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">580</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">748</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">209</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">2</span> <span class="o">|</span>
<span class="n">ruby</span> <span class="o">|</span> <span
class="mi">658</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -448,28 +448,28 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">to_pandas</span><span class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">8</span><span class="p">]:</span>
<span class="n">nrs</span> <span class="n">names</span> <span
class="n">random</span> <span class="n">groups</span>
-<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">580</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">748</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">329</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">652</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">56</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">209</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">658</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">243</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">767</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">208</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.describe"
title="datafusion.dataframe.DataFrame.describe"><code class="xref py py-func
docutils literal notranslate"><span class="pre">describe()</span></code></a>
shows a quick statistic summary of your data:</p>
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">9</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span class="n">describe</span><span
class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">9</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
-<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
-<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">473.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">280.06249302611013</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">56.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">748.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">580.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span
class="o">+------------+--------------------+-------+--------------------+--------+</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
+<span class="o">|</span> <span class="n">describe</span> <span
class="o">|</span> <span class="n">nrs</span> <span
class="o">|</span> <span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span
class="n">groups</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
+<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">417.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">std</span> <span
class="o">|</span> <span class="mf">1.5811388300841898</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">272.8561892279521</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">min</span> <span
class="o">|</span> <span class="mf">1.0</span> <span
class="o">|</span> <span class="n">go</span> <span class="o">|</span> <span
class="mf">208.0</span> <span class="o">|</span> <span
class="n">A</span> <span class="o">|</span>
+<span class="o">|</span> <span class="nb">max</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="n">ruby</span> <span class="o">|</span> <span
class="mf">767.0</span> <span class="o">|</span> <span
class="n">C</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">median</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">243.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/functions.html
b/user-guide/common-operations/functions.html
index 9ca2a91a..a1cdddfd 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -505,16 +505,16 @@ In here we will cover some of the more popular use cases.
If you want to view al
<span class="o">+--------------------------------+</span>
<span class="o">|</span> <span class="n">now</span><span class="p">()</span>
<span class="o">|</span>
<span class="o">+--------------------------------+</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">05</span><span class="p">:</span><span
class="mf">27.143068756</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2025</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">15</span><span class="n">T11</span><span class="p">:</span><span
class="mi">39</span><span class="p">:</span><span
class="mf">39.114237567</span><span class="n">Z</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
</pre></div>
</div>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
