Overview

Dataset statistics

Number of variables5
Number of observations341
Missing cells335
Missing cells (%)19.6%
Duplicate rows1
Duplicate rows (%)0.3%
Total size in memory13.4 KiB
Average record size in memory40.4 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description전북특별자치도 전주시 내 아동급식카드 가맹점 목록 현황으로서 관리기관, 가맹점명, 주소 등의 항목을 제공합니다.제공항목 : 관할기관, 가맹점명, 주소, 비고 등제공부서 : 아동복지과
Author전북특별자치도 전주시
URLhttps://www.data.go.kr/data/15075026/fileData.do

Alerts

데이터기준일 has constant value ""Constant
Dataset has 1 (0.3%) duplicate rowsDuplicates
비고 has 335 (98.2%) missing valuesMissing

Reproduction

Analysis started2024-03-14 21:16:22.040126
Analysis finished2024-03-14 21:16:23.309373
Duration1.27 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관할기관
Categorical

Distinct36
Distinct (%)10.6%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
인후3동
25 
평화2동
24 
덕진동
 
22
서신동
 
18
효자4동
 
17
Other values (31)
235 

Length

Max length5
Median length4
Mean length3.6891496
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row완산구
2nd row완산구
3rd row완산구
4th row완산구
5th row완산구

Common Values

ValueCountFrequency (%)
인후3동 25
 
7.3%
평화2동 24
 
7.0%
덕진동 22
 
6.5%
서신동 18
 
5.3%
효자4동 17
 
5.0%
효자5동 14
 
4.1%
삼천2동 14
 
4.1%
금암1동 13
 
3.8%
호성동 12
 
3.5%
중화산1동 12
 
3.5%
Other values (26) 170
49.9%

Length

2024-03-15T06:16:23.554438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
인후3동 25
 
7.3%
평화2동 24
 
7.0%
덕진동 22
 
6.5%
서신동 18
 
5.3%
효자4동 17
 
5.0%
효자5동 14
 
4.1%
삼천2동 14
 
4.1%
금암1동 13
 
3.8%
중화산1동 12
 
3.5%
호성동 12
 
3.5%
Other values (26) 170
49.9%

가맹점명
Text

Distinct337
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2024-03-15T06:16:24.510867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length19
Mean length8.6041056
Min length2

Characters and Unicode

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

Unique

Unique333 ?
Unique (%)97.7%

Sample

1st rowCU(구,훼미리마트)(전주완산구)
2nd row코리아세븐(전주완산구)
3rd row지에스리테일(GS25)(전주완산구)
4th row바이더웨이(완산)
5th row(주)이마트24(전주완산구)
ValueCountFrequency (%)
cu 18
 
3.6%
파리바게뜨 16
 
3.2%
롯데리아 16
 
3.2%
본죽&비빔밥 14
 
2.8%
본죽 12
 
2.4%
아중점 6
 
1.2%
본 6
 
1.2%
죽&비빔밥 6
 
1.2%
피자스쿨 6
 
1.2%
중화산점 6
 
1.2%
Other values (342) 399
79.0%
2024-03-15T06:16:25.850018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 193
 
6.6%
164
 
5.6%
전 109
 
3.7%
주 94
 
3.2%
리 87
 
3.0%
트 69
 
2.4%
마 68
 
2.3%
) 67
 
2.3%
( 67
 
2.3%
아 54
 
1.8%
Other values (327) 1962
66.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2527
86.1%
Space Separator 164
 
5.6%
Close Punctuation 67
 
2.3%
Open Punctuation 67
 
2.3%
Uppercase Letter 45
 
1.5%
Other Punctuation 43
 
1.5%
Decimal Number 16
 
0.5%
Lowercase Letter 4
 
0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 193
 
7.6%
전 109
 
4.3%
주 94
 
3.7%
리 87
 
3.4%
트 69
 
2.7%
마 68
 
2.7%
아 54
 
2.1%
밥 53
 
2.1%
스 48
 
1.9%
본 45
 
1.8%
Other values (305) 1707
67.6%
Decimal Number
ValueCountFrequency (%)
2 4
25.0%
1 4
25.0%
4 3
18.8%
5 2
12.5%
0 2
12.5%
3 1
 
6.2%
Other Punctuation
ValueCountFrequency (%)
, 21
48.8%
& 20
46.5%
# 1
 
2.3%
. 1
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
C 20
44.4%
U 20
44.4%
S 3
 
6.7%
G 2
 
4.4%
Lowercase Letter
ValueCountFrequency (%)
r 1
25.0%
u 1
25.0%
p 1
25.0%
e 1
25.0%
Space Separator
ValueCountFrequency (%)
164
100.0%
Close Punctuation
ValueCountFrequency (%)
) 67
100.0%
Open Punctuation
ValueCountFrequency (%)
( 67
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2528
86.2%
Common 357
 
12.2%
Latin 49
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 193
 
7.6%
전 109
 
4.3%
주 94
 
3.7%
리 87
 
3.4%
트 69
 
2.7%
마 68
 
2.7%
아 54
 
2.1%
밥 53
 
2.1%
스 48
 
1.9%
본 45
 
1.8%
Other values (306) 1708
67.6%
Common
ValueCountFrequency (%)
164
45.9%
) 67
18.8%
( 67
18.8%
, 21
 
5.9%
& 20
 
5.6%
2 4
 
1.1%
1 4
 
1.1%
4 3
 
0.8%
5 2
 
0.6%
0 2
 
0.6%
Other values (3) 3
 
0.8%
Latin
ValueCountFrequency (%)
C 20
40.8%
U 20
40.8%
S 3
 
6.1%
G 2
 
4.1%
r 1
 
2.0%
u 1
 
2.0%
p 1
 
2.0%
e 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2527
86.1%
ASCII 406
 
13.8%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 193
 
7.6%
전 109
 
4.3%
주 94
 
3.7%
리 87
 
3.4%
트 69
 
2.7%
마 68
 
2.7%
아 54
 
2.1%
밥 53
 
2.1%
스 48
 
1.9%
본 45
 
1.8%
Other values (305) 1707
67.6%
ASCII
ValueCountFrequency (%)
164
40.4%
) 67
16.5%
( 67
16.5%
, 21
 
5.2%
& 20
 
4.9%
C 20
 
4.9%
U 20
 
4.9%
2 4
 
1.0%
1 4
 
1.0%
4 3
 
0.7%
Other values (11) 16
 
3.9%
None
ValueCountFrequency (%)
㈜ 1
100.0%

주소
Text

Distinct300
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
2024-03-15T06:16:27.353338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length41
Mean length30.659824
Min length2

Characters and Unicode

Total characters10455
Distinct characters246
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

Unique269 ?
Unique (%)78.9%

Sample

1st row전국
2nd row서울 중구 남창동 롯데손해보험빌딩
3rd row서울 영등포구 문래동6가
4th row서울 중구 남창동 롯데손해보험빌딩
5th row서울특별시 성동구 성수동 2가 281-4 푸조비즈타워
ValueCountFrequency (%)
전북특별자치도 330
 
16.5%
전주시 313
 
15.6%
완산구 173
 
8.6%
덕진구 158
 
7.9%
삼천동1가 21
 
1.0%
인후동1가 21
 
1.0%
서신동 17
 
0.8%
효자동2가 16
 
0.8%
효자동1가 16
 
0.8%
중화산동2가 15
 
0.7%
Other values (446) 924
46.1%
2024-03-15T06:16:29.413431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1663
 
15.9%
전 666
 
6.4%
자 376
 
3.6%
구 352
 
3.4%
북 342
 
3.3%
주 334
 
3.2%
별 333
 
3.2%
특 332
 
3.2%
치 331
 
3.2%
도 330
 
3.2%
Other values (236) 5396
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7047
67.4%
Space Separator 1663
 
15.9%
Decimal Number 1093
 
10.5%
Close Punctuation 260
 
2.5%
Open Punctuation 260
 
2.5%
Other Punctuation 82
 
0.8%
Dash Punctuation 50
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 666
 
9.5%
자 376
 
5.3%
구 352
 
5.0%
북 342
 
4.9%
주 334
 
4.7%
별 333
 
4.7%
특 332
 
4.7%
치 331
 
4.7%
도 330
 
4.7%
시 322
 
4.6%
Other values (221) 3329
47.2%
Decimal Number
ValueCountFrequency (%)
1 313
28.6%
2 231
21.1%
3 99
 
9.1%
5 92
 
8.4%
4 91
 
8.3%
7 63
 
5.8%
6 57
 
5.2%
0 50
 
4.6%
9 49
 
4.5%
8 48
 
4.4%
Space Separator
ValueCountFrequency (%)
1663
100.0%
Close Punctuation
ValueCountFrequency (%)
) 260
100.0%
Open Punctuation
ValueCountFrequency (%)
( 260
100.0%
Other Punctuation
ValueCountFrequency (%)
, 82
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7047
67.4%
Common 3408
32.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 666
 
9.5%
자 376
 
5.3%
구 352
 
5.0%
북 342
 
4.9%
주 334
 
4.7%
별 333
 
4.7%
특 332
 
4.7%
치 331
 
4.7%
도 330
 
4.7%
시 322
 
4.6%
Other values (221) 3329
47.2%
Common
ValueCountFrequency (%)
1663
48.8%
1 313
 
9.2%
) 260
 
7.6%
( 260
 
7.6%
2 231
 
6.8%
3 99
 
2.9%
5 92
 
2.7%
4 91
 
2.7%
, 82
 
2.4%
7 63
 
1.8%
Other values (5) 254
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7047
67.4%
ASCII 3408
32.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1663
48.8%
1 313
 
9.2%
) 260
 
7.6%
( 260
 
7.6%
2 231
 
6.8%
3 99
 
2.9%
5 92
 
2.7%
4 91
 
2.7%
, 82
 
2.4%
7 63
 
1.8%
Other values (5) 254
 
7.5%
Hangul
ValueCountFrequency (%)
전 666
 
9.5%
자 376
 
5.3%
구 352
 
5.0%
북 342
 
4.9%
주 334
 
4.7%
별 333
 
4.7%
특 332
 
4.7%
치 331
 
4.7%
도 330
 
4.7%
시 322
 
4.6%
Other values (221) 3329
47.2%

비고
Text

MISSING 

Distinct6
Distinct (%)100.0%
Missing335
Missing (%)98.2%
Memory size2.8 KiB
2024-03-15T06:16:30.042234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length15
Mean length15.5
Min length7

Characters and Unicode

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

Unique

Unique6 ?
Unique (%)100.0%

Sample

1st row*최소 배달 11,000원
2nd row*최소 배달 10,000원
3rd row*13,000원이상 배달가능
4th row*배달비 별도
5th row*10,000원이상 배달가능
ValueCountFrequency (%)
최소 2
14.3%
배달 2
14.3%
배달가능 2
14.3%
11,000원 1
7.1%
10,000원 1
7.1%
13,000원이상 1
7.1%
배달비 1
7.1%
별도 1
7.1%
10,000원이상 1
7.1%
홀16:00~18:00 1
7.1%
2024-03-15T06:16:31.321024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 22
23.7%
1 9
 
9.7%
8
 
8.6%
* 6
 
6.5%
배 5
 
5.4%
달 5
 
5.4%
, 5
 
5.4%
원 4
 
4.3%
: 4
 
4.3%
최 2
 
2.2%
Other values (16) 23
24.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 36
38.7%
Other Letter 32
34.4%
Other Punctuation 15
16.1%
Space Separator 8
 
8.6%
Math Symbol 2
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
배 5
15.6%
달 5
15.6%
원 4
12.5%
최 2
 
6.2%
능 2
 
6.2%
가 2
 
6.2%
상 2
 
6.2%
이 2
 
6.2%
소 2
 
6.2%
비 1
 
3.1%
Other values (5) 5
15.6%
Decimal Number
ValueCountFrequency (%)
0 22
61.1%
1 9
25.0%
6 2
 
5.6%
3 1
 
2.8%
8 1
 
2.8%
2 1
 
2.8%
Other Punctuation
ValueCountFrequency (%)
* 6
40.0%
, 5
33.3%
: 4
26.7%
Space Separator
ValueCountFrequency (%)
8
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 61
65.6%
Hangul 32
34.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
배 5
15.6%
달 5
15.6%
원 4
12.5%
최 2
 
6.2%
능 2
 
6.2%
가 2
 
6.2%
상 2
 
6.2%
이 2
 
6.2%
소 2
 
6.2%
비 1
 
3.1%
Other values (5) 5
15.6%
Common
ValueCountFrequency (%)
0 22
36.1%
1 9
14.8%
8
 
13.1%
* 6
 
9.8%
, 5
 
8.2%
: 4
 
6.6%
~ 2
 
3.3%
6 2
 
3.3%
3 1
 
1.6%
8 1
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 61
65.6%
Hangul 32
34.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 22
36.1%
1 9
14.8%
8
 
13.1%
* 6
 
9.8%
, 5
 
8.2%
: 4
 
6.6%
~ 2
 
3.3%
6 2
 
3.3%
3 1
 
1.6%
8 1
 
1.6%
Hangul
ValueCountFrequency (%)
배 5
15.6%
달 5
15.6%
원 4
12.5%
최 2
 
6.2%
능 2
 
6.2%
가 2
 
6.2%
상 2
 
6.2%
이 2
 
6.2%
소 2
 
6.2%
비 1
 
3.1%
Other values (5) 5
15.6%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.8 KiB
Minimum2023-11-28 00:00:00
Maximum2023-11-28 00:00:00
2024-03-15T06:16:31.658471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:16:31.959790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-03-15T06:16:32.166713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관할기관비고
관할기관1.0001.000
비고1.0001.000

Missing values

2024-03-15T06:16:22.856941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T06:16:23.176774image/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완산구CU(구,훼미리마트)(전주완산구)전국<NA>2023-11-28
1완산구코리아세븐(전주완산구)서울 중구 남창동 롯데손해보험빌딩<NA>2023-11-28
2완산구지에스리테일(GS25)(전주완산구)서울 영등포구 문래동6가<NA>2023-11-28
3완산구바이더웨이(완산)서울 중구 남창동 롯데손해보험빌딩<NA>2023-11-28
4완산구(주)이마트24(전주완산구)서울특별시 성동구 성수동 2가 281-4 푸조비즈타워<NA>2023-11-28
5중앙동또와분식전북특별자치도 전주시 완산구 태평5길 41-5 (태평동)<NA>2023-11-28
6중앙동한스델리중앙점전북특별자치도 전주시 완산구 전주객사5길 43-18<NA>2023-11-28
7중앙동마트유(태평점)전북특별자치도 전주시 완산구 공북로 77<NA>2023-11-28
8중앙동신포우리만두전북특별자치도 전주시 완산구 전주객사4길 24-5 (고사동)<NA>2023-11-28
9중앙동중본이쟁반짜장전북특별자치도 전주시 완산구 공북로 71 (태평동)<NA>2023-11-28
관할기관가맹점명주소비고데이터기준일
331여의동하하꼬치전북특별자치도 전주시 덕진구 덕용4길 11 (여의동2가)<NA>2023-11-28
332여의동굿모닝행복애찬전북특별자치도 전주시 덕진구 편운로 54-11 (여의동2가)<NA>2023-11-28
333여의동CU (구,훼미리마트)(전주동산점)전북특별자치도 덕진구 동산동<NA>2023-11-28
334여의동파리바게트여의점전북특별자치도 전주시 덕진구 쪽구름로 61 (여의동, 이상영가정의학과)<NA>2023-11-28
335여의동낙원분식전북특별자치도 전주시 덕진구 편운로 52<NA>2023-11-28
336여의동본죽&비빔밥 전주만성점전북특별자치도 전주시 덕진구 만성중앙로 45 (만성동)<NA>2023-11-28
337혁신동감탄 혁신점전북특별자치도 전주시 덕진구 안전로 197 (장동)<NA>2023-11-28
338혁신동피자스쿨혁신점전북특별자치도 전주시 덕진구 안전로 197 (장동)<NA>2023-11-28
339혁신동파리바게뜨(전북혁신1호점)전북특별자치도 전주시 덕진구 오정1길 1 (중동)<NA>2023-11-28
340혁신동모몽크전북특별자치도 전주시 덕진구 오공로 43-22 (중동)<NA>2023-11-28

Duplicate rows

Most frequently occurring

관할기관가맹점명주소비고데이터기준일# duplicates
0중화산1동롯데리아 중화산점전북특별자치도 전주시 완산구 백제대로 224 (중화산동2가)<NA>2023-11-282