Vacation Rental Listings and Reviews Analysis

Company: Turing_21oct

Difficulty: medium

Problem Statement

Vacation Rental Listings and Reviews Analysis Problem You are given a dataset of vacation rental listings in a city and the guest reviews of those listings. Answer the seven analysis questions below about it. Listings : one row per listing, with attributes of the listing and of its host. Reviews : one row per guest review of a listing in the Listings table, with the date of the review. Implement solve(listings_df, reviews_df) . It receives both tables as pandas DataFrames and returns a list of the 7 answers in task order. (inferred -- the original assessment used seven separate task files with fixed method signatures; here one function returns all seven answers so that one program can be judged on standard input and output.) Wherever a task uses a column, rows where that column is missing (an empty field) are ignored for that task only. (inferred) Task 1: Neighbourhood price difference Use host_is_superhost , neighbourhood_cleansed and price . For every neighbourhood that has at least