Importing and joining the accident data

It's the final chapter! Congratulations on making it this far. This chapter's scenario is that a senior executive believes that workplace accidents have increased this past year at the production sites. She wants you to find out if that's true, and if it is, to look into what might be driving the increase.

Start by importing the HR and accident datasets. Then join them together, and add a had_accident variable to make it easier to analyze accident rates.

Import "hr_data_2.csv" and "accident_data.csv" with read_csv(). Assign them to hr_data and accident_data, respectively.
Use left_join() to add the accident data to the HR data. Join on both employee ID and year.
Using %>% after the join, use mutate() to add had_accident, which is 0 when accident_type is NA, and 1 otherwise.

Exercise

Importing and joining the accident data

Instructions