Overview

Dataset statistics

Number of variables4
Number of observations209
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.9 KiB
Average record size in memory33.6 B

Variable types

Numeric1
Text2
DateTime1

Dataset

Description제주도 내 소재한 정보통신공사업에 대한 데이터로 등록번호,상호,주소를 제공합니다.정보통신공사는 도지사에게 등록된 정보통신공사업자가 아니면 도급을 받거나 시공할 수 없도록 제한됩니다.
Author제주특별자치도
URLhttps://www.data.go.kr/data/15100653/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
등록번호 has unique valuesUnique
상호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:40:43.938644
Analysis finished2023-12-12 11:40:44.726207
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록번호
Real number (ℝ)

UNIQUE 

Distinct209
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean510446.72
Minimum111902
Maximum640179
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 KiB
2023-12-12T20:40:44.868837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum111902
5-th percentile180026.4
Q1180081
median640058
Q3640120
95-th percentile640165.6
Maximum640179
Range528277
Interquartile range (IQR)460039

Descriptive statistics

Standard deviation205677.77
Coefficient of variation (CV)0.4029368
Kurtosis-1.0180635
Mean510446.72
Median Absolute Deviation (MAD)73
Skewness-0.98317939
Sum1.0668336 × 108
Variance4.2303343 × 1010
MonotonicityNot monotonic
2023-12-12T20:40:45.153535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
640178 1
 
0.5%
180080 1
 
0.5%
640027 1
 
0.5%
640025 1
 
0.5%
640024 1
 
0.5%
640023 1
 
0.5%
640022 1
 
0.5%
640021 1
 
0.5%
180065 1
 
0.5%
640019 1
 
0.5%
Other values (199) 199
95.2%
ValueCountFrequency (%)
111902 1
0.5%
140297 1
0.5%
180003 1
0.5%
180005 1
0.5%
180007 1
0.5%
180008 1
0.5%
180010 1
0.5%
180015 1
0.5%
180021 1
0.5%
180024 1
0.5%
ValueCountFrequency (%)
640179 1
0.5%
640178 1
0.5%
640177 1
0.5%
640175 1
0.5%
640174 1
0.5%
640173 1
0.5%
640172 1
0.5%
640171 1
0.5%
640169 1
0.5%
640168 1
0.5%

상호
Text

UNIQUE 

Distinct209
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T20:40:45.638487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length22
Mean length8.7177033
Min length4

Characters and Unicode

Total characters1822
Distinct characters223
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

Unique209 ?
Unique (%)100.0%

Sample

1st row주식회사 제라클이앤지(JERACLE ENG)
2nd row주식회사 세경이엔씨
3rd row제이아이엔시스템 주식회사
4th row주식회사 디에이씨엔에스
5th row다함테크
ValueCountFrequency (%)
주식회사 98
30.6%
주)월드씨앤에스 1
 
0.3%
세방전지총판(주 1
 
0.3%
도암엔지니어링 1
 
0.3%
동양정보기술(주 1
 
0.3%
주)태영전력 1
 
0.3%
이투지 1
 
0.3%
e2z 1
 
0.3%
co 1
 
0.3%
ltd 1
 
0.3%
Other values (213) 213
66.6%
2023-12-12T20:40:46.442358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
169
 
9.3%
111
 
6.1%
104
 
5.7%
102
 
5.6%
101
 
5.5%
) 67
 
3.7%
( 67
 
3.7%
60
 
3.3%
52
 
2.9%
45
 
2.5%
Other values (213) 944
51.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1502
82.4%
Space Separator 111
 
6.1%
Close Punctuation 67
 
3.7%
Open Punctuation 67
 
3.7%
Uppercase Letter 30
 
1.6%
Lowercase Letter 25
 
1.4%
Other Symbol 18
 
1.0%
Decimal Number 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
169
 
11.3%
104
 
6.9%
102
 
6.8%
101
 
6.7%
60
 
4.0%
52
 
3.5%
45
 
3.0%
45
 
3.0%
45
 
3.0%
40
 
2.7%
Other values (178) 739
49.2%
Uppercase Letter
ValueCountFrequency (%)
E 5
16.7%
C 5
16.7%
S 2
 
6.7%
R 2
 
6.7%
V 2
 
6.7%
J 2
 
6.7%
L 2
 
6.7%
A 2
 
6.7%
G 2
 
6.7%
Z 1
 
3.3%
Other values (5) 5
16.7%
Lowercase Letter
ValueCountFrequency (%)
o 5
20.0%
t 3
12.0%
i 2
 
8.0%
u 2
 
8.0%
n 2
 
8.0%
m 2
 
8.0%
d 2
 
8.0%
h 1
 
4.0%
e 1
 
4.0%
y 1
 
4.0%
Other values (4) 4
16.0%
Space Separator
ValueCountFrequency (%)
111
100.0%
Close Punctuation
ValueCountFrequency (%)
) 67
100.0%
Open Punctuation
ValueCountFrequency (%)
( 67
100.0%
Other Symbol
ValueCountFrequency (%)
18
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1520
83.4%
Common 247
 
13.6%
Latin 55
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
169
 
11.1%
104
 
6.8%
102
 
6.7%
101
 
6.6%
60
 
3.9%
52
 
3.4%
45
 
3.0%
45
 
3.0%
45
 
3.0%
40
 
2.6%
Other values (179) 757
49.8%
Latin
ValueCountFrequency (%)
E 5
 
9.1%
o 5
 
9.1%
C 5
 
9.1%
t 3
 
5.5%
S 2
 
3.6%
R 2
 
3.6%
V 2
 
3.6%
J 2
 
3.6%
i 2
 
3.6%
u 2
 
3.6%
Other values (19) 25
45.5%
Common
ValueCountFrequency (%)
111
44.9%
) 67
27.1%
( 67
27.1%
2 1
 
0.4%
. 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1502
82.4%
ASCII 302
 
16.6%
None 18
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
169
 
11.3%
104
 
6.9%
102
 
6.8%
101
 
6.7%
60
 
4.0%
52
 
3.5%
45
 
3.0%
45
 
3.0%
45
 
3.0%
40
 
2.7%
Other values (178) 739
49.2%
ASCII
ValueCountFrequency (%)
111
36.8%
) 67
22.2%
( 67
22.2%
E 5
 
1.7%
o 5
 
1.7%
C 5
 
1.7%
t 3
 
1.0%
S 2
 
0.7%
R 2
 
0.7%
V 2
 
0.7%
Other values (24) 33
 
10.9%
None
ValueCountFrequency (%)
18
100.0%

주소
Text

Distinct203
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2023-12-12T20:40:47.173992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length31
Mean length21.636364
Min length16

Characters and Unicode

Total characters4522
Distinct characters178
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

Unique197 ?
Unique (%)94.3%

Sample

1st row제주특별자치도 서귀포시 중산간동로 7884
2nd row제주특별자치도 서귀포시 남원읍 중산간동로 6965
3rd row제주특별자치도 제주시 연삼로 10
4th row제주특별자치도 제주시 복지로5길 21
5th row제주특별자치도 제주시 동광로19길 55
ValueCountFrequency (%)
제주특별자치도 209
22.5%
제주시 185
19.9%
서귀포시 24
 
2.6%
2층 24
 
2.6%
1층 22
 
2.4%
애월읍 7
 
0.8%
중산간동로 7
 
0.8%
아연로 7
 
0.8%
15 5
 
0.5%
첨단로 5
 
0.5%
Other values (315) 435
46.8%
2023-12-12T20:40:48.063644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
721
15.9%
403
 
8.9%
399
 
8.8%
221
 
4.9%
209
 
4.6%
209
 
4.6%
209
 
4.6%
209
 
4.6%
209
 
4.6%
1 176
 
3.9%
Other values (168) 1557
34.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3052
67.5%
Space Separator 721
 
15.9%
Decimal Number 704
 
15.6%
Dash Punctuation 37
 
0.8%
Uppercase Letter 7
 
0.2%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
403
13.2%
399
13.1%
221
 
7.2%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
143
 
4.7%
123
 
4.0%
Other values (148) 718
23.5%
Decimal Number
ValueCountFrequency (%)
1 176
25.0%
2 127
18.0%
3 65
 
9.2%
4 63
 
8.9%
5 56
 
8.0%
6 56
 
8.0%
9 43
 
6.1%
7 43
 
6.1%
8 42
 
6.0%
0 33
 
4.7%
Uppercase Letter
ValueCountFrequency (%)
C 1
14.3%
E 1
14.3%
M 1
14.3%
J 1
14.3%
L 1
14.3%
K 1
14.3%
D 1
14.3%
Space Separator
ValueCountFrequency (%)
721
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3052
67.5%
Common 1463
32.4%
Latin 7
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
403
13.2%
399
13.1%
221
 
7.2%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
143
 
4.7%
123
 
4.0%
Other values (148) 718
23.5%
Common
ValueCountFrequency (%)
721
49.3%
1 176
 
12.0%
2 127
 
8.7%
3 65
 
4.4%
4 63
 
4.3%
5 56
 
3.8%
6 56
 
3.8%
9 43
 
2.9%
7 43
 
2.9%
8 42
 
2.9%
Other values (3) 71
 
4.9%
Latin
ValueCountFrequency (%)
C 1
14.3%
E 1
14.3%
M 1
14.3%
J 1
14.3%
L 1
14.3%
K 1
14.3%
D 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3052
67.5%
ASCII 1470
32.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
721
49.0%
1 176
 
12.0%
2 127
 
8.6%
3 65
 
4.4%
4 63
 
4.3%
5 56
 
3.8%
6 56
 
3.8%
9 43
 
2.9%
7 43
 
2.9%
8 42
 
2.9%
Other values (10) 78
 
5.3%
Hangul
ValueCountFrequency (%)
403
13.2%
399
13.1%
221
 
7.2%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
209
 
6.8%
143
 
4.7%
123
 
4.0%
Other values (148) 718
23.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2023-08-03 00:00:00
Maximum2023-08-03 00:00:00
2023-12-12T20:40:48.837098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:40:49.000594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T20:40:44.299579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T20:40:44.487706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:40:44.661148image/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

등록번호상호주소데이터기준일자
0640178주식회사 제라클이앤지(JERACLE ENG)제주특별자치도 서귀포시 중산간동로 78842023-08-03
1640179주식회사 세경이엔씨제주특별자치도 서귀포시 남원읍 중산간동로 69652023-08-03
2640177제이아이엔시스템 주식회사제주특별자치도 제주시 연삼로 102023-08-03
3640175주식회사 디에이씨엔에스제주특별자치도 제주시 복지로5길 212023-08-03
4640174다함테크제주특별자치도 제주시 동광로19길 552023-08-03
5640173주식회사 제이시스제주특별자치도 제주시 연신로 188-202023-08-03
6312132유스 바인 커뮤니티(Youth Vine Community)제주특별자치도 제주시 서광로11길 32023-08-03
7640172주식회사 우리정보통신제주특별자치도 제주시 서해안로 620-122023-08-03
8640171주식회사 인성전력제주특별자치도 제주시 원남6길 712023-08-03
9640169주식회사 아이엔티정보통신제주특별자치도 제주시 아연로 299 1층2023-08-03
등록번호상호주소데이터기준일자
199180042진일통신공사제주특별자치도 제주시 천수동로2길 10-102023-08-03
200180030중앙정보통신제주특별자치도 제주시 연신로 2612023-08-03
201180028진일정보통신제주특별자치도 제주시 남광로 152-12023-08-03
202180047에스에스코리아 주식회사(SS COREA)제주특별자치도 제주시 도령로 542023-08-03
203180029대신네트웍스㈜제주특별자치도 제주시 삼무로11길 242023-08-03
204180055대우산업통신제주특별자치도 제주시 임향로 362023-08-03
205180008한라전설㈜제주특별자치도 제주시 전농로 682023-08-03
206180003(주)성우이앤씨제주특별자치도 제주시 선반로4길 192023-08-03
207180024청암기업㈜제주특별자치도 제주시 노형로 3972023-08-03
208180007태광통신㈜제주특별자치도 제주시 고마로16길 162023-08-03