How to center data into a new column but only for specific conditions based on other columns?
Hi all, I want to center my data. But the problem is I only want to adjust the data with an average of it's respective category. For example, see table below. What if in the "age adjusted" col, I want the age column data but subtracted by the average of only the age data that has the same "city" and "gender" category? So each age for "san francisco" and "male" would be subtracted by average of 1,2...