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

Reproduction

Analysis started2024-05-17 22:13:58.611393
Analysis finished2024-05-17 22:14:00.808598
Duration2.2 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-18T07:14:01.010663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:14:01.269287image/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-18T07:14:01.544212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:14:01.801586image/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%
Mean756.8882
Minimum1
Maximum101475
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-18T07:14:02.162698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile51
Q1275
median555
Q3881
95-th percentile2067
Maximum101475
Range101474
Interquartile range (IQR)606

Descriptive statistics

Standard deviation3526.0494
Coefficient of variation (CV)4.6586132
Kurtosis796.3968
Mean756.8882
Median Absolute Deviation (MAD)297
Skewness27.976778
Sum7568882
Variance12433024
MonotonicityNot monotonic
2024-05-18T07:14:02.675959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
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
97.9%
ValueCountFrequency (%)
1 10
0.1%
2 10
0.1%
4 8
0.1%
5 7
 
0.1%
6 11
0.1%
7 9
0.1%
8 18
0.2%
9 10
0.1%
10 12
0.1%
12 12
0.1%
ValueCountFrequency (%)
101475 12
0.1%
2117 9
0.1%
2116 12
0.1%
2114 7
0.1%
2113 6
 
0.1%
2112 15
0.1%
2111 16
0.2%
2110 9
0.1%
2108 13
0.1%
2107 7
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-18T07:14:03.164401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:14:03.417039image/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
9186 
0
 
814

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 9186
91.9%
0 814
 
8.1%

Length

2024-05-18T07:14:03.718244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T07:14:03.980286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 9186
91.9%
0 814
 
8.1%

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

ZEROS 

Distinct1094
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean429.009
Minimum0
Maximum21871
Zeros8438
Zeros (%)84.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-05-18T07:14:04.433104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile2485.25
Maximum21871
Range21871
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1829.4386
Coefficient of variation (CV)4.2643361
Kurtosis44.675724
Mean429.009
Median Absolute Deviation (MAD)0
Skewness6.0682104
Sum4290090
Variance3346845.5
MonotonicityNot monotonic
2024-05-18T07:14:04.915011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 8438
84.4%
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%
ValueCountFrequency (%)
0 8438
84.4%
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%
ValueCountFrequency (%)
21871 1
< 0.1%
21855 1
< 0.1%
21854 1
< 0.1%
21852 1
< 0.1%
21849 1
< 0.1%
21841 1
< 0.1%
21827 1
< 0.1%
21826 1
< 0.1%
21822 1
< 0.1%
21820 1
< 0.1%
Distinct9929
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-08 00:00:13
Maximum2024-01-11 14:26:14
2024-05-18T07:14:05.416117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T07:14:05.920609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-18T07:13:59.632449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T07:13:59.110438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T07:13:59.900948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T07:13:59.369276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-18T07:14:06.208963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간
고유번호1.0000.0000.000
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0001.0000.479
악취저감장치 연속OFF시간0.0000.4791.000
2024-05-18T07:14:06.488104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호악취저감장치 연속OFF시간악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)
고유번호1.0000.0070.000
악취저감장치 연속OFF시간0.0071.0000.480
악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)0.0000.4801.000

Missing values

2024-05-18T07:14:00.274769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-18T07:14:00.644824image/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시간등록일시
59192서울시NTS1006101102024-01-10 02:46:54
44652서울시NTS1005781102024-01-09 14:17:36
95622서울시NTS1008061102024-01-11 10:39:33
29160서울시NTS1004191102024-01-09 01:00:31
42438서울시NTS10020971102024-01-09 12:06:36
71293서울시NTS100303104942024-01-10 13:15:20
2981서울시NTS1006331102024-01-08 02:25:25
5045서울시NTS1009251102024-01-08 04:03:29
80345서울시NTS1009531102024-01-10 21:03:07
23575서울시NTS1001991102024-01-08 20:17:01
기관 명모델명고유번호IoT기기상태값(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치상태(꺼짐:0, 켜짐:1, 알수없음:2)악취저감장치 연속OFF시간등록일시
9284서울시NTS1005771102024-01-08 07:52:03
28541서울시NTS1008321102024-01-09 00:19:03
7930서울시NTS10011111102024-01-08 06:26:57
50721서울시NTS100134117932024-01-09 19:40:00
3733서울시NTS1004541102024-01-08 03:09:11
46077서울시NTS10021081102024-01-09 15:14:00
53133서울시NTS1004251127822024-01-09 21:24:40
62135서울시NTS1008761102024-01-10 05:11:43
59746서울시NTS100641102024-01-10 03:27:10
24275서울시NTS10020601102024-01-08 20:29:59