Sorting columns and counting

[Soraya]

Hallo,

I have a dataset with videogames.
I have a column with 12 different type of genre, and i have a column with EU_sales.

I want to know how much EU_sales te music genre has.

So i tired this one:

music <- videogames %>%
filter (Genre == 'Misc' 'EU_Sales') %>%
count ()

But i have a error with: Error in group_vars(x) : argument "x" is missing, with no default

can anyone please help me?

[siddharthprabhu]

filter() operates on rows, not columns. So you'll probably need to reshape your data first. Would it be possible for you to prepare a minimal reproducible example of the videogames data set. See the guide below for instructions.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

[Soraya]

[siddharthprabhu]

OK, I misunderstood your description of the data set. Since your genres are already in rows, you can just do something like this.

videogames %>%
  filter(Genre == "Misc") %>%
  summarise(Total_EU_Sales = sum(EU_Sales))

[Soraya]

thank you so much for helping me !