Fix explicit missings using fill()
One type of missing value that can be obvious to deal with is where the first entry of a group is given, but subsequent entries are marked NA
.
These missing values often result from empty values in spreadsheets to avoid entering multiple names multiple times; as well as for "human readability".
This type of problem can be solved by using the fill()
function from the tidyr
package.
This exercise is part of the course
Dealing With Missing Data in R
Exercise instructions
- Use
fill()
to fill down the "name" observations in thefrogger
dataset.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Print the frogger data to have a look at it
___
# Use `fill()` to fill down the name variable in the frogger dataset
___ %>% fill(___)