table function - RDocumentation (2024)


table uses the cross-classifying factors to build a contingency table of the counts at each combination of factor levels.


table(…, exclude = if (useNA == "no") c(NA, NaN), useNA = c("no", "ifany", "always"), dnn = list.names(…), deparse.level = 1)

as.table(x, …)is.table(x)

# S3 method for, row.names = NULL, …, responseName = "Freq", stringsAsFactors = TRUE, sep = "", base = list(LETTERS))


one or more objects which can be interpreted as factors (including character strings), or a list (or data frame) whose components can be so interpreted. (For as.table, arguments passed to specific methods; for, unused.)


levels to remove for all factors in . If it does not contain NA and useNA is not specified, it implies useNA = "ifany". See ‘Details’ for its interpretation for non-factor arguments.


the names to be given to the dimensions in the result (the dimnames names).


controls how the default dnn is constructed. See ‘Details’.


an arbitrary R object, or an object inheriting from class "table" for the method. Note that, *) may be called explicitly for non-table x for “reshaping” arrays.


a character vector giving the row names for the data frame.


The name to be used for the column of table entries, usually counts.


logical: should the classifying factors be returned as factors (the default) or character vectors?

sep, base

passed to provideDimnames.


table() returns a contingency table, an object of class "table", an array of integer values. Note that unlike S the result is always an array, a 1D array if one factor is given.

as.table and is.table coerce to and test for contingency table, respectively.

The method for objects inheriting from class "table" can be used to convert the array-based representation of a contingency table to a data frame containing the classifying factors and the corresponding entries (the latter as component named by responseName). This is the inverse of xtabs.


If the argument dnn is not supplied, the internal function list.names is called to compute the ‘dimname names’. If the arguments in are named, those names are used. For the remaining arguments, deparse.level = 0 gives an empty name, deparse.level = 1 uses the supplied argument if it is a symbol, and deparse.level = 2 will deparse the argument.

Only when exclude is specified (i.e., not by default) and non-empty, will table potentially drop levels of factor arguments.

useNA controls if the table includes counts of NA values: the allowed values correspond to never ("no"), only if the count is positive ("ifany") and even for zero counts ("always"). Note the somewhat “pathological” case of two different kinds of NAs which are treated differently, depending on both useNA and exclude, see d.patho in the ‘Examples:’ below.

Both exclude and useNA operate on an “all or none” basis. If you want to control the dimensions of a multiway table separately, modify each argument using factor or addNA.

Non-factor arguments a are coerced via factor(a, exclude=exclude). Since R 3.4.0, care is taken not to count the excluded values (where they were included in the NA count, previously).

The summary method for class "table" (used for objects created by table or xtabs) which gives basic information and performs a chi-squared test for independence of factors (note that the function chisq.test currently only handles 2-d tables).


Becker, R. A., Chambers, J. M. and Wilks, A. R. (1988) The New S Language. Wadsworth & Brooks/Cole.

See Also

tabulate is the underlying function and allows finer control.

Use ftable for printing (and more) of multidimensional tables. margin.table, prop.table, addmargins.

addNA for constructing factors with NA as a level.

xtabs for cross tabulation of data frames with a formula interface.


Run this code

# NOT RUN {require(stats) # for rpois and xtabs## Simple frequency distributiontable(rpois(100, 5))## Check the design:with(warpbreaks, table(wool, tension))table(state.division, state.region)# simple two-way contingency tablewith(airquality, table(cut(Temp, quantile(Temp)), Month))a <- letters[1:3]table(a, sample(a)) # dnn is c("a", "")table(a, sample(a), deparse.level = 0) # dnn is c("", "")table(a, sample(a), deparse.level = 2) # dnn is c("a", "sample(a)")## xtabs() <-> :UCBAdmissions ## already a contingency tableDF <- <- xtabs(Freq ~ ., DF)) # xtabs & table## tab *is* "the same" as the original table:all(tab == UCBAdmissions)all.equal(dimnames(tab), dimnames(UCBAdmissions))a <- rep(c(NA, 1/0:3), 10)table(a) # does not report NA'stable(a, exclude = NULL) # reports NA'sb <- factor(rep(c("A","B","C"), 10))table(b)table(b, exclude = "B")d <- factor(rep(c("A","B","C"), 10), levels = c("A","B","C","D","E"))table(d, exclude = "B")print(table(b, d), zero.print = ".")## NA <- 3:4d. <- addNA(d)d.[1:7]table(d.) # ", exclude = NULL" is not needed## i.e., if you want to count the NA's of 'd', usetable(d, useNA = "ifany")## "pathological" case:d.patho <- addNA(c(1,NA,1:2,1:3))[-7]; <- 3:4d.patho## just 3 consecutive NA's ? --- well, have *two* kinds of NAs here :as.integer(d.patho) # 1 4 NA NA 1 2#### In R >= 3.4.0, table() allows to differentiate:table(d.patho) # counts the "unusual" NAtable(d.patho, useNA = "ifany") # counts all threetable(d.patho, exclude = NULL) # (ditto)table(d.patho, exclude = NA) # counts none## Two-way tables with NA counts. The 3rd variant is absurd, but shows## something that cannot be done using exclude or useNA.with(airquality, table(OzHi = Ozone > 80, Month, useNA = "ifany"))with(airquality, table(OzHi = Ozone > 80, Month, useNA = "always"))with(airquality, table(OzHi = Ozone > 80, addNA(Month)))# }

Run the code above in your browser using DataLab

table function - RDocumentation (2024)


What is the table function in Rdocumentation? ›

table() returns a contingency table, an object of class "table" , an array of integer values. Note that unlike S the result is always an array , a 1D array if one factor is given.

What is the table function in R package? ›

To use table(), simply add in the variables you want to tabulate separated by a comma. Note that table() does not have a data= argument like many other functions do (e.g., ggplot2 functions), so you much reference the variable using dataset$variable.

What does the table function accomplish? ›

A table function is directly linked to a single CLASS->METHOD. The Method is where all the logic is written. The table function simply exposes the output of the logic from the Method in a tabular format.

What is the use of table functions? ›

A table function, also called a table-valued function (TVF), is a user-defined function that returns a table. You can use a table function anywhere that you can use a table. Table functions behave similarly to views, but a table function can take parameters.

What does a table function look like? ›

The function table definition is a visual, gridded table with cells for input and cells for output that are organized into rows and columns. When students first learn function tables, they are often called function machines. The table itself has a specific rule that is applied to the input value to produce the output.

Which package is data table function in R? ›

Data. table is an extension of data. frame package in R. It is widely used for fast aggregation of large datasets, low latency add/update/remove of columns, quicker ordered joins, and a fast file reader.

What function creates tables in R? ›

We can create a table by using as. table() function, first we create a table using matrix and then assign it to this method to get the table format. Example: In this example, we will create a matrix and assign it to a table in the R language.

What is the function to read a table in R? ›

The read. table() function in R can be used to read a text file's contents. A versatile and often used function for reading tabular data from different file formats, including text files, is read. table().

How do you run a table function? ›

To invoke a user-defined table function, reference the function in the FROM clause of an SQL statement where it is to process a set of input values. The reference to the table function must be preceded by the TABLE clause and be contained in brackets.

How do you create a table in a function? ›

Creating SQL table functions
  1. Define the CREATE FUNCTION (table) statement: Specify a name for the function. Specify a name and data type for each input parameter. Specify the routine attributes. Specify the RETURNS TABLE keyword. ...
  2. Execute the CREATE FUNCTION (table) statement from a supported interface.

How do you clear a table function? ›

clear() is a function that removes all the elements from a table, leaving it empty. It is equivalent to iterating over the table and setting each key to nil.

What is the main function of table? ›

A table is an item of furniture with a raised flat top and is supported most commonly by 1 to 4 legs (although some can have more). It is used as a surface for working at, eating from or on which to place things.

When you use the table function what happens to the data? ›

The Table function creates a table from an argument list of records or tables. The result table's columns are the union of all the columns from all the argument records and tables.

What does the data table function do? ›

Unlike scenarios, data tables show you all the outcomes in one table on one worksheet. Using data tables makes it easy to examine a range of possibilities at a glance. Because you focus on only one or two variables, results are easy to read and share in tabular form.

What is the function of the Theatre table? ›

Providing a stable and secure platform for surgical procedures: OT tables are specifically designed to provide a stable and secure platform for surgical procedures, helping to reduce the risk of complications and improve patient outcomes.

What is the function of table in AutoCAD? ›

We use AutoCAD Tables to organize and present data in a structured format. Think of them as spreadsheets for your drawings. Use tables to show things like part lists and schedules. And because they are spreadsheet like, you can include various data types such as text, numbers, dates and formulas.

What does the table command do? ›

The table command itself can compute summary statistics. table also provides a command() option that allows you to run any Stata command and include its results in the table.

Top Articles
Latest Posts
Article information

Author: Golda Nolan II

Last Updated:

Views: 6032

Rating: 4.8 / 5 (58 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Golda Nolan II

Birthday: 1998-05-14

Address: Suite 369 9754 Roberts Pines, West Benitaburgh, NM 69180-7958

Phone: +522993866487

Job: Sales Executive

Hobby: Worldbuilding, Shopping, Quilting, Cooking, Homebrewing, Leather crafting, Pet

Introduction: My name is Golda Nolan II, I am a thoughtful, clever, cute, jolly, brave, powerful, splendid person who loves writing and wants to share my knowledge and understanding with you.