Overview

Dataset statistics

Number of variables5
Number of observations61
Missing cells10
Missing cells (%)3.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory42.2 B

Variable types

Text4
Categorical1

Dataset

Description전라북도 정읍시 소재한 옥외광고업 현황중(업체명, 소재지도로명주소, 소재지지번주소, 전화번호)등의 자료를 제공합니다.
Author전라북도 정읍시
URLhttps://www.data.go.kr/data/15025092/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 10 (16.4%) missing valuesMissing
업체명 has unique valuesUnique
소재지지번주소 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:19:02.217317
Analysis finished2023-12-16 15:19:04.368112
Duration2.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:19:04.956295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length6.2131148
Min length4

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row하나칼라인쇄
2nd row네모이엔지
3rd row유한회사 앰플랜
4th row한양디자인기획
5th row티앤씨건설(주)
ValueCountFrequency (%)
유한회사 3
 
4.6%
하나칼라인쇄 1
 
1.5%
일이디자인 1
 
1.5%
한일인쇄소 1
 
1.5%
모던디자인광고기획 1
 
1.5%
해태광고기획 1
 
1.5%
동신광고기획 1
 
1.5%
토탈싸인 1
 
1.5%
원광인쇄소 1
 
1.5%
오케이광고 1
 
1.5%
Other values (53) 53
81.5%
2023-12-16T15:19:06.983670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
 
7.1%
25
 
6.6%
15
 
4.0%
12
 
3.2%
12
 
3.2%
) 11
 
2.9%
( 10
 
2.6%
9
 
2.4%
8
 
2.1%
8
 
2.1%
Other values (121) 242
63.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 346
91.3%
Close Punctuation 11
 
2.9%
Open Punctuation 10
 
2.6%
Uppercase Letter 5
 
1.3%
Space Separator 4
 
1.1%
Decimal Number 2
 
0.5%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
27
 
7.8%
25
 
7.2%
15
 
4.3%
12
 
3.5%
12
 
3.5%
9
 
2.6%
8
 
2.3%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (111) 215
62.1%
Uppercase Letter
ValueCountFrequency (%)
S 2
40.0%
E 1
20.0%
F 1
20.0%
A 1
20.0%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 346
91.3%
Common 28
 
7.4%
Latin 5
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
27
 
7.8%
25
 
7.2%
15
 
4.3%
12
 
3.5%
12
 
3.5%
9
 
2.6%
8
 
2.3%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (111) 215
62.1%
Common
ValueCountFrequency (%)
) 11
39.3%
( 10
35.7%
4
 
14.3%
& 1
 
3.6%
2 1
 
3.6%
1 1
 
3.6%
Latin
ValueCountFrequency (%)
S 2
40.0%
E 1
20.0%
F 1
20.0%
A 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 346
91.3%
ASCII 33
 
8.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
27
 
7.8%
25
 
7.2%
15
 
4.3%
12
 
3.5%
12
 
3.5%
9
 
2.6%
8
 
2.3%
8
 
2.3%
8
 
2.3%
7
 
2.0%
Other values (111) 215
62.1%
ASCII
ValueCountFrequency (%)
) 11
33.3%
( 10
30.3%
4
 
12.1%
S 2
 
6.1%
& 1
 
3.0%
2 1
 
3.0%
1 1
 
3.0%
E 1
 
3.0%
F 1
 
3.0%
A 1
 
3.0%
Distinct58
Distinct (%)95.1%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:19:08.337368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length25
Mean length21.918033
Min length15

Characters and Unicode

Total characters1337
Distinct characters90
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

Unique55 ?
Unique (%)90.2%

Sample

1st row전라북도 정읍시 충정로 273 (수성동, 대율빌딩)
2nd row전라북도 정읍시 수성5로 12
3rd row전라북도 정읍시 북면 북면공단2길 67
4th row전라북도 정읍시 서성길 18
5th row전라북도 정읍시 정읍사로 576 (시기동)
ValueCountFrequency (%)
전라북도 61
20.8%
정읍시 61
20.8%
수성동 17
 
5.8%
연지동 6
 
2.0%
서부산업도로 6
 
2.0%
충정로 6
 
2.0%
시기동 5
 
1.7%
수성5로 4
 
1.4%
천변로 3
 
1.0%
우암로 3
 
1.0%
Other values (97) 121
41.3%
2023-12-16T15:19:10.582322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
254
19.0%
70
 
5.2%
69
 
5.2%
67
 
5.0%
66
 
4.9%
64
 
4.8%
61
 
4.6%
61
 
4.6%
41
 
3.1%
1 41
 
3.1%
Other values (80) 543
40.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 803
60.1%
Space Separator 254
 
19.0%
Decimal Number 189
 
14.1%
Open Punctuation 37
 
2.8%
Close Punctuation 37
 
2.8%
Dash Punctuation 13
 
1.0%
Other Punctuation 4
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
70
 
8.7%
69
 
8.6%
67
 
8.3%
66
 
8.2%
64
 
8.0%
61
 
7.6%
61
 
7.6%
41
 
5.1%
38
 
4.7%
35
 
4.4%
Other values (65) 231
28.8%
Decimal Number
ValueCountFrequency (%)
1 41
21.7%
3 30
15.9%
2 23
12.2%
4 18
9.5%
8 16
 
8.5%
5 16
 
8.5%
7 12
 
6.3%
6 12
 
6.3%
9 11
 
5.8%
0 10
 
5.3%
Space Separator
ValueCountFrequency (%)
254
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Close Punctuation
ValueCountFrequency (%)
) 37
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 803
60.1%
Common 534
39.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
70
 
8.7%
69
 
8.6%
67
 
8.3%
66
 
8.2%
64
 
8.0%
61
 
7.6%
61
 
7.6%
41
 
5.1%
38
 
4.7%
35
 
4.4%
Other values (65) 231
28.8%
Common
ValueCountFrequency (%)
254
47.6%
1 41
 
7.7%
( 37
 
6.9%
) 37
 
6.9%
3 30
 
5.6%
2 23
 
4.3%
4 18
 
3.4%
8 16
 
3.0%
5 16
 
3.0%
- 13
 
2.4%
Other values (5) 49
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 803
60.1%
ASCII 534
39.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
254
47.6%
1 41
 
7.7%
( 37
 
6.9%
) 37
 
6.9%
3 30
 
5.6%
2 23
 
4.3%
4 18
 
3.4%
8 16
 
3.0%
5 16
 
3.0%
- 13
 
2.4%
Other values (5) 49
 
9.2%
Hangul
ValueCountFrequency (%)
70
 
8.7%
69
 
8.6%
67
 
8.3%
66
 
8.2%
64
 
8.0%
61
 
7.6%
61
 
7.6%
41
 
5.1%
38
 
4.7%
35
 
4.4%
Other values (65) 231
28.8%
Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T15:19:11.985893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length26
Mean length20.459016
Min length16

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row전라북도 정읍시 수성동 448-54
2nd row전라북도 정읍시 수성동 904-1
3rd row전라북도 정읍시 북면 한교리 34-12
4th row전라북도 정읍시 수성동 524-12
5th row전라북도 정읍시 시기동 53-17
ValueCountFrequency (%)
전라북도 61
22.8%
정읍시 61
22.8%
수성동 25
 
9.3%
시기동 8
 
3.0%
연지동 8
 
3.0%
장명동 3
 
1.1%
태인면 3
 
1.1%
하북동 3
 
1.1%
오봉리 3
 
1.1%
북면 3
 
1.1%
Other values (85) 90
33.6%
2023-12-16T15:19:14.584404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
248
19.9%
69
 
5.5%
67
 
5.4%
62
 
5.0%
61
 
4.9%
61
 
4.9%
61
 
4.9%
61
 
4.9%
52
 
4.2%
1 52
 
4.2%
Other values (51) 454
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 701
56.2%
Decimal Number 255
 
20.4%
Space Separator 248
 
19.9%
Dash Punctuation 44
 
3.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
9.8%
67
9.6%
62
8.8%
61
8.7%
61
8.7%
61
8.7%
61
8.7%
52
 
7.4%
29
 
4.1%
26
 
3.7%
Other values (39) 152
21.7%
Decimal Number
ValueCountFrequency (%)
1 52
20.4%
2 31
12.2%
3 29
11.4%
6 26
10.2%
4 23
9.0%
9 23
9.0%
5 20
 
7.8%
8 18
 
7.1%
0 18
 
7.1%
7 15
 
5.9%
Space Separator
ValueCountFrequency (%)
248
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 701
56.2%
Common 547
43.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
9.8%
67
9.6%
62
8.8%
61
8.7%
61
8.7%
61
8.7%
61
8.7%
52
 
7.4%
29
 
4.1%
26
 
3.7%
Other values (39) 152
21.7%
Common
ValueCountFrequency (%)
248
45.3%
1 52
 
9.5%
- 44
 
8.0%
2 31
 
5.7%
3 29
 
5.3%
6 26
 
4.8%
4 23
 
4.2%
9 23
 
4.2%
5 20
 
3.7%
8 18
 
3.3%
Other values (2) 33
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 701
56.2%
ASCII 547
43.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
248
45.3%
1 52
 
9.5%
- 44
 
8.0%
2 31
 
5.7%
3 29
 
5.3%
6 26
 
4.8%
4 23
 
4.2%
9 23
 
4.2%
5 20
 
3.7%
8 18
 
3.3%
Other values (2) 33
 
6.0%
Hangul
ValueCountFrequency (%)
69
9.8%
67
9.6%
62
8.8%
61
8.7%
61
8.7%
61
8.7%
61
8.7%
52
 
7.4%
29
 
4.1%
26
 
3.7%
Other values (39) 152
21.7%

전화번호
Text

MISSING 

Distinct49
Distinct (%)96.1%
Missing10
Missing (%)16.4%
Memory size620.0 B
2023-12-16T15:19:16.537839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.980392
Min length9

Characters and Unicode

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

Unique

Unique47 ?
Unique (%)92.2%

Sample

1st row063-532-6969
2nd row063-532-8820
3rd row063-532-1666
4th row063-537-7703
5th row063-538-0482
ValueCountFrequency (%)
063-533-7411 2
 
3.9%
063-532-8820 2
 
3.9%
063-535-5787 1
 
2.0%
063-532-8818 1
 
2.0%
063-531-7110 1
 
2.0%
063-531-7555 1
 
2.0%
063-535-0666 1
 
2.0%
063-533-0550 1
 
2.0%
063-535-9289 1
 
2.0%
063-536-9877 1
 
2.0%
Other values (39) 39
76.5%
2023-12-16T15:19:19.275218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 119
19.5%
- 101
16.5%
5 87
14.2%
6 73
11.9%
0 70
11.5%
1 36
 
5.9%
7 34
 
5.6%
8 27
 
4.4%
2 25
 
4.1%
4 21
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 510
83.5%
Dash Punctuation 101
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 119
23.3%
5 87
17.1%
6 73
14.3%
0 70
13.7%
1 36
 
7.1%
7 34
 
6.7%
8 27
 
5.3%
2 25
 
4.9%
4 21
 
4.1%
9 18
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 101
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 611
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 119
19.5%
- 101
16.5%
5 87
14.2%
6 73
11.9%
0 70
11.5%
1 36
 
5.9%
7 34
 
5.6%
8 27
 
4.4%
2 25
 
4.1%
4 21
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 611
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 119
19.5%
- 101
16.5%
5 87
14.2%
6 73
11.9%
0 70
11.5%
1 36
 
5.9%
7 34
 
5.6%
8 27
 
4.4%
2 25
 
4.1%
4 21
 
3.4%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-15
61 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-15
2nd row2023-12-15
3rd row2023-12-15
4th row2023-12-15
5th row2023-12-15

Common Values

ValueCountFrequency (%)
2023-12-15 61
100.0%

Length

2023-12-16T15:19:20.265718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:19:21.254828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-15 61
100.0%

Correlations

2023-12-16T15:19:22.013661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명소재지도로명주소소재지지번주소전화번호
업체명1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0000.995
소재지지번주소1.0001.0001.0001.000
전화번호1.0000.9951.0001.000

Missing values

2023-12-16T15:19:03.730048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:19:04.162754image/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하나칼라인쇄전라북도 정읍시 충정로 273 (수성동, 대율빌딩)전라북도 정읍시 수성동 448-54063-532-69692023-12-15
1네모이엔지전라북도 정읍시 수성5로 12전라북도 정읍시 수성동 904-1063-532-88202023-12-15
2유한회사 앰플랜전라북도 정읍시 북면 북면공단2길 67전라북도 정읍시 북면 한교리 34-12<NA>2023-12-15
3한양디자인기획전라북도 정읍시 서성길 18전라북도 정읍시 수성동 524-12063-532-16662023-12-15
4티앤씨건설(주)전라북도 정읍시 정읍사로 576 (시기동)전라북도 정읍시 시기동 53-17063-537-77032023-12-15
5유니애드전라북도 정읍시 쇠죽동길 15전라북도 정읍시 구룡동 611-4<NA>2023-12-15
6한솔종합간판백화점전라북도 정읍시 서부산업도로 181전라북도 정읍시 상평동 133-4063-538-04822023-12-15
7현대광고전라북도 정읍시 충정로 299-1 (연지동)전라북도 정읍시 연지동 39-1063-536-56712023-12-15
8(주)소재산업개발전라북도 정읍시 서부산업도로 489 (하북동)전라북도 정읍시 하북동 721-19063-533-87002023-12-15
9(주)서림이엔지전라북도 정읍시 고부면 영원로 513-16전라북도 정읍시 북면 한교리 34-23<NA>2023-12-15
업체명소재지도로명주소소재지지번주소전화번호데이터기준일자
5121세기 광고사전라북도 정읍시 벚꽃로 363전라북도 정읍시 시기동 225-66번지063-531-44322023-12-15
52(유)칠칠공사전라북도 정읍시 신태인읍 신태인1길 88-2전라북도 정읍시 신태인읍 신태인리 197번지063-536-77042023-12-15
53한우리광고전라북도 정읍시 수성6로 51-4전라북도 정읍시 수성동 1000-3번지063-532-54492023-12-15
54명성실사전라북도 정읍시 명덕1길 3전라북도 정읍시 연지동 13-6063-537-26392023-12-15
55모든광고전라북도 정읍시 초산로 92 (수성동)전라북도 정읍시 수성동 653번지 3호063-533-51812023-12-15
56예림광고간판전라북도 정읍시 수성택지3길 35 (수성동)전라북도 정읍시 수성동 938번지 12호063-536-45152023-12-15
57(유)엘제이건설산업전라북도 정읍시 충정로 291전라북도 정읍시 연지동 39-34번지063-535-57872023-12-15
58대창종합광고인쇄전라북도 정읍시 수성택지1길 53전라북도 정읍시 수성동 603-6번지063-531-65662023-12-15
59S디자인전라북도 정읍시 천변로 174 (연지동)전라북도 정읍시 연지동 87번지 2호063-531-71102023-12-15
60제일광고전라북도 정읍시 관통로 30 (시기동)전라북도 정읍시 시기동 170번지 5호063-536-23392023-12-15