Overview

Dataset statistics

Number of variables5
Number of observations597
Missing cells116
Missing cells (%)3.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.4 KiB
Average record size in memory40.2 B

Variable types

Text4
DateTime1

Dataset

Description전북특별자치도 전주시 내 집단급식소를 제공하며 사업장명, 인허가일자, 영업상태명, 소재지전화번호 등을 제공합니다.
Author전라북도
URLhttps://www.bigdatahub.go.kr/index.jeonbuk?startPage=14&menuCd=DOM_000000103007001000&pListTypeStr=&pId=15083098

Alerts

데이터기준일자 has constant value ""Constant
소재지(도로명) has 28 (4.7%) missing valuesMissing
소재지전화 has 83 (13.9%) missing valuesMissing

Reproduction

Analysis started2024-03-14 00:05:41.287569
Analysis finished2024-03-14 00:05:41.902631
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

Distinct596
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
2024-03-14T09:05:42.021102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length8.1172529
Min length3

Characters and Unicode

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

Unique

Unique595 ?
Unique (%)99.7%

Sample

1st row은성어린이집
2nd row홀트아동복지회 전주영아원
3rd row신생어린이집
4th row상산고등학교(기숙사)
5th row예수병원
ValueCountFrequency (%)
어린이집 4
 
0.6%
의료법인 3
 
0.5%
아이들세상어린이집 2
 
0.3%
주식회사 2
 
0.3%
전북지역본부 2
 
0.3%
농촌진흥청 2
 
0.3%
전주21세기병원급식소 1
 
0.2%
주)휴비스전주공장수우관 1
 
0.2%
주)휴비스전주공장복지관 1
 
0.2%
전주중학교 1
 
0.2%
Other values (610) 610
97.0%
2024-03-14T09:05:42.318243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 253
 
5.2%
주 229
 
4.7%
원 213
 
4.4%
이 204
 
4.2%
학 180
 
3.7%
린 176
 
3.6%
집 176
 
3.6%
교 171
 
3.5%
어 169
 
3.5%
등 104
 
2.1%
Other values (340) 2971
61.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4743
97.9%
Open Punctuation 32
 
0.7%
Close Punctuation 32
 
0.7%
Space Separator 32
 
0.7%
Decimal Number 4
 
0.1%
Other Punctuation 2
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 253
 
5.3%
주 229
 
4.8%
원 213
 
4.5%
이 204
 
4.3%
학 180
 
3.8%
린 176
 
3.7%
집 176
 
3.7%
교 171
 
3.6%
어 169
 
3.6%
등 104
 
2.2%
Other values (332) 2868
60.5%
Decimal Number
ValueCountFrequency (%)
2 3
75.0%
1 1
 
25.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
50.0%
. 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%
Space Separator
ValueCountFrequency (%)
32
100.0%
Uppercase Letter
ValueCountFrequency (%)
S 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4743
97.9%
Common 102
 
2.1%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 253
 
5.3%
주 229
 
4.8%
원 213
 
4.5%
이 204
 
4.3%
학 180
 
3.8%
린 176
 
3.7%
집 176
 
3.7%
교 171
 
3.6%
어 169
 
3.6%
등 104
 
2.2%
Other values (332) 2868
60.5%
Common
ValueCountFrequency (%)
( 32
31.4%
) 32
31.4%
32
31.4%
2 3
 
2.9%
1 1
 
1.0%
/ 1
 
1.0%
. 1
 
1.0%
Latin
ValueCountFrequency (%)
S 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4743
97.9%
ASCII 103
 
2.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 253
 
5.3%
주 229
 
4.8%
원 213
 
4.5%
이 204
 
4.3%
학 180
 
3.8%
린 176
 
3.7%
집 176
 
3.7%
교 171
 
3.6%
어 169
 
3.6%
등 104
 
2.2%
Other values (332) 2868
60.5%
ASCII
ValueCountFrequency (%)
( 32
31.1%
) 32
31.1%
32
31.1%
2 3
 
2.9%
1 1
 
1.0%
/ 1
 
1.0%
S 1
 
1.0%
. 1
 
1.0%

소재지(도로명)
Text

MISSING 

Distinct563
Distinct (%)98.9%
Missing28
Missing (%)4.7%
Memory size4.8 KiB
2024-03-14T09:05:42.667729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length52
Mean length32.344464
Min length24

Characters and Unicode

Total characters18404
Distinct characters313
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

Unique557 ?
Unique (%)97.9%

Sample

1st row전라북도 전주시 완산구 강당1길 18-21 (서완산동2가)
2nd row전라북도 전주시 완산구 중산2길 7 (중화산동2가)
3rd row전라북도 전주시 완산구 난전들로 22-7 (평화동3가)
4th row전라북도 전주시 완산구 거마평로 130 (효자동1가)
5th row전라북도 전주시 완산구 서원로 365 (중화산동1가)
ValueCountFrequency (%)
전라북도 570
 
15.1%
전주시 569
 
15.1%
덕진구 296
 
7.8%
완산구 273
 
7.2%
1층 84
 
2.2%
효자동3가 33
 
0.9%
인후동1가 31
 
0.8%
효자동2가 27
 
0.7%
백제대로 26
 
0.7%
금암동 25
 
0.7%
Other values (883) 1846
48.8%
2024-03-14T09:05:43.094992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3214
 
17.5%
전 1201
 
6.5%
1 700
 
3.8%
동 647
 
3.5%
주 610
 
3.3%
북 593
 
3.2%
시 588
 
3.2%
구 579
 
3.1%
도 575
 
3.1%
( 573
 
3.1%
Other values (303) 9124
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11223
61.0%
Space Separator 3214
 
17.5%
Decimal Number 2405
 
13.1%
Open Punctuation 573
 
3.1%
Close Punctuation 573
 
3.1%
Other Punctuation 285
 
1.5%
Dash Punctuation 124
 
0.7%
Uppercase Letter 5
 
< 0.1%
Lowercase Letter 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1201
 
10.7%
동 647
 
5.8%
주 610
 
5.4%
북 593
 
5.3%
시 588
 
5.2%
구 579
 
5.2%
도 575
 
5.1%
라 573
 
5.1%
가 425
 
3.8%
산 378
 
3.4%
Other values (283) 5054
45.0%
Decimal Number
ValueCountFrequency (%)
1 700
29.1%
2 442
18.4%
3 328
13.6%
5 158
 
6.6%
4 154
 
6.4%
0 153
 
6.4%
7 141
 
5.9%
6 133
 
5.5%
8 111
 
4.6%
9 85
 
3.5%
Uppercase Letter
ValueCountFrequency (%)
C 2
40.0%
B 2
40.0%
K 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 284
99.6%
@ 1
 
0.4%
Space Separator
ValueCountFrequency (%)
3214
100.0%
Open Punctuation
ValueCountFrequency (%)
( 573
100.0%
Close Punctuation
ValueCountFrequency (%)
) 573
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 124
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11223
61.0%
Common 7174
39.0%
Latin 7
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1201
 
10.7%
동 647
 
5.8%
주 610
 
5.4%
북 593
 
5.3%
시 588
 
5.2%
구 579
 
5.2%
도 575
 
5.1%
라 573
 
5.1%
가 425
 
3.8%
산 378
 
3.4%
Other values (283) 5054
45.0%
Common
ValueCountFrequency (%)
3214
44.8%
1 700
 
9.8%
( 573
 
8.0%
) 573
 
8.0%
2 442
 
6.2%
3 328
 
4.6%
, 284
 
4.0%
5 158
 
2.2%
4 154
 
2.1%
0 153
 
2.1%
Other values (6) 595
 
8.3%
Latin
ValueCountFrequency (%)
C 2
28.6%
B 2
28.6%
e 2
28.6%
K 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11223
61.0%
ASCII 7181
39.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3214
44.8%
1 700
 
9.7%
( 573
 
8.0%
) 573
 
8.0%
2 442
 
6.2%
3 328
 
4.6%
, 284
 
4.0%
5 158
 
2.2%
4 154
 
2.1%
0 153
 
2.1%
Other values (10) 602
 
8.4%
Hangul
ValueCountFrequency (%)
전 1201
 
10.7%
동 647
 
5.8%
주 610
 
5.4%
북 593
 
5.3%
시 588
 
5.2%
구 579
 
5.2%
도 575
 
5.1%
라 573
 
5.1%
가 425
 
3.8%
산 378
 
3.4%
Other values (283) 5054
45.0%

소재지(지번)
Text

Distinct575
Distinct (%)97.1%
Missing5
Missing (%)0.8%
Memory size4.8 KiB
2024-03-14T09:05:43.287127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length38
Mean length25.08277
Min length19

Characters and Unicode

Total characters14849
Distinct characters189
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

Unique565 ?
Unique (%)95.4%

Sample

1st row전라북도 전주시 완산구 서완산동2가 78-21
2nd row전라북도 전주시 완산구 중화산동2가 623-2
3rd row전라북도 전주시 완산구 평화동3가 277
4th row전라북도 전주시 완산구 효자동1가 260
5th row전라북도 전주시 완산구 중화산동1가 300
ValueCountFrequency (%)
전라북도 592
19.2%
전주시 592
19.2%
완산구 301
 
9.8%
덕진구 291
 
9.4%
효자동3가 39
 
1.3%
효자동2가 36
 
1.2%
인후동1가 34
 
1.1%
송천동1가 32
 
1.0%
평화동2가 28
 
0.9%
중화산동2가 27
 
0.9%
Other values (697) 1112
36.1%
2024-03-14T09:05:43.587587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2793
18.8%
전 1201
 
8.1%
1 683
 
4.6%
동 615
 
4.1%
북 605
 
4.1%
주 605
 
4.1%
도 594
 
4.0%
라 593
 
4.0%
시 593
 
4.0%
구 592
 
4.0%
Other values (179) 5975
40.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8710
58.7%
Decimal Number 2903
 
19.6%
Space Separator 2793
 
18.8%
Dash Punctuation 432
 
2.9%
Other Punctuation 7
 
< 0.1%
Uppercase Letter 2
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1201
13.8%
동 615
 
7.1%
북 605
 
6.9%
주 605
 
6.9%
도 594
 
6.8%
라 593
 
6.8%
시 593
 
6.8%
구 592
 
6.8%
가 433
 
5.0%
산 365
 
4.2%
Other values (162) 2514
28.9%
Decimal Number
ValueCountFrequency (%)
1 683
23.5%
2 445
15.3%
3 347
12.0%
5 252
 
8.7%
4 231
 
8.0%
6 213
 
7.3%
7 203
 
7.0%
8 201
 
6.9%
0 175
 
6.0%
9 153
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
C 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
2793
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 432
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8710
58.7%
Common 6137
41.3%
Latin 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1201
13.8%
동 615
 
7.1%
북 605
 
6.9%
주 605
 
6.9%
도 594
 
6.8%
라 593
 
6.8%
시 593
 
6.8%
구 592
 
6.8%
가 433
 
5.0%
산 365
 
4.2%
Other values (162) 2514
28.9%
Common
ValueCountFrequency (%)
2793
45.5%
1 683
 
11.1%
2 445
 
7.3%
- 432
 
7.0%
3 347
 
5.7%
5 252
 
4.1%
4 231
 
3.8%
6 213
 
3.5%
7 203
 
3.3%
8 201
 
3.3%
Other values (5) 337
 
5.5%
Latin
ValueCountFrequency (%)
C 1
50.0%
S 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8710
58.7%
ASCII 6139
41.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2793
45.5%
1 683
 
11.1%
2 445
 
7.2%
- 432
 
7.0%
3 347
 
5.7%
5 252
 
4.1%
4 231
 
3.8%
6 213
 
3.5%
7 203
 
3.3%
8 201
 
3.3%
Other values (7) 339
 
5.5%
Hangul
ValueCountFrequency (%)
전 1201
13.8%
동 615
 
7.1%
북 605
 
6.9%
주 605
 
6.9%
도 594
 
6.8%
라 593
 
6.8%
시 593
 
6.8%
구 592
 
6.8%
가 433
 
5.0%
산 365
 
4.2%
Other values (162) 2514
28.9%

소재지전화
Text

MISSING 

Distinct508
Distinct (%)98.8%
Missing83
Missing (%)13.9%
Memory size4.8 KiB
2024-03-14T09:05:43.796274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique502 ?
Unique (%)97.7%

Sample

1st row063-284-1825
2nd row063-222-1559
3rd row063-226-9952
4th row063-223-8355
5th row063-230-8495
ValueCountFrequency (%)
063-221-2228 2
 
0.4%
063-210-2245 2
 
0.4%
063-227-9100 2
 
0.4%
063-247-0301 2
 
0.4%
063-244-6636 2
 
0.4%
063-272-8415 2
 
0.4%
063-273-1917 1
 
0.2%
063-212-7111 1
 
0.2%
063-245-3272 1
 
0.2%
063-245-5217 1
 
0.2%
Other values (498) 498
96.9%
2024-03-14T09:05:44.143236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 1028
16.7%
0 916
14.9%
2 907
14.7%
3 818
13.3%
6 701
11.4%
1 423
6.9%
5 336
 
5.4%
7 329
 
5.3%
4 295
 
4.8%
8 248
 
4.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5140
83.3%
Dash Punctuation 1028
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 916
17.8%
2 907
17.6%
3 818
15.9%
6 701
13.6%
1 423
8.2%
5 336
 
6.5%
7 329
 
6.4%
4 295
 
5.7%
8 248
 
4.8%
9 167
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 1028
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 6168
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 1028
16.7%
0 916
14.9%
2 907
14.7%
3 818
13.3%
6 701
11.4%
1 423
6.9%
5 336
 
5.4%
7 329
 
5.3%
4 295
 
4.8%
8 248
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6168
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 1028
16.7%
0 916
14.9%
2 907
14.7%
3 818
13.3%
6 701
11.4%
1 423
6.9%
5 336
 
5.4%
7 329
 
5.3%
4 295
 
4.8%
8 248
 
4.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.8 KiB
Minimum2021-07-27 00:00:00
Maximum2021-07-27 00:00:00
2024-03-14T09:05:44.236236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:05:44.308025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-03-14T09:05:41.671567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:05:41.757643image/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:05:41.862103image/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

업소명소재지(도로명)소재지(지번)소재지전화데이터기준일자
0은성어린이집전라북도 전주시 완산구 강당1길 18-21 (서완산동2가)전라북도 전주시 완산구 서완산동2가 78-21063-284-18252021-07-27
1홀트아동복지회 전주영아원전라북도 전주시 완산구 중산2길 7 (중화산동2가)전라북도 전주시 완산구 중화산동2가 623-2063-222-15592021-07-27
2신생어린이집전라북도 전주시 완산구 난전들로 22-7 (평화동3가)전라북도 전주시 완산구 평화동3가 277063-226-99522021-07-27
3상산고등학교(기숙사)전라북도 전주시 완산구 거마평로 130 (효자동1가)전라북도 전주시 완산구 효자동1가 260063-223-83552021-07-27
4예수병원전라북도 전주시 완산구 서원로 365 (중화산동1가)전라북도 전주시 완산구 중화산동1가 300063-230-84952021-07-27
5전주시청구내식당전라북도 전주시 완산구 노송광장로 10 (서노송동)전라북도 전주시 완산구 서노송동 568-1063-281-20272021-07-27
6기독병원전라북도 전주시 완산구 거마평로 185 (효자동1가)전라북도 전주시 완산구 효자동1가 398063-220-71202021-07-27
7전주교육대학교전라북도 전주시 완산구 서학로 50 (동서학동,학생회관 1층)전라북도 전주시 완산구 동서학동 213 학생회관 1층063-281-70262021-07-27
8완산구청구내식당전라북도 전주시 완산구 서원로 232 (효자동1가)전라북도 전주시 완산구 효자동1가 595063-226-00112021-07-27
9삼천초등학교전라북도 전주시 완산구 성지산로 38 (삼천동1가)전라북도 전주시 완산구 삼천동1가 585-1063-223-62432021-07-27
업소명소재지(도로명)소재지(지번)소재지전화데이터기준일자
587미듬어린이집전라북도 전주시 덕진구 혁신로 665, 1층 (반월동, 전주반월2엘에이치아파트)전라북도 전주시 덕진구 반월동 1350<NA>2021-07-27
588셰플러코리아 유한책임회사전라북도 전주시 덕진구 팔과정로 17, 셰플러코리아(유)전주공장 2동 지하1층 일부호 (팔복동3가)전라북도 전주시 덕진구 팔복동3가 402<NA>2021-07-27
589전주성현유치원전라북도 전주시 덕진구 만성남로 39-7, 2층 일부호 (만성동)<NA>063-213-05122021-07-27
590전주시거점형공공직장어린이집전라북도 전주시 덕진구 만성동로 114, 1층 일부호 (만성동)<NA>063-213-77602021-07-27
591이편한숲어린이집전라북도 전주시 덕진구 우아로 50, e편한세상 우아아파트 관리동 1층 (우아동3가, e편한세상 우아아파트)전라북도 전주시 덕진구 우아동3가 762063-245-55652021-07-27
592파란나라어린이집전라북도 전주시 덕진구 원산정길 22, 3층 (산정동)전라북도 전주시 덕진구 산정동 290-2063-241-65222021-07-27
593늘푸른어린이집전라북도 전주시 덕진구 세병로 136, 에코시티 더샵3차 1층 (송천동2가, 에코시티 더샵3차)전라북도 전주시 덕진구 송천동2가 1304063-272-27002021-07-27
594국민연금공단글로벌기금관전라북도 전주시 덕진구 오공로 131, 1층 (만성동)<NA>063-713-53582021-07-27
595주식회사데크카본전라북도 전주시 덕진구 운암로 30, 3동 1층 일부호 (팔복동2가)전라북도 전주시 덕진구 팔복동2가 835-1<NA>2021-07-27
596예랑어린이집전라북도 전주시 덕진구 쪽구름1길 24, 지하 1층 (여의동2가)전라북도 전주시 덕진구 동산동 692-10<NA>2021-07-27