Expires in:


Estimate the Estate
Your dataset contains property sales for one-family dwellings in Manhattan over the last 12 months, including each property's zip code, building class, square feet, and sale price. However, records have have a sale price of $0 whenever there was a transfer of ownership without a cash consideration (like from parents to children).
Your task is create a new market value column that uses the recorded sale price when available, or estimates it by using the average price per square foot from properties within the same zip code and building class.
See example below:

BONUS: Can you impute by scraping the real market values from the internet based on each address?
Submit your solution
After imputing, how many total properties have an estimated market value greater than $15 million?
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors



