1. Learn
  2. /
  3. Courses
  4. /
  5. Joining Data with dplyr

Exercise

Cleaning up your count

In both left and right joins, there is the opportunity for there to be NA values in the resulting table. Fortunately, the replace_na function can turn those NAs into meaningful values.

In the last exercise, we saw that the n column had NAs after the right_join. Let's use the replace_na column, which takes a list of column names and the values with which NAs should be replaced, to clean up our table.

Instructions

100 XP
  • Use replace_na to replace NAs in the n column with the value 0.