Create frequency tables for multiple factor columns in R

by

You were nearly there. Just one small change in your function would have got you there. The x in function(x) ... needs to be passed through to the table() call:

levs <- c("Not Impt at all", "Somewhat Impt", "Neutral", "Impt", "Very Impt")
sapply(x.sample, function(x) table(factor(x, levels=levs, ordered=TRUE)))

A little re-jig of the code might make it a bit easier to read too:

sapply(lapply(x.sample,factor,levels=levs,ordered=TRUE), table)

#                Q9_A Q9_B Q9_C
#Not Impt at all    3    4    4
#Somewhat Impt      0    0    0
#Neutral            0    0    0
#Impt               1    0    0
#Very Impt          6    6    6

More Related Contents:

  1. Grouping functions (tapply, by, aggregate) and the *apply family
  2. Drop unused factor levels in a subsetted data frame
  3. Cleaning up factor levels (collapsing multiple levels/labels)
  4. Coerce multiple columns to factors at once
  5. Concatenate row-wise across specific columns of dataframe
  6. Confusion between factor levels and factor labels
  7. Replacing numbers within a range with a factor [duplicate]
  8. Apply a function to every row of a matrix or a data frame
  9. Means multiple columns by multiple groups [duplicate]
  10. Colouring plot by factor in R
  11. Plotting with ggplot2: “Error: Discrete value supplied to continuous scale” on categorical y-axis
  12. Why does as.factor return a character when used inside apply?
  13. How to concatenate factors, without them being converted to integer level?
  14. How to change order of boxplots when using ggplot2?
  15. R error “sum not meaningful for factors”
  16. Factors in R: more than an annoyance?
  17. Idiom for ifelse-style recoding for multiple categories
  18. Directly creating dummy variable set in a sparse matrix in R
  19. Imported a csv-dataset to R but the values becomes factors
  20. Concatenate rows of a data frame
  21. Why use as.factor() instead of just factor()
  22. Convert Factor to Date/Time in R
  23. Apply function to each column in a data frame observing each columns existing data type
  24. Add a prefix to column names
  25. ggplot2 plot without axes, legends, etc
  26. Remove facet_wrap labels completely
  27. How to automatically adjust the width of each facet for facet_wrap?
  28. Calculate mean across rows with NA values in R
  29. Convert numeric to date
  30. How to combine two lists in R

Leave a Comment