Applying Weighted Mean Across DataFrame While Retaining Information from Dropped Factor Columns

Understanding the Issue with `group_by` and `mutate(mean)` in R: How to Correctly Calculate Group Means While Ignoring Missing Values