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 266e155 Publish built docs triggered by
f59dd08bfbc0f01cc16b858465d03c3a01ba647c
266e155 is described below
commit 266e155d1ddb6bda539b6555f996c89e13e52886
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Oct 21 21:07:01 2024 +0000
Publish built docs triggered by f59dd08bfbc0f01cc16b858465d03c3a01ba647c
---
.../autoapi/datafusion/dataframe/index.rst.txt | 23 +++++++
autoapi/datafusion/dataframe/index.html | 48 +++++++++++++
genindex.html | 10 ++-
objects.inv | Bin 5583 -> 5594 bytes
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 76 ++++++++++-----------
user-guide/common-operations/basic-info.html | 34 ++++-----
user-guide/common-operations/functions.html | 22 +++---
.../common-operations/select-and-filter.html | 2 +-
user-guide/common-operations/windows.html | 30 ++++----
10 files changed, 162 insertions(+), 85 deletions(-)
diff --git a/_sources/autoapi/datafusion/dataframe/index.rst.txt
b/_sources/autoapi/datafusion/dataframe/index.rst.txt
index 565123c..c1fc799 100644
--- a/_sources/autoapi/datafusion/dataframe/index.rst.txt
+++ b/_sources/autoapi/datafusion/dataframe/index.rst.txt
@@ -231,6 +231,16 @@ Module Contents
+ .. py:method:: head(n: int = 5) -> DataFrame
+
+ Return a new :py:class:`DataFrame` with a limited number of rows.
+
+ :param n: Number of rows to take from the head of the DataFrame.
+
+ :returns: DataFrame after limiting.
+
+
+
.. py:method:: intersect(other: DataFrame) -> DataFrame
Calculate the intersection of two :py:class:`DataFrame`.
@@ -385,6 +395,19 @@ Module Contents
+ .. py:method:: tail(n: int = 5) -> DataFrame
+
+ Return a new :py:class:`DataFrame` with a limited number of rows.
+
+ Be aware this could be potentially expensive since the row size needs to
be
+ determined of the dataframe. This is done by collecting it.
+
+ :param n: Number of rows to take from the tail of the DataFrame.
+
+ :returns: DataFrame after limiting.
+
+
+
.. py:method:: to_arrow_table() -> pyarrow.Table
Execute the :py:class:`DataFrame` and convert it into an Arrow Table.
diff --git a/autoapi/datafusion/dataframe/index.html
b/autoapi/datafusion/dataframe/index.html
index 82c095c..4bd06a1 100644
--- a/autoapi/datafusion/dataframe/index.html
+++ b/autoapi/datafusion/dataframe/index.html
@@ -540,6 +540,15 @@
</code>
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#datafusion.dataframe.DataFrame.head">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ DataFrame.head()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link"
href="#datafusion.dataframe.DataFrame.intersect">
<code class="docutils literal notranslate">
@@ -657,6 +666,15 @@
</code>
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#datafusion.dataframe.DataFrame.tail">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ DataFrame.tail()
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link"
href="#datafusion.dataframe.DataFrame.to_arrow_table">
<code class="docutils literal notranslate">
@@ -1107,6 +1125,20 @@ logical operations in <a class="reference internal"
href="../functions/index.htm
</dl>
</dd></dl>
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.dataframe.DataFrame.head">
+<span class="sig-name descname"><span class="pre">head</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">n</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">int</span></span><span class="w"> </span><span class="o"><span
class="pre">=</span></span><span class="w"> </span><span
class="default_value"><span class="pre">5</span></span></em><span
class="sig-paren">)</span> < [...]
+<dd><p>Return a new <a class="reference internal"
href="#datafusion.dataframe.DataFrame"
title="datafusion.dataframe.DataFrame"><code class="xref py py-class docutils
literal notranslate"><span class="pre">DataFrame</span></code></a> with a
limited number of rows.</p>
+<dl class="field-list simple">
+<dt class="field-odd">Parameters<span class="colon">:</span></dt>
+<dd class="field-odd"><p><strong>n</strong> – Number of rows to take from the
head of the DataFrame.</p>
+</dd>
+<dt class="field-even">Returns<span class="colon">:</span></dt>
+<dd class="field-even"><p>DataFrame after limiting.</p>
+</dd>
+</dl>
+</dd></dl>
+
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.dataframe.DataFrame.intersect">
<span class="sig-name descname"><span class="pre">intersect</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">other</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><a
class="reference internal" href="#datafusion.dataframe.DataFrame"
title="datafusion.dataframe.DataFrame"><span
class="pre">DataFrame</span></a></span></em><span class="sig-paren">)</span>
<span class="sig-return"><span c [...]
@@ -1308,6 +1340,22 @@ calling its` <code class="docutils literal
notranslate"><span class="pre">sort</
</dl>
</dd></dl>
+<dl class="py method">
+<dt class="sig sig-object py" id="datafusion.dataframe.DataFrame.tail">
+<span class="sig-name descname"><span class="pre">tail</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">n</span></span><span class="p"><span
class="pre">:</span></span><span class="w"> </span><span class="n"><span
class="pre">int</span></span><span class="w"> </span><span class="o"><span
class="pre">=</span></span><span class="w"> </span><span
class="default_value"><span class="pre">5</span></span></em><span
class="sig-paren">)</span> < [...]
+<dd><p>Return a new <a class="reference internal"
href="#datafusion.dataframe.DataFrame"
title="datafusion.dataframe.DataFrame"><code class="xref py py-class docutils
literal notranslate"><span class="pre">DataFrame</span></code></a> with a
limited number of rows.</p>
+<p>Be aware this could be potentially expensive since the row size needs to be
+determined of the dataframe. This is done by collecting it.</p>
+<dl class="field-list simple">
+<dt class="field-odd">Parameters<span class="colon">:</span></dt>
+<dd class="field-odd"><p><strong>n</strong> – Number of rows to take from the
tail of the DataFrame.</p>
+</dd>
+<dt class="field-even">Returns<span class="colon">:</span></dt>
+<dd class="field-even"><p>DataFrame after limiting.</p>
+</dd>
+</dl>
+</dd></dl>
+
<dl class="py method">
<dt class="sig sig-object py"
id="datafusion.dataframe.DataFrame.to_arrow_table">
<span class="sig-name descname"><span
class="pre">to_arrow_table</span></span><span class="sig-paren">(</span><span
class="sig-paren">)</span> <span class="sig-return"><span
class="sig-return-icon">→</span> <span class="sig-return-typehint"><span
class="pre">pyarrow.Table</span></span></span><a class="headerlink"
href="#datafusion.dataframe.DataFrame.to_arrow_table" title="Link to this
definition">¶</a></dt>
diff --git a/genindex.html b/genindex.html
index 76cad9d..3975151 100644
--- a/genindex.html
+++ b/genindex.html
@@ -1356,6 +1356,10 @@
<h2 id="H">H</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
+ <td style="width: 33%; vertical-align: top;"><ul>
+ <li><a
href="autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.head">head()
(datafusion.dataframe.DataFrame method)</a>
+</li>
+ </ul></td>
<td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/object_store/index.html#datafusion.object_store.Http">Http
(in module datafusion.object_store)</a>
</li>
@@ -2099,6 +2103,8 @@
<li><a
href="autoapi/datafusion/context/index.html#datafusion.context.SessionContext.table_exist">table_exist()
(datafusion.context.SessionContext method)</a>
</li>
<li><a
href="autoapi/datafusion/expr/index.html#datafusion.expr.TableScan">TableScan
(in module datafusion.expr)</a>
+</li>
+ <li><a
href="autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.tail">tail()
(datafusion.dataframe.DataFrame method)</a>
</li>
<li><a
href="autoapi/datafusion/functions/index.html#datafusion.functions.tan">tan()
(in module datafusion.functions)</a>
</li>
@@ -2122,14 +2128,14 @@
<li><a
href="autoapi/datafusion/plan/index.html#datafusion.plan.LogicalPlan.to_proto">(datafusion.plan.LogicalPlan
method)</a>
</li>
</ul></li>
+ </ul></td>
+ <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/record_batch/index.html#datafusion.record_batch.RecordBatch.to_pyarrow">to_pyarrow()
(datafusion.record_batch.RecordBatch method)</a>
<ul>
<li><a
href="autoapi/datafusion/index.html#datafusion.RecordBatch.to_pyarrow">(datafusion.RecordBatch
method)</a>
</li>
</ul></li>
- </ul></td>
- <td style="width: 33%; vertical-align: top;"><ul>
<li><a
href="autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.to_pydict">to_pydict()
(datafusion.dataframe.DataFrame method)</a>
</li>
<li><a
href="autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.to_pylist">to_pylist()
(datafusion.dataframe.DataFrame method)</a>
diff --git a/objects.inv b/objects.inv
index a34e3f5..f3b808d 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index ec57f17..8fb5927 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[14, null]], "Aggregate
Functions": [[18, "aggregate-functions"], [25, "aggregate-functions"], [26,
"aggregate-functions"]], "Aggregation": [[18, null]], "Arrays": [[20,
"arrays"]], "Arrow": [[29, null]], "Attributes": [[3, "attributes"], [5,
"attributes"], [9, "attributes"], [13, "attributes"]], "Available Functions":
[[26, "available-functions"]], "Avro": [[30, null]], "Basic Operations": [[19,
null]], "Boolean": [[20, "boolean"]], "CSV" [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[14, null]], "Aggregate
Functions": [[18, "aggregate-functions"], [25, "aggregate-functions"], [26,
"aggregate-functions"]], "Aggregation": [[18, null]], "Arrays": [[20,
"arrays"]], "Arrow": [[29, null]], "Attributes": [[3, "attributes"], [5,
"attributes"], [9, "attributes"], [13, "attributes"]], "Available Functions":
[[26, "available-functions"]], "Avro": [[30, null]], "Basic Operations": [[19,
null]], "Boolean": [[20, "boolean"]], "CSV" [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 6f61f2e..25c7a13 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -421,7 +421,7 @@ to form a single summary value. For performing an
aggregation, DataFusion provid
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f62e7f4cb50</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f1b4a999710</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">6</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
@@ -467,20 +467,20 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">13</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span
class="o">+----------+-----------+--------------------+-----------+</span>
-<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Max</span> <span
class="n">Speed</span> <span class="o">|</span> <span class="n">Avg</span>
<span class="n">Speed</span> <span class="o">|</span> <span
class="n">Min</span> <span class="n">Speed</span> <span class="o">|</span>
-<span
class="o">+----------+-----------+--------------------+-----------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mi">121</span> <span class="o">|</span>
<span class="mf">72.75</span> <span class="o">|</span> <span
class="mi">20</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mi">95</span> <span class="o">|</span>
<span class="mf">90.0</span> <span class="o">|</span> <span
class="mi">85</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="mi">145</span> <span class="o">|</span>
<span class="mf">66.78571428571429</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="mi">90</span> <span class="o">|</span>
<span class="mf">58.785714285714285</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="mi">140</span> <span class="o">|</span>
<span class="mf">98.88888888888889</span> <span class="o">|</span> <span
class="mi">45</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="mi">60</span> <span class="o">|</span>
<span class="mf">47.5</span> <span class="o">|</span> <span
class="mi">35</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mf">54.23076923076923</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mi">105</span> <span class="o">|</span>
<span class="mf">86.28571428571429</span> <span class="o">|</span> <span
class="mi">60</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mi">115</span> <span class="o">|</span>
<span class="mf">67.25806451612904</span> <span class="o">|</span> <span
class="mi">15</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mi">120</span> <span class="o">|</span>
<span class="mf">58.125</span> <span class="o">|</span> <span
class="mi">25</span> <span class="o">|</span>
-<span
class="o">+----------+-----------+--------------------+-----------+</span>
+<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>
</pre></div>
</div>
<p>More than one column can be used for grouping</p>
@@ -502,8 +502,8 @@ For grouping the <code class="code docutils literal
notranslate"><span class="pr
<span class="o">|</span> <span class="n">Psychic</span> <span
class="o">|</span> <span class="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">Grass</span> <span
class="o">|</span> <span class="n">Poison</span> <span class="o">|</span> <span
class="mi">80</span> <span class="o">|</span> <span
class="mf">55.0</span> <span class="o">|</span> <span
class="mi">30</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span
class="mi">105</span> <span class="o">|</span> <span
class="mf">93.33333333333333</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="n">Flying</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span> <span
class="mf">96.66666666666667</span> <span class="o">|</span> <span
class="mi">90</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="n">Dragon</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span> <span
class="mf">100.0</span> <span class="o">|</span> <span
class="mi">100</span> <span class="o">|</span>
<span
class="o">+----------+--------+-----------+--------------------+-----------+</span>
</pre></div>
</div>
@@ -562,15 +562,15 @@ Pokemon set. Since there will be many entries of <code
class="docutils literal n
<span
class="o">+----------+--------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="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">Poison</span><span
class="p">,</span> <span class="n">Flying</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">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fairy</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Flying</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">,</span> <span
class="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="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="p">,</span> <span class="n">Flying</span><span
class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Poison</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Psychic</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="p">,</span> <span class="n">Flying</span><span
class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Dark</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">Flying</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">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">Poison</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="p">,</span> <span
class="n">Flying</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>
@@ -585,15 +585,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">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">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">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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">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">Ice</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Psychic</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Dragon</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Fighting</span><span
class="p">,</span> <span class="n">Dark</span><span class="p">,</span> <span
class="n">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">Flying</span><span class="p">]</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Rock</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Water</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">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">Poison</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">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">Ground</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="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>
@@ -603,15 +603,15 @@ entries entirely removed. The second is we can use the
<code class="docutils lit
<span
class="o">+----------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">Type</span> <span class="mi">1</span>
<span class="o">|</span> <span class="n">Type</span> <span
class="mi">2</span> <span class="n">List</span>
<span class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Fairy</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">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">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">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">Flying</span><span
class="p">,</span> <span class="n">Grass</span><span class="p">,</span> <span
class="n">Poison</span><span class="p">]</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Ground</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Steel</span><span
class="p">,</span> <span class="n">Flying</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Flying</span><span
class="p">,</span> <span class="n">Steel</span><span class="p">]</span>
<span class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Psychic</span><span
class="p">,</span> <span class="n">Poison</span><span class="p">]</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="p">[</span><span class="n">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="n">Fighting</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="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">Poison</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">Ice</span><span class="p">]</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="p">[</span><span class="n">Rock</span><span
class="p">]</span> <span
class="o">|</span>
<span
class="o">+----------+------------------------------------------------+</span>
</pre></div>
@@ -696,12 +696,12 @@ aggregate function without filtering rows from the entire
DataFrame.</p>
<span class="o">|</span> <span class="n">Poison</span> <span
class="o">|</span> <span class="mf">58.785714285714285</span> <span
class="o">|</span> <span class="mf">48.0</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Electric</span> <span
class="o">|</span> <span class="mf">98.88888888888889</span> <span
class="o">|</span> <span class="mf">72.5</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Fairy</span> <span
class="o">|</span> <span class="mf">47.5</span> <span
class="o">|</span> <span class="mf">35.0</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">72.75</span> <span
class="o">|</span> <span class="mf">52.8</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Ice</span> <span
class="o">|</span> <span class="mf">90.0</span> <span
class="o">|</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">Grass</span> <span
class="o">|</span> <span class="mf">54.23076923076923</span> <span
class="o">|</span> <span class="mf">42.5</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Fire</span> <span
class="o">|</span> <span class="mf">86.28571428571429</span> <span
class="o">|</span> <span class="mf">65.0</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Water</span> <span
class="o">|</span> <span class="mf">67.25806451612904</span> <span
class="o">|</span> <span class="mf">63.833333333333336</span> <span
class="o">|</span>
<span class="o">|</span> <span class="n">Ground</span> <span
class="o">|</span> <span class="mf">58.125</span> <span
class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Fighting</span> <span
class="o">|</span> <span class="mf">66.14285714285714</span> <span
class="o">|</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Psychic</span> <span
class="o">|</span> <span class="mf">99.25</span> <span
class="o">|</span> <span class="mf">81.75</span> <span
class="o">|</span>
<span class="o">+----------+--------------------+----------------------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index 24c0001..4c8a13b 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -389,11 +389,11 @@
<span class="o">+-----+---------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">608</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">924</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">281</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">543</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">851</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">879</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">488</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">982</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">135</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">264</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -404,8 +404,8 @@
<span class="o">+-----+--------+--------+--------+</span>
<span class="o">|</span> <span class="n">nrs</span> <span class="o">|</span>
<span class="n">names</span> <span class="o">|</span> <span
class="n">random</span> <span class="o">|</span> <span class="n">groups</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span>
<span class="n">python</span> <span class="o">|</span> <span
class="mi">608</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">924</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">879</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">488</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -423,11 +423,11 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">8</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">to_pandas</span><span class="p">()</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">8</span><span class="p">]:</span>
<span class="n">nrs</span> <span class="n">names</span> <span
class="n">random</span> <span class="n">groups</span>
-<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">608</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">924</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">281</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">543</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">851</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">879</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">488</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">982</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">135</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">264</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../autoapi/datafusion/dataframe/index.html#datafusion.dataframe.DataFrame.describe"
title="datafusion.dataframe.DataFrame.describe"><code class="xref py py-func
docutils literal notranslate"><span class="pre">describe()</span></code></a>
shows a quick statistic summary of your data:</p>
@@ -439,11 +439,11 @@ passing them to an Arrow table, and then converting them
to a pandas DataFrame.<
<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
<span class="o">|</span> <span class="n">count</span> <span
class="o">|</span> <span class="mf">5.0</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="mf">5.0</span> <span class="o">|</span> <span
class="mi">5</span> <span class="o">|</span>
<span class="o">|</span> <span class="n">null_count</span> <span
class="o">|</span> <span class="mf">0.0</span> <span
class="o">|</span> <span class="mi">0</span> <span class="o">|</span> <span
class="mf">0.0</span> <span class="o">|</span> <span
class="mi">0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">641.4</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">std</span> <span
class="o">|</span> <span class="mf">1.5811388300841898</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">257.1386785374771</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">281.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">924.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">608.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">mean</span> <span
class="o">|</span> <span class="mf">3.0</span> <span
class="o">|</span> <span class="n">null</span> <span class="o">|</span> <span
class="mf">549.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">371.7287989919533</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">135.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">982.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">488.0</span> <span class="o">|</span> <span
class="n">null</span> <span class="o">|</span>
<span
class="o">+------------+--------------------+-------+-------------------+--------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/functions.html
b/user-guide/common-operations/functions.html
index 55967af..3b8b477 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -410,7 +410,7 @@ In here we will cover some of the more popular use cases.
If you want to view al
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f62e7fc9750</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f1b49c46fd0</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
@@ -484,16 +484,16 @@ In here we will cover some of the more popular use cases.
If you want to view al
<span class="o">+--------------------------------+</span>
<span class="o">|</span> <span class="n">now</span><span class="p">()</span>
<span class="o">|</span>
<span class="o">+--------------------------------+</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T17</span><span class="p">:</span><span
class="mi">25</span><span class="p">:</span><span
class="mf">28.453025149</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2024</span><span
class="o">-</span><span class="mi">10</span><span class="o">-</span><span
class="mi">21</span><span class="n">T21</span><span class="p">:</span><span
class="mi">06</span><span class="p">:</span><span
class="mf">54.190252418</span><span class="n">Z</span> <span class="o">|</span>
<span class="o">+--------------------------------+</span>
</pre></div>
</div>
diff --git a/user-guide/common-operations/select-and-filter.html
b/user-guide/common-operations/select-and-filter.html
index 955b4d7..694075a 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -378,7 +378,7 @@
<span class="n">In</span> <span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="n">urllib</span><span
class="o">.</span><span class="n">request</span><span class="o">.</span><span
class="n">urlretrieve</span><span class="p">(</span><span
class="s2">"https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2021-01.parquet"</span><span
class="p">,</span>
<span class="o">...</span><span class="p">:</span>
<span class="s2">"yellow_trip_data.parquet"</span><span
class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span>
<span class="o"><</span><span class="n">http</span><span
class="o">.</span><span class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f62e41bd3d0</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">3</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'yellow_trip_data.parquet'</span><span class="p">,</span>
<span class="o"><</span><span class="n">http</span><span
class="o">.</span><span class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f1b49cc6050</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">4</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
diff --git a/user-guide/common-operations/windows.html
b/user-guide/common-operations/windows.html
index 97cb6d9..aa52989 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -428,7 +428,7 @@ provides a single value for multiple rows.</p>
<span class="o">...</span><span class="p">:</span> <span
class="s2">"pokemon.csv"</span><span class="p">,</span>
<span class="o">...</span><span class="p">:</span> <span class="p">)</span>
<span class="o">...</span><span class="p">:</span>
-<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f62c5d63590</span><span class="o">></span><span
class="p">)</span>
+<span class="n">Out</span><span class="p">[</span><span
class="mi">5</span><span class="p">]:</span> <span class="p">(</span><span
class="s1">'pokemon.csv'</span><span class="p">,</span> <span
class="o"><</span><span class="n">http</span><span class="o">.</span><span
class="n">client</span><span class="o">.</span><span
class="n">HTTPMessage</span> <span class="n">at</span> <span
class="mh">0x7f1b49cc60d0</span><span class="o">></span><span
class="p">)</span>
<span class="n">In</span> <span class="p">[</span><span
class="mi">6</span><span class="p">]:</span> <span class="n">ctx</span> <span
class="o">=</span> <span class="n">SessionContext</span><span
class="p">()</span>
@@ -657,20 +657,20 @@ power in its <code class="docutils literal
notranslate"><span class="pre">"
<span class="o">....</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">15</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">Name</span> <span
class="o">|</span> <span class="n">Attack</span> <span class="o">|</span> <span
class="n">Type</span> <span class="mi">1</span> <span class="o">|</span> <span
class="n">Average</span> <span class="n">Attack</span> <span class="o">|</span>
-<span
class="o">+---------------------+--------+--------+----------------+</span>
-<span class="o">|</span> <span class="n">Jynx</span> <span
class="o">|</span> <span class="mi">50</span> <span class="o">|</span>
<span class="n">Ice</span> <span class="o">|</span> <span
class="mf">67.5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Articuno</span> <span
class="o">|</span> <span class="mi">85</span> <span class="o">|</span>
<span class="n">Ice</span> <span class="o">|</span> <span
class="mf">67.5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Pidgey</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Pidgeotto</span> <span
class="o">|</span> <span class="mi">60</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Pidgeot</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">PidgeotMega</span> <span
class="n">Pidgeot</span> <span class="o">|</span> <span class="mi">80</span>
<span class="o">|</span> <span class="n">Normal</span> <span
class="o">|</span> <span class="mf">70.625</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Rattata</span> <span
class="o">|</span> <span class="mi">56</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Raticate</span> <span
class="o">|</span> <span class="mi">81</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Spearow</span> <span
class="o">|</span> <span class="mi">60</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Fearow</span> <span
class="o">|</span> <span class="mi">90</span> <span class="o">|</span>
<span class="n">Normal</span> <span class="o">|</span> <span
class="mf">70.625</span> <span class="o">|</span>
-<span
class="o">+---------------------+--------+--------+----------------+</span>
+<span
class="o">+-----------------------+--------+--------+-------------------+</span>
+<span class="o">|</span> <span class="n">Name</span> <span
class="o">|</span> <span class="n">Attack</span> <span class="o">|</span> <span
class="n">Type</span> <span class="mi">1</span> <span class="o">|</span> <span
class="n">Average</span> <span class="n">Attack</span> <span
class="o">|</span>
+<span
class="o">+-----------------------+--------+--------+-------------------+</span>
+<span class="o">|</span> <span class="n">Metapod</span> <span
class="o">|</span> <span class="mi">20</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Butterfree</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Weedle</span> <span
class="o">|</span> <span class="mi">35</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Kakuna</span> <span
class="o">|</span> <span class="mi">25</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Beedrill</span> <span
class="o">|</span> <span class="mi">90</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">BeedrillMega</span> <span
class="n">Beedrill</span> <span class="o">|</span> <span class="mi">150</span>
<span class="o">|</span> <span class="n">Bug</span> <span
class="o">|</span> <span class="mf">76.42857142857143</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Paras</span> <span
class="o">|</span> <span class="mi">70</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Parasect</span> <span
class="o">|</span> <span class="mi">95</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Venonat</span> <span
class="o">|</span> <span class="mi">55</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Venomoth</span> <span
class="o">|</span> <span class="mi">65</span> <span class="o">|</span>
<span class="n">Bug</span> <span class="o">|</span> <span
class="mf">76.42857142857143</span> <span class="o">|</span>
+<span
class="o">+-----------------------+--------+--------+-------------------+</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]