Overview

Dataset statistics

Number of variables4
Number of observations28
Missing cells3
Missing cells (%)2.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory36.7 B

Variable types

Categorical1
Text3

Dataset

Description순창군 병.의원 현황
Author전라북도 순창군
URLhttps://www.data.go.kr/data/15055220/fileData.do

Alerts

Unnamed: 1 has 1 (3.6%) missing valuesMissing
Unnamed: 2 has 1 (3.6%) missing valuesMissing
Unnamed: 3 has 1 (3.6%) missing valuesMissing

Reproduction

Analysis started2023-12-12 17:03:16.872150
Analysis finished2023-12-12 17:03:17.350695
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct7
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
의원
14 
치과
한의원
<NA>
 
1
구분
 
1
Other values (2)

Length

Max length4
Median length2
Mean length2.3214286
Min length2

Unique

Unique4 ?
Unique (%)14.3%

Sample

1st row<NA>
2nd row구분
3rd row병원
4th row요양병원
5th row의원

Common Values

ValueCountFrequency (%)
의원 14
50.0%
치과 5
 
17.9%
한의원 5
 
17.9%
<NA> 1
 
3.6%
구분 1
 
3.6%
병원 1
 
3.6%
요양병원 1
 
3.6%

Length

2023-12-13T02:03:17.433025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:03:17.594268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의원 14
50.0%
치과 5
 
17.9%
한의원 5
 
17.9%
na 1
 
3.6%
구분 1
 
3.6%
병원 1
 
3.6%
요양병원 1
 
3.6%

Unnamed: 1
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:03:17.797888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.3333333
Min length3

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row업소명
2nd row희망병원
3rd row순창요양병원
4th row대동의원
5th row문희식내과의원
ValueCountFrequency (%)
업소명 1
 
3.7%
박의원 1
 
3.7%
최한의원 1
 
3.7%
원광한의원 1
 
3.7%
은혜한의원 1
 
3.7%
누가한의원 1
 
3.7%
제일치과의원 1
 
3.7%
명작치과의원 1
 
3.7%
순창치과의원 1
 
3.7%
권치과의원 1
 
3.7%
Other values (17) 17
63.0%
2023-12-13T02:03:18.101498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
18.8%
25
17.4%
11
 
7.6%
7
 
4.9%
6
 
4.2%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (47) 55
38.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 144
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
27
18.8%
25
17.4%
11
 
7.6%
7
 
4.9%
6
 
4.2%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (47) 55
38.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 144
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
27
18.8%
25
17.4%
11
 
7.6%
7
 
4.9%
6
 
4.2%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (47) 55
38.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 144
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
27
18.8%
25
17.4%
11
 
7.6%
7
 
4.9%
6
 
4.2%
3
 
2.1%
3
 
2.1%
3
 
2.1%
2
 
1.4%
2
 
1.4%
Other values (47) 55
38.2%

Unnamed: 2
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:03:18.305751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length13.62963
Min length4

Characters and Unicode

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

Unique27 ?
Unique (%)100.0%

Sample

1st row전화번호
2nd row 063-652-2612
3rd row 063-650-8000
4th row 063-653-2828
5th row 063-653-0952
ValueCountFrequency (%)
전화번호 1
 
3.7%
063-653-8875 1
 
3.7%
063-653-1079 1
 
3.7%
063-653-8275 1
 
3.7%
063-652-6624 1
 
3.7%
063-653-8434 1
 
3.7%
063-652-7582 1
 
3.7%
063-653-2875 1
 
3.7%
063-653-7527 1
 
3.7%
063-652-7728 1
 
3.7%
Other values (17) 17
63.0%
2023-12-13T02:03:18.619691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 58
15.8%
3 54
14.7%
52
14.1%
- 52
14.1%
0 41
11.1%
5 39
10.6%
2 20
 
5.4%
8 14
 
3.8%
7 13
 
3.5%
1 9
 
2.4%
Other values (6) 16
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 260
70.7%
Space Separator 52
 
14.1%
Dash Punctuation 52
 
14.1%
Other Letter 4
 
1.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 58
22.3%
3 54
20.8%
0 41
15.8%
5 39
15.0%
2 20
 
7.7%
8 14
 
5.4%
7 13
 
5.0%
1 9
 
3.5%
4 7
 
2.7%
9 5
 
1.9%
Other Letter
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
Space Separator
ValueCountFrequency (%)
52
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 364
98.9%
Hangul 4
 
1.1%

Most frequent character per script

Common
ValueCountFrequency (%)
6 58
15.9%
3 54
14.8%
52
14.3%
- 52
14.3%
0 41
11.3%
5 39
10.7%
2 20
 
5.5%
8 14
 
3.8%
7 13
 
3.6%
1 9
 
2.5%
Other values (2) 12
 
3.3%
Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 364
98.9%
Hangul 4
 
1.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 58
15.9%
3 54
14.8%
52
14.3%
- 52
14.3%
0 41
11.3%
5 39
10.7%
2 20
 
5.5%
8 14
 
3.8%
7 13
 
3.6%
1 9
 
2.5%
Other values (2) 12
 
3.3%
Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Unnamed: 3
Text

MISSING 

Distinct26
Distinct (%)96.3%
Missing1
Missing (%)3.6%
Memory size356.0 B
2023-12-13T02:03:18.809077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length13.222222
Min length3

Characters and Unicode

Total characters357
Distinct characters35
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

Unique25 ?
Unique (%)92.6%

Sample

1st row소재지
2nd row 순창읍 장류로 347
3rd row 순창읍 순창로 105
4th row 순창읍 순창5길 15
5th row 순창읍 장류로 333
ValueCountFrequency (%)
순창읍 23
29.1%
장류로 7
 
8.9%
옥천로 7
 
8.9%
순창로 5
 
6.3%
순창9길 2
 
2.5%
복흥면 2
 
2.5%
364-1 2
 
2.5%
360 1
 
1.3%
12-11 1
 
1.3%
380 1
 
1.3%
Other values (28) 28
35.4%
2023-12-13T02:03:19.171276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
104
29.1%
31
 
8.7%
31
 
8.7%
23
 
6.4%
22
 
6.2%
1 18
 
5.0%
3 14
 
3.9%
2 13
 
3.6%
- 10
 
2.8%
5 8
 
2.2%
Other values (25) 83
23.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 159
44.5%
Space Separator 104
29.1%
Decimal Number 84
23.5%
Dash Punctuation 10
 
2.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
31
19.5%
31
19.5%
23
14.5%
22
13.8%
7
 
4.4%
7
 
4.4%
7
 
4.4%
7
 
4.4%
4
 
2.5%
3
 
1.9%
Other values (13) 17
10.7%
Decimal Number
ValueCountFrequency (%)
1 18
21.4%
3 14
16.7%
2 13
15.5%
5 8
9.5%
4 8
9.5%
0 7
 
8.3%
6 7
 
8.3%
9 6
 
7.1%
8 2
 
2.4%
7 1
 
1.2%
Space Separator
ValueCountFrequency (%)
104
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 198
55.5%
Hangul 159
44.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
31
19.5%
31
19.5%
23
14.5%
22
13.8%
7
 
4.4%
7
 
4.4%
7
 
4.4%
7
 
4.4%
4
 
2.5%
3
 
1.9%
Other values (13) 17
10.7%
Common
ValueCountFrequency (%)
104
52.5%
1 18
 
9.1%
3 14
 
7.1%
2 13
 
6.6%
- 10
 
5.1%
5 8
 
4.0%
4 8
 
4.0%
0 7
 
3.5%
6 7
 
3.5%
9 6
 
3.0%
Other values (2) 3
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 198
55.5%
Hangul 159
44.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
104
52.5%
1 18
 
9.1%
3 14
 
7.1%
2 13
 
6.6%
- 10
 
5.1%
5 8
 
4.0%
4 8
 
4.0%
0 7
 
3.5%
6 7
 
3.5%
9 6
 
3.0%
Other values (2) 3
 
1.5%
Hangul
ValueCountFrequency (%)
31
19.5%
31
19.5%
23
14.5%
22
13.8%
7
 
4.4%
7
 
4.4%
7
 
4.4%
7
 
4.4%
4
 
2.5%
3
 
1.9%
Other values (13) 17
10.7%

Correlations

2023-12-13T02:03:19.295066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순창군 병.의원 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
순창군 병.의원 현황(2014. 9월 현재)1.0001.0001.0000.898
Unnamed: 11.0001.0001.0001.000
Unnamed: 21.0001.0001.0001.000
Unnamed: 30.8981.0001.0001.000

Missing values

2023-12-13T02:03:17.084854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:03:17.179718image/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.
2023-12-13T02:03:17.289403image/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

순창군 병.의원 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
0<NA><NA><NA><NA>
1구분업소명전화번호소재지
2병원희망병원063-652-2612순창읍 장류로 347
3요양병원순창요양병원063-650-8000순창읍 순창로 105
4의원대동의원063-653-2828순창읍 순창5길 15
5의원문희식내과의원063-653-0952순창읍 장류로 333
6의원중앙의원063-653-5331순창읍 옥천로 52
7의원한국의원063-653-7001순창읍 순창로 230-3
8의원류재규내과의원063-653-5885순창읍 순창로 225-10
9의원문재연정형외과의원063-653-5300순창읍 옥천로 58
순창군 병.의원 현황(2014. 9월 현재)Unnamed: 1Unnamed: 2Unnamed: 3
18치과송치과의원063-653-2043순창읍 옥천로 49
19치과권치과의원063-652-7728순창읍 옥천로 39
20치과순창치과의원063-653-7527순창읍 장류로 364-1
21치과명작치과의원063-653-2875순창읍 장류로 349
22치과제일치과의원063-652-7582순창읍 장류로 380
23한의원누가한의원063-653-8434순창읍 순창9길 12-11
24한의원은혜한의원063-652-6624순창읍 장류로 364-1
25한의원원광한의원063-653-8275순창읍 장류로 360
26한의원최한의원063-653-1079순창읍 옥천로 45
27한의원순창한의원063-653-1075순창읍 순창로 236