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. 기준 시군별 아동급식 카드가 사용 가능한 업체 목록으로 편의점, 휴게음식점, 일반음식점, 마트 등 현황 데이터
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=312&beforeMenuCd=DOM_000000201001001000&publicdatapk=15092768

Alerts

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

Reproduction

Analysis started2024-01-09 20:54:20.111955
Analysis finished2024-01-09 20:54:21.353481
Duration1.24 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%
Mean7024.6966
Minimum2
Maximum14073
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-10T05:54:21.416127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile700.95
Q13508.75
median6993
Q310548.25
95-th percentile13348.05
Maximum14073
Range14071
Interquartile range (IQR)7039.5

Descriptive statistics

Standard deviation4057.1972
Coefficient of variation (CV)0.57756191
Kurtosis-1.1980277
Mean7024.6966
Median Absolute Deviation (MAD)3518.5
Skewness0.0020212087
Sum70246966
Variance16460849
MonotonicityNot monotonic
2024-01-10T05:54:21.734691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7613 1
 
< 0.1%
11787 1
 
< 0.1%
10804 1
 
< 0.1%
11098 1
 
< 0.1%
13798 1
 
< 0.1%
2988 1
 
< 0.1%
9491 1
 
< 0.1%
1405 1
 
< 0.1%
4891 1
 
< 0.1%
2513 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 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%
11 1
< 0.1%
12 1
< 0.1%
ValueCountFrequency (%)
14073 1
< 0.1%
14072 1
< 0.1%
14071 1
< 0.1%
14070 1
< 0.1%
14069 1
< 0.1%
14068 1
< 0.1%
14066 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

2024-01-10T05:54:21.841390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:54:21.914613image/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
천안시
8606 
당진시
 
229
서산시
 
188
논산시
 
159
홍성군
 
126
Other values (9)
 
692

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 (%)
천안시 8606
86.1%
당진시 229
 
2.3%
서산시 188
 
1.9%
논산시 159
 
1.6%
홍성군 126
 
1.3%
예산군 122
 
1.2%
공주시 108
 
1.1%
보령시 102
 
1.0%
태안군 77
 
0.8%
부여군 71
 
0.7%
Other values (4) 212
 
2.1%

Length

2024-01-10T05:54:21.995471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
천안시 8606
86.1%
당진시 229
 
2.3%
서산시 188
 
1.9%
논산시 159
 
1.6%
홍성군 126
 
1.3%
예산군 122
 
1.2%
공주시 108
 
1.1%
보령시 102
 
1.0%
태안군 77
 
0.8%
부여군 71
 
0.7%
Other values (4) 212
 
2.1%

가맹점명
Text

Distinct9055
Distinct (%)90.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T05:54:22.243089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length20
Mean length7.1938
Min length1

Characters and Unicode

Total characters71938
Distinct characters993
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

Unique8346 ?
Unique (%)83.5%

Sample

1st row성우식당
2nd row차니분식
3rd row본가네
4th row이슬목장
5th row무지개맥주 천안성정점
ValueCountFrequency (%)
세븐일레븐 243
 
1.9%
지에스25 155
 
1.2%
씨유 145
 
1.1%
gs25 122
 
1.0%
cu 107
 
0.8%
미니스톱 82
 
0.6%
이마트24 65
 
0.5%
주식회사 62
 
0.5%
씨유(cu 51
 
0.4%
49
 
0.4%
Other values (9130) 11571
91.5%
2024-01-10T05:54:22.639131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 3652
 
5.1%
2662
 
3.7%
천 1762
 
2.4%
안 1567
 
2.2%
이 1273
 
1.8%
스 1119
 
1.6%
당 1049
 
1.5%
마 891
 
1.2%
정 860
 
1.2%
성 795
 
1.1%
Other values (983) 56308
78.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 64249
89.3%
Space Separator 2662
 
3.7%
Uppercase Letter 1641
 
2.3%
Decimal Number 1633
 
2.3%
Close Punctuation 701
 
1.0%
Open Punctuation 699
 
1.0%
Lowercase Letter 313
 
0.4%
Other Punctuation 33
 
< 0.1%
Dash Punctuation 5
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 3652
 
5.7%
천 1762
 
2.7%
안 1567
 
2.4%
이 1273
 
2.0%
스 1119
 
1.7%
당 1049
 
1.6%
마 891
 
1.4%
정 860
 
1.3%
성 795
 
1.2%
리 766
 
1.2%
Other values (912) 50515
78.6%
Uppercase Letter
ValueCountFrequency (%)
C 370
22.5%
U 330
20.1%
S 311
19.0%
G 302
18.4%
I 38
 
2.3%
A 33
 
2.0%
E 31
 
1.9%
T 26
 
1.6%
O 23
 
1.4%
F 20
 
1.2%
Other values (16) 157
9.6%
Lowercase Letter
ValueCountFrequency (%)
e 44
14.1%
a 40
12.8%
n 31
 
9.9%
o 21
 
6.7%
d 19
 
6.1%
h 17
 
5.4%
r 15
 
4.8%
t 14
 
4.5%
l 13
 
4.2%
s 13
 
4.2%
Other values (12) 86
27.5%
Decimal Number
ValueCountFrequency (%)
2 633
38.8%
5 510
31.2%
4 123
 
7.5%
1 109
 
6.7%
9 59
 
3.6%
0 55
 
3.4%
3 48
 
2.9%
7 39
 
2.4%
8 37
 
2.3%
6 20
 
1.2%
Other Punctuation
ValueCountFrequency (%)
. 18
54.5%
& 10
30.3%
' 2
 
6.1%
# 2
 
6.1%
, 1
 
3.0%
Close Punctuation
ValueCountFrequency (%)
) 482
68.8%
] 219
31.2%
Open Punctuation
ValueCountFrequency (%)
( 480
68.7%
[ 219
31.3%
Space Separator
ValueCountFrequency (%)
2662
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 64249
89.3%
Common 5734
 
8.0%
Latin 1954
 
2.7%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 3652
 
5.7%
천 1762
 
2.7%
안 1567
 
2.4%
이 1273
 
2.0%
스 1119
 
1.7%
당 1049
 
1.6%
마 891
 
1.4%
정 860
 
1.3%
성 795
 
1.2%
리 766
 
1.2%
Other values (912) 50515
78.6%
Latin
ValueCountFrequency (%)
C 370
18.9%
U 330
16.9%
S 311
15.9%
G 302
15.5%
e 44
 
2.3%
a 40
 
2.0%
I 38
 
1.9%
A 33
 
1.7%
E 31
 
1.6%
n 31
 
1.6%
Other values (38) 424
21.7%
Common
ValueCountFrequency (%)
2662
46.4%
2 633
 
11.0%
5 510
 
8.9%
) 482
 
8.4%
( 480
 
8.4%
] 219
 
3.8%
[ 219
 
3.8%
4 123
 
2.1%
1 109
 
1.9%
9 59
 
1.0%
Other values (12) 238
 
4.2%
Han
ValueCountFrequency (%)
樂 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 64248
89.3%
ASCII 7688
 
10.7%
None 1
 
< 0.1%
CJK 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 3652
 
5.7%
천 1762
 
2.7%
안 1567
 
2.4%
이 1273
 
2.0%
스 1119
 
1.7%
당 1049
 
1.6%
마 891
 
1.4%
정 860
 
1.3%
성 795
 
1.2%
리 766
 
1.2%
Other values (911) 50514
78.6%
ASCII
ValueCountFrequency (%)
2662
34.6%
2 633
 
8.2%
5 510
 
6.6%
) 482
 
6.3%
( 480
 
6.2%
C 370
 
4.8%
U 330
 
4.3%
S 311
 
4.0%
G 302
 
3.9%
] 219
 
2.8%
Other values (60) 1389
18.1%
None
ValueCountFrequency (%)
㈜ 1
100.0%
CJK
ValueCountFrequency (%)
樂 1
100.0%

도로명주소
Text

Distinct9332
Distinct (%)93.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-10T05:54:22.933531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length82
Median length72
Mean length38.3036
Min length13

Characters and Unicode

Total characters383036
Distinct characters662
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

Unique8793 ?
Unique (%)87.9%

Sample

1st row(31179) 충남 천안시 서북구 월봉 1 길 78, ( 쌍용동 )
2nd row(31191) 충남 천안시 동남구 대흥로 13 1동 1층 (구성동)
3rd row(31150) 충남 천안시 동남구 봉명동 52-5
4th row(31066) 충남 천안시 동남구 각원사길 48 (안서동)
5th row(31109) 충남 천안시 서북구 성정두정로 19 1층 101호 (성정동,리슈빌디에스)
ValueCountFrequency (%)
충남 8749
 
10.2%
천안시 8614
 
10.0%
서북구 5124
 
6.0%
3669
 
4.3%
동남구 3436
 
4.0%
1층 3203
 
3.7%
충청남도 1254
 
1.5%
1 1220
 
1.4%
층 936
 
1.1%
길 723
 
0.8%
Other values (7447) 49011
57.0%
2024-01-10T05:54:23.374292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
76081
19.9%
1 32917
 
8.6%
( 16542
 
4.3%
) 16542
 
4.3%
3 15083
 
3.9%
남 13728
 
3.6%
동 11951
 
3.1%
충 10325
 
2.7%
천 10023
 
2.6%
시 9865
 
2.6%
Other values (652) 169979
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 171053
44.7%
Decimal Number 94802
24.8%
Space Separator 76081
19.9%
Close Punctuation 16543
 
4.3%
Open Punctuation 16542
 
4.3%
Other Punctuation 4780
 
1.2%
Dash Punctuation 2566
 
0.7%
Uppercase Letter 545
 
0.1%
Lowercase Letter 112
 
< 0.1%
Math Symbol 12
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 13728
 
8.0%
동 11951
 
7.0%
충 10325
 
6.0%
천 10023
 
5.9%
시 9865
 
5.8%
안 9546
 
5.6%
구 8792
 
5.1%
서 6294
 
3.7%
북 5283
 
3.1%
로 4990
 
2.9%
Other values (590) 80256
46.9%
Uppercase Letter
ValueCountFrequency (%)
B 140
25.7%
A 86
15.8%
I 41
 
7.5%
C 36
 
6.6%
S 29
 
5.3%
T 25
 
4.6%
L 19
 
3.5%
K 18
 
3.3%
F 17
 
3.1%
P 17
 
3.1%
Other values (14) 117
21.5%
Lowercase Letter
ValueCountFrequency (%)
e 24
21.4%
s 17
15.2%
t 12
10.7%
i 12
10.7%
r 11
9.8%
h 9
 
8.0%
j 8
 
7.1%
o 4
 
3.6%
n 4
 
3.6%
a 3
 
2.7%
Other values (7) 8
 
7.1%
Decimal Number
ValueCountFrequency (%)
1 32917
34.7%
3 15083
15.9%
0 9759
 
10.3%
2 9191
 
9.7%
5 5446
 
5.7%
4 5209
 
5.5%
6 5159
 
5.4%
7 4241
 
4.5%
8 4010
 
4.2%
9 3787
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 4625
96.8%
. 139
 
2.9%
@ 7
 
0.1%
/ 6
 
0.1%
& 3
 
0.1%
Close Punctuation
ValueCountFrequency (%)
) 16542
> 99.9%
] 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
76081
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16542
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2566
100.0%
Math Symbol
ValueCountFrequency (%)
~ 12
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 211326
55.2%
Hangul 171053
44.7%
Latin 657
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 13728
 
8.0%
동 11951
 
7.0%
충 10325
 
6.0%
천 10023
 
5.9%
시 9865
 
5.8%
안 9546
 
5.6%
구 8792
 
5.1%
서 6294
 
3.7%
북 5283
 
3.1%
로 4990
 
2.9%
Other values (590) 80256
46.9%
Latin
ValueCountFrequency (%)
B 140
21.3%
A 86
 
13.1%
I 41
 
6.2%
C 36
 
5.5%
S 29
 
4.4%
T 25
 
3.8%
e 24
 
3.7%
L 19
 
2.9%
K 18
 
2.7%
s 17
 
2.6%
Other values (31) 222
33.8%
Common
ValueCountFrequency (%)
76081
36.0%
1 32917
15.6%
( 16542
 
7.8%
) 16542
 
7.8%
3 15083
 
7.1%
0 9759
 
4.6%
2 9191
 
4.3%
5 5446
 
2.6%
4 5209
 
2.5%
6 5159
 
2.4%
Other values (11) 19397
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 211983
55.3%
Hangul 171045
44.7%
Compat Jamo 8
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
76081
35.9%
1 32917
15.5%
( 16542
 
7.8%
) 16542
 
7.8%
3 15083
 
7.1%
0 9759
 
4.6%
2 9191
 
4.3%
5 5446
 
2.6%
4 5209
 
2.5%
6 5159
 
2.4%
Other values (52) 20054
 
9.5%
Hangul
ValueCountFrequency (%)
남 13728
 
8.0%
동 11951
 
7.0%
충 10325
 
6.0%
천 10023
 
5.9%
시 9865
 
5.8%
안 9546
 
5.6%
구 8792
 
5.1%
서 6294
 
3.7%
북 5283
 
3.1%
로 4990
 
2.9%
Other values (582) 80248
46.9%
Compat Jamo
ValueCountFrequency (%)
ㅍ 1
12.5%
ㅑ 1
12.5%
ㅅ 1
12.5%
ㅂ 1
12.5%
ㅇ 1
12.5%
ㅡ 1
12.5%
ㅌ 1
12.5%
ㅏ 1
12.5%

업종
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반음식점
5242 
휴게음식점
1564 
편의점
1507 
기타
792 
마트
 
463
Other values (2)
 
432

Length

Max length5
Median length5
Mean length4.2477
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row휴게음식점
3rd row일반음식점
4th row일반음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 5242
52.4%
휴게음식점 1564
 
15.6%
편의점 1507
 
15.1%
기타 792
 
7.9%
마트 463
 
4.6%
제과점 312
 
3.1%
반찬가게 120
 
1.2%

Length

2024-01-10T05:54:23.497443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:54:23.597666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 5242
52.4%
휴게음식점 1564
 
15.6%
편의점 1507
 
15.1%
기타 792
 
7.9%
마트 463
 
4.6%
제과점 312
 
3.1%
반찬가게 120
 
1.2%

Interactions

2024-01-10T05:54:21.108848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:54:23.672398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구업종
순번1.0000.7130.376
시군구0.7131.0000.531
업종0.3760.5311.000
2024-01-10T05:54:23.748502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종시군구
업종1.0000.224
시군구0.2241.000
2024-01-10T05:54:23.816540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구업종
순번1.0000.3850.201
시군구0.3851.0000.224
업종0.2010.2241.000

Missing values

2024-01-10T05:54:21.212367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:54:21.303395image/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

순번시도시군구가맹점명도로명주소업종
76127613충청남도천안시성우식당(31179) 충남 천안시 서북구 월봉 1 길 78, ( 쌍용동 )일반음식점
97739774충청남도천안시차니분식(31191) 충남 천안시 동남구 대흥로 13 1동 1층 (구성동)휴게음식점
1295212953충청남도천안시본가네(31150) 충남 천안시 동남구 봉명동 52-5일반음식점
54555456충청남도천안시이슬목장(31066) 충남 천안시 동남구 각원사길 48 (안서동)일반음식점
55895590충청남도천안시무지개맥주 천안성정점(31109) 충남 천안시 서북구 성정두정로 19 1층 101호 (성정동,리슈빌디에스)일반음식점
1415충청남도부여군남경 중화요리충청남도 부여군 부여읍 궁남로 6일반음식점
1088610887충청남도천안시(주)농협대전유통천안점(31110) 충남 천안시 서북구 성정공원7길 9 101호 (성정동)마트
30913092충청남도천안시세븐일레븐 천안풍세산단점(31217) 충남 천안시 동남구 풍세면 풍세산단4로 12-1 1층 4,5호 (보성리)편의점
46114612충청남도천안시씨유(CU)천안불당하이빌점(31163) 충남 천안시 서북구 시청로 73 불당마을동일하이빌APT,상가1동동 1층 106호 (불당동)편의점
57805781충청남도천안시지에스25 월봉세상점(31171) 충남 천안시 서북구 월봉4로 120-16 상가동 1층 102호 (쌍용동)편의점
순번시도시군구가맹점명도로명주소업종
81298130충청남도천안시분식샵(31126) 충남 천안시 동남구 원성 4 길 25, 1 층 ( 원성동 )휴게음식점
1265812659충청남도천안시맘스터치 천안풍세산단점(31217) 충남 천안시 동남구 풍세면 풍세산단로 18-16, 1 층 ( 보성리 )휴게음식점
79977998충청남도천안시7 단지과일야채(31166) 충남 천안시 서북구 쌍용동 1284 주공아파트 7 단지상가 106 호기타
34963497충청남도천안시와카와리이치반(330160) 충남 천안시 동남구 신부동 367-24 3호상가휴게음식점
525526충청남도청양군비에이치씨청양점충청남도 청양군 청양읍 중앙로 84일반음식점
34793480충청남도천안시하루식탁(31123) 충남 천안시 동남구 먹거리8길 25 2층 (신부동)일반음식점
86238624충청남도천안시달콤아이스크림(31089) 충남 천안시 서북구 두정고 5 길 14, 1 층 ( 두정동 )기타
75267527충청남도천안시홍계원(31192) 충남 천안시 동남구 충절로 249 (구성동)일반음식점
123124충청남도홍성군덕꾼오리바베큐 내포신도시점충남 홍성군 홍북읍 의향로 267 (신경리)105호일반음식점
51465147충청남도천안시천안칼국수(31142) 충남 천안시 서북구 성정4길 36 1층 (성정동)일반음식점