Overview

Dataset statistics

Number of variables5
Number of observations242
Missing cells51
Missing cells (%)4.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.6 KiB
Average record size in memory40.5 B

Variable types

Categorical1
Text4

Dataset

Description광주광역시 서구 관내 집단급식소가 업소에 대한 명칭, 업태명, 소재지(지번, 도로명주소), 전화번호 등에 관한 정보입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15037583/fileData.do

Alerts

업소전화번호 has 51 (21.1%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-23 07:28:56.359758
Analysis finished2023-12-23 07:28:59.203613
Duration2.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업태명
Categorical

Distinct8
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
어린이집
78 
병원
56 
학교
54 
공공기관
20 
산업체
17 
Other values (3)
17 

Length

Max length8
Median length6
Mean length3.1652893
Min length2

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row산업체
2nd row학교
3rd row어린이집
4th row병원
5th row공공기관

Common Values

ValueCountFrequency (%)
어린이집 78
32.2%
병원 56
23.1%
학교 54
22.3%
공공기관 20
 
8.3%
산업체 17
 
7.0%
사회복지시설 14
 
5.8%
기타 집단급식소 2
 
0.8%
수련원 1
 
0.4%

Length

2023-12-23T07:28:59.761332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-23T07:29:00.746494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
어린이집 78
32.0%
병원 56
23.0%
학교 54
22.1%
공공기관 20
 
8.2%
산업체 17
 
7.0%
사회복지시설 14
 
5.7%
기타 2
 
0.8%
집단급식소 2
 
0.8%
수련원 1
 
0.4%

업소명
Text

UNIQUE 

Distinct242
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-23T07:29:01.500116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length17
Mean length7.9049587
Min length4

Characters and Unicode

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

Unique

Unique242 ?
Unique (%)100.0%

Sample

1st row기아 오토랜드 광주 중식당
2nd row광주화정중학교
3rd row해달유치원
4th row미르치과병원 구내식당
5th row전남체신청 구내식당
ValueCountFrequency (%)
사회복지법인 8
 
2.7%
유치원 5
 
1.7%
어린이집 5
 
1.7%
기아 4
 
1.3%
광주 4
 
1.3%
오토랜드 4
 
1.3%
광주광역시 3
 
1.0%
구내식당 3
 
1.0%
주식회사 3
 
1.0%
식당 2
 
0.7%
Other values (257) 258
86.3%
2023-12-23T07:29:04.402429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
102
 
5.3%
81
 
4.2%
71
 
3.7%
68
 
3.6%
57
 
3.0%
56
 
2.9%
56
 
2.9%
52
 
2.7%
52
 
2.7%
51
 
2.7%
Other values (266) 1267
66.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1809
94.6%
Space Separator 57
 
3.0%
Close Punctuation 14
 
0.7%
Open Punctuation 14
 
0.7%
Decimal Number 11
 
0.6%
Uppercase Letter 6
 
0.3%
Other Punctuation 1
 
0.1%
Lowercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
102
 
5.6%
81
 
4.5%
71
 
3.9%
68
 
3.8%
56
 
3.1%
56
 
3.1%
52
 
2.9%
52
 
2.9%
51
 
2.8%
51
 
2.8%
Other values (250) 1169
64.6%
Uppercase Letter
ValueCountFrequency (%)
K 1
16.7%
S 1
16.7%
Y 1
16.7%
A 1
16.7%
C 1
16.7%
W 1
16.7%
Decimal Number
ValueCountFrequency (%)
2 4
36.4%
1 3
27.3%
3 2
18.2%
5 1
 
9.1%
6 1
 
9.1%
Space Separator
ValueCountFrequency (%)
57
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Other Punctuation
ValueCountFrequency (%)
· 1
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1809
94.6%
Common 97
 
5.1%
Latin 7
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
102
 
5.6%
81
 
4.5%
71
 
3.9%
68
 
3.8%
56
 
3.1%
56
 
3.1%
52
 
2.9%
52
 
2.9%
51
 
2.8%
51
 
2.8%
Other values (250) 1169
64.6%
Common
ValueCountFrequency (%)
57
58.8%
) 14
 
14.4%
( 14
 
14.4%
2 4
 
4.1%
1 3
 
3.1%
3 2
 
2.1%
· 1
 
1.0%
5 1
 
1.0%
6 1
 
1.0%
Latin
ValueCountFrequency (%)
K 1
14.3%
S 1
14.3%
e 1
14.3%
Y 1
14.3%
A 1
14.3%
C 1
14.3%
W 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1809
94.6%
ASCII 103
 
5.4%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
102
 
5.6%
81
 
4.5%
71
 
3.9%
68
 
3.8%
56
 
3.1%
56
 
3.1%
52
 
2.9%
52
 
2.9%
51
 
2.8%
51
 
2.8%
Other values (250) 1169
64.6%
ASCII
ValueCountFrequency (%)
57
55.3%
) 14
 
13.6%
( 14
 
13.6%
2 4
 
3.9%
1 3
 
2.9%
3 2
 
1.9%
K 1
 
1.0%
S 1
 
1.0%
e 1
 
1.0%
Y 1
 
1.0%
Other values (5) 5
 
4.9%
None
ValueCountFrequency (%)
· 1
100.0%
Distinct240
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-23T07:29:06.406324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length41
Mean length30.747934
Min length21

Characters and Unicode

Total characters7441
Distinct characters232
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

Unique238 ?
Unique (%)98.3%

Sample

1st row광주광역시 서구 화운로 277, 기아자동차 88동 중식당 1층 (내방동)
2nd row광주광역시 서구 화운로 53 (화정동,(일층))
3rd row광주광역시 서구 상무자유로 25 (치평동,(일층))
4th row광주광역시 서구 운천로 231 (치평동,(메트로치과칠층))
5th row광주광역시 서구 계수로 41 (유촌동,(8층))
ValueCountFrequency (%)
광주광역시 244
 
16.7%
서구 242
 
16.6%
1층 56
 
3.8%
화정동 34
 
2.3%
치평동 27
 
1.9%
쌍촌동 24
 
1.6%
3층 19
 
1.3%
금호동 19
 
1.3%
지하1층 18
 
1.2%
풍암동 16
 
1.1%
Other values (439) 758
52.0%
2023-12-23T07:29:08.763030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1215
 
16.3%
510
 
6.9%
( 304
 
4.1%
) 304
 
4.1%
1 277
 
3.7%
268
 
3.6%
260
 
3.5%
, 256
 
3.4%
255
 
3.4%
250
 
3.4%
Other values (222) 3542
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4294
57.7%
Space Separator 1215
 
16.3%
Decimal Number 1012
 
13.6%
Open Punctuation 304
 
4.1%
Close Punctuation 304
 
4.1%
Other Punctuation 258
 
3.5%
Dash Punctuation 33
 
0.4%
Uppercase Letter 14
 
0.2%
Lowercase Letter 6
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
510
 
11.9%
268
 
6.2%
260
 
6.1%
255
 
5.9%
250
 
5.8%
247
 
5.8%
246
 
5.7%
224
 
5.2%
214
 
5.0%
104
 
2.4%
Other values (187) 1716
40.0%
Uppercase Letter
ValueCountFrequency (%)
C 2
14.3%
K 2
14.3%
W 1
7.1%
E 1
7.1%
I 1
7.1%
V 1
7.1%
H 1
7.1%
S 1
7.1%
T 1
7.1%
Y 1
7.1%
Other values (2) 2
14.3%
Decimal Number
ValueCountFrequency (%)
1 277
27.4%
2 148
14.6%
3 106
 
10.5%
4 79
 
7.8%
6 75
 
7.4%
7 74
 
7.3%
5 72
 
7.1%
0 65
 
6.4%
8 61
 
6.0%
9 55
 
5.4%
Lowercase Letter
ValueCountFrequency (%)
e 1
16.7%
n 1
16.7%
t 1
16.7%
r 1
16.7%
a 1
16.7%
l 1
16.7%
Other Punctuation
ValueCountFrequency (%)
, 256
99.2%
. 2
 
0.8%
Space Separator
ValueCountFrequency (%)
1215
100.0%
Open Punctuation
ValueCountFrequency (%)
( 304
100.0%
Close Punctuation
ValueCountFrequency (%)
) 304
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 33
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4294
57.7%
Common 3127
42.0%
Latin 20
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
510
 
11.9%
268
 
6.2%
260
 
6.1%
255
 
5.9%
250
 
5.8%
247
 
5.8%
246
 
5.7%
224
 
5.2%
214
 
5.0%
104
 
2.4%
Other values (187) 1716
40.0%
Latin
ValueCountFrequency (%)
C 2
 
10.0%
K 2
 
10.0%
W 1
 
5.0%
E 1
 
5.0%
e 1
 
5.0%
I 1
 
5.0%
n 1
 
5.0%
t 1
 
5.0%
r 1
 
5.0%
V 1
 
5.0%
Other values (8) 8
40.0%
Common
ValueCountFrequency (%)
1215
38.9%
( 304
 
9.7%
) 304
 
9.7%
1 277
 
8.9%
, 256
 
8.2%
2 148
 
4.7%
3 106
 
3.4%
4 79
 
2.5%
6 75
 
2.4%
7 74
 
2.4%
Other values (7) 289
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4294
57.7%
ASCII 3147
42.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1215
38.6%
( 304
 
9.7%
) 304
 
9.7%
1 277
 
8.8%
, 256
 
8.1%
2 148
 
4.7%
3 106
 
3.4%
4 79
 
2.5%
6 75
 
2.4%
7 74
 
2.4%
Other values (25) 309
 
9.8%
Hangul
ValueCountFrequency (%)
510
 
11.9%
268
 
6.2%
260
 
6.1%
255
 
5.9%
250
 
5.8%
247
 
5.8%
246
 
5.7%
224
 
5.2%
214
 
5.0%
104
 
2.4%
Other values (187) 1716
40.0%
Distinct240
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-23T07:29:09.917269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length38
Mean length24.417355
Min length16

Characters and Unicode

Total characters5909
Distinct characters170
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

Unique238 ?
Unique (%)98.3%

Sample

1st row광주광역시 서구 내방동 700-1 기아자동차 88동 중식당 1층
2nd row광주광역시 서구 화정동 647-7 (일층)
3rd row광주광역시 서구 치평동 889-4 (일층)
4th row광주광역시 서구 치평동 1227-6 (메트로치과칠층)
5th row광주광역시 서구 유촌동 840-3 (8층)
ValueCountFrequency (%)
광주광역시 242
19.5%
서구 242
19.5%
1층 61
 
4.9%
화정동 44
 
3.5%
쌍촌동 37
 
3.0%
치평동 37
 
3.0%
금호동 27
 
2.2%
일층 25
 
2.0%
풍암동 23
 
1.8%
3층 21
 
1.7%
Other values (327) 485
39.0%
2023-12-23T07:29:11.767073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1243
21.0%
503
 
8.5%
1 312
 
5.3%
264
 
4.5%
252
 
4.3%
248
 
4.2%
247
 
4.2%
244
 
4.1%
244
 
4.1%
209
 
3.5%
Other values (160) 2143
36.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3096
52.4%
Space Separator 1243
21.0%
Decimal Number 1175
 
19.9%
Dash Punctuation 147
 
2.5%
Close Punctuation 115
 
1.9%
Open Punctuation 115
 
1.9%
Other Punctuation 14
 
0.2%
Uppercase Letter 3
 
0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
503
16.2%
264
 
8.5%
252
 
8.1%
248
 
8.0%
247
 
8.0%
244
 
7.9%
244
 
7.9%
209
 
6.8%
47
 
1.5%
47
 
1.5%
Other values (141) 791
25.5%
Decimal Number
ValueCountFrequency (%)
1 312
26.6%
2 160
13.6%
3 110
 
9.4%
8 93
 
7.9%
4 89
 
7.6%
5 89
 
7.6%
6 86
 
7.3%
0 82
 
7.0%
9 77
 
6.6%
7 77
 
6.6%
Uppercase Letter
ValueCountFrequency (%)
T 1
33.3%
Y 1
33.3%
B 1
33.3%
Space Separator
ValueCountFrequency (%)
1243
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 147
100.0%
Close Punctuation
ValueCountFrequency (%)
) 115
100.0%
Open Punctuation
ValueCountFrequency (%)
( 115
100.0%
Other Punctuation
ValueCountFrequency (%)
, 14
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3096
52.4%
Common 2810
47.6%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
503
16.2%
264
 
8.5%
252
 
8.1%
248
 
8.0%
247
 
8.0%
244
 
7.9%
244
 
7.9%
209
 
6.8%
47
 
1.5%
47
 
1.5%
Other values (141) 791
25.5%
Common
ValueCountFrequency (%)
1243
44.2%
1 312
 
11.1%
2 160
 
5.7%
- 147
 
5.2%
) 115
 
4.1%
( 115
 
4.1%
3 110
 
3.9%
8 93
 
3.3%
4 89
 
3.2%
5 89
 
3.2%
Other values (6) 337
 
12.0%
Latin
ValueCountFrequency (%)
T 1
33.3%
Y 1
33.3%
B 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3096
52.4%
ASCII 2813
47.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1243
44.2%
1 312
 
11.1%
2 160
 
5.7%
- 147
 
5.2%
) 115
 
4.1%
( 115
 
4.1%
3 110
 
3.9%
8 93
 
3.3%
4 89
 
3.2%
5 89
 
3.2%
Other values (9) 340
 
12.1%
Hangul
ValueCountFrequency (%)
503
16.2%
264
 
8.5%
252
 
8.1%
248
 
8.0%
247
 
8.0%
244
 
7.9%
244
 
7.9%
209
 
6.8%
47
 
1.5%
47
 
1.5%
Other values (141) 791
25.5%

업소전화번호
Text

MISSING 

Distinct190
Distinct (%)99.5%
Missing51
Missing (%)21.1%
Memory size2.0 KiB
2023-12-23T07:29:12.909132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.005236
Min length12

Characters and Unicode

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

Unique189 ?
Unique (%)99.0%

Sample

1st row062-370-1725
2nd row062-375-7831
3rd row062-383-3900
4th row062-600-2800
5th row062-600-4401
ValueCountFrequency (%)
062-227-8711 2
 
1.0%
062-610-7000 1
 
0.5%
062-610-7123 1
 
0.5%
062-370-1725 1
 
0.5%
062-613-5667 1
 
0.5%
062-604-0215 1
 
0.5%
062-604-8051 1
 
0.5%
062-606-8275 1
 
0.5%
062-608-1313 1
 
0.5%
062-610-2500 1
 
0.5%
Other values (180) 180
94.2%
2023-12-23T07:29:14.834693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 454
19.8%
- 382
16.7%
6 335
14.6%
2 302
13.2%
3 209
9.1%
1 146
 
6.4%
7 132
 
5.8%
8 116
 
5.1%
5 107
 
4.7%
4 64
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1911
83.3%
Dash Punctuation 382
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 454
23.8%
6 335
17.5%
2 302
15.8%
3 209
10.9%
1 146
 
7.6%
7 132
 
6.9%
8 116
 
6.1%
5 107
 
5.6%
4 64
 
3.3%
9 46
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 382
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2293
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 454
19.8%
- 382
16.7%
6 335
14.6%
2 302
13.2%
3 209
9.1%
1 146
 
6.4%
7 132
 
5.8%
8 116
 
5.1%
5 107
 
4.7%
4 64
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2293
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 454
19.8%
- 382
16.7%
6 335
14.6%
2 302
13.2%
3 209
9.1%
1 146
 
6.4%
7 132
 
5.8%
8 116
 
5.1%
5 107
 
4.7%
4 64
 
2.8%

Missing values

2023-12-23T07:28:58.053714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T07:28:58.945421image/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산업체기아 오토랜드 광주 중식당광주광역시 서구 화운로 277, 기아자동차 88동 중식당 1층 (내방동)광주광역시 서구 내방동 700-1 기아자동차 88동 중식당 1층062-370-1725
1학교광주화정중학교광주광역시 서구 화운로 53 (화정동,(일층))광주광역시 서구 화정동 647-7 (일층)062-375-7831
2어린이집해달유치원광주광역시 서구 상무자유로 25 (치평동,(일층))광주광역시 서구 치평동 889-4 (일층)062-383-3900
3병원미르치과병원 구내식당광주광역시 서구 운천로 231 (치평동,(메트로치과칠층))광주광역시 서구 치평동 1227-6 (메트로치과칠층)062-600-2800
4공공기관전남체신청 구내식당광주광역시 서구 계수로 41 (유촌동,(8층))광주광역시 서구 유촌동 840-3 (8층)062-600-4401
5학교광주동명중학교광주광역시 서구 운천로 306 (쌍촌동,(일층))광주광역시 서구 쌍촌동 1320-1 (일층)062-603-8105
6공공기관광주광역시청집단급식소광주광역시 서구 내방로 111 (치평동,(지하일층))광주광역시 서구 치평동 1200 (지하일층)062-613-2114
7학교풍암고등학교광주광역시 서구 풍암신흥로39번길 20 (풍암동,(이층))광주광역시 서구 풍암동 1006 (이층)062-650-0593
8학교마재초등학교광주광역시 서구 마재로 27 (금호동,(일층))광주광역시 서구 금호동 788 (일층)062-670-5208
9어린이집도화그림샘 어린이집광주광역시 서구 화개1로78번길 8, 1층 (금호동, 금호5차호반리젠시빌 유야보육시설)광주광역시 서구 금호동 809 (금호5차호반리젠시빌 유야보육시설 1층)062-681-4258
업태명업소명소재지(도로명)소재지(지번)업소전화번호
232학교치평초등학교광주광역시 서구 상무평화로 43 (치평동,(일층))광주광역시 서구 치평동 1171-7 (일층)062-381-3953
233어린이집삼성리나유치원광주광역시 서구 화개중앙로 117 (금호동,(지하1층))광주광역시 서구 금호동 612-6 (지하1층)062-382-2367
234어린이집홉스쿨유치원광주광역시 서구 금화로 41 (금호동,(지하1층))광주광역시 서구 금호동 281-1 (지하1층)062-383-2100
235병원규림한방병원광주광역시 서구 상무중앙로 75, 6층 (치평동)광주광역시 서구 치평동 1182-2 (치평동,6층)062-383-8275
236학교상일여자고등학교광주광역시 서구 내방로 217 (쌍촌동,(1층))광주광역시 서구 쌍촌동 1353 (1층)062-385-6021
237학교광주대동고등학교광주광역시 서구 전평길 50 (매월동)광주광역시 서구 매월동 521-4062-600-3680
238병원광주새우리병원광주광역시 서구 군분2로 8, 8층 (화정동)광주광역시 서구 화정동 180-28 8층062-603-8027
239어린이집세운그림유치원광주광역시 서구 풍금로38번길 4-20, 2층 (풍암동)광주광역시 서구 풍암동 948 2층062-655-0054
240산업체주식회사 케이티(농성빌딩)광주광역시 서구 월산로 173-1 (농성동,(오층))광주광역시 서구 농성동 100-1 (오층)0621-361-2699
241병원밝은안과의원21광주광역시 서구 무진대로 950 (농성동,(11층))광주광역시 서구 농성동 418-18 (11층)062-364-9000