DPLYR not recognizing a column that is in my dataframe

[jordan.howell2]

Hello. I'm using dplyr to summarise a larger data frame. I get an error that states `Error in group_by(RATING_CLASS_CODE): object 'RATING_CLASS_CODE' not found.

Here is the code I'm using:

class_comp <- mc_lr_segments_q22018 %>%
  select(RATING_CLASS_CODE)
  group_by(RATING_CLASS_CODE) %>%
  summarise(sum(earned), sum(incurred))

EDIT: I figured out why. I would delete but I don't have permission to. I forgot the pipe operator. Here is the code that worked:

class_comp <- mc_lr_segments_q22018 %>%
  select(RATING_CLASS_CODE) **%>%**
  group_by(RATING_CLASS_CODE) %>%
  summarise(sum(earned), sum(incurred))

[mara]

Could you please turn this into a self-contained reprex (short for reproducible example)? It will help us help you if we can be sure we're all working with/looking at the same stuff.

install.reprex("reprex")

If you've never heard of a reprex before, you might want to start by reading the tidyverse.org help page. The reprex dos and don'ts are also useful.

What to do if you run into clipboard problems

If you run into problems with access to your clipboard, you can specify an outfile for the reprex, and then copy and paste the contents into the forum.

reprex::reprex(input = "fruits_stringdist.R", outfile = "fruits_stringdist.md")

For pointers specific to the community site, check out the reprex FAQ, linked to below.

[jordan.howell2]

Hi Mara. I apologize. I just figured out why and WHILE I'm embarrassed, it has to do with a missing pipe operator after the select statement. So much for my first question on the community being a good one.

[mara]

No worries!

If your question's been answered (even if by you), would you mind choosing a solution? (See FAQ below for how).

Having questions checked as resolved makes it a bit easier to navigate the site visually and see which threads still need help.

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

Thanks

[jcblum]

@jordan.howell2

So much for my first question on the community being a good one.

Consider it a test run You’ve even gotten a reprex nudge, so now you know how to make your next question super awesome!