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.

How to check if something is a data table in R? ›

table() function in R Language is used to check if an object is a table.

What is the function for table to data frame? ›

frame() function converts a table to a data frame in a format that you need for regression analysis on count data. If you need to summarize the counts first, you use table() to create the desired table. Now you get a data frame with three variables.

What is useNA in R? ›

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

How do table functions work? ›

A table function returns a set of rows for each input row. The returned set can contain zero, one, or more rows. Each row can contain one or more columns. Table functions are sometimes called “tabular functions”.

How do I extract information from a table in R? ›

Method - Extracting Information
  1. In the R Output, paste the below under Properties > R CODE: ...
  2. Check OUTPUT > Show raw R output.
  3. Click Calculate to see the printout of attributes available for extraction. ...
  4. Add a line of code using the attr() function which will extract the filter.labels from the table and call it filter:
Apr 4, 2022

How to check if a table exists in R? ›

dbExistsTable() returns a logical scalar, TRUE if the table or view specified by the name argument exists, FALSE otherwise. This includes temporary tables if supported by the database. An error is raised when calling this method for a closed or invalid connection.

How to check if a table is a dataframe in R? ›

frame() function in R Language is used to return TRUE if the specified data type is a data frame else return FALSE. R data. frame is a powerful data type, especially when processing table (. csv).

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.

Is a table a data frame in R? ›

frame in R is similar to the data table which is used to create tabular data but data table provides a lot more features than the data frame so, generally, all prefer the data. table instead of the data.

What is the purpose or 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.

What does table() do in R? ›

The table() function in R is a versatile tool that allows you to create frequency tables, also known as contingency tables, from categorical data. Its primary purpose is to summarize and organize the counts or frequencies of different unique values present within a vector, factor, or column of a data frame.

How to check if there is missing data in R? ›

In R programming, the missing values can be determined by is.na() method. This method accepts the data variable as a parameter and determines whether the data point is a missing value or not. To find the location of the missing value use which() method in which is.na() method is passed to which() method.

How to check a data type in R? ›

To determine the type of data, you can use the class(), mode() or typeof() functions. The following commands create different variables and check their type using the class() function. It is possible to convert from one data type to another by using functions such as as. integer(), as.

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 to plot data from a table in R? ›

Plotting a table in R is a straightforward process. To do so, one must first create a data frame with the desired variables and values, and then use the command “plot” followed by the data frame and the desired type of plot.

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.

References

Top Articles
MBA 2023 - Business school rankings from the Financial Times
BMW M2 Beats Its Toyota GR Supra Half-Sibling, but Is It Worth the Price Difference?
The Shoppes At Zion Directory
Bannerlord Campaign Or Sandbox
Health Stream Kaiser
Deshaun Watson Timeline: What Has Occurred Since First Lawsuit Filed
Pooch Parlor Covington Tn
Craigslist Pinellas County Rentals
Colossians 2 Amplified
Hudson River Regional Conference Inc. · 112-14 107th ave., South Richmond Hill, NY 11419
Lucio Surf Code
Rebecca Benedict Forum
What's the Difference Between Halal and Haram Meat & Food?
Choke Pony Dating App
Nypsl-E Tax Code Category
Mr Seconds Geneseo Ny
Please Put On Your Jacket In Italian Duolingo
Fisher-Cheney Funeral Home Obituaries
2006 Lebanon War | Summary, Casualties, & Israel
2887 Royce Road Varysburg Ny 14167
Gopher Hockey Forum
Ck3 Diplomatic Range
Pechins Ad
Craigslist For Sale By Owner Chillicothe Ohio
H. P. Lovecraft - Deutsche Lovecraft Gesellschaft
Brooklyn Pizzeria Gulfport Menu
Odawa Hypixel
Huffington Post Horoscope Libra
Starlight River Multiplayer
Www.publicsurplus.com Motor Pool
Katmoie
Black Adam Showtimes Near Linden Boulevard Multiplex Cinemas
Check Subdomains Of A Domain
Pella Culver's Flavor Of The Day
Sams Gurnee Gas Price
Shannon Ray Booty
How to get tink dissipator coil? - Dish De
Boone County Sheriff 700 Report
Www.lookmovie.og
A-Z List of Common Medical Abbreviations, Acronyms & Definitions
10000 Blaulicht-Meldungen aus Baden-Württemberg | Presseportal
1875 Grams To Pounds And Ounces
Best Greek Restaurants In Manhattan
Los Alamos Beach in Torremolinos: A Perfect Mediterranean Escape - Mama Málaga
Denny's Ace Hardware Duluth Mn
Lee County Buy Sell And Trade
Doomz.io Unblocked Games 76
Fifty Shades Of Gray 123Movies
'It's something you dream about': This sparky quit his job to be a YouTube star
Natriumazid 1% in wässriger Lösung
Christian Publishers Outlet Rivergate
Baja Boats For Sale On Craigslist
Latest Posts
Article information

Author: Arline Emard IV

Last Updated:

Views: 5969

Rating: 4.1 / 5 (52 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Arline Emard IV

Birthday: 1996-07-10

Address: 8912 Hintz Shore, West Louie, AZ 69363-0747

Phone: +13454700762376

Job: Administration Technician

Hobby: Paintball, Horseback riding, Cycling, Running, Macrame, Playing musical instruments, Soapmaking

Introduction: My name is Arline Emard IV, I am a cheerful, gorgeous, colorful, joyous, excited, super, inquisitive person who loves writing and wants to share my knowledge and understanding with you.