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 c15fe2b Publish built docs triggered by
ef889211a0365f208a39221a93e6fee54f3ad4ed
c15fe2b is described below
commit c15fe2b2f0f8ed1bfbad4f5638453d2e4c998057
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri May 31 15:02:21 2024 +0000
Publish built docs triggered by ef889211a0365f208a39221a93e6fee54f3ad4ed
---
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 | 58 +++++++++++-----------
7 files changed, 77 insertions(+), 77 deletions(-)
diff --git a/searchindex.js b/searchindex.js
index aae229d..206ffa3 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"API Reference": [[0, "api-reference"]],
"Aggregation": [[16, "aggregation"]], "Avro": [[27, "avro"]], "Basic
Operations": [[17, "basic-operations"]], "Boolean": [[18, "boolean"]], "CSV":
[[28, "csv"]], "Column": [[18, "column"]], "Column Selections": [[22,
"column-selections"]], "Common Operations": [[20, "common-operations"]],
"Concepts": [[15, "concepts"]], "Conditional": [[19, "conditional"]],
"Configuration": [[25, "configuration"]], "DataFrame": [[1, [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"API Reference": [[0, "api-reference"]],
"Aggregation": [[16, "aggregation"]], "Avro": [[27, "avro"]], "Basic
Operations": [[17, "basic-operations"]], "Boolean": [[18, "boolean"]], "CSV":
[[28, "csv"]], "Column": [[18, "column"]], "Column Selections": [[22,
"column-selections"]], "Common Operations": [[20, "common-operations"]],
"Concepts": [[15, "concepts"]], "Conditional": [[19, "conditional"]],
"Configuration": [[25, "configuration"]], "DataFrame": [[1, [...]
\ No newline at end of file
diff --git a/user-guide/common-operations/aggregations.html
b/user-guide/common-operations/aggregations.html
index 3bb4e29..b7aea0d 100644
--- a/user-guide/common-operations/aggregations.html
+++ b/user-guide/common-operations/aggregations.html
@@ -417,7 +417,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.39750249593664966</span> <span
class="o">|</span> <span class="mf">0.39750249593664966</span>
<span class="o">|</span>
+<span class="o">|</span> <span class="mi">8</span>
<span class="o">|</span> <span class="mf">0.41337570627800363</span> <span
class="o">|</span> <span class="mf">0.41337570627800363</span>
<span class="o">|</span>
<span
class="o">+----------------------------+--------------------------+------------------------------------------------+</span>
</pre></div>
</div>
@@ -426,28 +426,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">275</span> <span class="o">|</span> <span
class="mf">0.7870989281668387</span> <span class="o">|</span> <span
class="mf">0.11911552388487434</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="mi">221</span> <span class="o">|</span> <span
class="mf">0.6719806185385827</span> <span class="o">|</span> <span
class="mf">0.17420618680605693</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">351</span> <span class="o">|</span> <span
class="mf">0.8416555297982307</span> <span class="o">|</span> <span
class="mf">0.3135939495980634</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">bar</span> <span class="o">|</span>
<span class="mi">96</span> <span class="o">|</span> <span
class="mf">0.8301482897511284</span> <span class="o">|</span> <span
class="mf">0.028726151070095907</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">121</span> <span class="o">|</span> <span
class="mf">0.7870989281668387</span> <span class="o">|</span> <span
class="mf">0.2142778885543727</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">73</span> <span class="o">|</span> <span
class="mf">0.6719806185385827</span> <span class="o">|</span> <span
class="mf">0.6719806185385827</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">87</span> <span class="o">|</span> <span
class="mf">0.17420618680605693</span> <span class="o">|</span> <span
class="mf">0.17420618680605693</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">61</span> <span class="o">|</span> <span
class="mf">0.39750249593664966</span> <span class="o">|</span> <span
class="mf">0.39750249593664966</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">122</span> <span class="o">|</span> <span
class="mf">0.6104421249170311</span> <span class="o">|</span> <span
class="mf">0.4342749490037877</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">32</span> <span class="o">|</span> <span
class="mf">0.11911552388487434</span> <span class="o">|</span> <span
class="mf">0.11911552388487434</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">two</span> <span class="o">|</span> <span
class="mi">125</span> <span class="o">|</span> <span
class="mf">0.8416555297982307</span> <span class="o">|</span> <span
class="mf">0.35457736508837545</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">75</span> <span class="o">|</span> <span
class="mf">0.8232070639314484</span> <span class="o">|</span> <span
class="mf">0.8232070639314484</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">151</span> <span class="o">|</span> <span
class="mf">0.5305331309887719</span> <span class="o">|</span> <span
class="mf">0.3135939495980634</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">1</span>
<span class="o">|</span> <span
class="mf">0.028726151070095907</span> <span class="o">|</span> <span
class="mf">0.028726151070095907</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">59</span> <span class="o">|</span> <span
class="mf">0.8301482897511284</span> <span class="o">|</span> <span
class="mf">0.8301482897511284</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">36</span> <span class="o">|</span> <span
class="mf">0.12153931959193887</span> <span class="o">|</span> <span
class="mf">0.12153931959193887</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 271e0a3..08a4f09 100644
--- a/user-guide/common-operations/basic-info.html
+++ b/user-guide/common-operations/basic-info.html
@@ -401,11 +401,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">213</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">777</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">992</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">741</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">969</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">474</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">569</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">189</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">71</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">183</span> <span class="o">|</span> <span class="n">B</span>
<span class="o">|</span>
<span class="o">+-----+---------+--------+--------+</span>
</pre></div>
</div>
@@ -416,8 +416,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">213</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">777</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">474</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">569</span> <span class="o">|</span> <span class="n">A</span>
<span class="o">|</span>
<span class="o">+-----+--------+--------+--------+</span>
</pre></div>
</div>
@@ -435,11 +435,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">213</span> <span
class="n">A</span>
-<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">777</span> <span
class="n">A</span>
-<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">992</span> <span
class="n">B</span>
-<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">741</span> <span
class="n">C</span>
-<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">969</span> <span
class="n">B</span>
+<span class="mi">0</span> <span class="mi">1</span> <span
class="n">python</span> <span class="mi">474</span> <span
class="n">A</span>
+<span class="mi">1</span> <span class="mi">2</span> <span
class="n">ruby</span> <span class="mi">569</span> <span
class="n">A</span>
+<span class="mi">2</span> <span class="mi">3</span> <span
class="n">java</span> <span class="mi">189</span> <span
class="n">B</span>
+<span class="mi">3</span> <span class="mi">4</span> <span
class="n">haskell</span> <span class="mi">71</span> <span
class="n">C</span>
+<span class="mi">4</span> <span class="mi">5</span> <span
class="n">go</span> <span class="mi">183</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>
@@ -451,11 +451,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">738.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">314.2575376979843</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">213.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">777.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">297.2</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">212.7491480593988</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">71.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">569.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">189.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 bae842c..a7391de 100644
--- a/user-guide/common-operations/functions.html
+++ b/user-guide/common-operations/functions.html
@@ -422,7 +422,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">0x7f66e07f8110</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">0x7f5bb62e82d0</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>
@@ -496,16 +496,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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">25</span><span class="n">T12</span><span class="p">:</span><span
class="mi">48</span><span class="p">:</span><span
class="mf">49.795589984</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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">05</span><span class="o">-</span><span
class="mi">31</span><span class="n">T15</span><span class="p">:</span><span
class="mi">02</span><span class="p">:</span><span
class="mf">17.984137976</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 cdf49f8..2b2bfec 100644
--- a/user-guide/common-operations/joins.html
+++ b/user-guide/common-operations/joins.html
@@ -486,8 +486,8 @@ is no match. Unmatched rows will have null values.</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="o">|</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span> <span
class="n">UrbanGo</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">3</span> <span
class="o">|</span> <span class="n">Charlie</span> <span class="o">|</span>
<span class="o">|</span> <span class="o">|</span>
<span class="o">+-------------+----------+----+-----------+</span>
diff --git a/user-guide/common-operations/select-and-filter.html
b/user-guide/common-operations/select-and-filter.html
index ef19913..0367f74 100644
--- a/user-guide/common-operations/select-and-filter.html
+++ b/user-guide/common-operations/select-and-filter.html
@@ -390,7 +390,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">0x7f66e06db690</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">0x7f5bb4703110</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 3445a3f..ce124f4 100644
--- a/user-guide/common-operations/windows.html
+++ b/user-guide/common-operations/windows.html
@@ -397,7 +397,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">0x7f66e0719690</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">0x7f5bb4765ed0</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>
@@ -416,20 +416,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">Gastly</span> <span
class="o">|</span> <span class="mi">35</span> <span class="o">|</span>
<span class="mf">35.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">GengarMega</span> <span
class="n">Gengar</span> <span class="o">|</span> <span class="mi">65</span>
<span class="o">|</span> <span class="mf">50.0</span> <span
class="o">|</span>
-<span class="o">|</span> <span class="n">Gengar</span> <span
class="o">|</span> <span class="mi">65</span> <span class="o">|</span>
<span class="mf">55.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Haunter</span> <span
class="o">|</span> <span class="mi">50</span> <span class="o">|</span>
<span class="mf">53.75</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Dodrio</span> <span
class="o">|</span> <span class="mi">110</span> <span class="o">|</span>
<span class="mf">110.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Chansey</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="mf">57.5</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="mf">58.333333333333336</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="mf">66.25</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Jigglypuff</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="mf">62.0</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Wigglytuff</span> <span
class="o">|</span> <span class="mi">70</span> <span class="o">|</span>
<span class="mf">63.333333333333336</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">Exeggcute</span> <span
class="o">|</span> <span class="mi">40</span> <span class="o">|</span>
<span class="mf">40.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ivysaur</span> <span
class="o">|</span> <span class="mi">62</span> <span class="o">|</span>
<span class="mf">51.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Venusaur</span> <span
class="o">|</span> <span class="mi">82</span> <span class="o">|</span>
<span class="mf">61.333333333333336</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">VenusaurMega</span> <span
class="n">Venusaur</span> <span class="o">|</span> <span class="mi">100</span>
<span class="o">|</span> <span class="mf">71.0</span> <span
class="o">|</span>
+<span class="o">|</span> <span class="n">Tangela</span> <span
class="o">|</span> <span class="mi">55</span> <span class="o">|</span>
<span class="mf">67.8</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bellsprout</span> <span
class="o">|</span> <span class="mi">75</span> <span class="o">|</span>
<span class="mf">69.0</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Vileplume</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mf">70.57142857142857</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Gloom</span> <span
class="o">|</span> <span class="mi">65</span> <span class="o">|</span>
<span class="mf">69.875</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Bulbasaur</span> <span
class="o">|</span> <span class="mi">49</span> <span class="o">|</span>
<span class="mf">67.55555555555556</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Oddish</span> <span
class="o">|</span> <span class="mi">50</span> <span class="o">|</span>
<span class="mf">65.8</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
@@ -450,20 +450,20 @@ a list of <a class="reference internal"
href="../../generated/datafusion.functio
<span class="o">...</span><span class="p">:</span>
<span class="n">Out</span><span class="p">[</span><span
class="mi">9</span><span class="p">]:</span>
<span class="n">DataFrame</span><span class="p">()</span>
-<span class="o">+------------+--------+------+</span>
-<span class="o">|</span> <span class="n">Name</span> <span
class="o">|</span> <span class="n">Attack</span> <span class="o">|</span> <span
class="n">rank</span> <span class="o">|</span>
-<span class="o">+------------+--------+------+</span>
-<span class="o">|</span> <span class="n">Exeggcute</span> <span
class="o">|</span> <span class="mi">40</span> <span class="o">|</span>
<span class="mi">1</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bulbasaur</span> <span
class="o">|</span> <span class="mi">49</span> <span class="o">|</span>
<span class="mi">2</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Oddish</span> <span
class="o">|</span> <span class="mi">50</span> <span class="o">|</span>
<span class="mi">3</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Tangela</span> <span
class="o">|</span> <span class="mi">55</span> <span class="o">|</span>
<span class="mi">4</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Ivysaur</span> <span
class="o">|</span> <span class="mi">62</span> <span class="o">|</span>
<span class="mi">5</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Gloom</span> <span
class="o">|</span> <span class="mi">65</span> <span class="o">|</span>
<span class="mi">6</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Bellsprout</span> <span
class="o">|</span> <span class="mi">75</span> <span class="o">|</span>
<span class="mi">7</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Vileplume</span> <span
class="o">|</span> <span class="mi">80</span> <span class="o">|</span>
<span class="mi">8</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Venusaur</span> <span
class="o">|</span> <span class="mi">82</span> <span class="o">|</span>
<span class="mi">9</span> <span class="o">|</span>
-<span class="o">|</span> <span class="n">Weepinbell</span> <span
class="o">|</span> <span class="mi">90</span> <span class="o">|</span>
<span class="mi">10</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">rank</span> <span class="o">|</span>
+<span class="o">+-------------------+--------+------+</span>
+<span class="o">|</span> <span class="n">Gastly</span> <span
class="o">|</span> <span class="mi">35</span> <span class="o">|</span>
<span class="mi">1</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Haunter</span> <span
class="o">|</span> <span class="mi">50</span> <span class="o">|</span>
<span class="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">GengarMega</span> <span
class="n">Gengar</span> <span class="o">|</span> <span class="mi">65</span>
<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Gengar</span> <span
class="o">|</span> <span class="mi">65</span> <span class="o">|</span>
<span class="mi">3</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Chansey</span> <span
class="o">|</span> <span class="mi">5</span> <span class="o">|</span>
<span class="mi">1</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="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Jigglypuff</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Meowth</span> <span
class="o">|</span> <span class="mi">45</span> <span class="o">|</span>
<span class="mi">2</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Ditto</span> <span
class="o">|</span> <span class="mi">48</span> <span class="o">|</span>
<span class="mi">5</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">Eevee</span> <span
class="o">|</span> <span class="mi">55</span> <span class="o">|</span>
<span class="mi">6</span> <span class="o">|</span>
+<span class="o">+-------------------+--------+------+</span>
</pre></div>
</div>
<p>The possible window functions are:</p>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
