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 %>%
group_by(Released) %>%
filter(Released>=1995) %>%
select(Released, Movie, Worldwide_Gross) %>%
summarize(max = max(Worldwide_Gross))
Which results look like that:
Released max
-
"1995" "366101666"
-
"1996" "817400878"
-
"1997" "139801096"
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!
Thank you!