Overview

Dataset statistics

Number of variables7
Number of observations86
Missing cells28
Missing cells (%)4.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory57.5 B

Variable types

Unsupported1
Categorical2
Text4

Dataset

Description정신건강의학과, 요양병원, 정신건강복지센터 등 상호명, 주소, 전화번호 등의 정보 등의 정보를 제공하고 있습니다.
Author충청남도
URLhttps://www.data.go.kr/data/15103398/fileData.do

Alerts

Unnamed: 2 is highly imbalanced (56.1%)Imbalance
Unnamed: 3 has 1 (1.2%) missing valuesMissing
Unnamed: 4 has 1 (1.2%) missing valuesMissing
Unnamed: 5 has 1 (1.2%) missing valuesMissing
Unnamed: 6 has 25 (29.1%) missing valuesMissing
의료기관 현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 11:27:59.222197
Analysis finished2024-03-14 11:28:01.164484
Duration1.94 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

의료기관 현황
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size816.0 B

Unnamed: 1
Categorical

Distinct18
Distinct (%)20.9%
Missing0
Missing (%)0.0%
Memory size816.0 B
천안시 동남구
12 
공주시
11 
논산시
11 
천안시 서북구
11 
아산시
8 
Other values (13)
33 

Length

Max length7
Median length3
Mean length4.0697674
Min length2

Unique

Unique6 ?
Unique (%)7.0%

Sample

1st row<NA>
2nd row시군
3rd row천안시 동남구
4th row천안시 동남구
5th row천안시 동남구

Common Values

ValueCountFrequency (%)
천안시 동남구 12
14.0%
공주시 11
12.8%
논산시 11
12.8%
천안시 서북구 11
12.8%
아산시 8
9.3%
홍성군 5
5.8%
부여군 5
5.8%
서천군 5
5.8%
당진시 4
 
4.7%
금산군 3
 
3.5%
Other values (8) 11
12.8%

Length

2024-03-14T20:28:01.392920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
천안시 23
21.1%
동남구 12
11.0%
공주시 11
10.1%
논산시 11
10.1%
서북구 11
10.1%
아산시 8
 
7.3%
홍성군 5
 
4.6%
부여군 5
 
4.6%
서천군 5
 
4.6%
당진시 4
 
3.7%
Other values (9) 14
12.8%

Unnamed: 2
Categorical

IMBALANCE 

Distinct5
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size816.0 B
요양병원
66 
정신병원
16 
노인병원
 
2
<NA>
 
1
종별
 
1

Length

Max length4
Median length4
Mean length3.9767442
Min length2

Unique

Unique2 ?
Unique (%)2.3%

Sample

1st row<NA>
2nd row종별
3rd row노인병원
4th row요양병원
5th row요양병원

Common Values

ValueCountFrequency (%)
요양병원 66
76.7%
정신병원 16
 
18.6%
노인병원 2
 
2.3%
<NA> 1
 
1.2%
종별 1
 
1.2%

Length

2024-03-14T20:28:01.805435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:28:02.170829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
요양병원 66
76.7%
정신병원 16
 
18.6%
노인병원 2
 
2.3%
na 1
 
1.2%
종별 1
 
1.2%

Unnamed: 3
Text

MISSING 

Distinct84
Distinct (%)98.8%
Missing1
Missing (%)1.2%
Memory size816.0 B
2024-03-14T20:28:02.915924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length9.4588235
Min length4

Characters and Unicode

Total characters804
Distinct characters144
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

Unique83 ?
Unique (%)97.6%

Sample

1st row의료기관명
2nd row천안시립노인전문병원
3rd row메디움천안요양병원
4th row로고스요양병원
5th row선한이웃요양병원
ValueCountFrequency (%)
의료법인 9
 
8.3%
현대요양병원 2
 
1.9%
금산효사랑요양병원 1
 
0.9%
당진효제요양병원 1
 
0.9%
논산사랑요양병원 1
 
0.9%
수청요양병원 1
 
0.9%
당진솔담요양병원 1
 
0.9%
계룡장수요양병원 1
 
0.9%
성지하임병원 1
 
0.9%
논산시립노인전문병원 1
 
0.9%
Other values (89) 89
82.4%
2024-03-14T20:28:04.150131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
병 84
 
10.4%
원 84
 
10.4%
양 66
 
8.2%
요 64
 
8.0%
료 36
 
4.5%
의 36
 
4.5%
24
 
3.0%
인 23
 
2.9%
단 18
 
2.2%
재 18
 
2.2%
Other values (134) 351
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 780
97.0%
Space Separator 24
 
3.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
병 84
 
10.8%
원 84
 
10.8%
양 66
 
8.5%
요 64
 
8.2%
료 36
 
4.6%
의 36
 
4.6%
인 23
 
2.9%
단 18
 
2.3%
재 18
 
2.3%
법 17
 
2.2%
Other values (133) 334
42.8%
Space Separator
ValueCountFrequency (%)
24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 780
97.0%
Common 24
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
병 84
 
10.8%
원 84
 
10.8%
양 66
 
8.5%
요 64
 
8.2%
료 36
 
4.6%
의 36
 
4.6%
인 23
 
2.9%
단 18
 
2.3%
재 18
 
2.3%
법 17
 
2.2%
Other values (133) 334
42.8%
Common
ValueCountFrequency (%)
24
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 780
97.0%
ASCII 24
 
3.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
병 84
 
10.8%
원 84
 
10.8%
양 66
 
8.5%
요 64
 
8.2%
료 36
 
4.6%
의 36
 
4.6%
인 23
 
2.9%
단 18
 
2.3%
재 18
 
2.3%
법 17
 
2.2%
Other values (133) 334
42.8%
ASCII
ValueCountFrequency (%)
24
100.0%

Unnamed: 4
Text

MISSING 

Distinct85
Distinct (%)100.0%
Missing1
Missing (%)1.2%
Memory size816.0 B
2024-03-14T20:28:05.271186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length37
Mean length24.564706
Min length11

Characters and Unicode

Total characters2088
Distinct characters189
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

Unique85 ?
Unique (%)100.0%

Sample

1st row의료기관주소(도로명)
2nd row충청남도 천안시 동남구 목천읍 삼방로 735 (천안시립노인전문병원)
3rd row충청남도 천안시 동남구 유량로 180 (유량동, 메디움천안요양병원)
4th row충청남도 천안시 동남구 청수로 123-11(구성동)
5th row충청남도 천안시 동남구 정골2길 91 (구성동)
ValueCountFrequency (%)
충청남도 79
 
17.2%
천안시 23
 
5.0%
동남구 12
 
2.6%
서북구 11
 
2.4%
공주시 11
 
2.4%
논산시 11
 
2.4%
아산시 8
 
1.7%
홍성군 5
 
1.1%
서천군 5
 
1.1%
부여군 5
 
1.1%
Other values (244) 288
62.9%
2024-03-14T20:28:06.852728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
373
 
17.9%
남 98
 
4.7%
충 88
 
4.2%
청 87
 
4.2%
도 84
 
4.0%
시 65
 
3.1%
1 64
 
3.1%
로 56
 
2.7%
동 51
 
2.4%
천 49
 
2.3%
Other values (179) 1073
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1306
62.5%
Space Separator 373
 
17.9%
Decimal Number 293
 
14.0%
Close Punctuation 39
 
1.9%
Open Punctuation 39
 
1.9%
Other Punctuation 18
 
0.9%
Dash Punctuation 16
 
0.8%
Math Symbol 3
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 98
 
7.5%
충 88
 
6.7%
청 87
 
6.7%
도 84
 
6.4%
시 65
 
5.0%
로 56
 
4.3%
동 51
 
3.9%
천 49
 
3.8%
길 38
 
2.9%
산 38
 
2.9%
Other values (162) 652
49.9%
Decimal Number
ValueCountFrequency (%)
1 64
21.8%
2 42
14.3%
3 36
12.3%
7 28
9.6%
5 26
8.9%
4 26
8.9%
8 22
 
7.5%
6 17
 
5.8%
9 16
 
5.5%
0 16
 
5.5%
Space Separator
ValueCountFrequency (%)
373
100.0%
Close Punctuation
ValueCountFrequency (%)
) 39
100.0%
Open Punctuation
ValueCountFrequency (%)
( 39
100.0%
Other Punctuation
ValueCountFrequency (%)
, 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1306
62.5%
Common 781
37.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 98
 
7.5%
충 88
 
6.7%
청 87
 
6.7%
도 84
 
6.4%
시 65
 
5.0%
로 56
 
4.3%
동 51
 
3.9%
천 49
 
3.8%
길 38
 
2.9%
산 38
 
2.9%
Other values (162) 652
49.9%
Common
ValueCountFrequency (%)
373
47.8%
1 64
 
8.2%
2 42
 
5.4%
) 39
 
5.0%
( 39
 
5.0%
3 36
 
4.6%
7 28
 
3.6%
5 26
 
3.3%
4 26
 
3.3%
8 22
 
2.8%
Other values (6) 86
 
11.0%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1306
62.5%
ASCII 782
37.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
373
47.7%
1 64
 
8.2%
2 42
 
5.4%
) 39
 
5.0%
( 39
 
5.0%
3 36
 
4.6%
7 28
 
3.6%
5 26
 
3.3%
4 26
 
3.3%
8 22
 
2.8%
Other values (7) 87
 
11.1%
Hangul
ValueCountFrequency (%)
남 98
 
7.5%
충 88
 
6.7%
청 87
 
6.7%
도 84
 
6.4%
시 65
 
5.0%
로 56
 
4.3%
동 51
 
3.9%
천 49
 
3.8%
길 38
 
2.9%
산 38
 
2.9%
Other values (162) 652
49.9%

Unnamed: 5
Text

MISSING 

Distinct85
Distinct (%)100.0%
Missing1
Missing (%)1.2%
Memory size816.0 B
2024-03-14T20:28:08.004979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.905882
Min length4

Characters and Unicode

Total characters1012
Distinct characters16
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

Unique85 ?
Unique (%)100.0%

Sample

1st row전화번호
2nd row041-521-1114
3rd row041-413-7100
4th row041-410-2100
5th row041-564-5555
ValueCountFrequency (%)
041-552-0700 1
 
1.2%
041-834-5114 1
 
1.2%
041-355-8600 1
 
1.2%
041-351-5000 1
 
1.2%
041-355-2002 1
 
1.2%
042-840-7676 1
 
1.2%
041-734-9100 1
 
1.2%
041-734-9911 1
 
1.2%
041-741-5552 1
 
1.2%
041-745-6771 1
 
1.2%
Other values (75) 75
88.2%
2024-03-14T20:28:09.476321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 175
17.3%
- 167
16.5%
1 153
15.1%
4 130
12.8%
5 99
9.8%
7 64
 
6.3%
2 51
 
5.0%
3 50
 
4.9%
8 43
 
4.2%
6 41
 
4.1%
Other values (6) 39
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 840
83.0%
Dash Punctuation 167
 
16.5%
Other Letter 4
 
0.4%
Close Punctuation 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 175
20.8%
1 153
18.2%
4 130
15.5%
5 99
11.8%
7 64
 
7.6%
2 51
 
6.1%
3 50
 
6.0%
8 43
 
5.1%
6 41
 
4.9%
9 34
 
4.0%
Other Letter
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 167
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1008
99.6%
Hangul 4
 
0.4%

Most frequent character per script

Common
ValueCountFrequency (%)
0 175
17.4%
- 167
16.6%
1 153
15.2%
4 130
12.9%
5 99
9.8%
7 64
 
6.3%
2 51
 
5.1%
3 50
 
5.0%
8 43
 
4.3%
6 41
 
4.1%
Other values (2) 35
 
3.5%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1008
99.6%
Hangul 4
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 175
17.4%
- 167
16.6%
1 153
15.2%
4 130
12.9%
5 99
9.8%
7 64
 
6.3%
2 51
 
5.1%
3 50
 
5.0%
8 43
 
4.3%
6 41
 
4.1%
Other values (2) 35
 
3.5%
Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Unnamed: 6
Text

MISSING 

Distinct56
Distinct (%)91.8%
Missing25
Missing (%)29.1%
Memory size816.0 B
2024-03-14T20:28:10.287692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length10.803279
Min length1

Characters and Unicode

Total characters659
Distinct characters15
Distinct categories3 ?
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팩스번호
2nd row041-521-1239
3rd row041-413-7111
4th row041-410-2101
5th row041-564-5559
ValueCountFrequency (%)
6
 
9.8%
041-935-1169 1
 
1.6%
041-351-5003 1
 
1.6%
041-363-3329 1
 
1.6%
041-543-0047 1
 
1.6%
041-541-6500 1
 
1.6%
041-541-3680 1
 
1.6%
041-548-9855 1
 
1.6%
041-666-5667 1
 
1.6%
041-745-1503 1
 
1.6%
Other values (46) 46
75.4%
2024-03-14T20:28:11.492213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 114
17.3%
0 100
15.2%
1 98
14.9%
4 83
12.6%
5 64
9.7%
3 46
7.0%
6 35
 
5.3%
7 31
 
4.7%
2 30
 
4.6%
9 28
 
4.2%
Other values (5) 30
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 541
82.1%
Dash Punctuation 114
 
17.3%
Other Letter 4
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 100
18.5%
1 98
18.1%
4 83
15.3%
5 64
11.8%
3 46
8.5%
6 35
 
6.5%
7 31
 
5.7%
2 30
 
5.5%
9 28
 
5.2%
8 26
 
4.8%
Other Letter
ValueCountFrequency (%)
팩 1
25.0%
스 1
25.0%
번 1
25.0%
호 1
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 114
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 655
99.4%
Hangul 4
 
0.6%

Most frequent character per script

Common
ValueCountFrequency (%)
- 114
17.4%
0 100
15.3%
1 98
15.0%
4 83
12.7%
5 64
9.8%
3 46
7.0%
6 35
 
5.3%
7 31
 
4.7%
2 30
 
4.6%
9 28
 
4.3%
Hangul
ValueCountFrequency (%)
팩 1
25.0%
스 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 655
99.4%
Hangul 4
 
0.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 114
17.4%
0 100
15.3%
1 98
15.0%
4 83
12.7%
5 64
9.8%
3 46
7.0%
6 35
 
5.3%
7 31
 
4.7%
2 30
 
4.6%
9 28
 
4.3%
Hangul
ValueCountFrequency (%)
팩 1
25.0%
스 1
25.0%
번 1
25.0%
호 1
25.0%

Correlations

2024-03-14T20:28:11.760127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
Unnamed: 11.0000.7640.0001.0001.0000.986
Unnamed: 20.7641.0001.0001.0001.0000.969
Unnamed: 30.0001.0001.0001.0001.0000.991
Unnamed: 41.0001.0001.0001.0001.0001.000
Unnamed: 51.0001.0001.0001.0001.0001.000
Unnamed: 60.9860.9690.9911.0001.0001.000
2024-03-14T20:28:12.026793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2
Unnamed: 11.0000.497
Unnamed: 20.4971.000
2024-03-14T20:28:12.261870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2
Unnamed: 11.0000.497
Unnamed: 20.4971.000

Missing values

2024-03-14T20:28:00.026000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:28:00.411146image/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.
2024-03-14T20:28:00.963059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

의료기관 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
0(기준 : 2023.06.30.)<NA><NA><NA><NA><NA><NA>
1순번시군종별의료기관명의료기관주소(도로명)전화번호팩스번호
21천안시 동남구노인병원천안시립노인전문병원충청남도 천안시 동남구 목천읍 삼방로 735 (천안시립노인전문병원)041-521-1114041-521-1239
32천안시 동남구요양병원메디움천안요양병원충청남도 천안시 동남구 유량로 180 (유량동, 메디움천안요양병원)041-413-7100041-413-7111
43천안시 동남구요양병원로고스요양병원충청남도 천안시 동남구 청수로 123-11(구성동)041-410-2100041-410-2101
54천안시 동남구요양병원선한이웃요양병원충청남도 천안시 동남구 정골2길 91 (구성동)041-564-5555041-564-5559
65천안시 동남구요양병원의료법인 백석의료재단 한사랑요양병원충청남도 천안시 동남구 대흥로 228 (대흥동, 삼영빌딩)041-556-7781041-556-7782
76천안시 동남구요양병원가야요양병원충청남도 천안시 동남구 영성로 7 (영성동, 가야요양병원)041-558-1000041-553-0050
87천안시 동남구요양병원의료법인세온의료재단브라운요양병원충청남도 천안시 동남구 목천읍 충절로 794041-553-1234041-565-4411
98천안시 동남구요양병원천안요양병원충청남도 천안시 동남구 삼룡천3길 10 (구성동, 이라의료재단 천안병원)041-569-5533041-569-5511
의료기관 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
7675서천군정신병원서천사랑병원충청남도 서천군 판교면 대백제로 2078041-951-8114<NA>
7776청양군요양병원의료법인 연훈의료재단 청양훈요양병원충청남도 청양군 청양읍 칠갑산로 157041-943-8114041-943-8117
7877청양군요양병원의료법인 가온의료재단 청양요양병원충청남도 청양군 청양읍 중앙로 151041-944-1277041-944-1266
7978홍성군요양병원홍주요양병원충청남도 홍성군 홍성읍 백월로 130041-632-2332041-632-2337
8079홍성군요양병원장수요양병원충청남도 홍성군 은하면 구성남로 381041-642-0001041-642-2004
8180홍성군요양병원홍성요양병원충청남도 홍성군 홍성읍 조양로 143번길 11041-631-2757041-633-1517
8281홍성군정신병원홍성한국병원충청남도 홍성군 홍성읍 대내길 97041-634-2088070-8610-0929
8382홍성군정신병원신동환병원충청남도 홍성군 홍성읍 홍성천길 214, 두리프라자 4-6층041-631-7541041-631-7542
8483예산군요양병원신요양병원충청남도 예산군 예산읍 마상길 9041-338-9119<NA>
8584태안군요양병원현대요양병원충남 태안군 태안읍 환동로 31041-672-2900041-673-2900