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-1335/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 |
Reproduction
Analysis started | 2023-12-11 08:03:08.617526 |
---|---|
Analysis finished | 2023-12-11 08:03:12.535806 |
Duration | 3.92 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 (%) |
3 | 1 | 0.2% |
233 | 1 | 0.2% |
305 | 1 | 0.2% |
303 | 1 | 0.2% |
302 | 1 | 0.2% |
281 | 1 | 0.2% |
279 | 1 | 0.2% |
278 | 1 | 0.2% |
243 | 1 | 0.2% |
239 | 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 (%) |
1103058 | 1 | 0.2% |
1114078 | 1 | 0.2% |
1121081 | 1 | 0.2% |
1117070 | 1 | 0.2% |
1123075 | 1 | 0.2% |
1115062 | 1 | 0.2% |
1115059 | 1 | 0.2% |
1115058 | 1 | 0.2% |
1116052 | 1 | 0.2% |
1112068 | 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% |
구로1동 | 1 | 0.2% |
공덕동 | 1 | 0.2% |
가리봉동 | 1 | 0.2% |
수서동 | 1 | 0.2% |
신월6동 | 1 | 0.2% |
신월3동 | 1 | 0.2% |
신월2동 | 1 | 0.2% |
등촌1동 | 1 | 0.2% |
수색동 | 1 | 0.2% |
Other values (427) | 427 |
Most occurring characters
Value | Count | Frequency (%) |
동 | 439 | |
1 | 101 | 6.0% |
2 | 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 (%) |
1 | 101 | |
2 | 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 (%) |
1 | 101 | |
2 | 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 (%) |
1 | 101 | |
2 | 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
 
Distinct | 437 |
---|---|
Distinct (%) | 99.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 97.806861 |
Minimum | 7.689708 |
---|---|
Maximum | 831.76975 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 7.689708 |
---|---|
5-th percentile | 29.565866 |
Q1 | 50.59604 |
median | 68.728149 |
Q3 | 105.82203 |
95-th percentile | 257.35967 |
Maximum | 831.76975 |
Range | 824.08005 |
Interquartile range (IQR) | 55.225989 |
Descriptive statistics
Standard deviation | 94.714691 |
---|---|
Coefficient of variation (CV) | 0.96838493 |
Kurtosis | 19.452535 |
Mean | 97.806861 |
Median Absolute Deviation (MAD) | 22.90389 |
Skewness | 3.746478 |
Sum | 42839.405 |
Variance | 8970.8726 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
57.489527 | 2 | 0.5% |
20.814328 | 1 | 0.2% |
127.471271 | 1 | 0.2% |
44.60397 | 1 | 0.2% |
80.302857 | 1 | 0.2% |
28.442686 | 1 | 0.2% |
38.918728 | 1 | 0.2% |
45.785454 | 1 | 0.2% |
97.621055 | 1 | 0.2% |
46.796878 | 1 | 0.2% |
Other values (427) | 427 |
Value | Count | Frequency (%) |
7.689708 | 1 | |
8.222036 | 1 | |
12.637248 | 1 | |
13.391452 | 1 | |
13.518065 | 1 | |
14.357689 | 1 | |
16.753378 | 1 | |
17.042226 | 1 | |
18.183449 | 1 | |
20.814328 | 1 |
Value | Count | Frequency (%) |
831.769753 | 1 | |
811.389233 | 1 | |
548.405825 | 1 | |
547.700436 | 1 | |
494.563072 | 1 | |
494.54089 | 1 | |
467.512156 | 1 | |
458.031508 | 1 | |
434.279556 | 1 | |
423.513379 | 1 |
2008년사용량
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 437 |
---|---|
Distinct (%) | 99.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 100.37198 |
Minimum | 7.425011 |
---|---|
Maximum | 862.38961 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 4.0 KiB |
Quantile statistics
Minimum | 7.425011 |
---|---|
5-th percentile | 30.730494 |
Q1 | 51.001925 |
median | 70.178257 |
Q3 | 107.37879 |
95-th percentile | 267.52692 |
Maximum | 862.38961 |
Range | 854.9646 |
Interquartile range (IQR) | 56.376867 |
Descriptive statistics
Standard deviation | 97.057949 |
---|---|
Coefficient of variation (CV) | 0.96698255 |
Kurtosis | 19.821936 |
Mean | 100.37198 |
Median Absolute Deviation (MAD) | 23.534489 |
Skewness | 3.7555051 |
Sum | 43962.925 |
Variance | 9420.2454 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
59.389609 | 2 | 0.5% |
21.459975 | 1 | 0.2% |
129.049927 | 1 | 0.2% |
46.063641 | 1 | 0.2% |
81.075794 | 1 | 0.2% |
29.105478 | 1 | 0.2% |
40.666991 | 1 | 0.2% |
46.951724 | 1 | 0.2% |
100.65776 | 1 | 0.2% |
46.981828 | 1 | 0.2% |
Other values (427) | 427 |
Value | Count | Frequency (%) |
7.425011 | 1 | |
8.429381 | 1 | |
14.025424 | 1 | |
14.903593 | 1 | |
15.349535 | 1 | |
16.982302 | 1 | |
17.382672 | 1 | |
17.516867 | 1 | |
19.178458 | 1 | |
21.459975 | 1 |
Value | Count | Frequency (%) |
862.389607 | 1 | |
839.363475 | 1 | |
571.652817 | 1 | |
532.941004 | 1 | |
498.36079 | 1 | |
493.660601 | 1 | |
473.315272 | 1 | |
451.500206 | 1 | |
447.570895 | 1 | |
424.742285 | 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.84416473 |
Mean | 126.99566 |
Median Absolute Deviation (MAD) | 0.06347975 |
Skewness | -0.20532014 |
Sum | 55624.101 |
Variance | 0.0072310508 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
126.960713 | 1 | 0.2% |
126.9529527 | 1 | 0.2% |
126.920547 | 1 | 0.2% |
126.888207 | 1 | 0.2% |
127.1015292 | 1 | 0.2% |
126.8417608 | 1 | 0.2% |
126.8282326 | 1 | 0.2% |
126.846252 | 1 | 0.2% |
126.859834 | 1 | 0.2% |
126.89328 | 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.32431153 |
Sum | 16447.14 |
Variance | 0.0027795695 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
37.5436889 | 1 | 0.2% |
37.550399 | 1 | 0.2% |
37.4703208 | 1 | 0.2% |
37.4829137 | 1 | 0.2% |
37.485455 | 1 | 0.2% |
37.51656 | 1 | 0.2% |
37.532608 | 1 | 0.2% |
37.5224464 | 1 | 0.2% |
37.5560676 | 1 | 0.2% |
37.5865769 | 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.910 | 0.109 | 0.123 | 0.758 | 0.756 |
행정동코드 | 0.910 | 1.000 | 0.043 | 0.000 | 0.895 | 0.878 |
2007년사용량 | 0.109 | 0.043 | 1.000 | 0.997 | 0.000 | 0.000 |
2008년사용량 | 0.123 | 0.000 | 0.997 | 1.000 | 0.000 | 0.000 |
경도 | 0.758 | 0.895 | 0.000 | 0.000 | 1.000 | 0.453 |
위도 | 0.756 | 0.878 | 0.000 | 0.000 | 0.453 | 1.000 |
고유번호 | 행정동코드 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|
고유번호 | 1.000 | 0.907 | 0.079 | 0.084 | -0.013 | -0.568 |
행정동코드 | 0.907 | 1.000 | 0.123 | 0.130 | 0.009 | -0.630 |
2007년사용량 | 0.079 | 0.123 | 1.000 | 0.997 | 0.005 | -0.150 |
2008년사용량 | 0.084 | 0.130 | 0.997 | 1.000 | 0.004 | -0.157 |
경도 | -0.013 | 0.009 | 0.005 | 0.004 | 1.000 | 0.215 |
위도 | -0.568 | -0.630 | -0.150 | -0.157 | 0.215 | 1.000 |
고유번호 | 기준연도 | 행정동코드 | 행정동명 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|---|---|
0 | 3 | 2008 | 1103058 | 효창동 | 20.814328 | 21.459975 | 126.960713 | 37.543689 |
1 | 6 | 2008 | 1101071 | 숭인2동 | 72.809621 | 74.027617 | 127.019527 | 37.574927 |
2 | 8 | 2008 | 1102052 | 소공동 | 423.513379 | 424.742285 | 126.97468 | 37.564492 |
3 | 9 | 2008 | 1105062 | 구의3동 | 133.85004 | 131.664698 | 127.096142 | 37.535739 |
4 | 103 | 2008 | 1111059 | 하계2동 | 36.930365 | 37.577989 | 127.064602 | 37.635166 |
5 | 7 | 2008 | 1102064 | 신당4동 | 47.600798 | 50.101068 | 127.015277 | 37.55663 |
6 | 5 | 2008 | 1103063 | 이촌1동 | 78.776724 | 79.079995 | 126.970211 | 37.517545 |
7 | 10 | 2008 | 1109074 | 우이동 | 51.867977 | 52.548616 | 126.998999 | 37.661931 |
8 | 11 | 2008 | 1110064 | 도봉1동 | 67.514091 | 68.453704 | 127.027025 | 37.685297 |
9 | 12 | 2008 | 1111056 | 공릉2동 | 158.930946 | 165.70109 | 127.091858 | 37.631411 |
고유번호 | 기준연도 | 행정동코드 | 행정동명 | 2007년사용량 | 2008년사용량 | 경도 | 위도 | |
---|---|---|---|---|---|---|---|---|
428 | 402 | 2008 | 1125065 | 성내1동 | 76.47508 | 76.809205 | 127.125487 | 37.528454 |
429 | 404 | 2008 | 1124059 | 오륜동 | 75.20928 | 81.636248 | 127.128998 | 37.517569 |
430 | 405 | 2008 | 1124060 | 오금동 | 122.379257 | 124.80993 | 127.134071 | 37.503719 |
431 | 408 | 2008 | 1125053 | 명일1동 | 72.925659 | 72.658741 | 127.145279 | 37.549573 |
432 | 409 | 2008 | 1125067 | 성내3동 | 88.867987 | 89.051932 | 127.133676 | 37.528412 |
433 | 410 | 2008 | 1124063 | 석촌동 | 160.149134 | 158.103925 | 127.104114 | 37.502851 |
434 | 412 | 2008 | 1124066 | 가락1동 | 108.872008 | 107.456593 | 127.107744 | 37.49517 |
435 | 413 | 2008 | 1124067 | 가락2동 | 96.375492 | 96.978021 | 127.131344 | 37.496279 |
436 | 435 | 2008 | 1108081 | 성북동 | 75.10811 | 77.239237 | 126.9974 | 37.595353 |
437 | 438 | 2008 | 1114071 | 연남동 | 47.055426 | 48.724297 | 126.922474 | 37.562494 |