Overview

Dataset statistics

Number of variables9
Number of observations110
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory75.2 B

Variable types

Categorical5
Text1
Numeric2
Boolean1

Dataset

Description대기환경 옥외전광판 설치 현황
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=UDY92DPEIUGXXAT6CW4D32047736&infSeq=1

Alerts

시군명 is highly overall correlated with 표출시간 and 1 other fieldsHigh correlation
표출시간 is highly overall correlated with 시군명High correlation
표출내용 is highly overall correlated with 시군명High correlation
표출방식 is highly imbalanced (53.6%)Imbalance
설치위치 has unique valuesUnique

Reproduction

Analysis started2023-12-10 21:31:39.211614
Analysis finished2023-12-10 21:31:40.199258
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)27.3%
Missing0
Missing (%)0.0%
Memory size1012.0 B
성남시
12 
화성시
11 
용인시
11 
수원시
11 
부천시
6 
Other values (25)
59 

Length

Max length4
Median length3
Mean length3.0545455
Min length3

Unique

Unique5 ?
Unique (%)4.5%

Sample

1st row수원시
2nd row수원시
3rd row수원시
4th row수원시
5th row수원시

Common Values

ValueCountFrequency (%)
성남시 12
 
10.9%
화성시 11
 
10.0%
용인시 11
 
10.0%
수원시 11
 
10.0%
부천시 6
 
5.5%
고양시 5
 
4.5%
안양시 5
 
4.5%
광명시 4
 
3.6%
남양주시 3
 
2.7%
광주시 3
 
2.7%
Other values (20) 39
35.5%

Length

2023-12-11T06:31:40.255827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
성남시 12
 
10.9%
용인시 11
 
10.0%
수원시 11
 
10.0%
화성시 11
 
10.0%
부천시 6
 
5.5%
고양시 5
 
4.5%
안양시 5
 
4.5%
광명시 4
 
3.6%
시흥시 3
 
2.7%
구리시 3
 
2.7%
Other values (20) 39
35.5%

설치위치
Text

UNIQUE 

Distinct110
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1012.0 B
2023-12-11T06:31:40.474427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length27
Mean length15.081818
Min length7

Characters and Unicode

Total characters1659
Distinct characters185
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique110 ?
Unique (%)100.0%

Sample

1st row권선구 권선동 1120
2nd row권선구 세류동 1215
3rd row장안구 파장동 128-10
4th row권선구 구운동 920
5th row영통구 중부대로 440
ValueCountFrequency (%)
앞 15
 
4.1%
분당구 8
 
2.2%
권선구 5
 
1.4%
처인구 5
 
1.4%
안양시 5
 
1.4%
고양시 5
 
1.4%
영통구 5
 
1.4%
광명시 4
 
1.1%
남양주시 3
 
0.8%
광주시 3
 
0.8%
Other values (281) 311
84.3%
2023-12-11T06:31:40.807796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
259
 
15.6%
동 88
 
5.3%
1 69
 
4.2%
2 58
 
3.5%
시 57
 
3.4%
구 54
 
3.3%
- 52
 
3.1%
3 41
 
2.5%
9 39
 
2.4%
4 38
 
2.3%
Other values (175) 904
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 887
53.5%
Decimal Number 407
24.5%
Space Separator 259
 
15.6%
Dash Punctuation 52
 
3.1%
Open Punctuation 26
 
1.6%
Close Punctuation 26
 
1.6%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 88
 
9.9%
시 57
 
6.4%
구 54
 
6.1%
리 29
 
3.3%
로 25
 
2.8%
양 22
 
2.5%
안 21
 
2.4%
앞 17
 
1.9%
읍 15
 
1.7%
사 14
 
1.6%
Other values (159) 545
61.4%
Decimal Number
ValueCountFrequency (%)
1 69
17.0%
2 58
14.3%
3 41
10.1%
9 39
9.6%
4 38
9.3%
0 36
8.8%
7 34
8.4%
5 33
8.1%
8 30
7.4%
6 29
7.1%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
I 1
50.0%
Space Separator
ValueCountFrequency (%)
259
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 887
53.5%
Common 770
46.4%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 88
 
9.9%
시 57
 
6.4%
구 54
 
6.1%
리 29
 
3.3%
로 25
 
2.8%
양 22
 
2.5%
안 21
 
2.4%
앞 17
 
1.9%
읍 15
 
1.7%
사 14
 
1.6%
Other values (159) 545
61.4%
Common
ValueCountFrequency (%)
259
33.6%
1 69
 
9.0%
2 58
 
7.5%
- 52
 
6.8%
3 41
 
5.3%
9 39
 
5.1%
4 38
 
4.9%
0 36
 
4.7%
7 34
 
4.4%
5 33
 
4.3%
Other values (4) 111
14.4%
Latin
ValueCountFrequency (%)
C 1
50.0%
I 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 887
53.5%
ASCII 772
46.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
259
33.5%
1 69
 
8.9%
2 58
 
7.5%
- 52
 
6.7%
3 41
 
5.3%
9 39
 
5.1%
4 38
 
4.9%
0 36
 
4.7%
7 34
 
4.4%
5 33
 
4.3%
Other values (6) 113
14.6%
Hangul
ValueCountFrequency (%)
동 88
 
9.9%
시 57
 
6.4%
구 54
 
6.1%
리 29
 
3.3%
로 25
 
2.8%
양 22
 
2.5%
안 21
 
2.4%
앞 17
 
1.9%
읍 15
 
1.7%
사 14
 
1.6%
Other values (159) 545
61.4%

구분
Categorical

Distinct2
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1012.0 B
설치
82 
교체
28 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row교체
2nd row교체
3rd row교체
4th row설치
5th row설치

Common Values

ValueCountFrequency (%)
설치 82
74.5%
교체 28
 
25.5%

Length

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

Common Values (Plot)

2023-12-11T06:31:41.007226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
설치 82
74.5%
교체 28
 
25.5%

설치및교체연도
Real number (ℝ)

Distinct18
Distinct (%)16.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2016.3636
Minimum2003
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-11T06:31:41.123025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2003
5-th percentile2008
Q12015
median2018
Q32019
95-th percentile2021
Maximum2022
Range19
Interquartile range (IQR)4

Descriptive statistics

Standard deviation4.2915049
Coefficient of variation (CV)0.0021283388
Kurtosis0.69773206
Mean2016.3636
Median Absolute Deviation (MAD)1
Skewness-1.2706049
Sum221800
Variance18.417014
MonotonicityNot monotonic
2023-12-11T06:31:41.258927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
2019 27
24.5%
2018 15
13.6%
2017 14
12.7%
2020 12
10.9%
2008 8
 
7.3%
2016 5
 
4.5%
2013 5
 
4.5%
2015 5
 
4.5%
2021 4
 
3.6%
2009 3
 
2.7%
Other values (8) 12
10.9%
ValueCountFrequency (%)
2003 1
 
0.9%
2005 1
 
0.9%
2006 2
 
1.8%
2008 8
7.3%
2009 3
 
2.7%
2010 1
 
0.9%
2011 2
 
1.8%
2012 1
 
0.9%
2013 5
4.5%
2014 1
 
0.9%
ValueCountFrequency (%)
2022 3
 
2.7%
2021 4
 
3.6%
2020 12
10.9%
2019 27
24.5%
2018 15
13.6%
2017 14
12.7%
2016 5
 
4.5%
2015 5
 
4.5%
2014 1
 
0.9%
2013 5
 
4.5%

동영상송출여부
Boolean

Distinct2
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size242.0 B
True
58 
False
52 
ValueCountFrequency (%)
True 58
52.7%
False 52
47.3%
2023-12-11T06:31:41.365102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

표출면적
Real number (ℝ)

Distinct55
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.9645455
Minimum0.8
Maximum33.4
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-11T06:31:41.478092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.8
5-th percentile1.3
Q15.825
median8.2
Q311.175
95-th percentile16.155
Maximum33.4
Range32.6
Interquartile range (IQR)5.35

Descriptive statistics

Standard deviation5.646101
Coefficient of variation (CV)0.62982568
Kurtosis6.3767862
Mean8.9645455
Median Absolute Deviation (MAD)2.5
Skewness2.0232873
Sum986.1
Variance31.878456
MonotonicityNot monotonic
2023-12-11T06:31:41.625312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8.7 6
 
5.5%
12.0 6
 
5.5%
7.7 6
 
5.5%
1.3 6
 
5.5%
8.6 5
 
4.5%
6.5 4
 
3.6%
9.0 4
 
3.6%
5.1 3
 
2.7%
15.8 3
 
2.7%
4.6 3
 
2.7%
Other values (45) 64
58.2%
ValueCountFrequency (%)
0.8 1
 
0.9%
1.3 6
5.5%
1.5 1
 
0.9%
1.6 1
 
0.9%
2.5 1
 
0.9%
4.0 1
 
0.9%
4.1 3
2.7%
4.2 1
 
0.9%
4.3 1
 
0.9%
4.4 1
 
0.9%
ValueCountFrequency (%)
33.4 1
 
0.9%
32.6 1
 
0.9%
28.0 2
1.8%
16.6 1
 
0.9%
16.2 1
 
0.9%
16.1 1
 
0.9%
15.8 3
2.7%
14.8 1
 
0.9%
14.3 2
1.8%
14.1 1
 
0.9%

표출방식
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size1012.0 B
양면
90 
단면
19 
3면
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)0.9%

Sample

1st row양면
2nd row양면
3rd row양면
4th row양면
5th row양면

Common Values

ValueCountFrequency (%)
양면 90
81.8%
단면 19
 
17.3%
3면 1
 
0.9%

Length

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

Common Values (Plot)

2023-12-11T06:31:41.926969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양면 90
81.8%
단면 19
 
17.3%
3면 1
 
0.9%

표출시간
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)16.4%
Missing0
Missing (%)0.0%
Memory size1012.0 B
07:00~22:00
37 
00:00~24:00
23 
08:00~20:00
11 
06:00~22:00
10 
07:00~23:00
6 
Other values (13)
23 

Length

Max length17
Median length11
Mean length11.272727
Min length11

Unique

Unique7 ?
Unique (%)6.4%

Sample

1st row07:00~22:00
2nd row07:00~22:00
3rd row07:00~22:00
4th row07:00~22:00
5th row07:00~22:00

Common Values

ValueCountFrequency (%)
07:00~22:00 37
33.6%
00:00~24:00 23
20.9%
08:00~20:00 11
 
10.0%
06:00~22:00 10
 
9.1%
07:00~23:00 6
 
5.5%
07:00~21:00(14시간) 5
 
4.5%
05:00~22:00 3
 
2.7%
08:00~21:00 2
 
1.8%
07:00~21:00 2
 
1.8%
06:00~22:30 2
 
1.8%
Other values (8) 9
 
8.2%

Length

2023-12-11T06:31:42.039742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
07:00~22:00 37
33.6%
00:00~24:00 23
20.9%
08:00~20:00 11
 
10.0%
06:00~22:00 10
 
9.1%
07:00~23:00 6
 
5.5%
07:00~21:00(14시간 5
 
4.5%
05:00~22:00 3
 
2.7%
06:00~23:00 2
 
1.8%
06:00~22:30 2
 
1.8%
07:00~21:00 2
 
1.8%
Other values (8) 9
 
8.2%

표출내용
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size1012.0 B
대기환경정보+지자체 환경정책 홍보
68 
대기환경정보
13 
대기환경정보+지자체 정책 홍보
11 
대기환경정보(날씨, 대기오염물질 농도, 주의보 발령사항 등)
 
5
대기환경정보＋지자체 정책 홍보
 
4
Other values (5)
9 

Length

Max length49
Median length18
Mean length17.418182
Min length6

Unique

Unique2 ?
Unique (%)1.8%

Sample

1st row대기환경정보+지자체 환경정책 홍보
2nd row대기환경정보+지자체 환경정책 홍보
3rd row대기환경정보+지자체 환경정책 홍보
4th row대기환경정보+지자체 환경정책 홍보
5th row대기환경정보+지자체 환경정책 홍보

Common Values

ValueCountFrequency (%)
대기환경정보+지자체 환경정책 홍보 68
61.8%
대기환경정보 13
 
11.8%
대기환경정보+지자체 정책 홍보 11
 
10.0%
대기환경정보(날씨, 대기오염물질 농도, 주의보 발령사항 등) 5
 
4.5%
대기환경정보＋지자체 정책 홍보 4
 
3.6%
대기환경정보, 지자체환경정책 홍보 3
 
2.7%
대기환경정보+지자체 정책홍보 2
 
1.8%
대기환경정보(날씨, 대기오염물질 농도, 주의보 발령사항, 행동요령 등)+지자체 정책 홍보 2
 
1.8%
누전으로 운영 일시중단 1
 
0.9%
대기환경정보+교통,환경,재난 1
 
0.9%

Length

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

Common Values (Plot)

2023-12-11T06:31:42.263125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
홍보 88
26.9%
대기환경정보+지자체 81
24.8%
환경정책 68
20.8%
정책 17
 
5.2%
대기환경정보 16
 
4.9%
대기환경정보(날씨 7
 
2.1%
대기오염물질 7
 
2.1%
농도 7
 
2.1%
주의보 7
 
2.1%
발령사항 7
 
2.1%
Other values (10) 22
 
6.7%

Interactions

2023-12-11T06:31:39.833565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:31:39.663814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:31:39.937617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T06:31:39.740230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T06:31:42.371889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명구분설치및교체연도동영상송출여부표출면적표출방식표출시간표출내용
시군명1.0000.6230.3820.6980.8300.7060.9610.987
구분0.6231.0000.3520.0000.0410.0580.3450.000
설치및교체연도0.3820.3521.0000.4600.4460.7650.6420.323
동영상송출여부0.6980.0000.4601.0000.3450.1960.5600.402
표출면적0.8300.0410.4460.3451.0000.5870.6580.520
표출방식0.7060.0580.7650.1960.5871.0000.2860.000
표출시간0.9610.3450.6420.5600.6580.2861.0000.835
표출내용0.9870.0000.3230.4020.5200.0000.8351.000
2023-12-11T06:31:42.504700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
표출시간표출내용표출방식구분시군명동영상송출여부
표출시간1.0000.4910.1210.2480.6320.409
표출내용0.4911.0000.0000.0000.7330.296
표출방식0.1210.0001.0000.0940.3800.320
구분0.2480.0000.0941.0000.4290.000
시군명0.6320.7330.3800.4291.0000.486
동영상송출여부0.4090.2960.3200.0000.4861.000
2023-12-11T06:31:42.599736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치및교체연도표출면적시군명구분동영상송출여부표출방식표출시간표출내용
설치및교체연도1.0000.2550.0430.3310.4430.4470.2400.169
표출면적0.2551.0000.4690.0370.3600.4690.3440.290
시군명0.0430.4691.0000.4290.4860.3800.6320.733
구분0.3310.0370.4291.0000.0000.0940.2480.000
동영상송출여부0.4430.3600.4860.0001.0000.3200.4090.296
표출방식0.4470.4690.3800.0940.3201.0000.1210.000
표출시간0.2400.3440.6320.2480.4090.1211.0000.491
표출내용0.1690.2900.7330.0000.2960.0000.4911.000

Missing values

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

시군명설치위치구분설치및교체연도동영상송출여부표출면적표출방식표출시간표출내용
0수원시권선구 권선동 1120교체2019Y6.4양면07:00~22:00대기환경정보+지자체 환경정책 홍보
1수원시권선구 세류동 1215교체2019Y7.0양면07:00~22:00대기환경정보+지자체 환경정책 홍보
2수원시장안구 파장동 128-10교체2019Y8.6양면07:00~22:00대기환경정보+지자체 환경정책 홍보
3수원시권선구 구운동 920설치2009N6.8양면07:00~22:00대기환경정보+지자체 환경정책 홍보
4수원시영통구 중부대로 440설치2013N5.7양면07:00~22:00대기환경정보+지자체 환경정책 홍보
5수원시영통구 광교로 116설치2013N5.7양면07:00~22:00대기환경정보+지자체 환경정책 홍보
6수원시권선구 호매실동 1435설치2014N6.9양면07:00~22:00대기환경정보+지자체 환경정책 홍보
7수원시영통구 봉영로 1617교체2016Y8.2양면07:00~22:00대기환경정보+지자체 환경정책 홍보
8수원시영통구 망포동 38-3설치2018Y7.7양면07:00~22:00대기환경정보+지자체 환경정책 홍보
9수원시권선구 세화로 136설치2018N1.5단면07:00~22:00대기환경정보+지자체 환경정책 홍보
시군명설치위치구분설치및교체연도동영상송출여부표출면적표출방식표출시간표출내용
100시흥시시흥시 하중동 137-94설치2020N4.4양면07:00~22:00대기환경정보+지자체 정책 홍보
101시흥시시흥시 정왕동 1789설치2009N8.6양면07:00~23:00대기환경정보+지자체 정책 홍보
102김포시사우동 909 (사우고등학교 앞)교체2019Y4.0양면07:00~22:00대기환경정보(날씨, 대기오염물질 농도, 주의보 발령사항, 행동요령 등)+지자체 정책 홍보
103김포시구래동 6928-2 (호수공원입구 사거리)설치2017Y7.7양면07:00~22:00대기환경정보(날씨, 대기오염물질 농도, 주의보 발령사항, 행동요령 등)+지자체 정책 홍보
104파주시중앙로 240 (한국농어촌공사 앞)교체2019Y5.1양면06:00~22:00대기환경정보+지자체 환경정책 홍보
105파주시문산읍 문산리 17-8 (문산행정복지센터 앞)설치2018Y5.1양면06:00~22:00대기환경정보+지자체 환경정책 홍보
106의정부시의정부시 시민로 118설치2016Y8.8양면00:00~24:00대기환경정보+지자체 환경정책 홍보
107의정부시의정부시 민락동 800-7설치2017Y16.2양면00:00~24:00대기환경정보+지자체 환경정책 홍보
108광주시광주시 송정동 529설치2008N11.4양면05:00~22:00대기환경정보+지자체 환경정책 홍보
109광주시광주시 고산동 241-6설치2020N14.3양면05:00~22:00대기환경정보+지자체 환경정책 홍보