Overview

Dataset info

Number of variables13
Number of observations2999
Missing cells139 (0.4%)
Duplicate rows1 (< 0.1%)
Total size in memory304.7 KiB
Average record size in memory104.0 B

Variables types

Numeric4
Categorical9
Boolean0
Date0
URL0
Text (Unique)0
Rejected0
Unsupported0

Warnings

Dataset has 1 (< 0.1%) duplicate rows Warning
地铁 has a high cardinality: 210 distinct values Warning
地铁 has 102 (3.4%) missing values Missing
小区 has a high cardinality: 1776 distinct values Warning
标题 has a high cardinality: 2995 distinct values Warning
楼层 has a high cardinality: 170 distinct values Warning

Variables

区域
Categorical

Distinct count13
Unique (%)0.4%
Missing (%)0.1%
Missing (n)3
朝阳区
850
海淀区
412
丰台区
398
Other values (9)
1336
ValueCountFrequency (%) 
朝阳区 850 28.3%
 
海淀区 412 13.7%
 
丰台区 398 13.3%
 
昌平区 280 9.3%
 
大兴区 255 8.5%
 
西城区 202 6.7%
 
通州区 159 5.3%
 
石景山区 137 4.6%
 
房山区 94 3.1%
 
东城区 90 3.0%
 
Other values (2) 119 4.0%
 
Max length4
Mean length3.060020007
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

单价(元)
Numeric

Distinct count2921
Unique (%)97.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean61631.85495
Minimum15834
Maximum168577
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum15834
5-th percentile32524.4
Q143738.5
Median55581
Q373834.5
95-th percentile111163.7
Maximum168577
Range152743
Interquartile range30096

Descriptive statistics

Standard deviation24674.50995
Coef of variation0.4003531934
Kurtosis1.53717113
Mean61631.85495
MAD19120.51776
Skewness1.205653286
Sum184833933
Variance608831441.1
Memory size23.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 15834. 24685.5 29785. 35502.5 57812.5 ... 76878.5 96996.5 114819. 143116. 168577. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
96695 3 0.1%
 
36917 3 0.1%
 
48456 2 0.1%
 
43914 2 0.1%
 
56150 2 0.1%
 
40059 2 0.1%
 
41826 2 0.1%
 
48928 2 0.1%
 
53270 2 0.1%
 
82977 2 0.1%
 
Other values (2911) 2977 99.3%
 

Minimum 5 values

ValueCountFrequency (%) 
15834 1 < 0.1%
 
17564 1 < 0.1%
 
18083 1 < 0.1%
 
18502 1 < 0.1%
 
18949 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
168577 1 < 0.1%
 
168190 1 < 0.1%
 
164557 1 < 0.1%
 
162163 1 < 0.1%
 
159255 1 < 0.1%
 

地铁
Categorical

Distinct count210
Unique (%)7.0%
Missing (%)3.4%
Missing (n)102
回龙观
 
111
北苑
 
72
望京
 
65
Other values (206)
2649
(Missing)
 
102
ValueCountFrequency (%) 
回龙观 111 3.7%
 
北苑 72 2.4%
 
望京 65 2.2%
 
长阳 60 2.0%
 
天通苑 52 1.7%
 
常营 49 1.6%
 
清河 47 1.6%
 
青塔 42 1.4%
 
苹果园 42 1.4%
 
鲁谷 40 1.3%
 
Other values (199) 2317 77.3%
 
(Missing) 102 3.4%
 
Max length8
Mean length2.711903968
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

小区
Categorical

Distinct count1776
Unique (%)59.2%
Missing (%)0.0%
Missing (n)0
翠成馨园
 
17
新龙城
 
16
荣丰2008
 
11
Other values (1773)
2955
ValueCountFrequency (%) 
翠成馨园 17 0.6%
 
新龙城 16 0.5%
 
荣丰2008 11 0.4%
 
广安﹒康馨家园 10 0.3%
 
加州水郡三期 10 0.3%
 
芍药居北里 10 0.3%
 
大方居 9 0.3%
 
海特花园小区 9 0.3%
 
天通西苑二区 9 0.3%
 
北郡嘉源 8 0.3%
 
Other values (1766) 2890 96.4%
 
Max length13
Mean length5.898966322
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

年份
Numeric

Distinct count54
Unique (%)1.8%
Missing (%)0.4%
Missing (n)11
Infinite (%)0.0%
Infinite (n)0
Mean2000.111446
Minimum1950
Maximum2016
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1950
5-th percentile1983
Q11994
Median2002
Q32007
95-th percentile2013
Maximum2016
Range66
Interquartile range13

Descriptive statistics

Standard deviation9.266899321
Coef of variation0.004633191485
Kurtosis0.6474788447
Mean2000.111446
MAD7.531465218
Skewness-0.7679286465
Sum5976333
Variance85.87542302
Memory size23.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2004 191 6.4%
 
2005 164 5.5%
 
2003 149 5.0%
 
2006 146 4.9%
 
2000 127 4.2%
 
2010 120 4.0%
 
2009 119 4.0%
 
2008 118 3.9%
 
2007 105 3.5%
 
2012 99 3.3%
 
Other values (43) 1650 55.0%
 

Minimum 5 values

ValueCountFrequency (%) 
1950 1 < 0.1%
 
1955 2 0.1%
 
1958 2 0.1%
 
1960 1 < 0.1%
 
1964 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2016 13 0.4%
 
2015 21 0.7%
 
2014 56 1.9%
 
2013 66 2.2%
 
2012 99 3.3%
 

总价(万元)
Numeric

Distinct count580
Unique (%)19.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean510.0503501
Minimum135
Maximum3599
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum135
5-th percentile229
Q1328
Median435
Q3595
95-th percentile1050
Maximum3599
Range3464
Interquartile range267

Descriptive statistics

Standard deviation297.8913168
Coef of variation0.5840429611
Kurtosis16.06076167
Mean510.0503501
MAD198.3992526
Skewness3.03763991
Sum1529641
Variance88739.23662
Memory size23.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 135. 183.5 224.5 261.5 264.5 ... 1005. 1305. 1774. 2715. 3599. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
435 32 1.1%
 
320 29 1.0%
 
370 28 0.9%
 
365 27 0.9%
 
330 25 0.8%
 
450 25 0.8%
 
420 24 0.8%
 
355 24 0.8%
 
350 23 0.8%
 
510 23 0.8%
 
Other values (570) 2739 91.3%
 

Minimum 5 values

ValueCountFrequency (%) 
135 1 < 0.1%
 
138 1 < 0.1%
 
152 1 < 0.1%
 
155 1 < 0.1%
 
156 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3599 1 < 0.1%
 
3299 1 < 0.1%
 
2800 1 < 0.1%
 
2630 1 < 0.1%
 
2620 1 < 0.1%
 

户型
Categorical

Distinct count16
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
2室1厅
1560
3室1厅
459
1室1厅
425
Other values (13)
555
ValueCountFrequency (%) 
2室1厅 1560 52.0%
 
3室1厅 459 15.3%
 
1室1厅 425 14.2%
 
3室2厅 227 7.6%
 
2室2厅 209 7.0%
 
1室0厅 46 1.5%
 
4室2厅 34 1.1%
 
5室2厅 12 0.4%
 
4室1厅 12 0.4%
 
1室2厅 6 0.2%
 
Other values (6) 9 0.3%
 
Max length4
Mean length4
Min length4
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

朝向
Categorical

Distinct count25
Unique (%)0.8%
Missing (%)0.0%
Missing (n)0
南北
1376
496
西南
 
221
Other values (22)
906
ValueCountFrequency (%) 
南北 1376 45.9%
 
496 16.5%
 
西南 221 7.4%
 
东南 214 7.1%
 
东西 113 3.8%
 
98 3.3%
 
西 86 2.9%
 
西北 72 2.4%
 
东北 67 2.2%
 
东南北 66 2.2%
 
Other values (15) 190 6.3%
 
Max length4
Mean length1.817939313
Min length1
Contains charsFalse
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

标题
Categorical

Distinct count2995
Unique (%)99.9%
Missing (%)0.0%
Missing (n)0
科技园 四环内 正规一居室 随时看房
 
2
三环内,精装两居,采光充足,人车分流!
 
2
西环里小区,商品房满五唯一,明厨明卫
 
2
Other values (2992)
2993
ValueCountFrequency (%) 
科技园 四环内 正规一居室 随时看房 2 0.1%
 
三环内,精装两居,采光充足,人车分流! 2 0.1%
 
西环里小区,商品房满五唯一,明厨明卫 2 0.1%
 
南北两居 主卧落地窗 中间层 不临街 业主诚售 2 0.1%
 
奥森地产 观景四居 两梯两户装修保持好 楼栋位置好 1 < 0.1%
 
此房满五唯一视野好,采光充足,南北通透 1 < 0.1%
 
中间楼层 税费少 南北通透 价格合适 诚意出售 不临街 1 < 0.1%
 
必看好房!电梯板楼,满五唯一,带车位,临近地铁 1 < 0.1%
 
中直社区 满五年央产房 视野开阔 采光充足 交通便利 1 < 0.1%
 
满五年公房 精装修 可以拎包入住 业主随时签约 1 < 0.1%
 
Other values (2985) 2985 99.5%
 
Max length31
Mean length20.85128376
Min length10
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

楼层
Categorical

Distinct count170
Unique (%)5.7%
Missing (%)0.0%
Missing (n)0
中楼层|共6层
 
333
顶层|共6层
 
180
低楼层|共6层
 
174
Other values (167)
2312
ValueCountFrequency (%) 
中楼层|共6层 333 11.1%
 
顶层|共6层 180 6.0%
 
低楼层|共6层 174 5.8%
 
高楼层|共6层 157 5.2%
 
底层|共6层 111 3.7%
 
中楼层|共5层 85 2.8%
 
中楼层|共7层 67 2.2%
 
中楼层|共18层 61 2.0%
 
高楼层|共18层 54 1.8%
 
中楼层|共16层 46 1.5%
 
Other values (160) 1731 57.7%
 
Max length8
Mean length7.280093364
Min length2
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

装修
Categorical

Distinct count4
Unique (%)0.1%
Missing (%)0.3%
Missing (n)9
精装
1578
简装
1340
毛坯
 
72
(Missing)
 
9
ValueCountFrequency (%) 
精装 1578 52.6%
 
简装 1340 44.7%
 
毛坯 72 2.4%
 
(Missing) 9 0.3%
 
Max length3
Mean length2.003001
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

面积(平米)
Numeric

Distinct count2455
Unique (%)81.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean84.21528843
Minimum24.03
Maximum420.95
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum24.03
5-th percentile47.239
Q160.26
Median78.13
Q396.49
95-th percentile144.428
Maximum420.95
Range396.92
Interquartile range36.23

Descriptive statistics

Standard deviation33.38300406
Coef of variation0.3964007567
Kurtosis9.93185499
Mean84.21528843
MAD24.06229733
Skewness2.15016707
Sum252561.65
Variance1114.42496
Memory size23.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 24.03 35.705 41.285 51.415 54.58 ... 149.05 172.295 198.985 240.785 420.95 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
56.9 6 0.2%
 
56.1 6 0.2%
 
89.04 5 0.2%
 
57.7 5 0.2%
 
54.6 5 0.2%
 
58.2 5 0.2%
 
57.2 5 0.2%
 
96.06 4 0.1%
 
60.9 4 0.1%
 
57.73 4 0.1%
 
Other values (2445) 2950 98.4%
 

Minimum 5 values

ValueCountFrequency (%) 
24.03 1 < 0.1%
 
28.37 1 < 0.1%
 
30.25 1 < 0.1%
 
31.94 1 < 0.1%
 
32.23 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
420.95 1 < 0.1%
 
363.35 1 < 0.1%
 
319.52 1 < 0.1%
 
313.56 1 < 0.1%
 
306.85 1 < 0.1%
 

风格
Categorical

Distinct count4
Unique (%)0.1%
Missing (%)0.5%
Missing (n)14
板楼
1808
塔楼
675
板塔结合
502
(Missing)
 
14
ValueCountFrequency (%) 
板楼 1808 60.3%
 
塔楼 675 22.5%
 
板塔结合 502 16.7%
 
(Missing) 14 0.5%
 
Max length4
Mean length2.339446482
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Correlations

Missing values

Sample

First rows

区域单价(元)地铁小区年份总价(万元)户型朝向标题楼层装修面积(平米)风格
0东城区108768安定门青年湖西里1993.08203室1厅南北东城 青年湖西里 田字格三居 中间层中楼层|共5层简装75.39板楼
1西城区164557六铺炕黄寺大街24号院1995.06501室1厅黄寺大街24号院,正规一居室,低楼层|共6层简装39.50板楼
2丰台区46827看丹桥韩庄子三里2001.03152室1厅韩庄子三里 2室1厅 315万底层|共6层精装67.27板楼
3NaN99207NaN魏公村8号院1997.07502室1厅西南魏公村8号院 2室1厅 750万高楼层|共14层简装75.60板塔结合
4海淀区67433清河宝盛里2000.03581室1厅海淀宝盛里 紧邻奥森 只有契税 首付友好 刚需一居高楼层|共6层简装53.09板楼
5海淀区87482北太平庄花园路18号院1998.05802室1厅南北西花园路18号院 2室1厅 580万高楼层|共12层简装66.30板塔结合
6通州区45313北苑西马庄园2001.01881室1厅通州北苑 全南中间楼层正规一居中楼层|共6层简装41.49板楼
7丰台区53329宋家庄横一条1992.02982室1厅南北满五年已购公房 南北通透 购房成本低中楼层|共5层精装55.88板楼
8顺义区32670NaN港馨家园东区2010.03202室1厅南北满五唯一 电梯商品房好楼层 格局南北双通透 楼龄新高楼层|共8层精装97.95板楼
9丰台区48050蒲黄榆南三环中路15号院1992.02983室1厅西南三环里刘家窑地铁西南三居室 满两年原值334万高楼层|共7层简装62.02板楼

Last rows

区域单价(元)地铁小区年份总价(万元)户型朝向标题楼层装修面积(平米)风格
2989石景山区50174苹果园苹果园小区三区1999.03482室2厅南北苹果园三区小白楼 中间楼层,南北通透,99年房龄中楼层|共6层精装69.36板楼
2990西城区99595木樨地西便门西里1983.05902室1厅西东满五年唯一公房 户型方正 诚心出售高楼层|共20层精装59.24塔楼
2991朝阳区64569双井华腾园2003.07103室1厅东北华腾园经典小三居,满两年,交通便利低楼层|共24层精装109.96塔楼
2992东城区92042安定门安外西河沿1983.04952室1厅东北东城 安定门 2居室 带8.5平米阳台 有电梯 满五年公房中楼层|共11层简装53.78板楼
2993大兴区34696枣园首开康乃馨城2012.02251室1厅康乃馨城,满五唯一的南向,大一居低楼层|共9层简装64.85板楼
2994昌平区31748北七家温泉花园B区1997.02752室2厅南北满五唯一 南北通透 采光充足 看房随时中楼层|共7层简装86.62板楼
2995丰台区49141青塔同馨家园2012.02831室1厅西业主诚售!满五年家庭唯一住房,楼层佳户型方正!高楼层|共16层精装57.59板楼
2996昌平区49942回龙观慧华苑1995.02581室1厅南北总价低,通风好,诚心出售,看房随时底层|共6层简装51.66板楼
2997朝阳区68467三元桥曙光里1998.04162室1厅南北三元桥两居室 1998年 带客厅 南北通透 看房方便高楼层|共6层简装60.76板楼
2998丰台区52326玉泉营新村二里1987.02251室1厅全南向一居室 户型方正 满五唯一 总价低 视野好中楼层|共6层精装43.00板楼