Overview

Dataset statistics

Number of variables5
Number of observations127
Missing cells127
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.3 KiB
Average record size in memory43.0 B

Variable types

Categorical1
Text2
Numeric1
Unsupported1

Dataset

Description경상남도 요양보호사 교육기관 현황에 대한 데이터로 교육기관명, 전화번호, 주소 항목을 제공합니다. 경상남도 요양보호사 교육기관 현황에 대한 데이터로 교육기관명, 전화번호, 주소 항목을 제공합니다.
Author경상남도
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3079125

Alerts

전화번호 is highly overall correlated with 시군High correlation
시군 is highly overall correlated with 전화번호High correlation
비고 has 127 (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-11 00:06:50.163597
Analysis finished2023-12-11 00:06:50.771880
Duration0.61 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)11.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
창원
51 
김해
18 
진주
14 
양산
14 
밀양
10 
Other values (10)
20 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row창원
2nd row창원
3rd row창원
4th row창원
5th row창원

Common Values

ValueCountFrequency (%)
창원 51
40.2%
김해 18
 
14.2%
진주 14
 
11.0%
양산 14
 
11.0%
밀양 10
 
7.9%
거창 3
 
2.4%
통영 2
 
1.6%
사천 2
 
1.6%
함안 2
 
1.6%
고성 2
 
1.6%
Other values (5) 9
 
7.1%

Length

2023-12-11T09:06:50.854934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
창원 51
40.2%
김해 18
 
14.2%
진주 14
 
11.0%
양산 14
 
11.0%
밀양 10
 
7.9%
거창 3
 
2.4%
통영 2
 
1.6%
사천 2
 
1.6%
함안 2
 
1.6%
고성 2
 
1.6%
Other values (5) 9
 
7.1%

교육기관명
Text

UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-11T09:06:51.088256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length3.7322835
Min length1

Characters and Unicode

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

Unique

Unique127 ?
Unique (%)100.0%

Sample

1st row실버
2nd row우리
3rd row창원
4th row창원가족
5th row창원문성대학교부설
ValueCountFrequency (%)
실버 1
 
0.8%
신마산 1
 
0.8%
옥포사랑 1
 
0.8%
희망가득 1
 
0.8%
거제 1
 
0.8%
송운 1
 
0.8%
제일 1
 
0.8%
밀양영남 1
 
0.8%
밀양 1
 
0.8%
더온 1
 
0.8%
Other values (118) 118
92.2%
2023-12-11T09:06:51.482194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
15
 
3.2%
14
 
3.0%
14
 
3.0%
13
 
2.7%
12
 
2.5%
12
 
2.5%
12
 
2.5%
11
 
2.3%
11
 
2.3%
10
 
2.1%
Other values (143) 350
73.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 466
98.3%
Uppercase Letter 7
 
1.5%
Space Separator 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
15
 
3.2%
14
 
3.0%
14
 
3.0%
13
 
2.8%
12
 
2.6%
12
 
2.6%
12
 
2.6%
11
 
2.4%
11
 
2.4%
10
 
2.1%
Other values (135) 342
73.4%
Uppercase Letter
ValueCountFrequency (%)
O 1
14.3%
B 1
14.3%
M 1
14.3%
C 1
14.3%
S 1
14.3%
P 1
14.3%
T 1
14.3%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 466
98.3%
Latin 7
 
1.5%
Common 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
15
 
3.2%
14
 
3.0%
14
 
3.0%
13
 
2.8%
12
 
2.6%
12
 
2.6%
12
 
2.6%
11
 
2.4%
11
 
2.4%
10
 
2.1%
Other values (135) 342
73.4%
Latin
ValueCountFrequency (%)
O 1
14.3%
B 1
14.3%
M 1
14.3%
C 1
14.3%
S 1
14.3%
P 1
14.3%
T 1
14.3%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 466
98.3%
ASCII 8
 
1.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
15
 
3.2%
14
 
3.0%
14
 
3.0%
13
 
2.8%
12
 
2.6%
12
 
2.6%
12
 
2.6%
11
 
2.4%
11
 
2.4%
10
 
2.1%
Other values (135) 342
73.4%
ASCII
ValueCountFrequency (%)
O 1
12.5%
B 1
12.5%
M 1
12.5%
C 1
12.5%
S 1
12.5%
P 1
12.5%
1
12.5%
T 1
12.5%

전화번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4705338
Minimum2213335
Maximum9747723
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2023-12-11T09:06:51.681993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2213335
5-th percentile2375216.5
Q12666351
median3461611
Q37164420
95-th percentile9391069.9
Maximum9747723
Range7534388
Interquartile range (IQR)4498069

Descriptive statistics

Standard deviation2442455.2
Coefficient of variation (CV)0.51908178
Kurtosis-0.94993475
Mean4705338
Median Absolute Deviation (MAD)973891
Skewness0.76857843
Sum5.9757792 × 108
Variance5.9655876 × 1012
MonotonicityNot monotonic
2023-12-11T09:06:51.872897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2615825 1
 
0.8%
2553806 1
 
0.8%
6353344 1
 
0.8%
6877008 1
 
0.8%
6378338 1
 
0.8%
6383740 1
 
0.8%
3914031 1
 
0.8%
3551151 1
 
0.8%
3513412 1
 
0.8%
3568777 1
 
0.8%
Other values (117) 117
92.1%
ValueCountFrequency (%)
2213335 1
0.8%
2219991 1
0.8%
2301122 1
0.8%
2311023 1
0.8%
2311179 1
0.8%
2325265 1
0.8%
2373343 1
0.8%
2379588 1
0.8%
2381233 1
0.8%
2422200 1
0.8%
ValueCountFrequency (%)
9747723 1
0.8%
9737722 1
0.8%
9627845 1
0.8%
9621986 1
0.8%
9507404 1
0.8%
9450339 1
0.8%
9413833 1
0.8%
9337956 1
0.8%
9337717 1
0.8%
9209297 1
0.8%

주소
Text

UNIQUE 

Distinct127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-11T09:06:52.180191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length35
Mean length26.677165
Min length14

Characters and Unicode

Total characters3388
Distinct characters211
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique127 ?
Unique (%)100.0%

Sample

1st row창원시 의창구 신사로 4, 은아상가 28동 301호(신월동)
2nd row창원시 의창구 평산로 219번길 13, 2층(서상동)
3rd row창원시 의창구 도계로4번길 141, 대흥빌딩 3층 (도계동)
4th row창원시 의창구 봉곡로 115번길 6, 301호(봉곡동,형제상가)
5th row창원시 의창구 충혼로 91(두대동)
ValueCountFrequency (%)
창원시 51
 
8.0%
김해시 18
 
2.8%
의창구 15
 
2.3%
양산시 14
 
2.2%
진주시 14
 
2.2%
마산회원구 13
 
2.0%
2층 12
 
1.9%
성산구 11
 
1.7%
마산합포구 9
 
1.4%
3층 8
 
1.3%
Other values (391) 474
74.2%
2023-12-11T09:06:52.724425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
516
 
15.2%
, 140
 
4.1%
128
 
3.8%
1 123
 
3.6%
113
 
3.3%
113
 
3.3%
) 106
 
3.1%
( 106
 
3.1%
2 104
 
3.1%
3 91
 
2.7%
Other values (201) 1848
54.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1885
55.6%
Decimal Number 630
 
18.6%
Space Separator 516
 
15.2%
Other Punctuation 143
 
4.2%
Close Punctuation 106
 
3.1%
Open Punctuation 106
 
3.1%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
128
 
6.8%
113
 
6.0%
113
 
6.0%
85
 
4.5%
78
 
4.1%
69
 
3.7%
67
 
3.6%
65
 
3.4%
56
 
3.0%
49
 
2.6%
Other values (183) 1062
56.3%
Decimal Number
ValueCountFrequency (%)
1 123
19.5%
2 104
16.5%
3 91
14.4%
0 70
11.1%
5 59
9.4%
4 56
8.9%
6 43
 
6.8%
7 37
 
5.9%
8 26
 
4.1%
9 21
 
3.3%
Other Punctuation
ValueCountFrequency (%)
, 140
97.9%
. 2
 
1.4%
· 1
 
0.7%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
D 1
50.0%
Space Separator
ValueCountFrequency (%)
516
100.0%
Close Punctuation
ValueCountFrequency (%)
) 106
100.0%
Open Punctuation
ValueCountFrequency (%)
( 106
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1885
55.6%
Common 1501
44.3%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
128
 
6.8%
113
 
6.0%
113
 
6.0%
85
 
4.5%
78
 
4.1%
69
 
3.7%
67
 
3.6%
65
 
3.4%
56
 
3.0%
49
 
2.6%
Other values (183) 1062
56.3%
Common
ValueCountFrequency (%)
516
34.4%
, 140
 
9.3%
1 123
 
8.2%
) 106
 
7.1%
( 106
 
7.1%
2 104
 
6.9%
3 91
 
6.1%
0 70
 
4.7%
5 59
 
3.9%
4 56
 
3.7%
Other values (6) 130
 
8.7%
Latin
ValueCountFrequency (%)
A 1
50.0%
D 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1885
55.6%
ASCII 1502
44.3%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
516
34.4%
, 140
 
9.3%
1 123
 
8.2%
) 106
 
7.1%
( 106
 
7.1%
2 104
 
6.9%
3 91
 
6.1%
0 70
 
4.7%
5 59
 
3.9%
4 56
 
3.7%
Other values (7) 131
 
8.7%
Hangul
ValueCountFrequency (%)
128
 
6.8%
113
 
6.0%
113
 
6.0%
85
 
4.5%
78
 
4.1%
69
 
3.7%
67
 
3.6%
65
 
3.4%
56
 
3.0%
49
 
2.6%
Other values (183) 1062
56.3%
None
ValueCountFrequency (%)
· 1
100.0%

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing127
Missing (%)100.0%
Memory size1.2 KiB

Interactions

2023-12-11T09:06:50.433809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:06:52.858835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군전화번호
시군1.0000.919
전화번호0.9191.000
2023-12-11T09:06:52.970647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전화번호시군
전화번호1.0000.683
시군0.6831.000

Missing values

2023-12-11T09:06:50.599150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:06:50.725552image/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

시군교육기관명전화번호주소비고
0창원실버2615825창원시 의창구 신사로 4, 은아상가 28동 301호(신월동)<NA>
1창원우리2553806창원시 의창구 평산로 219번길 13, 2층(서상동)<NA>
2창원창원2373343창원시 의창구 도계로4번길 141, 대흥빌딩 3층 (도계동)<NA>
3창원창원가족2770125창원시 의창구 봉곡로 115번길 6, 301호(봉곡동,형제상가)<NA>
4창원창원문성대학교부설2795103창원시 의창구 충혼로 91(두대동)<NA>
5창원창원신세계2652247창원시 의창구 태복산로3번길 31, 3층(도계동,경도빌딩)<NA>
6창원청솔2776387창원시 의창구 우곡로217번길 36, 1001호(명서동,세인모리스타운)<NA>
7창원조은2779192창원시 의창구 도계로 66, 정화빌딩 401호(도계동)<NA>
8창원BM이화2379588창원시 의창구 도계로4번길 8, 일출빌딩 4층 401호(도계동)<NA>
9창원미래2640377창원시 의창구 남산로 5, 동양빌딩 2층(팔용동)<NA>
시군교육기관명전화번호주소비고
117하동해맑은8827521하동군 하동읍 화심길 5113, 2층<NA>
118산청산청9737722산청군 금서면 동의보감로312번가길 10771<NA>
119산청산청신안9747723산청군 신안면 원지강변로63번길 3026, 3층<NA>
120함양이레9627845함양군 함양읍 교산1길 5<NA>
121함양함양9621986함양군 함양읍 위성초등길 3<NA>
122거창거창사랑9450339거창군 거창읍 창동로 174<NA>
123거창경남도립거창대학평생교육원부설2542774거창군 거창읍 거창대학로 72<NA>
124거창거창9413833거창군 거창읍 강남로1길 20, 2층<NA>
125합천경남9337956합천군 합천읍 충효로 783<NA>
126합천합천9337717합천군 합천읍 중앙로 17, 102호(고품상가)<NA>