Overview

Dataset statistics

Number of variables10
Number of observations31
Missing cells31
Missing cells (%)10.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory88.3 B

Variable types

Numeric1
Categorical5
Text3
Unsupported1

Dataset

Description전라북도 임실군의 병의원현황 데이터 입니다. 데이터 세부내역에는 구분, 기관명, 소재지, 전화번호, 진료과목, 병상수, 휴무일, 진료시간, 층수를 포함하여 제공하고 있습니다.
Author전라북도 임실군
URLhttps://www.data.go.kr/data/3076432/fileData.do

Alerts

휴무일 has constant value ""Constant
순번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 순번 and 3 other fieldsHigh correlation
진료과목 is highly overall correlated with 구분 and 2 other fieldsHigh correlation
병상수 is highly overall correlated with 구분 and 2 other fieldsHigh correlation
층수 is highly overall correlated with 구분 and 2 other fieldsHigh correlation
병상수 is highly imbalanced (65.0%)Imbalance
진료시간 has 31 (100.0%) missing valuesMissing
순번 has unique valuesUnique
기관명 has unique valuesUnique
전화번호 has unique valuesUnique
진료시간 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 15:29:24.611353
Analysis finished2023-12-12 15:29:25.236073
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2023-12-13T00:29:25.288468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q18.5
median16
Q323.5
95-th percentile29.5
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation9.0921211
Coefficient of variation (CV)0.56825757
Kurtosis-1.2
Mean16
Median Absolute Deviation (MAD)8
Skewness0
Sum496
Variance82.666667
MonotonicityStrictly increasing
2023-12-13T00:29:25.407944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
31 1
 
3.2%
30 1
 
3.2%
29 1
 
3.2%
28 1
 
3.2%
27 1
 
3.2%
26 1
 
3.2%
25 1
 
3.2%
24 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
1 1
3.2%
2 1
3.2%
3 1
3.2%
4 1
3.2%
5 1
3.2%
6 1
3.2%
7 1
3.2%
8 1
3.2%
9 1
3.2%
10 1
3.2%
ValueCountFrequency (%)
31 1
3.2%
30 1
3.2%
29 1
3.2%
28 1
3.2%
27 1
3.2%
26 1
3.2%
25 1
3.2%
24 1
3.2%
23 1
3.2%
22 1
3.2%

구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size380.0 B
의원
15 
한의원
7 
치과의원
6 
요양병원
2 
병원
 
1

Length

Max length4
Median length2
Mean length2.7419355
Min length2

Unique

Unique1 ?
Unique (%)3.2%

Sample

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

Common Values

ValueCountFrequency (%)
의원 15
48.4%
한의원 7
22.6%
치과의원 6
 
19.4%
요양병원 2
 
6.5%
병원 1
 
3.2%

Length

2023-12-13T00:29:25.563256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:29:25.677613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의원 15
48.4%
한의원 7
22.6%
치과의원 6
 
19.4%
요양병원 2
 
6.5%
병원 1
 
3.2%

기관명
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-13T00:29:25.877409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length6.9354839
Min length4

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row의료법인 이루의료재단 임실병원
2nd row의료법인예본의료재단 선요양병원
3rd row임실중앙요양병원
4th row기쁨정형외과의원
5th row중앙의원
ValueCountFrequency (%)
의료법인 1
 
2.9%
오수치과의원 1
 
2.9%
현대마취통증의학과의원 1
 
2.9%
신치과의원 1
 
2.9%
부부치과의원 1
 
2.9%
송치과의원 1
 
2.9%
관촌치과의원 1
 
2.9%
상아치과의원 1
 
2.9%
오수대명한의원 1
 
2.9%
전주가정의원 1
 
2.9%
Other values (25) 25
71.4%
2023-12-13T00:29:26.216980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
의 36
 
16.7%
원 32
 
14.9%
과 15
 
7.0%
한 8
 
3.7%
정 6
 
2.8%
치 6
 
2.8%
가 5
 
2.3%
4
 
1.9%
학 4
 
1.9%
료 4
 
1.9%
Other values (63) 95
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 211
98.1%
Space Separator 4
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 36
 
17.1%
원 32
 
15.2%
과 15
 
7.1%
한 8
 
3.8%
정 6
 
2.8%
치 6
 
2.8%
가 5
 
2.4%
학 4
 
1.9%
료 4
 
1.9%
오 3
 
1.4%
Other values (62) 92
43.6%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 211
98.1%
Common 4
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 36
 
17.1%
원 32
 
15.2%
과 15
 
7.1%
한 8
 
3.8%
정 6
 
2.8%
치 6
 
2.8%
가 5
 
2.4%
학 4
 
1.9%
료 4
 
1.9%
오 3
 
1.4%
Other values (62) 92
43.6%
Common
ValueCountFrequency (%)
4
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 211
98.1%
ASCII 4
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
의 36
 
17.1%
원 32
 
15.2%
과 15
 
7.1%
한 8
 
3.8%
정 6
 
2.8%
치 6
 
2.8%
가 5
 
2.4%
학 4
 
1.9%
료 4
 
1.9%
오 3
 
1.4%
Other values (62) 92
43.6%
ASCII
ValueCountFrequency (%)
4
100.0%

소재지
Text

Distinct28
Distinct (%)90.3%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-13T00:29:26.409770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length19.870968
Min length18

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)80.6%

Sample

1st row전라북도 임실군 임실읍 운수로 15
2nd row전라북도 임실군 덕치면 사곡1길 9-8
3rd row전라북도 임실군 임실읍 봉황로 71
4th row전라북도 임실군 임실읍 운수로 34
5th row전라북도 임실군 관촌면 사선로 40
ValueCountFrequency (%)
전라북도 31
19.9%
임실군 31
19.9%
임실읍 13
 
8.3%
오수면 10
 
6.4%
운수로 8
 
5.1%
관촌면 7
 
4.5%
사선로 6
 
3.8%
오수로 6
 
3.8%
삼일로 4
 
2.6%
봉황로 4
 
2.6%
Other values (32) 36
23.1%
2023-12-13T00:29:26.743284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
125
20.3%
임 44
 
7.1%
실 44
 
7.1%
전 31
 
5.0%
라 31
 
5.0%
북 31
 
5.0%
도 31
 
5.0%
군 31
 
5.0%
로 28
 
4.5%
수 24
 
3.9%
Other values (29) 196
31.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 404
65.6%
Space Separator 125
 
20.3%
Decimal Number 81
 
13.1%
Dash Punctuation 5
 
0.8%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
임 44
10.9%
실 44
10.9%
전 31
 
7.7%
라 31
 
7.7%
북 31
 
7.7%
도 31
 
7.7%
군 31
 
7.7%
로 28
 
6.9%
수 24
 
5.9%
면 18
 
4.5%
Other values (16) 91
22.5%
Decimal Number
ValueCountFrequency (%)
1 23
28.4%
2 12
14.8%
3 8
 
9.9%
4 7
 
8.6%
0 7
 
8.6%
9 7
 
8.6%
7 6
 
7.4%
5 5
 
6.2%
6 4
 
4.9%
8 2
 
2.5%
Space Separator
ValueCountFrequency (%)
125
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 404
65.6%
Common 212
34.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
임 44
10.9%
실 44
10.9%
전 31
 
7.7%
라 31
 
7.7%
북 31
 
7.7%
도 31
 
7.7%
군 31
 
7.7%
로 28
 
6.9%
수 24
 
5.9%
면 18
 
4.5%
Other values (16) 91
22.5%
Common
ValueCountFrequency (%)
125
59.0%
1 23
 
10.8%
2 12
 
5.7%
3 8
 
3.8%
4 7
 
3.3%
0 7
 
3.3%
9 7
 
3.3%
7 6
 
2.8%
5 5
 
2.4%
- 5
 
2.4%
Other values (3) 7
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 404
65.6%
ASCII 212
34.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
125
59.0%
1 23
 
10.8%
2 12
 
5.7%
3 8
 
3.8%
4 7
 
3.3%
0 7
 
3.3%
9 7
 
3.3%
7 6
 
2.8%
5 5
 
2.4%
- 5
 
2.4%
Other values (3) 7
 
3.3%
Hangul
ValueCountFrequency (%)
임 44
10.9%
실 44
10.9%
전 31
 
7.7%
라 31
 
7.7%
북 31
 
7.7%
도 31
 
7.7%
군 31
 
7.7%
로 28
 
6.9%
수 24
 
5.9%
면 18
 
4.5%
Other values (16) 91
22.5%

전화번호
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-13T00:29:26.975238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique31 ?
Unique (%)100.0%

Sample

1st row063-640-8888
2nd row063-643-7575
3rd row063-644-1101
4th row063-642-0060
5th row063-642-0031
ValueCountFrequency (%)
063-640-8888 1
 
3.2%
063-642-5048 1
 
3.2%
063-642-7354 1
 
3.2%
063-642-1075 1
 
3.2%
063-644-2378 1
 
3.2%
063-644-1075 1
 
3.2%
063-643-0555 1
 
3.2%
063-644-8802 1
 
3.2%
063-642-6534 1
 
3.2%
063-642-3213 1
 
3.2%
Other values (21) 21
67.7%
2023-12-13T00:29:27.307554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 69
18.5%
- 62
16.7%
0 55
14.8%
4 42
11.3%
3 41
11.0%
2 30
8.1%
5 22
 
5.9%
8 18
 
4.8%
7 17
 
4.6%
1 13
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 310
83.3%
Dash Punctuation 62
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 69
22.3%
0 55
17.7%
4 42
13.5%
3 41
13.2%
2 30
9.7%
5 22
 
7.1%
8 18
 
5.8%
7 17
 
5.5%
1 13
 
4.2%
9 3
 
1.0%
Dash Punctuation
ValueCountFrequency (%)
- 62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 372
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 69
18.5%
- 62
16.7%
0 55
14.8%
4 42
11.3%
3 41
11.0%
2 30
8.1%
5 22
 
5.9%
8 18
 
4.8%
7 17
 
4.6%
1 13
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 372
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 69
18.5%
- 62
16.7%
0 55
14.8%
4 42
11.3%
3 41
11.0%
2 30
8.1%
5 22
 
5.9%
8 18
 
4.8%
7 17
 
4.6%
1 13
 
3.5%

진료과목
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)32.3%
Missing0
Missing (%)0.0%
Memory size380.0 B
가정의학과
9 
한방과
7 
치과
6 
내과
3 
정형외과,내과
1 
Other values (5)
5 

Length

Max length10
Median length7
Mean length3.8064516
Min length2

Unique

Unique6 ?
Unique (%)19.4%

Sample

1st row정형외과,내과
2nd row신경외과,재활의학과
3rd row한방내과
4th row정형외과
5th row가정의학과

Common Values

ValueCountFrequency (%)
가정의학과 9
29.0%
한방과 7
22.6%
치과 6
19.4%
내과 3
 
9.7%
정형외과,내과 1
 
3.2%
신경외과,재활의학과 1
 
3.2%
한방내과 1
 
3.2%
정형외과 1
 
3.2%
외과 1
 
3.2%
마취통증의학과 1
 
3.2%

Length

2023-12-13T00:29:27.757748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:29:27.897075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가정의학과 9
29.0%
한방과 7
22.6%
치과 6
19.4%
내과 3
 
9.7%
정형외과,내과 1
 
3.2%
신경외과,재활의학과 1
 
3.2%
한방내과 1
 
3.2%
정형외과 1
 
3.2%
외과 1
 
3.2%
마취통증의학과 1
 
3.2%

병상수
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size380.0 B
0
27 
103
 
1
70
 
1
86
 
1
29
 
1

Length

Max length3
Median length1
Mean length1.1612903
Min length1

Unique

Unique4 ?
Unique (%)12.9%

Sample

1st row103
2nd row70
3rd row86
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 27
87.1%
103 1
 
3.2%
70 1
 
3.2%
86 1
 
3.2%
29 1
 
3.2%

Length

2023-12-13T00:29:28.054904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:29:28.279731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 27
87.1%
103 1
 
3.2%
70 1
 
3.2%
86 1
 
3.2%
29 1
 
3.2%

휴무일
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
일요일, 공유일
31 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일요일, 공유일
2nd row일요일, 공유일
3rd row일요일, 공유일
4th row일요일, 공유일
5th row일요일, 공유일

Common Values

ValueCountFrequency (%)
일요일, 공유일 31
100.0%

Length

2023-12-13T00:29:28.467502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:29:28.604702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일요일 31
50.0%
공유일 31
50.0%

진료시간
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

층수
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)9.7%
Missing0
Missing (%)0.0%
Memory size380.0 B
1
17 
2
13 
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)3.2%

Sample

1st row4
2nd row2
3rd row2
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 17
54.8%
2 13
41.9%
4 1
 
3.2%

Length

2023-12-13T00:29:28.712399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:29:28.818682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 17
54.8%
2 13
41.9%
4 1
 
3.2%

Interactions

2023-12-13T00:29:24.954305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:29:28.897125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분기관명소재지전화번호진료과목병상수층수
순번1.0000.9811.0000.7821.0000.8850.4960.472
구분0.9811.0001.0000.7661.0001.0000.9410.765
기관명1.0001.0001.0001.0001.0001.0001.0001.000
소재지0.7820.7661.0001.0001.0000.9621.0000.952
전화번호1.0001.0001.0001.0001.0001.0001.0001.000
진료과목0.8851.0001.0000.9621.0001.0000.9840.843
병상수0.4960.9411.0001.0001.0000.9841.0000.723
층수0.4720.7651.0000.9521.0000.8430.7231.000
2023-12-13T00:29:29.027092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분진료과목층수병상수
구분1.0000.8990.7420.658
진료과목0.8991.0000.6510.736
층수0.7420.6511.0000.686
병상수0.6580.7360.6861.000
2023-12-13T00:29:29.121763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분진료과목병상수층수
순번1.0000.5730.3300.0000.000
구분0.5731.0000.8990.6580.742
진료과목0.3300.8991.0000.7360.651
병상수0.0000.6580.7361.0000.686
층수0.0000.7420.6510.6861.000

Missing values

2023-12-13T00:29:25.060340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:29:25.185827image/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병원의료법인 이루의료재단 임실병원전라북도 임실군 임실읍 운수로 15063-640-8888정형외과,내과103일요일, 공유일<NA>4
12요양병원의료법인예본의료재단 선요양병원전라북도 임실군 덕치면 사곡1길 9-8063-643-7575신경외과,재활의학과70일요일, 공유일<NA>2
23요양병원임실중앙요양병원전라북도 임실군 임실읍 봉황로 71063-644-1101한방내과86일요일, 공유일<NA>2
34의원기쁨정형외과의원전라북도 임실군 임실읍 운수로 34063-642-0060정형외과0일요일, 공유일<NA>1
45의원중앙의원전라북도 임실군 관촌면 사선로 40063-642-0031가정의학과0일요일, 공유일<NA>2
56의원푸른내과의원전라북도 임실군 임실읍 운수로 23063-642-7587내과0일요일, 공유일<NA>2
67의원열린가정의학과의원전라북도 임실군 관촌면 사선로 29063-642-6570가정의학과0일요일, 공유일<NA>1
78의원연세의원전라북도 임실군 오수면 삼일로 10063-642-7115가정의학과0일요일, 공유일<NA>1
89의원우리가정의원전라북도 임실군 임실읍 봉황10길 57063-642-0097가정의학과0일요일, 공유일<NA>1
910의원우리가정의학과의원전라북도 임실군 오수면 삼일로 11063-642-0975가정의학과0일요일, 공유일<NA>1
순번구분기관명소재지전화번호진료과목병상수휴무일진료시간층수
2122치과의원관촌치과의원전라북도 임실군 관촌면 사선로 29063-642-8275치과0일요일, 공유일<NA>2
2223치과의원상아치과의원전라북도 임실군 임실읍 운수로 25063-642-3213치과0일요일, 공유일<NA>2
2324치과의원오수치과의원전라북도 임실군 오수면 오수로 173063-642-6534치과0일요일, 공유일<NA>2
2425한의원오수대명한의원전라북도 임실군 오수면 오수로 162-1063-644-8802한방과0일요일, 공유일<NA>1
2526한의원원광한의원전라북도 임실군 오수면 삼일로 4063-643-0555한방과0일요일, 공유일<NA>2
2627한의원오수한의원전라북도 임실군 오수면 오수로 149-3063-644-1075한방과0일요일, 공유일<NA>1
2728한의원삼성한의원전라북도 임실군 임실읍 운수로 29063-644-2378한방과0일요일, 공유일<NA>1
2829한의원관촌한의원전라북도 임실군 관촌면 사선1길 17-1063-642-1075한방과0일요일, 공유일<NA>1
2930한의원허경회한의원전라북도 임실군 임실읍 운수로 20063-642-7354한방과0일요일, 공유일<NA>2
3031한의원남산당 한의원전라북도 임실군 관촌면 사선로 73063-642-0016한방과0일요일, 공유일<NA>1