Overview

Dataset statistics

Number of variables9
Number of observations31
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory83.3 B

Variable types

Categorical5
Text1
Numeric3

Alerts

집계년월 has constant value ""Constant
점검분기 has constant value ""Constant
지정수 has constant value ""Constant
폐쇄수 has constant value ""Constant
사용중지수 is highly imbalanced (50.6%)Imbalance
시군명 has unique valuesUnique
사용금지수 has 22 (71.0%) zerosZeros
현재시설수 has 6 (19.4%) zerosZeros

Reproduction

Analysis started2023-12-10 21:39:08.707466
Analysis finished2023-12-10 21:39:09.980962
Duration1.27 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년월
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12
31 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12
2nd row2023-12
3rd row2023-12
4th row2023-12
5th row2023-12

Common Values

ValueCountFrequency (%)
2023-12 31
100.0%

Length

2023-12-11T06:39:10.041978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:39:10.144325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12 31
100.0%

점검분기
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
4
31 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
4 31
100.0%

Length

2023-12-11T06:39:10.260261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:39:10.363013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4 31
100.0%

시군명
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-11T06:39:10.544420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.0967742
Min length3

Characters and Unicode

Total characters96
Distinct characters38
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row가평군
2nd row고양시
3rd row과천시
4th row광명시
5th row광주시
ValueCountFrequency (%)
가평군 1
 
3.2%
안양시 1
 
3.2%
하남시 1
 
3.2%
포천시 1
 
3.2%
평택시 1
 
3.2%
파주시 1
 
3.2%
이천시 1
 
3.2%
의정부시 1
 
3.2%
의왕시 1
 
3.2%
용인시 1
 
3.2%
Other values (21) 21
67.7%
2023-12-11T06:39:10.905437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 29
30.2%
천 6
 
6.2%
양 5
 
5.2%
주 5
 
5.2%
군 4
 
4.2%
성 3
 
3.1%
포 3
 
3.1%
안 3
 
3.1%
평 3
 
3.1%
남 3
 
3.1%
Other values (28) 32
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 96
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 29
30.2%
천 6
 
6.2%
양 5
 
5.2%
주 5
 
5.2%
군 4
 
4.2%
성 3
 
3.1%
포 3
 
3.1%
안 3
 
3.1%
평 3
 
3.1%
남 3
 
3.1%
Other values (28) 32
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 96
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 29
30.2%
천 6
 
6.2%
양 5
 
5.2%
주 5
 
5.2%
군 4
 
4.2%
성 3
 
3.1%
포 3
 
3.1%
안 3
 
3.1%
평 3
 
3.1%
남 3
 
3.1%
Other values (28) 32
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 96
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 29
30.2%
천 6
 
6.2%
양 5
 
5.2%
주 5
 
5.2%
군 4
 
4.2%
성 3
 
3.1%
포 3
 
3.1%
안 3
 
3.1%
평 3
 
3.1%
남 3
 
3.1%
Other values (28) 32
33.3%

이전분기시설수
Real number (ℝ)

Distinct13
Distinct (%)41.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.6774194
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-11T06:39:11.045718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q15
median7
Q312
95-th percentile22.5
Maximum31
Range30
Interquartile range (IQR)7

Descriptive statistics

Standard deviation6.6251395
Coefficient of variation (CV)0.68459775
Kurtosis2.8498818
Mean9.6774194
Median Absolute Deviation (MAD)3
Skewness1.5328219
Sum300
Variance43.892473
MonotonicityNot monotonic
2023-12-11T06:39:11.171459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
7 6
19.4%
5 5
16.1%
12 4
12.9%
14 3
9.7%
10 3
9.7%
3 2
 
6.5%
6 2
 
6.5%
16 1
 
3.2%
20 1
 
3.2%
31 1
 
3.2%
Other values (3) 3
9.7%
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
3 2
 
6.5%
5 5
16.1%
6 2
 
6.5%
7 6
19.4%
10 3
9.7%
12 4
12.9%
14 3
9.7%
16 1
 
3.2%
ValueCountFrequency (%)
31 1
 
3.2%
25 1
 
3.2%
20 1
 
3.2%
16 1
 
3.2%
14 3
9.7%
12 4
12.9%
10 3
9.7%
7 6
19.4%
6 2
 
6.5%
5 5
16.1%

사용중지수
Categorical

IMBALANCE 

Distinct5
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size380.0 B
0
24 
1
4 
4
 
1
9
 
1
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique3 ?
Unique (%)9.7%

Sample

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

Common Values

ValueCountFrequency (%)
0 24
77.4%
1 4
 
12.9%
4 1
 
3.2%
9 1
 
3.2%
5 1
 
3.2%

Length

2023-12-11T06:39:11.294523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:39:11.393043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 24
77.4%
1 4
 
12.9%
4 1
 
3.2%
9 1
 
3.2%
5 1
 
3.2%

사용금지수
Real number (ℝ)

ZEROS 

Distinct7
Distinct (%)22.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.90322581
Minimum0
Maximum7
Zeros22
Zeros (%)71.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-11T06:39:11.495957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile5
Maximum7
Range7
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.8322088
Coefficient of variation (CV)2.0285169
Kurtosis4.6361976
Mean0.90322581
Median Absolute Deviation (MAD)0
Skewness2.2724724
Sum28
Variance3.3569892
MonotonicityNot monotonic
2023-12-11T06:39:11.616387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 22
71.0%
1 3
 
9.7%
3 2
 
6.5%
7 1
 
3.2%
2 1
 
3.2%
6 1
 
3.2%
4 1
 
3.2%
ValueCountFrequency (%)
0 22
71.0%
1 3
 
9.7%
2 1
 
3.2%
3 2
 
6.5%
4 1
 
3.2%
6 1
 
3.2%
7 1
 
3.2%
ValueCountFrequency (%)
7 1
 
3.2%
6 1
 
3.2%
4 1
 
3.2%
3 2
 
6.5%
2 1
 
3.2%
1 3
 
9.7%
0 22
71.0%

지정수
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
0
31 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 31
100.0%

Length

2023-12-11T06:39:11.748405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:39:11.844923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 31
100.0%

폐쇄수
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
0
31 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 31
100.0%

Length

2023-12-11T06:39:11.950446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T06:39:12.045230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 31
100.0%

현재시설수
Real number (ℝ)

ZEROS 

Distinct14
Distinct (%)45.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.7419355
Minimum0
Maximum22
Zeros6
Zeros (%)19.4%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-11T06:39:12.136101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12.5
median6
Q310
95-th percentile18
Maximum22
Range22
Interquartile range (IQR)7.5

Descriptive statistics

Standard deviation5.7559693
Coefficient of variation (CV)0.85375621
Kurtosis0.7462593
Mean6.7419355
Median Absolute Deviation (MAD)4
Skewness0.93499016
Sum209
Variance33.131183
MonotonicityNot monotonic
2023-12-11T06:39:12.239296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0 6
19.4%
7 5
16.1%
5 5
16.1%
12 3
9.7%
3 2
 
6.5%
10 2
 
6.5%
11 1
 
3.2%
16 1
 
3.2%
20 1
 
3.2%
6 1
 
3.2%
Other values (4) 4
12.9%
ValueCountFrequency (%)
0 6
19.4%
1 1
 
3.2%
2 1
 
3.2%
3 2
 
6.5%
5 5
16.1%
6 1
 
3.2%
7 5
16.1%
9 1
 
3.2%
10 2
 
6.5%
11 1
 
3.2%
ValueCountFrequency (%)
22 1
 
3.2%
20 1
 
3.2%
16 1
 
3.2%
12 3
9.7%
11 1
 
3.2%
10 2
 
6.5%
9 1
 
3.2%
7 5
16.1%
6 1
 
3.2%
5 5
16.1%

Interactions

2023-12-11T06:39:09.488706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:08.943195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.223980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.579121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.046395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.312263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.667943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.144519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:39:09.406288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:39:12.312339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명이전분기시설수사용중지수사용금지수현재시설수
시군명1.0001.0001.0001.0001.000
이전분기시설수1.0001.0000.6250.5310.918
사용중지수1.0000.6251.0000.0000.253
사용금지수1.0000.5310.0001.0000.496
현재시설수1.0000.9180.2530.4961.000
2023-12-11T06:39:12.401581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이전분기시설수사용금지수현재시설수사용중지수
이전분기시설수1.0000.2860.3810.429
사용금지수0.2861.0000.0160.000
현재시설수0.3810.0161.0000.000
사용중지수0.4290.0000.0001.000

Missing values

2023-12-11T06:39:09.780832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T06:39:09.919426image/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

집계년월점검분기시군명이전분기시설수사용중지수사용금지수지정수폐쇄수현재시설수
02023-124가평군300003
12023-124고양시1417000
22023-124과천시12000012
32023-124광명시1400000
42023-124광주시700007
52023-124구리시500005
62023-124군포시12000011
72023-124김포시740000
82023-124남양주시16020016
92023-124동두천시12010012
집계년월점검분기시군명이전분기시설수사용중지수사용금지수지정수폐쇄수현재시설수
212023-124오산시710007
222023-124용인시510005
232023-124의왕시700007
242023-124의정부시1410000
252023-124이천시1000009
262023-124파주시10500010
272023-124평택시100001
282023-124포천시200002
292023-124하남시604000
302023-124화성시501005