Count non-NA values by group [duplicate]

by

You can use this

mydf %>% group_by(col_1) %>% summarise(non_na_count = sum(!is.na(col_2)))

# A tibble: 2 x 2
   col_1 non_na_count
  <fctr>        <int>
1      A            1
2      B            2

More Related Contents:

  1. Relative frequencies / proportions with dplyr
  2. How to number/label data-table by group-number from group_by?
  3. Finding percentage in a sub-group using group_by and summarise
  4. Count number of rows by group using dplyr
  5. dplyr issues when using group_by(multiple variables)
  6. Add a column with count of NAs and Mean
  7. dplyr – groupby on multiple columns using variable names
  8. How to replace empty string with NA in R dataframe?
  9. Filtering rows in R unexpectedly removes NAs when using subset or dplyr::filter
  10. How can I count the number of NAs per group?
  11. Replace values greater than zero with 1 in r
  12. How does one access the piped data.frame in dplyr::funs?
  13. Extract row corresponding to minimum value of a variable by group
  14. How to select the rows with maximum values in each group with dplyr? [duplicate]
  15. Filter multiple values on a string column in dplyr
  16. What does %>% function mean in R?
  17. aggregate methods treat missing values (NA) differently
  18. dplyr: how to reference columns by column index rather than column name using mutate?
  19. How to delete columns that contain ONLY NAs?
  20. Merge rows in a dataframe where the rows are disjoint and contain NAs
  21. Reshape from long to wide and create columns with binary value
  22. Find the most frequent value by row
  23. Randomly insert NAs into dataframe proportionaly
  24. Can dplyr join on multiple columns or composite key?
  25. Replace a value NA with the value from another column in R
  26. Apply a ggplot-function per group with dplyr and set title per group
  27. How to group by two columns in R
  28. Count unique values for every column
  29. Count number of non-NA values by group
  30. Override column types when importing data using readr::read_csv() when there are many columns

Leave a Comment