Using ratios to describe the frequency of a name
In the video, you learned how to find the difference in the frequency of a baby name between consecutive years. What if instead of finding the difference, you wanted to find the ratio?
You'll start with the babynames_fraction data already, so that you can consider the popularity of each name within each year.
This exercise is part of the course
Data Manipulation with dplyr
Exercise instructions
- Arrange the data in ascending order of name and then year.
- Group by name so that your mutate works within each name.
- Add a column
ratiocontaining the ratio (not difference) offractionbetween each year.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
babynames_fraction %>%
# Arrange the data in order of name, then year
___
# Group the data by name
___
# Add a ratio column that contains the ratio of fraction between each year
___