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/arrow-datafusion-python.git
commit 1f2504cb9e1b13c9aa0ffedc7c9ef6abf17c2c0d
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Aug 11 19:53:34 2023 +0000
Publish built docs triggered by e1b37401a2d1af86ab16b899f1dda8237a0d3535
---
_sources/contributor-guide/introduction.rst.txt | 9 ++++++
contributor-guide/introduction.html | 11 +++++++
generated/datafusion.SessionContext.html | 6 ++--
searchindex.js | 2 +-
user-guide/common-operations/aggregations.html | 34 +++++++++++-----------
user-guide/common-operations/basic-info.html | 34 +++++++++++-----------
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 | 30 +++++++++----------
10 files changed, 86 insertions(+), 66 deletions(-)
diff --git a/_sources/contributor-guide/introduction.rst.txt
b/_sources/contributor-guide/introduction.rst.txt
index dd61ad8..6de2b87 100644
--- a/_sources/contributor-guide/introduction.rst.txt
+++ b/_sources/contributor-guide/introduction.rst.txt
@@ -62,6 +62,15 @@ Whenever rust code changes (your changes or via `git pull`):
maturin develop
python -m pytest
+Running & Installing pre-commit hooks
+-------------------------------------
+
+arrow-datafusion-python takes advantage of `pre-commit
<https://pre-commit.com/>`_ to assist developers with code linting to help
reduce the number of commits that ultimately fail in CI due to linter errors.
Using the pre-commit hooks is optional for the developer but certainly helpful
for keeping PRs clean and concise.
+
+Our pre-commit hooks can be installed by running :code:`pre-commit install`,
which will install the configurations in your
ARROW_DATAFUSION_PYTHON_ROOT/.github directory and run each time you perform a
commit, failing to complete the commit if an offending lint is found allowing
you to make changes locally before pushing.
+
+The pre-commit hooks can also be run adhoc without installing them by simply
running :code:`pre-commit run --all-files`
+
Update Dependencies
-------------------
diff --git a/contributor-guide/introduction.html
b/contributor-guide/introduction.html
index 7926edc..7bba934 100644
--- a/contributor-guide/introduction.html
+++ b/contributor-guide/introduction.html
@@ -349,6 +349,11 @@
How to develop
</a>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#running-installing-pre-commit-hooks">
+ Running & Installing pre-commit hooks
+ </a>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#update-dependencies">
Update Dependencies
@@ -420,6 +425,12 @@ python<span class="w"> </span>-m<span class="w">
</span>pytest
</pre></div>
</div>
</section>
+<section id="running-installing-pre-commit-hooks">
+<h2>Running & Installing pre-commit hooks<a class="headerlink"
href="#running-installing-pre-commit-hooks" title="Permalink to this
heading">¶</a></h2>
+<p>arrow-datafusion-python takes advantage of <a class="reference external"
href="https://pre-commit.com/";>pre-commit</a> to assist developers with code
linting to help reduce the number of commits that ultimately fail in CI due to
linter errors. Using the pre-commit hooks is optional for the developer but
certainly helpful for keeping PRs clean and concise.</p>
+<p>Our pre-commit hooks can be installed by running <code class="code docutils
literal notranslate"><span class="pre">pre-commit</span> <span
class="pre">install</span></code>, which will install the configurations in
your ARROW_DATAFUSION_PYTHON_ROOT/.github directory and run each time you
perform a commit, failing to complete the commit if an offending lint is found
allowing you to make changes locally before pushing.</p>
+<p>The pre-commit hooks can also be run adhoc without installing them by
simply running <code class="code docutils literal notranslate"><span
class="pre">pre-commit</span> <span class="pre">run</span> <span
class="pre">--all-files</span></code></p>
+</section>
<section id="update-dependencies">
<h2>Update Dependencies<a class="headerlink" href="#update-dependencies"
title="Permalink to this heading">¶</a></h2>
<p>To change test dependencies, change the <cite>requirements.in</cite> and
run</p>
diff --git a/generated/datafusion.SessionContext.html
b/generated/datafusion.SessionContext.html
index cf81370..24be74f 100644
--- a/generated/datafusion.SessionContext.html
+++ b/generated/datafusion.SessionContext.html
@@ -819,12 +819,12 @@ multi-threaded execution engine to perform the
execution.</p>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.SessionContext.read_csv">
-<span class="sig-name descname"><span class="pre">read_csv</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">has_header</span></span><span class="o"><span
class="pr [...]
+<span class="sig-name descname"><span class="pre">read_csv</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">has_header</span></span><span class="o"><span
class="pr [...]
<dd></dd></dl>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.SessionContext.read_json">
-<span class="sig-name descname"><span class="pre">read_json</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema_infer_max_records</span></span><span
class="o"> [...]
+<span class="sig-name descname"><span class="pre">read_json</span></span><span
class="sig-paren">(</span><em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema_infer_max_records</span></span><span
class="o"> [...]
<dd></dd></dl>
<dl class="py method">
@@ -834,7 +834,7 @@ multi-threaded execution engine to perform the
execution.</p>
<dl class="py method">
<dt class="sig sig-object py" id="datafusion.SessionContext.register_csv">
-<span class="sig-name descname"><span
class="pre">register_csv</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">name</span></span></em>,
<em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><spa [...]
+<span class="sig-name descname"><span
class="pre">register_csv</span></span><span class="sig-paren">(</span><em
class="sig-param"><span class="n"><span class="pre">name</span></span></em>,
<em class="sig-param"><span class="n"><span
class="pre">path</span></span></em>, <em class="sig-param"><span
class="n"><span class="pre">schema</span></span><span class="o"><span
class="pre">=</span></span><span class="default_value"><span
class="pre">None</span></span></em>, <em class="sig-param"><spa [...]
<dd></dd></dl>
<dl class="py method">
diff --git a/searchindex.js b/searchindex.js
index 042fa3c..48c5f02 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["api", "api/dataframe", "api/execution_context",
"api/expression", "api/functions", "api/object_store",
"contributor-guide/introduction", "generated/datafusion.DataFrame",
"generated/datafusion.Expr", "generated/datafusion.RuntimeConfig",
"generated/datafusion.SessionConfig", "generated/datafusion.SessionContext",
"generated/datafusion.functions.functions",
"generated/datafusion.object_store.object_store", "index", "user-guide/basics",
"user-guide/common-ope [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["api", "api/dataframe", "api/execution_context",
"api/expression", "api/functions", "api/object_store",
"contributor-guide/introduction", "generated/datafusion.DataFrame",
"generated/datafusion.Expr", "generated/datafusion.RuntimeConfig",
"generated/datafusion.SessionConfig", "generated/datafusion.SessionContext",
"generated/datafusion.functions.functions",
"generated/datafusion.object_store.object_store", "index", "user-guide/basics",
"user-guide/common-ope [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index e22baa8..76e9bb0 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -406,7 +406,7 @@ For performing an aggregation, DataFusion provides the <a
class="reference inter
<span
class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
<span class="o">|</span> <span class="n">APPROX_DISTINCT</span><span
class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span
class="n">c</span><span class="p">)</span> <span class="o">|</span> <span
class="n">APPROX_MEDIAN</span><span class="p">(</span><span
class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span
class="p">)</span> <span class="o">|</span> <span
class="n">APPROX_PERCENTILE_CONT</span><span class="p">(</span><span
class="n">foo_ [...]
<span
class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
-<span class="o">|</span> <span class="mi">8</span>
<span class="o">|</span> <span class="mf">0.38593296581374087</span> <span
class="o">|</span> <span class="mf">0.38593296581374087</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">8</span>
<span class="o">|</span> <span class="mf">0.3405129650738258</span> <span
class="o">|</span> <span class="mf">0.3405129650738258</span>
<span class="o">|</span>
<span
class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
</pre></div>
</div>
@@ -415,28 +415,28 @@ the <code class="code docutils literal notranslate"><span
class="pre">group_by</
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">12</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">aggregate</span><span class="p">([</span><span
class="n">col_a</span><span class="p">],</span> <span class="p">[</span><span
class="n">f</span><span class="o">.</span><span class="n">sum</span><span
class="p">(</span><span class="n">col_c</s [...]
<span class="n">Out</span><span class="p">[</span><span
class="mi">12</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">a</span> <span class="o">|</span>
<span class="n">SUM</span><span class="p">(</span><span
class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span
class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span
class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span
class="n">d</span><span class="p">)</span> <span class="o">|</span> <span
class="n">MIN</span><span class="p">(</span><span [...]
-<span
class="o">+-----+----------------+--------------------+---------------------+</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="mi">322</span> <span class="o">|</span> <span
class="mf">0.9965977013547045</span> <span class="o">|</span> <span
class="mf">0.1619218346521616</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="mi">75</span> <span class="o">|</span> <span
class="mf">0.6069314173585633</span> <span class="o">|</span> <span
class="mf">0.03769220949440766</span> <span class="o">|</span>
-<span
class="o">+-----+----------------+--------------------+---------------------+</span>
+<span
class="o">+-----+----------------+--------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">a</span> <span class="o">|</span>
<span class="n">SUM</span><span class="p">(</span><span
class="n">foo_bar</span><span class="o">.</span><span class="n">c</span><span
class="p">)</span> <span class="o">|</span> <span class="n">MAX</span><span
class="p">(</span><span class="n">foo_bar</span><span class="o">.</span><span
class="n">d</span><span class="p">)</span> <span class="o">|</span> <span
class="n">MIN</span><span class="p">(</span><span [...]
+<span
class="o">+-----+----------------+--------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="mi">342</span> <span class="o">|</span> <span
class="mf">0.7956831772230495</span> <span class="o">|</span> <span
class="mf">0.059422268155995384</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="mi">141</span> <span class="o">|</span> <span
class="mf">0.5482694894513831</span> <span class="o">|</span> <span
class="mf">0.2867192908378937</span> <span class="o">|</span>
+<span
class="o">+-----+----------------+--------------------+----------------------+</span>
</pre></div>
</div>
<p>More than one column can be used for grouping</p>
<div class="highlight-ipython notranslate"><div
class="highlight"><pre><span></span><span class="n">In</span> <span
class="p">[</span><span class="mi">13</span><span class="p">]:</span> <span
class="n">df</span><span class="o">.</span><span
class="n">aggregate</span><span class="p">([</span><span
class="n">col_a</span><span class="p">,</span> <span
class="n">col_b</span><span class="p">],</span> <span class="p">[</span><span
class="n">f</span><span class="o">.</span><span class="n">sum</ [...]
<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">a</span> <span class="o">|</span>
<span class="n">b</span> <span class="o">|</span> <span
class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span
class="o">.</span><span class="n">c</span><span class="p">)</span> <span
class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span
class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span
class="p">)</span> <span class="o">|</span> [...]
-<span
class="o">+-----+-------+----------------+---------------------+---------------------+</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">one</span> <span class="o">|</span> <span
class="mi">70</span> <span class="o">|</span> <span
class="mf">0.9965977013547045</span> <span class="o">|</span> <span
class="mf">0.27615996150208977</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">one</span> <span class="o">|</span> <span
class="mi">34</span> <span class="o">|</span> <span
class="mf">0.03769220949440766</span> <span class="o">|</span> <span
class="mf">0.03769220949440766</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">two</span> <span class="o">|</span> <span
class="mi">175</span> <span class="o">|</span> <span
class="mf">0.9468768339611371</span> <span class="o">|</span> <span
class="mf">0.4614772616420465</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">three</span> <span class="o">|</span> <span class="mi">2</span>
<span class="o">|</span> <span
class="mf">0.30475423404534074</span> <span class="o">|</span> <span
class="mf">0.30475423404534074</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">two</span> <span class="o">|</span> <span
class="mi">39</span> <span class="o">|</span> <span
class="mf">0.6069314173585633</span> <span class="o">|</span> <span
class="mf">0.6069314173585633</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">three</span> <span class="o">|</span> <span
class="mi">77</span> <span class="o">|</span> <span
class="mf">0.1619218346521616</span> <span class="o">|</span> <span
class="mf">0.1619218346521616</span> <span class="o">|</span>
-<span
class="o">+-----+-------+----------------+---------------------+---------------------+</span>
+<span
class="o">+-----+-------+----------------+---------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">a</span> <span class="o">|</span>
<span class="n">b</span> <span class="o">|</span> <span
class="n">SUM</span><span class="p">(</span><span class="n">foo_bar</span><span
class="o">.</span><span class="n">c</span><span class="p">)</span> <span
class="o">|</span> <span class="n">MAX</span><span class="p">(</span><span
class="n">foo_bar</span><span class="o">.</span><span class="n">d</span><span
class="p">)</span> <span class="o">|</span> [...]
+<span
class="o">+-----+-------+----------------+---------------------+----------------------+</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">one</span> <span class="o">|</span> <span
class="mi">190</span> <span class="o">|</span> <span
class="mf">0.15076021983050847</span> <span class="o">|</span> <span
class="mf">0.059422268155995384</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">one</span> <span class="o">|</span> <span
class="mi">35</span> <span class="o">|</span> <span
class="mf">0.2867192908378937</span> <span class="o">|</span> <span
class="mf">0.2867192908378937</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">two</span> <span class="o">|</span> <span
class="mi">105</span> <span class="o">|</span> <span
class="mf">0.7956831772230495</span> <span class="o">|</span> <span
class="mf">0.4007128845363974</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">three</span> <span class="o">|</span> <span
class="mi">12</span> <span class="o">|</span> <span
class="mf">0.5482694894513831</span> <span class="o">|</span> <span
class="mf">0.5482694894513831</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="n">two</span> <span class="o">|</span> <span
class="mi">94</span> <span class="o">|</span> <span
class="mf">0.30746981160109654</span> <span class="o">|</span> <span
class="mf">0.30746981160109654</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">three</span> <span class="o">|</span> <span
class="mi">47</span> <span class="o">|</span> <span
class="mf">0.7256213233696616</span> <span class="o">|</span> <span
class="mf">0.7256213233696616</span> <span class="o">|</span>
+<span
class="o">+-----+-------+----------------+---------------------+----------------------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/common-operations/basic-info.html
b/user-guide/common-operations/basic-info.html
index 7195b09..3cc7321 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -390,11 +390,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">224</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">9</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">69</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">388</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">248</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">197</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">992</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">296</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">978</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">507</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -405,8 +405,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">224</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">9</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">197</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">992</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -424,11 +424,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">224</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">9</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">69</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">388</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">248</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">197</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">992</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">296</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">978</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">507</span> <span
class="n">B</span>
</pre></div>
</div>
<p><a class="reference internal"
href="../../generated/datafusion.DataFrame.html#datafusion.DataFrame.describe"
title="datafusion.DataFrame.describe"><code class="xref py py-meth docutils
literal notranslate"><span class="pre">DataFrame.describe()</span></code></a>
shows a quick statistic summary of your data:</p>
@@ -440,11 +440,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">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">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">187.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">150.91156350657823</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">9.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">388.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">224.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">594.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">374.11295085842727</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">197.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">992.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">507.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 4ec7e25..cff10e3 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -411,7 +411,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">0x7f81865fadd0</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">0x7fa1f7e4d750</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>
@@ -485,16 +485,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">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">10</span><span class="n">T00</span><span class="p">:</span><span
class="mi">09</span><span class="p">:</span><span
class="mf">58.547833600</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</span><span class="n">Z</span> <span class="o">|</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">08</span><span class="o">-</span><span
class="mi">11</span><span class="n">T19</span><span class="p">:</span><span
class="mi">53</span><span class="p">:</span><span
class="mf">29.627292459</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 5abfa16..6a0e75c 100644
--- a/user-guide/common-operations/joins.html
+++ b/user-guide/common-operations/joins.html
@@ -439,8 +439,8 @@ will be included in the resulting DataFrame.</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">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 ddc21e6..76c409e 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -379,7 +379,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">0x7f81844bfc70</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">0x7fa1f7ee2a40</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 6c9438e..c3f1d6a 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -386,7 +386,7 @@ produce a result for each individual row, unlike an
aggregate function that prov
<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">0x7f8184525ab0</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">0x7fa1f5d64550</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>
@@ -405,20 +405,20 @@ produce a result for each individual row, unlike an
aggregate function that prov
<span class="o">...</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">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">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="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="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="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="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="mf">76.42857142857143</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Scyther</span> <span
class="o">|</span> <span class="mi">110</span> <span class="o">|</span>
<span class="mf">76.42857142857143</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Pinsir</span> <span
class="o">|</span> <span class="mi">125</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="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="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="mf">76.42857142857143</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">Average</span> <span class="n">Attack</span> <span
class="o">|</span>
+<span class="o">+------------+--------+--------------------+</span>
+<span class="o">|</span> <span class="n">Dragonite</span> <span
class="o">|</span> <span class="mi">134</span> <span class="o">|</span>
<span class="mf">94.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Dragonair</span> <span
class="o">|</span> <span class="mi">84</span> <span class="o">|</span>
<span class="mf">94.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Dratini</span> <span
class="o">|</span> <span class="mi">64</span> <span class="o">|</span>
<span class="mf">94.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Clefairy</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="mf">57.5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Clefable</span> <span
class="o">|</span> <span class="mi">70</span> <span class="o">|</span>
<span class="mf">57.5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Machamp</span> <span
class="o">|</span> <span class="mi">130</span> <span class="o">|</span>
<span class="mf">102.85714285714286</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Hitmonchan</span> <span
class="o">|</span> <span class="mi">105</span> <span class="o">|</span>
<span class="mf">102.85714285714286</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Hitmonlee</span> <span
class="o">|</span> <span class="mi">120</span> <span class="o">|</span>
<span class="mf">102.85714285714286</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Machop</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mf">102.85714285714286</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Machoke</span> <span
class="o">|</span> <span class="mi">100</span> <span class="o">|</span>
<span class="mf">102.85714285714286</span> <span class="o">|</span>
+<span class="o">+------------+--------+--------------------+</span>
</pre></div>
</div>
<p>You can also control the order in which rows are processed by window
functions by providing
