Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 3310 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 136 |
Duplicate rows (%) | 4.1% |
Total size in memory | 197.3 KiB |
Average record size in memory | 61.0 B |
Variable types
DateTime | 2 |
---|---|
Numeric | 4 |
Categorical | 1 |
Dataset
Description | 경기도 성남시 CCTV 위치별 조도, 휘도 데이터를 제공합니다. 날짜, 시간, 위도, 경도, 조도, 휘도 데이터를 제공하고 있습니다. |
---|---|
Author | 경기도 성남시 |
URL | https://www.data.go.kr/data/15110584/fileData.do |
날짜(DATE) has constant value "" | Constant |
시간(TIME) has constant value "" | Constant |
달 위상(LUNAR_PHASE) has constant value "" | Constant |
Dataset has 136 (4.1%) duplicate rows | Duplicates |
위도(LATITUDE) is highly overall correlated with 경도(LONGITUDE) | High correlation |
경도(LONGITUDE) is highly overall correlated with 위도(LATITUDE) | High correlation |
조도(ILLUMINATION) is highly overall correlated with 휘도(BRIGHTNESS) | High correlation |
휘도(BRIGHTNESS) is highly overall correlated with 조도(ILLUMINATION) | High correlation |
Reproduction
Analysis started | 2023-12-12 20:38:55.219017 |
---|---|
Analysis finished | 2023-12-12 20:38:57.630632 |
Duration | 2.41 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
날짜(DATE)
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 26.0 KiB |
Minimum | 2022-09-19 00:00:00 |
---|---|
Maximum | 2022-09-19 00:00:00 |
시간(TIME)
Date
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 26.0 KiB |
Minimum | 2023-12-13 20:50:00 |
---|---|
Maximum | 2023-12-13 20:50:00 |
위도(LATITUDE)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 3053 |
---|---|
Distinct (%) | 92.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 37.417736 |
Minimum | 37.33406 |
---|---|
Maximum | 37.473342 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 29.2 KiB |
Quantile statistics
Minimum | 37.33406 |
---|---|
5-th percentile | 37.359156 |
Q1 | 37.39108 |
median | 37.43065 |
Q3 | 37.444984 |
95-th percentile | 37.458494 |
Maximum | 37.473342 |
Range | 0.1392819 |
Interquartile range (IQR) | 0.053903625 |
Descriptive statistics
Standard deviation | 0.03306843 |
---|---|
Coefficient of variation (CV) | 0.00088376353 |
Kurtosis | -0.9094428 |
Mean | 37.417736 |
Median Absolute Deviation (MAD) | 0.0228245 |
Skewness | -0.51659803 |
Sum | 123852.71 |
Variance | 0.0010935211 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
37.4062829 | 13 | 0.4% |
37.4022329 | 11 | 0.3% |
37.3704978 | 5 | 0.2% |
37.4281 | 4 | 0.1% |
37.3921196 | 4 | 0.1% |
37.3897387 | 4 | 0.1% |
37.3917731 | 4 | 0.1% |
37.41872 | 4 | 0.1% |
37.3995763 | 4 | 0.1% |
37.4443519 | 3 | 0.1% |
Other values (3043) | 3254 |
Value | Count | Frequency (%) |
37.33406 | 1 | |
37.33415 | 1 | |
37.3346918 | 2 | |
37.33524 | 1 | |
37.33606 | 1 | |
37.3373 | 1 | |
37.3375722 | 1 | |
37.337576 | 1 | |
37.3378233 | 1 | |
37.337944 | 1 |
Value | Count | Frequency (%) |
37.4733419 | 1 | |
37.4729854 | 1 | |
37.4724 | 1 | |
37.4723 | 1 | |
37.4719 | 2 | |
37.4717 | 1 | |
37.47165 | 1 | |
37.4713 | 1 | |
37.4712498 | 1 | |
37.4712 | 1 |
경도(LONGITUDE)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 3055 |
---|---|
Distinct (%) | 92.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 127.13026 |
Minimum | 127.05796 |
---|---|
Maximum | 127.1814 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 29.2 KiB |
Quantile statistics
Minimum | 127.05796 |
---|---|
5-th percentile | 127.08244 |
Q1 | 127.1133 |
median | 127.13223 |
Q3 | 127.14773 |
95-th percentile | 127.16623 |
Maximum | 127.1814 |
Range | 0.1234457 |
Interquartile range (IQR) | 0.0344335 |
Descriptive statistics
Standard deviation | 0.024711469 |
---|---|
Coefficient of variation (CV) | 0.00019437913 |
Kurtosis | -0.27572165 |
Mean | 127.13026 |
Median Absolute Deviation (MAD) | 0.0172737 |
Skewness | -0.46434356 |
Sum | 420801.14 |
Variance | 0.0006106567 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
127.1164218 | 13 | 0.4% |
127.0949281 | 11 | 0.3% |
127.1167369 | 5 | 0.2% |
127.1017312 | 4 | 0.1% |
127.1183055 | 4 | 0.1% |
127.0667121 | 4 | 0.1% |
127.1272 | 4 | 0.1% |
127.0752031 | 4 | 0.1% |
127.118613 | 3 | 0.1% |
127.105877 | 3 | 0.1% |
Other values (3045) | 3255 |
Value | Count | Frequency (%) |
127.057956 | 1 | |
127.058537 | 1 | |
127.0617751 | 1 | |
127.0621399 | 1 | |
127.0624901 | 1 | |
127.0625973 | 1 | |
127.0632668 | 1 | |
127.0633526 | 1 | |
127.0634879 | 1 | |
127.063617 | 1 |
Value | Count | Frequency (%) |
127.1814017 | 1 | |
127.180953 | 1 | |
127.18091 | 1 | |
127.1809082 | 1 | |
127.180471 | 1 | |
127.180371 | 1 | |
127.18037 | 1 | |
127.1801152 | 1 | |
127.1800133 | 1 | |
127.1794657 | 1 |
조도(ILLUMINATION)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 1750 |
---|---|
Distinct (%) | 52.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 22.772011 |
Minimum | 0.3 |
---|---|
Maximum | 200 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 29.2 KiB |
Quantile statistics
Minimum | 0.3 |
---|---|
5-th percentile | 3.725 |
Q1 | 9.37 |
median | 17.458869 |
Q3 | 30.246875 |
95-th percentile | 57.008214 |
Maximum | 200 |
Range | 199.7 |
Interquartile range (IQR) | 20.876875 |
Descriptive statistics
Standard deviation | 19.866605 |
---|---|
Coefficient of variation (CV) | 0.87241327 |
Kurtosis | 15.396616 |
Mean | 22.772011 |
Median Absolute Deviation (MAD) | 9.458869 |
Skewness | 2.8350829 |
Sum | 75375.356 |
Variance | 394.68197 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7.8 | 18 | 0.5% |
33.983333 | 13 | 0.4% |
0.5 | 9 | 0.3% |
40.2 | 9 | 0.3% |
12.8 | 8 | 0.2% |
11.4 | 8 | 0.2% |
19.155556 | 7 | 0.2% |
15.9 | 7 | 0.2% |
6.8 | 7 | 0.2% |
8.866667 | 7 | 0.2% |
Other values (1740) | 3217 |
Value | Count | Frequency (%) |
0.3 | 1 | < 0.1% |
0.4 | 4 | |
0.44 | 1 | < 0.1% |
0.45 | 1 | < 0.1% |
0.5 | 9 | |
0.6 | 2 | 0.1% |
0.65 | 1 | < 0.1% |
0.68 | 2 | 0.1% |
0.7 | 1 | < 0.1% |
0.744444 | 1 | < 0.1% |
Value | Count | Frequency (%) |
200.0 | 1 | < 0.1% |
189.5 | 6 | |
186.7 | 1 | < 0.1% |
177.0 | 1 | < 0.1% |
150.542857 | 1 | < 0.1% |
136.033333 | 1 | < 0.1% |
122.8 | 2 | 0.1% |
121.3 | 2 | 0.1% |
120.6 | 1 | < 0.1% |
112.825 | 1 | < 0.1% |
휘도(BRIGHTNESS)
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 1542 |
---|---|
Distinct (%) | 46.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.9796674 |
Minimum | 0.01 |
---|---|
Maximum | 9.99 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 29.2 KiB |
Quantile statistics
Minimum | 0.01 |
---|---|
5-th percentile | 0.14 |
Q1 | 0.35270825 |
median | 0.640667 |
Q3 | 1.259 |
95-th percentile | 2.9616923 |
Maximum | 9.99 |
Range | 9.98 |
Interquartile range (IQR) | 0.90629175 |
Descriptive statistics
Standard deviation | 1.0135182 |
---|---|
Coefficient of variation (CV) | 1.0345534 |
Kurtosis | 10.548584 |
Mean | 0.9796674 |
Median Absolute Deviation (MAD) | 0.365667 |
Skewness | 2.714467 |
Sum | 3242.6991 |
Variance | 1.0272192 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.225 | 23 | 0.7% |
0.73 | 22 | 0.7% |
0.52 | 14 | 0.4% |
0.59 | 14 | 0.4% |
0.14 | 11 | 0.3% |
0.415 | 11 | 0.3% |
0.62 | 10 | 0.3% |
0.6 | 10 | 0.3% |
0.23 | 9 | 0.3% |
0.38 | 9 | 0.3% |
Other values (1532) | 3177 |
Value | Count | Frequency (%) |
0.01 | 1 | < 0.1% |
0.015 | 1 | < 0.1% |
0.02 | 2 | 0.1% |
0.026 | 2 | 0.1% |
0.03 | 6 | |
0.038 | 2 | 0.1% |
0.04 | 8 | |
0.043333 | 1 | < 0.1% |
0.045 | 2 | 0.1% |
0.0475 | 1 | < 0.1% |
Value | Count | Frequency (%) |
9.99 | 1 | < 0.1% |
8.93 | 1 | < 0.1% |
7.85 | 4 | |
6.314286 | 2 | |
6.273333 | 1 | < 0.1% |
6.17 | 2 | |
6.082 | 1 | < 0.1% |
6.044615 | 4 | |
6.0375 | 1 | < 0.1% |
5.874286 | 1 | < 0.1% |
달 위상(LUNAR_PHASE)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 26.0 KiB |
45.33333333 |
---|
Length
Max length | 11 |
---|---|
Median length | 11 |
Mean length | 11 |
Min length | 11 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 45.33333333 |
---|---|
2nd row | 45.33333333 |
3rd row | 45.33333333 |
4th row | 45.33333333 |
5th row | 45.33333333 |
Common Values
Value | Count | Frequency (%) |
45.33333333 | 3310 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
45.33333333 | 3310 |
위도(LATITUDE) | 경도(LONGITUDE) | 조도(ILLUMINATION) | 휘도(BRIGHTNESS) | |
---|---|---|---|---|
위도(LATITUDE) | 1.000 | 0.753 | 0.227 | 0.209 |
경도(LONGITUDE) | 0.753 | 1.000 | 0.235 | 0.198 |
조도(ILLUMINATION) | 0.227 | 0.235 | 1.000 | 0.816 |
휘도(BRIGHTNESS) | 0.209 | 0.198 | 0.816 | 1.000 |
위도(LATITUDE) | 경도(LONGITUDE) | 조도(ILLUMINATION) | 휘도(BRIGHTNESS) | |
---|---|---|---|---|
위도(LATITUDE) | 1.000 | 0.618 | -0.004 | -0.011 |
경도(LONGITUDE) | 0.618 | 1.000 | 0.048 | -0.032 |
조도(ILLUMINATION) | -0.004 | 0.048 | 1.000 | 0.808 |
휘도(BRIGHTNESS) | -0.011 | -0.032 | 0.808 | 1.000 |
날짜(DATE) | 시간(TIME) | 위도(LATITUDE) | 경도(LONGITUDE) | 조도(ILLUMINATION) | 휘도(BRIGHTNESS) | 달 위상(LUNAR_PHASE) | |
---|---|---|---|---|---|---|---|
0 | 2022-09-19 | 20:50 | 37.4713 | 127.1354 | 136.033333 | 6.273333 | 45.333333 |
1 | 2022-09-19 | 20:50 | 37.471 | 127.1372 | 48.5 | 2.745 | 45.333333 |
2 | 2022-09-19 | 20:50 | 37.4712 | 127.1405 | 42.05 | 0.85 | 45.333333 |
3 | 2022-09-19 | 20:50 | 37.4707 | 127.1458 | 122.8 | 4.695 | 45.333333 |
4 | 2022-09-19 | 20:50 | 37.4696 | 127.1407 | 6.8 | 0.19 | 45.333333 |
5 | 2022-09-19 | 20:50 | 37.4699 | 127.1509 | 50.05 | 2.405 | 45.333333 |
6 | 2022-09-19 | 20:50 | 37.46735 | 127.1386 | 31.714286 | 1.675714 | 45.333333 |
7 | 2022-09-19 | 20:50 | 37.47118 | 127.13857 | 17.0 | 0.78 | 45.333333 |
8 | 2022-09-19 | 20:50 | 37.4685 | 127.138 | 16.06 | 1.0 | 45.333333 |
9 | 2022-09-19 | 20:50 | 37.4676 | 127.1386 | 31.714286 | 1.675714 | 45.333333 |
날짜(DATE) | 시간(TIME) | 위도(LATITUDE) | 경도(LONGITUDE) | 조도(ILLUMINATION) | 휘도(BRIGHTNESS) | 달 위상(LUNAR_PHASE) | |
---|---|---|---|---|---|---|---|
3300 | 2022-09-19 | 20:50 | 37.452607 | 127.153384 | 52.92 | 1.736 | 45.333333 |
3301 | 2022-09-19 | 20:50 | 37.455369 | 127.1511 | 77.633333 | 1.445 | 45.333333 |
3302 | 2022-09-19 | 20:50 | 37.452942 | 127.150548 | 29.733333 | 0.676667 | 45.333333 |
3303 | 2022-09-19 | 20:50 | 37.457571 | 127.152881 | 5.666667 | 0.048333 | 45.333333 |
3304 | 2022-09-19 | 20:50 | 37.459555 | 127.161394 | 26.45 | 0.63 | 45.333333 |
3305 | 2022-09-19 | 20:50 | 37.462584 | 127.167041 | 16.683333 | 0.661667 | 45.333333 |
3306 | 2022-09-19 | 20:50 | 37.46031 | 127.162838 | 5.525 | 0.3975 | 45.333333 |
3307 | 2022-09-19 | 20:50 | 37.457481 | 127.160111 | 15.08 | 0.548 | 45.333333 |
3308 | 2022-09-19 | 20:50 | 37.44939 | 127.163534 | 22.71 | 0.669 | 45.333333 |
3309 | 2022-09-19 | 20:50 | 37.448404 | 127.162797 | 9.314286 | 0.268571 | 45.333333 |
Most frequently occurring
날짜(DATE) | 시간(TIME) | 위도(LATITUDE) | 경도(LONGITUDE) | 조도(ILLUMINATION) | 휘도(BRIGHTNESS) | 달 위상(LUNAR_PHASE) | # duplicates | |
---|---|---|---|---|---|---|---|---|
84 | 2022-09-19 | 20:50 | 37.406283 | 127.116422 | 33.983333 | 0.73 | 45.333333 | 13 |
80 | 2022-09-19 | 20:50 | 37.402233 | 127.094928 | 7.8 | 0.225 | 45.333333 | 11 |
24 | 2022-09-19 | 20:50 | 37.370498 | 127.116737 | 6.466667 | 0.52 | 45.333333 | 5 |
43 | 2022-09-19 | 20:50 | 37.389739 | 127.101731 | 189.5 | 5.385 | 45.333333 | 4 |
57 | 2022-09-19 | 20:50 | 37.391773 | 127.075203 | 55.366667 | 2.036667 | 45.333333 | 4 |
58 | 2022-09-19 | 20:50 | 37.39212 | 127.066712 | 2.7 | 0.095 | 45.333333 | 4 |
76 | 2022-09-19 | 20:50 | 37.399576 | 127.118306 | 9.6 | 0.75 | 45.333333 | 4 |
87 | 2022-09-19 | 20:50 | 37.41872 | 127.1272 | 4.75 | 0.1725 | 45.333333 | 4 |
13 | 2022-09-19 | 20:50 | 37.358961 | 127.124492 | 2.933333 | 0.127778 | 45.333333 | 3 |
54 | 2022-09-19 | 20:50 | 37.391191 | 127.084791 | 55.82 | 1.866 | 45.333333 | 3 |