table function - RDocumentation (2024)

Description

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

Usage

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 tableas.data.frame(x, row.names = NULL, …, responseName = "Freq", stringsAsFactors = TRUE, sep = "", base = list(LETTERS))

Arguments

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 as.data.frame, unused.)

exclude

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.

dnn

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

deparse.level

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

x

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

row.names

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

responseName

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

stringsAsFactors

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

sep, base

passed to provideDimnames.

Value

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 as.data.frame 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.

Details

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).

References

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.

Examples

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() <-> as.data.frame.table() :UCBAdmissions ## already a contingency tableDF <- as.data.frame(UCBAdmissions)class(tab <- 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 counting:is.na(d) <- 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]; is.na(d.patho) <- 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)

FAQs

How to use the table() function in R? ›

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 is the function data table in R package? ›

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.

How do you solve if a table is a function? ›

The table is a function if there is a single rule that can consistently be applied to the input to get the output. If the same rule doesn't apply to all input and output relationships, then it's not a function.

What does the table function accomplish? ›

Table function (table())in R performs a tabulation of categorical variable and gives its frequency as output. It is further useful to create conditional frequency table and Proportinal frequency table. This recipe demonstrates how to use table() function to create the following two tables: Frequency table.

How do you use 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 to create a table of two variables in R? ›

To create a two way table, simply pass two variables to the table() function instead of one. The output of a two-way table is a two-dimensional array of integers where the row names are set to the levels of the first variable and the column names are set to the levels of the second variable.

How to access data from a table in R? ›

To access the table values, we can use single square brackets. For example, if we have a table called TABLE then the first element of the table can accessed by using TABLE[1].

What does the data table function do? ›

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. A data table cannot accommodate more than two variables. If you want to analyze more than two variables, you should instead use scenarios.

How to order data table in R? ›

To sort a data frame in R, use the order( ) function. By default, sorting is ASCENDING. Prepend the sorting variable by a minus sign to indicate DESCENDING order.

How does a function table work? ›

A function describes the relationship between an input variable (x) and an output variable (y). A table provides a list of x values and their y values. A table is a function if a given x value has only one y value. Multiple x values can have the same y value, but a given x value can only have one specific y value.

Which function grows the fastest? ›

An exponential function grows at a faster rate than a power function. Growth rates of a power function and an exponential function.

How to tell function from table? ›

Given a table of input and output values, determine whether the table represents a function.
  1. Identify the input and output values.
  2. Check to see if each input value is paired with only one output value. If so, the table represents a function.

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 is the purpose or function of table? ›

Tables are used to organize data that is too detailed or complicated to be described adequately in the text, allowing the reader to quickly see the results. They can be used to highlight trends or patterns in the data and to make a manuscript more readable by removing numeric data from the text.

What is the function to calculate the result in the data table? ›

MS Excel uses the table funtion to calculate the results in the data table. Explanation: The Table function is used to create a data table in MS Excel.

How do you use a table variable in a function? ›

To declare a table variable in SQL Server, start the DECLARE statement. The name of the table variable must start with at(@) sign. The TABLE keyword defines that the used variable is a table variable. After the TABLE keyword, define column names and datatypes of the table variable in SQL Server.

How do I pull a value from a table in R? ›

To access the table values, we can use single square brackets. For example, if we have a table called TABLE then the first element of the table can accessed by using TABLE[1].

How do I write to a table in R? ›

The write. table() function is used to export a dataframe or matrix to a file in the R Language. This function converts a dataframe into a text file in the R Language and can be used to write dataframe into a variety of space-separated files for example CSV( comma separated values) files.

How to apply a function to each row of a data frame in R? ›

apply() lets you perform a function across a data frame's rows or columns. In the arguments, you specify what you want as follows: apply(X = data. frame, MARGIN = 1, FUN = function.

Top Articles
Mikayla Demaiter Bio, Wiki, Net Worth, Boyfriend, Husband, Age
Workforce Management - Kronos - Blueprint Technologies
Wmaz 13
What Is a Megapixel: Essential Guide [Megapixels Explained]
Hoy Kilnoski Obituaries
Www.myschedule.kp.org
Mashle: Magic And Muscles Gogoanime
Santa Maria Cars Craigslist
Sarah Lindstrom Telegram
Clarita Amish Auction 2023
Who has the best money market rate right now?
Mannat Indian Grocers
Adt First Responder Discount
Apple Nails & Spa, 3429 Toringdon Way, Charlotte, Reviews and Appointments
Six Broadway Wiki
Fintechzoommortgagecalculator.live Hours
781 Area Code | Telephone Directories
라이키 유출
Budokai Z Pre Alpha Trello
How To Find Free Stuff On Craigslist San Diego | Tips, Popular Items, Safety Precautions | RoamBliss
Riverrun Rv Park Middletown Photos
Milanka Kudel Telegram
Syracuse Deadline
Sweeterthanolives
Master Series Snap On Tool Box
Ap Computer Science Principles Grade Calculator
Altametrics Login Little Caesars
Palindromic Sony Console For Short Crossword Clue 6 Letters: Composer Of
Tbom Retail Credit Card
Contoured Fowl Feather Wow
Cambria County Most Wanted 2022
Virtualrewardcenter.com/Activate
Kagtwt
Nikki Porsche Girl Head
Credit Bureau Contact Information
Basis Independent Brooklyn
Gabrielle Abbate Obituary
Cvs Pharmacy Tb Test
Parx Entries For Today
8 Common Things That are 7 Centimeters Long | Measuringly
Circuit Court Peoria Il
Meshuggah Bleed Tab
Ticketmaster La Dodgers
Priscilla 2023 Showtimes Near Regal Escondido
Reli Stocktwits
4215 Tapper Rd Norton Oh 44203
Skid B Gon Brake Pads
Agurahl The Butcher Wow
palm springs free stuff - craigslist
Vci Classified Paducah
Obsidian Guard's Skullsplitter
Dragon Ball Super Super Hero 123Movies
Latest Posts
Article information

Author: Gregorio Kreiger

Last Updated:

Views: 6099

Rating: 4.7 / 5 (77 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Gregorio Kreiger

Birthday: 1994-12-18

Address: 89212 Tracey Ramp, Sunside, MT 08453-0951

Phone: +9014805370218

Job: Customer Designer

Hobby: Mountain biking, Orienteering, Hiking, Sewing, Backpacking, Mushroom hunting, Backpacking

Introduction: My name is Gregorio Kreiger, I am a tender, brainy, enthusiastic, combative, agreeable, gentle, gentle person who loves writing and wants to share my knowledge and understanding with you.