{ "cells": [ { "cell_type": "code", "execution_count": 2, "id": "5a2b479d", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 3, "id": "f203e4ac", "metadata": {}, "outputs": [], "source": [ "listing = pd.read_csv(\"data\\listings.csv\")" ] }, { "cell_type": "code", "execution_count": 4, "id": "bec320e6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\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", "2797791 | \n", "https://www.airbnb.com/rooms/2797791 | \n", "20220621060517 | \n", "2022-06-21 | \n", "Beijing Great Wall Escape | \n", "A perfect escape only 2 hours away from Beijin... | \n", "Located in a small village at the base of the ... | \n", "https://a0.muscache.com/pictures/da7d00b7-37f0... | \n", "14311129 | \n", "https://www.airbnb.com/users/show/14311129 | \n", "... | \n", "4.92 | \n", "4.91 | \n", "4.30 | \n", "NaN | \n", "f | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "0.57 | \n", "
1 | \n", "4990531 | \n", "https://www.airbnb.com/rooms/4990531 | \n", "20220621060517 | \n", "2022-06-21 | \n", "Monthly Discounted- Orchid's Residence Expansi... | \n", "Begin the day in the tiled rain shower and wit... | \n", "The neighborhood is very safe and full of loca... | \n", "https://a0.muscache.com/pictures/ebd3ed91-02e2... | \n", "25729513 | \n", "https://www.airbnb.com/users/show/25729513 | \n", "... | \n", "4.88 | \n", "4.88 | \n", "4.76 | \n", "NaN | \n", "f | \n", "10 | \n", "6 | \n", "4 | \n", "0 | \n", "0.22 | \n", "
2 | \n", "6207089 | \n", "https://www.airbnb.com/rooms/6207089 | \n", "20220621060517 | \n", "2022-06-21 | \n", "雍和宫地铁附近崇文门东单南二环精装双床房 | \n", "位于北京市丰台区方庄物美大卖场旁(地铁5号线蒲黄榆站楼上)。交通非常便利:距离南二环玉蜓桥南... | \n", "公寓北部是龙潭湖公园,西北是天坛公园、北京游乐场、北京教学植物园、北京国际网球中心、南面是中... | \n", "https://a0.muscache.com/pictures/83597610/e003... | \n", "32187257 | \n", "https://www.airbnb.com/users/show/32187257 | \n", "... | \n", "5.00 | \n", "5.00 | \n", "5.00 | \n", "NaN | \n", "t | \n", "9 | \n", "9 | \n", "0 | \n", "0 | \n", "0.12 | \n", "
3 | \n", "6223892 | \n", "https://www.airbnb.com/rooms/6223892 | \n", "20220621060517 | \n", "2022-06-21 | \n", "北京家诚-方庄蒲黄榆南站地铁情侣观景房,舒适大床,可做饭,新中式风 | \n", "房间位于地铁五号线蒲黄榆站楼上,楼下是方庄物美大卖场,房间设施免费使用,35寸超大液晶电视,... | \n", "美食:海底捞火锅方庄店、全聚德烤鸭店,方庄时代广场<br />娱乐:博纳国际电影院 | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "32187257 | \n", "https://www.airbnb.com/users/show/32187257 | \n", "... | \n", "5.00 | \n", "5.00 | \n", "5.00 | \n", "NaN | \n", "t | \n", "9 | \n", "9 | \n", "0 | \n", "0 | \n", "0.23 | \n", "
4 | \n", "6232044 | \n", "https://www.airbnb.com/rooms/6232044 | \n", "20220621060517 | \n", "2022-06-21 | \n", "同仁协和医院东单五号线地铁旁家庭双床房 | \n", "位于北京市丰台区方庄物美大卖场旁(地铁5号线蒲黄榆站楼上)。交通非常便利:距离南二环玉蜓桥南... | \n", "北部是龙潭湖公园,西北是天坛公园、北京游乐场、北京教学植物园、北京国际网球中心、南面是中央音... | \n", "https://a0.muscache.com/pictures/miso/Hosting-... | \n", "32187257 | \n", "https://www.airbnb.com/users/show/32187257 | \n", "... | \n", "5.00 | \n", "5.00 | \n", "5.00 | \n", "NaN | \n", "t | \n", "9 | \n", "9 | \n", "0 | \n", "0 | \n", "0.17 | \n", "
5 rows × 74 columns
\n", "\n", " | price | \n", "minimum_nights | \n", "number_of_reviews | \n", "calculated_host_listings_count | \n", "availability_365 | \n", "
---|---|---|---|---|---|
count | \n", "6657.000000 | \n", "6657.000000 | \n", "6657.000000 | \n", "6657.000000 | \n", "6657.000000 | \n", "
mean | \n", "1687.660358 | \n", "1.180562 | \n", "5.289620 | \n", "9.447349 | \n", "28.368034 | \n", "
std | \n", "2080.966851 | \n", "4.053299 | \n", "15.005025 | \n", "14.538637 | \n", "13.946877 | \n", "
min | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "1.000000 | \n", "0.000000 | \n", "
25% | \n", "374.000000 | \n", "1.000000 | \n", "0.000000 | \n", "2.000000 | \n", "20.000000 | \n", "
50% | \n", "848.000000 | \n", "1.000000 | \n", "1.000000 | \n", "6.000000 | \n", "37.000000 | \n", "
75% | \n", "2400.000000 | \n", "1.000000 | \n", "4.000000 | \n", "10.000000 | \n", "38.000000 | \n", "
max | \n", "25091.000000 | \n", "300.000000 | \n", "490.000000 | \n", "100.000000 | \n", "38.000000 | \n", "
\n", " | name | \n", "
---|---|
host_name | \n", "\n", " |
李 | \n", "108 | \n", "
Wohkoon者行孙青年旅舍什刹海店 | \n", "57 | \n", "
广安门 | \n", "51 | \n", "
辉 | \n", "45 | \n", "
静 | \n", "40 | \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", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6332 | \n", "43369350 | \n", "https://www.airbnb.com/rooms/43369350 | \n", "20220621060517 | \n", "2022-06-21 | \n", "野三坡百里峡村北山舍民宿,自助烧烤,露天游泳池 | \n", "村北山舍民宿第二个院子\"右舍\"是以田园风光的格调设计完成,整体面积大约300平米。本小院拥有... | \n", "首都环线G95高速野三坡都衙出口,右转三分钟即到。高德地图直接导航村北山舍民宿 | \n", "https://a0.muscache.com/pictures/a6a25260-6da6... | \n", "277558727 | \n", "https://www.airbnb.com/users/show/277558727 | \n", "... | \n", "3.0 | \n", "3.0 | \n", "3.0 | \n", "NaN | \n", "f | \n", "3 | \n", "3 | \n", "0 | \n", "0 | \n", "0.09 | \n", "
1 rows × 74 columns
\n", "\n", " | 区域 | \n", "最高价格 | \n", "最低价格 | \n", "中位数价格 | \n", "25%价格 | \n", "75%价格 | \n", "
---|---|---|---|---|---|---|
0 | \n", "怀柔区 / Huairou | \n", "20686.0 | \n", "42.0 | \n", "342.0 | \n", "432.00 | \n", "654.00 | \n", "
1 | \n", "东城区 | \n", "3366.0 | \n", "70.0 | \n", "338.0 | \n", "88.00 | \n", "398.00 | \n", "
2 | \n", "丰台区 / Fengtai | \n", "4998.0 | \n", "25.0 | \n", "254.0 | \n", "361.00 | \n", "559.00 | \n", "
3 | \n", "朝阳区 / Chaoyang | \n", "10541.0 | \n", "61.0 | \n", "994.0 | \n", "1709.50 | \n", "2109.50 | \n", "
4 | \n", "密云县 / Miyun | \n", "25091.0 | \n", "151.0 | \n", "2568.0 | \n", "2359.00 | \n", "3639.00 | \n", "
5 | \n", "房山区 | \n", "24214.0 | \n", "131.0 | \n", "1866.0 | \n", "2393.75 | \n", "3200.00 | \n", "
6 | \n", "西城区 | \n", "18056.0 | \n", "118.0 | \n", "1981.0 | \n", "2709.00 | \n", "3418.00 | \n", "
7 | \n", "大兴区 / Daxing | \n", "15000.0 | \n", "67.0 | \n", "999.0 | \n", "2287.50 | \n", "2575.50 | \n", "
8 | \n", "延庆县 / Yanqing | \n", "22000.0 | \n", "76.0 | \n", "2097.5 | \n", "2424.75 | \n", "3223.00 | \n", "
9 | \n", "顺义区 / Shunyi | \n", "9999.0 | \n", "34.0 | \n", "458.0 | \n", "227.25 | \n", "571.25 | \n", "
10 | \n", "通州区 / Tongzhou | \n", "5434.0 | \n", "120.0 | \n", "458.0 | \n", "189.00 | \n", "557.00 | \n", "
11 | \n", "昌平区 | \n", "10120.0 | \n", "239.0 | \n", "389.5 | \n", "120.00 | \n", "493.00 | \n", "
12 | \n", "门头沟区 / Mentougou | \n", "12800.0 | \n", "112.0 | \n", "527.0 | \n", "168.00 | \n", "639.00 | \n", "
13 | \n", "平谷区 / Pinggu | \n", "9598.0 | \n", "19.0 | \n", "359.5 | \n", "523.75 | \n", "747.75 | \n", "
14 | \n", "海淀区 | \n", "20000.0 | \n", "150.0 | \n", "1550.5 | \n", "2359.00 | \n", "3000.00 | \n", "
15 | \n", "石景山区 | \n", "12800.0 | \n", "168.0 | \n", "2028.0 | \n", "2331.00 | \n", "3000.00 | \n", "