Crunch supports more types of variables than many of the data formats from which you can create datasets. Plain-text .csv files, for example, can’t express that some columns are actually indicator matrices of multiple selections (Multiple Response Variables). Most SPSS .sav files do not indicate Categorical Arrays (otherwise known as “grids”) as being part of a group—they are simply several categorical variables. The same is true for an R data.frame.
You can use crunch to “bind” categorical variables into Multiple Response and Categorical Array variables.
One of the reasons to use R with Crunch is to leverage the power of scripting for tasks that would be repetitive in a GUI. Many crunch functions operating on Crunch datasets have an optional pattern argument that lets you use regular expressions for these “bulk” operations.
In our sample Economist dataset, we have set of variables prefixed with “imiss”:
## [1] "imiss_b" "imiss_c" "imiss_d" "imiss_f" "imiss_g" "imiss_h" "imiss_j" "imiss_m" "imiss_p" "imiss_q" "imiss_r"
## [12] "imiss_s" "imiss_t"These correspond to a survey grid question about how important respondents view a set of issues. Examining one of them, we see
## imiss_b (categorical)
##
## Count
## Very Important 196
## Somewhat Important 44
## Not very Important 8
## Unimportant 1All of these “imiss” categorical variables have the same structure. We can combine them into a categorical array variable with makeArray:
## Issue importance (categorical_array)
## Subvariables:
## $`imiss_b`
## $`imiss_c`
## $`imiss_d`
## $`imiss_f`
## $`imiss_g`
## $`imiss_h`
## $`imiss_j`
## $`imiss_m`
## $`imiss_p`
## $`imiss_q`
## $`imiss_r`
## $`imiss_s`
## $`imiss_t`The set of “important issue” variables have gone from thirteen separate categorical variable cards to just one, where the subvariables are shown as rows, and the common categories across all of them are shown as columns.
In our example dataset, the categorical variables imiss_* are now not visible in the dataset directly, but we can access them as “subvariables” of the array we just created.
## Subvariables:
## $`imiss_b`
## $`imiss_c`
## $`imiss_d`
## $`imiss_f`
## $`imiss_g`
## $`imiss_h`
## $`imiss_j`
## $`imiss_m`
## $`imiss_p`
## $`imiss_q`
## $`imiss_r`
## $`imiss_s`
## $`imiss_t`We can also step into the subvariables and access the underlying categorical variables:
## imiss_b (categorical)
##
## Count
## Very Important 196
## Somewhat Important 44
## Not very Important 8
## Unimportant 1The names imiss_b through imiss_t are unsatisfying from a human-readability perspective: you can’t tell which political issues correspond to the variables. Unfortunately, we didn’t have additional metadata on these survey questions in the data.frame we imported initially. However, we can rectify this.
Subvariables have methods similar to those for categories. They have a names attribute that we can get:
## [1] "imiss_b" "imiss_c" "imiss_d" "imiss_f" "imiss_g" "imiss_h" "imiss_j" "imiss_m" "imiss_p" "imiss_q" "imiss_r"
## [12] "imiss_s" "imiss_t"We can set it, too:
names(subvariables(ds$imiss)) <- c("The economy", "Immigration",
"The environment", "Terrorism", "Gay rights", "Education",
"Health care", "Social security", "The budget deficit",
"The war in Afghanistan", "Taxes", "Medicare", "Abortion")
subvariables(ds$imiss)## Subvariables:
## $`The economy`
## $`Immigration`
## $`The environment`
## $`Terrorism`
## $`Gay rights`
## $`Education`
## $`Health care`
## $`Social security`
## $`The budget deficit`
## $`The war in Afghanistan`
## $`Taxes`
## $`Medicare`
## $`Abortion`Another useful thing we can do with array subvariables is reorder them. Let’s alphabetize the subvariables:
sorting <- order(names(subvariables(ds$imiss)))
subvariables(ds$imiss) <- subvariables(ds$imiss)[sorting]
subvariables(ds$imiss)## Subvariables:
## $`Abortion`
## $`Education`
## $`Gay rights`
## $`Health care`
## $`Immigration`
## $`Medicare`
## $`Social security`
## $`Taxes`
## $`Terrorism`
## $`The budget deficit`
## $`The economy`
## $`The environment`
## $`The war in Afghanistan`Just as we created a categorical array, we can create a multiple response variable. Like categorical arrays, multiple responses contain a set of subvariables, categorical variables with a common list of categories. However, the subvariables in a multiple response are treated as dichotomous indicators. We specify one or more categories that indicate “selected” versus “not selected”. Hence, when a multiple response appears in the web app, it looks like a single categorical variable, each subvariable shown like a category. Unlike a categorical variable, though, the multiple responses are not mutually exclusive, so tabulations with them may not sum to 100 percent.
In the Economist dataset, we have another set of parallel categorical variables, “boap”, which indicate approval of President Obama on a range of issues.
## boap_4 (categorical)
##
## Count
## Somewhat approve 68
## Strongly disapprove 67
## No opinion 46
## Somewhat disapprove 43
## Strongly approve 26In the questionnaire that collected this data, “boap” appeared as a grid question, just as “imiss” did. But, for illustration purposes—and to show how you can convert between categorical array and multiple response—let’s treat this as multiple response.
The function makeMR works like makeArray but with an additional argument, “selections”, in which you specify the category name(s) that identify which category or categories should be the dichotomous indicator.
ds$boap <- makeMR(ds[grep("^boap_[0-9]+", names(ds))],
name="Approval of Obama on issues",
selections=c("Strongly approve", "Somewhat approve"))
ds$boap## Approval of Obama on issues (multiple_response)
## Subvariables:
## $`boap_2`
## $`boap_3`
## $`boap_4`
## $`boap_5`
## $`boap_6`
## $`boap_7`
## $`boap_8`
## $`boap_9`
## $`boap_10`
## $`boap_11`
## $`boap_12`
## $`boap_13`
## $`boap_14`Multiple response variables can be thought of as categorical arrays that have extra metadata indicating which categories are “selected”. This metadata can be manipulated, and we can thus transform categorical arrays into multiple response and vice versa.
The function undichotomize removes the dichotomization metadata:
## Approval of Obama on issues (categorical_array)
## Subvariables:
## $`boap_2`
## $`boap_3`
## $`boap_4`
## $`boap_5`
## $`boap_6`
## $`boap_7`
## $`boap_8`
## $`boap_9`
## $`boap_10`
## $`boap_11`
## $`boap_12`
## $`boap_13`
## $`boap_14`We can add that information with dichotomize. Taking our categorical array “boap,” let’s make it into a multiple response, but this time, let’s only include the “Strongly approve” category:
## Approval of Obama on issues (multiple_response)
## Subvariables:
## $`boap_2`
## $`boap_3`
## $`boap_4`
## $`boap_5`
## $`boap_6`
## $`boap_7`
## $`boap_8`
## $`boap_9`
## $`boap_10`
## $`boap_11`
## $`boap_12`
## $`boap_13`
## $`boap_14`As noted above, when we make an array, its subvariables no longer appear in the dataset outside of the array.
## [1] "boap"We can access the subvariables and do things with them directly via the subvariables method, but the case may arise in which we want to undo our binding of these subvariables into the array. The function unbind deletes the array variable and restores the subvariables as top-level variables.
Note the use of refresh. Most functions that modify objects on the server refresh their local copies in our R session automatically; however, because unbind doesn’t assign back into ds, the local dataset object doesn’t get updated with the change, so we need to refresh it manually.
Now, if we check the names of ds, we see our full set of boap_* former subvariables:
## [1] "boap_2" "boap_3" "boap_4" "boap_5" "boap_6" "boap_7" "boap_8" "boap_9" "boap_10" "boap_11" "boap_12"
## [12] "boap_13" "boap_14"