This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Data Analyst at Zillow. In the properties table, some properties have an hoa_fee of 0.0. A value of zero does not mean the HOA fee is free — it means the data was not collected. Your task is to treat these zero values as missing, then fill them with the median HOA fee calculated from properties that do have a known (non-zero) fee. This produces a cleaner dataset for downstream pricing models.
You are a Data Analyst at Zillow. In the properties table, some properties have an hoa_fee of 0.0. A value of zero does not mean the HOA fee is free — it means the data was not collected. Your task is to treat these zero values as missing, then fill them with the median HOA fee calculated from properties that do have a known (non-zero) fee. This produces a cleaner dataset for downstream pricing models.