Here is the code with explanations and improvements.

Extracting Last Three Digits from a Unique Code in Each Row with Tidyverse Only

Working with Raster Data in Tidy and Dplyr: A Streamlined Approach to Spatial Analysis