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 (54.7%)Imbalance
고유번호 is highly skewed (γ1 = 27.97464048)Skewed
악취저감장치 연속OFF시간 has 8179 (81.8%) zerosZeros

Reproduction

Analysis started2024-05-03 21:23:17.911115
Analysis finished2024-05-03 21:23:20.186316
Duration2.28 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-03T21:23:20.406144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:23:20.709830image/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-03T21:23:21.000755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:23:21.239696image/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%
Mean757.3358
Minimum1
Maximum101475
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-03T21:23:21.556273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile52
Q1275
median555
Q3888
95-th percentile2070
Maximum101475
Range101474
Interquartile range (IQR)613

Descriptive statistics

Standard deviation3526.1229
Coefficient of variation (CV)4.655957
Kurtosis796.3159
Mean757.3358
Median Absolute Deviation (MAD)300
Skewness27.97464
Sum7573358
Variance12433543
MonotonicityNot monotonic
2024-05-03T21:23:22.172837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
40 28
 
0.3%
275 27
 
0.3%
873 25
 
0.2%
276 23
 
0.2%
338 23
 
0.2%
69 22
 
0.2%
238 22
 
0.2%
598 22
 
0.2%
636 21
 
0.2%
543 20
 
0.2%
Other values (889) 9767
97.7%
ValueCountFrequency (%)
1 12
0.1%
2 13
0.1%
4 7
0.1%
5 11
0.1%
6 12
0.1%
7 6
0.1%
8 12
0.1%
9 8
0.1%
10 7
0.1%
12 6
0.1%
ValueCountFrequency (%)
101475 12
0.1%
2117 12
0.1%
2116 8
0.1%
2114 9
0.1%
2113 14
0.1%
2112 19
0.2%
2111 15
0.1%
2110 14
0.1%
2108 9
0.1%
2107 17
0.2%

IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)
Categorical

CONSTANT 

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-03T21:23:22.543458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:23:22.839212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)
Categorical

IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
9049 
0
951 

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 9049
90.5%
0 951
 
9.5%

Length

2024-05-03T21:23:23.276870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:23:23.772701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9049
90.5%
0 951
 
9.5%

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

ZEROS 

Distinct1204
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean523.3832
Minimum0
Maximum22536
Zeros8179
Zeros (%)81.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-03T21:23:24.204628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile3468.1
Maximum22536
Range22536
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1959.9526
Coefficient of variation (CV)3.7447754
Kurtosis35.004748
Mean523.3832
Median Absolute Deviation (MAD)0
Skewness5.3792317
Sum5233832
Variance3841414
MonotonicityNot monotonic
2024-05-03T21:23:24.689389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 8179
81.8%
64 11
 
0.1%
3 9
 
0.1%
18 9
 
0.1%
68 9
 
0.1%
13 8
 
0.1%
2 8
 
0.1%
1458 7
 
0.1%
15 7
 
0.1%
14 7
 
0.1%
Other values (1194) 1746
 
17.5%
ValueCountFrequency (%)
0 8179
81.8%
2 8
 
0.1%
3 9
 
0.1%
4 4
 
< 0.1%
5 6
 
0.1%
6 6
 
0.1%
7 4
 
< 0.1%
8 2
 
< 0.1%
9 4
 
< 0.1%
10 6
 
0.1%
ValueCountFrequency (%)
22536 1
< 0.1%
22535 1
< 0.1%
22534 1
< 0.1%
22528 1
< 0.1%
22524 1
< 0.1%
22513 1
< 0.1%
22510 1
< 0.1%
22491 1
< 0.1%
22487 1
< 0.1%
17229 1
< 0.1%

등록일시
Date

Distinct9883
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-02-05 00:00:11
Maximum2024-02-07 23:59:58
2024-05-03T21:23:25.077034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:23:25.612020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-03T21:23:18.954001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:23:18.434199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:23:19.224313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-03T21:23:18.696623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-03T21:23:25.873042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간
고유번호1.0000.0000.000
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0001.0000.443
악취저감장치 연속OFF시간0.0000.4431.000
2024-05-03T21:23:26.126215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치 연속OFF시간악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)
고유번호1.000-0.0060.000
악취저감장치 연속OFF시간-0.0061.0000.444
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0000.4441.000

Missing values

2024-05-03T21:23:19.572882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-03T21:23:19.991609image/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시간등록일시
76281서울시NTS1004451102024-02-07 17:47:47
38427서울시NTS1007171102024-02-06 08:52:25
45787서울시NTS1008491102024-02-06 15:09:13
22491서울시NTS10020811102024-02-05 18:56:57
18786서울시NTS10010651102024-02-05 15:48:20
66796서울시NTS10010121102024-02-07 09:22:08
63122서울시NTS1003661102024-02-07 06:13:55
6159서울시NTS10020751113362024-02-05 04:54:15
39508서울시NTS1004141102024-02-06 09:42:47
24507서울시NTS1002151187102024-02-05 21:04:16
기관 명모델명고유번호IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간등록일시
76702서울시NTS1009341102024-02-07 17:55:35
54225서울시NTS10020891102024-02-06 22:15:30
49799서울시NTS100981102024-02-06 18:53:32
66419서울시NTS1003121102024-02-07 09:15:10
17509서울시NTS1006311102024-02-05 14:54:41
60819서울시NTS1002701102024-02-07 04:17:36
65209서울시NTS100871102024-02-07 08:22:45
53200서울시NTS10010221102024-02-06 21:26:31
81601서울시NTS1001801102024-02-07 22:26:17
37306서울시NTS1004011182024-02-06 08:01:32