Selecting only numeric columns from a data frame

by

EDIT: updated to avoid use of ill-advised sapply.

Since a data frame is a list we can use the list-apply functions:

nums <- unlist(lapply(x, is.numeric), use.names = FALSE)

Then standard subsetting

x[ , nums]

## don't use sapply, even though it's less code
## nums <- sapply(x, is.numeric)

For a more idiomatic modern R I’d now recommend

x[ , purrr::map_lgl(x, is.numeric)]

Less codey, less reflecting R’s particular quirks, and more straightforward, and robust to use on database-back-ended tibbles:

dplyr::select_if(x, is.numeric)

Newer versions of dplyr, also support the following syntax:

x %>% dplyr::select(where(is.numeric))

More Related Contents:

  1. How to make plots from distributed data from R
  2. Rcpp package doesn’t include Rcpp_precious_remove
  3. Formatting dates with scale_x_date in ggplot2
  4. Append an object to a list in R in amortized constant time, O(1)?
  5. Concatenate unique strings after groupby in R
  6. Generate an incrementally increasing sequence like 112123123412345
  7. Extract rows for the first occurrence of a variable in a data frame
  8. Disable messages upon loading a package
  9. Evaluating both column name and the target value within `j` expression within `data.table`
  10. Mean of each element of a list of matrices
  11. R apply function with multiple parameters
  12. Printing newlines with print() in R
  13. data.table and parallel computing
  14. Making a stacked area plot using ggplot2
  15. Convert string to date, format: “dd.mm.yyyy”
  16. Seeking workaround for gtable_add_grob code broken by ggplot 2.2.0
  17. Perform multiple paired t-tests based on groups/categories
  18. What is about the first column in R’s dataset mtcars?
  19. R – ggplot2 issues with date as character for x-axis
  20. Using If/Else on a data frame
  21. dplyr / R cumulative sum with reset
  22. ggplot2: Setting geom_bar baseline to 1 instead of zero
  23. Remove ‘search’ option but leave ‘search columns’ option
  24. Plot background colour in gradient
  25. Plotting multiple graphs in R [closed]
  26. Changing format of some axis labels in ggplot2 according to condition [duplicate]
  27. What does the period mean when used with ~ (in a formula)?
  28. Add axis tick-marks on top and to the right to a ggplot?
  29. heatmap-like plot, but for categorical variables
  30. data.table: anonymous function in j

Leave a Comment