Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory664.1 KiB
Average record size in memory68.0 B

Variable types

Categorical4
Numeric2
DateTime1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15966/S/1/datasetView.do

Alerts

기관 명 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%) zerosZeros

Reproduction

Analysis started2024-05-11 16:40:11.812787
Analysis finished2024-05-11 16:40:14.340337
Duration2.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
서울시
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울시
2nd row서울시
3rd row서울시
4th row서울시
5th row서울시

Common Values

ValueCountFrequency (%)
서울시 10000
100.0%

Length

2024-05-12T01:40:14.531898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:40:14.818483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울시 10000
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
NTS100
10000 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowNTS100
2nd rowNTS100
3rd rowNTS100
4th rowNTS100
5th rowNTS100

Common Values

ValueCountFrequency (%)
NTS100 10000
100.0%

Length

2024-05-12T01:40:15.115597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:40:15.403574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
nts100 10000
100.0%

고유번호
Real number (ℝ)

SKEWED 

Distinct899
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean765.1774
Minimum1
Maximum101475
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:40:15.732268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile50
Q1274
median553
Q3889
95-th percentile2067
Maximum101475
Range101474
Interquartile range (IQR)615

Descriptive statistics

Standard deviation3666.8303
Coefficient of variation (CV)4.792131
Kurtosis737.23855
Mean765.1774
Median Absolute Deviation (MAD)302
Skewness26.942587
Sum7651774
Variance13445645
MonotonicityNot monotonic
2024-05-12T01:40:16.163363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
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
97.7%
ValueCountFrequency (%)
1 8
0.1%
2 11
0.1%
4 11
0.1%
5 6
0.1%
6 13
0.1%
7 10
0.1%
8 10
0.1%
9 8
0.1%
10 11
0.1%
12 10
0.1%
ValueCountFrequency (%)
101475 13
0.1%
2117 10
0.1%
2116 9
0.1%
2114 7
0.1%
2113 9
0.1%
2112 10
0.1%
2111 6
0.1%
2110 12
0.1%
2108 7
0.1%
2107 12
0.1%
Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 10000
100.0%

Length

2024-05-12T01:40:16.670624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:40:16.954779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%
Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
9216 
0
 
784

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 9216
92.2%
0 784
 
7.8%

Length

2024-05-12T01:40:17.253759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:40:17.545087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9216
92.2%
0 784
 
7.8%

악취저감장치 연속OFF시간
Real number (ℝ)

ZEROS 

Distinct1085
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean429.2871
Minimum0
Maximum21872
Zeros8474
Zeros (%)84.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-12T01:40:17.877596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2501.05
Maximum21872
Range21872
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1850.9829
Coefficient of variation (CV)4.3117599
Kurtosis43.030929
Mean429.2871
Median Absolute Deviation (MAD)0
Skewness6.0255841
Sum4292871
Variance3426137.6
MonotonicityNot monotonic
2024-05-12T01:40:18.289344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 8474
84.7%
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%
ValueCountFrequency (%)
0 8474
84.7%
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%
ValueCountFrequency (%)
21872 1
< 0.1%
21868 1
< 0.1%
21859 1
< 0.1%
21855 1
< 0.1%
21851 1
< 0.1%
21849 1
< 0.1%
21822 1
< 0.1%
21817 1
< 0.1%
21812 1
< 0.1%
21802 1
< 0.1%
Distinct9923
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-08 00:00:03
Maximum2024-01-11 14:26:17
2024-05-12T01:40:18.664685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:40:19.070389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-12T01:40:13.171045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:40:12.667849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:40:13.424177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:40:12.920823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-12T01:40:19.324410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간
고유번호1.0000.0000.000
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0001.0000.489
악취저감장치 연속OFF시간0.0000.4891.000
2024-05-12T01:40:19.570642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치 연속OFF시간악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)
고유번호1.0000.0110.000
악취저감장치 연속OFF시간0.0111.0000.490
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0000.4901.000

Missing values

2024-05-12T01:40:13.758514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T01:40:14.160853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

기관 명모델명고유번호IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간등록일시
94850서울시NTS1009531102024-01-11 09:55:15
64019서울시NTS1009531102024-01-10 07:00:32
88516서울시NTS1003411102024-01-11 04:27:48
588서울시NTS10010111102024-01-08 00:10:56
35408서울시NTS1002561102024-01-09 06:26:25
17591서울시NTS1007541102024-01-08 14:56:02
83878서울시NTS1008491102024-01-11 00:08:35
15395서울시NTS1001821102024-01-08 13:15:19
19902서울시NTS1001501102024-01-08 17:08:55
79565서울시NTS10010981102024-01-10 20:18:40
기관 명모델명고유번호IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간등록일시
74684서울시NTS1006941102024-01-10 16:18:11
50263서울시NTS1003811102024-01-09 19:01:31
48790서울시NTS10021001102024-01-09 17:34:14
1787서울시NTS1001781102024-01-08 01:33:08
57836서울시NTS10020711102024-01-10 01:21:46
49514서울시NTS1003661102024-01-09 18:17:39
18148서울시NTS1002181102024-01-08 15:36:22
20716서울시NTS100241102024-01-08 17:54:01
29251서울시NTS1005921102024-01-09 01:02:12
87177서울시NTS1004671102024-01-11 03:33:00