Geographical Revenue Analysis with GeoPandas and SQL: Analysing Hotel ADR
Using GeoPandas to analyse average ADR by country
Note: The full article is available here.
GeoPandas is a Python library designed for working with geospatial data. It has many uses when analysing data across different countries.
Specifically, companies that have international customers or operate internationally may be interested in metrics relevant to the regions in which they operate.
Suppose a hotel chain in Portugal wishes to answer the following question:
“Of all the customers that book with our hotel, which countries show among the highest average daily rate for these customers?”
To answer this question, let us see how GeoPandas can be used to visualise countries with the highest average daily rates.
The dataset used for this analysis is the hotel booking dataset from ScienceDirect by Antonio, Almeida and Nunes (2019), which is licensed under the Creative Commons Attribution 4.0 International license.
