Overview

Dataset statistics

Number of variables17
Number of observations69
Missing cells782
Missing cells (%)66.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.3 KiB
Average record size in memory137.9 B

Variable types

Unsupported14
Text3

Dataset

Description환경전문공사업등환경산업체현황엑셀
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=203087

Alerts

환경산업체 현황 has 1 (1.4%) missing valuesMissing
Unnamed: 1 has 2 (2.9%) missing valuesMissing
Unnamed: 2 has 3 (4.3%) missing valuesMissing
Unnamed: 3 has 55 (79.7%) missing valuesMissing
Unnamed: 4 has 32 (46.4%) missing valuesMissing
Unnamed: 5 has 59 (85.5%) missing valuesMissing
Unnamed: 6 has 56 (81.2%) missing valuesMissing
Unnamed: 7 has 66 (95.7%) missing valuesMissing
Unnamed: 8 has 59 (85.5%) missing valuesMissing
Unnamed: 9 has 61 (88.4%) missing valuesMissing
Unnamed: 10 has 65 (94.2%) missing valuesMissing
Unnamed: 11 has 66 (95.7%) missing valuesMissing
Unnamed: 12 has 63 (91.3%) missing valuesMissing
Unnamed: 13 has 63 (91.3%) missing valuesMissing
Unnamed: 14 has 66 (95.7%) missing valuesMissing
Unnamed: 15 has 64 (92.8%) missing valuesMissing
Unnamed: 16 has 1 (1.4%) missing valuesMissing
환경산업체 현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 03:26:03.658326
Analysis finished2024-03-14 03:26:04.467039
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

환경산업체 현황
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)1.4%
Memory size684.0 B

Unnamed: 1
Text

MISSING 

Distinct67
Distinct (%)100.0%
Missing2
Missing (%)2.9%
Memory size684.0 B
2024-03-14T12:26:04.634401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length10
Mean length7.5373134
Min length3

Characters and Unicode

Total characters505
Distinct characters134
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique67 ?
Unique (%)100.0%

Sample

1st row업체명
2nd row광진환경㈜
3rd row(유)지구엔비텍
4th row(주)이앤에스테크
5th row㈜청송이앤티
ValueCountFrequency (%)
유)한백종합건설 1
 
1.4%
주)이레엔텍 1
 
1.4%
유)반석환경 1
 
1.4%
유)태헌건설 1
 
1.4%
㈜파인리포먼스 1
 
1.4%
유)대금환경 1
 
1.4%
유)도영종합건설 1
 
1.4%
㈜코엔텍 1
 
1.4%
재)한국환경과학기술연구원 1
 
1.4%
㈜공유 1
 
1.4%
Other values (60) 60
85.7%
2024-03-14T12:26:04.972866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 36
 
7.1%
) 36
 
7.1%
㈜ 28
 
5.5%
유 28
 
5.5%
환 24
 
4.8%
경 24
 
4.8%
이 18
 
3.6%
엔 13
 
2.6%
산 10
 
2.0%
건 10
 
2.0%
Other values (124) 278
55.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 402
79.6%
Open Punctuation 36
 
7.1%
Close Punctuation 36
 
7.1%
Other Symbol 28
 
5.5%
Space Separator 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 28
 
7.0%
환 24
 
6.0%
경 24
 
6.0%
이 18
 
4.5%
엔 13
 
3.2%
산 10
 
2.5%
건 10
 
2.5%
업 9
 
2.2%
설 9
 
2.2%
원 8
 
2.0%
Other values (120) 249
61.9%
Open Punctuation
ValueCountFrequency (%)
( 36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 28
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 430
85.1%
Common 75
 
14.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
㈜ 28
 
6.5%
유 28
 
6.5%
환 24
 
5.6%
경 24
 
5.6%
이 18
 
4.2%
엔 13
 
3.0%
산 10
 
2.3%
건 10
 
2.3%
업 9
 
2.1%
설 9
 
2.1%
Other values (121) 257
59.8%
Common
ValueCountFrequency (%)
( 36
48.0%
) 36
48.0%
3
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 402
79.6%
ASCII 75
 
14.9%
None 28
 
5.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 36
48.0%
) 36
48.0%
3
 
4.0%
None
ValueCountFrequency (%)
㈜ 28
100.0%
Hangul
ValueCountFrequency (%)
유 28
 
7.0%
환 24
 
6.0%
경 24
 
6.0%
이 18
 
4.5%
엔 13
 
3.2%
산 10
 
2.5%
건 10
 
2.5%
업 9
 
2.2%
설 9
 
2.2%
원 8
 
2.0%
Other values (120) 249
61.9%

Unnamed: 2
Text

MISSING 

Distinct66
Distinct (%)100.0%
Missing3
Missing (%)4.3%
Memory size684.0 B
2024-03-14T12:26:05.264107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length23.5
Mean length20.272727
Min length4

Characters and Unicode

Total characters1338
Distinct characters150
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique66 ?
Unique (%)100.0%

Sample

1st row주 소
2nd row전주시 덕진구 호반3길 7 (덕진동2가)
3rd row전주시 덕진구 비석날로 99 (팔복동2가)
4th row전주시 완산구 서곡6길 23-4 (효자동3가)
5th row전주시 덕진구 동부대로 727 (우아동3가)
ValueCountFrequency (%)
전주시 37
 
13.7%
덕진구 22
 
8.1%
완산구 15
 
5.6%
익산시 10
 
3.7%
군산시 9
 
3.3%
우아동3가 3
 
1.1%
부안읍 2
 
0.7%
서동로 2
 
0.7%
김제시 2
 
0.7%
외항로 2
 
0.7%
Other values (160) 166
61.5%
2024-03-14T12:26:05.724228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
205
 
15.3%
시 61
 
4.6%
1 61
 
4.6%
동 52
 
3.9%
) 43
 
3.2%
산 43
 
3.2%
( 43
 
3.2%
전 40
 
3.0%
주 38
 
2.8%
구 38
 
2.8%
Other values (140) 714
53.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 746
55.8%
Decimal Number 259
 
19.4%
Space Separator 206
 
15.4%
Close Punctuation 43
 
3.2%
Open Punctuation 43
 
3.2%
Dash Punctuation 21
 
1.6%
Other Punctuation 18
 
1.3%
Uppercase Letter 1
 
0.1%
Control 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 61
 
8.2%
동 52
 
7.0%
산 43
 
5.8%
전 40
 
5.4%
주 38
 
5.1%
구 38
 
5.1%
로 38
 
5.1%
길 32
 
4.3%
진 28
 
3.8%
덕 26
 
3.5%
Other values (122) 350
46.9%
Decimal Number
ValueCountFrequency (%)
1 61
23.6%
2 36
13.9%
3 36
13.9%
0 24
 
9.3%
4 23
 
8.9%
5 22
 
8.5%
7 21
 
8.1%
8 18
 
6.9%
9 11
 
4.2%
6 7
 
2.7%
Space Separator
ValueCountFrequency (%)
205
99.5%
  1
 
0.5%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%
Other Punctuation
ValueCountFrequency (%)
, 18
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 746
55.8%
Common 591
44.2%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 61
 
8.2%
동 52
 
7.0%
산 43
 
5.8%
전 40
 
5.4%
주 38
 
5.1%
구 38
 
5.1%
로 38
 
5.1%
길 32
 
4.3%
진 28
 
3.8%
덕 26
 
3.5%
Other values (122) 350
46.9%
Common
ValueCountFrequency (%)
205
34.7%
1 61
 
10.3%
) 43
 
7.3%
( 43
 
7.3%
2 36
 
6.1%
3 36
 
6.1%
0 24
 
4.1%
4 23
 
3.9%
5 22
 
3.7%
7 21
 
3.6%
Other values (7) 77
 
13.0%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 746
55.8%
ASCII 591
44.2%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
205
34.7%
1 61
 
10.3%
) 43
 
7.3%
( 43
 
7.3%
2 36
 
6.1%
3 36
 
6.1%
0 24
 
4.1%
4 23
 
3.9%
5 22
 
3.7%
7 21
 
3.6%
Other values (7) 77
 
13.0%
Hangul
ValueCountFrequency (%)
시 61
 
8.2%
동 52
 
7.0%
산 43
 
5.8%
전 40
 
5.4%
주 38
 
5.1%
구 38
 
5.1%
로 38
 
5.1%
길 32
 
4.3%
진 28
 
3.8%
덕 26
 
3.5%
Other values (122) 350
46.9%
None
ValueCountFrequency (%)
  1
100.0%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing55
Missing (%)79.7%
Memory size684.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing32
Missing (%)46.4%
Memory size684.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing59
Missing (%)85.5%
Memory size684.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing56
Missing (%)81.2%
Memory size684.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing66
Missing (%)95.7%
Memory size684.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing59
Missing (%)85.5%
Memory size684.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing61
Missing (%)88.4%
Memory size684.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing65
Missing (%)94.2%
Memory size684.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing66
Missing (%)95.7%
Memory size684.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)91.3%
Memory size684.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)91.3%
Memory size684.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing66
Missing (%)95.7%
Memory size684.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing64
Missing (%)92.8%
Memory size684.0 B

Unnamed: 16
Text

MISSING 

Distinct67
Distinct (%)98.5%
Missing1
Missing (%)1.4%
Memory size684.0 B
2024-03-14T12:26:05.953072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length8
Mean length7.9705882
Min length3

Characters and Unicode

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

Unique

Unique66 ?
Unique (%)97.1%

Sample

1st row사무실
2nd rowmobile
3rd row254-8150
4th row211-8001
5th row273-5251
ValueCountFrequency (%)
242-4690 2
 
2.9%
212-8878 1
 
1.5%
831-8266 1
 
1.5%
468-2077 1
 
1.5%
226-4538 1
 
1.5%
834-0821 1
 
1.5%
211-6001 1
 
1.5%
544-5617 1
 
1.5%
253-0762 1
 
1.5%
838-2700 1
 
1.5%
Other values (57) 57
83.8%
2024-03-14T12:26:06.264756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 92
17.0%
- 67
12.4%
4 50
9.2%
8 48
8.9%
3 47
8.7%
0 46
8.5%
1 45
8.3%
6 44
8.1%
5 43
7.9%
7 35
 
6.5%
Other values (10) 25
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 466
86.0%
Dash Punctuation 67
 
12.4%
Lowercase Letter 6
 
1.1%
Other Letter 3
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 92
19.7%
4 50
10.7%
8 48
10.3%
3 47
10.1%
0 46
9.9%
1 45
9.7%
6 44
9.4%
5 43
9.2%
7 35
 
7.5%
9 16
 
3.4%
Lowercase Letter
ValueCountFrequency (%)
m 1
16.7%
o 1
16.7%
b 1
16.7%
i 1
16.7%
l 1
16.7%
e 1
16.7%
Other Letter
ValueCountFrequency (%)
사 1
33.3%
무 1
33.3%
실 1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 67
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 533
98.3%
Latin 6
 
1.1%
Hangul 3
 
0.6%

Most frequent character per script

Common
ValueCountFrequency (%)
2 92
17.3%
- 67
12.6%
4 50
9.4%
8 48
9.0%
3 47
8.8%
0 46
8.6%
1 45
8.4%
6 44
8.3%
5 43
8.1%
7 35
 
6.6%
Latin
ValueCountFrequency (%)
m 1
16.7%
o 1
16.7%
b 1
16.7%
i 1
16.7%
l 1
16.7%
e 1
16.7%
Hangul
ValueCountFrequency (%)
사 1
33.3%
무 1
33.3%
실 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 539
99.4%
Hangul 3
 
0.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 92
17.1%
- 67
12.4%
4 50
9.3%
8 48
8.9%
3 47
8.7%
0 46
8.5%
1 45
8.3%
6 44
8.2%
5 43
8.0%
7 35
 
6.5%
Other values (7) 22
 
4.1%
Hangul
ValueCountFrequency (%)
사 1
33.3%
무 1
33.3%
실 1
33.3%

Correlations

2024-03-14T12:26:06.342438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 16
Unnamed: 11.0001.0001.000
Unnamed: 21.0001.0001.000
Unnamed: 161.0001.0001.000

Missing values

2024-03-14T12:26:03.937994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T12:26:04.124443image/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.
2024-03-14T12:26:04.295147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

환경산업체 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16
0구분업체명주 소전문공사NaN관리대행NaNNaN측정대행NaNNaNNaNNaN폐수처리업NaN컨설팅\n회사사무실
1NaN<NA><NA>대기수질대기수질유독물대기수질소음진동악취실내공기처리재활용NaNmobile
2합계<NA><NA>1135711176214313<NA>
31광진환경㈜전주시 덕진구 호반3길 7 (덕진동2가)NaN1NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaN254-8150
42(유)지구엔비텍전주시 덕진구 비석날로 99 (팔복동2가)111NaNNaN11NaNNaNNaNNaNNaNNaN211-8001
53(주)이앤에스테크전주시 완산구 서곡6길 23-4 (효자동3가)11NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN273-5251
64㈜청송이앤티전주시 덕진구 동부대로 727 (우아동3가)1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN242-4690
75㈜광산테크익산시 석암로13길 71 (팔봉동)1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN835-2823
86바다정수산업㈜진안군 진안읍 연장리 1781NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN242-4690
97(유)한백종합건설전주시 덕진구 도당산3길 8-4 (우아동3가)NaN1NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN242-4130
환경산업체 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16
5957㈜엔아이티군산시 서해로 627(소룡동)NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaN468-4141
6058한국수자원공사 전북지역본부전주시 덕진구 기린대로1025(여의동)NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaN281-1366
6159전북대학교 산학협력단(물환경연구센터)전주시 덕진구 반룡로 110-5 전북테크노파크(테크노빌A동)NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaN270-2442
6260원일환경㈜전주시 완산구 화산천변3길 15-4(중화산동2가)NaNNaNNaNNaNNaN111NaNNaNNaNNaNNaN227-2043
6361㈜이티엠센터전주시 덕진구 오공로 136,2층(만성동)NaNNaNNaNNaNNaN1NaNNaN1NaNNaNNaNNaN237-0731
6462㈜새롬에너지전주시 덕진구 오공로 138 5층(만성동)NaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaNNaN276-7586
6563㈜려원이엔씨<NA>NaNNaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaN273-8804
6664(사)대한산업보건협회 전북산업보건센타전주시 덕진구 기린대로 1030NaNNaN1NaNNaNNaNNaNNaNNaN1NaNNaNNaN225-1242
6765푸른환경연구소㈜전주시 덕진구 팔달로 310-7, 2층(진북동)NaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaN254-4009
6866㈜서해환경과학연구소전주시 덕진구 베미실마을길9 (호성동1가)NaNNaNNaNNaNNaNNaNNaNNaNNaN1NaNNaNNaN221-6420