(a) Combine the two datasets with house features to obtain a single…

Question Answered step-by-step (a) Combine the two datasets with house features to obtain a single… (a) Combine the two datasets with house features to obtain a single dataset containing features for all the houses in Ames. What is the number of observations in the combined dataset? (b) Reshape the dataset obtained in the previous question to the House_Id level, i.e., all the information for a house must be contained in a single observation. Excluding House_Id, how many columns do you have in the reshaped dataset? Use pivot().(c) Combine the dataset obtained in the previous question with House prices data, so that you obtain the price and features of each house as a single observation. What is the number of observations in the combined dataset?(i) If you used pivot() in the previous question, reset the index on the dataframe in-place so that House_Id becomes a column.(ii) Merge the resulting dataframe with the price dataframe.(d) Which neighborhood has the highest variance of sale price?(e) Which neighborhood has the highest correlation between GrLivArea (ground living area) and SalePrice? Ignore the neighborhood with 10 or less observations(i) Use groupby().filter() to remove neighborhood with 10 or less observations. (ii) Use groupby().apply(lambda f:n) to find correlation, followed by using sort_values.    (f) The variable OverallQual rates the material and finish of the house. The ratings are given by integers from 1 to 10: 1 being poor and 10 being excellent. Make a dataframe that shows the median sale prices of houses receiving an OverallQual score 2, score 5, and score 7. House Feature 1. https://docs.google.com/spreadsheets/d/1dG2Oqy6cSOGGwXVxMjMK5GXMU8EqBuqlx_OGxR1O3mA/edit?usp=sharing2. https://docs.google.com/spreadsheets/d/1QBP6FasG_WoYG9w28Bz1uGBiYZGpoHm0mYfrrA6pczs/edit?usp=sharing House Pricehttps://docs.google.com/spreadsheets/d/1rLNhZb3NQnq0qEWIJCyyFoIYfrc75N_JdX-woQl4QnI/edit?usp=sharing  Computer Science Engineering & Technology Python Programming CS 142 Share QuestionEmailCopy link Comments (0)