Overview

Dataset statistics

Number of variables7
Number of observations167
Missing cells116
Missing cells (%)9.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.3 KiB
Average record size in memory56.8 B

Variable types

Text3
DateTime1
Categorical3

Dataset

Description관내 의료기기 판매업소 및 소독업소 현황에 대한 데이터로 사업장명, 도로명전체주소, 인허가일자, 영업상태명, 전화번호를 포함하고 있다
Author울산광역시 동구
URLhttps://www.data.go.kr/data/3075511/fileData.do

Alerts

영업상태명 has constant value ""Constant
담당기관 has constant value ""Constant
담당기관 연락처 has constant value ""Constant
전화번호 has 116 (69.5%) missing valuesMissing
사업장명 has unique valuesUnique

Reproduction

Analysis started2024-03-14 14:59:31.110117
Analysis finished2024-03-14 14:59:32.204104
Duration1.09 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업장명
Text

UNIQUE 

Distinct167
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-03-14T23:59:32.815597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length16
Mean length9.6347305
Min length2

Characters and Unicode

Total characters1609
Distinct characters234
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

Unique167 ?
Unique (%)100.0%

Sample

1st row해피안힐링센타
2nd row바른숨
3rd row와이피주식회사
4th row무무야
5th row참사랑홈파티스스튜디오 울산꽃바위점
ValueCountFrequency (%)
세븐일레븐 18
 
6.8%
cu 15
 
5.7%
gs25 10
 
3.8%
이마트24 7
 
2.7%
울산동구점 5
 
1.9%
홈파티스 3
 
1.1%
참사랑 3
 
1.1%
홈플러스 3
 
1.1%
주)아성다이소 3
 
1.1%
울산화암점 3
 
1.1%
Other values (183) 193
73.4%
2024-03-14T23:59:33.776487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
119
 
7.4%
96
 
6.0%
75
 
4.7%
63
 
3.9%
46
 
2.9%
39
 
2.4%
39
 
2.4%
2 35
 
2.2%
33
 
2.1%
31
 
1.9%
Other values (224) 1033
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1310
81.4%
Space Separator 96
 
6.0%
Uppercase Letter 91
 
5.7%
Decimal Number 76
 
4.7%
Open Punctuation 18
 
1.1%
Close Punctuation 18
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
119
 
9.1%
75
 
5.7%
63
 
4.8%
46
 
3.5%
39
 
3.0%
39
 
3.0%
33
 
2.5%
31
 
2.4%
28
 
2.1%
26
 
2.0%
Other values (206) 811
61.9%
Uppercase Letter
ValueCountFrequency (%)
S 22
24.2%
U 22
24.2%
C 21
23.1%
G 20
22.0%
H 2
 
2.2%
R 1
 
1.1%
L 1
 
1.1%
Y 1
 
1.1%
N 1
 
1.1%
Decimal Number
ValueCountFrequency (%)
2 35
46.1%
5 24
31.6%
4 11
 
14.5%
1 3
 
3.9%
3 2
 
2.6%
0 1
 
1.3%
Space Separator
ValueCountFrequency (%)
96
100.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1310
81.4%
Common 208
 
12.9%
Latin 91
 
5.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
119
 
9.1%
75
 
5.7%
63
 
4.8%
46
 
3.5%
39
 
3.0%
39
 
3.0%
33
 
2.5%
31
 
2.4%
28
 
2.1%
26
 
2.0%
Other values (206) 811
61.9%
Common
ValueCountFrequency (%)
96
46.2%
2 35
 
16.8%
5 24
 
11.5%
( 18
 
8.7%
) 18
 
8.7%
4 11
 
5.3%
1 3
 
1.4%
3 2
 
1.0%
0 1
 
0.5%
Latin
ValueCountFrequency (%)
S 22
24.2%
U 22
24.2%
C 21
23.1%
G 20
22.0%
H 2
 
2.2%
R 1
 
1.1%
L 1
 
1.1%
Y 1
 
1.1%
N 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1310
81.4%
ASCII 299
 
18.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
119
 
9.1%
75
 
5.7%
63
 
4.8%
46
 
3.5%
39
 
3.0%
39
 
3.0%
33
 
2.5%
31
 
2.4%
28
 
2.1%
26
 
2.0%
Other values (206) 811
61.9%
ASCII
ValueCountFrequency (%)
96
32.1%
2 35
 
11.7%
5 24
 
8.0%
S 22
 
7.4%
U 22
 
7.4%
C 21
 
7.0%
G 20
 
6.7%
( 18
 
6.0%
) 18
 
6.0%
4 11
 
3.7%
Other values (8) 12
 
4.0%
Distinct164
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2024-03-14T23:59:34.861863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length49
Mean length28.658683
Min length20

Characters and Unicode

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

Unique

Unique161 ?
Unique (%)96.4%

Sample

1st row울산광역시 동구 대송1길 24, 2층 (화정동)
2nd row울산광역시 동구 남목21길 5, 205호 (동부동, 두산아파트)
3rd row울산광역시 동구 남목7길 36, 5동 213호 (서부동, 남목우주아파트)
4th row울산광역시 동구 서부로 51, 울산지웰시티자이2단지 209동 2605호 (서부동)
5th row울산광역시 동구 문재6길 4 (방어동)
ValueCountFrequency (%)
울산광역시 167
 
17.4%
동구 167
 
17.4%
방어진순환도로 39
 
4.1%
1층 33
 
3.4%
전하동 32
 
3.3%
방어동 26
 
2.7%
일산동 19
 
2.0%
서부동 17
 
1.8%
화정동 17
 
1.8%
2층 10
 
1.0%
Other values (314) 435
45.2%
2024-03-14T23:59:36.228917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
797
 
16.7%
378
 
7.9%
199
 
4.2%
1 173
 
3.6%
170
 
3.6%
169
 
3.5%
) 167
 
3.5%
167
 
3.5%
167
 
3.5%
167
 
3.5%
Other values (167) 2232
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2827
59.1%
Space Separator 797
 
16.7%
Decimal Number 687
 
14.4%
Close Punctuation 167
 
3.5%
Open Punctuation 167
 
3.5%
Other Punctuation 122
 
2.5%
Uppercase Letter 10
 
0.2%
Dash Punctuation 6
 
0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
378
 
13.4%
199
 
7.0%
170
 
6.0%
169
 
6.0%
167
 
5.9%
167
 
5.9%
167
 
5.9%
86
 
3.0%
86
 
3.0%
86
 
3.0%
Other values (145) 1152
40.7%
Decimal Number
ValueCountFrequency (%)
1 173
25.2%
2 89
13.0%
3 72
10.5%
0 72
10.5%
6 60
 
8.7%
4 54
 
7.9%
5 47
 
6.8%
9 47
 
6.8%
7 42
 
6.1%
8 31
 
4.5%
Uppercase Letter
ValueCountFrequency (%)
C 4
40.0%
B 3
30.0%
A 1
 
10.0%
K 1
 
10.0%
E 1
 
10.0%
Space Separator
ValueCountFrequency (%)
797
100.0%
Close Punctuation
ValueCountFrequency (%)
) 167
100.0%
Open Punctuation
ValueCountFrequency (%)
( 167
100.0%
Other Punctuation
ValueCountFrequency (%)
, 122
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2827
59.1%
Common 1948
40.7%
Latin 11
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
378
 
13.4%
199
 
7.0%
170
 
6.0%
169
 
6.0%
167
 
5.9%
167
 
5.9%
167
 
5.9%
86
 
3.0%
86
 
3.0%
86
 
3.0%
Other values (145) 1152
40.7%
Common
ValueCountFrequency (%)
797
40.9%
1 173
 
8.9%
) 167
 
8.6%
( 167
 
8.6%
, 122
 
6.3%
2 89
 
4.6%
3 72
 
3.7%
0 72
 
3.7%
6 60
 
3.1%
4 54
 
2.8%
Other values (6) 175
 
9.0%
Latin
ValueCountFrequency (%)
C 4
36.4%
B 3
27.3%
e 1
 
9.1%
A 1
 
9.1%
K 1
 
9.1%
E 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2827
59.1%
ASCII 1959
40.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
797
40.7%
1 173
 
8.8%
) 167
 
8.5%
( 167
 
8.5%
, 122
 
6.2%
2 89
 
4.5%
3 72
 
3.7%
0 72
 
3.7%
6 60
 
3.1%
4 54
 
2.8%
Other values (12) 186
 
9.5%
Hangul
ValueCountFrequency (%)
378
 
13.4%
199
 
7.0%
170
 
6.0%
169
 
6.0%
167
 
5.9%
167
 
5.9%
167
 
5.9%
86
 
3.0%
86
 
3.0%
86
 
3.0%
Other values (145) 1152
40.7%
Distinct116
Distinct (%)69.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2004-07-20 00:00:00
Maximum2024-01-08 00:00:00
2024-03-14T23:59:36.473082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:59:36.800388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
영업중
167 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 167
100.0%

Length

2024-03-14T23:59:37.032927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:59:37.210264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 167
100.0%

전화번호
Text

MISSING 

Distinct48
Distinct (%)94.1%
Missing116
Missing (%)69.5%
Memory size1.4 KiB
2024-03-14T23:59:37.987664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.921569
Min length9

Characters and Unicode

Total characters608
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

Unique45 ?
Unique (%)88.2%

Sample

1st row052-227-8103
2nd row1577-0711
3rd row1577-0711
4th row052-271-3695
5th row052-271-3695
ValueCountFrequency (%)
052-271-3695 2
 
3.9%
1577-0711 2
 
3.9%
000-0000-0000 2
 
3.9%
052-702-8066 1
 
2.0%
052-234-6342 1
 
2.0%
052-234-5290 1
 
2.0%
052-201-4141 1
 
2.0%
052-233-2334 1
 
2.0%
052-209-2686 1
 
2.0%
052-201-9649 1
 
2.0%
Other values (38) 38
74.5%
2024-03-14T23:59:39.062826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 108
17.8%
0 103
16.9%
- 100
16.4%
5 83
13.7%
3 48
7.9%
1 40
 
6.6%
7 35
 
5.8%
4 30
 
4.9%
6 25
 
4.1%
9 23
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 508
83.6%
Dash Punctuation 100
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 108
21.3%
0 103
20.3%
5 83
16.3%
3 48
9.4%
1 40
 
7.9%
7 35
 
6.9%
4 30
 
5.9%
6 25
 
4.9%
9 23
 
4.5%
8 13
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 608
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 108
17.8%
0 103
16.9%
- 100
16.4%
5 83
13.7%
3 48
7.9%
1 40
 
6.6%
7 35
 
5.8%
4 30
 
4.9%
6 25
 
4.1%
9 23
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 608
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 108
17.8%
0 103
16.9%
- 100
16.4%
5 83
13.7%
3 48
7.9%
1 40
 
6.6%
7 35
 
5.8%
4 30
 
4.9%
6 25
 
4.1%
9 23
 
3.8%

담당기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
울산광역시 동구 보건행정과
167 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산광역시 동구 보건행정과
2nd row울산광역시 동구 보건행정과
3rd row울산광역시 동구 보건행정과
4th row울산광역시 동구 보건행정과
5th row울산광역시 동구 보건행정과

Common Values

ValueCountFrequency (%)
울산광역시 동구 보건행정과 167
100.0%

Length

2024-03-14T23:59:39.288293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:59:39.455745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
울산광역시 167
33.3%
동구 167
33.3%
보건행정과 167
33.3%

담당기관 연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
052-209-4094
167 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row052-209-4094
2nd row052-209-4094
3rd row052-209-4094
4th row052-209-4094
5th row052-209-4094

Common Values

ValueCountFrequency (%)
052-209-4094 167
100.0%

Length

2024-03-14T23:59:39.631484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:59:39.798204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
052-209-4094 167
100.0%

Missing values

2024-03-14T23:59:31.667713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:59:32.058009image/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해피안힐링센타울산광역시 동구 대송1길 24, 2층 (화정동)2024-01-08영업중<NA>울산광역시 동구 보건행정과052-209-4094
1바른숨울산광역시 동구 남목21길 5, 205호 (동부동, 두산아파트)2023-12-22영업중<NA>울산광역시 동구 보건행정과052-209-4094
2와이피주식회사울산광역시 동구 남목7길 36, 5동 213호 (서부동, 남목우주아파트)2023-12-18영업중<NA>울산광역시 동구 보건행정과052-209-4094
3무무야울산광역시 동구 서부로 51, 울산지웰시티자이2단지 209동 2605호 (서부동)2023-12-07영업중<NA>울산광역시 동구 보건행정과052-209-4094
4참사랑홈파티스스튜디오 울산꽃바위점울산광역시 동구 문재6길 4 (방어동)2023-11-20영업중<NA>울산광역시 동구 보건행정과052-209-4094
5비마이뷰티울산광역시 동구 방어진순환도로 865, KCC스위첸웰츠타워2단지 203동 1909호 (전하동)2023-12-05영업중<NA>울산광역시 동구 보건행정과052-209-4094
6예나몰01울산광역시 동구 옥류로 2, 2,3층 17호 (서부동)2023-10-27영업중052-227-8103울산광역시 동구 보건행정과052-209-4094
7(주)코리아세븐 울산동구남목점울산광역시 동구 남목10길 4, 1층 (동부동)2023-10-11영업중1577-0711울산광역시 동구 보건행정과052-209-4094
8오만가지울산광역시 동구 꽃바위로 323, 301호 (방어동)2023-09-18영업중<NA>울산광역시 동구 보건행정과052-209-4094
9이마트24 동구힐스파크점울산광역시 동구 진성9길 2 (일산동, 삼성힐스파크)2023-08-14영업중<NA>울산광역시 동구 보건행정과052-209-4094
사업장명도로명전체주소인허가일자영업상태명전화번호담당기관담당기관 연락처
157롯데하이마트(주)동구일산점울산광역시 동구 방어진순환도로 642 (일산동)2023-07-13영업중052-201-5757울산광역시 동구 보건행정과052-209-4094
158씨유전하현대점울산광역시 동구 전하로 10 (전하동)2014-11-19영업중052-911-5307울산광역시 동구 보건행정과052-209-4094
159CU울산동구남목점울산광역시 동구 옥류로 6 (동부동)2021-09-02영업중052-201-5687울산광역시 동구 보건행정과052-209-4094
160펄스캠생활과학 울산동구지점울산광역시 동구 진성14길 77 (전하동)2017-07-18영업중052-235-7807울산광역시 동구 보건행정과052-209-4094
161해피랜드 동구홈플러스점울산광역시 동구 방어진순환도로 637 (일산동)2011-07-08영업중052-234-8991울산광역시 동구 보건행정과052-209-4094
162봉 덴탈울산광역시 동구 남목6길 20 (서부동)2022-08-02영업중052-234-6342울산광역시 동구 보건행정과052-209-4094
163홈플러스(주)울산동구점울산광역시 동구 방어진순환도로 637 (일산동)2021-06-01영업중052-702-8066울산광역시 동구 보건행정과052-209-4094
164한성의료기보청기상사울산광역시 동구 방어진순환도로 793-1 (전하동)2006-10-04영업중052-201-4141울산광역시 동구 보건행정과052-209-4094
165동인의료기울산광역시 동구 방어진순환도로 859 (전하동)2004-07-20영업중052-234-2500울산광역시 동구 보건행정과052-209-4094
166누가의료기울산광역시 동구 방어진순환도로 743 (전하동)2020-04-09영업중052-201-9949울산광역시 동구 보건행정과052-209-4094