Home Work of Dplyr (Rstudio) – savvyessaywriters.net | Savvy Essay Writers
Home Work of Dplyr (Rstudio) – savvyessaywriters.net | Savvy Essay Writers
Savvy Essay Writers Business & Finance Assignment Help
# Use package dplyr to explore WestRoxbury real estate datasetd = read.csv(“WestRoxbury.csv”)View(d)# Questions# 1) Filter the data to show only houses whose total value# is greater than 350 (thousand), less than 20 years of age,# and tax is less than 5000. HINT: use Mutate to calculate# age of the house as of 2020.# 2) Sort the dataset by (age, total value), then show# only age, total value, lot sqft, and rooms. Assign entire# output to a variable named sortedD. Now using standard base R, show only# first 10 rows of sortedD.# 3) A potential buyer is looking for a house which will have at least 8 rooms,# in exactly one floor, have a fireplace, and built in between 1970 and 1990.# Arrange these houses sorted by total value.# Finally, assign the result to a new variable named custList.# View custList.# 4) Summarize the dataset by first grouping on age, then calculate# count of each group, mean, min, and max of total value. Then,# order the resulting output (in descending order) by count. Finally, assign the result# to a new variable named groupedD.# View groupedD.