1-Background
2-Purpose and Proposed Visualization Strategies
3-Data Source
4-Dataset and Variables
5-ETL process
6-Technologies used in the project
7-Website with Visualization
8-home
9-Dashboard
10- Maps
11-Chart
12-About
Since its inception in 2008, Airbnb has disrupted the travel industry. Today tourists have begun to prefer accommodations that resemble their own home (e.g., multiple bedrooms, stove, grill, and private parking). In most cases, these locations are preferred over that of a traditional hotel.
The purpose of this project was to tell a story of Airbnb accommodations using data visualizations. Here, we propose to use visualizations to graphically display different filters based on price points, cities, and room types. In addition, we propose to use both plotly heatmap and cluster graphing strategies to display bookings that may differ by price points, cities, and room type.
Overall, these data allow potential travelers to identify high-value locations at the right price point.
The Airbnb data were downloaded from kaggle. These data were compiled by Kritik Seth, an inspiring data scientist from Mumbai, India. The data was compiled from multiple Airbnb datasets in October of 2020. We downloaded it as CSV data file and converted it into a JSON format.
The original datasets were such a large. it was over 34 KB. After cleaning we have little more than 10 KB. Varaibles such as Id, name, host_id and some states are not longer available in our dataset.
-
id: Unique Listing ID
-
name: Name of Listing
-
host_id: Unique host ID
-
host_name: Name of host
-
neighborhood_group: Group in which the neighborhood lies
-
neighborhood: name of neighborhood
-
latitude: Latitude of listing
-
longitude: Longitude of listing
-
room_type: room type
-
price: price of listing per night
-
minimum_nights: Minimum number of nights required to book
-
number_of_reviews: Total number of reviews on listing
-
last_review: Date on which listing received its last review
-
reviews_per_month: Average reviews pr month on listing
-
calculated_host_listings_count: Total number of listings by host
With jupyter notbook, clean our data.our final data had over 218, 000 unique rows and 17columns. we start by dropping id,name, host_id,neighbourhood_group, last_review and any duplcate latitude and longitude we can have. our final dataset contained 12 columns and 165,733 rows. Based on our interest, we decided to move on with only the top 14 cities and the top 150 records of our primary dataset. we calculted average and median of price availability and number of review in new dataframe. then some plot to show the number and the type (hotel room, shared room, private room, entire home/apt) of airbnb rental place in each city. We did bins for price also. Once finish cleaning, we were able to load the dataset to SQLite for Exploratory Analysis.
For the proposed project, we will be using the following software:
- libraries : Plotly, Leaflet, pandas, Chart.js, jQuery
- Deployment : Heroku, Flask
- Database : sqlite
- Languages : Python, Javascript, HTML, CSS
we use flask to set the routes and heroku to deploy our website. Each Icon : Home, Dasboard, maps, charts about represents a link to a another page.
The page display the project name and the team memebers names with picture of the beach in the background.
The plot in the page shows the number of rental propeties based on type (shared room, private room, hotel room, entire home/apt). We can aslo see the number of properties by cities. The top 3 of cities with more properties is New York City, Los Angeles, Hawaii and the entire home/apt is far the most properties proposed on airbnb in those cities. And the plot of the average price of private room and entire home/apt.
The heatmap has street and topographic layers with price, reviews and avalaibility markers and dropdown button that allows to navigate through the top 5 cities. For example, if you zoom in on each city, there is a heatmap by price, reviews, and availability. Zoom in a little more and there is a cluster number of properties in the area. Also if you mouse over the property, you can see more detailed information about the property.
Those shows two maps display the count or frequency of rental properties by region and the average of price based on type of room by region.
The app can be viewed here.