Sum of unique values in column.

[BenWade]

Hi everyone.

Let's say, I have a column 'Model' and 3 values: Basic, Premium and Lux. How to sum distinct each type of model? I want to group by Model.
I believe I have to use group by, summarise and n_distinct functions, right? but how to use them properly I do not know.

[scottyd22]

Here are a couple ways to accomplish a distinct sum of each type of model.

Using the approach you described...

d = data.frame(model =c(rep('Basic', 7), rep('Premium', 4), rep('Lux', 11)))

d |>
  group_by(model) |>
  summarise(n = n()) |>
  ungroup()

You could also use the count() function to achieve the same result.

count(d, model)

[BenWade]

@scottyd22 thank you for your quick response
i used this code and it worked perfectly

hotel_bookings %>%
group_by(distribution_channel) %>%
count(distribution_channel)

[scottyd22]

Excllent! One thing to note in your example is that when you use count(), you don't even need the group_by() line, thus making it even more succinct.