Dear RStudio Community,
Here is a look of my data structure:
What I need to do: "show and comment for each year from 1995 (included):
the name of the movie with the highest total gross and the value of this gross"
For so far, what I can do is:
mayor_recaudacion <- movies_century %>%
select(Released, Movie, Worldwide_Gross) %>%
summarize(max = max(Worldwide_Gross))
Which results look like that:
So I need to return the corresponding Movie name for each max Gross found, in the same table but I don't know how to compute it.
Any ideas ? Don't hesitate to ask for clarification if my request is not clear!