Exercise: Cleaning NYC Property Sales
Understand how to clean a real NYC property sales dataset by transforming borough codes, removing missing sale prices, eliminating duplicates, and filtering outliers. This lesson guides you through practical Python functions to prepare data for meaningful analysis.
We'll cover the following...
We'll cover the following...
NYC Property Sales
In this lesson, you are going to clean the NYC Property Sales Dataset. This dataset is a record of every building or building unit (apartment, etc.) sold in the New York City property market over a 12-month period.
In the below exercises, you will be writing functions for every task. The functions will receive a dataframe df as an input argument. Your task will be to perform the required operations and return the dataframe.
1. Change values
In the BOROUGH column, the values range from ...