Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I used jupytor notebook in anaconda import pandas as pd # Load data housing _ df = pd . read _ csv ( WestRoxbury

I used jupytor notebook in anaconda
import pandas as pd
# Load data
housing_df = pd.read_csv("WestRoxbury.csv")
housing_df.shape
housing_df.head()
print(housing_df) #show all the data
I need answers for
Try to implement the available code in your lecture.
LAB Q. Use provided data, and write Python functions (or just code) that do one of the following:
1. Write a function to find the highest house price in the dataset.
2. Write a function to calculate the average square footage of the living area.
3. Write a function to count the number of houses with exactly 5 bedrooms.
4. Write a function to find the median value of the 'year_built' column.
5. Write a function to identify the top 5 neighborhoods with the highest average house prices.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

Understand scientific fraud and how to avoid plagiarism

Answered: 1 week ago

Question

4. Label problematic uses of language and their remedies

Answered: 1 week ago