I was wondering, is there a smarter way to approach Missing Value as opposed to just calculating the mean for the entire column.
I want to be able to calculate the mean based on other columns, for example;
For example, I have two columns, Sex and Score. I have missing values in my score column. Can I fill the missing values in by calculate the mean for Female and Male respectively as opposed the mean for both sexes or do I need to Ungroup and calculate for each column and then Group them back together?