Overview

Dataset statistics

Number of variables6
Number of observations409
Missing cells22
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.7 KiB
Average record size in memory49.3 B

Variable types

Numeric1
Text2
DateTime3

Dataset

Description전북특별자치도 정보통신공사업체 등록현황 데이터입니다. 정보통신공사업체로 등록된 업체의 상호명, 주소, 등록일자 등의 데이터를 제공합니다.
Author전북특별자치도
URLhttps://www.data.go.kr/data/15100577/fileData.do

Alerts

대장생성일 has 22 (5.4%) missing valuesMissing
순번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2024-03-14 11:09:21.323002
Analysis finished2024-03-14 11:09:22.749530
Duration1.43 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct409
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean205
Minimum1
Maximum409
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2024-03-14T20:09:22.967075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile21.4
Q1103
median205
Q3307
95-th percentile388.6
Maximum409
Range408
Interquartile range (IQR)204

Descriptive statistics

Standard deviation118.21238
Coefficient of variation (CV)0.57664575
Kurtosis-1.2
Mean205
Median Absolute Deviation (MAD)102
Skewness0
Sum83845
Variance13974.167
MonotonicityStrictly increasing
2024-03-14T20:09:23.424869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
270 1
 
0.2%
280 1
 
0.2%
279 1
 
0.2%
278 1
 
0.2%
277 1
 
0.2%
276 1
 
0.2%
275 1
 
0.2%
274 1
 
0.2%
273 1
 
0.2%
Other values (399) 399
97.6%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
409 1
0.2%
408 1
0.2%
407 1
0.2%
406 1
0.2%
405 1
0.2%
404 1
0.2%
403 1
0.2%
402 1
0.2%
401 1
0.2%
400 1
0.2%

상호명
Text

UNIQUE 

Distinct409
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-03-14T20:09:24.475071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length28
Mean length9.2542787
Min length4

Characters and Unicode

Total characters3785
Distinct characters288
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

Unique409 ?
Unique (%)100.0%

Sample

1st row주식회사 신성솔루션
2nd row주식회사 라곤이엔씨
3rd row동원티앤씨 주식회사
4th row신우산업 주식회사
5th row주식회사 미디아
ValueCountFrequency (%)
주식회사 177
27.1%
유한회사 43
 
6.6%
co.,ltd 9
 
1.4%
사단법인 2
 
0.3%
tech 2
 
0.3%
주)에스엠케이정보통신 1
 
0.2%
혁신엔지니어링 1
 
0.2%
유)산돌 1
 
0.2%
주)에슬론통신 1
 
0.2%
주)대경산전 1
 
0.2%
Other values (415) 415
63.6%
2024-03-14T20:09:25.955318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 282
 
7.5%
244
 
6.4%
사 229
 
6.1%
회 224
 
5.9%
식 178
 
4.7%
( 170
 
4.5%
) 169
 
4.5%
이 127
 
3.4%
유 114
 
3.0%
신 97
 
2.6%
Other values (278) 1951
51.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3040
80.3%
Space Separator 244
 
6.4%
Open Punctuation 170
 
4.5%
Close Punctuation 169
 
4.5%
Uppercase Letter 88
 
2.3%
Lowercase Letter 42
 
1.1%
Other Punctuation 31
 
0.8%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 282
 
9.3%
사 229
 
7.5%
회 224
 
7.4%
식 178
 
5.9%
이 127
 
4.2%
유 114
 
3.8%
신 97
 
3.2%
스 87
 
2.9%
통 83
 
2.7%
보 83
 
2.7%
Other values (241) 1536
50.5%
Uppercase Letter
ValueCountFrequency (%)
C 15
17.0%
L 12
13.6%
S 9
10.2%
H 8
9.1%
T 7
8.0%
E 7
8.0%
N 5
 
5.7%
D 5
 
5.7%
O 3
 
3.4%
G 3
 
3.4%
Other values (9) 14
15.9%
Lowercase Letter
ValueCountFrequency (%)
o 11
26.2%
t 9
21.4%
d 8
19.0%
e 3
 
7.1%
m 3
 
7.1%
r 2
 
4.8%
a 2
 
4.8%
h 1
 
2.4%
c 1
 
2.4%
n 1
 
2.4%
Other Punctuation
ValueCountFrequency (%)
. 20
64.5%
, 10
32.3%
& 1
 
3.2%
Space Separator
ValueCountFrequency (%)
244
100.0%
Open Punctuation
ValueCountFrequency (%)
( 170
100.0%
Close Punctuation
ValueCountFrequency (%)
) 169
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3040
80.3%
Common 615
 
16.2%
Latin 130
 
3.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 282
 
9.3%
사 229
 
7.5%
회 224
 
7.4%
식 178
 
5.9%
이 127
 
4.2%
유 114
 
3.8%
신 97
 
3.2%
스 87
 
2.9%
통 83
 
2.7%
보 83
 
2.7%
Other values (241) 1536
50.5%
Latin
ValueCountFrequency (%)
C 15
 
11.5%
L 12
 
9.2%
o 11
 
8.5%
S 9
 
6.9%
t 9
 
6.9%
H 8
 
6.2%
d 8
 
6.2%
T 7
 
5.4%
E 7
 
5.4%
N 5
 
3.8%
Other values (20) 39
30.0%
Common
ValueCountFrequency (%)
244
39.7%
( 170
27.6%
) 169
27.5%
. 20
 
3.3%
, 10
 
1.6%
& 1
 
0.2%
- 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3040
80.3%
ASCII 745
 
19.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 282
 
9.3%
사 229
 
7.5%
회 224
 
7.4%
식 178
 
5.9%
이 127
 
4.2%
유 114
 
3.8%
신 97
 
3.2%
스 87
 
2.9%
통 83
 
2.7%
보 83
 
2.7%
Other values (241) 1536
50.5%
ASCII
ValueCountFrequency (%)
244
32.8%
( 170
22.8%
) 169
22.7%
. 20
 
2.7%
C 15
 
2.0%
L 12
 
1.6%
o 11
 
1.5%
, 10
 
1.3%
S 9
 
1.2%
t 9
 
1.2%
Other values (27) 76
 
10.2%

주소
Text

Distinct401
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-03-14T20:09:27.054513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length65
Median length44
Mean length27.293399
Min length15

Characters and Unicode

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

Unique

Unique393 ?
Unique (%)96.1%

Sample

1st row전북특별자치도 군산시 문화로 68, 1층(수송동)
2nd row전북특별자치도 남원시 금하정1길 7-5, 1층(금동)
3rd row전북특별자치도 군산시 번영로 92, 1층 3호(경장동)
4th row전북특별자치도 완주군 봉동읍 테크노밸리2로 123
5th row전북특별자치도 완주군 이서면 용서2길 59, 2동 202호
ValueCountFrequency (%)
전북 267
 
11.4%
전주시 168
 
7.2%
전북특별자치도 142
 
6.0%
덕진구 87
 
3.7%
완산구 81
 
3.4%
65
 
2.8%
군산시 49
 
2.1%
익산시 43
 
1.8%
정읍시 30
 
1.3%
완주군 24
 
1.0%
Other values (880) 1392
59.3%
2024-03-14T20:09:28.583766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1939
 
17.4%
전 604
 
5.4%
북 463
 
4.1%
1 378
 
3.4%
시 340
 
3.0%
동 335
 
3.0%
2 293
 
2.6%
( 278
 
2.5%
) 278
 
2.5%
산 259
 
2.3%
Other values (293) 5996
53.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6609
59.2%
Space Separator 1939
 
17.4%
Decimal Number 1711
 
15.3%
Open Punctuation 278
 
2.5%
Close Punctuation 278
 
2.5%
Other Punctuation 204
 
1.8%
Dash Punctuation 129
 
1.2%
Uppercase Letter 8
 
0.1%
Lowercase Letter 6
 
0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 604
 
9.1%
북 463
 
7.0%
시 340
 
5.1%
동 335
 
5.1%
산 259
 
3.9%
로 247
 
3.7%
주 219
 
3.3%
구 194
 
2.9%
자 182
 
2.8%
길 178
 
2.7%
Other values (264) 3588
54.3%
Decimal Number
ValueCountFrequency (%)
1 378
22.1%
2 293
17.1%
3 230
13.4%
0 138
 
8.1%
5 135
 
7.9%
6 133
 
7.8%
4 125
 
7.3%
7 100
 
5.8%
9 96
 
5.6%
8 83
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
A 1
12.5%
S 1
12.5%
K 1
12.5%
L 1
12.5%
W 1
12.5%
E 1
12.5%
I 1
12.5%
V 1
12.5%
Lowercase Letter
ValueCountFrequency (%)
e 2
33.3%
a 1
16.7%
s 1
16.7%
r 1
16.7%
d 1
16.7%
Space Separator
ValueCountFrequency (%)
1939
100.0%
Open Punctuation
ValueCountFrequency (%)
( 278
100.0%
Close Punctuation
ValueCountFrequency (%)
) 278
100.0%
Other Punctuation
ValueCountFrequency (%)
, 204
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 129
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6610
59.2%
Common 4539
40.7%
Latin 14
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 604
 
9.1%
북 463
 
7.0%
시 340
 
5.1%
동 335
 
5.1%
산 259
 
3.9%
로 247
 
3.7%
주 219
 
3.3%
구 194
 
2.9%
자 182
 
2.8%
길 178
 
2.7%
Other values (265) 3589
54.3%
Common
ValueCountFrequency (%)
1939
42.7%
1 378
 
8.3%
2 293
 
6.5%
( 278
 
6.1%
) 278
 
6.1%
3 230
 
5.1%
, 204
 
4.5%
0 138
 
3.0%
5 135
 
3.0%
6 133
 
2.9%
Other values (5) 533
 
11.7%
Latin
ValueCountFrequency (%)
e 2
14.3%
a 1
 
7.1%
A 1
 
7.1%
S 1
 
7.1%
K 1
 
7.1%
L 1
 
7.1%
W 1
 
7.1%
E 1
 
7.1%
I 1
 
7.1%
V 1
 
7.1%
Other values (3) 3
21.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6609
59.2%
ASCII 4553
40.8%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1939
42.6%
1 378
 
8.3%
2 293
 
6.4%
( 278
 
6.1%
) 278
 
6.1%
3 230
 
5.1%
, 204
 
4.5%
0 138
 
3.0%
5 135
 
3.0%
6 133
 
2.9%
Other values (18) 547
 
12.0%
Hangul
ValueCountFrequency (%)
전 604
 
9.1%
북 463
 
7.0%
시 340
 
5.1%
동 335
 
5.1%
산 259
 
3.9%
로 247
 
3.7%
주 219
 
3.3%
구 194
 
2.9%
자 182
 
2.8%
길 178
 
2.7%
Other values (264) 3588
54.3%
None
ValueCountFrequency (%)
㈜ 1
100.0%

등록일자
Date

Distinct376
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum1979-05-10 00:00:00
Maximum2022-05-23 00:00:00
2024-03-14T20:09:28.992408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:09:29.448025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

대장생성일
Date

MISSING 

Distinct316
Distinct (%)81.7%
Missing22
Missing (%)5.4%
Memory size3.3 KiB
Minimum2012-03-05 00:00:00
Maximum2022-05-23 00:00:00
2024-03-14T20:09:29.840693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:09:30.272416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최종수정일
Date

Distinct342
Distinct (%)83.6%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2012-05-22 00:00:00
Maximum2022-05-30 00:00:00
2024-03-14T20:09:30.665493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:09:31.090477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T20:09:21.870348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2024-03-14T20:09:22.263369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:09:22.610763image/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

순번상호명주소등록일자대장생성일최종수정일
01주식회사 신성솔루션전북특별자치도 군산시 문화로 68, 1층(수송동)2022-05-232022-05-232022-05-24
12주식회사 라곤이엔씨전북특별자치도 남원시 금하정1길 7-5, 1층(금동)2022-04-222022-04-222022-04-25
23동원티앤씨 주식회사전북특별자치도 군산시 번영로 92, 1층 3호(경장동)2022-04-202022-04-202022-04-20
34신우산업 주식회사전북특별자치도 완주군 봉동읍 테크노밸리2로 1232022-04-112022-04-112022-04-11
45주식회사 미디아전북특별자치도 완주군 이서면 용서2길 59, 2동 202호2022-04-042022-04-042022-04-11
56주식회사 진환정보통신전북특별자치도 고창군 고창읍 중거리당산로 75, 1층2022-04-042022-04-042022-04-11
67주식회사 신독이엔씨전북특별자치도 군산시 설림5길 50(소룡동)2022-03-162022-03-162022-05-12
78주식회사 엔지아이전북특별자치도 전주시 덕진구 오공로 33-16, 5층 502호(중동)2022-03-112022-03-112022-03-11
89티지삼보서비스전주센터(티지에스)전북특별자치도 전주시 덕진구 견훤로 393, 4층(인후동2가)2022-02-232022-02-232022-02-24
910효성중전기 주식회사전북특별자치도 전주시 완산구 콩쥐팥쥐로 1629(상림동)2022-02-152022-02-152022-02-15
순번상호명주소등록일자대장생성일최종수정일
399400주식회사 엠제이정보통신전북 남원시 요천로 1843(고죽동)1991-10-102013-01-142017-06-29
400401(유)정안정보전북 전주시 완산구 전룡로 38, 2층(서신동)1991-10-102014-02-212020-06-02
401402(유)제이케이건설전북 군산시 조촌로 112 , (조촌동)1991-10-102014-09-052014-09-05
402403(주)백광전기통신전북 익산시 무왕로31길 254(부송동)1991-10-10<NA>2020-02-28
403404(주)남형통신건설전북 전주시 완산구 서신로 18 , 5층 (서신동)1991-02-262013-11-112013-11-13
404405(주)하나로전북 전주시 완산구 내원당길 7-5(대성동)1990-01-252012-09-072012-09-11
405406(주)대성전력전북특별자치도 정읍시 수성6로 61-14(수성동)1990-01-23<NA>2022-03-29
406407(주)중앙통신건설전북 전주시 완산구 중산6길 4, 진영빌딩3층(중화산동2가)1986-03-272014-01-142019-02-20
407408(유)제일통신건설전북특별자치도 전주시 완산구 팔달로 148-1(전동)1979-11-102014-01-022021-10-08
408409(유)비제이솔루션전북특별자치도 익산시 현신길 40 (현영동)1979-05-102013-05-072021-12-23