6 Working with Tables in R

Tables are often essential for organzing and summarizing your data, especially with categorical variables. When creating a table in R, it considers your table as a specifc type of object (called “table”) which is very similar to a data frame. Though this may seem strange since datasets are stored as data frames, this means working with tables will be very easy since we have covered data frames in detail over the previous tutorials. In this chapter, we will discuss how to create various types of tables, and how to use various statistical methods to analyze tabular data. Throughout the chapter, the AOSI dataset will be used.

6.2 Creating Basic Tables: table() and xtabs()

A contingency table is a tabulation of counts and/or percentages for one or more variables. In R, these tables can be created using table() along with some of its variations. 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. Some examples are shown below. By default, missing values are excluded from the counts; if you want a count for these missing values you must specify the argument useNA=“ifany” or useNA=“always”. The below examples show how to use this function.

aosi_data read.csv("Data/cross-sec_aosi.csv", stringsAsFactors=FALSE, na.strings = ".") # Table for gender table(aosi_data$Gender)
## ## Female Male ## 235 352
# Table for study site table(aosi_data$Study_Site)
## ## PHI SEA STL UNC ## 149 152 145 141
# Two-way table for gender and study site table(aosi_data$Gender, aosi_data$Study_Site) 
## ## PHI SEA STL UNC ## Female 55 67 60 53 ## Male 94 85 85 88
# Notice order matters: 1st variable is row variable, 2nd variable is column variable # Let's try adding in the useNA argument table(aosi_data$Gender, aosi_data$Study_Site, useNA = "ifany") 
## ## PHI SEA STL UNC ## Female 55 67 60 53 ## Male 94 85 85 88
table(aosi_data$Gender, aosi_data$Study_Site, useNA = "always") 
## ## PHI SEA STL UNC ## Female 55 67 60 53 0 ## Male 94 85 85 88 0 ## 0 0 0 0 0
# Let's save one of these tables to use for later examples table_ex table(aosi_data$Gender, aosi_data$Study_Site) 

Now let’s add row and column labels to the gender by study site table. For a table object, these labels are referred to as “dimnames” (i.e., dimension names) which can be accessed using the dimnames() function. Note that this is similar to the names() function with lists, except that now our table has multiple dimensions, each of which can have its own set of names. For a table, dimnames are stored as a list, with each list entry holding the group labels for the variable corresponding to that dimension. The name for each of these list entries will specify the actual label to be used in the table. By default, these names are blank, hence why the default table has no row and column labels. We can change this by specifying these names, using names() with dimnames().

dimnames(table_ex)
## [[1]] ## [1] "Female" "Male" ## ## [[2]] ## [1] "PHI" "SEA" "STL" "UNC"
# we see the group labels. Note that each set of group labels in unnamed (blanks next to [[1]] and [[2]]). This is more clearly see by accessing these names explicitly using names() names(dimnames(table_ex))
# Now, let's change these names and see how the table changes names(dimnames(table_ex)) c("Gender", "Site") names(dimnames(table_ex))
## [1] "Gender" "Site"
table_ex
## Site ## Gender PHI SEA STL UNC ## Female 55 67 60 53 ## Male 94 85 85 88
# Now the row and column labels appear, making the table easier to understand

It also common to view these tabulations as percentages. This can be done by using prop.table(), which unlike table() takes in a table object as an argument and not the actual variables of interest. Note that any changes to dimnames that are done to the table object are kept when applying prop.table(). The output from prop.table() is also stored as an object of type table.

# 2 Way Proportion Table prop_table_ex prop.table(table_ex) prop_table_ex
## Site ## Gender PHI SEA STL UNC ## Female 0.09369676 0.11413969 0.10221465 0.09028961 ## Male 0.16013629 0.14480409 0.14480409 0.14991482

A second way of creating contingency tables is using the xtabs() function, which requires the stats package (which is included in R by default, though still load the package using library()). The function xtabs() creates a object of type xtabs and you will notice that the output of both xtabs() and tabel() is nearly identical. xtabs() has the following advantages: 1) row and column labels are included automatically, set to the variable names and 2) there is a data= argument, which means you just have to reference the variable names. With xtabs(), you do not list out the variables of interest separated by commas. Instead you use formula notation, which is ~variable1+variable2+… where variable1 and variable2 are the names of the variables of interest. You can add more then two variables (hence the …). See below for the two-way gender and site example.

library(stats) table_ex_xtabs xtabs(~Gender+Study_Site, data=aosi_data) table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC ## Female 55 67 60 53 ## Male 94 85 85 88

To create a table of proportions using xtab(), you first create the table of counts using xtab(), and then use the prop.table() function on this table object. This is exactly what was done when using table().

One useful function when creating tables is proportions is round(). As seen with the previous table of proportions, R will not round decimals by default. The round() function can be used for all types of R objects. The first argument is the object of values you want to round and the second argument is the number of decimal places to round to.

prop_table_ex_xtabs prop.table(table_ex_xtabs) prop_table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC ## Female 0.09369676 0.11413969 0.10221465 0.09028961 ## Male 0.16013629 0.14480409 0.14480409 0.14991482
prop_table_ex_xtabs round(prop_table_ex_xtabs, 2) prop_table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC ## Female 0.09 0.11 0.10 0.09 ## Male 0.16 0.14 0.14 0.15
prop_table_ex round(prop_table_ex, 2) prop_table_ex
## Site ## Gender PHI SEA STL UNC ## Female 0.09 0.11 0.10 0.09 ## Male 0.16 0.14 0.14 0.15

Lastly, we discuss how to add margin totals to your table. Whether using table() or xtab(), a simple way to add all margin totals to your table is with the function addmargins() from the stats package. Simply add your table or xtab object as the first argument to the addmargins() function, and a new table will be returned which includes these margin totals. This also works with tables of proportions.

table_ex addmargins(table_ex) table_ex_xtabs addmargins(table_ex_xtabs) prop_table_ex addmargins(prop_table_ex) prop_table_ex_xtabs addmargins(prop_table_ex_xtabs) table_ex
## Site ## Gender PHI SEA STL UNC Sum ## Female 55 67 60 53 235 ## Male 94 85 85 88 352 ## Sum 149 152 145 141 587
table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC Sum ## Female 55 67 60 53 235 ## Male 94 85 85 88 352 ## Sum 149 152 145 141 587
prop_table_ex
## Site ## Gender PHI SEA STL UNC Sum ## Female 0.09 0.11 0.10 0.09 0.39 ## Male 0.16 0.14 0.14 0.15 0.59 ## Sum 0.25 0.25 0.24 0.24 0.98
prop_table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC Sum ## Female 0.09 0.11 0.10 0.09 0.39 ## Male 0.16 0.14 0.14 0.15 0.59 ## Sum 0.25 0.25 0.24 0.24 0.98

There are many packages which you can install with more advanced tools for creating and customizing contingency tables. We will cover some in the Chapter 9, though table() and xtabs() should suffice for exploratory analyses.

6.3 Tabular Data Analysis

In this section, we detail some common statistical methods used to analyze contingency table data as well as how to implement these methods in R. These methods are defined and the statistics behind them are explained and then implementation in R is discussed and shown through examples.

6.3.1 Tests for Independence

6.3.2 Defining Independence

Suppose we have two categorical variables, denoted \(X\) and \(Y\) . Denote the joint distribution of \(X\) and \(Y\) by \(f_\) , the distribution of \(X\) by \(f_x\) and the distribution of \(Y\) by \(f_y\) . Denote the distribution of \(X\) conditional on \(Y\) by \(f_\) and the distribution of \(Y\) conditional on \(X\) by \(f_\) .

In statistics, \(X\) and \(Y\) are independent if \(f_=f_*f_\) (i.e., if the distribution of \(X\) and \(Y\) as a pair is equal to the distribution of \(X\) times the the distribution of \(Y\) ). This criteria is the equivalent to \(f_=f_\) and \(f_=f_\) (i.e., if the distribution of \(X\) in the whole population is the same as the distribution of \(X\) in the sub-population defined by specific values of \(Y\) ). As an example, suppose we were interested in seeing if a person voting in an election ( \(X\) ) is independent of their sex at birth ( \(Y\) ). If these variables were independent, we would expect that the percentage of women in the total population is similar to the percentage of women among the people who vote in the election. This matches with our definition of independence in statistics.

6.3.3 Chi-Square Test for Independence

To motivate the concept of testing for independence, let’s consider the AOSI dataset. Let’s see if study site and gender are independent. Recall the contingency table for these variables in the data was the following.

table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC Sum ## Female 55 67 60 53 235 ## Male 94 85 85 88 352 ## Sum 149 152 145 141 587
prop_table_ex_xtabs
## Study_Site ## Gender PHI SEA STL UNC Sum ## Female 0.09 0.11 0.10 0.09 0.39 ## Male 0.16 0.14 0.14 0.15 0.59 ## Sum 0.25 0.25 0.24 0.24 0.98

From our definition of independence, it looks like gender and site are independent based on comparing the counts within each gender and site group as well as the population-level counts. Let’s conduct a formal test to see if there is evidence for independence. First, we cover the Chi-Square test. For all of these tests the null hypothesis is that the variables are independent. Under this null hypothesis, we would expect the following contingency table.

expected_table table_ex_xtabs sex_sums expected_table[,5] site_sums expected_table[3,] expected_table[1,1] 149*(235/587) expected_table[2,1] 149*(352/587) expected_table[1,2] 152*(235/587) expected_table[2,2] 152*(352/587) expected_table[1,3] 145*(235/587) expected_table[2,3] 145*(352/587) expected_table[1,4] 141*(235/587) expected_table[2,4] 141*(352/587) expected_table round(expected_table,2)

Where did these values come from? Take the Philadelphia study site column as an example (labeled PHI). As explained before, under independence, in Philadelphia we would expect the percentage of female participants to be the same as the percentage in the total sample There are 149 participants from Philadelphia, 235 females, and 587 total subjects in the sample. The total sample is about 40% female, so we would expect there to be approximately 0.40*149 or 59.6 females from the Philadelphia site and thus approximately 89.4 males. That is, the expected count is equal to (row total*column total)/sample size. All entries are calculated using this equation. Let’s look at the differences between the counts from the AOSI data and the expected counts.

expected_table[-3,-5]-table_ex_xtabs[-3,-5]
## Study_Site ## Gender PHI SEA STL UNC ## Female 4.65 -6.15 -1.95 3.45 ## Male -4.65 6.15 1.95 -3.45

We can see that the differences are small considering the study site margins, so it there no evidence to suggest dependence. However, let’s do this more rigorously using a formal hypothesis test. For any hypothesis test, we create a test statistic and then calculate a p-value from this test statistic. Informally, the p-value measures the probability you would observe a test statistic value as or more extreme then the value observed in the dataset if the null hypothesis is true. For the Chi-Square test, the test statistic is equal to the sum of the squared differences between the observed and expected counts, divided by the expected counts. The distribution of this test statistic is approximately Chi-Square with \((r-1)\*(c-1)\) degrees of freedom, where \(r\) is the number of row categories and \(c\) is the number of column categories. The approximation becomes more accurate as the large size grows larger and larger (to infinity). Thus, if the sample size is “large enough”, we can accurately approximate the test statistics distribution with this Chi-Square distribution. This is what is referred to by “large sample” or “asymptotic” statistics. Let’s conduct the Chi-Square test on AOSI dataset. This is done by using summary() with the contingency table object (created by table() or xtab()). Note that you cannot have the row and column margins in the table object when conducting this Chi-Square test, as R will consider these marginals are row and column categories.

table_ex_xtabs xtabs(~Gender+Study_Site, data=aosi_data) summary(table_ex_xtabs)
## Call: xtabs(formula = ~Gender + Study_Site, data = aosi_data) ## Number of cases in table: 587 ## Number of factors: 2 ## Test for independence of all factors: ## Chisq = 2.1011, df = 3, p-value = 0.5517

We see that the p-value is 0.55, which is very large and under a threshold of 0.05 is far from significance. Thus, we do not have evidence to reject the null hypothesis that gender and study site are independent.

6.3.4 Fisher’s Exact Test

An alternative to the Chi-Square test is Fisher’s Exact Test. This hypothesis test has the same null and alternative hypothesis as the Chi-Square test. However, its test statistic has a known distribution for any finite sample size. Thus, no distributional approximation is required, unlike the Chi-Square test and thus it produces accurate p-values for any sample size. To conduct Fisher’s Exact Test, use the function fisher.test() from the stats package with the table or xtab object. The drawback to Fisher’s Exact Test is that it has a high computation time if the data has a large sample size; in that case, the approximation from the Chi-Square is likely accurate and this testing procedure should be used. Let’s run Fisher’s Exact Test on the gender by site contingency table.

fisher.test(table_ex_xtabs)
## ## Fisher's Exact Test for Count Data ## ## data: table_ex_xtabs ## p-value = 0.553 ## alternative hypothesis: two.sided

Due to large sample size, we see that the p-value is very close to the p-value from the Chi-Square test, as expected.