Overview

Dataset statistics

Number of variables6
Number of observations260
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.6 KiB
Average record size in memory49.5 B

Variable types

Numeric1
Text3
Categorical2

Dataset

Description대구광역시 서구_병의원 현황_10/21/2021
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3054447&dataSetDetailId=30544471e99b43fe780a_201909291629&provdMethod=FILE

Alerts

기준일자 has constant value ""Constant
연번 is highly overall correlated with 의료기관종별High correlation
의료기관종별 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
의료기관명 has unique valuesUnique
의료기관전화번호 has unique valuesUnique

Reproduction

Analysis started2024-04-22 00:14:22.103676
Analysis finished2024-04-22 00:14:22.626336
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct260
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean130.5
Minimum1
Maximum260
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-04-22T09:14:22.711593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile13.95
Q165.75
median130.5
Q3195.25
95-th percentile247.05
Maximum260
Range259
Interquartile range (IQR)129.5

Descriptive statistics

Standard deviation75.199734
Coefficient of variation (CV)0.57624317
Kurtosis-1.2
Mean130.5
Median Absolute Deviation (MAD)65
Skewness0
Sum33930
Variance5655
MonotonicityStrictly increasing
2024-04-22T09:14:22.886962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
165 1
 
0.4%
167 1
 
0.4%
168 1
 
0.4%
169 1
 
0.4%
170 1
 
0.4%
171 1
 
0.4%
172 1
 
0.4%
173 1
 
0.4%
174 1
 
0.4%
Other values (250) 250
96.2%
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 (%)
260 1
0.4%
259 1
0.4%
258 1
0.4%
257 1
0.4%
256 1
0.4%
255 1
0.4%
254 1
0.4%
253 1
0.4%
252 1
0.4%
251 1
0.4%

의료기관명
Text

UNIQUE 

Distinct260
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2024-04-22T09:14:23.150104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length7.2230769
Min length4

Characters and Unicode

Total characters1878
Distinct characters236
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

Unique260 ?
Unique (%)100.0%

Sample

1st row대구의료원
2nd row참튼튼병원
3rd row제이병원
4th row새동산병원
5th row한신병원
ValueCountFrequency (%)
대구의료원 1
 
0.4%
청구치과의원 1
 
0.4%
중리치과의원 1
 
0.4%
윤성치과의원 1
 
0.4%
명광치과의원 1
 
0.4%
유현석치과의원 1
 
0.4%
박소현치과의원 1
 
0.4%
김해규치과의원 1
 
0.4%
윤동호치과의원 1
 
0.4%
성수치과의원 1
 
0.4%
Other values (251) 251
96.2%
2024-04-22T09:14:23.569377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
원 271
 
14.4%
의 264
 
14.1%
과 150
 
8.0%
한 83
 
4.4%
치 52
 
2.8%
대 38
 
2.0%
연 34
 
1.8%
합 32
 
1.7%
정 29
 
1.5%
내 28
 
1.5%
Other values (226) 897
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1869
99.5%
Decimal Number 4
 
0.2%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 271
 
14.5%
의 264
 
14.1%
과 150
 
8.0%
한 83
 
4.4%
치 52
 
2.8%
대 38
 
2.0%
연 34
 
1.8%
합 32
 
1.7%
정 29
 
1.6%
내 28
 
1.5%
Other values (220) 888
47.5%
Decimal Number
ValueCountFrequency (%)
0 2
50.0%
1 1
25.0%
4 1
25.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1869
99.5%
Common 9
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 271
 
14.5%
의 264
 
14.1%
과 150
 
8.0%
한 83
 
4.4%
치 52
 
2.8%
대 38
 
2.0%
연 34
 
1.8%
합 32
 
1.7%
정 29
 
1.6%
내 28
 
1.5%
Other values (220) 888
47.5%
Common
ValueCountFrequency (%)
( 2
22.2%
0 2
22.2%
) 2
22.2%
1 1
11.1%
4 1
11.1%
1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1869
99.5%
ASCII 9
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
원 271
 
14.5%
의 264
 
14.1%
과 150
 
8.0%
한 83
 
4.4%
치 52
 
2.8%
대 38
 
2.0%
연 34
 
1.8%
합 32
 
1.7%
정 29
 
1.6%
내 28
 
1.5%
Other values (220) 888
47.5%
ASCII
ValueCountFrequency (%)
( 2
22.2%
0 2
22.2%
) 2
22.2%
1 1
11.1%
4 1
11.1%
1
11.1%

의료기관종별
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
의원
119 
한의원
70 
치과의원
52 
일반요양병원
 
10
병원
 
7
Other values (2)
 
2

Length

Max length6
Median length4
Mean length2.8384615
Min length2

Unique

Unique2 ?
Unique (%)0.8%

Sample

1st row종합병원
2nd row병원
3rd row병원
4th row병원
5th row병원

Common Values

ValueCountFrequency (%)
의원 119
45.8%
한의원 70
26.9%
치과의원 52
20.0%
일반요양병원 10
 
3.8%
병원 7
 
2.7%
종합병원 1
 
0.4%
정신병원 1
 
0.4%

Length

2024-04-22T09:14:23.731072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:14:23.867583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의원 119
45.8%
한의원 70
26.9%
치과의원 52
20.0%
일반요양병원 10
 
3.8%
병원 7
 
2.7%
종합병원 1
 
0.4%
정신병원 1
 
0.4%

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

Distinct244
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2024-04-22T09:14:24.121320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length37
Mean length26.476923
Min length21

Characters and Unicode

Total characters6884
Distinct characters90
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

Unique229 ?
Unique (%)88.1%

Sample

1st row대구광역시 서구 평리로 157 (중리동)
2nd row대구광역시 서구 달구벌대로 1807, 지하1,1층일부~7층 (내당동)
3rd row대구광역시 서구 달구벌대로 1677 (내당동)
4th row대구광역시 서구 국채보상로 379 (비산동)
5th row대구광역시 서구 서대구로 60 (내당동)
ValueCountFrequency (%)
대구광역시 260
17.8%
서구 260
17.8%
평리동 86
 
5.9%
비산동 79
 
5.4%
내당동 74
 
5.1%
국채보상로 53
 
3.6%
2층 51
 
3.5%
달서로 39
 
2.7%
달구벌대로 37
 
2.5%
서대구로 28
 
1.9%
Other values (257) 497
33.9%
2024-04-22T09:14:24.509563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1204
17.5%
구 594
 
8.6%
대 350
 
5.1%
서 335
 
4.9%
동 269
 
3.9%
) 261
 
3.8%
( 261
 
3.8%
역 260
 
3.8%
시 260
 
3.8%
광 260
 
3.8%
Other values (80) 2830
41.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3931
57.1%
Space Separator 1204
 
17.5%
Decimal Number 1040
 
15.1%
Close Punctuation 261
 
3.8%
Open Punctuation 261
 
3.8%
Other Punctuation 160
 
2.3%
Dash Punctuation 18
 
0.3%
Math Symbol 8
 
0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 594
15.1%
대 350
 
8.9%
서 335
 
8.5%
동 269
 
6.8%
역 260
 
6.6%
시 260
 
6.6%
광 260
 
6.6%
로 260
 
6.6%
층 138
 
3.5%
리 112
 
2.8%
Other values (63) 1093
27.8%
Decimal Number
ValueCountFrequency (%)
1 216
20.8%
2 182
17.5%
3 147
14.1%
4 86
 
8.3%
6 78
 
7.5%
5 77
 
7.4%
8 76
 
7.3%
7 74
 
7.1%
0 60
 
5.8%
9 44
 
4.2%
Space Separator
ValueCountFrequency (%)
1204
100.0%
Close Punctuation
ValueCountFrequency (%)
) 261
100.0%
Open Punctuation
ValueCountFrequency (%)
( 261
100.0%
Other Punctuation
ValueCountFrequency (%)
, 160
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 8
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3931
57.1%
Common 2952
42.9%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 594
15.1%
대 350
 
8.9%
서 335
 
8.5%
동 269
 
6.8%
역 260
 
6.6%
시 260
 
6.6%
광 260
 
6.6%
로 260
 
6.6%
층 138
 
3.5%
리 112
 
2.8%
Other values (63) 1093
27.8%
Common
ValueCountFrequency (%)
1204
40.8%
) 261
 
8.8%
( 261
 
8.8%
1 216
 
7.3%
2 182
 
6.2%
, 160
 
5.4%
3 147
 
5.0%
4 86
 
2.9%
6 78
 
2.6%
5 77
 
2.6%
Other values (6) 280
 
9.5%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3931
57.1%
ASCII 2953
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1204
40.8%
) 261
 
8.8%
( 261
 
8.8%
1 216
 
7.3%
2 182
 
6.2%
, 160
 
5.4%
3 147
 
5.0%
4 86
 
2.9%
6 78
 
2.6%
5 77
 
2.6%
Other values (7) 281
 
9.5%
Hangul
ValueCountFrequency (%)
구 594
15.1%
대 350
 
8.9%
서 335
 
8.5%
동 269
 
6.8%
역 260
 
6.6%
시 260
 
6.6%
광 260
 
6.6%
로 260
 
6.6%
층 138
 
3.5%
리 112
 
2.8%
Other values (63) 1093
27.8%

의료기관전화번호
Text

UNIQUE 

Distinct260
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2024-04-22T09:14:24.759231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique260 ?
Unique (%)100.0%

Sample

1st row053-560-7575
2nd row053-552-9400
3rd row053-571-6000
4th row053-720-0365
5th row053-565-9200
ValueCountFrequency (%)
053-560-7575 1
 
0.4%
053-359-1334 1
 
0.4%
053-552-3709 1
 
0.4%
053-561-0275 1
 
0.4%
053-554-2965 1
 
0.4%
053-566-8664 1
 
0.4%
053-558-7842 1
 
0.4%
053-566-0600 1
 
0.4%
053-565-2343 1
 
0.4%
053-562-7775 1
 
0.4%
Other values (250) 250
96.2%
2024-04-22T09:14:25.142740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 756
24.2%
- 520
16.7%
0 432
13.8%
3 402
12.9%
2 216
 
6.9%
7 197
 
6.3%
6 176
 
5.6%
1 146
 
4.7%
8 134
 
4.3%
4 71
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2600
83.3%
Dash Punctuation 520
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 756
29.1%
0 432
16.6%
3 402
15.5%
2 216
 
8.3%
7 197
 
7.6%
6 176
 
6.8%
1 146
 
5.6%
8 134
 
5.2%
4 71
 
2.7%
9 70
 
2.7%
Dash Punctuation
ValueCountFrequency (%)
- 520
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3120
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 756
24.2%
- 520
16.7%
0 432
13.8%
3 402
12.9%
2 216
 
6.9%
7 197
 
6.3%
6 176
 
5.6%
1 146
 
4.7%
8 134
 
4.3%
4 71
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3120
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 756
24.2%
- 520
16.7%
0 432
13.8%
3 402
12.9%
2 216
 
6.9%
7 197
 
6.3%
6 176
 
5.6%
1 146
 
4.7%
8 134
 
4.3%
4 71
 
2.3%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2021-10-21
260 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-10-21
2nd row2021-10-21
3rd row2021-10-21
4th row2021-10-21
5th row2021-10-21

Common Values

ValueCountFrequency (%)
2021-10-21 260
100.0%

Length

2024-04-22T09:14:25.278739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-22T09:14:25.372561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-10-21 260
100.0%

Interactions

2024-04-22T09:14:22.350206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-22T09:14:25.440120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번의료기관종별
연번1.0000.822
의료기관종별0.8221.000
2024-04-22T09:14:25.537633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번의료기관종별
연번1.0000.604
의료기관종별0.6041.000

Missing values

2024-04-22T09:14:22.467107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-22T09:14:22.582595image/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대구의료원종합병원대구광역시 서구 평리로 157 (중리동)053-560-75752021-10-21
12참튼튼병원병원대구광역시 서구 달구벌대로 1807, 지하1,1층일부~7층 (내당동)053-552-94002021-10-21
23제이병원병원대구광역시 서구 달구벌대로 1677 (내당동)053-571-60002021-10-21
34새동산병원병원대구광역시 서구 국채보상로 379 (비산동)053-720-03652021-10-21
45한신병원병원대구광역시 서구 서대구로 60 (내당동)053-565-92002021-10-21
56대명의료재단서대구병원병원대구광역시 서구 국채보상로 200 (평리동)053-558-58002021-10-21
67세민병원병원대구광역시 서구 국채보상로 302 (평리동, 세민병원)053-521-95002021-10-21
78열린큰병원병원대구광역시 서구 달구벌대로 1877 (내당동, 열린큰병원)053-552-11192021-10-21
89곽호순병원정신병원대구광역시 서구 통학로 31 (내당동)053-572-77702021-10-21
910장수효요양병원일반요양병원대구광역시 서구 평리로 380 (내당동)053-285-11002021-10-21
연번의료기관명의료기관종별의료기관주소(도로명)의료기관전화번호기준일자
250251금비한의원한의원대구광역시 서구 평리로 375, 1층 (평리동)053-555-56202021-10-21
251252동덕한의원한의원대구광역시 서구 서대구로 349, 3층 (비산동)053-354-03112021-10-21
252253혜민한의원한의원대구광역시 서구 국채보상로 230, 1층 (평리동)053-557-00242021-10-21
253254동광한의원한의원대구광역시 서구 국채보상로 207 (평리동)053-555-12022021-10-21
254255경희보인한의원한의원대구광역시 서구 국채보상로 293, 2층 (평리동)053-557-54002021-10-21
255256광덕한의원한의원대구광역시 서구 달서로 100-1 (비산동)053-571-23392021-10-21
256257영신한의원한의원대구광역시 서구 고성로 25 (원대동3가)053-353-33102021-10-21
257258조한의원한의원대구광역시 서구 국채보상로 375, 2층 (비산동)053-558-12122021-10-21
258259동화한의원한의원대구광역시 서구 달서로 201, 2층 (비산동)053-553-37202021-10-21
259260광제한의원한의원대구광역시 서구 평리로 308 (내당동)053-552-56562021-10-21