Name: Airbnb Prices In European Cities
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Airbnb Prices In European Cities

Airbnb Prices in European Cities

Determinants of Price by Room Type, Location, Cleanliness Rating, and More

By [source]

About this dataset

This dataset provides a comprehensive look at Airbnb prices in some of the most popular European cities. Each listing is evaluated for various attributes such as room types, cleanliness and satisfaction ratings, bedrooms, distance from the city centre, and more to capture an in-depth understanding of Airbnb prices on both weekdays and weekends. Using spatial econometric methods, we analyse and identify the determinants of Airbnb prices across these cities. Our dataset includes information such as realSum (the total price of the listing), room_type (private/shared/entire home/apt), host_is_superhost (boolean value indicating if host is a superhost or not), multi (indicator whether listing is for multiple rooms or not), biz (business indicator) , guest_satisfaction_overall (overall rating from guests camparing all listings offered by host ), bedrooms, dist (distance from city center) , lng & lat coordinates for location identification etc. We hope that this data set offers insight into how global markets are affected by social dynamics and geographical factors which in turn determine pricing strategies for optimal profitability!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset can be used by individuals and companies to gain insight on the cost of Airbnb listings in some of the most popular European cities. It contains information on a variety of attributes such as room type, cleanliness rating, guest satisfaction, distance from the city centre, and more. In addition to exploring general trends in prices across Europe, this dataset can be used for deeper spatial econometric analysis.

To begin using this dataset for your own research or analysis project:

Download the files which contain both weekday and weekend listings data for European cities.

Familiarize yourself with the columns included in each file; these provide descriptions of various attributes associated with each listing.

Calculate any desired summary statistics - average price per night per city or room type etc. - using statistical software (e.g Excel).

Perform spatial econometric analysis if desired; use specialized packages such as spdep or spatialreg in R to identify determinants of Airbnb price levels across Europe (e.g., metro distance).

Visualize your results with GIS software if necessary to more easily understand patterns between variables like proximity/location and price level (e.g., QGIS).

By leveraging both descriptive and inferential methods while taking advantage of geographic information systems (GIS), users can apply this dataset to many interesting questions related to rental prices on Airbnb in Europe!

Research Ideas

Analyzing spatial trends in Airbnb prices across Europe and finding the most favorable cities for hosting.

Comparing differences between weekday vs weekend booking patterns to project rental rates for vacationers and business travelers in European cities.

Using spatial econometrics methods to find important determinants of Airbnb prices in order to provide insights into areas of opportunity for improvement, or assess the effectiveness of existing policy changes concerning vacation rentals

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: vienna_weekdays.csv

Column name	Description
realSum	The total price of the Airbnb listing. (Numeric)
room_type	The type of room being offered (e.g. private, shared, etc.). (Categorical)
room_shared	Whether the room is shared or not. (Boolean)
room_private	Whether the room is private or not. (Boolean)
person_capacity	The maximum number of people that can stay in the room. (Numeric)
host_is_superhost	Whether the host is a superhost or not. (Boolean)
multi	Whether the listing is for multiple rooms or not. (Boolean)
biz	Whether the listing is for business purposes or not. (Boolean)
cleanliness_rating	The cleanliness rating of the listing. (Numeric)
guest_satisfaction_overall	The overall guest satisfaction rating of the listing. (Numeric)
bedrooms	The number of bedrooms in the listing. (Numeric)
dist	The distance from the city centre. (Numeric)
metro_dist	The distance from the nearest metro station. (Numeric)
lng	The longitude of the listing. (Numeric)
lat	The latitude of the listing. (Numeric)

File: vienna_weekends.csv

Column name	Description
realSum	The total price of the Airbnb listing. (Numeric)
room_type	The type of room being offered (e.g. private, shared, etc.). (Categorical)
room_shared	Whether the room is shared or not. (Boolean)
room_private	Whether the room is private or not. (Boolean)
person_capacity	The maximum number of people that can stay in the room. (Numeric)
host_is_superhost	Whether the host is a superhost or not. (Boolean)
multi	Whether the listing is for multiple rooms or not. (Boolean)
biz	Whether the listing is for business purposes or not. (Boolean)
cleanliness_rating	The cleanliness rating of the listing. (Numeric)
guest_satisfaction_overall	The overall guest satisfaction rating of the listing. (Numeric)
bedrooms	The number of bedrooms in the listing. (Numeric)
dist	The distance from the city centre. (Numeric)
metro_dist	The distance from the nearest metro station. (Numeric)
lng	The longitude of the listing. (Numeric)
lat	The latitude of the listing. (Numeric)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Amsterdam Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.amsterdam_weekdays

109.57 kB
1,103 rows
20 columns

CREATE TABLE amsterdam_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Amsterdam Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.amsterdam_weekends

98.66 kB
977 rows
20 columns

CREATE TABLE amsterdam_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Athens Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.athens_weekdays

228.38 kB
2,653 rows
20 columns

CREATE TABLE athens_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Athens Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.athens_weekends

226.48 kB
2,627 rows
20 columns

CREATE TABLE athens_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Barcelona Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.barcelona_weekdays

145.09 kB
1,555 rows
20 columns

CREATE TABLE barcelona_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Barcelona Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.barcelona_weekends

122.23 kB
1,278 rows
20 columns

CREATE TABLE barcelona_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Berlin Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.berlin_weekdays

124.11 kB
1,284 rows
20 columns

CREATE TABLE berlin_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Berlin Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.berlin_weekends

117.27 kB
1,200 rows
20 columns

CREATE TABLE berlin_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" BIGINT,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Budapest Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.budapest_weekdays

186.67 kB
2,074 rows
20 columns

CREATE TABLE budapest_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Budapest Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.budapest_weekends

174.81 kB
1,948 rows
20 columns

CREATE TABLE budapest_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Lisbon Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.lisbon_weekdays

246.57 kB
2,857 rows
20 columns

CREATE TABLE lisbon_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Lisbon Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.lisbon_weekends

249.76 kB
2,906 rows
20 columns

CREATE TABLE lisbon_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

London Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.london_weekdays

410.62 kB
4,614 rows
20 columns

CREATE TABLE london_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

London Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.london_weekends

476.29 kB
5,379 rows
20 columns

CREATE TABLE london_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Paris Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.paris_weekdays

281.24 kB
3,130 rows
20 columns

CREATE TABLE paris_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Paris Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.paris_weekends

316.94 kB
3,558 rows
20 columns

CREATE TABLE paris_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Rome Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.rome_weekdays

378.29 kB
4,492 rows
20 columns

CREATE TABLE rome_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Rome Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.rome_weekends

383.53 kB
4,535 rows
20 columns

CREATE TABLE rome_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Vienna Weekdays

@kaggle.thedevastator_airbnb_prices_in_european_cities.vienna_weekdays

160.44 kB
1,738 rows
20 columns

CREATE TABLE vienna_weekdays (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);

Vienna Weekends

@kaggle.thedevastator_airbnb_prices_in_european_cities.vienna_weekends

166.1 kB
1,799 rows
20 columns

CREATE TABLE vienna_weekends (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "realsum" DOUBLE,
  "room_type" VARCHAR,
  "room_shared" BOOLEAN,
  "room_private" BOOLEAN,
  "person_capacity" DOUBLE,
  "host_is_superhost" BOOLEAN,
  "multi" BIGINT,
  "biz" BIGINT,
  "cleanliness_rating" DOUBLE,
  "guest_satisfaction_overall" DOUBLE,
  "bedrooms" BIGINT,
  "dist" DOUBLE,
  "metro_dist" DOUBLE,
  "attr_index" DOUBLE,
  "attr_index_norm" DOUBLE,
  "rest_index" DOUBLE,
  "rest_index_norm" DOUBLE,
  "lng" DOUBLE,
  "lat" DOUBLE
);