Dataset statistics
Number of variables | 5 |
---|---|
Number of observations | 2738 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 628 |
Duplicate rows (%) | 22.9% |
Total size in memory | 117.8 KiB |
Average record size in memory | 44.0 B |
Variable types
Categorical | 2 |
---|---|
Numeric | 3 |
Dataset
Description | 서울특별시 서대문구 CCTV 위치별 조도, 휘도 데이터를 제공합니다. 날짜, 시간, 위도, 경도, 조도 데이터를 제공하고 있습니다. |
---|---|
Author | 서울특별시 서대문구 |
URL | https://www.data.go.kr/data/15109208/fileData.do |
날짜 has constant value "" | Constant |
시간 has constant value "" | Constant |
Dataset has 628 (22.9%) duplicate rows | Duplicates |
Reproduction
Analysis started | 2023-12-12 09:32:51.371756 |
---|---|
Analysis finished | 2023-12-12 09:32:52.960474 |
Duration | 1.59 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
날짜
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 21.5 KiB |
20220926 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20220926 |
---|---|
2nd row | 20220926 |
3rd row | 20220926 |
4th row | 20220926 |
5th row | 20220926 |
Common Values
Value | Count | Frequency (%) |
20220926 | 2738 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20220926 | 2738 |
시간
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 21.5 KiB |
20:17 |
---|
Length
Max length | 5 |
---|---|
Median length | 5 |
Mean length | 5 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20:17 |
---|---|
2nd row | 20:17 |
3rd row | 20:17 |
4th row | 20:17 |
5th row | 20:17 |
Common Values
Value | Count | Frequency (%) |
20:17 | 2738 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20:17 | 2738 |
위도
Real number (ℝ)
Distinct | 804 |
---|---|
Distinct (%) | 29.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 37.577165 |
Minimum | 37.555796 |
---|---|
Maximum | 37.6058 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 24.2 KiB |
Quantile statistics
Minimum | 37.555796 |
---|---|
5-th percentile | 37.557857 |
Q1 | 37.567329 |
median | 37.578182 |
Q3 | 37.58532 |
95-th percentile | 37.598233 |
Maximum | 37.6058 |
Range | 0.05000432 |
Interquartile range (IQR) | 0.01799137 |
Descriptive statistics
Standard deviation | 0.012287576 |
---|---|
Coefficient of variation (CV) | 0.00032699582 |
Kurtosis | -0.83048595 |
Mean | 37.577165 |
Median Absolute Deviation (MAD) | 0.00875089 |
Skewness | 0.067341773 |
Sum | 102886.28 |
Variance | 0.00015098452 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
37.57890074 | 28 | 1.0% |
37.56185447 | 20 | 0.7% |
37.55723615 | 16 | 0.6% |
37.58537284 | 14 | 0.5% |
37.574108 | 12 | 0.4% |
37.58438976 | 12 | 0.4% |
37.5581842 | 11 | 0.4% |
37.59477112 | 10 | 0.4% |
37.56788241 | 10 | 0.4% |
37.580063 | 10 | 0.4% |
Other values (794) | 2595 |
Value | Count | Frequency (%) |
37.55579603 | 1 | < 0.1% |
37.55598695 | 4 | |
37.556147 | 1 | < 0.1% |
37.55630715 | 4 | |
37.5566748 | 1 | < 0.1% |
37.55687376 | 2 | 0.1% |
37.55693278 | 8 | |
37.5569452 | 5 | |
37.55695796 | 4 | |
37.55704283 | 6 |
Value | Count | Frequency (%) |
37.60580035 | 2 | 0.1% |
37.605378 | 3 | |
37.60523087 | 4 | |
37.60381265 | 4 | |
37.60346911 | 1 | < 0.1% |
37.60334171 | 3 | |
37.60307318 | 1 | < 0.1% |
37.603019 | 4 | |
37.60262693 | 3 | |
37.60238579 | 5 |
경도
Real number (ℝ)
Distinct | 801 |
---|---|
Distinct (%) | 29.3% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 126.93562 |
Minimum | 126.90346 |
---|---|
Maximum | 126.96691 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 24.2 KiB |
Quantile statistics
Minimum | 126.90346 |
---|---|
5-th percentile | 126.91083 |
Q1 | 126.92425 |
median | 126.93514 |
Q3 | 126.94728 |
95-th percentile | 126.96014 |
Maximum | 126.96691 |
Range | 0.0634455 |
Interquartile range (IQR) | 0.023028 |
Descriptive statistics
Standard deviation | 0.014905667 |
---|---|
Coefficient of variation (CV) | 0.00011742698 |
Kurtosis | -0.83568052 |
Mean | 126.93562 |
Median Absolute Deviation (MAD) | 0.0115754 |
Skewness | -0.069119564 |
Sum | 347549.73 |
Variance | 0.0002221789 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
126.9177559 | 28 | 1.0% |
126.954875 | 20 | 0.7% |
126.9328742 | 16 | 0.6% |
126.9389115 | 14 | 0.5% |
126.9439175 | 12 | 0.4% |
126.918545 | 12 | 0.4% |
126.952262 | 11 | 0.4% |
126.919415 | 10 | 0.4% |
126.9429481 | 10 | 0.4% |
126.9468728 | 10 | 0.4% |
Other values (791) | 2595 |
Value | Count | Frequency (%) |
126.90346 | 1 | < 0.1% |
126.9038642 | 4 | |
126.9047879 | 2 | 0.1% |
126.9049853 | 2 | 0.1% |
126.905255 | 4 | |
126.905281 | 5 | |
126.9054524 | 4 | |
126.905502 | 3 | |
126.9059805 | 4 | |
126.90628 | 4 |
Value | Count | Frequency (%) |
126.9669055 | 3 | |
126.9667707 | 4 | |
126.9661652 | 2 | 0.1% |
126.9659613 | 3 | |
126.965737 | 5 | |
126.965155 | 7 | |
126.965138 | 3 | |
126.9644372 | 5 | |
126.9643946 | 3 | |
126.9643682 | 4 |
조도
Real number (ℝ)
Distinct | 339 |
---|---|
Distinct (%) | 12.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 34.774543 |
Minimum | 0.1 |
---|---|
Maximum | 132.9 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 24.2 KiB |
Quantile statistics
Minimum | 0.1 |
---|---|
5-th percentile | 12.3 |
Q1 | 23.2 |
median | 31.2 |
Q3 | 43.5 |
95-th percentile | 68.5 |
Maximum | 132.9 |
Range | 132.8 |
Interquartile range (IQR) | 20.3 |
Descriptive statistics
Standard deviation | 17.683843 |
---|---|
Coefficient of variation (CV) | 0.5085284 |
Kurtosis | 2.4516979 |
Mean | 34.774543 |
Median Absolute Deviation (MAD) | 10 |
Skewness | 1.1437458 |
Sum | 95212.7 |
Variance | 312.7183 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20.9 | 41 | 1.5% |
16.4 | 34 | 1.2% |
31.1 | 32 | 1.2% |
13.5 | 31 | 1.1% |
32.2 | 29 | 1.1% |
32.6 | 28 | 1.0% |
30.0 | 27 | 1.0% |
25.8 | 26 | 0.9% |
28.7 | 26 | 0.9% |
21.2 | 25 | 0.9% |
Other values (329) | 2439 |
Value | Count | Frequency (%) |
0.1 | 4 | 0.1% |
1.4 | 3 | 0.1% |
2.8 | 22 | |
3.9 | 3 | 0.1% |
4.2 | 6 | 0.2% |
4.4 | 4 | 0.1% |
4.8 | 4 | 0.1% |
5.3 | 3 | 0.1% |
5.7 | 2 | 0.1% |
5.8 | 4 | 0.1% |
Value | Count | Frequency (%) |
132.9 | 4 | 0.1% |
127.4 | 3 | 0.1% |
96.3 | 8 | |
94.0 | 4 | 0.1% |
93.0 | 3 | 0.1% |
90.0 | 14 | |
83.8 | 3 | 0.1% |
81.6 | 5 | 0.2% |
81.3 | 8 | |
80.7 | 4 | 0.1% |
위도 | 경도 | 조도 | |
---|---|---|---|
위도 | 1.000 | 0.797 | 0.420 |
경도 | 0.797 | 1.000 | 0.407 |
조도 | 0.420 | 0.407 | 1.000 |
위도 | 경도 | 조도 | |
---|---|---|---|
위도 | 1.000 | -0.045 | 0.003 |
경도 | -0.045 | 1.000 | 0.211 |
조도 | 0.003 | 0.211 | 1.000 |
날짜 | 시간 | 위도 | 경도 | 조도 | |
---|---|---|---|---|---|
0 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
1 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
2 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
3 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
4 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
5 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
6 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
7 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
8 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
9 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 |
날짜 | 시간 | 위도 | 경도 | 조도 | |
---|---|---|---|---|---|
2728 | 20220926 | 20:17 | 37.597585 | 126.956203 | 50.9 |
2729 | 20220926 | 20:17 | 37.597585 | 126.956203 | 50.9 |
2730 | 20220926 | 20:17 | 37.597585 | 126.956203 | 50.9 |
2731 | 20220926 | 20:17 | 37.597585 | 126.956203 | 50.9 |
2732 | 20220926 | 20:17 | 37.597203 | 126.956081 | 50.9 |
2733 | 20220926 | 20:17 | 37.57815 | 126.923918 | 35.4 |
2734 | 20220926 | 20:17 | 37.57815 | 126.923918 | 35.4 |
2735 | 20220926 | 20:17 | 37.57815 | 126.923918 | 35.4 |
2736 | 20220926 | 20:17 | 37.57815 | 126.923918 | 35.4 |
2737 | 20220926 | 20:17 | 37.57815 | 126.923918 | 35.4 |
Most frequently occurring
날짜 | 시간 | 위도 | 경도 | 조도 | # duplicates | |
---|---|---|---|---|---|---|
323 | 20220926 | 20:17 | 37.578901 | 126.917756 | 16.4 | 28 |
93 | 20220926 | 20:17 | 37.561854 | 126.954875 | 21.2 | 20 |
7 | 20220926 | 20:17 | 37.557236 | 126.932874 | 19.6 | 16 |
466 | 20220926 | 20:17 | 37.585373 | 126.938912 | 2.8 | 14 |
237 | 20220926 | 20:17 | 37.574108 | 126.918545 | 21.6 | 12 |
446 | 20220926 | 20:17 | 37.58439 | 126.943917 | 20.9 | 12 |
36 | 20220926 | 20:17 | 37.558184 | 126.952262 | 29.3 | 11 |
160 | 20220926 | 20:17 | 37.567882 | 126.946873 | 25.8 | 10 |
351 | 20220926 | 20:17 | 37.580063 | 126.919415 | 13.5 | 10 |
565 | 20220926 | 20:17 | 37.594771 | 126.942948 | 20.9 | 10 |