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 (59.3%) | Imbalance |
고유번호 is highly skewed (γ1 = 27.97677825) | Skewed |
악취저감장치 연속OFF시간 has 8438 (84.4%) zeros | Zeros |
Reproduction
Analysis started | 2024-05-17 22:13:58.611393 |
---|---|
Analysis finished | 2024-05-17 22:14:00.808598 |
Duration | 2.2 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 | 756.8882 |
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 | 51 |
Q1 | 275 |
median | 555 |
Q3 | 881 |
95-th percentile | 2067 |
Maximum | 101475 |
Range | 101474 |
Interquartile range (IQR) | 606 |
Descriptive statistics
Standard deviation | 3526.0494 |
---|---|
Coefficient of variation (CV) | 4.6586132 |
Kurtosis | 796.3968 |
Mean | 756.8882 |
Median Absolute Deviation (MAD) | 297 |
Skewness | 27.976778 |
Sum | 7568882 |
Variance | 12433024 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
238 | 26 | 0.3% |
276 | 22 | 0.2% |
275 | 22 | 0.2% |
2097 | 21 | 0.2% |
69 | 21 | 0.2% |
1078 | 21 | 0.2% |
1053 | 20 | 0.2% |
267 | 20 | 0.2% |
1120 | 20 | 0.2% |
377 | 19 | 0.2% |
Other values (889) | 9788 |
Value | Count | Frequency (%) |
1 | 10 | |
2 | 10 | |
4 | 8 | |
5 | 7 | 0.1% |
6 | 11 | |
7 | 9 | |
8 | 18 | |
9 | 10 | |
10 | 12 | |
12 | 12 |
Value | Count | Frequency (%) |
101475 | 12 | |
2117 | 9 | |
2116 | 12 | |
2114 | 7 | |
2113 | 6 | 0.1% |
2112 | 15 | |
2111 | 16 | |
2110 | 9 | |
2108 | 13 | |
2107 | 7 |
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 | 814 |
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 | 9186 | |
0 | 814 | 8.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 9186 | |
0 | 814 | 8.1% |
악취저감장치 연속OFF시간
Real number (ℝ)
ZEROS
 
Distinct | 1094 |
---|---|
Distinct (%) | 10.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 429.009 |
Minimum | 0 |
---|---|
Maximum | 21871 |
Zeros | 8438 |
Zeros (%) | 84.4% |
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 | 2485.25 |
Maximum | 21871 |
Range | 21871 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 1829.4386 |
---|---|
Coefficient of variation (CV) | 4.2643361 |
Kurtosis | 44.675724 |
Mean | 429.009 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 6.0682104 |
Sum | 4290090 |
Variance | 3346845.5 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 8438 | |
3 | 9 | 0.1% |
21 | 8 | 0.1% |
757 | 8 | 0.1% |
5 | 8 | 0.1% |
811 | 7 | 0.1% |
742 | 7 | 0.1% |
11 | 6 | 0.1% |
22 | 6 | 0.1% |
14 | 6 | 0.1% |
Other values (1084) | 1497 | 15.0% |
Value | Count | Frequency (%) |
0 | 8438 | |
2 | 5 | 0.1% |
3 | 9 | 0.1% |
4 | 6 | 0.1% |
5 | 8 | 0.1% |
6 | 5 | 0.1% |
7 | 4 | < 0.1% |
8 | 2 | < 0.1% |
9 | 2 | < 0.1% |
10 | 4 | < 0.1% |
Value | Count | Frequency (%) |
21871 | 1 | |
21855 | 1 | |
21854 | 1 | |
21852 | 1 | |
21849 | 1 | |
21841 | 1 | |
21827 | 1 | |
21826 | 1 | |
21822 | 1 | |
21820 | 1 |
등록일시
Date
Distinct | 9929 |
---|---|
Distinct (%) | 99.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
Minimum | 2024-01-08 00:00:13 |
---|---|
Maximum | 2024-01-11 14:26:14 |
고유번호 | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | |
---|---|---|---|
고유번호 | 1.000 | 0.000 | 0.000 |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 0.000 | 1.000 | 0.479 |
악취저감장치 연속OFF시간 | 0.000 | 0.479 | 1.000 |
고유번호 | 악취저감장치 연속OFF시간 | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | |
---|---|---|---|
고유번호 | 1.000 | 0.007 | 0.000 |
악취저감장치 연속OFF시간 | 0.007 | 1.000 | 0.480 |
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 0.000 | 0.480 | 1.000 |
기관 명 | 모델명 | 고유번호 | IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | 등록일시 | |
---|---|---|---|---|---|---|---|
59192 | 서울시 | NTS100 | 610 | 1 | 1 | 0 | 2024-01-10 02:46:54 |
44652 | 서울시 | NTS100 | 578 | 1 | 1 | 0 | 2024-01-09 14:17:36 |
95622 | 서울시 | NTS100 | 806 | 1 | 1 | 0 | 2024-01-11 10:39:33 |
29160 | 서울시 | NTS100 | 419 | 1 | 1 | 0 | 2024-01-09 01:00:31 |
42438 | 서울시 | NTS100 | 2097 | 1 | 1 | 0 | 2024-01-09 12:06:36 |
71293 | 서울시 | NTS100 | 303 | 1 | 0 | 494 | 2024-01-10 13:15:20 |
2981 | 서울시 | NTS100 | 633 | 1 | 1 | 0 | 2024-01-08 02:25:25 |
5045 | 서울시 | NTS100 | 925 | 1 | 1 | 0 | 2024-01-08 04:03:29 |
80345 | 서울시 | NTS100 | 953 | 1 | 1 | 0 | 2024-01-10 21:03:07 |
23575 | 서울시 | NTS100 | 199 | 1 | 1 | 0 | 2024-01-08 20:17:01 |
기관 명 | 모델명 | 고유번호 | IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2) | 악취저감장치 연속OFF시간 | 등록일시 | |
---|---|---|---|---|---|---|---|
9284 | 서울시 | NTS100 | 577 | 1 | 1 | 0 | 2024-01-08 07:52:03 |
28541 | 서울시 | NTS100 | 832 | 1 | 1 | 0 | 2024-01-09 00:19:03 |
7930 | 서울시 | NTS100 | 1111 | 1 | 1 | 0 | 2024-01-08 06:26:57 |
50721 | 서울시 | NTS100 | 134 | 1 | 1 | 793 | 2024-01-09 19:40:00 |
3733 | 서울시 | NTS100 | 454 | 1 | 1 | 0 | 2024-01-08 03:09:11 |
46077 | 서울시 | NTS100 | 2108 | 1 | 1 | 0 | 2024-01-09 15:14:00 |
53133 | 서울시 | NTS100 | 425 | 1 | 1 | 2782 | 2024-01-09 21:24:40 |
62135 | 서울시 | NTS100 | 876 | 1 | 1 | 0 | 2024-01-10 05:11:43 |
59746 | 서울시 | NTS100 | 64 | 1 | 1 | 0 | 2024-01-10 03:27:10 |
24275 | 서울시 | NTS100 | 2060 | 1 | 1 | 0 | 2024-01-08 20:29:59 |