| <!DOCTYPE html> |
| <!-- Generated by pkgdown: do not edit by hand --><html lang="en-US"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><title>Table class — Table • Arrow R Package</title><!-- favicons --><link rel="icon" type="image/png" sizes="96x96" href="../favicon-96x96.png"><link rel="icon" type="”image/svg+xml”" href="../favicon.svg"><link rel="apple-touch-icon" sizes="180x180" href="../apple-touch-icon.png"><link rel="icon" sizes="any" href="../favicon.ico"><link rel="manifest" href="../site.webmanifest"><script src="../deps/jquery-3.6.0/jquery-3.6.0.min.js"></script><meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"><link href="../deps/bootstrap-5.3.1/bootstrap.min.css" rel="stylesheet"><script src="../deps/bootstrap-5.3.1/bootstrap.bundle.min.js"></script><link href="../deps/font-awesome-6.5.2/css/all.min.css" rel="stylesheet"><link href="../deps/font-awesome-6.5.2/css/v4-shims.min.css" rel="stylesheet"><script src="../deps/headroom-0.11.0/headroom.min.js"></script><script src="../deps/headroom-0.11.0/jQuery.headroom.min.js"></script><script src="../deps/bootstrap-toc-1.0.1/bootstrap-toc.min.js"></script><script src="../deps/clipboard.js-2.0.11/clipboard.min.js"></script><script src="../deps/search-1.0.0/autocomplete.jquery.min.js"></script><script src="../deps/search-1.0.0/fuse.min.js"></script><script src="../deps/search-1.0.0/mark.min.js"></script><!-- pkgdown --><script src="../pkgdown.js"></script><link href="../extra.css" rel="stylesheet"><meta property="og:title" content="Table class — Table"><meta name="description" content="A Table is a sequence of chunked arrays. They |
| have a similar interface to record batches, but they can be |
| composed from multiple record batches or chunked arrays."><meta property="og:description" content="A Table is a sequence of chunked arrays. They |
| have a similar interface to record batches, but they can be |
| composed from multiple record batches or chunked arrays."><meta property="og:image" content="https://arrow.apache.org/img/arrow-logo_horizontal_black-txt_white-bg.png"><meta property="og:image:alt" content="Apache Arrow logo, displaying the triple chevron image adjacent to the text"><!-- Matomo --><script> |
| var _paq = window._paq = window._paq || []; |
| /* tracker methods like "setCustomDimension" should be called before "trackPageView" */ |
| /* We explicitly disable cookie tracking to avoid privacy issues */ |
| _paq.push(['disableCookies']); |
| _paq.push(['trackPageView']); |
| _paq.push(['enableLinkTracking']); |
| (function() { |
| var u="https://analytics.apache.org/"; |
| _paq.push(['setTrackerUrl', u+'matomo.php']); |
| _paq.push(['setSiteId', '20']); |
| var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0]; |
| g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s); |
| })(); |
| </script><!-- End Matomo Code --><!-- Kapa AI --><script async src="https://widget.kapa.ai/kapa-widget.bundle.js" data-website-id="9db461d5-ac77-4b3f-a5c5-75efa78339d2" data-project-name="Apache Arrow" data-project-color="#000000" data-project-logo="https://arrow.apache.org/img/arrow-logo_chevrons_white-txt_black-bg.png" data-modal-disclaimer="This is a custom LLM with access to all of [Arrow documentation](https://arrow.apache.org/docs/). If you want an R-specific answer, please mention this in your question." data-consent-required="true" data-user-analytics-cookie-enabled="false" data-consent-screen-disclaimer="By clicking "I agree, let's chat", you consent to the use of the AI assistant in accordance with kapa.ai's [Privacy Policy](https://www.kapa.ai/content/privacy-policy). This service uses reCAPTCHA, which requires your consent to Google's [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms). By proceeding, you explicitly agree to both kapa.ai's and Google's privacy policies."></script><!-- End Kapa AI --></head><body> |
| <a href="#main" class="visually-hidden-focusable">Skip to contents</a> |
| |
| |
| <nav class="navbar fixed-top navbar-dark navbar-expand-lg bg-black"><div class="container"> |
| |
| <a class="navbar-brand me-2" href="../index.html">Arrow R Package</a> |
| |
| <span class="version"> |
| <small class="nav-text text-muted me-auto" data-bs-toggle="tooltip" data-bs-placement="bottom" title="">22.0.0</small> |
| </span> |
| |
| |
| <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbar" aria-controls="navbar" aria-expanded="false" aria-label="Toggle navigation"> |
| <span class="navbar-toggler-icon"></span> |
| </button> |
| |
| <div id="navbar" class="collapse navbar-collapse ms-3"> |
| <ul class="navbar-nav me-auto"><li class="nav-item"><a class="nav-link" href="../articles/arrow.html">Get started</a></li> |
| <li class="active nav-item"><a class="nav-link" href="../reference/index.html">Reference</a></li> |
| <li class="nav-item dropdown"> |
| <button class="nav-link dropdown-toggle" type="button" id="dropdown-articles" data-bs-toggle="dropdown" aria-expanded="false" aria-haspopup="true">Articles</button> |
| <ul class="dropdown-menu" aria-labelledby="dropdown-articles"><li><hr class="dropdown-divider"></li> |
| <li><h6 class="dropdown-header" data-toc-skip>Using the package</h6></li> |
| <li><a class="dropdown-item" href="../articles/read_write.html">Reading and writing data files</a></li> |
| <li><a class="dropdown-item" href="../articles/data_wrangling.html">Data analysis with dplyr syntax</a></li> |
| <li><a class="dropdown-item" href="../articles/dataset.html">Working with multi-file data sets</a></li> |
| <li><a class="dropdown-item" href="../articles/python.html">Integrating Arrow, Python, and R</a></li> |
| <li><a class="dropdown-item" href="../articles/fs.html">Using cloud storage (S3, GCS)</a></li> |
| <li><a class="dropdown-item" href="../articles/flight.html">Connecting to a Flight server</a></li> |
| <li><hr class="dropdown-divider"></li> |
| <li><h6 class="dropdown-header" data-toc-skip>Arrow concepts</h6></li> |
| <li><a class="dropdown-item" href="../articles/data_objects.html">Data objects</a></li> |
| <li><a class="dropdown-item" href="../articles/data_types.html">Data types</a></li> |
| <li><a class="dropdown-item" href="../articles/metadata.html">Metadata</a></li> |
| <li><hr class="dropdown-divider"></li> |
| <li><h6 class="dropdown-header" data-toc-skip>Installation</h6></li> |
| <li><a class="dropdown-item" href="../articles/install.html">Installing on Linux</a></li> |
| <li><a class="dropdown-item" href="../articles/install_nightly.html">Installing development versions</a></li> |
| <li><hr class="dropdown-divider"></li> |
| <li><a class="dropdown-item" href="../articles/index.html">More articles...</a></li> |
| </ul></li> |
| <li class="nav-item"><a class="nav-link" href="../news/index.html">Changelog</a></li> |
| </ul><form class="form-inline my-2 my-lg-0" role="search"> |
| <input type="search" class="form-control me-sm-2" aria-label="Toggle navigation" name="search-input" data-search-index="../search.json" id="search-input" placeholder="" autocomplete="off"></form> |
| |
| <ul class="navbar-nav"><li class="nav-item"><a class="external-link nav-link" href="https://github.com/apache/arrow/" aria-label="GitHub"><span class="fa fab fa-github fa-lg"></span></a></li> |
| </ul></div> |
| |
| |
| </div> |
| </nav><div class="container template-reference-topic"> |
| <div class="row"> |
| <main id="main" class="col-md-9"><div class="page-header"> |
| |
| <h1>Table class</h1> |
| <small class="dont-index">Source: <a href="https://github.com/apache/arrow/blob/main/r/R/table.R" class="external-link"><code>R/table.R</code></a></small> |
| <div class="d-none name"><code>Table-class.Rd</code></div> |
| </div> |
| |
| <div class="ref-description section level2"> |
| <p>A Table is a sequence of <a href="ChunkedArray-class.html">chunked arrays</a>. They |
| have a similar interface to <a href="RecordBatch-class.html">record batches</a>, but they can be |
| composed from multiple record batches or chunked arrays.</p> |
| </div> |
| |
| |
| <div class="section level2"> |
| <h2 id="s-methods-and-usage">S3 Methods and Usage<a class="anchor" aria-label="anchor" href="#s-methods-and-usage"></a></h2> |
| |
| |
| <p>Tables are data-frame-like, and many methods you expect to work on |
| a <code>data.frame</code> are implemented for <code>Table</code>. This includes <code>[</code>, <code>[[</code>, |
| <code>$</code>, <code>names</code>, <code>dim</code>, <code>nrow</code>, <code>ncol</code>, <code>head</code>, and <code>tail</code>. You can also pull |
| the data from an Arrow table into R with <code><a href="https://rdrr.io/r/base/as.data.frame.html" class="external-link">as.data.frame()</a></code>. See the |
| examples.</p> |
| <p>A caveat about the <code>$</code> method: because <code>Table</code> is an <code>R6</code> object, |
| <code>$</code> is also used to access the object's methods (see below). Methods take |
| precedence over the table's columns. So, <code>tab$Slice</code> would return the |
| "Slice" method function even if there were a column in the table called |
| "Slice".</p> |
| </div> |
| <div class="section level2"> |
| <h2 id="r-methods">R6 Methods<a class="anchor" aria-label="anchor" href="#r-methods"></a></h2> |
| |
| |
| <p>In addition to the more R-friendly S3 methods, a <code>Table</code> object has |
| the following R6 methods that map onto the underlying C++ methods:</p><ul><li><p><code>$column(i)</code>: Extract a <code>ChunkedArray</code> by integer position from the table</p></li> |
| <li><p><code>$ColumnNames()</code>: Get all column names (called by <code>names(tab)</code>)</p></li> |
| <li><p><code>$nbytes()</code>: Total number of bytes consumed by the elements of the table</p></li> |
| <li><p><code>$RenameColumns(value)</code>: Set all column names (called by <code>names(tab) <- value</code>)</p></li> |
| <li><p><code>$GetColumnByName(name)</code>: Extract a <code>ChunkedArray</code> by string name</p></li> |
| <li><p><code>$field(i)</code>: Extract a <code>Field</code> from the table schema by integer position</p></li> |
| <li><p><code>$SelectColumns(indices)</code>: Return new <code>Table</code> with specified columns, expressed as 0-based integers.</p></li> |
| <li><p><code>$Slice(offset, length = NULL)</code>: Create a zero-copy view starting at the |
| indicated integer offset and going for the given length, or to the end |
| of the table if <code>NULL</code>, the default.</p></li> |
| <li><p><code>$Take(i)</code>: return an <code>Table</code> with rows at positions given by |
| integers <code>i</code>. If <code>i</code> is an Arrow <code>Array</code> or <code>ChunkedArray</code>, it will be |
| coerced to an R vector before taking.</p></li> |
| <li><p><code>$Filter(i, keep_na = TRUE)</code>: return an <code>Table</code> with rows at positions where logical |
| vector or Arrow boolean-type <code>(Chunked)Array</code> <code>i</code> is <code>TRUE</code>.</p></li> |
| <li><p><code>$SortIndices(names, descending = FALSE)</code>: return an <code>Array</code> of integer row |
| positions that can be used to rearrange the <code>Table</code> in ascending or descending |
| order by the first named column, breaking ties with further named columns. |
| <code>descending</code> can be a logical vector of length one or of the same length as |
| <code>names</code>.</p></li> |
| <li><p><code>$serialize(output_stream, ...)</code>: Write the table to the given |
| <a href="OutputStream.html">OutputStream</a></p></li> |
| <li><p><code>$cast(target_schema, safe = TRUE, options = cast_options(safe))</code>: Alter |
| the schema of the record batch.</p></li> |
| </ul><p>There are also some active bindings:</p><ul><li><p><code>$num_columns</code></p></li> |
| <li><p><code>$num_rows</code></p></li> |
| <li><p><code>$schema</code></p></li> |
| <li><p><code>$metadata</code>: Returns the key-value metadata of the <code>Schema</code> as a named list. |
| Modify or replace by assigning in (<code>tab$metadata <- new_metadata</code>). |
| All list elements are coerced to string. See <code><a href="schema.html">schema()</a></code> for more information.</p></li> |
| <li><p><code>$columns</code>: Returns a list of <code>ChunkedArray</code>s</p></li> |
| </ul></div> |
| |
| </main><aside class="col-md-3"><nav id="toc" aria-label="Table of contents"><h2>On this page</h2> |
| </nav></aside></div> |
| |
| |
| <footer><div class="pkgdown-footer-left"> |
| <p><a href="https://arrow.apache.org/docs/r/versions.html">Older versions of these docs</a></p> |
| </div> |
| |
| <div class="pkgdown-footer-right"> |
| <p>Site built with <a href="https://pkgdown.r-lib.org/" class="external-link">pkgdown</a> 2.1.3.</p> |
| </div> |
| |
| </footer></div> |
| |
| |
| |
| |
| |
| </body></html> |
| |