Hi there!

I have household-level data with unique household_id. For each household, I have data for village_id and income, among other variables.

Is there any way I can create a new variable called village_income_mean by averaging the income amounts across a village given by village_id?

Thanks!