| \n", " | id | \n", "listing_url | \n", "scrape_id | \n", "last_scraped | \n", "source | \n", "name | \n", "description | \n", "neighborhood_overview | \n", "picture_url | \n", "host_id | \n", "host_url | \n", "host_name | \n", "host_since | \n", "host_location | \n", "host_about | \n", "host_response_time | \n", "host_response_rate | \n", "host_acceptance_rate | \n", "host_is_superhost | \n", "host_thumbnail_url | \n", "host_picture_url | \n", "host_neighbourhood | \n", "host_listings_count | \n", "host_total_listings_count | \n", "host_verifications | \n", "host_has_profile_pic | \n", "host_identity_verified | \n", "neighbourhood | \n", "neighbourhood_cleansed | \n", "neighbourhood_group_cleansed | \n", "latitude | \n", "longitude | \n", "property_type | \n", "room_type | \n", "accommodates | \n", "bathrooms | \n", "bathrooms_text | \n", "bedrooms | \n", "beds | \n", "amenities | \n", "price | \n", "minimum_nights | \n", "maximum_nights | \n", "minimum_minimum_nights | \n", "maximum_minimum_nights | \n", "minimum_maximum_nights | \n", "maximum_maximum_nights | \n", "minimum_nights_avg_ntm | \n", "maximum_nights_avg_ntm | \n", "calendar_updated | \n", "has_availability | \n", "availability_30 | \n", "availability_60 | \n", "availability_90 | \n", "availability_365 | \n", "calendar_last_scraped | \n", "number_of_reviews | \n", "number_of_reviews_ltm | \n", "number_of_reviews_l30d | \n", "first_review | \n", "last_review | \n", "review_scores_rating | \n", "review_scores_accuracy | \n", "review_scores_cleanliness | \n", "review_scores_checkin | \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", "675719763048199652 | \n", "https://www.airbnb.com/rooms/675719763048199652 | \n", "20221206172243 | \n", "2022-12-07 | \n", "city scrape | \n", "Walking distance to UCLA, private room shared ... | \n", "Forget your worries in this spacious and seren... | \n", "None | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "4780152 | \n", "https://www.airbnb.com/users/show/4780152 | \n", "Moon | \n", "2013-01-20 | \n", "Los Angeles, CA | \n", "I am from LA\\r\\nI love studying. I care about ... | \n", "within an hour | \n", "100% | \n", "47% | \n", "t | \n", "https://a0.muscache.com/im/users/4780152/profi... | \n", "https://a0.muscache.com/im/users/4780152/profi... | \n", "Brentwood | \n", "68.0 | \n", "86.0 | \n", "['email', 'phone'] | \n", "t | \n", "t | \n", "None | \n", "West Los Angeles | \n", "City of Los Angeles | \n", "34.04863 | \n", "-118.43262 | \n", "Private room in condo | \n", "Private room | \n", "1 | \n", "None | \n", "1 private bath | \n", "1.0 | \n", "1.0 | \n", "[\"Wifi\", \"Hot tub\", \"Long term stays allowed\",... | \n", "67.0 | \n", "30 | \n", "365 | \n", "30.0 | \n", "30.0 | \n", "365.0 | \n", "365.0 | \n", "30.0 | \n", "365.0 | \n", "None | \n", "t | \n", "30 | \n", "60 | \n", "90 | \n", "365 | \n", "2022-12-07 | \n", "1 | \n", "1 | \n", "0 | \n", "2022-09-16 | \n", "2022-09-16 | \n", "4.0 | \n", "3.0 | \n", "2.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "4.0 | \n", "None | \n", "f | \n", "26 | \n", "4 | \n", "22 | \n", "0 | \n", "0.36 | \n", "
| 1 | \n", "678493211017259570 | \n", "https://www.airbnb.com/rooms/678493211017259570 | \n", "20221206172243 | \n", "2022-12-07 | \n", "city scrape | \n", "Film Executive Luxury Suite, pool, tiki bar, ETC | \n", "a really nice vibe atmosphere like being at at... | \n", "None | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "119676461 | \n", "https://www.airbnb.com/users/show/119676461 | \n", "David | \n", "2017-03-07 | \n", "Los Angeles, CA | \n", "Cindy and David are a retired theatre producin... | \n", "within an hour | \n", "100% | \n", "97% | \n", "t | \n", "https://a0.muscache.com/im/pictures/user/9abd0... | \n", "https://a0.muscache.com/im/pictures/user/9abd0... | \n", "North Hollywood | \n", "5.0 | \n", "7.0 | \n", "['email', 'phone'] | \n", "t | \n", "f | \n", "None | \n", "North Hollywood | \n", "City of Los Angeles | \n", "34.17599 | \n", "-118.36910 | \n", "Entire guest suite | \n", "Entire home/apt | \n", "2 | \n", "None | \n", "1 bath | \n", "NaN | \n", "1.0 | \n", "[\"Wifi\", \"Long term stays allowed\", \"TV\", \"Fir... | \n", "120.0 | \n", "30 | \n", "90 | \n", "30.0 | \n", "30.0 | \n", "90.0 | \n", "90.0 | \n", "30.0 | \n", "90.0 | \n", "None | \n", "t | \n", "16 | \n", "46 | \n", "76 | \n", "101 | \n", "2022-12-07 | \n", "1 | \n", "1 | \n", "0 | \n", "2022-08-31 | \n", "2022-08-31 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "None | \n", "f | \n", "5 | \n", "5 | \n", "0 | \n", "0 | \n", "0.30 | \n", "
| 2 | \n", "677263836495587840 | \n", "https://www.airbnb.com/rooms/677263836495587840 | \n", "20221206172243 | \n", "2022-12-07 | \n", "city scrape | \n", "Genting house with swimming pool in Runyon Canyon | \n", "This listing is in a prime location in the Hol... | \n", "The best location in Los Angeles.Near Runyon C... | \n", "https://a0.muscache.com/pictures/22fe5f73-b340... | \n", "418509413 | \n", "https://www.airbnb.com/users/show/418509413 | \n", "Nina | \n", "2021-08-15 | \n", "None | \n", "I'm from Los Angeles with more than 10 years o... | \n", "within an hour | \n", "100% | \n", "100% | \n", "f | \n", "https://a0.muscache.com/im/pictures/user/4cc11... | \n", "https://a0.muscache.com/im/pictures/user/4cc11... | \n", "Central LA | \n", "2.0 | \n", "3.0 | \n", "['phone'] | \n", "t | \n", "t | \n", "Los Angeles, California, United States | \n", "Hollywood Hills West | \n", "City of Los Angeles | \n", "34.11680 | \n", "-118.35407 | \n", "Entire villa | \n", "Entire home/apt | \n", "9 | \n", "None | \n", "3.5 baths | \n", "4.0 | \n", "5.0 | \n", "[\"Shower gel\", \"Dishes and silverware\", \"TV\", ... | \n", "1241.0 | \n", "1 | \n", "365 | \n", "1.0 | \n", "1.0 | \n", "1125.0 | \n", "1125.0 | \n", "1.0 | \n", "1125.0 | \n", "None | \n", "t | \n", "21 | \n", "38 | \n", "63 | \n", "320 | \n", "2022-12-07 | \n", "3 | \n", "3 | \n", "0 | \n", "2022-09-20 | \n", "2022-10-30 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "HSR22-001906 | \n", "f | \n", "2 | \n", "2 | \n", "0 | \n", "0 | \n", "1.14 | \n", "
| 3 | \n", "15299255 | \n", "https://www.airbnb.com/rooms/15299255 | \n", "20230307175359 | \n", "2023-03-08 | \n", "previous scrape | \n", "Nice Hollywood home | \n", "Lovely home with gym and pool | \n", "None | \n", "https://a0.muscache.com/pictures/15f16ac8-c3f6... | \n", "97000730 | \n", "https://www.airbnb.com/users/show/97000730 | \n", "Richard | \n", "2016-09-27 | \n", "None | \n", "None | \n", "N/A | \n", "N/A | \n", "N/A | \n", "f | \n", "https://a0.muscache.com/im/pictures/user/6fc54... | \n", "https://a0.muscache.com/im/pictures/user/6fc54... | \n", "None | \n", "1.0 | \n", "3.0 | \n", "['email', 'phone'] | \n", "t | \n", "f | \n", "None | \n", "North Hollywood | \n", "City of Los Angeles | \n", "34.20079 | \n", "-118.37875 | \n", "Private room in rental unit | \n", "Private room | \n", "1 | \n", "None | \n", "1 bath | \n", "1.0 | \n", "1.0 | \n", "[] | \n", "100.0 | \n", "30 | \n", "1125 | \n", "30.0 | \n", "30.0 | \n", "1125.0 | \n", "1125.0 | \n", "30.0 | \n", "1125.0 | \n", "None | \n", "f | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "2023-03-08 | \n", "0 | \n", "0 | \n", "0 | \n", "NaT | \n", "NaT | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "None | \n", "f | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "None | \n", "
| 4 | \n", "678522593527800929 | \n", "https://www.airbnb.com/rooms/678522593527800929 | \n", "20221206172243 | \n", "2022-12-07 | \n", "city scrape | \n", "Stylish newly remodeled 2bd 2ba home in West LA | \n", "Stylish single home with mid-century/eclectic ... | \n", "None | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "163620715 | \n", "https://www.airbnb.com/users/show/163620715 | \n", "Sakona | \n", "2017-12-21 | \n", "Los Angeles, CA | \n", "We are Waka & Sakona, we are designers in the ... | \n", "within a few hours | \n", "100% | \n", "100% | \n", "f | \n", "https://a0.muscache.com/im/pictures/user/b29db... | \n", "https://a0.muscache.com/im/pictures/user/b29db... | \n", "West Los Angeles | \n", "1.0 | \n", "1.0 | \n", "['email', 'phone'] | \n", "t | \n", "f | \n", "None | \n", "Rancho Park | \n", "City of Los Angeles | \n", "34.03645 | \n", "-118.43144 | \n", "Entire home | \n", "Entire home/apt | \n", "4 | \n", "None | \n", "2 baths | \n", "2.0 | \n", "2.0 | \n", "[\"Private entrance\", \"Shower gel\", \"Dishes and... | \n", "220.0 | \n", "30 | \n", "120 | \n", "30.0 | \n", "30.0 | \n", "120.0 | \n", "120.0 | \n", "30.0 | \n", "120.0 | \n", "None | \n", "t | \n", "0 | \n", "3 | \n", "33 | \n", "123 | \n", "2022-12-07 | \n", "3 | \n", "3 | \n", "1 | \n", "2022-08-17 | \n", "2022-11-07 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "5.0 | \n", "None | \n", "f | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0.80 | \n", "
\n",
"June 6 2023:
\n",
" 2023-06-06
\n",
" 2023-06-07
\n",
" 2023-06-08
\n",
"
| \n", " | host_id | \n", "host_name | \n", "host_since | \n", "neighbourhood_cleansed | \n", "property_type | \n", "average_proj_revenue | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "127909016 | \n", "Jordan | \n", "2017-04-27 | \n", "Beverly Crest | \n", "Entire home | \n", "63000.0 | \n", "
| 1 | \n", "165879616 | \n", "Jaida | \n", "2018-01-04 | \n", "Beverly Grove | \n", "Entire home | \n", "60000.0 | \n", "
| 2 | \n", "262960927 | \n", "Kay | \n", "2019-05-20 | \n", "Westwood | \n", "Private room in condo | \n", "60000.0 | \n", "
| 3 | \n", "1779977 | \n", "Dennis | \n", "2012-02-20 | \n", "Malibu | \n", "Entire home | \n", "60000.0 | \n", "
| 4 | \n", "344798399 | \n", "Moneyteam | \n", "2020-04-27 | \n", "Hawthorne | \n", "Entire home | \n", "60000.0 | \n", "
| 5 | \n", "4620768 | \n", "Jess | \n", "2013-01-07 | \n", "Westwood | \n", "Entire condo | \n", "60000.0 | \n", "
| 6 | \n", "165879616 | \n", "Jaida | \n", "2018-01-04 | \n", "Beverly Crest | \n", "Entire home | \n", "60000.0 | \n", "
| 7 | \n", "21603394 | \n", "Kevin | \n", "2014-09-21 | \n", "Redondo Beach | \n", "Entire rental unit | \n", "60000.0 | \n", "
| 8 | \n", "25276597 | \n", "Jonathan | \n", "2014-12-27 | \n", "Beverly Grove | \n", "Entire serviced apartment | \n", "60000.0 | \n", "
| 9 | \n", "257369700 | \n", "Billy | \n", "2019-04-22 | \n", "Rancho Palos Verdes | \n", "Entire home | \n", "60000.0 | \n", "
| 10 | \n", "49148904 | \n", "Donna | \n", "2015-11-16 | \n", "Inglewood | \n", "Entire home | \n", "60000.0 | \n", "
| 11 | \n", "73617291 | \n", "Amir | \n", "2016-05-23 | \n", "Malibu | \n", "Entire villa | \n", "60000.0 | \n", "
| 12 | \n", "302834378 | \n", "Alaa | \n", "2019-10-17 | \n", "Culver City | \n", "Private room in rental unit | \n", "59970.0 | \n", "
| 13 | \n", "38857249 | \n", "Chantal | \n", "2015-07-18 | \n", "West Hollywood | \n", "Entire home | \n", "59850.0 | \n", "
| 14 | \n", "155261 | \n", "Lindsay | \n", "2010-06-29 | \n", "Windsor Square | \n", "Entire home | \n", "57420.0 | \n", "
| 15 | \n", "267453940 | \n", "Kaylen | \n", "2019-06-09 | \n", "Malibu | \n", "Entire home | \n", "57000.0 | \n", "
| 16 | \n", "11522437 | \n", "Leslie | \n", "2014-01-21 | \n", "Hollywood Hills West | \n", "Entire home | \n", "57000.0 | \n", "
| 17 | \n", "160766240 | \n", "Bob | \n", "2017-11-30 | \n", "Sherman Oaks | \n", "Entire home | \n", "56970.0 | \n", "
| 18 | \n", "385575830 | \n", "Onefinestay | \n", "2021-01-22 | \n", "Hollywood Hills | \n", "Entire rental unit | \n", "56700.0 | \n", "
| 19 | \n", "41239505 | \n", "Shah | \n", "2015-08-12 | \n", "Venice | \n", "Entire rental unit | \n", "56700.0 | \n", "
| 20 | \n", "186993728 | \n", "Joe | \n", "2018-04-29 | \n", "Laguna Niguel | \n", "Entire home | \n", "53850.0 | \n", "
| 21 | \n", "1410898 | \n", "Jeff | \n", "2011-11-15 | \n", "Fairfax | \n", "Entire home | \n", "53200.0 | \n", "
| 22 | \n", "2620843 | \n", "Sandra | \n", "2012-06-12 | \n", "Venice | \n", "Entire home | \n", "52595.5 | \n", "
| 23 | \n", "93729818 | \n", "Ori | \n", "2016-09-05 | \n", "Encino | \n", "Entire rental unit | \n", "51000.0 | \n", "
| 24 | \n", "37594030 | \n", "John | \n", "2015-07-05 | \n", "Bel-Air | \n", "Entire home | \n", "50940.0 | \n", "
| 25 | \n", "174309124 | \n", "Jose | \n", "2018-02-20 | \n", "Studio City | \n", "Entire rental unit | \n", "50850.0 | \n", "
| \n", " | id | \n", "listing_url | \n", "name | \n", "host_id | \n", "host_name | \n", "last_scraped | \n", "neighbourhood_cleansed | \n", "property_type | \n", "number_of_reviews | \n", "
|---|---|---|---|---|---|---|---|---|---|
| 99920 | \n", "42409434 | \n", "https://www.airbnb.com/rooms/42409434 | \n", "The Burlington Hotel | \n", "229716119 | \n", "Simone | \n", "2023-03-09 | \n", "Westlake | \n", "Entire rental unit | \n", "2084 | \n", "
| 77420 | \n", "42409434 | \n", "https://www.airbnb.com/rooms/42409434 | \n", "The Burlington Hotel | \n", "229716119 | \n", "Simone | \n", "2022-12-25 | \n", "Westlake | \n", "Entire rental unit | \n", "1924 | \n", "
| 18622 | \n", "42409434 | \n", "https://www.airbnb.com/rooms/42409434 | \n", "The Burlington Hotel | \n", "229716119 | \n", "Simone | \n", "2022-09-10 | \n", "Westlake | \n", "Entire rental unit | \n", "1702 | \n", "
| 38704 | \n", "25186230 | \n", "https://www.airbnb.com/rooms/25186230 | \n", "King Kitchen Studio -Disneyland/Knott's Berry ... | \n", "174393062 | \n", "Hotel Pepper Tree | \n", "2022-09-10 | \n", "Anaheim | \n", "Room in boutique hotel | \n", "1175 | \n", "
| 155210 | \n", "578174478591578178 | \n", "https://www.airbnb.com/rooms/578174478591578178 | \n", "Boutique hotel in Inglewood · ★4.28 · 1 bedroo... | \n", "253105222 | \n", "Sonder (Los Angeles) | \n", "2023-06-08 | \n", "Inglewood | \n", "Room in boutique hotel | \n", "1137 | \n", "
| 129714 | \n", "1990543 | \n", "https://www.airbnb.com/rooms/1990543 | \n", "Guesthouse in Santa Monica · ★4.65 · 1 bedroom... | \n", "10265095 | \n", "Janet | \n", "2023-06-08 | \n", "Santa Monica | \n", "Entire guesthouse | \n", "1094 | \n", "
| 101601 | \n", "1990543 | \n", "https://www.airbnb.com/rooms/1990543 | \n", "Private 1906 Bungalow | \n", "10265095 | \n", "Janet | \n", "2023-03-09 | \n", "Santa Monica | \n", "Entire guesthouse | \n", "1068 | \n", "
| 61032 | \n", "1990543 | \n", "https://www.airbnb.com/rooms/1990543 | \n", "Private 1906 Bungalow | \n", "10265095 | \n", "Janet | \n", "2022-12-25 | \n", "Santa Monica | \n", "Entire guesthouse | \n", "1048 | \n", "
| 40193 | \n", "3561523 | \n", "https://www.airbnb.com/rooms/3561523 | \n", "Private Entrance Queen Bed Newport Mesa | \n", "3346091 | \n", "Vicki | \n", "2022-09-10 | \n", "Costa Mesa | \n", "Private room in cottage | \n", "1043 | \n", "
| 153568 | \n", "53827863 | \n", "https://www.airbnb.com/rooms/53827863 | \n", "Boutique hotel in Inglewood · ★4.34 · 1 bedroo... | \n", "253105222 | \n", "Sonder (Los Angeles) | \n", "2023-06-08 | \n", "Inglewood | \n", "Room in boutique hotel | \n", "1039 | \n", "
| 1624 | \n", "1990543 | \n", "https://www.airbnb.com/rooms/1990543 | \n", "Private 1906 Bungalow | \n", "10265095 | \n", "Janet | \n", "2022-09-10 | \n", "Santa Monica | \n", "Entire guesthouse | \n", "1027 | \n", "
| 145451 | \n", "42515360 | \n", "https://www.airbnb.com/rooms/42515360 | \n", "Boutique hotel in Los Angeles · ★4.76 · 1 bedr... | \n", "295744253 | \n", "Hoxton | \n", "2023-06-08 | \n", "Downtown | \n", "Room in boutique hotel | \n", "1024 | \n", "
| 94201 | \n", "42515360 | \n", "https://www.airbnb.com/rooms/42515360 | \n", "A Lush Room at The Hoxton, Downtown LA | \n", "295744253 | \n", "Hoxton | \n", "2023-03-09 | \n", "Downtown | \n", "Room in boutique hotel | \n", "1020 | \n", "
| 131550 | \n", "7293369 | \n", "https://www.airbnb.com/rooms/7293369 | \n", "Home in Malibu · ★4.95 · 1 bedroom · 1 bed · 1... | \n", "37437994 | \n", "Shelly & Paul | \n", "2023-06-08 | \n", "Malibu | \n", "Private room in home | \n", "1019 | \n", "
| 77551 | \n", "42515360 | \n", "https://www.airbnb.com/rooms/42515360 | \n", "A Lush Room at The Hoxton, Downtown LA | \n", "295744253 | \n", "Hoxton | \n", "2022-12-25 | \n", "Downtown | \n", "Room in boutique hotel | \n", "1012 | \n", "
| \n", " | Neighbourhood | \n", "Mean Projected Revenue(30d) | \n", "Mean Price | \n", "Property Type | \n", "
|---|---|---|---|---|
| 84 | \n", "Emerald Bay | \n", "18650.000000 | \n", "1450.000000 | \n", "Entire home | \n", "
| 6 | \n", "Aliso and Wood Regional Park | \n", "12825.000000 | \n", "513.000000 | \n", "Entire home | \n", "
| 160 | \n", "Malibu | \n", "10636.365679 | \n", "806.946456 | \n", "Entire home | \n", "
| 22 | \n", "Bel-Air | \n", "9742.377049 | \n", "818.715847 | \n", "Entire home | \n", "
| 280 | \n", "Villa Park | \n", "9384.000000 | \n", "408.000000 | \n", "Entire home | \n", "
| 212 | \n", "Rolling Hills | \n", "8730.850000 | \n", "323.800000 | \n", "Entire guesthouse | \n", "
| 263 | \n", "Unincorporated Santa Monica Mountains | \n", "8563.676681 | \n", "592.638054 | \n", "Entire home | \n", "
| 296 | \n", "Westlake Village | \n", "8239.736842 | \n", "410.877193 | \n", "Entire home | \n", "
| 177 | \n", "Newport Beach | \n", "8201.215130 | \n", "497.951143 | \n", "Entire home | \n", "
| 207 | \n", "Rancho Palos Verdes | \n", "8108.256065 | \n", "396.110512 | \n", "Private room in home | \n", "
| 193 | \n", "Palos Verdes Estates | \n", "7711.961538 | \n", "470.179487 | \n", "Entire home | \n", "
| 26 | \n", "Beverly Crest | \n", "7545.798913 | \n", "743.193841 | \n", "Entire home | \n", "
| 117 | \n", "Hollywood Hills West | \n", "7459.039374 | \n", "652.057042 | \n", "Entire home | \n", "
| 189 | \n", "Pacific Palisades | \n", "7375.629008 | \n", "494.201527 | \n", "Entire home | \n", "
| 303 | \n", "Windsor Square | \n", "6767.688525 | \n", "289.688525 | \n", "Entire rental unit | \n", "
| 162 | \n", "Manhattan Beach | \n", "6502.803381 | \n", "410.327402 | \n", "Entire home | \n", "
| 213 | \n", "Rolling Hills Estates | \n", "6426.760870 | \n", "479.173913 | \n", "Entire home | \n", "
| 222 | \n", "San Marino | \n", "6313.316667 | \n", "248.550000 | \n", "Private room in home | \n", "
| 17 | \n", "Avalon | \n", "6307.815951 | \n", "434.279755 | \n", "Entire condo | \n", "
| 128 | \n", "La Crescenta-Montrose | \n", "6165.328671 | \n", "246.230769 | \n", "Entire home | \n", "
| 137 | \n", "Laguna Beach | \n", "5722.688705 | \n", "436.595041 | \n", "Entire home | \n", "
| 29 | \n", "Beverlywood | \n", "5672.872340 | \n", "287.936170 | \n", "Entire rental unit | \n", "
| 136 | \n", "Ladera Ranch | \n", "5642.933333 | \n", "233.533333 | \n", "Entire home | \n", "
| 257 | \n", "Topanga | \n", "5590.427403 | \n", "335.654397 | \n", "Entire home | \n", "
| 60 | \n", "Cypress | \n", "5529.857143 | \n", "270.142857 | \n", "Entire home | \n", "
\n", "The most expensive neighborhoods overall are Bel-Air, Malibu, Beverly Crest, Pacific Palisades and Unincorporated Santa Monica Mountains. Their average prices range from \\$400 to over \\$1500 per night.
\n", "We also notice a trend across many top neighbourhoods. For example, Bel-Air shows a steep price jump from 2 to 3 bedrooms, averaging \\$879 for 3 bedrooms versus \\$303 for 2.
\n", "Newport Beach has the most availability across larger 4-8 bedroom properties among the top neighborhoods.
\n", "| \n", " | listing_id | \n", "id | \n", "date | \n", "reviewer_id | \n", "reviewer_name | \n", "comments | \n", "score_neg | \n", "score_neu | \n", "score_pos | \n", "sentiment | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 118832 | \n", "16635769 | \n", "196016735 | \n", "2017-09-21 | \n", "1808452 | \n", "Jeffrey | \n", "Amir's place is a huge house located right on ... | \n", "0.00231 | \n", "0.022884 | \n", "0.974806 | \n", "Positive | \n", "
| 118833 | \n", "16635769 | \n", "324266676 | \n", "2018-09-16 | \n", "28777882 | \n", "Lara | \n", "This place is palatial! The Views!!!! The ow... | \n", "0.00393 | \n", "0.007768 | \n", "0.988302 | \n", "Positive | \n", "
| 118834 | \n", "16635769 | \n", "652899389 | \n", "2020-08-17 | \n", "35660075 | \n", "Alexandra | \n", "Awesome for big groups. Host was very responsi... | \n", "0.007756 | \n", "0.043151 | \n", "0.949093 | \n", "Positive | \n", "
| 119181 | \n", "19573901 | \n", "202036996 | \n", "2017-10-09 | \n", "43428003 | \n", "Candice | \n", "This location cannot be beat. Shah was a grea... | \n", "0.004962 | \n", "0.008434 | \n", "0.986603 | \n", "Positive | \n", "
| 119182 | \n", "19573901 | \n", "204559179 | \n", "2017-10-18 | \n", "9117752 | \n", "Yehia | \n", "This is the best place you can stay at ever in... | \n", "0.003481 | \n", "0.007355 | \n", "0.989164 | \n", "Positive | \n", "
In the top listings we see words such as \"place\", \"home\", \"house\", \"amazing\", \"loved\", \"beautiful\", \"family\", \"kitchen\", \"closet\", \"great host\", \"pool\", \"location\", \"view\", \"ocean\", \"spacious\", \"Malibu\", etc. These casual words and phrases indicate customers' satisfaction of amenities, views and locations expressing positive vibe and emotions. Some actual hosts' names are also in the cloud, pointing to popularity of certain operators as well as customers attention and attitude.
\n", "The overall word map tells the story of similar mood. The list contains \"great location\", \"clean\", \"house\", \"great place\", \"highly recommend\", \"great host\", \"definitely stay\", \"street parking\", \"quick respond\", \"Santa Monica\", \"quiet neighborhood\" and so on. The terms are more generic and concentrate on location, property type, conditions of stay and overall satisfaction.
\n", "By evaluating top neighbourhoods based on average projected monthly revenue, it can be noted that coastal neighborhoods like Emerald Bay, Newport Beach, and Palos Verdes ranked high in revenue generation. The analysis revealed that these lucrative neighborhoods maintained a balance between demand and earnings, offering prices often ranging between \\$400 and \\$800. The dominance of entire homes in these neighborhoods highlighted a focus on group and family accommodations.\n", "
\n", "Listings by number of bedrooms showed prices increased significantly from 2 to 3+ bedrooms in the most expensive neighborhoods.\n", "We also analyzed the most frequently mentioned amenities in listings. By cross-referencing this with top neighborhoods, it was established that certain amenities were consistently popular. This underscores the importance of including these amenities to meet guest expectations and drive satisfaction.\n", "\n", "In summary, the analysis provided insights into top earning hosts, optimal property types, pricing, neighborhoods, amenities, and guest sentiment.
\n", "