Dataset statistics
Number of variables | 7 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 664.1 KiB |
Average record size in memory | 68.0 B |
Variable types
Categorical | 4 |
---|---|
Numeric | 2 |
DateTime | 1 |
Dataset
Description | 파일 다운로드 |
---|---|
Author | 서울특별시 |
URL | https://data.seoul.go.kr/dataList/OA-15966/S/1/datasetView.do |
기관 명 has constant value "" | Constant |
모델명 has constant value "" | Constant |
IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2) has constant value "" | Constant |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) is highly imbalanced (60.3%) | Imbalance |
고유번호 is highly skewed (γ1 = 26.9425872) | Skewed |
악취저감장치 연속OFF시간 has 8474 (84.7%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-11 16:40:11.812787 |
---|---|
Analysis finished | 2024-05-11 16:40:14.340337 |
Duration | 2.53 seconds |
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 | 156.2 KiB |
서울시 |
---|
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 서울시 |
---|---|
2nd row | 서울시 |
3rd row | 서울시 |
4th row | 서울시 |
5th row | 서울시 |
Common Values
Value | Count | Frequency (%) |
서울시 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
서울시 | 10000 |
모델명
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
NTS100 |
---|
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | NTS100 |
---|---|
2nd row | NTS100 |
3rd row | NTS100 |
4th row | NTS100 |
5th row | NTS100 |
Common Values
Value | Count | Frequency (%) |
NTS100 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
nts100 | 10000 |
고유번호
Real number (ℝ)
SKEWED
 
Distinct | 899 |
---|---|
Distinct (%) | 9.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 765.1774 |
Minimum | 1 |
---|---|
Maximum | 101475 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 50 |
Q1 | 274 |
median | 553 |
Q3 | 889 |
95-th percentile | 2067 |
Maximum | 101475 |
Range | 101474 |
Interquartile range (IQR) | 615 |
Descriptive statistics
Standard deviation | 3666.8303 |
---|---|
Coefficient of variation (CV) | 4.792131 |
Kurtosis | 737.23855 |
Mean | 765.1774 |
Median Absolute Deviation (MAD) | 302 |
Skewness | 26.942587 |
Sum | 7651774 |
Variance | 13445645 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
238 | 29 | 0.3% |
23 | 28 | 0.3% |
276 | 27 | 0.3% |
40 | 26 | 0.3% |
873 | 22 | 0.2% |
36 | 20 | 0.2% |
701 | 20 | 0.2% |
91 | 20 | 0.2% |
69 | 20 | 0.2% |
916 | 19 | 0.2% |
Other values (889) | 9769 |
Value | Count | Frequency (%) |
1 | 8 | |
2 | 11 | |
4 | 11 | |
5 | 6 | |
6 | 13 | |
7 | 10 | |
8 | 10 | |
9 | 8 | |
10 | 11 | |
12 | 10 |
Value | Count | Frequency (%) |
101475 | 13 | |
2117 | 10 | |
2116 | 9 | |
2114 | 7 | |
2113 | 9 | |
2112 | 10 | |
2111 | 6 | |
2110 | 12 | |
2108 | 7 | |
2107 | 12 |
IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 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 | 10000 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 10000 |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)
Categorical
IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
1 | |
---|---|
0 | 784 |
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 | 9216 | |
0 | 784 | 7.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 9216 | |
0 | 784 | 7.8% |
악취저감장치 연속OFF시간
Real number (ℝ)
ZEROS
 
Distinct | 1085 |
---|---|
Distinct (%) | 10.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 429.2871 |
Minimum | 0 |
---|---|
Maximum | 21872 |
Zeros | 8474 |
Zeros (%) | 84.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 2501.05 |
Maximum | 21872 |
Range | 21872 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 1850.9829 |
---|---|
Coefficient of variation (CV) | 4.3117599 |
Kurtosis | 43.030929 |
Mean | 429.2871 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 6.0255841 |
Sum | 4292871 |
Variance | 3426137.6 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 8474 | |
732 | 8 | 0.1% |
783 | 7 | 0.1% |
14 | 7 | 0.1% |
749 | 6 | 0.1% |
26 | 6 | 0.1% |
757 | 6 | 0.1% |
743 | 6 | 0.1% |
16 | 6 | 0.1% |
3 | 6 | 0.1% |
Other values (1075) | 1468 | 14.7% |
Value | Count | Frequency (%) |
0 | 8474 | |
2 | 6 | 0.1% |
3 | 6 | 0.1% |
4 | 4 | < 0.1% |
5 | 5 | 0.1% |
6 | 3 | < 0.1% |
7 | 4 | < 0.1% |
8 | 5 | 0.1% |
9 | 1 | < 0.1% |
10 | 4 | < 0.1% |
Value | Count | Frequency (%) |
21872 | 1 | |
21868 | 1 | |
21859 | 1 | |
21855 | 1 | |
21851 | 1 | |
21849 | 1 | |
21822 | 1 | |
21817 | 1 | |
21812 | 1 | |
21802 | 1 |
등록일시
Date
Distinct | 9923 |
---|---|
Distinct (%) | 99.2% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2024-01-08 00:00:03 |
---|---|
Maximum | 2024-01-11 14:26:17 |
고유번호 | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | |
---|---|---|---|
고유번호 | 1.000 | 0.000 | 0.000 |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 0.000 | 1.000 | 0.489 |
악취저감장치 연속OFF시간 | 0.000 | 0.489 | 1.000 |
고유번호 | 악취저감장치 연속OFF시간 | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | |
---|---|---|---|
고유번호 | 1.000 | 0.011 | 0.000 |
악취저감장치 연속OFF시간 | 0.011 | 1.000 | 0.490 |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 0.000 | 0.490 | 1.000 |
기관 명 | 모델명 | 고유번호 | IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | 등록일시 | |
---|---|---|---|---|---|---|---|
94850 | 서울시 | NTS100 | 953 | 1 | 1 | 0 | 2024-01-11 09:55:15 |
64019 | 서울시 | NTS100 | 953 | 1 | 1 | 0 | 2024-01-10 07:00:32 |
88516 | 서울시 | NTS100 | 341 | 1 | 1 | 0 | 2024-01-11 04:27:48 |
588 | 서울시 | NTS100 | 1011 | 1 | 1 | 0 | 2024-01-08 00:10:56 |
35408 | 서울시 | NTS100 | 256 | 1 | 1 | 0 | 2024-01-09 06:26:25 |
17591 | 서울시 | NTS100 | 754 | 1 | 1 | 0 | 2024-01-08 14:56:02 |
83878 | 서울시 | NTS100 | 849 | 1 | 1 | 0 | 2024-01-11 00:08:35 |
15395 | 서울시 | NTS100 | 182 | 1 | 1 | 0 | 2024-01-08 13:15:19 |
19902 | 서울시 | NTS100 | 150 | 1 | 1 | 0 | 2024-01-08 17:08:55 |
79565 | 서울시 | NTS100 | 1098 | 1 | 1 | 0 | 2024-01-10 20:18:40 |
기관 명 | 모델명 | 고유번호 | IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | 등록일시 | |
---|---|---|---|---|---|---|---|
74684 | 서울시 | NTS100 | 694 | 1 | 1 | 0 | 2024-01-10 16:18:11 |
50263 | 서울시 | NTS100 | 381 | 1 | 1 | 0 | 2024-01-09 19:01:31 |
48790 | 서울시 | NTS100 | 2100 | 1 | 1 | 0 | 2024-01-09 17:34:14 |
1787 | 서울시 | NTS100 | 178 | 1 | 1 | 0 | 2024-01-08 01:33:08 |
57836 | 서울시 | NTS100 | 2071 | 1 | 1 | 0 | 2024-01-10 01:21:46 |
49514 | 서울시 | NTS100 | 366 | 1 | 1 | 0 | 2024-01-09 18:17:39 |
18148 | 서울시 | NTS100 | 218 | 1 | 1 | 0 | 2024-01-08 15:36:22 |
20716 | 서울시 | NTS100 | 24 | 1 | 1 | 0 | 2024-01-08 17:54:01 |
29251 | 서울시 | NTS100 | 592 | 1 | 1 | 0 | 2024-01-09 01:02:12 |
87177 | 서울시 | NTS100 | 467 | 1 | 1 | 0 | 2024-01-11 03:33:00 |