Overview

Dataset statistics

Number of variables8
Number of observations102
Missing cells16
Missing cells (%)2.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.5 KiB
Average record size in memory65.3 B

Variable types

Categorical3
Text3
DateTime2

Dataset

Description본 공공데이터는 전라북도 완주군 대기배출시설 설치사업장 현황(시설구분, 사업장명, 업종, 주소, 사업장전화번호, 종별, 신고/허가일자) 내역을 제공하고 있습니다.
Author전북특별자치도 완주군
URLhttps://www.data.go.kr/data/15077998/fileData.do

Alerts

시설구분 has constant value ""Constant
기준일자 has constant value ""Constant
대표업종 is highly overall correlated with 종High correlation
종 is highly overall correlated with 대표업종High correlation
전화번호 has 16 (15.7%) missing valuesMissing

Reproduction

Analysis started2024-04-06 08:25:12.076434
Analysis finished2024-04-06 08:25:14.613456
Duration2.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size948.0 B
대기배출시설
102 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대기배출시설
2nd row대기배출시설
3rd row대기배출시설
4th row대기배출시설
5th row대기배출시설

Common Values

ValueCountFrequency (%)
대기배출시설 102
100.0%

Length

2024-04-06T17:25:14.736684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:25:14.922124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대기배출시설 102
100.0%

사업장명
Text

Distinct100
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size948.0 B
2024-04-06T17:25:15.376540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length8.8529412
Min length3

Characters and Unicode

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

Unique

Unique98 ?
Unique (%)96.1%

Sample

1st row(주)팔마
2nd row(주)강동콘크리트
3rd row(유)우진산업사
4th row(유)호경완주지점
5th row제일콘크리트공업(주)
ValueCountFrequency (%)
주식회사 6
 
4.8%
유한회사 3
 
2.4%
유)우진산업사 2
 
1.6%
주)강동 2
 
1.6%
농업회사법인 2
 
1.6%
유)신동진산업 1
 
0.8%
농업회사법인(주)대성팜 1
 
0.8%
봉동영농조합법인 1
 
0.8%
유)아우디중산전주써비스센타 1
 
0.8%
주)팔마 1
 
0.8%
Other values (105) 105
84.0%
2024-04-06T17:25:16.180634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 62
 
6.9%
( 57
 
6.3%
) 57
 
6.3%
유 27
 
3.0%
사 26
 
2.9%
업 25
 
2.8%
23
 
2.5%
동 19
 
2.1%
전 19
 
2.1%
공 18
 
2.0%
Other values (189) 570
63.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 749
82.9%
Open Punctuation 57
 
6.3%
Close Punctuation 57
 
6.3%
Space Separator 23
 
2.5%
Uppercase Letter 14
 
1.6%
Other Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 62
 
8.3%
유 27
 
3.6%
사 26
 
3.5%
업 25
 
3.3%
동 19
 
2.5%
전 19
 
2.5%
공 18
 
2.4%
산 17
 
2.3%
스 15
 
2.0%
농 14
 
1.9%
Other values (176) 507
67.7%
Uppercase Letter
ValueCountFrequency (%)
C 5
35.7%
S 2
 
14.3%
K 2
 
14.3%
R 1
 
7.1%
L 1
 
7.1%
D 1
 
7.1%
M 1
 
7.1%
J 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
/ 2
66.7%
. 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 57
100.0%
Close Punctuation
ValueCountFrequency (%)
) 57
100.0%
Space Separator
ValueCountFrequency (%)
23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 749
82.9%
Common 140
 
15.5%
Latin 14
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 62
 
8.3%
유 27
 
3.6%
사 26
 
3.5%
업 25
 
3.3%
동 19
 
2.5%
전 19
 
2.5%
공 18
 
2.4%
산 17
 
2.3%
스 15
 
2.0%
농 14
 
1.9%
Other values (176) 507
67.7%
Latin
ValueCountFrequency (%)
C 5
35.7%
S 2
 
14.3%
K 2
 
14.3%
R 1
 
7.1%
L 1
 
7.1%
D 1
 
7.1%
M 1
 
7.1%
J 1
 
7.1%
Common
ValueCountFrequency (%)
( 57
40.7%
) 57
40.7%
23
16.4%
/ 2
 
1.4%
. 1
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 749
82.9%
ASCII 154
 
17.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 62
 
8.3%
유 27
 
3.6%
사 26
 
3.5%
업 25
 
3.3%
동 19
 
2.5%
전 19
 
2.5%
공 18
 
2.4%
산 17
 
2.3%
스 15
 
2.0%
농 14
 
1.9%
Other values (176) 507
67.7%
ASCII
ValueCountFrequency (%)
( 57
37.0%
) 57
37.0%
23
14.9%
C 5
 
3.2%
/ 2
 
1.3%
S 2
 
1.3%
K 2
 
1.3%
R 1
 
0.6%
L 1
 
0.6%
D 1
 
0.6%
Other values (3) 3
 
1.9%

소재지
Text

Distinct99
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size948.0 B
2024-04-06T17:25:16.979033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length36
Mean length26.421569
Min length21

Characters and Unicode

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

Unique

Unique96 ?
Unique (%)94.1%

Sample

1st row전북특별자치도 완주군 봉동읍 봉동로 678-74
2nd row전북특별자치도 완주군 상관면 신리로 153
3rd row전북특별자치도 완주군 소양면 전진로 860-13
4th row전북특별자치도 완주군 봉동읍 봉동로 810-74
5th row전북특별자치도 완주군 이서면 이문길 105-65
ValueCountFrequency (%)
전북특별자치도 102
19.1%
완주군 102
19.1%
봉동읍 24
 
4.5%
이서면 19
 
3.6%
삼례읍 12
 
2.2%
소양면 12
 
2.2%
봉동로 11
 
2.1%
고산면 7
 
1.3%
용진읍 7
 
1.3%
비봉면 7
 
1.3%
Other values (178) 231
43.3%
2024-04-06T17:25:18.256518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
444
 
16.5%
주 113
 
4.2%
전 107
 
4.0%
완 105
 
3.9%
자 104
 
3.9%
치 103
 
3.8%
도 103
 
3.8%
특 103
 
3.8%
북 103
 
3.8%
별 102
 
3.8%
Other values (151) 1308
48.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1817
67.4%
Space Separator 444
 
16.5%
Decimal Number 369
 
13.7%
Dash Punctuation 46
 
1.7%
Open Punctuation 9
 
0.3%
Close Punctuation 9
 
0.3%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 113
 
6.2%
전 107
 
5.9%
완 105
 
5.8%
자 104
 
5.7%
치 103
 
5.7%
도 103
 
5.7%
특 103
 
5.7%
북 103
 
5.7%
별 102
 
5.6%
군 102
 
5.6%
Other values (136) 772
42.5%
Decimal Number
ValueCountFrequency (%)
1 63
17.1%
2 44
11.9%
4 44
11.9%
3 40
10.8%
6 37
10.0%
5 34
9.2%
0 34
9.2%
9 32
8.7%
7 23
 
6.2%
8 18
 
4.9%
Space Separator
ValueCountFrequency (%)
444
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1817
67.4%
Common 878
32.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 113
 
6.2%
전 107
 
5.9%
완 105
 
5.8%
자 104
 
5.7%
치 103
 
5.7%
도 103
 
5.7%
특 103
 
5.7%
북 103
 
5.7%
별 102
 
5.6%
군 102
 
5.6%
Other values (136) 772
42.5%
Common
ValueCountFrequency (%)
444
50.6%
1 63
 
7.2%
- 46
 
5.2%
2 44
 
5.0%
4 44
 
5.0%
3 40
 
4.6%
6 37
 
4.2%
5 34
 
3.9%
0 34
 
3.9%
9 32
 
3.6%
Other values (5) 60
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1817
67.4%
ASCII 878
32.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
444
50.6%
1 63
 
7.2%
- 46
 
5.2%
2 44
 
5.0%
4 44
 
5.0%
3 40
 
4.6%
6 37
 
4.2%
5 34
 
3.9%
0 34
 
3.9%
9 32
 
3.6%
Other values (5) 60
 
6.8%
Hangul
ValueCountFrequency (%)
주 113
 
6.2%
전 107
 
5.9%
완 105
 
5.8%
자 104
 
5.7%
치 103
 
5.7%
도 103
 
5.7%
특 103
 
5.7%
북 103
 
5.7%
별 102
 
5.6%
군 102
 
5.6%
Other values (136) 772
42.5%

전화번호
Text

MISSING 

Distinct79
Distinct (%)91.9%
Missing16
Missing (%)15.7%
Memory size948.0 B
2024-04-06T17:25:18.961802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.627907
Min length1

Characters and Unicode

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

Unique

Unique73 ?
Unique (%)84.9%

Sample

1st row063-262-6801
2nd row063-284-8889
3rd row063-243-8500
4th row063-262-1114
5th row063-222-7005
ValueCountFrequency (%)
063 4
 
4.4%
063-222-6605 2
 
2.2%
063-261-6827 2
 
2.2%
063-222-7400 2
 
2.2%
063-225-0354 2
 
2.2%
063-243-8500 2
 
2.2%
261 2
 
2.2%
063-262-5318 1
 
1.1%
063-219-9117 1
 
1.1%
063-229-7474 1
 
1.1%
Other values (71) 71
78.9%
2024-04-06T17:25:19.834639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 169
16.9%
- 158
15.8%
6 148
14.8%
2 136
13.6%
3 125
12.5%
1 62
 
6.2%
4 46
 
4.6%
7 43
 
4.3%
5 34
 
3.4%
8 34
 
3.4%
Other values (2) 45
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 831
83.1%
Dash Punctuation 158
 
15.8%
Space Separator 11
 
1.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 169
20.3%
6 148
17.8%
2 136
16.4%
3 125
15.0%
1 62
 
7.5%
4 46
 
5.5%
7 43
 
5.2%
5 34
 
4.1%
8 34
 
4.1%
9 34
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 158
100.0%
Space Separator
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1000
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 169
16.9%
- 158
15.8%
6 148
14.8%
2 136
13.6%
3 125
12.5%
1 62
 
6.2%
4 46
 
4.6%
7 43
 
4.3%
5 34
 
3.4%
8 34
 
3.4%
Other values (2) 45
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 169
16.9%
- 158
15.8%
6 148
14.8%
2 136
13.6%
3 125
12.5%
1 62
 
6.2%
4 46
 
4.6%
7 43
 
4.3%
5 34
 
3.4%
8 34
 
3.4%
Other values (2) 45
 
4.5%

대표업종
Categorical

HIGH CORRELATION 

Distinct48
Distinct (%)47.1%
Missing0
Missing (%)0.0%
Memory size948.0 B
자동차 종합 수리업
20 
14 
곡물 도정업
 
5
비금속원료 재생업
 
5
기타 비료 및 질소화합물 제조업
 
4
Other values (43)
54 

Length

Max length24
Median length18
Mean length9.872549
Min length1

Unique

Unique34 ?
Unique (%)33.3%

Sample

1st row비금속광물제품 제조업
2nd row콘크리트 시멘트 및 플라스터 제품 제조업
3rd row
4th row
5th row

Common Values

ValueCountFrequency (%)
자동차 종합 수리업 20
19.6%
14
 
13.7%
곡물 도정업 5
 
4.9%
비금속원료 재생업 5
 
4.9%
기타 비료 및 질소화합물 제조업 4
 
3.9%
아스콘 제조업 3
 
2.9%
일반 공공 행정 3
 
2.9%
폐기물 처리업 2
 
2.0%
레미콘 제조업 2
 
2.0%
금속선 가공제품 제조업 2
 
2.0%
Other values (38) 42
41.2%

Length

2024-04-06T17:25:20.144116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제조업 29
 
10.1%
및 27
 
9.4%
자동차 21
 
7.3%
수리업 21
 
7.3%
종합 20
 
7.0%
기타 8
 
2.8%
비료 7
 
2.4%
재생업 7
 
2.4%
질소화합물 6
 
2.1%
곡물 6
 
2.1%
Other values (88) 134
46.9%

종
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size948.0 B
5종
54 
4종
39 
2종
6 
3종
 
2
1종
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
5종 54
52.9%
4종 39
38.2%
2종 6
 
5.9%
3종 2
 
2.0%
1종 1
 
1.0%

Length

2024-04-06T17:25:20.424433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:25:20.772549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5종 54
52.9%
4종 39
38.2%
2종 6
 
5.9%
3종 2
 
2.0%
1종 1
 
1.0%

허가(신고)일자
Date

Distinct95
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size948.0 B
Minimum1978-03-17 00:00:00
Maximum2023-11-30 00:00:00
2024-04-06T17:25:21.037392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:25:21.390094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size948.0 B
Minimum2024-02-08 00:00:00
Maximum2024-02-08 00:00:00
2024-04-06T17:25:21.636739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:25:22.303347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-04-06T17:25:22.598699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업장명소재지전화번호대표업종종허가(신고)일자
사업장명1.0000.9921.0000.9900.7430.990
소재지0.9921.0000.9990.4160.0000.989
전화번호1.0000.9991.0000.9860.6920.970
대표업종0.9900.4160.9861.0000.9280.000
종0.7430.0000.6920.9281.0000.000
허가(신고)일자0.9900.9890.9700.0000.0001.000
2024-04-06T17:25:22.808702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종대표업종
종1.0000.546
대표업종0.5461.000
2024-04-06T17:25:22.956771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대표업종종
대표업종1.0000.546
종0.5461.000

Missing values

2024-04-06T17:25:14.282610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:25:14.518982image/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대기배출시설(주)팔마전북특별자치도 완주군 봉동읍 봉동로 678-74063-262-6801비금속광물제품 제조업4종1997-07-142024-02-08
1대기배출시설(주)강동콘크리트전북특별자치도 완주군 상관면 신리로 153063-284-8889콘크리트 시멘트 및 플라스터 제품 제조업4종1978-03-172024-02-08
2대기배출시설(유)우진산업사전북특별자치도 완주군 소양면 전진로 860-13063-243-85002종1982-05-262024-02-08
3대기배출시설(유)호경완주지점전북특별자치도 완주군 봉동읍 봉동로 810-74063-262-11142종2000-10-102024-02-08
4대기배출시설제일콘크리트공업(주)전북특별자치도 완주군 이서면 이문길 105-65063-222-70054종1989-02-102024-02-08
5대기배출시설(주)강동전북특별자치도 완주군 봉동읍 둔산신봉길 10063-261-6827레미콘 제조업4종1989-10-102024-02-08
6대기배출시설(주)삼보전북특별자치도 완주군 구이면 계안로 395063-222-7400아스콘 제조업2종1990-01-102024-02-08
7대기배출시설유한회사 성원레미콘전북특별자치도 완주군 소양면 전진로 910063-243-6611시멘트 석회 플라스터 및 그 제품 제조업5종1990-03-122024-02-08
8대기배출시설(주)동양/건재부문 전주공장전북특별자치도 완주군 봉동읍 봉동로 453-30063-261-68675종1990-05-212024-02-08
9대기배출시설선진공업(주)전북특별자치도 완주군 상관면 춘향로 4503-7063-232-44515종1992-09-262024-02-08
시설구분사업장명소재지전화번호대표업종종허가(신고)일자기준일자
92대기배출시설한국과학기술연구원전북특별자치도 완주군 봉동읍 추동로 92 한국과학기술연구원 전북분원063-219-8406연구 및 개발업5종2022-01-062024-02-08
93대기배출시설전주 하늘전북특별자치도 완주군 소양면 전진로 1630 현대오일뱅크<NA>애완동물 장묘 및 보호 서비스업5종2022-02-222024-02-08
94대기배출시설스마트 정비 종합검사소전북특별자치도 완주군 삼례읍 과학로 600-5063-261-0999자동차 종합 수리업5종2022-02-232024-02-08
95대기배출시설(유)우진산업사전북특별자치도 완주군 소양면 해월리 산 208-1063-243-8500석재 쇄석 및 모래자갈 채취업4종2022-03-172024-02-08
96대기배출시설눈부신자연애바이오(주)전북특별자치도 완주군 소양면 마수길 1-1063-902-6603비료 및 질소화합물 제조업5종2022-01-202024-02-08
97대기배출시설LS엠트론(주) 생활관전북특별자치도 완주군 봉동읍 봉동로 408 엘에스엠트론(주) 생활관063-279-5260농업용 기계 제조업5종2022-11-292024-02-08
98대기배출시설신고랑정미소전북특별자치도 완주군 삼례읍 용와로 94<NA>곡물 도정업5종2023-01-182024-02-08
99대기배출시설(유)삼덕산업개발전북특별자치도 완주군 고산면 대아저수로 179-64063-263-8710건설용 석재 채굴 및 쇄석 생산업4종2023-06-152024-02-08
100대기배출시설(유)신동진산업전북특별자치도 완주군 봉동읍 봉동로 911-66<NA>폐기물 처리업5종2023-07-032024-02-08
101대기배출시설석우산업(주)전북특별자치도 완주군 이서면 은교리 116-16<NA>비금속광물 분쇄물 생산업5종2023-11-302024-02-08