Overview

Dataset statistics

Number of variables6
Number of observations230
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.1 KiB
Average record size in memory49.6 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description충청북도 제천시 병원, 약국 등 의료기관 현황- 번호- 의료기관종별- 의료기관명- 의료기관주소(도로명)- 전화번호- 데이터기준일자
Author충청북도 제천시
URLhttps://www.data.go.kr/data/15033914/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 의료기관종별High correlation
의료기관종별 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-15 02:07:16.518063
Analysis finished2024-03-15 02:07:17.801800
Duration1.28 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct230
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean115.5
Minimum1
Maximum230
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-03-15T11:07:18.075121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.45
Q158.25
median115.5
Q3172.75
95-th percentile218.55
Maximum230
Range229
Interquartile range (IQR)114.5

Descriptive statistics

Standard deviation66.539462
Coefficient of variation (CV)0.57609924
Kurtosis-1.2
Mean115.5
Median Absolute Deviation (MAD)57.5
Skewness0
Sum26565
Variance4427.5
MonotonicityStrictly increasing
2024-03-15T11:07:18.489394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
146 1
 
0.4%
148 1
 
0.4%
149 1
 
0.4%
150 1
 
0.4%
151 1
 
0.4%
152 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
Other values (220) 220
95.7%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
230 1
0.4%
229 1
0.4%
228 1
0.4%
227 1
0.4%
226 1
0.4%
225 1
0.4%
224 1
0.4%
223 1
0.4%
222 1
0.4%
221 1
0.4%

의료기관종별
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
의원
82 
약국
55 
치과의원
45 
한의원
37 
요양병원(일반요양병원)
 
5
Other values (5)
 
6

Length

Max length12
Median length2
Mean length2.8086957
Min length2

Unique

Unique4 ?
Unique (%)1.7%

Sample

1st row의원
2nd row의원
3rd row의원
4th row의원
5th row의원

Common Values

ValueCountFrequency (%)
의원 82
35.7%
약국 55
23.9%
치과의원 45
19.6%
한의원 37
16.1%
요양병원(일반요양병원) 5
 
2.2%
종합병원 2
 
0.9%
병원 1
 
0.4%
정신병원 1
 
0.4%
한방병원 1
 
0.4%
한약국 1
 
0.4%

Length

2024-03-15T11:07:19.255110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:07:19.649971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의원 82
35.7%
약국 55
23.9%
치과의원 45
19.6%
한의원 37
16.1%
요양병원(일반요양병원 5
 
2.2%
종합병원 2
 
0.9%
병원 1
 
0.4%
정신병원 1
 
0.4%
한방병원 1
 
0.4%
한약국 1
 
0.4%

의료기관명
Text

Distinct229
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2024-03-15T11:07:20.580564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length6.9086957
Min length3

Characters and Unicode

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

Unique

Unique228 ?
Unique (%)99.1%

Sample

1st row황민호신경과의원
2nd row서울튼튼마취통증의학과의원
3rd row서울연합내과의원
4th row재림메디칼의원
5th row기운찬정형외과의원
ValueCountFrequency (%)
의료법인 5
 
2.1%
두손온누리약국 2
 
0.8%
창민의료재단 2
 
0.8%
장세혁치과의원 1
 
0.4%
약손한의원 1
 
0.4%
경희길한의원 1
 
0.4%
자연한의원 1
 
0.4%
남창규한의원 1
 
0.4%
고려한의원 1
 
0.4%
송수한의원 1
 
0.4%
Other values (225) 225
93.4%
2024-03-15T11:07:22.093420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
의 187
 
11.8%
원 183
 
11.5%
과 108
 
6.8%
약 57
 
3.6%
국 56
 
3.5%
한 50
 
3.1%
치 46
 
2.9%
인 26
 
1.6%
세 20
 
1.3%
정 20
 
1.3%
Other values (210) 836
52.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1573
99.0%
Space Separator 11
 
0.7%
Decimal Number 3
 
0.2%
Dash Punctuation 1
 
0.1%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 187
 
11.9%
원 183
 
11.6%
과 108
 
6.9%
약 57
 
3.6%
국 56
 
3.6%
한 50
 
3.2%
치 46
 
2.9%
인 26
 
1.7%
세 20
 
1.3%
정 20
 
1.3%
Other values (205) 820
52.1%
Decimal Number
ValueCountFrequency (%)
0 2
66.7%
1 1
33.3%
Space Separator
ValueCountFrequency (%)
11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1573
99.0%
Common 15
 
0.9%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 187
 
11.9%
원 183
 
11.6%
과 108
 
6.9%
약 57
 
3.6%
국 56
 
3.6%
한 50
 
3.2%
치 46
 
2.9%
인 26
 
1.7%
세 20
 
1.3%
정 20
 
1.3%
Other values (205) 820
52.1%
Common
ValueCountFrequency (%)
11
73.3%
0 2
 
13.3%
1 1
 
6.7%
- 1
 
6.7%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1573
99.0%
ASCII 16
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
의 187
 
11.9%
원 183
 
11.6%
과 108
 
6.9%
약 57
 
3.6%
국 56
 
3.6%
한 50
 
3.2%
치 46
 
2.9%
인 26
 
1.7%
세 20
 
1.3%
정 20
 
1.3%
Other values (205) 820
52.1%
ASCII
ValueCountFrequency (%)
11
68.8%
0 2
 
12.5%
1 1
 
6.2%
- 1
 
6.2%
e 1
 
6.2%

의료기관주소(도로명)
Text

Distinct186
Distinct (%)80.9%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2024-03-15T11:07:23.092633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length39
Mean length25.817391
Min length19

Characters and Unicode

Total characters5938
Distinct characters137
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

Unique160 ?
Unique (%)69.6%

Sample

1st row충청북도 제천시 의림대로 222, 두손메디칼센타 6층 (청전동)
2nd row충청북도 제천시 용두천로 88, 영창빌딩 4층 (남천동)
3rd row충청북도 제천시 청전대로 182, 비둘기아파트 (청전동)
4th row충청북도 제천시 청전대로 216, 2,4,7층층 (장락동)
5th row충청북도 제천시 독순로 79, 내토메디컬센터 201호 (중앙로2가)
ValueCountFrequency (%)
충청북도 230
18.5%
제천시 230
18.5%
중앙로2가 52
 
4.2%
의림대로 50
 
4.0%
남천동 37
 
3.0%
중앙로1가 33
 
2.6%
용두천로 32
 
2.6%
청전동 28
 
2.2%
독순로 20
 
1.6%
의병대로 18
 
1.4%
Other values (211) 516
41.4%
2024-03-15T11:07:24.570938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1019
 
17.2%
로 314
 
5.3%
천 309
 
5.2%
청 276
 
4.6%
제 237
 
4.0%
시 234
 
3.9%
북 232
 
3.9%
충 230
 
3.9%
도 230
 
3.9%
1 224
 
3.8%
Other values (127) 2633
44.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3538
59.6%
Space Separator 1019
 
17.2%
Decimal Number 830
 
14.0%
Open Punctuation 223
 
3.8%
Close Punctuation 223
 
3.8%
Other Punctuation 80
 
1.3%
Dash Punctuation 18
 
0.3%
Uppercase Letter 5
 
0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 314
 
8.9%
천 309
 
8.7%
청 276
 
7.8%
제 237
 
6.7%
시 234
 
6.6%
북 232
 
6.6%
충 230
 
6.5%
도 230
 
6.5%
동 147
 
4.2%
대 99
 
2.8%
Other values (105) 1230
34.8%
Decimal Number
ValueCountFrequency (%)
1 224
27.0%
2 177
21.3%
8 65
 
7.8%
7 63
 
7.6%
3 61
 
7.3%
9 52
 
6.3%
0 52
 
6.3%
5 52
 
6.3%
4 50
 
6.0%
6 34
 
4.1%
Uppercase Letter
ValueCountFrequency (%)
A 1
20.0%
M 1
20.0%
R 1
20.0%
E 1
20.0%
T 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 79
98.8%
. 1
 
1.2%
Space Separator
ValueCountFrequency (%)
1019
100.0%
Open Punctuation
ValueCountFrequency (%)
( 223
100.0%
Close Punctuation
ValueCountFrequency (%)
) 223
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3538
59.6%
Common 2395
40.3%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 314
 
8.9%
천 309
 
8.7%
청 276
 
7.8%
제 237
 
6.7%
시 234
 
6.6%
북 232
 
6.6%
충 230
 
6.5%
도 230
 
6.5%
동 147
 
4.2%
대 99
 
2.8%
Other values (105) 1230
34.8%
Common
ValueCountFrequency (%)
1019
42.5%
1 224
 
9.4%
( 223
 
9.3%
) 223
 
9.3%
2 177
 
7.4%
, 79
 
3.3%
8 65
 
2.7%
7 63
 
2.6%
3 61
 
2.5%
9 52
 
2.2%
Other values (7) 209
 
8.7%
Latin
ValueCountFrequency (%)
A 1
20.0%
M 1
20.0%
R 1
20.0%
E 1
20.0%
T 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3538
59.6%
ASCII 2400
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1019
42.5%
1 224
 
9.3%
( 223
 
9.3%
) 223
 
9.3%
2 177
 
7.4%
, 79
 
3.3%
8 65
 
2.7%
7 63
 
2.6%
3 61
 
2.5%
9 52
 
2.2%
Other values (12) 214
 
8.9%
Hangul
ValueCountFrequency (%)
로 314
 
8.9%
천 309
 
8.7%
청 276
 
7.8%
제 237
 
6.7%
시 234
 
6.6%
북 232
 
6.6%
충 230
 
6.5%
도 230
 
6.5%
동 147
 
4.2%
대 99
 
2.8%
Other values (105) 1230
34.8%

전화번호
Text

Distinct226
Distinct (%)98.7%
Missing1
Missing (%)0.4%
Memory size1.9 KiB
2024-03-15T11:07:25.396328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.008734
Min length12

Characters and Unicode

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

Unique223 ?
Unique (%)97.4%

Sample

1st row043-653-7118
2nd row043-644-7582
3rd row043-651-9100
4th row043-647-1000
5th row043-642-0001
ValueCountFrequency (%)
043-652-2666 2
 
0.9%
043-645-1722 2
 
0.9%
043-652-6022 2
 
0.9%
043-645-6102 1
 
0.4%
043-644-8575 1
 
0.4%
043-648-3375 1
 
0.4%
043-653-7730 1
 
0.4%
043-651-0030 1
 
0.4%
043-653-7118 1
 
0.4%
043-646-2778 1
 
0.4%
Other values (216) 216
94.3%
2024-03-15T11:07:26.530050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 463
16.8%
- 458
16.7%
0 397
14.4%
3 336
12.2%
6 317
11.5%
5 200
7.3%
2 175
 
6.4%
7 158
 
5.7%
1 104
 
3.8%
8 101
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2292
83.3%
Dash Punctuation 458
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 463
20.2%
0 397
17.3%
3 336
14.7%
6 317
13.8%
5 200
8.7%
2 175
 
7.6%
7 158
 
6.9%
1 104
 
4.5%
8 101
 
4.4%
9 41
 
1.8%
Dash Punctuation
ValueCountFrequency (%)
- 458
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2750
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 463
16.8%
- 458
16.7%
0 397
14.4%
3 336
12.2%
6 317
11.5%
5 200
7.3%
2 175
 
6.4%
7 158
 
5.7%
1 104
 
3.8%
8 101
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2750
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 463
16.8%
- 458
16.7%
0 397
14.4%
3 336
12.2%
6 317
11.5%
5 200
7.3%
2 175
 
6.4%
7 158
 
5.7%
1 104
 
3.8%
8 101
 
3.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2024-01-03
230 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-03
2nd row2024-01-03
3rd row2024-01-03
4th row2024-01-03
5th row2024-01-03

Common Values

ValueCountFrequency (%)
2024-01-03 230
100.0%

Length

2024-03-15T11:07:26.772236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:07:26.931966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-03 230
100.0%

Interactions

2024-03-15T11:07:16.952114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T11:07:27.045741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번의료기관종별
연번1.0000.917
의료기관종별0.9171.000
2024-03-15T11:07:27.242063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번의료기관종별
연번1.0000.533
의료기관종별0.5331.000

Missing values

2024-03-15T11:07:17.268130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T11:07:17.628332image/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의원황민호신경과의원충청북도 제천시 의림대로 222, 두손메디칼센타 6층 (청전동)043-653-71182024-01-03
12의원서울튼튼마취통증의학과의원충청북도 제천시 용두천로 88, 영창빌딩 4층 (남천동)043-644-75822024-01-03
23의원서울연합내과의원충청북도 제천시 청전대로 182, 비둘기아파트 (청전동)043-651-91002024-01-03
34의원재림메디칼의원충청북도 제천시 청전대로 216, 2,4,7층층 (장락동)043-647-10002024-01-03
45의원기운찬정형외과의원충청북도 제천시 독순로 79, 내토메디컬센터 201호 (중앙로2가)043-642-00012024-01-03
56의원박가정의학과의원충청북도 제천시 용두천로 78, 2층 (남천동)043-647-70002024-01-03
67의원삼성바른정형외과의원충청북도 제천시 의림대로 123, 2층 (중앙로2가)043-643-33002024-01-03
78의원온빛안과의원충청북도 제천시 용두천로 88, 영창빌딩 2,3층 (남천동)043-756-75772024-01-03
89의원최상현내과의원충청북도 제천시 용두대로15길 4, 용두시티 2층 201호 (하소동)043-647-11112024-01-03
910의원이원재내과의원충청북도 제천시 용두천로 117, 제천메디컬센터 4층 (중앙로1가)043-648-75532024-01-03
연번의료기관종별의료기관명의료기관주소(도로명)전화번호데이터기준일자
220221약국온누리건강약국충청북도 제천시 의병대로 233 (신백동)043-642-43002024-01-03
221222약국영진약국충청북도 제천시 명륜로 98 (중앙로2가)043-647-61712024-01-03
222223약국중앙로약국충청북도 제천시 의림대로14길 4 (중앙로1가)043-645-36112024-01-03
223224약국중앙약국충청북도 제천시 의림대로 180 (중앙로2가)043-643-30322024-01-03
224225약국금강약국충청북도 제천시 독순로 81 (중앙로2가)043-647-30392024-01-03
225226약국감초당약국충청북도 제천시 청풍호로 100 (강제동)043-645-61022024-01-03
226227약국세일약국충청북도 제천시 의림대로 109 (중앙로1가)043-642-27212024-01-03
227228약국동일약국충청북도 제천시 백운면 평동로2길 8043-652-60222024-01-03
228229약국수산약국충청북도 제천시 수산면 월악로22길 96-9043-648-51292024-01-03
229230한약국초정한약국충청북도 제천시 숭문로 108 (의림동)<NA>2024-01-03