Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory556.6 KiB
Average record size in memory57.0 B

Variable types

Numeric1
Categorical3
Text2

Dataset

Description2023. 7. 26. 기준 시군별 아동급식 카드가 사용 가능한 업체 목록으로 편의점, 휴게음식점, 일반음식점, 마트 등 현황 데이터
URLhttps://www.data.go.kr/data/15092768/fileData.do

Alerts

시도 has constant value ""Constant
시군구 is highly imbalanced (72.0%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:23:45.706570
Analysis finished2023-12-12 20:23:47.432647
Duration1.73 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7021.811
Minimum1
Maximum14072
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T05:23:47.517563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile708.95
Q13524.75
median6978.5
Q310542.25
95-th percentile13366.05
Maximum14072
Range14071
Interquartile range (IQR)7017.5

Descriptive statistics

Standard deviation4056.9049
Coefficient of variation (CV)0.57775763
Kurtosis-1.1981693
Mean7021.811
Median Absolute Deviation (MAD)3512
Skewness0.009045441
Sum70218110
Variance16458477
MonotonicityNot monotonic
2023-12-13T05:23:47.690887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8260 1
 
< 0.1%
2185 1
 
< 0.1%
9475 1
 
< 0.1%
8773 1
 
< 0.1%
8114 1
 
< 0.1%
2899 1
 
< 0.1%
10915 1
 
< 0.1%
10839 1
 
< 0.1%
13876 1
 
< 0.1%
6351 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
14072 1
< 0.1%
14071 1
< 0.1%
14070 1
< 0.1%
14069 1
< 0.1%
14067 1
< 0.1%
14065 1
< 0.1%
14064 1
< 0.1%
14062 1
< 0.1%
14061 1
< 0.1%
14060 1
< 0.1%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
충청남도
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청남도
2nd row충청남도
3rd row충청남도
4th row충청남도
5th row충청남도

Common Values

ValueCountFrequency (%)
충청남도 10000
100.0%

Length

2023-12-13T05:23:47.845457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:47.958556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 10000
100.0%

시군구
Categorical

IMBALANCE 

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
천안시
8618 
당진시
 
236
서산시
 
179
논산시
 
159
예산군
 
122
Other values (9)
 
686

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row천안시
2nd row천안시
3rd row천안시
4th row천안시
5th row천안시

Common Values

ValueCountFrequency (%)
천안시 8618
86.2%
당진시 236
 
2.4%
서산시 179
 
1.8%
논산시 159
 
1.6%
예산군 122
 
1.2%
홍성군 112
 
1.1%
공주시 108
 
1.1%
보령시 93
 
0.9%
태안군 78
 
0.8%
부여군 72
 
0.7%
Other values (4) 223
 
2.2%

Length

2023-12-13T05:23:48.160427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
천안시 8618
86.2%
당진시 236
 
2.4%
서산시 179
 
1.8%
논산시 159
 
1.6%
예산군 122
 
1.2%
홍성군 112
 
1.1%
공주시 108
 
1.1%
보령시 93
 
0.9%
태안군 78
 
0.8%
부여군 72
 
0.7%
Other values (4) 223
 
2.2%

가맹점명
Text

Distinct9062
Distinct (%)90.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T05:23:48.573975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length19
Mean length7.1813
Min length1

Characters and Unicode

Total characters71813
Distinct characters1007
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8365 ?
Unique (%)83.7%

Sample

1st row파리바게뜨천안차암점
2nd row지에스25쌍용코리아점
3rd row1번지 수산
4th row더벤티 천안성성점
5th row모아생고기
ValueCountFrequency (%)
세븐일레븐 250
 
2.0%
씨유 144
 
1.1%
지에스25 142
 
1.1%
gs25 115
 
0.9%
cu 115
 
0.9%
이마트24 78
 
0.6%
미니스톱 75
 
0.6%
주식회사 71
 
0.6%
씨유(cu 50
 
0.4%
45
 
0.4%
Other values (9158) 11560
91.4%
2023-12-13T05:23:49.459285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 3630
 
5.1%
2653
 
3.7%
천 1745
 
2.4%
안 1554
 
2.2%
이 1283
 
1.8%
스 1109
 
1.5%
당 1088
 
1.5%
마 925
 
1.3%
정 824
 
1.1%
성 775
 
1.1%
Other values (997) 56227
78.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 64132
89.3%
Space Separator 2653
 
3.7%
Uppercase Letter 1697
 
2.4%
Decimal Number 1645
 
2.3%
Close Punctuation 663
 
0.9%
Open Punctuation 660
 
0.9%
Lowercase Letter 315
 
0.4%
Other Punctuation 39
 
0.1%
Dash Punctuation 5
 
< 0.1%
Connector Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 3630
 
5.7%
천 1745
 
2.7%
안 1554
 
2.4%
이 1283
 
2.0%
스 1109
 
1.7%
당 1088
 
1.7%
마 925
 
1.4%
정 824
 
1.3%
성 775
 
1.2%
리 763
 
1.2%
Other values (926) 50436
78.6%
Uppercase Letter
ValueCountFrequency (%)
C 376
22.2%
U 337
19.9%
S 314
18.5%
G 303
17.9%
I 39
 
2.3%
E 36
 
2.1%
A 36
 
2.1%
O 27
 
1.6%
N 25
 
1.5%
T 23
 
1.4%
Other values (16) 181
10.7%
Lowercase Letter
ValueCountFrequency (%)
e 44
14.0%
a 42
13.3%
n 22
 
7.0%
s 19
 
6.0%
o 19
 
6.0%
r 17
 
5.4%
f 16
 
5.1%
t 16
 
5.1%
d 15
 
4.8%
h 14
 
4.4%
Other values (12) 91
28.9%
Decimal Number
ValueCountFrequency (%)
2 628
38.2%
5 496
30.2%
4 134
 
8.1%
1 106
 
6.4%
0 63
 
3.8%
9 62
 
3.8%
3 54
 
3.3%
7 49
 
3.0%
8 31
 
1.9%
6 22
 
1.3%
Other Punctuation
ValueCountFrequency (%)
& 18
46.2%
. 14
35.9%
' 3
 
7.7%
# 3
 
7.7%
, 1
 
2.6%
Close Punctuation
ValueCountFrequency (%)
) 453
68.3%
] 210
31.7%
Open Punctuation
ValueCountFrequency (%)
( 450
68.2%
[ 210
31.8%
Space Separator
ValueCountFrequency (%)
2653
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 64132
89.3%
Common 5667
 
7.9%
Latin 2012
 
2.8%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 3630
 
5.7%
천 1745
 
2.7%
안 1554
 
2.4%
이 1283
 
2.0%
스 1109
 
1.7%
당 1088
 
1.7%
마 925
 
1.4%
정 824
 
1.3%
성 775
 
1.2%
리 763
 
1.2%
Other values (925) 50436
78.6%
Latin
ValueCountFrequency (%)
C 376
18.7%
U 337
16.7%
S 314
15.6%
G 303
15.1%
e 44
 
2.2%
a 42
 
2.1%
I 39
 
1.9%
E 36
 
1.8%
A 36
 
1.8%
O 27
 
1.3%
Other values (38) 458
22.8%
Common
ValueCountFrequency (%)
2653
46.8%
2 628
 
11.1%
5 496
 
8.8%
) 453
 
8.0%
( 450
 
7.9%
] 210
 
3.7%
[ 210
 
3.7%
4 134
 
2.4%
1 106
 
1.9%
0 63
 
1.1%
Other values (12) 264
 
4.7%
Han
ValueCountFrequency (%)
家 1
50.0%
樂 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 64130
89.3%
ASCII 7679
 
10.7%
None 2
 
< 0.1%
CJK 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 3630
 
5.7%
천 1745
 
2.7%
안 1554
 
2.4%
이 1283
 
2.0%
스 1109
 
1.7%
당 1088
 
1.7%
마 925
 
1.4%
정 824
 
1.3%
성 775
 
1.2%
리 763
 
1.2%
Other values (924) 50434
78.6%
ASCII
ValueCountFrequency (%)
2653
34.5%
2 628
 
8.2%
5 496
 
6.5%
) 453
 
5.9%
( 450
 
5.9%
C 376
 
4.9%
U 337
 
4.4%
S 314
 
4.1%
G 303
 
3.9%
] 210
 
2.7%
Other values (60) 1459
19.0%
None
ValueCountFrequency (%)
㈜ 2
100.0%
CJK
ValueCountFrequency (%)
家 1
50.0%
樂 1
50.0%

도로명주소
Text

Distinct9351
Distinct (%)93.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T05:23:49.852372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length82
Median length71
Mean length38.3415
Min length13

Characters and Unicode

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

Unique

Unique8829 ?
Unique (%)88.3%

Sample

1st row(31085) 충남 천안시 서북구 3공단6로 58-8 103호 (차암동,천안비즈타워)
2nd row(31180) 충남 천안시 서북구 차돌들길 7-3 101,102,103호 (쌍용동,동성빌딩)
3rd row(31080) 충남 천안시 서북구 천안대로 1347 1층 (신당동)
4th row(31079) 충남 천안시 서북구 성성9로 14 501동 1층 104호 (성성동,천안레이크타운2차푸르지오)
5th row(31187) 충남 천안시 동남구 원성동 543-7 번지
ValueCountFrequency (%)
충남 8748
 
10.2%
천안시 8622
 
10.0%
서북구 5097
 
5.9%
3681
 
4.3%
동남구 3478
 
4.0%
1층 3207
 
3.7%
충청남도 1253
 
1.5%
1 1232
 
1.4%
층 953
 
1.1%
길 723
 
0.8%
Other values (7490) 48965
57.0%
2023-12-13T05:23:50.437704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
76092
19.8%
1 32814
 
8.6%
( 16579
 
4.3%
) 16577
 
4.3%
3 15113
 
3.9%
남 13761
 
3.6%
동 12033
 
3.1%
충 10325
 
2.7%
천 10085
 
2.6%
시 9875
 
2.6%
Other values (655) 170161
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 171573
44.7%
Decimal Number 94656
24.7%
Space Separator 76092
19.8%
Open Punctuation 16579
 
4.3%
Close Punctuation 16578
 
4.3%
Other Punctuation 4786
 
1.2%
Dash Punctuation 2510
 
0.7%
Uppercase Letter 527
 
0.1%
Lowercase Letter 105
 
< 0.1%
Math Symbol 9
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 13761
 
8.0%
동 12033
 
7.0%
충 10325
 
6.0%
천 10085
 
5.9%
시 9875
 
5.8%
안 9580
 
5.6%
구 8818
 
5.1%
서 6253
 
3.6%
북 5242
 
3.1%
로 4974
 
2.9%
Other values (594) 80627
47.0%
Uppercase Letter
ValueCountFrequency (%)
B 159
30.2%
A 75
14.2%
I 40
 
7.6%
C 31
 
5.9%
S 27
 
5.1%
T 19
 
3.6%
P 18
 
3.4%
K 17
 
3.2%
G 16
 
3.0%
L 16
 
3.0%
Other values (14) 109
20.7%
Lowercase Letter
ValueCountFrequency (%)
e 24
22.9%
s 15
14.3%
t 11
10.5%
i 10
9.5%
j 9
 
8.6%
r 9
 
8.6%
h 7
 
6.7%
n 5
 
4.8%
o 4
 
3.8%
a 3
 
2.9%
Other values (6) 8
 
7.6%
Decimal Number
ValueCountFrequency (%)
1 32814
34.7%
3 15113
16.0%
0 9629
 
10.2%
2 9287
 
9.8%
5 5462
 
5.8%
6 5138
 
5.4%
4 5126
 
5.4%
7 4287
 
4.5%
8 4040
 
4.3%
9 3760
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 4631
96.8%
. 139
 
2.9%
/ 7
 
0.1%
@ 7
 
0.1%
& 2
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 16577
> 99.9%
] 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
76092
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16579
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2510
100.0%
Math Symbol
ValueCountFrequency (%)
~ 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 211210
55.1%
Hangul 171573
44.7%
Latin 632
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 13761
 
8.0%
동 12033
 
7.0%
충 10325
 
6.0%
천 10085
 
5.9%
시 9875
 
5.8%
안 9580
 
5.6%
구 8818
 
5.1%
서 6253
 
3.6%
북 5242
 
3.1%
로 4974
 
2.9%
Other values (594) 80627
47.0%
Latin
ValueCountFrequency (%)
B 159
25.2%
A 75
 
11.9%
I 40
 
6.3%
C 31
 
4.9%
S 27
 
4.3%
e 24
 
3.8%
T 19
 
3.0%
P 18
 
2.8%
K 17
 
2.7%
G 16
 
2.5%
Other values (30) 206
32.6%
Common
ValueCountFrequency (%)
76092
36.0%
1 32814
15.5%
( 16579
 
7.8%
) 16577
 
7.8%
3 15113
 
7.2%
0 9629
 
4.6%
2 9287
 
4.4%
5 5462
 
2.6%
6 5138
 
2.4%
4 5126
 
2.4%
Other values (11) 19393
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 211842
55.3%
Hangul 171566
44.7%
Compat Jamo 7
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
76092
35.9%
1 32814
15.5%
( 16579
 
7.8%
) 16577
 
7.8%
3 15113
 
7.1%
0 9629
 
4.5%
2 9287
 
4.4%
5 5462
 
2.6%
6 5138
 
2.4%
4 5126
 
2.4%
Other values (51) 20025
 
9.5%
Hangul
ValueCountFrequency (%)
남 13761
 
8.0%
동 12033
 
7.0%
충 10325
 
6.0%
천 10085
 
5.9%
시 9875
 
5.8%
안 9580
 
5.6%
구 8818
 
5.1%
서 6253
 
3.6%
북 5242
 
3.1%
로 4974
 
2.9%
Other values (590) 80620
47.0%
Compat Jamo
ValueCountFrequency (%)
ㅍ 2
28.6%
ㅅ 2
28.6%
ㅑ 2
28.6%
ㅂ 1
14.3%

업종
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반음식점
5244 
휴게음식점
1562 
편의점
1507 
기타
754 
마트
 
471
Other values (2)
 
462

Length

Max length5
Median length5
Mean length4.2516
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제과점
2nd row편의점
3rd row기타
4th row휴게음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 5244
52.4%
휴게음식점 1562
 
15.6%
편의점 1507
 
15.1%
기타 754
 
7.5%
마트 471
 
4.7%
제과점 333
 
3.3%
반찬가게 129
 
1.3%

Length

2023-12-13T05:23:50.592935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:23:50.707160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 5244
52.4%
휴게음식점 1562
 
15.6%
편의점 1507
 
15.1%
기타 754
 
7.5%
마트 471
 
4.7%
제과점 333
 
3.3%
반찬가게 129
 
1.3%

Interactions

2023-12-13T05:23:47.072193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:23:50.811899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구업종
순번1.0000.7130.378
시군구0.7131.0000.535
업종0.3780.5351.000
2023-12-13T05:23:50.919584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구업종
시군구1.0000.227
업종0.2271.000
2023-12-13T05:23:51.007915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구업종
순번1.0000.3860.202
시군구0.3861.0000.227
업종0.2020.2271.000

Missing values

2023-12-13T05:23:47.231855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:23:47.360724image/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

순번시도시군구가맹점명도로명주소업종
82598260충청남도천안시파리바게뜨천안차암점(31085) 충남 천안시 서북구 3공단6로 58-8 103호 (차암동,천안비즈타워)제과점
44004401충청남도천안시지에스25쌍용코리아점(31180) 충남 천안시 서북구 차돌들길 7-3 101,102,103호 (쌍용동,동성빌딩)편의점
25622563충청남도천안시1번지 수산(31080) 충남 천안시 서북구 천안대로 1347 1층 (신당동)기타
78207821충청남도천안시더벤티 천안성성점(31079) 충남 천안시 서북구 성성9로 14 501동 1층 104호 (성성동,천안레이크타운2차푸르지오)휴게음식점
89498950충청남도천안시모아생고기(31187) 충남 천안시 동남구 원성동 543-7 번지일반음식점
1389313894충청남도천안시씨유 천안청수점(31197) 충남 천안시 동남구 청수12로 44 102호 (삼룡동)편의점
59175918충청남도천안시바보찐만도(31243) 충남 천안시 동남구 북면 충절로 1304 1층 2호 (연춘리,서광철물)휴게음식점
88838884충청남도천안시길목식당(31124) 충남 천안시 동남구 신부3길 16-1 1층 (신부동)일반음식점
3233충청남도부여군CU [부여석성점]충청남도 부여군 석성면 증산로39번길 1편의점
1064810649충청남도천안시하원정(31222) 충남 천안시 동남구 광덕면 광덕로 294 (신덕리)일반음식점
순번시도시군구가맹점명도로명주소업종
68936894충청남도천안시송화양꼬치(31103) 충남 천안시 서북구 봉정로 386 101호 (두정동)일반음식점
89728973충청남도천안시왕노가리1000원(31233) 충남 천안시 동남구 목천읍 충절로 881 1층 (신계리)일반음식점
1211312114충청남도천안시탑골(31099) 충남 천안시 서북구 늘푸른3길 27 101호 (두정동,다존빌딩)일반음식점
21952196충청남도천안시한우리농원(31027) 충남 천안시 서북구 입장면 입장로175기타
25142515충청남도천안시우신(31133) 충남 천안시 서북구 동서대로 110-27 1층 106호 (성정동,우신프라자)기타
148149충청남도홍성군서해마트충청남도 홍성군 갈산면상촌로9번길8마트
66296630충청남도천안시하우다(31156) 충남 천안시 서북구 불당30길 30 1층 102호 (불당동)휴게음식점
23892390충청남도천안시중앙시장23호(31151) 충남 천안시 동남구 봉명4길 29 102동 803호 (봉명동,봉서산아이파크)휴게음식점
1356613567충청남도천안시이마트 24 알 (R) 천안신라점(31110) 충남 천안시 서북구 성정공원 2 길 8, 1 층 ( 성정동 )편의점
671672충청남도공주시원마트충청남도 공주시 백제문화로 2129마트