Overview

Dataset statistics

Number of variables7
Number of observations75
Missing cells32
Missing cells (%)6.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory57.8 B

Variable types

Text3
DateTime1
Categorical3

Dataset

Description파주시에 소재한 소독업소들에 대한 데이터로서 소독업소명칭, 소재지도로명주소, 소독업소 신고일자, 전화번호, 관리기관, 관리기관 전화번호 등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15083963/fileData.do

Alerts

관리기관명 has constant value ""Constant
관리기관 전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
전화번호 has 32 (42.7%) missing valuesMissing
소독업소명칭 has unique valuesUnique
소재지도로명주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:52:46.069902
Analysis finished2023-12-12 19:52:46.578495
Duration0.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

소독업소명칭
Text

UNIQUE 

Distinct75
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-13T04:52:46.765675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length12
Mean length6.7866667
Min length3

Characters and Unicode

Total characters509
Distinct characters175
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

Unique75 ?
Unique (%)100.0%

Sample

1st row현대방제
2nd row대한방역공사
3rd row삼원방역공사
4th row보건방역
5th row파주방역
ValueCountFrequency (%)
주식회사 5
 
5.4%
현대방제 1
 
1.1%
운터스베르크 1
 
1.1%
오케이솔루션 1
 
1.1%
㈜양정 1
 
1.1%
㈜케어맥스코리아 1
 
1.1%
유일방역 1
 
1.1%
도시마을협동조합 1
 
1.1%
파주 1
 
1.1%
클린케어 1
 
1.1%
Other values (78) 78
84.8%
2023-12-13T04:52:47.135700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 23
 
4.5%
18
 
3.5%
( 14
 
2.8%
) 14
 
2.8%
방 13
 
2.6%
사 13
 
2.6%
스 12
 
2.4%
이 12
 
2.4%
케 11
 
2.2%
역 10
 
2.0%
Other values (165) 369
72.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 428
84.1%
Space Separator 18
 
3.5%
Open Punctuation 14
 
2.8%
Close Punctuation 14
 
2.8%
Uppercase Letter 14
 
2.8%
Other Symbol 8
 
1.6%
Lowercase Letter 8
 
1.6%
Decimal Number 4
 
0.8%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 23
 
5.4%
방 13
 
3.0%
사 13
 
3.0%
스 12
 
2.8%
이 12
 
2.8%
케 11
 
2.6%
역 10
 
2.3%
경 10
 
2.3%
린 9
 
2.1%
회 8
 
1.9%
Other values (140) 307
71.7%
Uppercase Letter
ValueCountFrequency (%)
S 2
14.3%
E 2
14.3%
C 2
14.3%
O 2
14.3%
F 1
7.1%
T 1
7.1%
A 1
7.1%
L 1
7.1%
K 1
7.1%
P 1
7.1%
Lowercase Letter
ValueCountFrequency (%)
e 2
25.0%
v 1
12.5%
r 1
12.5%
y 1
12.5%
l 1
12.5%
n 1
12.5%
a 1
12.5%
Decimal Number
ValueCountFrequency (%)
1 2
50.0%
5 1
25.0%
9 1
25.0%
Space Separator
ValueCountFrequency (%)
18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 436
85.7%
Common 51
 
10.0%
Latin 22
 
4.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 23
 
5.3%
방 13
 
3.0%
사 13
 
3.0%
스 12
 
2.8%
이 12
 
2.8%
케 11
 
2.5%
역 10
 
2.3%
경 10
 
2.3%
린 9
 
2.1%
회 8
 
1.8%
Other values (141) 315
72.2%
Latin
ValueCountFrequency (%)
S 2
 
9.1%
E 2
 
9.1%
e 2
 
9.1%
C 2
 
9.1%
O 2
 
9.1%
F 1
 
4.5%
T 1
 
4.5%
v 1
 
4.5%
r 1
 
4.5%
y 1
 
4.5%
Other values (7) 7
31.8%
Common
ValueCountFrequency (%)
18
35.3%
( 14
27.5%
) 14
27.5%
1 2
 
3.9%
5 1
 
2.0%
9 1
 
2.0%
- 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 428
84.1%
ASCII 73
 
14.3%
None 8
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 23
 
5.4%
방 13
 
3.0%
사 13
 
3.0%
스 12
 
2.8%
이 12
 
2.8%
케 11
 
2.6%
역 10
 
2.3%
경 10
 
2.3%
린 9
 
2.1%
회 8
 
1.9%
Other values (140) 307
71.7%
ASCII
ValueCountFrequency (%)
18
24.7%
( 14
19.2%
) 14
19.2%
S 2
 
2.7%
E 2
 
2.7%
e 2
 
2.7%
C 2
 
2.7%
1 2
 
2.7%
O 2
 
2.7%
F 1
 
1.4%
Other values (14) 14
19.2%
None
ValueCountFrequency (%)
㈜ 8
100.0%

소재지도로명주소
Text

UNIQUE 

Distinct75
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-12-13T04:52:47.412553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length30
Mean length22.413333
Min length10

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)100.0%

Sample

1st row파주시 광탄면 큰여울길 8, 1층 102호
2nd row파주시 아동로 16, 103호 (아동동)
3rd row파주시 금정로 75, 2층 (금촌동)
4th row파주시 평화로 65, 홍익키즈스쿨 (금촌동)
5th row파주시 새꽃로 157 (금촌동)
ValueCountFrequency (%)
파주시 75
 
20.5%
2층 11
 
3.0%
금촌동 9
 
2.5%
월롱면 8
 
2.2%
파주읍 5
 
1.4%
1층 5
 
1.4%
조리읍 5
 
1.4%
상지석길 4
 
1.1%
탄현면 4
 
1.1%
아동동 3
 
0.8%
Other values (193) 236
64.7%
2023-12-13T04:52:47.839148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
292
 
17.4%
1 90
 
5.4%
파 85
 
5.1%
주 82
 
4.9%
시 76
 
4.5%
2 64
 
3.8%
0 56
 
3.3%
3 53
 
3.2%
동 51
 
3.0%
로 50
 
3.0%
Other values (157) 782
46.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 852
50.7%
Decimal Number 402
23.9%
Space Separator 292
 
17.4%
Other Punctuation 48
 
2.9%
Open Punctuation 27
 
1.6%
Close Punctuation 27
 
1.6%
Dash Punctuation 25
 
1.5%
Math Symbol 6
 
0.4%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
파 85
 
10.0%
주 82
 
9.6%
시 76
 
8.9%
동 51
 
6.0%
로 50
 
5.9%
길 34
 
4.0%
호 32
 
3.8%
층 27
 
3.2%
금 18
 
2.1%
면 17
 
2.0%
Other values (138) 380
44.6%
Decimal Number
ValueCountFrequency (%)
1 90
22.4%
2 64
15.9%
0 56
13.9%
3 53
13.2%
4 42
10.4%
5 26
 
6.5%
7 22
 
5.5%
9 21
 
5.2%
6 17
 
4.2%
8 11
 
2.7%
Other Punctuation
ValueCountFrequency (%)
, 47
97.9%
. 1
 
2.1%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
F 1
50.0%
Space Separator
ValueCountFrequency (%)
292
100.0%
Open Punctuation
ValueCountFrequency (%)
( 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 25
100.0%
Math Symbol
ValueCountFrequency (%)
~ 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 852
50.7%
Common 827
49.2%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
파 85
 
10.0%
주 82
 
9.6%
시 76
 
8.9%
동 51
 
6.0%
로 50
 
5.9%
길 34
 
4.0%
호 32
 
3.8%
층 27
 
3.2%
금 18
 
2.1%
면 17
 
2.0%
Other values (138) 380
44.6%
Common
ValueCountFrequency (%)
292
35.3%
1 90
 
10.9%
2 64
 
7.7%
0 56
 
6.8%
3 53
 
6.4%
, 47
 
5.7%
4 42
 
5.1%
( 27
 
3.3%
) 27
 
3.3%
5 26
 
3.1%
Other values (7) 103
 
12.5%
Latin
ValueCountFrequency (%)
B 1
50.0%
F 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 852
50.7%
ASCII 829
49.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
292
35.2%
1 90
 
10.9%
2 64
 
7.7%
0 56
 
6.8%
3 53
 
6.4%
, 47
 
5.7%
4 42
 
5.1%
( 27
 
3.3%
) 27
 
3.3%
5 26
 
3.1%
Other values (9) 105
 
12.7%
Hangul
ValueCountFrequency (%)
파 85
 
10.0%
주 82
 
9.6%
시 76
 
8.9%
동 51
 
6.0%
로 50
 
5.9%
길 34
 
4.0%
호 32
 
3.8%
층 27
 
3.2%
금 18
 
2.1%
면 17
 
2.0%
Other values (138) 380
44.6%

신고일자
Date

Distinct73
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
Minimum1986-04-22 00:00:00
Maximum2023-05-03 00:00:00
2023-12-13T04:52:47.981802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:52:48.155689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

전화번호
Text

MISSING 

Distinct42
Distinct (%)97.7%
Missing32
Missing (%)42.7%
Memory size732.0 B
2023-12-13T04:52:48.361701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length12
Mean length13.232558
Min length9

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)95.3%

Sample

1st row031-948-0090
2nd row031-941-3165
3rd row031-945-9096
4th row031-941-0607
5th row031-944-4119
ValueCountFrequency (%)
031-941-0607 2
 
4.2%
2
 
4.2%
031-949-5764 1
 
2.1%
1544-4820 1
 
2.1%
031-948-0090 1
 
2.1%
031-941-2758 1
 
2.1%
031-946-0023 1
 
2.1%
031-975-1088 1
 
2.1%
031-942-1214 1
 
2.1%
031-942-8955 1
 
2.1%
Other values (36) 36
75.0%
2023-12-13T04:52:48.739907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 90
15.8%
0 81
14.2%
1 77
13.5%
9 58
10.2%
4 55
9.7%
3 54
9.5%
5 37
6.5%
2 34
 
6.0%
6 27
 
4.7%
7 23
 
4.0%
Other values (5) 33
 
5.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 468
82.2%
Dash Punctuation 90
 
15.8%
Space Separator 6
 
1.1%
Other Punctuation 4
 
0.7%
Math Symbol 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 81
17.3%
1 77
16.5%
9 58
12.4%
4 55
11.8%
3 54
11.5%
5 37
7.9%
2 34
7.3%
6 27
 
5.8%
7 23
 
4.9%
8 22
 
4.7%
Other Punctuation
ValueCountFrequency (%)
/ 2
50.0%
, 2
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 569
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 90
15.8%
0 81
14.2%
1 77
13.5%
9 58
10.2%
4 55
9.7%
3 54
9.5%
5 37
6.5%
2 34
 
6.0%
6 27
 
4.7%
7 23
 
4.0%
Other values (5) 33
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 569
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 90
15.8%
0 81
14.2%
1 77
13.5%
9 58
10.2%
4 55
9.7%
3 54
9.5%
5 37
6.5%
2 34
 
6.0%
6 27
 
4.7%
7 23
 
4.0%
Other values (5) 33
 
5.8%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
경기도 파주시 보건소 질병관리과
75 

Length

Max length17
Median length17
Mean length17
Min length17

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 파주시 보건소 질병관리과
2nd row경기도 파주시 보건소 질병관리과
3rd row경기도 파주시 보건소 질병관리과
4th row경기도 파주시 보건소 질병관리과
5th row경기도 파주시 보건소 질병관리과

Common Values

ValueCountFrequency (%)
경기도 파주시 보건소 질병관리과 75
100.0%

Length

2023-12-13T04:52:48.915640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:52:49.033980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 75
25.0%
파주시 75
25.0%
보건소 75
25.0%
질병관리과 75
25.0%

관리기관 전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
031-940-5580
75 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-940-5580
2nd row031-940-5580
3rd row031-940-5580
4th row031-940-5580
5th row031-940-5580

Common Values

ValueCountFrequency (%)
031-940-5580 75
100.0%

Length

2023-12-13T04:52:49.142664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:52:49.244994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-940-5580 75
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size732.0 B
2023-08-01
75 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-01
2nd row2023-08-01
3rd row2023-08-01
4th row2023-08-01
5th row2023-08-01

Common Values

ValueCountFrequency (%)
2023-08-01 75
100.0%

Length

2023-12-13T04:52:49.351987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:52:49.459779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-01 75
100.0%

Correlations

2023-12-13T04:52:49.522747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소독업소명칭소재지도로명주소신고일자전화번호
소독업소명칭1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.000
신고일자1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2023-12-13T04:52:46.413380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:52:46.532800image/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현대방제파주시 광탄면 큰여울길 8, 1층 102호2009-11-09031-948-0090경기도 파주시 보건소 질병관리과031-940-55802023-08-01
1대한방역공사파주시 아동로 16, 103호 (아동동)1986-04-22031-941-3165경기도 파주시 보건소 질병관리과031-940-55802023-08-01
2삼원방역공사파주시 금정로 75, 2층 (금촌동)1995-10-18031-945-9096경기도 파주시 보건소 질병관리과031-940-55802023-08-01
3보건방역파주시 평화로 65, 홍익키즈스쿨 (금촌동)2001-04-04031-941-0607경기도 파주시 보건소 질병관리과031-940-55802023-08-01
4파주방역파주시 새꽃로 157 (금촌동)2005-05-19031-944-4119경기도 파주시 보건소 질병관리과031-940-55802023-08-01
5(주)두성파주시 문화로 23 (금촌동)2009-12-24031-946-9515경기도 파주시 보건소 질병관리과031-940-55802023-08-01
6(사)파주시새마을회파주시 시청로 3-11, 새마을 회관 3~4층 3~4층 (사무실)2013-02-27031-941-9191경기도 파주시 보건소 질병관리과031-940-55802023-08-01
7지앤시파주시 동산3길 35-9 (금촌동)2013-07-10031-941-7834경기도 파주시 보건소 질병관리과031-940-55802023-08-01
8은혜환경파주시 중앙로 294, 서부빌딩 304호 (금촌동)2013-11-06031-941-0607경기도 파주시 보건소 질병관리과031-940-55802023-08-01
9(주)클린케어파주시 가나무로 143, 파주메트로프라자 2층 4호 (금릉동)2015-10-22031-949-3675경기도 파주시 보건소 질병관리과031-940-55802023-08-01
소독업소명칭소재지도로명주소신고일자전화번호관리기관명관리기관 전화번호데이터기준일
65해송종합시스템파주시 파주읍 연풍5길 20, 2층 202호2021-12-08<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
66버그헌터119 파주센터파주시 파주읍 광천탄로 319-12022-01-11<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
67(주)비앤씨파주시 파주읍 여울길 310-8, 1층2021-06-15<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
68지구촌 컨설팅파주시 적성면 적서초교길 1502022-12-30<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
69㈜서정매니지먼트파주시 탄현면 국원말길 46-4, 지하1층 13호2023-01-31<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
70에코켐파주시 찬우물길 50, 2동 1층 (검산동)2021-08-06070-7630-2244경기도 파주시 보건소 질병관리과031-940-55802023-08-01
71㈜베이스코퍼레이션파주시 찬우물길 50, 1~2층 (검산동)2023-02-13<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
72해피라이프파주시 파평면 청송로 4132023-02-15<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
73도담케어파주시 파주읍 술이홀로 470, 201호2023-05-03<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01
74트리플파주시 월롱면 황소바위길 346, 1층2022-04-25<NA>경기도 파주시 보건소 질병관리과031-940-55802023-08-01