aggregate methods treat missing values (NA) differently

by

Good question, but in my opinion, this shouldn’t have caused a major debugging headache because it is documented quite clearly in multiple places in the manual page for aggregate.

First, in the usage section:

## S3 method for class 'formula'
aggregate(formula, data, FUN, ...,
          subset, na.action = na.omit)

Later, in the description:

na.action: a function which indicates what should happen when the data contain NA values. The default is to ignore missing values in the given variables.

I can’t answer why the formula mode was written differently—that’s something the function authors would have to answer—but using the above information, you can probably use the following:

aggregate(.~Name, M, FUN=sum, na.rm=TRUE, na.action=NULL)
#   Name Col1 Col2
# 1 name    1    2

More Related Contents:

  1. Collapsing rows where some are all NA, others are disjoint with some NAs
  2. How can I count the number of NAs per group?
  3. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  4. Collapse / concatenate / aggregate a column to a single comma separated string within each group
  5. Extract row corresponding to minimum value of a variable by group
  6. Group by multiple columns and sum other multiple columns
  7. Select the first and last row by group in a data frame
  8. Replacing character values with NA in a data frame
  9. Apply function conditionally
  10. How to replace NA values in a table for selected columns
  11. How to delete rows from a dataframe that contain n*NA
  12. Compute mean and standard deviation by group for multiple variables in a data.frame
  13. How to avoid warning when introducing NAs by coercion
  14. Remove columns from dataframe where some of values are NA
  15. How to subset data in R without losing NA rows?
  16. Group integer vector into consecutive runs
  17. How to delete columns that contain ONLY NAs?
  18. Randomly insert NAs into dataframe proportionaly
  19. Apply several summary functions (sum, mean, etc.) on several variables by group in one call
  20. Aggregate data in R
  21. Replace a value NA with the value from another column in R
  22. Replace in a factor column
  23. Counting non NAs in a data frame; getting answer as a vector
  24. R use ddply or aggregate
  25. R: replacing NAs in a data.frame with values in the same position in another dataframe
  26. Run a custom function on a data frame in R, by group
  27. Aggregating all unique values of each column of data frame
  28. Move NAs to the end of each column in a data frame
  29. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  30. Add a box for the NA values to the ggplot legend for a continuous map

Leave a Comment