Need Help : group_by and summarize_each

Welcome to R! I started using it two years ago for much the same reason after my data got too big for Excel to handle. It sounds like you're experimenting with dplyr, which is a great tool for data wrangling. There are some great tutorials out there, including:

You might get help sooner if you can provide some clarification.

  • You mention grouping, but I don't see any grouping happening in any of your code. In dplyr that's typically done with a group_by(....). Summarize and its variants, like summarize_each, collapse the rows of data they see into a single summary statistic. If you use group_by first, they will summarize each group, but if there's no grouping, it would summarize the whole data frame.
  • What is the question you are trying to answer? It looks like you're trying to sum some columns that are Chr (character) -- that seems impossible so I presume you mean something else.
  • What does your data in REPORT2 look like? Could you share a sample or some fake data that uses the same kinds of data?
    FAQ: What's a reproducible example (`reprex`) and how do I create one?