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

107.01 KB
1103 rows
20 columns


CREATE TABLE amsterdam_weekdays (
  "unnamed_0" BIGINT,
  "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

96.34 KB
977 rows
20 columns


CREATE TABLE amsterdam_weekends (
  "unnamed_0" BIGINT,
  "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

223.03 KB
2653 rows
20 columns


CREATE TABLE athens_weekdays (
  "unnamed_0" BIGINT,
  "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

221.18 KB
2627 rows
20 columns


CREATE TABLE athens_weekends (
  "unnamed_0" BIGINT,
  "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

141.69 KB
1555 rows
20 columns


CREATE TABLE barcelona_weekdays (
  "unnamed_0" BIGINT,
  "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

119.36 KB
1278 rows
20 columns


CREATE TABLE barcelona_weekends (
  "unnamed_0" BIGINT,
  "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

121.21 KB
1284 rows
20 columns


CREATE TABLE berlin_weekdays (
  "unnamed_0" BIGINT,
  "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

114.52 KB
1200 rows
20 columns


CREATE TABLE berlin_weekends (
  "unnamed_0" BIGINT,
  "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

182.29 KB
2074 rows
20 columns


CREATE TABLE budapest_weekdays (
  "unnamed_0" BIGINT,
  "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

170.71 KB
1948 rows
20 columns


CREATE TABLE budapest_weekends (
  "unnamed_0" BIGINT,
  "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

240.79 KB
2857 rows
20 columns


CREATE TABLE lisbon_weekdays (
  "unnamed_0" BIGINT,
  "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

243.91 KB
2906 rows
20 columns


CREATE TABLE lisbon_weekends (
  "unnamed_0" BIGINT,
  "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

401 KB
4614 rows
20 columns


CREATE TABLE london_weekdays (
  "unnamed_0" BIGINT,
  "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

465.12 KB
5379 rows
20 columns


CREATE TABLE london_weekends (
  "unnamed_0" BIGINT,
  "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

274.65 KB
3130 rows
20 columns


CREATE TABLE paris_weekdays (
  "unnamed_0" BIGINT,
  "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

309.51 KB
3558 rows
20 columns


CREATE TABLE paris_weekends (
  "unnamed_0" BIGINT,
  "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

369.42 KB
4492 rows
20 columns


CREATE TABLE rome_weekdays (
  "unnamed_0" BIGINT,
  "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

374.54 KB
4535 rows
20 columns


CREATE TABLE rome_weekends (
  "unnamed_0" BIGINT,
  "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

156.68 KB
1738 rows
20 columns


CREATE TABLE vienna_weekdays (
  "unnamed_0" BIGINT,
  "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

162.21 KB
1799 rows
20 columns


CREATE TABLE vienna_weekends (
  "unnamed_0" BIGINT,
  "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
);