R Combine Tables


Outer join in R using merge function: merge function takes df1 and df2 as argument along with all=TRUE there by returns all rows from both tables, join records from the left which have matching keys in the right table. 1 2 df = merge(x=df1,y=df2,by='CustomerId',all=TRUE). Data.table is a package is used for working with tabular data in R. It provides the efficient data.table object which is a much improved version of the default data.frame. It is super fast and has intuitive and terse syntax. If you know R language and haven’t picked up the data.table package yet, then this tutorial guide is a great place to.

table {base}R Documentation

Cross Tabulation and Table Creation



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




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


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


whether to include NA values in the table.See ‘Details’. Can be abbreviated.


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


controls how the default dnn isconstructed. See ‘Details’.


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


a character vector giving the row names for the dataframe.


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


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

sep, base

passed to provideDimnames.


If the argument dnn is not supplied, the internal functionlist.names is called to compute the ‘dimname names’. If thearguments in ... are named, those names are used. For theremaining 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) andnon-empty, will table potentially drop levels of factorarguments.

useNA controls if the table includes counts of NAvalues: the allowed values correspond to never ('no'), only if the count ispositive ('ifany') and even for zero counts ('always').Note the somewhat “pathological” case of two different kinds ofNAs which are treated differently, depending on bothuseNA 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 tableseparately, modify each argument using factor oraddNA.

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

The summary method for class 'table' (used for objectscreated by table or xtabs) which gives basicinformation and performs a chi-squared test for independence offactors (note that the function chisq.test currentlyonly handles 2-d tables).


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

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

The as.data.frame method for objects inheriting from class'table' can be used to convert the array-based representationof a contingency table to a data frame containing the classifyingfactors and the corresponding entries (the latter as componentnamed by responseName). This is the inverse of xtabs.


Join Two Tables In R

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

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

addNA for constructing factors with NA asa level.

R Combine Tables Excel

xtabs for cross tabulation of data frames with aformula interface.

R Combine Tables Online