Overview

Dataset statistics

Number of variables3
Number of observations1135
Missing cells0
Missing cells (%)0.0%
Duplicate rows15
Duplicate rows (%)1.3%
Total size in memory26.7 KiB
Average record size in memory24.1 B

Variable types

Text2
DateTime1

Dataset

Description도시환경 업무에 따른 제주특별자치도 제주시 관내에서 관리하고 있는 관리대상 기기 신고 관련 현황 데이터를 제공합니다.항목 : 업체명, 소재지 정보 제공
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/3083436/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 15 (1.3%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-06 08:38:35.246922
Analysis finished2024-04-06 08:38:36.718158
Duration1.47 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct1090
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
2024-04-06T17:38:37.126896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length21
Mean length7.7629956
Min length2

Characters and Unicode

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

Unique

Unique1053 ?
Unique (%)92.8%

Sample

1st row(주)에코파워텍
2nd row송당초등학교
3rd row제주의료원
4th row국립제주박물관
5th row라온레저개발(주)
ValueCountFrequency (%)
주식회사 7
 
0.6%
주)제주컨트리클럽 6
 
0.5%
한국전력공사 6
 
0.5%
주)케이티제주마케팅단 5
 
0.4%
주)경원산업 4
 
0.3%
범양건영(주 3
 
0.2%
제주문화방송(주 3
 
0.2%
그린스페이스휴2 3
 
0.2%
제주지역경제혁신센터 2
 
0.2%
물메초등학교 2
 
0.2%
Other values (1118) 1161
96.6%
2024-04-06T17:38:38.077644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 600
 
6.8%
제 320
 
3.6%
( 313
 
3.6%
) 313
 
3.6%
산 192
 
2.2%
교 136
 
1.5%
수 126
 
1.4%
학 123
 
1.4%
한 116
 
1.3%
원 112
 
1.3%
Other values (469) 6460
73.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7989
90.7%
Open Punctuation 313
 
3.6%
Close Punctuation 313
 
3.6%
Space Separator 68
 
0.8%
Decimal Number 68
 
0.8%
Uppercase Letter 48
 
0.5%
Other Punctuation 4
 
< 0.1%
Other Symbol 3
 
< 0.1%
Dash Punctuation 2
 
< 0.1%
Connector Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 600
 
7.5%
제 320
 
4.0%
산 192
 
2.4%
교 136
 
1.7%
수 126
 
1.6%
학 123
 
1.5%
한 116
 
1.5%
원 112
 
1.4%
트 108
 
1.4%
장 107
 
1.3%
Other values (435) 6049
75.7%
Uppercase Letter
ValueCountFrequency (%)
S 10
20.8%
K 8
16.7%
C 4
 
8.3%
P 4
 
8.3%
A 3
 
6.2%
E 3
 
6.2%
H 3
 
6.2%
L 3
 
6.2%
G 2
 
4.2%
B 1
 
2.1%
Other values (7) 7
14.6%
Decimal Number
ValueCountFrequency (%)
2 20
29.4%
1 18
26.5%
3 14
20.6%
5 5
 
7.4%
7 4
 
5.9%
4 4
 
5.9%
6 2
 
2.9%
9 1
 
1.5%
Other Punctuation
ValueCountFrequency (%)
. 3
75.0%
/ 1
 
25.0%
Open Punctuation
ValueCountFrequency (%)
( 313
100.0%
Close Punctuation
ValueCountFrequency (%)
) 313
100.0%
Space Separator
ValueCountFrequency (%)
68
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7992
90.7%
Common 770
 
8.7%
Latin 49
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 600
 
7.5%
제 320
 
4.0%
산 192
 
2.4%
교 136
 
1.7%
수 126
 
1.6%
학 123
 
1.5%
한 116
 
1.5%
원 112
 
1.4%
트 108
 
1.4%
장 107
 
1.3%
Other values (436) 6052
75.7%
Latin
ValueCountFrequency (%)
S 10
20.4%
K 8
16.3%
C 4
 
8.2%
P 4
 
8.2%
A 3
 
6.1%
E 3
 
6.1%
H 3
 
6.1%
L 3
 
6.1%
G 2
 
4.1%
B 1
 
2.0%
Other values (8) 8
16.3%
Common
ValueCountFrequency (%)
( 313
40.6%
) 313
40.6%
68
 
8.8%
2 20
 
2.6%
1 18
 
2.3%
3 14
 
1.8%
5 5
 
0.6%
7 4
 
0.5%
4 4
 
0.5%
. 3
 
0.4%
Other values (5) 8
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7989
90.7%
ASCII 819
 
9.3%
None 3
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 600
 
7.5%
제 320
 
4.0%
산 192
 
2.4%
교 136
 
1.7%
수 126
 
1.6%
학 123
 
1.5%
한 116
 
1.5%
원 112
 
1.4%
트 108
 
1.4%
장 107
 
1.3%
Other values (435) 6049
75.7%
ASCII
ValueCountFrequency (%)
( 313
38.2%
) 313
38.2%
68
 
8.3%
2 20
 
2.4%
1 18
 
2.2%
3 14
 
1.7%
S 10
 
1.2%
K 8
 
1.0%
5 5
 
0.6%
7 4
 
0.5%
Other values (23) 46
 
5.6%
None
ValueCountFrequency (%)
㈜ 3
100.0%

소재지
Text

Distinct1086
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
2024-04-06T17:38:39.277870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length65
Median length43
Mean length17.456388
Min length10

Characters and Unicode

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

Unique

Unique1047 ?
Unique (%)92.2%

Sample

1st row제주시 화북이동 2775
2nd row제주시 구좌읍 송당리 1366
3rd row제주시 아라일동 4-17
4th row제주시 건입동 261
5th row제주시 한경면 저지리 산 18번지 라온골프클럽
ValueCountFrequency (%)
제주시 1135
25.7%
연동 141
 
3.2%
애월읍 117
 
2.7%
1호 103
 
2.3%
한림읍 103
 
2.3%
구좌읍 97
 
2.2%
노형동 95
 
2.2%
조천읍 88
 
2.0%
건입동 42
 
1.0%
2호 42
 
1.0%
Other values (1188) 2446
55.5%
2024-04-06T17:38:40.819321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3306
16.7%
제 1154
 
5.8%
주 1153
 
5.8%
시 1137
 
5.7%
1 1079
 
5.4%
지 1022
 
5.2%
번 992
 
5.0%
2 754
 
3.8%
동 710
 
3.6%
3 510
 
2.6%
Other values (195) 7996
40.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11184
56.4%
Decimal Number 4913
24.8%
Space Separator 3306
 
16.7%
Dash Punctuation 312
 
1.6%
Connector Punctuation 42
 
0.2%
Open Punctuation 26
 
0.1%
Close Punctuation 26
 
0.1%
Uppercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
제 1154
 
10.3%
주 1153
 
10.3%
시 1137
 
10.2%
지 1022
 
9.1%
번 992
 
8.9%
동 710
 
6.3%
리 449
 
4.0%
호 415
 
3.7%
읍 409
 
3.7%
도 232
 
2.1%
Other values (177) 3511
31.4%
Decimal Number
ValueCountFrequency (%)
1 1079
22.0%
2 754
15.3%
3 510
10.4%
4 452
9.2%
5 396
 
8.1%
6 372
 
7.6%
7 355
 
7.2%
0 351
 
7.1%
9 326
 
6.6%
8 318
 
6.5%
Uppercase Letter
ValueCountFrequency (%)
A 2
50.0%
L 1
25.0%
K 1
25.0%
Space Separator
ValueCountFrequency (%)
3306
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 312
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 42
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11184
56.4%
Common 8625
43.5%
Latin 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
제 1154
 
10.3%
주 1153
 
10.3%
시 1137
 
10.2%
지 1022
 
9.1%
번 992
 
8.9%
동 710
 
6.3%
리 449
 
4.0%
호 415
 
3.7%
읍 409
 
3.7%
도 232
 
2.1%
Other values (177) 3511
31.4%
Common
ValueCountFrequency (%)
3306
38.3%
1 1079
 
12.5%
2 754
 
8.7%
3 510
 
5.9%
4 452
 
5.2%
5 396
 
4.6%
6 372
 
4.3%
7 355
 
4.1%
0 351
 
4.1%
9 326
 
3.8%
Other values (5) 724
 
8.4%
Latin
ValueCountFrequency (%)
A 2
50.0%
L 1
25.0%
K 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11184
56.4%
ASCII 8629
43.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3306
38.3%
1 1079
 
12.5%
2 754
 
8.7%
3 510
 
5.9%
4 452
 
5.2%
5 396
 
4.6%
6 372
 
4.3%
7 355
 
4.1%
0 351
 
4.1%
9 326
 
3.8%
Other values (8) 728
 
8.4%
Hangul
ValueCountFrequency (%)
제 1154
 
10.3%
주 1153
 
10.3%
시 1137
 
10.2%
지 1022
 
9.1%
번 992
 
8.9%
동 710
 
6.3%
리 449
 
4.0%
호 415
 
3.7%
읍 409
 
3.7%
도 232
 
2.1%
Other values (177) 3511
31.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
Minimum2023-08-31 00:00:00
Maximum2023-08-31 00:00:00
2024-04-06T17:38:41.221105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:38:41.640707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-04-06T17:38:36.212974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:38:36.617861image/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(주)에코파워텍제주시 화북이동 27752023-08-31
1송당초등학교제주시 구좌읍 송당리 13662023-08-31
2제주의료원제주시 아라일동 4-172023-08-31
3국립제주박물관제주시 건입동 2612023-08-31
4라온레저개발(주)제주시 한경면 저지리 산 18번지 라온골프클럽2023-08-31
5해수리수산제주시 애월읍 애월리 19572023-08-31
6은혜전수산제주시 애월읍 애월리 2618-82023-08-31
7오일수산제주시 애월읍 애월리 1250-22023-08-31
8대룡수산제주시 애월읍 애월리 26132023-08-31
9골든브릿지사모부동산투자신탁14호제주시 조천읍 선흘리 136번지2023-08-31
업체명소재지데이터기준일자
1125쌍용양회공업(주)제주영업제주시 한림읍 한림리 1377번지 45호2023-08-31
1126금성자동차(주)제주시 화북1동 2146번지 6호2023-08-31
1127대건금속제주시 화북1동 2131번지2023-08-31
1128하나은행제주시 이도2동 1176번지 17호2023-08-31
1129삼성생명보험제주시 연동 300번지 14호2023-08-31
1130현대해상화재보험(주)제주시 노형동 1294번지 5호2023-08-31
1131한국공항공사제주지역본부제주시 용담이동 2002번지2023-08-31
1132한국전력공사제주시 연동 290번지 64호2023-08-31
1133한국전력공사 제주지역본부 제주전력지사제주시 가령로 68(이도이동)2023-08-31
1134한국전력공사 제주전력지사제주시 가령로 68(이도이동)2023-08-31

Duplicate rows

Most frequently occurring

업체명소재지데이터기준일자# duplicates
0(주)블랙스톤협재지점제주시 한림읍 협재리 1416-1번지2023-08-312
1(주)일해제주시 조천읍 대흘리 110-55번지2023-08-312
2(주)한송제주시 애월읍 고성리 623번지2023-08-312
3그린스페이스휴2제주시 건입동 25번지2023-08-312
4뉴맨하탄관광호텔제주시 연동 251-29번지2023-08-312
5명송리조트제주시 구좌읍 송당리 2610번지2023-08-312
6물메초등학교제주시 애월읍 수산리 1033번지2023-08-312
7부영아파트입주자대표회제주시 노형동 732번지2023-08-312
8이시돌농촌개발협회사회복지사령부(요양원)제주시 한림읍 금악리 109번지2023-08-312
9정든마을3단지아파트제주시 노형동 2582-22023-08-312