Data for Coding Exercises
The next six exercises will be based on the Airbnb rental data below.
Copy and run the code from the yellow box.
The code above creates four tables:
The HOST table contains the information about a list of Airbnb hosts. It contains data such as the host’s name, ID, property, age and income.
The PROPERTY table contains the information about the properties on the Airbnb listings. It has each property’s neighborhood, number of bedrooms and price per night.
RENTALDATA is the largest table among the four. It has the rental data for the month of January in 2016.
The GUEST table contains the information about the guests who rented a property during the month of January in the Toronto area.
Review each table carefully and understand how the data is stored in each table.