Dataset statistics
Number of variables | 8 |
---|---|
Number of observations | 438 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 30.5 KiB |
Average record size in memory | 71.3 B |
Variable types
Numeric | 6 |
---|---|
Categorical | 1 |
Text | 1 |
Dataset
Description | 고유번호,기준연도,행정동코드,행정동명,2007년사용량,2008년사용량,경도,위도 |
---|---|
Author | 서울특별시 |
URL | https://data.seoul.go.kr/dataList/OA-1343/S/1/datasetView.do |
기준연도 has constant value "" | Constant |
고유번호 is highly overall correlated with 행정동코드 and 1 other fields | High correlation |
행정동코드 is highly overall correlated with 고유번호 and 1 other fields | High correlation |
2007년사용량 is highly overall correlated with 2008년사용량 | High correlation |
2008년사용량 is highly overall correlated with 2007년사용량 | High correlation |
위도 is highly overall correlated with 고유번호 and 1 other fields | High correlation |
고유번호 has unique values | Unique |
행정동코드 has unique values | Unique |
경도 has unique values | Unique |
위도 has unique values | Unique |
2007년사용량 has 325 (74.2%) zeros | Zeros |
2008년사용량 has 322 (73.5%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-11 08:59:38.183238 |
---|---|
Analysis finished | 2023-12-11 08:59:43.181334 |
Duration | 5 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
고유번호
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 438 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 219.5 |
Minimum | 1 |
---|---|
Maximum | 438 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 22.85 |
Q1 | 110.25 |
median | 219.5 |
Q3 | 328.75 |
95-th percentile | 416.15 |
Maximum | 438 |
Range | 437 |
Interquartile range (IQR) | 218.5 |
Descriptive statistics
Standard deviation | 126.58396 |
---|---|
Coefficient of variation (CV) | 0.57669232 |
Kurtosis | -1.2 |
Mean | 219.5 |
Median Absolute Deviation (MAD) | 109.5 |
Skewness | 0 |
Sum | 96141 |
Variance | 16023.5 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7 | 1 | 0.2% |
353 | 1 | 0.2% |
290 | 1 | 0.2% |
286 | 1 | 0.2% |
283 | 1 | 0.2% |
289 | 1 | 0.2% |
282 | 1 | 0.2% |
281 | 1 | 0.2% |
232 | 1 | 0.2% |
322 | 1 | 0.2% |
Other values (428) | 428 |
Value | Count | Frequency (%) |
1 | 1 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 1 | |
6 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
10 | 1 |
Value | Count | Frequency (%) |
438 | 1 | |
437 | 1 | |
436 | 1 | |
435 | 1 | |
434 | 1 | |
433 | 1 | |
432 | 1 | |
431 | 1 | |
430 | 1 | |
429 | 1 |
기준연도
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 3.6 KiB |
2008 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2008 |
---|---|
2nd row | 2008 |
3rd row | 2008 |
4th row | 2008 |
5th row | 2008 |
Common Values
Value | Count | Frequency (%) |
2008 | 438 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2008 | 438 |
행정동코드
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 438 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1113545.7 |
Minimum | 1101053 |
---|---|
Maximum | 1125074 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 1101053 |
---|---|
5-th percentile | 1102057.9 |
Q1 | 1107061.2 |
median | 1114060.5 |
Q3 | 1120072.8 |
95-th percentile | 1124075.3 |
Maximum | 1125074 |
Range | 24021 |
Interquartile range (IQR) | 13011.5 |
Descriptive statistics
Standard deviation | 7427.8897 |
---|---|
Coefficient of variation (CV) | 0.0066704851 |
Kurtosis | -1.2748023 |
Mean | 1113545.7 |
Median Absolute Deviation (MAD) | 6996 |
Skewness | -0.052988859 |
Sum | 4.87733 × 108 |
Variance | 55173546 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1102052 | 1 | 0.2% |
1123051 | 1 | 0.2% |
1121054 | 1 | 0.2% |
1117069 | 1 | 0.2% |
1120054 | 1 | 0.2% |
1122055 | 1 | 0.2% |
1120053 | 1 | 0.2% |
1114072 | 1 | 0.2% |
1114061 | 1 | 0.2% |
1119062 | 1 | 0.2% |
Other values (428) | 428 |
Value | Count | Frequency (%) |
1101053 | 1 | |
1101054 | 1 | |
1101055 | 1 | |
1101056 | 1 | |
1101057 | 1 | |
1101058 | 1 | |
1101060 | 1 | |
1101061 | 1 | |
1101063 | 1 | |
1101064 | 1 |
Value | Count | Frequency (%) |
1125074 | 1 | |
1125073 | 1 | |
1125072 | 1 | |
1125071 | 1 | |
1125070 | 1 | |
1125067 | 1 | |
1125066 | 1 | |
1125065 | 1 | |
1125063 | 1 | |
1125061 | 1 |
행정동명
Text
Distinct | 437 |
---|---|
Distinct (%) | 99.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 3.6 KiB |
Value | Count | Frequency (%) |
신사동 | 2 | 0.5% |
상도4동 | 1 | 0.2% |
공덕동 | 1 | 0.2% |
수궁동 | 1 | 0.2% |
상도2동 | 1 | 0.2% |
잠원동 | 1 | 0.2% |
상도1동 | 1 | 0.2% |
성산1동 | 1 | 0.2% |
염리동 | 1 | 0.2% |
양평2동 | 1 | 0.2% |
Other values (427) | 427 |
Most occurring characters
Value | Count | Frequency (%) |
동 | 439 | |
2 | 101 | 6.0% |
1 | 101 | 6.0% |
3 | 52 | 3.1% |
신 | 42 | 2.5% |
4 | 30 | 1.8% |
가 | 24 | 1.4% |
계 | 19 | 1.1% |
곡 | 18 | 1.1% |
화 | 16 | 1.0% |
Other values (177) | 835 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 1354 | |
Decimal Number | 314 | 18.7% |
Other Punctuation | 9 | 0.5% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
동 | 439 | |
신 | 42 | 3.1% |
가 | 24 | 1.8% |
계 | 19 | 1.4% |
곡 | 18 | 1.3% |
화 | 16 | 1.2% |
상 | 16 | 1.2% |
방 | 16 | 1.2% |
정 | 16 | 1.2% |
성 | 16 | 1.2% |
Other values (166) | 732 |
Decimal Number
Value | Count | Frequency (%) |
2 | 101 | |
1 | 101 | |
3 | 52 | |
4 | 30 | 9.6% |
5 | 11 | 3.5% |
6 | 8 | 2.5% |
7 | 6 | 1.9% |
8 | 3 | 1.0% |
9 | 1 | 0.3% |
0 | 1 | 0.3% |
Other Punctuation
Value | Count | Frequency (%) |
. | 9 |
Most occurring scripts
Value | Count | Frequency (%) |
Hangul | 1354 | |
Common | 323 | 19.3% |
Most frequent character per script
Hangul
Value | Count | Frequency (%) |
동 | 439 | |
신 | 42 | 3.1% |
가 | 24 | 1.8% |
계 | 19 | 1.4% |
곡 | 18 | 1.3% |
화 | 16 | 1.2% |
상 | 16 | 1.2% |
방 | 16 | 1.2% |
정 | 16 | 1.2% |
성 | 16 | 1.2% |
Other values (166) | 732 |
Common
Value | Count | Frequency (%) |
2 | 101 | |
1 | 101 | |
3 | 52 | |
4 | 30 | 9.3% |
5 | 11 | 3.4% |
. | 9 | 2.8% |
6 | 8 | 2.5% |
7 | 6 | 1.9% |
8 | 3 | 0.9% |
9 | 1 | 0.3% |
Most occurring blocks
Value | Count | Frequency (%) |
Hangul | 1354 | |
ASCII | 323 | 19.3% |
Most frequent character per block
Hangul
Value | Count | Frequency (%) |
동 | 439 | |
신 | 42 | 3.1% |
가 | 24 | 1.8% |
계 | 19 | 1.4% |
곡 | 18 | 1.3% |
화 | 16 | 1.2% |
상 | 16 | 1.2% |
방 | 16 | 1.2% |
정 | 16 | 1.2% |
성 | 16 | 1.2% |
Other values (166) | 732 |
ASCII
Value | Count | Frequency (%) |
2 | 101 | |
1 | 101 | |
3 | 52 | |
4 | 30 | 9.3% |
5 | 11 | 3.4% |
. | 9 | 2.8% |
6 | 8 | 2.5% |
7 | 6 | 1.9% |
8 | 3 | 0.9% |
9 | 1 | 0.3% |
2007년사용량
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 114 |
---|---|
Distinct (%) | 26.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 10474.456 |
Minimum | 0 |
---|---|
Maximum | 203553.2 |
Zeros | 325 |
Zeros (%) | 74.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 762.075 |
95-th percentile | 63353.47 |
Maximum | 203553.2 |
Range | 203553.2 |
Interquartile range (IQR) | 762.075 |
Descriptive statistics
Standard deviation | 25629.818 |
---|---|
Coefficient of variation (CV) | 2.4468878 |
Kurtosis | 16.115005 |
Mean | 10474.456 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 3.5307757 |
Sum | 4587811.6 |
Variance | 6.5688755 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 325 | |
21185.5 | 1 | 0.2% |
18205.4 | 1 | 0.2% |
20934.3 | 1 | 0.2% |
41730.3 | 1 | 0.2% |
89038.3 | 1 | 0.2% |
46652.1 | 1 | 0.2% |
23295.0 | 1 | 0.2% |
50390.2 | 1 | 0.2% |
14388.4 | 1 | 0.2% |
Other values (104) | 104 | 23.7% |
Value | Count | Frequency (%) |
0.0 | 325 | |
193.4 | 1 | 0.2% |
458.5 | 1 | 0.2% |
516.3 | 1 | 0.2% |
844.0 | 1 | 0.2% |
845.7 | 1 | 0.2% |
2036.3 | 1 | 0.2% |
2228.9 | 1 | 0.2% |
4889.9 | 1 | 0.2% |
5266.6 | 1 | 0.2% |
Value | Count | Frequency (%) |
203553.2 | 1 | |
191024.0 | 1 | |
133120.7 | 1 | |
123813.7 | 1 | |
106250.8 | 1 | |
102988.7 | 1 | |
98252.8 | 1 | |
97237.2 | 1 | |
94072.9 | 1 | |
93923.5 | 1 |
2008년사용량
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 117 |
---|---|
Distinct (%) | 26.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11037.428 |
Minimum | 0 |
---|---|
Maximum | 211015.9 |
Zeros | 322 |
Zeros (%) | 73.5% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 1731.925 |
95-th percentile | 65729.615 |
Maximum | 211015.9 |
Range | 211015.9 |
Interquartile range (IQR) | 1731.925 |
Descriptive statistics
Standard deviation | 26121.704 |
---|---|
Coefficient of variation (CV) | 2.3666478 |
Kurtosis | 15.864685 |
Mean | 11037.428 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 3.4427309 |
Sum | 4834393.3 |
Variance | 6.823434 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 322 | |
4852.4 | 1 | 0.2% |
2009.5 | 1 | 0.2% |
17708.0 | 1 | 0.2% |
20494.9 | 1 | 0.2% |
42785.5 | 1 | 0.2% |
86467.7 | 1 | 0.2% |
46279.6 | 1 | 0.2% |
24864.8 | 1 | 0.2% |
56106.6 | 1 | 0.2% |
Other values (107) | 107 | 24.4% |
Value | Count | Frequency (%) |
0.0 | 322 | |
136.7 | 1 | 0.2% |
227.0 | 1 | 0.2% |
401.9 | 1 | 0.2% |
432.2 | 1 | 0.2% |
585.1 | 1 | 0.2% |
899.2 | 1 | 0.2% |
2009.5 | 1 | 0.2% |
2115.2 | 1 | 0.2% |
4852.4 | 1 | 0.2% |
Value | Count | Frequency (%) |
211015.9 | 1 | |
194738.3 | 1 | |
127257.2 | 1 | |
125331.7 | 1 | |
105779.4 | 1 | |
101331.3 | 1 | |
95960.1 | 1 | |
94883.9 | 1 | |
94479.8 | 1 | |
92550.4 | 1 |
경도
Real number (ℝ)
UNIQUE
 
Distinct | 438 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 126.99566 |
Minimum | 126.79474 |
---|---|
Maximum | 127.17257 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 126.79474 |
---|---|
5-th percentile | 126.84818 |
Q1 | 126.92419 |
median | 127.01051 |
Q3 | 127.06216 |
95-th percentile | 127.12797 |
Maximum | 127.17257 |
Range | 0.3778334 |
Interquartile range (IQR) | 0.13797765 |
Descriptive statistics
Standard deviation | 0.085035585 |
---|---|
Coefficient of variation (CV) | 0.0006695944 |
Kurtosis | -0.84416474 |
Mean | 126.99566 |
Median Absolute Deviation (MAD) | 0.06347975 |
Skewness | -0.20532013 |
Sum | 55624.101 |
Variance | 0.0072310508 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
126.9746802 | 1 | 0.2% |
127.0201823 | 1 | 0.2% |
126.959249 | 1 | 0.2% |
126.8253891 | 1 | 0.2% |
126.9416175 | 1 | 0.2% |
127.0128992 | 1 | 0.2% |
126.9543551 | 1 | 0.2% |
126.9108057 | 1 | 0.2% |
126.9472006 | 1 | 0.2% |
126.8946775 | 1 | 0.2% |
Other values (428) | 428 |
Value | Count | Frequency (%) |
126.7947412 | 1 | |
126.8055663 | 1 | |
126.8129904 | 1 | |
126.8153977 | 1 | |
126.8253891 | 1 | |
126.8258043 | 1 | |
126.8282326 | 1 | |
126.8299898 | 1 | |
126.8313103 | 1 | |
126.8344994 | 1 |
Value | Count | Frequency (%) |
127.1725746 | 1 | |
127.1650498 | 1 | |
127.1622577 | 1 | |
127.1557966 | 1 | |
127.1545404 | 1 | |
127.1516416 | 1 | |
127.1491472 | 1 | |
127.1489329 | 1 | |
127.1485334 | 1 | |
127.1473638 | 1 |
위도
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 438 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 37.550548 |
Minimum | 37.440609 |
---|---|
Maximum | 37.685297 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 37.440609 |
---|---|
5-th percentile | 37.474466 |
Q1 | 37.506891 |
median | 37.549624 |
Q3 | 37.584754 |
95-th percentile | 37.646762 |
Maximum | 37.685297 |
Range | 0.244688 |
Interquartile range (IQR) | 0.07786345 |
Descriptive statistics
Standard deviation | 0.052721623 |
---|---|
Coefficient of variation (CV) | 0.0014040174 |
Kurtosis | -0.55488934 |
Mean | 37.550548 |
Median Absolute Deviation (MAD) | 0.03906035 |
Skewness | 0.32431151 |
Sum | 16447.14 |
Variance | 0.0027795695 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
37.5644921 | 1 | 0.2% |
37.5258447 | 1 | 0.2% |
37.4895535 | 1 | 0.2% |
37.4987947 | 1 | 0.2% |
37.5032617 | 1 | 0.2% |
37.5180129 | 1 | 0.2% |
37.4999435 | 1 | 0.2% |
37.5623625 | 1 | 0.2% |
37.5501423 | 1 | 0.2% |
37.5396988 | 1 | 0.2% |
Other values (428) | 428 |
Value | Count | Frequency (%) |
37.4406086 | 1 | |
37.4489992 | 1 | |
37.4506941 | 1 | |
37.452285 | 1 | |
37.453328 | 1 | |
37.4541092 | 1 | |
37.4543585 | 1 | |
37.4595548 | 1 | |
37.4614434 | 1 | |
37.4617099 | 1 |
Value | Count | Frequency (%) |
37.6852966 | 1 | |
37.6835121 | 1 | |
37.6815251 | 1 | |
37.676222 | 1 | |
37.668601 | 1 | |
37.6676017 | 1 | |
37.6661992 | 1 | |
37.6651501 | 1 | |
37.6633451 | 1 | |
37.6626127 | 1 |
고유번호 | 행정동코드 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|
고유번호 | 1.000 | 0.894 | 0.147 | 0.133 | 0.776 | 0.754 |
행정동코드 | 0.894 | 1.000 | 0.284 | 0.273 | 0.895 | 0.878 |
2007년사용량 | 0.147 | 0.284 | 1.000 | 0.990 | 0.221 | 0.227 |
2008년사용량 | 0.133 | 0.273 | 0.990 | 1.000 | 0.193 | 0.198 |
경도 | 0.776 | 0.895 | 0.221 | 0.193 | 1.000 | 0.453 |
위도 | 0.754 | 0.878 | 0.227 | 0.198 | 0.453 | 1.000 |
고유번호 | 행정동코드 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|
고유번호 | 1.000 | 0.906 | 0.204 | 0.205 | -0.046 | -0.602 |
행정동코드 | 0.906 | 1.000 | 0.304 | 0.310 | 0.009 | -0.630 |
2007년사용량 | 0.204 | 0.304 | 1.000 | 0.985 | 0.142 | -0.098 |
2008년사용량 | 0.205 | 0.310 | 0.985 | 1.000 | 0.135 | -0.090 |
경도 | -0.046 | 0.009 | 0.142 | 0.135 | 1.000 | 0.215 |
위도 | -0.602 | -0.630 | -0.098 | -0.090 | 0.215 | 1.000 |
고유번호 | 기준연도 | 행정동코드 | 행정동명 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|---|---|
0 | 7 | 2008 | 1102052 | 소공동 | 458.5 | 432.2 | 126.97468 | 37.564492 |
1 | 9 | 2008 | 1101057 | 무악동 | 0.0 | 0.0 | 126.958278 | 37.577329 |
2 | 14 | 2008 | 1104054 | 마장동 | 0.0 | 0.0 | 127.04029 | 37.567482 |
3 | 15 | 2008 | 1104058 | 응봉동 | 0.0 | 0.0 | 127.03459 | 37.550568 |
4 | 16 | 2008 | 1105054 | 군자동 | 0.0 | 0.0 | 127.073514 | 37.55337 |
5 | 17 | 2008 | 1105063 | 광장동 | 0.0 | 0.0 | 127.103556 | 37.547503 |
6 | 3 | 2008 | 1103063 | 이촌1동 | 106250.8 | 105779.4 | 126.970211 | 37.517545 |
7 | 8 | 2008 | 1102065 | 신당5동 | 0.0 | 0.0 | 127.021399 | 37.563164 |
8 | 6 | 2008 | 1102067 | 황학동 | 0.0 | 0.0 | 127.020584 | 37.568559 |
9 | 11 | 2008 | 1109074 | 우이동 | 0.0 | 0.0 | 126.998999 | 37.661931 |
고유번호 | 기준연도 | 행정동코드 | 행정동명 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|---|---|
428 | 438 | 2008 | 1125061 | 천호1동 | 0.0 | 0.0 | 127.137564 | 37.546579 |
429 | 408 | 2008 | 1124060 | 오금동 | 38982.5 | 38328.3 | 127.134071 | 37.503719 |
430 | 410 | 2008 | 1124063 | 석촌동 | 0.0 | 0.0 | 127.104114 | 37.502851 |
431 | 411 | 2008 | 1120070 | 신대방2동 | 0.0 | 0.0 | 126.922217 | 37.494006 |
432 | 412 | 2008 | 1120071 | 흑석동 | 0.0 | 0.0 | 126.96465 | 37.505401 |
433 | 413 | 2008 | 1120072 | 노량진1동 | 0.0 | 0.0 | 126.95046 | 37.512746 |
434 | 414 | 2008 | 1101061 | 종로1.2.3.4가동 | 0.0 | 0.0 | 126.989274 | 37.57777 |
435 | 418 | 2008 | 1117065 | 개봉3동 | 0.0 | 0.0 | 126.853885 | 37.486412 |
436 | 419 | 2008 | 1117054 | 구로3동 | 0.0 | 0.0 | 126.894794 | 37.485275 |
437 | 422 | 2008 | 1122066 | 양재1동 | 0.0 | 0.0 | 127.023697 | 37.470474 |