| \n", " | id | \n", "NAME | \n", "host id | \n", "host_identity_verified | \n", "host name | \n", "neighbourhood group | \n", "neighbourhood | \n", "lat | \n", "long | \n", "country | \n", "country code | \n", "instant_bookable | \n", "cancellation_policy | \n", "room type | \n", "Construction year | \n", "price | \n", "service fee | \n", "minimum nights | \n", "number of reviews | \n", "last review | \n", "reviews per month | \n", "review rate number | \n", "calculated host listings count | \n", "availability 365 | \n", "house_rules | \n", "license | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1001254 | \n", "Clean & quiet apt home by the park | \n", "80014485718 | \n", "unconfirmed | \n", "Madaline | \n", "Brooklyn | \n", "Kensington | \n", "40.65 | \n", "-73.97 | \n", "United States | \n", "US | \n", "False | \n", "strict | \n", "Private room | \n", "2020.00 | \n", "$966 | \n", "$193 | \n", "10.00 | \n", "9.00 | \n", "10/19/2021 | \n", "0.21 | \n", "4.00 | \n", "6.00 | \n", "286.00 | \n", "Clean up and treat the home the way you'd like... | \n", "NaN | \n", "
| 1 | \n", "1002102 | \n", "Skylit Midtown Castle | \n", "52335172823 | \n", "verified | \n", "Jenna | \n", "Manhattan | \n", "Midtown | \n", "40.75 | \n", "-73.98 | \n", "United States | \n", "US | \n", "False | \n", "moderate | \n", "Entire home/apt | \n", "2007.00 | \n", "$142 | \n", "$28 | \n", "30.00 | \n", "45.00 | \n", "5/21/2022 | \n", "0.38 | \n", "4.00 | \n", "2.00 | \n", "228.00 | \n", "Pet friendly but please confirm with me if the... | \n", "NaN | \n", "
| 2 | \n", "1002403 | \n", "THE VILLAGE OF HARLEM....NEW YORK ! | \n", "78829239556 | \n", "NaN | \n", "Elise | \n", "Manhattan | \n", "Harlem | \n", "40.81 | \n", "-73.94 | \n", "United States | \n", "US | \n", "True | \n", "flexible | \n", "Private room | \n", "2005.00 | \n", "$620 | \n", "$124 | \n", "3.00 | \n", "0.00 | \n", "NaN | \n", "NaN | \n", "5.00 | \n", "1.00 | \n", "352.00 | \n", "I encourage you to use my kitchen, cooking and... | \n", "NaN | \n", "
| 3 | \n", "1002755 | \n", "NaN | \n", "85098326012 | \n", "unconfirmed | \n", "Garry | \n", "Brooklyn | \n", "Clinton Hill | \n", "40.69 | \n", "-73.96 | \n", "United States | \n", "US | \n", "True | \n", "moderate | \n", "Entire home/apt | \n", "2005.00 | \n", "$368 | \n", "$74 | \n", "30.00 | \n", "270.00 | \n", "7/5/2019 | \n", "4.64 | \n", "4.00 | \n", "1.00 | \n", "322.00 | \n", "NaN | \n", "NaN | \n", "
| 4 | \n", "1003689 | \n", "Entire Apt: Spacious Studio/Loft by central park | \n", "92037596077 | \n", "verified | \n", "Lyndon | \n", "Manhattan | \n", "East Harlem | \n", "40.80 | \n", "-73.94 | \n", "United States | \n", "US | \n", "False | \n", "moderate | \n", "Entire home/apt | \n", "2009.00 | \n", "$204 | \n", "$41 | \n", "10.00 | \n", "9.00 | \n", "11/19/2018 | \n", "0.10 | \n", "3.00 | \n", "1.00 | \n", "289.00 | \n", "Please no smoking in the house, porch or on th... | \n", "NaN | \n", "
| \n", " | Missing Count | \n", "Missing % | \n", "
|---|---|---|
| license | \n", "102597 | \n", "100.00 | \n", "
| house_rules | \n", "52131 | \n", "50.81 | \n", "
| last review | \n", "15893 | \n", "15.49 | \n", "
| reviews per month | \n", "15879 | \n", "15.48 | \n", "
| country | \n", "532 | \n", "0.52 | \n", "
| availability 365 | \n", "448 | \n", "0.44 | \n", "
| minimum nights | \n", "409 | \n", "0.40 | \n", "
| host name | \n", "406 | \n", "0.40 | \n", "
| review rate number | \n", "326 | \n", "0.32 | \n", "
| calculated host listings count | \n", "319 | \n", "0.31 | \n", "
| host_identity_verified | \n", "289 | \n", "0.28 | \n", "
| service fee | \n", "273 | \n", "0.27 | \n", "
| NAME | \n", "250 | \n", "0.24 | \n", "
| price | \n", "247 | \n", "0.24 | \n", "
| Construction year | \n", "214 | \n", "0.21 | \n", "
| number of reviews | \n", "183 | \n", "0.18 | \n", "
| country code | \n", "131 | \n", "0.13 | \n", "
| instant_bookable | \n", "105 | \n", "0.10 | \n", "
| cancellation_policy | \n", "76 | \n", "0.07 | \n", "
| neighbourhood group | \n", "29 | \n", "0.03 | \n", "
| neighbourhood | \n", "16 | \n", "0.02 | \n", "
| long | \n", "8 | \n", "0.01 | \n", "
| lat | \n", "8 | \n", "0.01 | \n", "
| \n", " | lat | \n", "long | \n", "instant_bookable | \n", "construction_year | \n", "price | \n", "service_fee | \n", "minimum_nights | \n", "number_of_reviews | \n", "reviews_per_month | \n", "review_rate_number | \n", "calculated_host_listings_count | \n", "availability_365 | \n", "has_rules | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "68803.00 | \n", "
| mean | \n", "40.73 | \n", "-73.95 | \n", "0.00 | \n", "2012.49 | \n", "624.50 | \n", "124.90 | \n", "8.32 | \n", "27.97 | \n", "1.18 | \n", "3.32 | \n", "8.98 | \n", "152.04 | \n", "0.47 | \n", "
| std | \n", "0.06 | \n", "0.05 | \n", "0.00 | \n", "5.76 | \n", "331.75 | \n", "66.35 | \n", "17.27 | \n", "52.02 | \n", "1.72 | \n", "1.26 | \n", "34.85 | \n", "132.61 | \n", "0.50 | \n", "
| min | \n", "40.50 | \n", "-74.25 | \n", "0.00 | \n", "2003.00 | \n", "50.00 | \n", "10.00 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "1.00 | \n", "1.00 | \n", "0.00 | \n", "0.00 | \n", "
| 25% | \n", "40.69 | \n", "-73.98 | \n", "0.00 | \n", "2008.00 | \n", "338.00 | \n", "68.00 | \n", "2.00 | \n", "1.00 | \n", "0.10 | \n", "2.00 | \n", "1.00 | \n", "18.00 | \n", "0.00 | \n", "
| 50% | \n", "40.72 | \n", "-73.95 | \n", "0.00 | \n", "2012.00 | \n", "624.00 | \n", "125.00 | \n", "3.00 | \n", "7.00 | \n", "0.52 | \n", "3.00 | \n", "1.00 | \n", "125.00 | \n", "0.00 | \n", "
| 75% | \n", "40.76 | \n", "-73.93 | \n", "0.00 | \n", "2017.00 | \n", "912.00 | \n", "182.00 | \n", "6.00 | \n", "30.00 | \n", "1.74 | \n", "4.00 | \n", "3.00 | \n", "281.00 | \n", "1.00 | \n", "
| max | \n", "40.92 | \n", "-73.71 | \n", "0.00 | \n", "2022.00 | \n", "1200.00 | \n", "240.00 | \n", "365.00 | \n", "1024.00 | \n", "90.00 | \n", "5.00 | \n", "332.00 | \n", "365.00 | \n", "1.00 | \n", "