Overview

Dataset statistics

Number of variables6
Number of observations288
Missing cells5
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.6 KiB
Average record size in memory48.5 B

Variable types

Unsupported2
Text3
Categorical1

Dataset

Description전라북도지역아동센터현황201711기준-데이터등록
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202970

Alerts

전라북도 지역아동센터 현황 (2017년 11월 기준) - 전북 총 286개소 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 02:10:35.470458
Analysis finished2024-03-14 02:10:35.959505
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Missing1
Missing (%)0.3%
Memory size2.4 KiB
Distinct265
Distinct (%)92.3%
Missing1
Missing (%)0.3%
Memory size2.4 KiB
2024-03-14T11:10:36.097037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length8
Mean length8.9930314
Min length3

Characters and Unicode

Total characters2581
Distinct characters277
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

Unique246 ?
Unique (%)85.7%

Sample

1st row기관명
2nd row고창지역아동센터
3rd row다아솜지역아동센터
4th row성내하늘땅지역아동센터
5th row써미트지역아동센터
ValueCountFrequency (%)
솔로몬지역아동센터 3
 
1.0%
희망지역아동센터 3
 
1.0%
우리지역아동센터 3
 
1.0%
늘푸른지역아동센터 2
 
0.7%
나눔지역아동센터 2
 
0.7%
푸른초장지역아동센터 2
 
0.7%
푸른꿈지역아동센터 2
 
0.7%
드림지역아동센터 2
 
0.7%
한우리지역아동센터 2
 
0.7%
도담지역아동센터 2
 
0.7%
Other values (264) 273
92.2%
2024-03-14T11:10:36.397442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
299
 
11.6%
293
 
11.4%
286
 
11.1%
285
 
11.0%
283
 
11.0%
283
 
11.0%
20
 
0.8%
18
 
0.7%
16
 
0.6%
16
 
0.6%
Other values (267) 782
30.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2510
97.2%
Lowercase Letter 16
 
0.6%
Other Punctuation 10
 
0.4%
Uppercase Letter 10
 
0.4%
Open Punctuation 9
 
0.3%
Close Punctuation 9
 
0.3%
Decimal Number 8
 
0.3%
Space Separator 7
 
0.3%
Control 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
299
11.9%
293
11.7%
286
11.4%
285
11.4%
283
 
11.3%
283
 
11.3%
20
 
0.8%
18
 
0.7%
16
 
0.6%
16
 
0.6%
Other values (242) 711
28.3%
Lowercase Letter
ValueCountFrequency (%)
p 4
25.0%
a 2
12.5%
o 2
12.5%
n 2
12.5%
e 2
12.5%
y 2
12.5%
h 1
 
6.2%
z 1
 
6.2%
Uppercase Letter
ValueCountFrequency (%)
Y 2
20.0%
J 2
20.0%
H 1
10.0%
A 1
10.0%
C 1
10.0%
W 1
10.0%
G 1
10.0%
Z 1
10.0%
Decimal Number
ValueCountFrequency (%)
1 4
50.0%
3 2
25.0%
8 2
25.0%
Other Punctuation
ValueCountFrequency (%)
, 9
90.0%
! 1
 
10.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Control
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2510
97.2%
Common 45
 
1.7%
Latin 26
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
299
11.9%
293
11.7%
286
11.4%
285
11.4%
283
 
11.3%
283
 
11.3%
20
 
0.8%
18
 
0.7%
16
 
0.6%
16
 
0.6%
Other values (242) 711
28.3%
Latin
ValueCountFrequency (%)
p 4
15.4%
a 2
 
7.7%
o 2
 
7.7%
Y 2
 
7.7%
J 2
 
7.7%
n 2
 
7.7%
e 2
 
7.7%
y 2
 
7.7%
H 1
 
3.8%
h 1
 
3.8%
Other values (6) 6
23.1%
Common
ValueCountFrequency (%)
( 9
20.0%
) 9
20.0%
, 9
20.0%
7
15.6%
1 4
8.9%
3 2
 
4.4%
2
 
4.4%
8 2
 
4.4%
! 1
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2510
97.2%
ASCII 71
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
299
11.9%
293
11.7%
286
11.4%
285
11.4%
283
 
11.3%
283
 
11.3%
20
 
0.8%
18
 
0.7%
16
 
0.6%
16
 
0.6%
Other values (242) 711
28.3%
ASCII
ValueCountFrequency (%)
( 9
12.7%
) 9
12.7%
, 9
12.7%
7
 
9.9%
p 4
 
5.6%
1 4
 
5.6%
a 2
 
2.8%
o 2
 
2.8%
Y 2
 
2.8%
J 2
 
2.8%
Other values (15) 21
29.6%

Unnamed: 2
Categorical

Distinct16
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
전주시
66 
군산시
49 
익산시
47 
정읍시
30 
남원시
24 
Other values (11)
72 

Length

Max length4
Median length3
Mean length3.0034722
Min length3

Unique

Unique2 ?
Unique (%)0.7%

Sample

1st row<NA>
2nd row시군구
3rd row고창군
4th row고창군
5th row고창군

Common Values

ValueCountFrequency (%)
전주시 66
22.9%
군산시 49
17.0%
익산시 47
16.3%
정읍시 30
10.4%
남원시 24
 
8.3%
완주군 13
 
4.5%
진안군 12
 
4.2%
김제시 11
 
3.8%
장수군 7
 
2.4%
고창군 6
 
2.1%
Other values (6) 23
 
8.0%

Length

2024-03-14T11:10:36.506189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전주시 66
22.9%
군산시 49
17.0%
익산시 47
16.3%
정읍시 30
10.4%
남원시 24
 
8.3%
완주군 13
 
4.5%
진안군 12
 
4.2%
김제시 11
 
3.8%
장수군 7
 
2.4%
고창군 6
 
2.1%
Other values (6) 23
 
8.0%
Distinct287
Distinct (%)100.0%
Missing1
Missing (%)0.3%
Memory size2.4 KiB
2024-03-14T11:10:36.868679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length34
Mean length19.348432
Min length2

Characters and Unicode

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

Unique

Unique287 ?
Unique (%)100.0%

Sample

1st row주소
2nd row전북 고창군 고창읍 성산2길 23, 2층
3rd row전북 고창군 부안면 복분자로 916-1
4th row전북 고창군 성내면 시기2길18
5th row전북 고창군 고창읍 월곡공원2길 37
ValueCountFrequency (%)
전북 284
 
19.6%
전주시 66
 
4.6%
군산시 49
 
3.4%
익산시 47
 
3.2%
2층 46
 
3.2%
완산구 34
 
2.3%
덕진구 32
 
2.2%
정읍시 30
 
2.1%
남원시 24
 
1.7%
3층 15
 
1.0%
Other values (607) 822
56.7%
2024-03-14T11:10:37.289386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1196
21.5%
357
 
6.4%
296
 
5.3%
1 238
 
4.3%
232
 
4.2%
2 198
 
3.6%
166
 
3.0%
163
 
2.9%
148
 
2.7%
3 114
 
2.1%
Other values (236) 2445
44.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3145
56.6%
Space Separator 1196
 
21.5%
Decimal Number 1034
 
18.6%
Dash Punctuation 96
 
1.7%
Other Punctuation 76
 
1.4%
Uppercase Letter 2
 
< 0.1%
Control 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
357
 
11.4%
296
 
9.4%
232
 
7.4%
166
 
5.3%
163
 
5.2%
148
 
4.7%
109
 
3.5%
93
 
3.0%
78
 
2.5%
71
 
2.3%
Other values (215) 1432
45.5%
Decimal Number
ValueCountFrequency (%)
1 238
23.0%
2 198
19.1%
3 114
11.0%
4 93
 
9.0%
5 81
 
7.8%
6 72
 
7.0%
0 66
 
6.4%
7 62
 
6.0%
8 61
 
5.9%
9 49
 
4.7%
Other Punctuation
ValueCountFrequency (%)
, 73
96.1%
@ 2
 
2.6%
. 1
 
1.3%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
B 1
50.0%
Space Separator
ValueCountFrequency (%)
1196
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 96
100.0%
Control
ValueCountFrequency (%)
1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3145
56.6%
Common 2406
43.3%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
357
 
11.4%
296
 
9.4%
232
 
7.4%
166
 
5.3%
163
 
5.2%
148
 
4.7%
109
 
3.5%
93
 
3.0%
78
 
2.5%
71
 
2.3%
Other values (215) 1432
45.5%
Common
ValueCountFrequency (%)
1196
49.7%
1 238
 
9.9%
2 198
 
8.2%
3 114
 
4.7%
- 96
 
4.0%
4 93
 
3.9%
5 81
 
3.4%
, 73
 
3.0%
6 72
 
3.0%
0 66
 
2.7%
Other values (9) 179
 
7.4%
Latin
ValueCountFrequency (%)
A 1
50.0%
B 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3145
56.6%
ASCII 2408
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1196
49.7%
1 238
 
9.9%
2 198
 
8.2%
3 114
 
4.7%
- 96
 
4.0%
4 93
 
3.9%
5 81
 
3.4%
, 73
 
3.0%
6 72
 
3.0%
0 66
 
2.7%
Other values (11) 181
 
7.5%
Hangul
ValueCountFrequency (%)
357
 
11.4%
296
 
9.4%
232
 
7.4%
166
 
5.3%
163
 
5.2%
148
 
4.7%
109
 
3.5%
93
 
3.0%
78
 
2.5%
71
 
2.3%
Other values (215) 1432
45.5%

Unnamed: 4
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.3%
Memory size2.4 KiB
Distinct287
Distinct (%)100.0%
Missing1
Missing (%)0.3%
Memory size2.4 KiB
2024-03-14T11:10:37.528030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.031359
Min length2

Characters and Unicode

Total characters3453
Distinct characters13
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

Unique287 ?
Unique (%)100.0%

Sample

1st row전화
2nd row063-561-3927
3rd row063-562-6331
4th row063-563-5615
5th row063-562-3709
ValueCountFrequency (%)
전화 1
 
0.3%
063-242-2291 1
 
0.3%
063-251-1007 1
 
0.3%
070-8843-1377 1
 
0.3%
063-232-1091 1
 
0.3%
063-908-9324 1
 
0.3%
063-227-8291 1
 
0.3%
063-212-5025 1
 
0.3%
063-229-8081 1
 
0.3%
063-223-9354 1
 
0.3%
Other values (277) 277
96.5%
2024-03-14T11:10:37.848965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 572
16.6%
3 537
15.6%
0 486
14.1%
6 456
13.2%
2 287
8.3%
5 223
 
6.5%
4 218
 
6.3%
1 185
 
5.4%
8 185
 
5.4%
7 165
 
4.8%
Other values (3) 139
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2879
83.4%
Dash Punctuation 572
 
16.6%
Other Letter 2
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 537
18.7%
0 486
16.9%
6 456
15.8%
2 287
10.0%
5 223
7.7%
4 218
7.6%
1 185
 
6.4%
8 185
 
6.4%
7 165
 
5.7%
9 137
 
4.8%
Other Letter
ValueCountFrequency (%)
1
50.0%
1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 572
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3451
99.9%
Hangul 2
 
0.1%

Most frequent character per script

Common
ValueCountFrequency (%)
- 572
16.6%
3 537
15.6%
0 486
14.1%
6 456
13.2%
2 287
8.3%
5 223
 
6.5%
4 218
 
6.3%
1 185
 
5.4%
8 185
 
5.4%
7 165
 
4.8%
Hangul
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3451
99.9%
Hangul 2
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 572
16.6%
3 537
15.6%
0 486
14.1%
6 456
13.2%
2 287
8.3%
5 223
 
6.5%
4 218
 
6.3%
1 185
 
5.4%
8 185
 
5.4%
7 165
 
4.8%
Hangul
ValueCountFrequency (%)
1
50.0%
1
50.0%

Missing values

2024-03-14T11:10:35.728954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T11:10:35.810760image/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-14T11:10:35.899036image/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

전라북도 지역아동센터 현황 (2017년 11월 기준) - 전북 총 286개소Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
0NaN<NA><NA><NA>NaN<NA>
1기관명시군구주소우편번호전화
21고창지역아동센터고창군전북 고창군 고창읍 성산2길 23, 2층56433063-561-3927
32다아솜지역아동센터고창군전북 고창군 부안면 복분자로 916-156416063-562-6331
43성내하늘땅지역아동센터고창군전북 고창군 성내면 시기2길1856420063-563-5615
54써미트지역아동센터고창군전북 고창군 고창읍 월곡공원2길 3756430063-562-3709
65열린지역아동센터고창군전북 고창군 고창읍 상월1길 2056426063-564-9821
76한마음지역아동센터고창군전북 고창군 고창읍 남구4길 956439063-561-1775
871318HappyZone행복스케치군산시전북 군산시 해망로 40754019063-442-1318
98개정지역아동센터군산시전북 군산시 아동남로154068063-451-3738
전라북도 지역아동센터 현황 (2017년 11월 기준) - 전북 총 286개소Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
278277부귀지역아동센터진안군전북 진안군 부귀면 부귀로 304-655416063-432-2032
279278성수지역아동센터진안군전북 진안군 성수면 관진로 76755459063-432-1316
280279예솔지역아동센터진안군전북 진안군 백운면 임진로 1306-1055453063-432-4520
281280정천지역아동센터진안군전북 진안군 정천면 상항길 45, 1층55409063-432-5663
282281주천지역아동센터진안군전북 진안군 주천면 동상주천로 222855402063-432-1317
283282진안꿈동산지역아동센터진안군전북 진안군 진안읍 성산2길 21-555433063-433-8950
284283진안마이용지역아동센터진안군전북 진안군 진안읍 대성길 7-1155435063-432-1318
285284진안사랑지역아동센터진안군전북 진안군 마령면 평지리 임진로 212355451063-432-9969
286285진안중앙지역아동센터진안군전북 진안군 진안읍 진무로 116655431063-433-1360
287286청소년꿈터지역아동센터진안군전북 진안군 진안읍 중연길 20-4755427063-432-0693