Overview

Dataset statistics

Number of variables7
Number of observations668
Missing cells672
Missing cells (%)14.4%
Duplicate rows12
Duplicate rows (%)1.8%
Total size in memory37.3 KiB
Average record size in memory57.2 B

Variable types

Unsupported2
Text3
Categorical2

Dataset

Description2016제세동기설치내역공공데이터
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202016

Alerts

Dataset has 12 (1.8%) duplicate rowsDuplicates
Unnamed: 5 is highly overall correlated with Unnamed: 6High correlation
Unnamed: 6 is highly overall correlated with Unnamed: 5High correlation
Unnamed: 0 has 668 (100.0%) missing valuesMissing
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
2016년도 제세동기 설치 현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 00:46:25.583893
Analysis finished2024-03-14 00:46:26.345093
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing668
Missing (%)100.0%
Memory size6.0 KiB

2016년도 제세동기 설치 현황
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.1%
Memory size5.3 KiB

Unnamed: 2
Text

Distinct591
Distinct (%)88.6%
Missing1
Missing (%)0.1%
Memory size5.3 KiB
2024-03-14T09:46:26.483196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length19
Mean length8.6926537
Min length3

Characters and Unicode

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

Unique

Unique552 ?
Unique (%)82.8%

Sample

1st row설치기관명
2nd row고수면내창보건진료소
3rd row고수면보건지소
4th row고창읍백양보건진료소
5th row고창읍덕정보건진료소
ValueCountFrequency (%)
정읍시보건소 13
 
1.8%
익산지사 8
 
1.1%
주)케이티링커스 8
 
1.1%
익산역 7
 
1.0%
보건지소 7
 
1.0%
전주지사 6
 
0.8%
군산시보건소 5
 
0.7%
케이티링거스(주 5
 
0.7%
무주군보건의료원 4
 
0.6%
공설운동장 3
 
0.4%
Other values (604) 651
90.8%
2024-03-14T09:46:26.770957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
소 530
 
9.1%
보 427
 
7.4%
건 427
 
7.4%
진 276
 
4.8%
료 250
 
4.3%
지 202
 
3.5%
1 176
 
3.0%
전 127
 
2.2%
산 123
 
2.1%
) 113
 
1.9%
Other values (280) 3147
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5220
90.0%
Decimal Number 287
 
4.9%
Close Punctuation 113
 
1.9%
Open Punctuation 105
 
1.8%
Space Separator 50
 
0.9%
Uppercase Letter 15
 
0.3%
Other Punctuation 5
 
0.1%
Dash Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
소 530
 
10.2%
보 427
 
8.2%
건 427
 
8.2%
진 276
 
5.3%
료 250
 
4.8%
지 202
 
3.9%
전 127
 
2.4%
산 123
 
2.4%
서 101
 
1.9%
안 100
 
1.9%
Other values (258) 2657
50.9%
Decimal Number
ValueCountFrequency (%)
1 176
61.3%
9 85
29.6%
2 8
 
2.8%
5 5
 
1.7%
4 3
 
1.0%
6 3
 
1.0%
3 3
 
1.0%
0 2
 
0.7%
8 2
 
0.7%
Uppercase Letter
ValueCountFrequency (%)
K 4
26.7%
T 4
26.7%
L 3
20.0%
H 3
20.0%
E 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
, 2
40.0%
# 1
20.0%
& 1
20.0%
; 1
20.0%
Close Punctuation
ValueCountFrequency (%)
) 113
100.0%
Open Punctuation
ValueCountFrequency (%)
( 105
100.0%
Space Separator
ValueCountFrequency (%)
50
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5220
90.0%
Common 563
 
9.7%
Latin 15
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
소 530
 
10.2%
보 427
 
8.2%
건 427
 
8.2%
진 276
 
5.3%
료 250
 
4.8%
지 202
 
3.9%
전 127
 
2.4%
산 123
 
2.4%
서 101
 
1.9%
안 100
 
1.9%
Other values (258) 2657
50.9%
Common
ValueCountFrequency (%)
1 176
31.3%
) 113
20.1%
( 105
18.7%
9 85
15.1%
50
 
8.9%
2 8
 
1.4%
5 5
 
0.9%
- 3
 
0.5%
4 3
 
0.5%
6 3
 
0.5%
Other values (7) 12
 
2.1%
Latin
ValueCountFrequency (%)
K 4
26.7%
T 4
26.7%
L 3
20.0%
H 3
20.0%
E 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5220
90.0%
ASCII 578
 
10.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
소 530
 
10.2%
보 427
 
8.2%
건 427
 
8.2%
진 276
 
5.3%
료 250
 
4.8%
지 202
 
3.9%
전 127
 
2.4%
산 123
 
2.4%
서 101
 
1.9%
안 100
 
1.9%
Other values (258) 2657
50.9%
ASCII
ValueCountFrequency (%)
1 176
30.4%
) 113
19.6%
( 105
18.2%
9 85
14.7%
50
 
8.7%
2 8
 
1.4%
5 5
 
0.9%
K 4
 
0.7%
T 4
 
0.7%
- 3
 
0.5%
Other values (12) 25
 
4.3%

Unnamed: 3
Text

Distinct627
Distinct (%)94.0%
Missing1
Missing (%)0.1%
Memory size5.3 KiB
2024-03-14T09:46:27.063540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length43
Mean length21.770615
Min length4

Characters and Unicode

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

Unique

Unique597 ?
Unique (%)89.5%

Sample

1st row설치주소
2nd row전라북도 고창군 고수면 초내리 23-2
3rd row전라북도 고창군 고수면 황산리 269-4
4th row전라북도 고창군 고창읍 덕산리 134-3
5th row전라북도 고창군 고창읍 덕정리 76-1
ValueCountFrequency (%)
전라북도 666
 
20.2%
정읍시 69
 
2.1%
익산시 64
 
1.9%
전주시 64
 
1.9%
남원시 61
 
1.8%
군산시 59
 
1.8%
김제시 59
 
1.8%
완주군 47
 
1.4%
고창군 44
 
1.3%
부안군 40
 
1.2%
Other values (1315) 2131
64.5%
2024-03-14T09:46:27.485773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2687
 
18.5%
전 743
 
5.1%
도 704
 
4.8%
북 683
 
4.7%
라 669
 
4.6%
1 506
 
3.5%
리 423
 
2.9%
면 420
 
2.9%
- 388
 
2.7%
시 387
 
2.7%
Other values (280) 6911
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8945
61.6%
Space Separator 2687
 
18.5%
Decimal Number 2414
 
16.6%
Dash Punctuation 388
 
2.7%
Close Punctuation 43
 
0.3%
Open Punctuation 43
 
0.3%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 743
 
8.3%
도 704
 
7.9%
북 683
 
7.6%
라 669
 
7.5%
리 423
 
4.7%
면 420
 
4.7%
시 387
 
4.3%
군 355
 
4.0%
산 296
 
3.3%
동 213
 
2.4%
Other values (265) 4052
45.3%
Decimal Number
ValueCountFrequency (%)
1 506
21.0%
2 289
12.0%
3 288
11.9%
4 233
9.7%
5 233
9.7%
6 218
9.0%
8 177
 
7.3%
7 172
 
7.1%
0 163
 
6.8%
9 135
 
5.6%
Space Separator
ValueCountFrequency (%)
2687
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 388
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8945
61.6%
Common 5576
38.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 743
 
8.3%
도 704
 
7.9%
북 683
 
7.6%
라 669
 
7.5%
리 423
 
4.7%
면 420
 
4.7%
시 387
 
4.3%
군 355
 
4.0%
산 296
 
3.3%
동 213
 
2.4%
Other values (265) 4052
45.3%
Common
ValueCountFrequency (%)
2687
48.2%
1 506
 
9.1%
- 388
 
7.0%
2 289
 
5.2%
3 288
 
5.2%
4 233
 
4.2%
5 233
 
4.2%
6 218
 
3.9%
8 177
 
3.2%
7 172
 
3.1%
Other values (5) 385
 
6.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8945
61.6%
ASCII 5576
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2687
48.2%
1 506
 
9.1%
- 388
 
7.0%
2 289
 
5.2%
3 288
 
5.2%
4 233
 
4.2%
5 233
 
4.2%
6 218
 
3.9%
8 177
 
3.2%
7 172
 
3.1%
Other values (5) 385
 
6.9%
Hangul
ValueCountFrequency (%)
전 743
 
8.3%
도 704
 
7.9%
북 683
 
7.6%
라 669
 
7.5%
리 423
 
4.7%
면 420
 
4.7%
시 387
 
4.3%
군 355
 
4.0%
산 296
 
3.3%
동 213
 
2.4%
Other values (265) 4052
45.3%

Unnamed: 4
Text

Distinct271
Distinct (%)40.6%
Missing1
Missing (%)0.1%
Memory size5.3 KiB
2024-03-14T09:46:27.649889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length6.095952
Min length2

Characters and Unicode

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

Unique

Unique231 ?
Unique (%)34.6%

Sample

1st row설치장소
2nd row현관
3rd row현관
4th row현관
5th row현관
ValueCountFrequency (%)
진료실 103
 
10.0%
1층 95
 
9.2%
내 84
 
8.2%
구급차 81
 
7.9%
대기실 59
 
5.7%
현관 43
 
4.2%
민원실 39
 
3.8%
접수실 35
 
3.4%
입구 25
 
2.4%
진료대기실 23
 
2.2%
Other values (268) 442
43.0%
2024-03-14T09:46:27.951705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
실 406
 
10.0%
362
 
8.9%
진 218
 
5.4%
료 205
 
5.0%
내 163
 
4.0%
소 135
 
3.3%
구 135
 
3.3%
층 128
 
3.1%
기 127
 
3.1%
대 126
 
3.1%
Other values (227) 2061
50.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3534
86.9%
Space Separator 362
 
8.9%
Decimal Number 143
 
3.5%
Close Punctuation 11
 
0.3%
Open Punctuation 11
 
0.3%
Dash Punctuation 5
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
실 406
 
11.5%
진 218
 
6.2%
료 205
 
5.8%
내 163
 
4.6%
소 135
 
3.8%
구 135
 
3.8%
층 128
 
3.6%
기 127
 
3.6%
대 126
 
3.6%
급 100
 
2.8%
Other values (215) 1791
50.7%
Decimal Number
ValueCountFrequency (%)
1 125
87.4%
2 9
 
6.3%
5 4
 
2.8%
0 1
 
0.7%
6 1
 
0.7%
3 1
 
0.7%
4 1
 
0.7%
7 1
 
0.7%
Space Separator
ValueCountFrequency (%)
362
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3534
86.9%
Common 532
 
13.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
실 406
 
11.5%
진 218
 
6.2%
료 205
 
5.8%
내 163
 
4.6%
소 135
 
3.8%
구 135
 
3.8%
층 128
 
3.6%
기 127
 
3.6%
대 126
 
3.6%
급 100
 
2.8%
Other values (215) 1791
50.7%
Common
ValueCountFrequency (%)
362
68.0%
1 125
 
23.5%
) 11
 
2.1%
( 11
 
2.1%
2 9
 
1.7%
- 5
 
0.9%
5 4
 
0.8%
0 1
 
0.2%
6 1
 
0.2%
3 1
 
0.2%
Other values (2) 2
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3534
86.9%
ASCII 532
 
13.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
실 406
 
11.5%
진 218
 
6.2%
료 205
 
5.8%
내 163
 
4.6%
소 135
 
3.8%
구 135
 
3.8%
층 128
 
3.6%
기 127
 
3.6%
대 126
 
3.6%
급 100
 
2.8%
Other values (215) 1791
50.7%
ASCII
ValueCountFrequency (%)
362
68.0%
1 125
 
23.5%
) 11
 
2.1%
( 11
 
2.1%
2 9
 
1.7%
- 5
 
0.9%
5 4
 
0.8%
0 1
 
0.2%
6 1
 
0.2%
3 1
 
0.2%
Other values (2) 2
 
0.4%

Unnamed: 5
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size5.3 KiB
이동형
279 
캐비넷방식 고정형
275 
장비부착고정형
95 
기타
 
14
<NA>
 
3
Other values (2)
 
2

Length

Max length9
Median length7
Mean length6.0209581
Min length1

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row<NA>
2nd row설치방법
3rd row캐비넷방식 고정형
4th row캐비넷방식 고정형
5th row캐비넷방식 고정형

Common Values

ValueCountFrequency (%)
이동형 279
41.8%
캐비넷방식 고정형 275
41.2%
장비부착고정형 95
 
14.2%
기타 14
 
2.1%
<NA> 3
 
0.4%
설치방법 1
 
0.1%
- 1
 
0.1%

Length

2024-03-14T09:46:28.103835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:46:28.431758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
이동형 279
29.6%
캐비넷방식 275
29.2%
고정형 275
29.2%
장비부착고정형 95
 
10.1%
기타 14
 
1.5%
na 3
 
0.3%
설치방법 1
 
0.1%
1
 
0.1%

Unnamed: 6
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size5.3 KiB
정읍시보건소
69 
익산시보건소
64 
전주시보건소
64 
남원시보건소
61 
군산시보건소
59 
Other values (11)
351 

Length

Max length8
Median length6
Mean length6.3727545
Min length4

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row<NA>
2nd row관할보건소
3rd row고창군보건소
4th row고창군보건소
5th row고창군보건소

Common Values

ValueCountFrequency (%)
정읍시보건소 69
10.3%
익산시보건소 64
9.6%
전주시보건소 64
9.6%
남원시보건소 61
9.1%
군산시보건소 59
8.8%
김제시보건소 59
8.8%
완주군보건소 47
 
7.0%
고창군보건소 44
 
6.6%
부안군보건소 40
 
6.0%
임실군보건의료원 39
 
5.8%
Other values (6) 122
18.3%

Length

2024-03-14T09:46:28.571274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
정읍시보건소 69
10.3%
익산시보건소 64
9.6%
전주시보건소 64
9.6%
남원시보건소 61
9.1%
군산시보건소 59
8.8%
김제시보건소 59
8.8%
완주군보건소 47
 
7.0%
고창군보건소 44
 
6.6%
부안군보건소 40
 
6.0%
임실군보건의료원 39
 
5.8%
Other values (6) 122
18.3%

Correlations

2024-03-14T09:46:28.658985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 5Unnamed: 6
Unnamed: 51.0000.842
Unnamed: 60.8421.000
2024-03-14T09:46:28.728180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 6Unnamed: 5
Unnamed: 61.0000.588
Unnamed: 50.5881.000
2024-03-14T09:46:28.791981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 5Unnamed: 6
Unnamed: 51.0000.588
Unnamed: 60.5881.000

Missing values

2024-03-14T09:46:26.037733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:46:26.136415image/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-14T09:46:26.255179image/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: 02016년도 제세동기 설치 현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
0<NA>NaN<NA><NA><NA><NA><NA>
1<NA>NO설치기관명설치주소설치장소설치방법관할보건소
2<NA>1고수면내창보건진료소전라북도 고창군 고수면 초내리 23-2현관캐비넷방식 고정형고창군보건소
3<NA>2고수면보건지소전라북도 고창군 고수면 황산리 269-4현관캐비넷방식 고정형고창군보건소
4<NA>3고창읍백양보건진료소전라북도 고창군 고창읍 덕산리 134-3현관캐비넷방식 고정형고창군보건소
5<NA>4고창읍덕정보건진료소전라북도 고창군 고창읍 덕정리 76-1현관캐비넷방식 고정형고창군보건소
6<NA>5고창군공설운동장전라북도 고창군 고창읍 월암리 316실내수영장장비부착고정형고창군보건소
7<NA>6고창군공설운동장전라북도 고창군 고창읍 월암리 316공설운동장캐비넷방식 고정형고창군보건소
8<NA>7고창군보건소전라북도 고창군 고창읍 율계리 101구급차이동형고창군보건소
9<NA>8고창군보건소전라북도 고창군 고창읍 율계리 101중앙현관 복도캐비넷방식 고정형고창군보건소
Unnamed: 02016년도 제세동기 설치 현황Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
658<NA>657주천면대불보건진료소전라북도 진안군 주천면 벌뜸길 9진료실캐비넷방식 고정형진안군보건소
659<NA>658주천면무릉보건진료소전라북도 진안군 주천면 어자길 44진료실캐비넷방식 고정형진안군보건소
660<NA>659무진장소방서전라북도 진안군 주천면 주양리 437-4구급차내이동형진안군보건소
661<NA>660무진장소방서(진안119안전센터)전라북도 진안군 진안읍 군상리 246-1구급차내이동형진안군보건소
662<NA>661노인전문요양병원전라북도 진안군 진안읍 마이산로 76접수대캐비넷방식 고정형진안군보건소
663<NA>662홍삼스파전라북도 진안군 진안읍 외사양길 16-10접수대캐비넷방식 고정형진안군보건소
664<NA>663진안군청전라북도 진안군 진안읍 중앙로 67군청 입구캐비넷방식 고정형진안군보건소
665<NA>664문예체육회관전라북도 진안군 진안읍 진무로 1053-38사무실캐비넷방식 고정형진안군보건소
666<NA>665진안군보건소전라북도 진안군 진안읍 진무로 1189진료실이동형진안군보건소
667<NA>666진안군보건소전라북도 진안군 진안읍 진무로 1189보건소 환자 대기실-진안군보건소

Duplicate rows

Most frequently occurring

Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6# duplicates
0군산소방서(사정119안전센터)전라북도 군산시 사정동 171구급차이동형군산시보건소3
8전주완산소방서(효자119안전센터)전라북도 전주시 완산구 효자동1가 670구급차 내이동형전주시보건소3
1군산시보건소전라북도 군산시 나운동 153-8건강관리과이동형군산시보건소2
2김제소방서(교동119안전센터)전라북도 김제시 교동 314-19구급차 내이동형김제시보건소2
3남원소방서(용성119지역대)전라북도 남원시 향교동 780구급차 내이동형남원시보건소2
4부안소방서(격포119안전센터)전라북도 부안군 변산면 격포리 788-20구급차 내이동형부안군보건소2
5부안소방서(변산119지역대)전라북도 부안군 변산면 지서리 329-1구급차이동형부안군보건소2
6전주완산소방서(임실119안전센터)전라북도 임실군 임실읍 이도리 253-8구급차 내이동형임실군보건의료원2
7전주완산소방서(평화119안전센터)전라북도 전주시 완산구 평화동2가 895-3구급차 내이동형전주시보건소2
9정읍소방서(시기119안전센터)전라북도 정읍시 시기동 155-5구급차 내이동형정읍시보건소2