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 f459cc5  Publish built docs triggered by 
02d4453af1c18d7e31c21d60574456226b71793e
f459cc5 is described below

commit f459cc5dbf43b182cedcd43dff46610539fb7927
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Sep 11 17:32:21 2024 +0000

    Publish built docs triggered by 02d4453af1c18d7e31c21d60574456226b71793e
---
 _sources/autoapi/datafusion/expr/index.rst.txt     |  10 +++
 _sources/autoapi/datafusion/index.rst.txt          |  10 +++
 autoapi/datafusion/expr/index.html                 |  24 ++++++
 autoapi/datafusion/index.html                      |  24 ++++++
 genindex.html                                      |  10 ++-
 objects.inv                                        | Bin 4980 -> 4991 bytes
 searchindex.js                                     |   2 +-
 user-guide/common-operations/aggregations.html     |  96 ++++++++++-----------
 user-guide/common-operations/basic-info.html       |  46 +++++-----
 user-guide/common-operations/functions.html        |  22 ++---
 user-guide/common-operations/joins.html            |   2 +-
 .../common-operations/select-and-filter.html       |   2 +-
 user-guide/common-operations/windows.html          |   2 +-
 13 files changed, 162 insertions(+), 88 deletions(-)

diff --git a/_sources/autoapi/datafusion/expr/index.rst.txt 
b/_sources/autoapi/datafusion/expr/index.rst.txt
index 7338025..8719a88 100644
--- a/_sources/autoapi/datafusion/expr/index.rst.txt
+++ b/_sources/autoapi/datafusion/expr/index.rst.txt
@@ -276,6 +276,16 @@ Module Contents
 
 
 
+   .. py:method:: between(low: Any, high: Any, negated: bool = False) -> Expr
+
+      Returns ``True`` if this expression is between a given range.
+
+      :param low: lower bound of the range (inclusive).
+      :param high: higher bound of the range (inclusive).
+      :param negated: negates whether the expression is between a given range
+
+
+
    .. py:method:: canonical_name() -> str
 
       Returns a complete string representation of this expression.
diff --git a/_sources/autoapi/datafusion/index.rst.txt 
b/_sources/autoapi/datafusion/index.rst.txt
index be25151..b5cff1d 100644
--- a/_sources/autoapi/datafusion/index.rst.txt
+++ b/_sources/autoapi/datafusion/index.rst.txt
@@ -350,6 +350,16 @@ Package Contents
 
 
 
+   .. py:method:: between(low: Any, high: Any, negated: bool = False) -> Expr
+
+      Returns ``True`` if this expression is between a given range.
+
+      :param low: lower bound of the range (inclusive).
+      :param high: higher bound of the range (inclusive).
+      :param negated: negates whether the expression is between a given range
+
+
+
    .. py:method:: canonical_name() -> str
 
       Returns a complete string representation of this expression.
diff --git a/autoapi/datafusion/expr/index.html 
b/autoapi/datafusion/expr/index.html
index 82ce0a7..61d364c 100644
--- a/autoapi/datafusion/expr/index.html
+++ b/autoapi/datafusion/expr/index.html
@@ -578,6 +578,15 @@
        </code>
       </a>
      </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" 
href="#datafusion.expr.Expr.between">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         Expr.between()
+        </span>
+       </code>
+      </a>
+     </li>
      <li class="toc-h4 nav-item toc-entry">
       <a class="reference internal nav-link" 
href="#datafusion.expr.Expr.canonical_name">
        <code class="docutils literal notranslate">
@@ -1871,6 +1880,21 @@ element index begins at <code class="docutils literal 
notranslate"><span class="
 <dd><p>Assign a name to the expression.</p>
 </dd></dl>
 
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.expr.Expr.between">
+<span class="sig-name descname"><span class="pre">between</span></span><span 
class="sig-paren">(</span><em class="sig-param"><span class="n"><span 
class="pre">low</span></span><span class="p"><span 
class="pre">:</span></span><span class="w"> </span><span class="n"><span 
class="pre">Any</span></span></em>, <em class="sig-param"><span class="n"><span 
class="pre">high</span></span><span class="p"><span 
class="pre">:</span></span><span class="w"> </span><span class="n"><span 
class="pre">Any< [...]
+<dd><p>Returns <code class="docutils literal notranslate"><span 
class="pre">True</span></code> if this expression is between a given range.</p>
+<dl class="field-list simple">
+<dt class="field-odd">Parameters<span class="colon">:</span></dt>
+<dd class="field-odd"><ul class="simple">
+<li><p><strong>low</strong> – lower bound of the range (inclusive).</p></li>
+<li><p><strong>high</strong> – higher bound of the range (inclusive).</p></li>
+<li><p><strong>negated</strong> – negates whether the expression is between a 
given range</p></li>
+</ul>
+</dd>
+</dl>
+</dd></dl>
+
 <dl class="py method">
 <dt class="sig sig-object py" id="datafusion.expr.Expr.canonical_name">
 <span class="sig-name descname"><span 
class="pre">canonical_name</span></span><span class="sig-paren">(</span><span 
class="sig-paren">)</span> <span class="sig-return"><span 
class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><span 
class="pre">str</span></span></span><a class="headerlink" 
href="#datafusion.expr.Expr.canonical_name" title="Link to this 
definition">¶</a></dt>
diff --git a/autoapi/datafusion/index.html b/autoapi/datafusion/index.html
index 535444d..af229ff 100644
--- a/autoapi/datafusion/index.html
+++ b/autoapi/datafusion/index.html
@@ -707,6 +707,15 @@
        </code>
       </a>
      </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#datafusion.Expr.between">
+       <code class="docutils literal notranslate">
+        <span class="pre">
+         Expr.between()
+        </span>
+       </code>
+      </a>
+     </li>
      <li class="toc-h4 nav-item toc-entry">
       <a class="reference internal nav-link" 
href="#datafusion.Expr.canonical_name">
        <code class="docutils literal notranslate">
@@ -1882,6 +1891,21 @@ element index begins at <code class="docutils literal 
notranslate"><span class="
 <dd><p>Assign a name to the expression.</p>
 </dd></dl>
 
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.Expr.between">
+<span class="sig-name descname"><span class="pre">between</span></span><span 
class="sig-paren">(</span><em class="sig-param"><span class="n"><span 
class="pre">low</span></span><span class="p"><span 
class="pre">:</span></span><span class="w"> </span><span class="n"><span 
class="pre">Any</span></span></em>, <em class="sig-param"><span class="n"><span 
class="pre">high</span></span><span class="p"><span 
class="pre">:</span></span><span class="w"> </span><span class="n"><span 
class="pre">Any< [...]
+<dd><p>Returns <code class="docutils literal notranslate"><span 
class="pre">True</span></code> if this expression is between a given range.</p>
+<dl class="field-list simple">
+<dt class="field-odd">Parameters<span class="colon">:</span></dt>
+<dd class="field-odd"><ul class="simple">
+<li><p><strong>low</strong> – lower bound of the range (inclusive).</p></li>
+<li><p><strong>high</strong> – higher bound of the range (inclusive).</p></li>
+<li><p><strong>negated</strong> – negates whether the expression is between a 
given range</p></li>
+</ul>
+</dd>
+</dl>
+</dd></dl>
+
 <dl class="py method">
 <dt class="sig sig-object py" id="datafusion.Expr.canonical_name">
 <span class="sig-name descname"><span 
class="pre">canonical_name</span></span><span class="sig-paren">(</span><span 
class="sig-paren">)</span> <span class="sig-return"><span 
class="sig-return-icon">&#x2192;</span> <span class="sig-return-typehint"><span 
class="pre">str</span></span></span><a class="headerlink" 
href="#datafusion.Expr.canonical_name" title="Link to this 
definition">¶</a></dt>
diff --git a/genindex.html b/genindex.html
index f13aa90..e61b581 100644
--- a/genindex.html
+++ b/genindex.html
@@ -727,16 +727,22 @@
 </li>
       <li><a 
href="autoapi/datafusion/expr/index.html#datafusion.expr.Between">Between (in 
module datafusion.expr)</a>
 </li>
+      <li><a 
href="autoapi/datafusion/index.html#datafusion.Expr.between">between() 
(datafusion.Expr method)</a>
+
+      <ul>
+        <li><a 
href="autoapi/datafusion/expr/index.html#datafusion.expr.Expr.between">(datafusion.expr.Expr
 method)</a>
+</li>
+      </ul></li>
       <li><a 
href="autoapi/datafusion/expr/index.html#datafusion.expr.BinaryExpr">BinaryExpr 
(in module datafusion.expr)</a>
 </li>
       <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bit_and">bit_and()
 (in module datafusion.functions)</a>
 </li>
       <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bit_length">bit_length()
 (in module datafusion.functions)</a>
-</li>
-      <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bit_or">bit_or()
 (in module datafusion.functions)</a>
 </li>
   </ul></td>
   <td style="width: 33%; vertical-align: top;"><ul>
+      <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bit_or">bit_or()
 (in module datafusion.functions)</a>
+</li>
       <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bit_xor">bit_xor()
 (in module datafusion.functions)</a>
 </li>
       <li><a 
href="autoapi/datafusion/functions/index.html#datafusion.functions.bool_and">bool_and()
 (in module datafusion.functions)</a>
diff --git a/objects.inv b/objects.inv
index 587d402..832b97f 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index b3ed4aa..7ff823e 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[13, null]], "Aggregate 
Functions": [[17, "aggregate-functions"], [25, "aggregate-functions"]], 
"Aggregation": [[17, null]], "Arrays": [[19, "arrays"]], "Arrow": [[28, null]], 
"Attributes": [[3, "attributes"], [5, "attributes"], [9, "attributes"], [12, 
"attributes"]], "Available Functions": [[25, "available-functions"]], "Avro": 
[[29, null]], "Basic Operations": [[18, null]], "Boolean": [[19, "boolean"]], 
"CSV": [[30, null]], "Classes": [[ [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[13, null]], "Aggregate 
Functions": [[17, "aggregate-functions"], [25, "aggregate-functions"]], 
"Aggregation": [[17, null]], "Arrays": [[19, "arrays"]], "Arrow": [[28, null]], 
"Attributes": [[3, "attributes"], [5, "attributes"], [9, "attributes"], [12, 
"attributes"]], "Available Functions": [[25, "available-functions"]], "Avro": 
[[29, null]], "Basic Operations": [[18, null]], "Boolean": [[19, "boolean"]], 
"CSV": [[30, null]], "Classes": [[ [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html 
b/user-guide/common-operations/aggregations.html
index 8083b75..6039d53 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -416,7 +416,7 @@ to form a single summary value. For performing an 
aggregation, DataFusion provid
    <span class="o">...</span><span class="p">:</span>     <span 
class="s2">&quot;pokemon.csv&quot;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f7196426a10</span><span class="o">&gt;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f451e364390</span><span class="o">&gt;</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>
 
@@ -462,20 +462,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">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>
 </pre></div>
 </div>
 <p>More than one column can be used for grouping</p>
@@ -486,20 +486,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="o">|</span> <span class="mi">105</span>  
     <span class="o">|</span> <span class="mf">81.8</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="o">|</span> <span class="mi">90</span>   
     <span class="o">|</span> <span class="mf">68.05263157894737</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="o">|</span> <span class="mi">120</span>  
     <span class="o">|</span> <span class="mf">66.66666666666667</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="n">Fairy</span>  <span class="o">|</span> <span 
class="mi">45</span>        <span class="o">|</span> <span 
class="mf">32.5</span>               <span class="o">|</span> <span 
class="mi">20</span>        <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fighting</span> <span 
class="o">|</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="o">|</span> <span class="mi">150</span>  
     <span class="o">|</span> <span class="mf">100.57142857142857</span> <span 
class="o">|</span> <span class="mi">42</span>        <span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span>    <span 
class="o">|</span>        <span class="o">|</span> <span class="mi">60</span>   
     <span class="o">|</span> <span class="mf">60.0</span>               <span 
class="o">|</span> <span class="mi">60</span>        <span class="o">|</span>
-<span class="o">|</span> <span class="n">Dragon</span>   <span 
class="o">|</span>        <span class="o">|</span> <span class="mi">70</span>   
     <span class="o">|</span> <span class="mf">60.0</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="o">|</span> <span class="mi">85</span>   
     <span class="o">|</span> <span class="mf">53.333333333333336</span> <span 
class="o">|</span> <span class="mi">30</span>        <span class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span>   <span 
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span 
class="mi">121</span>       <span class="o">|</span> <span 
class="mf">83.77777777777777</span>  <span class="o">|</span> <span 
class="mi">56</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">Bug</span>      <span 
class="o">|</span>         <span class="o">|</span> <span class="mi">85</span>  
      <span class="o">|</span> <span class="mf">53.333333333333336</span> <span 
class="o">|</span> <span class="mi">30</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Normal</span>   <span 
class="o">|</span> <span class="n">Flying</span>  <span class="o">|</span> 
<span class="mi">121</span>       <span class="o">|</span> <span 
class="mf">83.77777777777777</span>  <span class="o">|</span> <span 
class="mi">56</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span>   <span 
class="o">|</span>         <span class="o">|</span> <span class="mi">80</span>  
      <span class="o">|</span> <span class="mf">51.7</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="o">|</span> <span class="mi">140</span> 
      <span class="o">|</span> <span class="mf">112.5</span>              <span 
class="o">|</span> <span class="mi">90</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fairy</span>    <span 
class="o">|</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">Water</span>    <span 
class="o">|</span> <span class="n">Ice</span>     <span class="o">|</span> 
<span class="mi">70</span>        <span class="o">|</span> <span 
class="mf">66.66666666666667</span>  <span class="o">|</span> <span 
class="mi">60</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span>      <span 
class="o">|</span> <span class="n">Psychic</span> <span class="o">|</span> 
<span class="mi">95</span>        <span class="o">|</span> <span 
class="mf">95.0</span>               <span class="o">|</span> <span 
class="mi">95</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span>      <span 
class="o">|</span> <span class="n">Flying</span>  <span class="o">|</span> 
<span class="mi">85</span>        <span class="o">|</span> <span 
class="mf">85.0</span>               <span class="o">|</span> <span 
class="mi">85</span>        <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span>     <span 
class="o">|</span>         <span class="o">|</span> <span class="mi">105</span> 
      <span class="o">|</span> <span class="mf">81.8</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="o">|</span> <span class="mi">90</span>  
      <span class="o">|</span> <span class="mf">68.05263157894737</span>  <span 
class="o">|</span> <span class="mi">40</span>        <span class="o">|</span>
+<span 
class="o">+----------+---------+-----------+--------------------+-----------+</span>
 </pre></div>
 </div>
 <section id="setting-parameters">
@@ -557,16 +557,16 @@ Pokemon set. Since there will be many entries of <code 
class="docutils literal n
 <span 
class="o">+----------+--------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span> 
  <span class="o">|</span> <span class="n">Type</span> <span 
class="mi">2</span> <span class="n">List</span>                                 
     <span class="o">|</span>
 <span 
class="o">+----------+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">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">Grass</span><span 
class="p">,</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">Bug</span>      <span 
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span 
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span 
class="p">,</span> <span class="n">Grass</span><span class="p">]</span>         
               <span class="o">|</span>
 <span class="o">|</span> <span class="n">Poison</span>   <span 
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span 
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>        
                       <span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span 
class="o">|</span> <span class="p">[,</span> <span class="n">Flying</span><span 
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>         
                       <span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span 
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span 
class="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="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">Dark</span><span 
class="p">,</span> <span class="n">Psychic</span><span class="p">,</span> <span 
class="n">Fighting</span><span class="p">,</span> <span 
class="n">Poison</span><span class="p">,</span> <span class="p">,</span> <span 
class="n">Ice</span><span class="p">,</span> <span class="n">Flying</span><span 
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ground</span>   <span 
class="o">|</span> <span class="p">[,</span> <span class="n">Rock</span><span 
class="p">]</span>                                         <span 
class="o">|</span>
+<span class="o">|</span> <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">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="n">Flying</span><span class="p">,</span> <span 
class="n">Psychic</span><span class="p">,</span> <span class="p">,</span> <span 
class="n">Fighting</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ground</span>   <span 
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span 
class="p">,</span> <span class="p">]</span>                                     
    <span class="o">|</span>
 <span 
class="o">+----------+--------------------------------------------------+</span>
 </pre></div>
 </div>
@@ -580,15 +580,15 @@ entries entirely removed. The second is we can use the 
<code class="docutils lit
 <span 
class="o">+----------+------------------------------------------------+</span>
 <span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span> 
  <span class="o">|</span> <span class="n">Type</span> <span 
class="mi">2</span> <span class="n">List</span>                                 
   <span class="o">|</span>
 <span 
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Bug</span>      <span 
class="o">|</span> <span class="p">[</span><span class="n">Grass</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span 
class="n">Poison</span><span class="p">]</span>                        <span 
class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span>   <span 
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>        
                       <span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span 
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>        
                        <span class="o">|</span>
 <span class="o">|</span> <span class="n">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">Ice</span>      <span 
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span 
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>       
                       <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span>      <span 
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span 
class="n">Grass</span><span class="p">]</span>                        <span 
class="o">|</span>
+<span class="o">|</span> <span class="n">Poison</span>   <span 
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span 
class="p">,</span> <span class="n">Ground</span><span class="p">]</span>        
                       <span class="o">|</span>
+<span class="o">|</span> <span class="n">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">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">Ice</span><span 
class="p">,</span> <span class="n">Psychic</span><span class="p">,</span> <span 
class="n">Poison</span><span class="p">,</span> <span 
class="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">Rock</span>     <span 
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span 
class="p">,</span> <span class="n">Ground</span><span class="p">,</span> <span 
class="n">Water</span><span class="p">]</span>                        <span 
class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span>     <span 
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>        
                       <span class="o">|</span>
+<span class="o">|</span> <span class="n">Water</span>    <span 
class="o">|</span> <span class="p">[</span><span class="n">Dark</span><span 
class="p">,</span> <span class="n">Ice</span><span class="p">,</span> <span 
class="n">Flying</span><span class="p">,</span> <span 
class="n">Psychic</span><span class="p">,</span> <span 
class="n">Poison</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">Rock</span>     <span 
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span 
class="p">,</span> <span class="n">Water</span><span class="p">,</span> <span 
class="n">Flying</span><span class="p">]</span>                        <span 
class="o">|</span>
 <span class="o">|</span> <span class="n">Ghost</span>    <span 
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span 
class="p">]</span>                                       <span 
class="o">|</span>
 <span 
class="o">+----------+------------------------------------------------+</span>
 
@@ -599,14 +599,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">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">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">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">Flying</span><span 
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>         
                       <span class="o">|</span>
 <span class="o">|</span> <span class="n">Fairy</span>    <span 
class="o">|</span>                                                <span 
class="o">|</span>
 <span class="o">|</span> <span class="n">Grass</span>    <span 
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span 
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>       
                       <span class="o">|</span>
-<span class="o">|</span> <span class="n">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">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="n">Fighting</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">Ice</span><span 
class="p">,</span> <span class="n">Flying</span><span class="p">,</span> <span 
class="n">Dark</span><span class="p">,</span> <span 
class="n">Fighting</span><span class="p">,</span> <span 
class="n">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">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 3a4264c..dadfe27 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -384,11 +384,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">995</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">570</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">621</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">223</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">476</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">363</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">223</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">531</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">384</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">377</span>    <span class="o">|</span> <span class="n">B</span>      
<span class="o">|</span>
 <span class="o">+-----+---------+--------+--------+</span>
 </pre></div>
 </div>
@@ -399,8 +399,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">995</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">570</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">363</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">223</span>    <span class="o">|</span> <span class="n">A</span>      
<span class="o">|</span>
 <span class="o">+-----+--------+--------+--------+</span>
 </pre></div>
 </div>
@@ -418,28 +418,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">995</span>      <span 
class="n">A</span>
-<span class="mi">1</span>    <span class="mi">2</span>     <span 
class="n">ruby</span>     <span class="mi">570</span>      <span 
class="n">A</span>
-<span class="mi">2</span>    <span class="mi">3</span>     <span 
class="n">java</span>     <span class="mi">621</span>      <span 
class="n">B</span>
-<span class="mi">3</span>    <span class="mi">4</span>  <span 
class="n">haskell</span>     <span class="mi">223</span>      <span 
class="n">C</span>
-<span class="mi">4</span>    <span class="mi">5</span>       <span 
class="n">go</span>     <span class="mi">476</span>      <span 
class="n">B</span>
+<span class="mi">0</span>    <span class="mi">1</span>   <span 
class="n">python</span>     <span class="mi">363</span>      <span 
class="n">A</span>
+<span class="mi">1</span>    <span class="mi">2</span>     <span 
class="n">ruby</span>     <span class="mi">223</span>      <span 
class="n">A</span>
+<span class="mi">2</span>    <span class="mi">3</span>     <span 
class="n">java</span>     <span class="mi">531</span>      <span 
class="n">B</span>
+<span class="mi">3</span>    <span class="mi">4</span>  <span 
class="n">haskell</span>     <span class="mi">384</span>      <span 
class="n">C</span>
+<span class="mi">4</span>    <span class="mi">5</span>       <span 
class="n">go</span>     <span class="mi">377</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">577.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">279.38593379051855</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">223.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">995.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">570.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">375.6</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">109.1640966618604</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">223.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">531.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">377.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 32d3ae3..1a48ff0 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -405,7 +405,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">&quot;pokemon.csv&quot;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f7194125b90</span><span class="o">&gt;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f451e073210</span><span class="o">&gt;</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>
 
@@ -479,16 +479,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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">09</span><span class="n">T22</span><span class="p">:</span><span 
class="mi">48</span><span class="p">:</span><span 
class="mf">15.758465002</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</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">09</span><span class="o">-</span><span 
class="mi">11</span><span class="n">T17</span><span class="p">:</span><span 
class="mi">32</span><span class="p">:</span><span 
class="mf">14.595782022</span><span class="n">Z</span> <span class="o">|</span>
 <span class="o">+--------------------------------+</span>
 </pre></div>
 </div>
diff --git a/user-guide/common-operations/joins.html 
b/user-guide/common-operations/joins.html
index 77ddd68..d4173e1 100644
--- a/user-guide/common-operations/joins.html
+++ b/user-guide/common-operations/joins.html
@@ -452,9 +452,9 @@ values for the corresponding columns.</p>
 <span class="o">+-------------+----------+----+-----------+</span>
 <span class="o">|</span> <span class="n">customer_id</span> <span 
class="o">|</span> <span class="n">customer</span> <span class="o">|</span> 
<span class="nb">id</span> <span class="o">|</span> <span class="n">name</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">Alice</span>    <span class="o">|</span> 
<span class="mi">1</span>  <span class="o">|</span> <span 
class="n">CityCabs</span>  <span class="o">|</span>
 <span class="o">|</span> <span class="mi">3</span>           <span 
class="o">|</span> <span class="n">Charlie</span>  <span class="o">|</span>    
<span class="o">|</span>           <span class="o">|</span>
 <span class="o">|</span> <span class="mi">2</span>           <span 
class="o">|</span> <span class="n">Bob</span>      <span class="o">|</span> 
<span class="mi">2</span>  <span class="o">|</span> <span 
class="n">MetroRide</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">1</span>           <span 
class="o">|</span> <span class="n">Alice</span>    <span class="o">|</span> 
<span class="mi">1</span>  <span class="o">|</span> <span 
class="n">CityCabs</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 79ba2d4..3b64366 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -373,7 +373,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">&quot;https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet&quot;</span><span
 class="p">,</span>
    <span class="o">...</span><span class="p">:</span>                          
  <span class="s2">&quot;yellow_trip_data.parquet&quot;</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">&#39;yellow_trip_data.parquet&#39;</span><span class="p">,</span> 
<span class="o">&lt;</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">0x7f719413fdd0</span><span class="o">&gt;</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">&#39;yellow_trip_data.parquet&#39;</span><span class="p">,</span> 
<span class="o">&lt;</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">0x7f451cf00510</span><span class="o">&gt;</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 aeb2eee..7b0117e 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -423,7 +423,7 @@ provides a single value for multiple rows.</p>
    <span class="o">...</span><span class="p">:</span>     <span 
class="s2">&quot;pokemon.csv&quot;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f7186f16150</span><span class="o">&gt;</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">&#39;pokemon.csv&#39;</span><span class="p">,</span> <span 
class="o">&lt;</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">0x7f451cf29650</span><span class="o">&gt;</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]

Reply via email to