Italian Airbnb

This dataset provide a snapshot of Airbnb listings across major Italian cities.

@kaggle.willianoliveiragibin_italian_airbnb

Table List

1 table(17.1 KB)

Airbnb Italian City Grouped New V2

@kaggle.willianoliveiragibin_italian_airbnb.airbnb_italian_city_grouped_new_v2

17.1 KB
17 rows
21 columns

place Place	period Period	neighbourhood_mode Neighbourhood Mode	room_type_mode Room Type Mode	host_is_superhost Host Is Superhost	neighbourhood Neighbourhood	property_type Property Type	number_of_reviews_ltm_median Number Of Reviews Ltm Median	number_of_reviews_ltm_median_abs_deviation Number Of Reviews Ltm Median Abs Deviation	host_total_listings_count_median Host Total Listings Count Median	host_total_listings_count_median_abs_deviation Host Total Listings Count Median Abs Deviation	neighbourhood_shannon_entropy Neighbourhood Shannon Entropy	room_type_shannon_entropy Room Type Shannon Entropy	accommodates_median Accommodates Median	accommodates_median_abs_deviation Accommodates Median Abs Deviation	price_median Price Median	host_number_of_listings Host Number Of Listings	beds_number Beds Number	bedrooms_number Bedrooms Number	maximum_allowed_guests Maximum Allowed Guests	price Price
Firenze	Early Spring	Centro Storico	Entire home/apt	Host	Centro Storico	Private room	14	12	4	3	12874	7	4	1	130	44	1	1	2	89
Firenze	Early Summer	Centro Storico	Entire home/apt	Superhost	Rifredi	Entire home	13	11	4	3	13446	7	4	1	145	3	3	2	4	300
Firenze	Early Winter	Centro Storico	Entire home/apt	Host	Gavinana Galluzzo	Entire home	11	11	4	3	13021	8	4	2	115	1	1	1	2	95
Milano	Early Spring	BUENOS AIRES - VENEZIA	Entire home/apt	Host	Centro Storico	Entire home	6	6	3	2	55081	6	3	1	100	2	1	1	4	60
Milano	Early Summer	BUENOS AIRES - VENEZIA	Entire home/apt	Superhost	Centro Storico	Entire home	5	5	3	2	55333	6	3	1	105	1	4	2	4	105
Milano	Early Winter	BUENOS AIRES - VENEZIA	Entire home/apt	Superhost	Campo di Marte	Entire home	4	4	3	2	55302	7	3	1	100	3	2	1	4	86
Napoli	Early Spring	San Lorenzo	Entire home/apt	Host	Centro Storico	Hotel room	6	6	3	2	39418	10	4	1	85	6	1	1	2	63
Napoli	Early Summer	San Lorenzo	Entire home/apt	Superhost	Centro Storico	Private room	5	5	3	2	39622	10	4	1	87	2	1	1	2	35
Napoli	Early Winter	San Lorenzo	Entire home/apt	Host	Centro Storico	Private room	6	6	3	2	39343	10	4	1	85	12	2	1	2	83
Roma	Early Autumn	I Centro Storico	Entire home/apt	Superhost	Campo di Marte	Private room	9	9	3	2	26916	9	4	2	140	1	2	1	2	61


CREATE TABLE airbnb_italian_city_grouped_new_v2 (
  "place" VARCHAR,
  "period" VARCHAR,
  "neighbourhood_mode" VARCHAR,
  "room_type_mode" VARCHAR,
  "host_is_superhost" VARCHAR,
  "neighbourhood" VARCHAR,
  "property_type" VARCHAR,
  "number_of_reviews_ltm_median" BIGINT,
  "number_of_reviews_ltm_median_abs_deviation" BIGINT,
  "host_total_listings_count_median" BIGINT,
  "host_total_listings_count_median_abs_deviation" BIGINT,
  "neighbourhood_shannon_entropy" BIGINT,
  "room_type_shannon_entropy" BIGINT,
  "accommodates_median" BIGINT,
  "accommodates_median_abs_deviation" BIGINT,
  "price_median" BIGINT,
  "host_number_of_listings" BIGINT,
  "beds_number" BIGINT,
  "bedrooms_number" BIGINT,
  "maximum_allowed_guests" BIGINT,
  "price" BIGINT
);