Using Summarize Within Mutate Instead of Left Join in R

Understanding Negating Functions in R: Advanced Filtering Techniques with `is.numeric`

Transforming Data from Long to Wide Format using tidyr in R

Here is the code with explanations and improvements.