README: hotels-europe dataset

This is a README file for the hotels-europe dataset that includes information on price and features of hotels in 46 European cities and for 10 different dates.

Used in case studies 3B Comparing hotel prices in Europe: Vienna vs. London 9B How stable is the hotel price–distance to center relationship?

Data source

Scraped from a price comparison website. It was anonymized and slightly altered to ensure confidentiality. It contains a great deal of information about the location and rating but not the name or the address.

The data was collected by the authors and may be used for education purposes only.

About the data

Raw data tables

The raw data is hotelbookingdata.csv and it is available from the OSF.io repo. It includes the cleaning code.

The file contains data about hotel prices and features from a price comparison website.

  • for in 46 European cities and for
  • for 10 different dates, including weekend and weekdays
  • The dataset has N= 149,966 observations.
  • ID variable: hotel_id

Tidy data table

There are two data tables

hotel_features

  • This is a cross section data, with id= hotel_id
  • The dataset has N=148,021 observations.
variable description type
hotel_id Hotel ID numeric
accommodation_type Type of accomodation factor
country Country string
city City based on search string
city_actual City actual of hotel string
neighbourhood Neighburhood string
center1label Centre 1 - name of location for distance string
distance Distance - from main city center numeric
center2label Centre 2 - name of location for distance_alter string
distance_alter Distance - alternative - from Centre 2 numeric
stars Number of stars numeric
rating User rating average numeric
rating_count Number of user ratings numeric
ratingta User rating average (tripadvisor) numeric
ratingta_count Number of user ratings (tripadvisor) numeric

hotel_prices

  • this is a panel data with id= hotel_id and the date (year, month, weekend)
  • The dataset has N= 22,902 observations.
variable description type
hotel_id Hotel ID numeric
year Year (YYYY) numeric
month Month (MM) numeric
weekend Flag, if day is a weekend binary
holiday Flag, if day is a public holiday binary
nnights Number of nights (1 or 4) factor
price Pricee in EUR numeric
scarce_room Flag, if room was noted as scarce binary
offer Flag, if there was an offer available binary
offer_cat Type of offer factor

work data

hotels-europe is created by joining the two tidy tables and cleaning it.

  • ID variable: hotel_id and date
  • The dataset has N= 148,021 observations.
variable name info type
hotel_id Hotel ID numeric
accommodation_type Type of accomodation factor
country Country string
city City based on search string
city_actual City actual of hotel string
neighbourhood Neighburhood string
center1label Centre 1 - name of location for distance string
distance Distance - from main city center numeric
center2label Centre 2 - name of location for distance_alter string
distance_alter Distance - alternative - from Centre 2 numeric
stars Number of stars numeric
rating User rating average numeric
rating_count Number of user ratings numeric
ratingta User rating average (tripadvisor) numeric
ratingta_count Number of user ratings (tripadvisor) numeric
hotel_id Hotel ID numeric
year Year (YYYY) numeric
month Month (MM) numeric
weekend Flag, if day is a weekend binary
holiday Flag, if day is a public holiday binary
nnights Number of nights factor
price Pricee in EUR numeric
scarce_room Flag, if room was noted as scarce binary
offer Flag, if there was an offer available binary
offer_cat Type of offer factor