Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 3000 |
Missing cells | 6000 |
Missing cells (%) | 22.2% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 228.6 KiB |
Average record size in memory | 78.0 B |
Variable types
DateTime | 2 |
---|---|
Numeric | 2 |
Categorical | 3 |
Unsupported | 2 |
Dataset
Description | 보행자Care검지 내역 조회 |
---|---|
Author | 차세대융합기술연구원 |
URL | https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=AM7QR8JEOI1J8KFWD55W31986856&infSeq=1 |
상태값 has constant value "" | Constant |
운영코드 has constant value "" | Constant |
보행자적외선검지유형 is highly overall correlated with 카메라명 | High correlation |
카메라명 is highly overall correlated with 보행자적외선검지유형 | High correlation |
함체ID has 3000 (100.0%) missing values | Missing |
볼라드ID has 3000 (100.0%) missing values | Missing |
이벤트발생년월일시 is highly skewed (γ1 = -38.70036717) | Skewed |
발생일시 has unique values | Unique |
함체ID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
볼라드ID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2024-03-23 01:31:14.198564 |
---|---|
Analysis finished | 2024-03-23 01:31:17.063437 |
Duration | 2.86 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
발생일시
Date
UNIQUE
 
Distinct | 3000 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 23.6 KiB |
Minimum | 2019-07-31 23:59:31.885000 |
---|---|
Maximum | 2019-08-01 07:43:49.293000 |
보행자적외선검지유형
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3.2803333 |
Minimum | 2 |
---|---|
Maximum | 12 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 26.5 KiB |
Quantile statistics
Minimum | 2 |
---|---|
5-th percentile | 2 |
Q1 | 2 |
median | 3 |
Q3 | 3 |
95-th percentile | 9 |
Maximum | 12 |
Range | 10 |
Interquartile range (IQR) | 1 |
Descriptive statistics
Standard deviation | 2.0532458 |
---|---|
Coefficient of variation (CV) | 0.62592598 |
Kurtosis | 5.7500189 |
Mean | 3.2803333 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 2.6245843 |
Sum | 9841 |
Variance | 4.2158185 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3 | 1738 | |
2 | 976 | |
9 | 221 | 7.4% |
11 | 54 | 1.8% |
12 | 6 | 0.2% |
4 | 5 | 0.2% |
Value | Count | Frequency (%) |
2 | 976 | |
3 | 1738 | |
4 | 5 | 0.2% |
9 | 221 | 7.4% |
11 | 54 | 1.8% |
12 | 6 | 0.2% |
Value | Count | Frequency (%) |
12 | 6 | 0.2% |
11 | 54 | 1.8% |
9 | 221 | 7.4% |
4 | 5 | 0.2% |
3 | 1738 | |
2 | 976 |
일시
Date
Distinct | 2781 |
---|---|
Distinct (%) | 92.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 23.6 KiB |
Minimum | 2019-07-31 23:59:41 |
---|---|
Maximum | 2019-08-01 07:43:48 |
상태값
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 23.6 KiB |
2 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 2 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
2 | 3000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 3000 |
카메라명
Categorical
HIGH CORRELATION
 
Distinct | 43 |
---|---|
Distinct (%) | 1.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 23.6 KiB |
CIT-SDB-3104 | |
---|---|
CIT-SDB-3074 | |
CIT-SDB-3045 | |
CIT-SDB-1011 | |
CIT-SDB-1012 | |
Other values (38) |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 0.1% |
Sample
1st row | CIT-SDB-3074 |
---|---|
2nd row | CIT-SDB-3104 |
3rd row | CIT-SDB-3101 |
4th row | CIT-SDB-3045 |
5th row | CIT-SDB-3045 |
Common Values
Value | Count | Frequency (%) |
CIT-SDB-3104 | 1353 | |
CIT-SDB-3074 | 521 | 17.4% |
CIT-SDB-3045 | 199 | 6.6% |
CIT-SDB-1011 | 174 | 5.8% |
CIT-SDB-1012 | 152 | 5.1% |
CIT-SDB-1032 | 69 | 2.3% |
CIT-SDB-3102 | 49 | 1.6% |
CIT-SDB-3042 | 37 | 1.2% |
CIT-SDB-1031 | 34 | 1.1% |
CIT-SDB-3075 | 32 | 1.1% |
Other values (33) | 380 | 12.7% |
Length
Value | Count | Frequency (%) |
cit-sdb-3104 | 1353 | |
cit-sdb-3074 | 521 | 17.4% |
cit-sdb-3045 | 199 | 6.6% |
cit-sdb-1011 | 174 | 5.8% |
cit-sdb-1012 | 152 | 5.1% |
cit-sdb-1032 | 69 | 2.3% |
cit-sdb-3102 | 49 | 1.6% |
cit-sdb-3042 | 37 | 1.2% |
cit-sdb-1031 | 34 | 1.1% |
cit-sdb-3075 | 32 | 1.1% |
Other values (33) | 380 | 12.7% |
함체ID
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 3000 |
---|---|
Missing (%) | 100.0% |
Memory size | 26.5 KiB |
볼라드ID
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 3000 |
---|---|
Missing (%) | 100.0% |
Memory size | 26.5 KiB |
운영코드
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 23.6 KiB |
1 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 1 |
---|---|
2nd row | 1 |
3rd row | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 3000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 3000 |
이벤트발생년월일시
Real number (ℝ)
SKEWED
 
Distinct | 2781 |
---|---|
Distinct (%) | 92.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0190801 × 1013 |
Minimum | 2.0190731 × 1013 |
---|---|
Maximum | 2.0190801 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 26.5 KiB |
Quantile statistics
Minimum | 2.0190731 × 1013 |
---|---|
5-th percentile | 2.0190801 × 1013 |
Q1 | 2.0190801 × 1013 |
median | 2.0190801 × 1013 |
Q3 | 2.0190801 × 1013 |
95-th percentile | 2.0190801 × 1013 |
Maximum | 2.0190801 × 1013 |
Range | 69838407 |
Interquartile range (IQR) | 42390 |
Descriptive statistics
Standard deviation | 1802086.3 |
---|---|
Coefficient of variation (CV) | 8.9252841 × 10-8 |
Kurtosis | 1496.9769 |
Mean | 2.0190801 × 1013 |
Median Absolute Deviation (MAD) | 21098.5 |
Skewness | -38.700367 |
Sum | 6.0572403 × 1016 |
Variance | 3.2475152 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20190801010226 | 8 | 0.3% |
20190801031051 | 4 | 0.1% |
20190801000632 | 4 | 0.1% |
20190801072259 | 3 | 0.1% |
20190801011833 | 3 | 0.1% |
20190801055005 | 3 | 0.1% |
20190801040818 | 3 | 0.1% |
20190801035740 | 3 | 0.1% |
20190801072346 | 3 | 0.1% |
20190801003952 | 3 | 0.1% |
Other values (2771) | 2963 |
Value | Count | Frequency (%) |
20190731235941 | 1 | |
20190731235954 | 1 | |
20190801000021 | 1 | |
20190801000043 | 1 | |
20190801000044 | 1 | |
20190801000047 | 1 | |
20190801000050 | 1 | |
20190801000052 | 1 | |
20190801000053 | 1 | |
20190801000055 | 1 |
Value | Count | Frequency (%) |
20190801074348 | 1 | |
20190801074345 | 1 | |
20190801074342 | 1 | |
20190801074340 | 1 | |
20190801074337 | 2 | |
20190801074334 | 1 | |
20190801074329 | 1 | |
20190801074319 | 1 | |
20190801074315 | 1 | |
20190801074313 | 1 |
보행자적외선검지유형 | 카메라명 | 이벤트발생년월일시 | |
---|---|---|---|
보행자적외선검지유형 | 1.000 | 0.912 | 0.000 |
카메라명 | 0.912 | 1.000 | 0.000 |
이벤트발생년월일시 | 0.000 | 0.000 | 1.000 |
보행자적외선검지유형 | 이벤트발생년월일시 | 카메라명 | |
---|---|---|---|
보행자적외선검지유형 | 1.000 | -0.306 | 0.628 |
이벤트발생년월일시 | -0.306 | 1.000 | 0.000 |
카메라명 | 0.628 | 0.000 | 1.000 |
발생일시 | 보행자적외선검지유형 | 일시 | 상태값 | 카메라명 | 함체ID | 볼라드ID | 운영코드 | 이벤트발생년월일시 | |
---|---|---|---|---|---|---|---|---|---|
0 | 2019-08-01 00:19:47.634 | 3 | 2019-08-01 00:19:57 | 2 | CIT-SDB-3074 | <NA> | <NA> | 1 | 20190801001957 |
1 | 2019-08-01 00:19:51.954 | 2 | 2019-08-01 00:20:01 | 2 | CIT-SDB-3104 | <NA> | <NA> | 1 | 20190801002001 |
2 | 2019-08-01 00:19:56.546 | 2 | 2019-08-01 00:20:06 | 2 | CIT-SDB-3101 | <NA> | <NA> | 1 | 20190801002006 |
3 | 2019-08-01 00:20:01.469 | 9 | 2019-08-01 00:20:11 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801002011 |
4 | 2019-08-01 00:20:16.782 | 9 | 2019-08-01 00:20:26 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801002026 |
5 | 2019-08-01 00:20:19.079 | 2 | 2019-08-01 00:20:28 | 2 | CIT-SDB-3104 | <NA> | <NA> | 1 | 20190801002028 |
6 | 2019-08-01 00:20:37.345 | 2 | 2019-08-01 00:20:47 | 2 | CIT-SDB-3071 | <NA> | <NA> | 1 | 20190801002047 |
7 | 2019-08-01 00:21:54.454 | 2 | 2019-08-01 00:22:04 | 2 | CIT-SDB-3094 | <NA> | <NA> | 1 | 20190801002204 |
8 | 2019-08-01 00:22:07.798 | 3 | 2019-08-01 00:22:17 | 2 | CIT-SDB-3074 | <NA> | <NA> | 1 | 20190801002217 |
9 | 2019-08-01 00:22:10.534 | 9 | 2019-08-01 00:22:20 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801002220 |
발생일시 | 보행자적외선검지유형 | 일시 | 상태값 | 카메라명 | 함체ID | 볼라드ID | 운영코드 | 이벤트발생년월일시 | |
---|---|---|---|---|---|---|---|---|---|
2990 | 2019-08-01 07:07:19.944 | 9 | 2019-08-01 07:07:19 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070719 |
2991 | 2019-08-01 07:07:20.546 | 9 | 2019-08-01 07:07:19 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070719 |
2992 | 2019-08-01 07:07:21.584 | 9 | 2019-08-01 07:07:21 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070721 |
2993 | 2019-08-01 07:07:22.187 | 9 | 2019-08-01 07:07:21 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070721 |
2994 | 2019-08-01 07:07:23.225 | 9 | 2019-08-01 07:07:22 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070722 |
2995 | 2019-08-01 07:07:23.828 | 9 | 2019-08-01 07:07:22 | 2 | CIT-SDB-3045 | <NA> | <NA> | 1 | 20190801070722 |
2996 | 2019-08-01 07:07:24.43 | 2 | 2019-08-01 07:07:22 | 2 | CIT-SDB-1012 | <NA> | <NA> | 1 | 20190801070722 |
2997 | 2019-08-01 07:07:25.033 | 2 | 2019-08-01 07:07:23 | 2 | CIT-SDB-1013 | <NA> | <NA> | 1 | 20190801070723 |
2998 | 2019-08-01 07:08:36.508 | 2 | 2019-08-01 07:08:36 | 2 | CIT-SDB-1033 | <NA> | <NA> | 1 | 20190801070836 |
2999 | 2019-08-01 07:09:02.867 | 2 | 2019-08-01 07:09:02 | 2 | CIT-SDB-1032 | <NA> | <NA> | 1 | 20190801070902 |