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
Text2
Categorical2
DateTime1

Dataset

Description경상북도 아동급식카드 가맹점 명단입니다. 가맹점 관련 정보(상호명, 주소 등)를 제공합니다. 일부 데이터가 현행화되어 있지 않아 일치하지 않을 수도 있습니다.
Author경상북도
URLhttps://www.data.go.kr/data/15100085/fileData.do

Alerts

순번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
업종 is highly overall correlated with 구분High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2024-04-29 23:00:00.766193
Analysis finished2024-04-29 23:00:03.339894
Duration2.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25230.561
Minimum8
Maximum50133
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-30T08:00:03.413910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8
5-th percentile2508.65
Q112523
median25483
Q337914.75
95-th percentile47587.15
Maximum50133
Range50125
Interquartile range (IQR)25391.75

Descriptive statistics

Standard deviation14525.004
Coefficient of variation (CV)0.57569091
Kurtosis-1.2111117
Mean25230.561
Median Absolute Deviation (MAD)12678.5
Skewness-0.019078804
Sum2.5230561 × 108
Variance2.1097576 × 108
MonotonicityNot monotonic
2024-04-30T08:00:03.580932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
42760 1
 
< 0.1%
24291 1
 
< 0.1%
18037 1
 
< 0.1%
23388 1
 
< 0.1%
42099 1
 
< 0.1%
43131 1
 
< 0.1%
6445 1
 
< 0.1%
44789 1
 
< 0.1%
41979 1
 
< 0.1%
15097 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
8 1
< 0.1%
24 1
< 0.1%
33 1
< 0.1%
49 1
< 0.1%
65 1
< 0.1%
75 1
< 0.1%
82 1
< 0.1%
83 1
< 0.1%
86 1
< 0.1%
90 1
< 0.1%
ValueCountFrequency (%)
50133 1
< 0.1%
50129 1
< 0.1%
50127 1
< 0.1%
50116 1
< 0.1%
50115 1
< 0.1%
50109 1
< 0.1%
50100 1
< 0.1%
50095 1
< 0.1%
50090 1
< 0.1%
50086 1
< 0.1%

가맹점명
Text

Distinct9541
Distinct (%)95.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-30T08:00:03.942946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length27
Mean length6.6051
Min length1

Characters and Unicode

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

Unique

Unique9172 ?
Unique (%)91.7%

Sample

1st row뽀야딸기
2nd row맨인더키친
3rd row백암온천마을영농조합법인
4th row씨유울진근남점
5th row포항수협중매인39
ValueCountFrequency (%)
주식회사 71
 
0.6%
이마트24 70
 
0.6%
세븐일레븐 67
 
0.6%
씨유(cu 53
 
0.4%
지에스25 45
 
0.4%
농업회사법인 30
 
0.3%
지에스(gs)25 30
 
0.3%
경산점 21
 
0.2%
영농조합법인 15
 
0.1%
교촌치킨 13
 
0.1%
Other values (10090) 11503
96.5%
2024-04-30T08:00:04.372288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 2378
 
3.6%
1918
 
2.9%
식 1633
 
2.5%
당 1112
 
1.7%
이 1075
 
1.6%
산 1028
 
1.6%
마 929
 
1.4%
수 741
 
1.1%
동 729
 
1.1%
리 712
 
1.1%
Other values (1012) 53796
81.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 59959
90.8%
Space Separator 1918
 
2.9%
Uppercase Letter 1105
 
1.7%
Decimal Number 1064
 
1.6%
Open Punctuation 636
 
1.0%
Close Punctuation 636
 
1.0%
Lowercase Letter 546
 
0.8%
Other Punctuation 177
 
0.3%
Dash Punctuation 8
 
< 0.1%
Connector Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 2378
 
4.0%
식 1633
 
2.7%
당 1112
 
1.9%
이 1075
 
1.8%
산 1028
 
1.7%
마 929
 
1.5%
수 741
 
1.2%
동 729
 
1.2%
리 712
 
1.2%
대 677
 
1.1%
Other values (939) 48945
81.6%
Uppercase Letter
ValueCountFrequency (%)
S 155
14.0%
C 149
13.5%
G 126
11.4%
U 92
 
8.3%
E 52
 
4.7%
B 48
 
4.3%
T 45
 
4.1%
A 43
 
3.9%
D 43
 
3.9%
N 42
 
3.8%
Other values (16) 310
28.1%
Lowercase Letter
ValueCountFrequency (%)
e 85
15.6%
a 62
11.4%
o 46
 
8.4%
t 34
 
6.2%
n 31
 
5.7%
r 30
 
5.5%
f 28
 
5.1%
c 28
 
5.1%
s 26
 
4.8%
i 25
 
4.6%
Other values (15) 151
27.7%
Decimal Number
ValueCountFrequency (%)
2 358
33.6%
5 203
19.1%
1 120
 
11.3%
4 105
 
9.9%
0 81
 
7.6%
3 58
 
5.5%
8 42
 
3.9%
9 41
 
3.9%
6 28
 
2.6%
7 28
 
2.6%
Other Punctuation
ValueCountFrequency (%)
& 67
37.9%
. 40
22.6%
/ 33
18.6%
, 17
 
9.6%
' 8
 
4.5%
? 8
 
4.5%
! 4
 
2.3%
Space Separator
ValueCountFrequency (%)
1918
100.0%
Open Punctuation
ValueCountFrequency (%)
( 636
100.0%
Close Punctuation
ValueCountFrequency (%)
) 636
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 59947
90.8%
Common 4441
 
6.7%
Latin 1651
 
2.5%
Han 12
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 2378
 
4.0%
식 1633
 
2.7%
당 1112
 
1.9%
이 1075
 
1.8%
산 1028
 
1.7%
마 929
 
1.5%
수 741
 
1.2%
동 729
 
1.2%
리 712
 
1.2%
대 677
 
1.1%
Other values (929) 48933
81.6%
Latin
ValueCountFrequency (%)
S 155
 
9.4%
C 149
 
9.0%
G 126
 
7.6%
U 92
 
5.6%
e 85
 
5.1%
a 62
 
3.8%
E 52
 
3.1%
B 48
 
2.9%
o 46
 
2.8%
T 45
 
2.7%
Other values (41) 791
47.9%
Common
ValueCountFrequency (%)
1918
43.2%
( 636
 
14.3%
) 636
 
14.3%
2 358
 
8.1%
5 203
 
4.6%
1 120
 
2.7%
4 105
 
2.4%
0 81
 
1.8%
& 67
 
1.5%
3 58
 
1.3%
Other values (12) 259
 
5.8%
Han
ValueCountFrequency (%)
家 2
16.7%
愛 2
16.7%
水 1
8.3%
海 1
8.3%
人 1
8.3%
情 1
8.3%
喜 1
8.3%
月 1
8.3%
穰 1
8.3%
持 1
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 59947
90.8%
ASCII 6092
 
9.2%
CJK 12
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 2378
 
4.0%
식 1633
 
2.7%
당 1112
 
1.9%
이 1075
 
1.8%
산 1028
 
1.7%
마 929
 
1.5%
수 741
 
1.2%
동 729
 
1.2%
리 712
 
1.2%
대 677
 
1.1%
Other values (929) 48933
81.6%
ASCII
ValueCountFrequency (%)
1918
31.5%
( 636
 
10.4%
) 636
 
10.4%
2 358
 
5.9%
5 203
 
3.3%
S 155
 
2.5%
C 149
 
2.4%
G 126
 
2.1%
1 120
 
2.0%
4 105
 
1.7%
Other values (63) 1686
27.7%
CJK
ValueCountFrequency (%)
家 2
16.7%
愛 2
16.7%
水 1
8.3%
海 1
8.3%
人 1
8.3%
情 1
8.3%
喜 1
8.3%
月 1
8.3%
穰 1
8.3%
持 1
8.3%

가맹점주소
Text

Distinct9779
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-30T08:00:04.652883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length54
Mean length22.9921
Min length12

Characters and Unicode

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

Unique

Unique9583 ?
Unique (%)95.8%

Sample

1st row경북 고령군 쌍림면 안림3길 44
2nd row경북 경산시 삼성현로 110-123층 (옥산동)
3rd row경북 울진군 온정면 온정1길 119
4th row경북 울진군 근남면 울진북로 163CU근남점
5th row경북 포항시 북구 죽도동557-7
ValueCountFrequency (%)
경북 9936
 
20.1%
포항시 2181
 
4.4%
구미시 1450
 
2.9%
북구 1097
 
2.2%
남구 1084
 
2.2%
경산시 929
 
1.9%
경주시 853
 
1.7%
안동시 635
 
1.3%
김천시 584
 
1.2%
칠곡군 485
 
1.0%
Other values (11767) 30157
61.1%
2024-04-30T08:00:05.112302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
39391
 
17.1%
경 12590
 
5.5%
1 12265
 
5.3%
북 11576
 
5.0%
시 8710
 
3.8%
동 8176
 
3.6%
로 6446
 
2.8%
2 5699
 
2.5%
( 5486
 
2.4%
) 5486
 
2.4%
Other values (571) 114096
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 132584
57.7%
Decimal Number 41655
 
18.1%
Space Separator 39391
 
17.1%
Open Punctuation 5486
 
2.4%
Close Punctuation 5486
 
2.4%
Dash Punctuation 3218
 
1.4%
Other Punctuation 1786
 
0.8%
Uppercase Letter 285
 
0.1%
Math Symbol 18
 
< 0.1%
Lowercase Letter 12
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 12590
 
9.5%
북 11576
 
8.7%
시 8710
 
6.6%
동 8176
 
6.2%
로 6446
 
4.9%
길 4714
 
3.6%
구 4188
 
3.2%
포 2725
 
2.1%
층 2718
 
2.1%
읍 2589
 
2.0%
Other values (521) 68152
51.4%
Uppercase Letter
ValueCountFrequency (%)
B 73
25.6%
A 73
25.6%
L 21
 
7.4%
C 17
 
6.0%
M 12
 
4.2%
H 9
 
3.2%
G 9
 
3.2%
D 8
 
2.8%
J 8
 
2.8%
W 8
 
2.8%
Other values (13) 47
16.5%
Decimal Number
ValueCountFrequency (%)
1 12265
29.4%
2 5699
13.7%
3 4182
 
10.0%
0 3522
 
8.5%
4 3300
 
7.9%
5 3050
 
7.3%
6 2721
 
6.5%
7 2453
 
5.9%
8 2307
 
5.5%
9 2156
 
5.2%
Lowercase Letter
ValueCountFrequency (%)
l 4
33.3%
b 2
16.7%
h 1
 
8.3%
n 1
 
8.3%
i 1
 
8.3%
o 1
 
8.3%
w 1
 
8.3%
e 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 1746
97.8%
. 29
 
1.6%
/ 8
 
0.4%
* 3
 
0.2%
Space Separator
ValueCountFrequency (%)
39391
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5486
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5486
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3218
100.0%
Math Symbol
ValueCountFrequency (%)
~ 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 132583
57.7%
Common 97040
42.2%
Latin 297
 
0.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 12590
 
9.5%
북 11576
 
8.7%
시 8710
 
6.6%
동 8176
 
6.2%
로 6446
 
4.9%
길 4714
 
3.6%
구 4188
 
3.2%
포 2725
 
2.1%
층 2718
 
2.1%
읍 2589
 
2.0%
Other values (520) 68151
51.4%
Latin
ValueCountFrequency (%)
B 73
24.6%
A 73
24.6%
L 21
 
7.1%
C 17
 
5.7%
M 12
 
4.0%
H 9
 
3.0%
G 9
 
3.0%
D 8
 
2.7%
J 8
 
2.7%
W 8
 
2.7%
Other values (21) 59
19.9%
Common
ValueCountFrequency (%)
39391
40.6%
1 12265
 
12.6%
2 5699
 
5.9%
( 5486
 
5.7%
) 5486
 
5.7%
3 4182
 
4.3%
0 3522
 
3.6%
4 3300
 
3.4%
- 3218
 
3.3%
5 3050
 
3.1%
Other values (9) 11441
 
11.8%
Han
ValueCountFrequency (%)
內 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 132583
57.7%
ASCII 97337
42.3%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
39391
40.5%
1 12265
 
12.6%
2 5699
 
5.9%
( 5486
 
5.6%
) 5486
 
5.6%
3 4182
 
4.3%
0 3522
 
3.6%
4 3300
 
3.4%
- 3218
 
3.3%
5 3050
 
3.1%
Other values (40) 11738
 
12.1%
Hangul
ValueCountFrequency (%)
경 12590
 
9.5%
북 11576
 
8.7%
시 8710
 
6.6%
동 8176
 
6.2%
로 6446
 
4.9%
길 4714
 
3.6%
구 4188
 
3.2%
포 2725
 
2.1%
층 2718
 
2.1%
읍 2589
 
2.0%
Other values (520) 68151
51.4%
CJK
ValueCountFrequency (%)
內 1
100.0%

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
BC일반가맹점
7806 
BC주부식가맹점
2194 

Length

Max length8
Median length7
Mean length7.2194
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowBC주부식가맹점
2nd rowBC일반가맹점
3rd rowBC주부식가맹점
4th rowBC일반가맹점
5th rowBC주부식가맹점

Common Values

ValueCountFrequency (%)
BC일반가맹점 7806
78.1%
BC주부식가맹점 2194
 
21.9%

Length

2024-04-30T08:00:05.234861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:05.350245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
bc일반가맹점 7806
78.1%
bc주부식가맹점 2194
 
21.9%

업종
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
일반·휴게음식
6957 
[BC]음료식품
1238 
유통업영리
1033 
음료식품
 
674
유통업비영리
 
97

Length

Max length8
Median length7
Mean length6.705
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row[BC]음료식품
2nd row일반·휴게음식
3rd row[BC]음료식품
4th row유통업영리
5th row[BC]음료식품

Common Values

ValueCountFrequency (%)
일반·휴게음식 6957
69.6%
[BC]음료식품 1238
 
12.4%
유통업영리 1033
 
10.3%
음료식품 674
 
6.7%
유통업비영리 97
 
1.0%
건강식품 1
 
< 0.1%

Length

2024-04-30T08:00:05.502394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:00:05.616616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반·휴게음식 6957
69.6%
bc]음료식품 1238
 
12.4%
유통업영리 1033
 
10.3%
음료식품 674
 
6.7%
유통업비영리 97
 
1.0%
건강식품 1
 
< 0.1%

가입일
Date

Distinct524
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-08-27 00:00:00
Maximum2023-06-30 00:00:00
2024-04-30T08:00:05.738079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T08:00:05.858521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-04-30T08:00:02.993379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-30T08:00:05.937360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분업종
순번1.0000.8910.698
구분0.8911.0000.978
업종0.6980.9781.000
2024-04-30T08:00:06.020260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분업종
구분1.0000.867
업종0.8671.000
2024-04-30T08:00:06.301273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분업종
순번1.0000.7270.462
구분0.7271.0000.867
업종0.4620.8671.000

Missing values

2024-04-30T08:00:03.166694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T08:00:03.277404image/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

순번가맹점명가맹점주소구분업종가입일
4275942760뽀야딸기경북 고령군 쌍림면 안림3길 44BC주부식가맹점[BC]음료식품2023-03-15
1934619347맨인더키친경북 경산시 삼성현로 110-123층 (옥산동)BC일반가맹점일반·휴게음식2021-07-31
4393143932백암온천마을영농조합법인경북 울진군 온정면 온정1길 119BC주부식가맹점[BC]음료식품2023-03-15
881882씨유울진근남점경북 울진군 근남면 울진북로 163CU근남점BC일반가맹점유통업영리2020-08-27
4340343404포항수협중매인39경북 포항시 북구 죽도동557-7BC주부식가맹점[BC]음료식품2023-03-15
1600816009배신떡방아간경북 김천시 감문면태촌리 536-3BC일반가맹점음료식품2021-07-31
3615836159무봤나촌닭 옥동점경북 안동시 복주1길 56(옥동)BC일반가맹점일반·휴게음식2022-11-29
2855128552주막촌경북 청송군 현동면도평리 719BC일반가맹점일반·휴게음식2022-02-24
3810638107대구막창경북 예천군 예천읍동본리 557-6BC일반가맹점일반·휴게음식2023-01-25
2474024741까사푸드경북 영천시 시장로 47,2층 (완산동)BC일반가맹점일반·휴게음식2021-12-23
순번가맹점명가맹점주소구분업종가입일
2817228173네네치킨(금장점)경북 경주시 현곡면 안현로 68-3상가동 105호BC일반가맹점일반·휴게음식2022-02-24
3968739688협신상회경북 포항시 북구 죽도시장2길 1(죽도동)BC주부식가맹점[BC]음료식품2023-03-15
1314313144낙원경북 문경시 앗골길 89(유곡동)BC일반가맹점일반·휴게음식2021-07-31
1321013211금호숯불가든경북 상주시 경상대로 2688(가장동)BC일반가맹점일반·휴게음식2021-07-31
3505435055송천솔뫼국밥경북 안동시 송천1길 146-151층 (송천동)BC일반가맹점일반·휴게음식2022-11-29
1585015851류가네닭개장경북 포항시 북구 양학천로 13-1(용흥동)BC일반가맹점일반·휴게음식2021-07-31
29602961순흥기지떡카페터미널점경북 영주시 대학로 352(가흥동)BC일반가맹점일반·휴게음식2021-07-31
411694117079번 중도매인경북 안동시 풍산읍 유통단지길 100BC주부식가맹점[BC]음료식품2023-03-15
2007720078솔비치카페경북 울진군 울진읍 온양4길 60BC일반가맹점일반·휴게음식2021-07-31
3251632517꼬모경북 포항시 북구 삼호로 601층 (동빈1가)BC일반가맹점음료식품2022-08-31