Filter the data to include only residential real estate of your neighborhood. Gr

Filter the data to include only residential real estate of your neighborhood. Group it by year, and summarize the data to show the average price of 1 square foot of real estate. List the results.
1. Do numbers show for all years? If a year shows N/A, why is that happening?
2. Filter your data to focus on residential real estate with adequate information for your model (remove fields with 0 for price or square feet)
3.Group the filtered data by year, and summarize the data to show the average price of 1 square foot of real estate. List the results.
4.Compare your selected neighborhood with 2 nearby neighborhoods. List the numbers.
5.Produce a plot that compares the neighborhoods. Explain the plot and the reason you chose that type of plot.