{ "cells": [ { "cell_type": "markdown", "id": "d9e67c9f", "metadata": {}, "source": [ "." ] }, { "cell_type": "markdown", "id": "b63fc669", "metadata": {}, "source": [ "
Most Profitable Neighborhoods For AirBnb
\n", "\t\n", " | id | \n", "name | \n", "host_id | \n", "host_name | \n", "neighbourhood_group | \n", "neighbourhood | \n", "latitude | \n", "longitude | \n", "room_type | \n", "price | \n", "minimum_nights | \n", "number_of_reviews | \n", "last_review | \n", "reviews_per_month | \n", "calculated_host_listings_count | \n", "availability_365 | \n", "number_of_reviews_ltm | \n", "license | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "6369 | \n", "Rooftop terrace room , ensuite bathroom | \n", "13660 | \n", "Simon | \n", "Chamartín | \n", "Hispanoamérica | \n", "40.45724 | \n", "-3.67688 | \n", "Private room | \n", "60 | \n", "1 | \n", "80 | \n", "2019-05-14 | \n", "1.21 | \n", "2 | \n", "180 | \n", "4 | \n", "NaN | \n", "
1 | \n", "21853 | \n", "Bright and airy room | \n", "83531 | \n", "Abdel | \n", "Latina | \n", "Cármenes | \n", "40.40381 | \n", "-3.74130 | \n", "Private room | \n", "31 | \n", "4 | \n", "33 | \n", "2018-05-29 | \n", "0.39 | \n", "2 | \n", "364 | \n", "0 | \n", "NaN | \n", "
2 | \n", "23001 | \n", "Apartmento Arganzuela- Madrid Rio | \n", "82175 | \n", "Jesus | \n", "Arganzuela | \n", "Legazpi | \n", "40.38840 | \n", "-3.69511 | \n", "Entire home/apt | \n", "50 | \n", "15 | \n", "0 | \n", "NaN | \n", "NaN | \n", "5 | \n", "222 | \n", "0 | \n", "NaN | \n", "
3 | \n", "24805 | \n", "Gran Via Studio Madrid | \n", "346366726 | \n", "A | \n", "Centro | \n", "Universidad | \n", "40.42183 | \n", "-3.70529 | \n", "Entire home/apt | \n", "92 | \n", "5 | \n", "12 | \n", "2020-03-01 | \n", "0.51 | \n", "1 | \n", "115 | \n", "2 | \n", "NaN | \n", "
4 | \n", "26825 | \n", "Single Room whith private Bathroom | \n", "114340 | \n", "Agustina | \n", "Arganzuela | \n", "Legazpi | \n", "40.38975 | \n", "-3.69018 | \n", "Private room | \n", "26 | \n", "2 | \n", "149 | \n", "2018-05-15 | \n", "1.65 | \n", "1 | \n", "349 | \n", "0 | \n", "NaN | \n", "
\n", " | id | \n", "listing_url | \n", "scrape_id | \n", "last_scraped | \n", "name | \n", "description | \n", "neighborhood_overview | \n", "picture_url | \n", "host_id | \n", "host_url | \n", "... | \n", "review_scores_communication | \n", "review_scores_location | \n", "review_scores_value | \n", "license | \n", "instant_bookable | \n", "calculated_host_listings_count | \n", "calculated_host_listings_count_entire_homes | \n", "calculated_host_listings_count_private_rooms | \n", "calculated_host_listings_count_shared_rooms | \n", "reviews_per_month | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "6369 | \n", "https://www.airbnb.com/rooms/6369 | \n", "20210910193531 | \n", "2021-09-11 | \n", "Rooftop terrace room , ensuite bathroom | \n", "Excellent connection with the AIRPORT and EXHI... | \n", "NaN | \n", "https://a0.muscache.com/pictures/683224/4cc318... | \n", "13660 | \n", "https://www.airbnb.com/users/show/13660 | \n", "... | \n", "4.89 | \n", "4.77 | \n", "4.85 | \n", "NaN | \n", "f | \n", "2 | \n", "0 | \n", "2 | \n", "0 | \n", "1.21 | \n", "
1 | \n", "21853 | \n", "https://www.airbnb.com/rooms/21853 | \n", "20210910193531 | \n", "2021-09-11 | \n", "Bright and airy room | \n", "We have a quiet and sunny room with a good vie... | \n", "We live in a leafy neighbourhood with plenty o... | \n", "https://a0.muscache.com/pictures/68483181/87bc... | \n", "83531 | \n", "https://www.airbnb.com/users/show/83531 | \n", "... | \n", "4.82 | \n", "4.21 | \n", "4.67 | \n", "NaN | \n", "f | \n", "2 | \n", "0 | \n", "2 | \n", "0 | \n", "0.39 | \n", "
2 | \n", "23001 | \n", "https://www.airbnb.com/rooms/23001 | \n", "20210910193531 | \n", "2021-09-11 | \n", "Apartmento Arganzuela- Madrid Rio | \n", "Apartamento de tres dormitorios dobles, gran s... | \n", "Barrio Arganzuela, junto a Madrid Rio, zonas c... | \n", "https://a0.muscache.com/pictures/58e6a770-509c... | \n", "82175 | \n", "https://www.airbnb.com/users/show/82175 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "f | \n", "5 | \n", "4 | \n", "1 | \n", "0 | \n", "NaN | \n", "
3 | \n", "24805 | \n", "https://www.airbnb.com/rooms/24805 | \n", "20210910193531 | \n", "2021-09-11 | \n", "Gran Via Studio Madrid | \n", "Studio located 50 meters from Gran Via, next t... | \n", "The area is next to the Gran Via, so people li... | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "346366726 | \n", "https://www.airbnb.com/users/show/346366726 | \n", "... | \n", "5.00 | \n", "5.00 | \n", "4.83 | \n", "NaN | \n", "f | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0.51 | \n", "
4 | \n", "26825 | \n", "https://www.airbnb.com/rooms/26825 | \n", "20210910193531 | \n", "2021-09-11 | \n", "Single Room whith private Bathroom | \n", "Nice and cozy roon for one person with a priva... | \n", "Es un barrio muy tranquilo, en una zona de Mad... | \n", "https://a0.muscache.com/pictures/149358/218d5b... | \n", "114340 | \n", "https://www.airbnb.com/users/show/114340 | \n", "... | \n", "4.71 | \n", "4.70 | \n", "4.72 | \n", "NaN | \n", "f | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1.65 | \n", "
5 rows × 74 columns
\n", "\n", " | precio_m2 | \n", "distrito | \n", "
---|---|---|
1 | \n", "4.085 €/m2 | \n", "Arganzuela | \n", "
2 | \n", "3.409 €/m2 | \n", "Barajas | \n", "
3 | \n", "2.123 €/m2 | \n", "Carabanchel | \n", "
4 | \n", "4.827 €/m2 | \n", "Centro | \n", "
5 | \n", "5.098 €/m2 | \n", "Chamartín | \n", "
6 | \n", "5.381 €/m2 | \n", "Chamberí | \n", "
7 | \n", "2.940 €/m2 | \n", "Ciudad Lineal | \n", "
8 | \n", "3.568 €/m2 | \n", "Fuencarral | \n", "
9 | \n", "3.871 €/m2 | \n", "Hortaleza | \n", "
10 | \n", "2.267 €/m2 | \n", "Latina | \n", "
11 | \n", "4.033 €/m2 | \n", "Moncloa | \n", "
12 | \n", "2.500 €/m2 | \n", "Moratalaz | \n", "
13 | \n", "1.918 €/m2 | \n", "Puente de Vallecas | \n", "
14 | \n", "4.788 €/m2 | \n", "Retiro | \n", "
15 | \n", "6.114 €/m2 | \n", "Salamanca | \n", "
16 | \n", "2.591 €/m2 | \n", "San Blas | \n", "
17 | \n", "3.678 €/m2 | \n", "Tetuán | \n", "
18 | \n", "1.995 €/m2 | \n", "Usera | \n", "
19 | \n", "2.403 €/m2 | \n", "Vicálvaro | \n", "
20 | \n", "2.354 €/m2 | \n", "Villa de Vallecas | \n", "
21 | \n", "1.693 €/m2 | \n", "Villaverde | \n", "
\n", " | precio_m2 | \n", "distrito | \n", "
---|---|---|
1 | \n", "4085 | \n", "Arganzuela | \n", "
2 | \n", "3409 | \n", "Barajas | \n", "
3 | \n", "2123 | \n", "Carabanchel | \n", "
4 | \n", "4827 | \n", "Centro | \n", "
5 | \n", "5098 | \n", "Chamartín | \n", "
6 | \n", "5381 | \n", "Chamberí | \n", "
7 | \n", "2940 | \n", "Ciudad Lineal | \n", "
8 | \n", "3568 | \n", "Fuencarral | \n", "
9 | \n", "3871 | \n", "Hortaleza | \n", "
10 | \n", "2267 | \n", "Latina | \n", "
11 | \n", "4033 | \n", "Moncloa | \n", "
12 | \n", "2500 | \n", "Moratalaz | \n", "
13 | \n", "1918 | \n", "Puente de Vallecas | \n", "
14 | \n", "4788 | \n", "Retiro | \n", "
15 | \n", "6114 | \n", "Salamanca | \n", "
16 | \n", "2591 | \n", "San Blas | \n", "
17 | \n", "3678 | \n", "Tetuán | \n", "
18 | \n", "1995 | \n", "Usera | \n", "
19 | \n", "2403 | \n", "Vicálvaro | \n", "
20 | \n", "2354 | \n", "Villa de Vallecas | \n", "
21 | \n", "1693 | \n", "Villaverde | \n", "
\n", " | level_0 | \n", "index | \n", "id | \n", "name | \n", "host_id | \n", "neighbourhood_group | \n", "neighbourhood | \n", "latitude | \n", "longitude | \n", "room_type | \n", "... | \n", "distrito | \n", "precio_total | \n", "ocupacion | \n", "bedrooms_disc | \n", "accommodates_disc | \n", "beds_disc | \n", "number_of_reviews_disc | \n", "m2 | \n", "precio_compra | \n", "pdi_sol | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "0 | \n", "6369 | \n", "Rooftop terrace room , ensuite bathroom | \n", "13660 | \n", "Chamartín | \n", "Hispanoamérica | \n", "40.45724 | \n", "-3.67688 | \n", "Private room | \n", "... | \n", "Chamartín | \n", "60.0 | \n", "50 | \n", "01_Una | \n", "0-3 | \n", "1 | \n", "49-744 | \n", "50 | \n", "178430.0 | \n", "5.032039 | \n", "
1 | \n", "1 | \n", "1 | \n", "21853 | \n", "Bright and airy room | \n", "83531 | \n", "Latina | \n", "Cármenes | \n", "40.40381 | \n", "-3.74130 | \n", "Private room | \n", "... | \n", "Latina | \n", "31.0 | \n", "0 | \n", "01_Una | \n", "0-3 | \n", "1 | \n", "5-48 | \n", "50 | \n", "79345.0 | \n", "3.521406 | \n", "
2 | \n", "2 | \n", "2 | \n", "23001 | \n", "Apartmento Arganzuela- Madrid Rio | \n", "82175 | \n", "Arganzuela | \n", "Legazpi | \n", "40.38840 | \n", "-3.69511 | \n", "Entire home/apt | \n", "... | \n", "Arganzuela | \n", "50.0 | \n", "39 | \n", "03_Tres | \n", "5-16 | \n", "3-23 | \n", "0-4 | \n", "90 | \n", "257355.0 | \n", "3.226963 | \n", "
3 | \n", "3 | \n", "3 | \n", "24805 | \n", "Gran Via Studio Madrid | \n", "346366726 | \n", "Centro | \n", "Universidad | \n", "40.42183 | \n", "-3.70529 | \n", "Entire home/apt | \n", "... | \n", "Centro | \n", "92.0 | \n", "68 | \n", "01_Una | \n", "0-3 | \n", "1 | \n", "5-48 | \n", "50 | \n", "168945.0 | \n", "0.591065 | \n", "
4 | \n", "4 | \n", "4 | \n", "26825 | \n", "Single Room whith private Bathroom | \n", "114340 | \n", "Arganzuela | \n", "Legazpi | \n", "40.38975 | \n", "-3.69018 | \n", "Private room | \n", "... | \n", "Arganzuela | \n", "26.0 | \n", "4 | \n", "01_Una | \n", "0-3 | \n", "1 | \n", "49-744 | \n", "50 | \n", "142975.0 | \n", "3.200942 | \n", "
5 rows × 35 columns
\n", "