Overview

Dataset statistics

Number of variables13
Number of observations2655
Missing cells0
Missing cells (%)0.0%
Duplicate rows5
Duplicate rows (%)0.2%
Total size in memory280.1 KiB
Average record size in memory108.0 B

Variable types

Text4
Categorical5
Numeric3
DateTime1

Dataset

Description충북 아동급식카드 현황에 대한 데이터로 가맹점명, 유형코드, 시도명, 시군구명, 도로명주소,.소재지주소 위도, 경도, 전화번호 관리기관명 등을 제공합니다.
URLhttps://www.data.go.kr/data/15033244/fileData.do

Alerts

시도명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 5 (0.2%) duplicate rowsDuplicates
관리기관전화번호 is highly overall correlated with 시군구코드 and 4 other fieldsHigh correlation
시군구명 is highly overall correlated with 시군구코드 and 4 other fieldsHigh correlation
관리기관명 is highly overall correlated with 시군구코드 and 4 other fieldsHigh correlation
시군구코드 is highly overall correlated with 위도 and 4 other fieldsHigh correlation
위도 is highly overall correlated with 시군구코드 and 4 other fieldsHigh correlation
경도 is highly overall correlated with 시군구코드 and 4 other fieldsHigh correlation
가맹점유형코드 is highly imbalanced (72.5%)Imbalance

Reproduction

Analysis started2023-12-12 03:03:55.599621
Analysis finished2023-12-12 03:03:59.220267
Duration3.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

가맹점명
Text

Distinct2447
Distinct (%)92.2%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
2023-12-12T12:03:59.490033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length6.6263653
Min length1

Characters and Unicode

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

Unique

Unique2345 ?
Unique (%)88.3%

Sample

1st row(주)맘스터치 충북대중문점
2nd row1978 덮밥앤볶음밥
3rd row1978 패밀리
4th row24시 김밥친구
5th row25시 해장국 사천점
ValueCountFrequency (%)
파리바게뜨 53
 
1.5%
뚜레쥬르 41
 
1.1%
맘스터치 35
 
1.0%
롯데리아 31
 
0.9%
용암점 30
 
0.8%
파리바게트 24
 
0.7%
본죽 23
 
0.6%
율량점 22
 
0.6%
김밥천국 22
 
0.6%
분평점 20
 
0.6%
Other values (2392) 3267
91.6%
2023-12-12T12:04:00.067518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
913
 
5.2%
점 770
 
4.4%
이 348
 
2.0%
치 333
 
1.9%
리 333
 
1.9%
마 320
 
1.8%
킨 248
 
1.4%
식 244
 
1.4%
밥 232
 
1.3%
스 209
 
1.2%
Other values (713) 13643
77.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16073
91.4%
Space Separator 913
 
5.2%
Decimal Number 174
 
1.0%
Uppercase Letter 159
 
0.9%
Lowercase Letter 80
 
0.5%
Other Punctuation 72
 
0.4%
Open Punctuation 60
 
0.3%
Close Punctuation 60
 
0.3%
Other Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 770
 
4.8%
이 348
 
2.2%
치 333
 
2.1%
리 333
 
2.1%
마 320
 
2.0%
킨 248
 
1.5%
식 244
 
1.5%
밥 232
 
1.4%
스 209
 
1.3%
트 188
 
1.2%
Other values (650) 12848
79.9%
Uppercase Letter
ValueCountFrequency (%)
B 38
23.9%
H 17
10.7%
C 16
10.1%
O 12
 
7.5%
Q 11
 
6.9%
D 8
 
5.0%
K 7
 
4.4%
S 7
 
4.4%
L 6
 
3.8%
E 5
 
3.1%
Other values (11) 32
20.1%
Lowercase Letter
ValueCountFrequency (%)
e 9
11.2%
o 8
10.0%
n 8
10.0%
i 7
8.8%
a 7
8.8%
c 6
 
7.5%
h 6
 
7.5%
s 6
 
7.5%
b 4
 
5.0%
r 3
 
3.8%
Other values (11) 16
20.0%
Decimal Number
ValueCountFrequency (%)
2 51
29.3%
1 25
14.4%
5 21
12.1%
9 16
 
9.2%
3 15
 
8.6%
6 11
 
6.3%
7 10
 
5.7%
8 10
 
5.7%
4 8
 
4.6%
0 7
 
4.0%
Other Punctuation
ValueCountFrequency (%)
& 41
56.9%
, 13
 
18.1%
. 12
 
16.7%
' 3
 
4.2%
＆ 1
 
1.4%
! 1
 
1.4%
/ 1
 
1.4%
Space Separator
ValueCountFrequency (%)
913
100.0%
Open Punctuation
ValueCountFrequency (%)
( 60
100.0%
Close Punctuation
ValueCountFrequency (%)
) 60
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16073
91.4%
Common 1279
 
7.3%
Latin 239
 
1.4%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 770
 
4.8%
이 348
 
2.2%
치 333
 
2.1%
리 333
 
2.1%
마 320
 
2.0%
킨 248
 
1.5%
식 244
 
1.5%
밥 232
 
1.4%
스 209
 
1.3%
트 188
 
1.2%
Other values (649) 12848
79.9%
Latin
ValueCountFrequency (%)
B 38
 
15.9%
H 17
 
7.1%
C 16
 
6.7%
O 12
 
5.0%
Q 11
 
4.6%
e 9
 
3.8%
o 8
 
3.3%
D 8
 
3.3%
n 8
 
3.3%
i 7
 
2.9%
Other values (32) 105
43.9%
Common
ValueCountFrequency (%)
913
71.4%
( 60
 
4.7%
) 60
 
4.7%
2 51
 
4.0%
& 41
 
3.2%
1 25
 
2.0%
5 21
 
1.6%
9 16
 
1.3%
3 15
 
1.2%
, 13
 
1.0%
Other values (10) 64
 
5.0%
Han
ValueCountFrequency (%)
家 1
50.0%
味 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16071
91.3%
ASCII 1517
 
8.6%
None 3
 
< 0.1%
CJK 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
913
60.2%
( 60
 
4.0%
) 60
 
4.0%
2 51
 
3.4%
& 41
 
2.7%
B 38
 
2.5%
1 25
 
1.6%
5 21
 
1.4%
H 17
 
1.1%
9 16
 
1.1%
Other values (51) 275
 
18.1%
Hangul
ValueCountFrequency (%)
점 770
 
4.8%
이 348
 
2.2%
치 333
 
2.1%
리 333
 
2.1%
마 320
 
2.0%
킨 248
 
1.5%
식 244
 
1.5%
밥 232
 
1.4%
스 209
 
1.3%
트 188
 
1.2%
Other values (648) 12846
79.9%
None
ValueCountFrequency (%)
㈜ 2
66.7%
＆ 1
33.3%
CJK
ValueCountFrequency (%)
家 1
50.0%
味 1
50.0%

가맹점유형코드
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
1
2433 
2
 
213
3
 
9

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 2433
91.6%
2 213
 
8.0%
3 9
 
0.3%

Length

2023-12-12T12:04:00.356526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:04:00.465873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2433
91.6%
2 213
 
8.0%
3 9
 
0.3%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
충청북도
2655 

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 (%)
충청북도 2655
100.0%

Length

2023-12-12T12:04:00.608025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:04:00.754035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 2655
100.0%

시군구명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
청주시
1513 
단양군
656 
제천시
209 
충주시
168 
증평군
 
109

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 (%)
청주시 1513
57.0%
단양군 656
24.7%
제천시 209
 
7.9%
충주시 168
 
6.3%
증평군 109
 
4.1%

Length

2023-12-12T12:04:00.903727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:04:01.051586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청주시 1513
57.0%
단양군 656
24.7%
제천시 209
 
7.9%
충주시 168
 
6.3%
증평군 109
 
4.1%

시군구코드
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean43312.332
Minimum43111
Maximum43800
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.5 KiB
2023-12-12T12:04:01.175315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum43111
5-th percentile43111
Q143112
median43114
Q343745
95-th percentile43800
Maximum43800
Range689
Interquartile range (IQR)633

Descriptive statistics

Standard deviation305.68234
Coefficient of variation (CV)0.0070576283
Kurtosis-1.1145471
Mean43312.332
Median Absolute Deviation (MAD)3
Skewness0.93600711
Sum1.1499424 × 108
Variance93441.691
MonotonicityNot monotonic
2023-12-12T12:04:01.358041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
43800 656
24.7%
43113 432
16.3%
43112 402
15.1%
43111 400
15.1%
43114 279
10.5%
43150 209
 
7.9%
43130 168
 
6.3%
43745 109
 
4.1%
ValueCountFrequency (%)
43111 400
15.1%
43112 402
15.1%
43113 432
16.3%
43114 279
10.5%
43130 168
 
6.3%
43150 209
 
7.9%
43745 109
 
4.1%
43800 656
24.7%
ValueCountFrequency (%)
43800 656
24.7%
43745 109
 
4.1%
43150 209
 
7.9%
43130 168
 
6.3%
43114 279
10.5%
43113 432
16.3%
43112 402
15.1%
43111 400
15.1%

소재지도로명주소
Text

Distinct2271
Distinct (%)85.5%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
2023-12-12T12:04:01.865905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length41
Mean length26.458757
Min length12

Characters and Unicode

Total characters70248
Distinct characters415
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

Unique1993 ?
Unique (%)75.1%

Sample

1st row충청북도 청주시 서원구 내수동로102번길 36 (사창동)
2nd row충청북도 청주시 상당구 용암북로94번길 20-11 (용암동)
3rd row충청북도 청주시 흥덕구 진재로28번길 6-1 (복대동, 연송빌라)
4th row충청북도 청주시 청원구 안덕벌로52번길 6-4 (내덕동)
5th row충청북도 청주시 청원구 율봉로 54 (사천동)
ValueCountFrequency (%)
충청북도 2654
 
17.3%
청주시 1513
 
9.9%
단양군 656
 
4.3%
흥덕구 432
 
2.8%
서원구 403
 
2.6%
상당구 400
 
2.6%
단양읍 339
 
2.2%
청원구 278
 
1.8%
제천시 209
 
1.4%
충주시 168
 
1.1%
Other values (2202) 8263
54.0%
2023-12-12T12:04:02.576081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12662
 
18.0%
청 4609
 
6.6%
충 2924
 
4.2%
도 2761
 
3.9%
북 2717
 
3.9%
로 2257
 
3.2%
1 2142
 
3.0%
시 1940
 
2.8%
주 1800
 
2.6%
) 1733
 
2.5%
Other values (405) 34703
49.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 44165
62.9%
Space Separator 12662
 
18.0%
Decimal Number 8947
 
12.7%
Close Punctuation 1733
 
2.5%
Open Punctuation 1733
 
2.5%
Dash Punctuation 529
 
0.8%
Other Punctuation 442
 
0.6%
Uppercase Letter 22
 
< 0.1%
Letter Number 10
 
< 0.1%
Lowercase Letter 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 4609
 
10.4%
충 2924
 
6.6%
도 2761
 
6.3%
북 2717
 
6.2%
로 2257
 
5.1%
시 1940
 
4.4%
주 1800
 
4.1%
동 1681
 
3.8%
구 1585
 
3.6%
길 1195
 
2.7%
Other values (372) 20696
46.9%
Uppercase Letter
ValueCountFrequency (%)
K 4
18.2%
S 3
13.6%
I 2
9.1%
B 2
9.1%
C 2
9.1%
O 2
9.1%
L 1
 
4.5%
F 1
 
4.5%
R 1
 
4.5%
M 1
 
4.5%
Other values (3) 3
13.6%
Decimal Number
ValueCountFrequency (%)
1 2142
23.9%
2 1345
15.0%
3 928
10.4%
4 848
 
9.5%
5 699
 
7.8%
6 646
 
7.2%
7 645
 
7.2%
8 595
 
6.7%
0 570
 
6.4%
9 529
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
o 2
40.0%
e 2
40.0%
d 1
20.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 6
60.0%
Ⅰ 4
40.0%
Space Separator
ValueCountFrequency (%)
12662
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1733
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1733
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 529
100.0%
Other Punctuation
ValueCountFrequency (%)
, 442
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 44165
62.9%
Common 26046
37.1%
Latin 37
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 4609
 
10.4%
충 2924
 
6.6%
도 2761
 
6.3%
북 2717
 
6.2%
로 2257
 
5.1%
시 1940
 
4.4%
주 1800
 
4.1%
동 1681
 
3.8%
구 1585
 
3.6%
길 1195
 
2.7%
Other values (372) 20696
46.9%
Latin
ValueCountFrequency (%)
Ⅱ 6
16.2%
Ⅰ 4
10.8%
K 4
10.8%
S 3
 
8.1%
I 2
 
5.4%
o 2
 
5.4%
e 2
 
5.4%
B 2
 
5.4%
C 2
 
5.4%
O 2
 
5.4%
Other values (8) 8
21.6%
Common
ValueCountFrequency (%)
12662
48.6%
1 2142
 
8.2%
) 1733
 
6.7%
( 1733
 
6.7%
2 1345
 
5.2%
3 928
 
3.6%
4 848
 
3.3%
5 699
 
2.7%
6 646
 
2.5%
7 645
 
2.5%
Other values (5) 2665
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 44165
62.9%
ASCII 26073
37.1%
Number Forms 10
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12662
48.6%
1 2142
 
8.2%
) 1733
 
6.6%
( 1733
 
6.6%
2 1345
 
5.2%
3 928
 
3.6%
4 848
 
3.3%
5 699
 
2.7%
6 646
 
2.5%
7 645
 
2.5%
Other values (21) 2692
 
10.3%
Hangul
ValueCountFrequency (%)
청 4609
 
10.4%
충 2924
 
6.6%
도 2761
 
6.3%
북 2717
 
6.2%
로 2257
 
5.1%
시 1940
 
4.4%
주 1800
 
4.1%
동 1681
 
3.8%
구 1585
 
3.6%
길 1195
 
2.7%
Other values (372) 20696
46.9%
Number Forms
ValueCountFrequency (%)
Ⅱ 6
60.0%
Ⅰ 4
40.0%

소재지주소
Text

Distinct2212
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
2023-12-12T12:04:03.066158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length32
Mean length20.957439
Min length14

Characters and Unicode

Total characters55642
Distinct characters178
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

Unique1900 ?
Unique (%)71.6%

Sample

1st row충청북도 청주시 서원구 사창동 217-22
2nd row충청북도 청주시 상당구 용암동 2452
3rd row충청북도 청주시 흥덕구 복대동 3004
4th row충청북도 청주시 청원구 내덕동 111-2
5th row충청북도 청주시 청원구 사천동 233-197
ValueCountFrequency (%)
충청북도 2655
20.2%
청주시 1513
 
11.5%
단양군 656
 
5.0%
흥덕구 432
 
3.3%
서원구 403
 
3.1%
상당구 400
 
3.0%
단양읍 339
 
2.6%
청원구 278
 
2.1%
제천시 209
 
1.6%
용암동 174
 
1.3%
Other values (2180) 6074
46.2%
2023-12-12T12:04:03.754185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10478
18.8%
청 4488
 
8.1%
충 2869
 
5.2%
도 2793
 
5.0%
북 2674
 
4.8%
1 1966
 
3.5%
시 1892
 
3.4%
동 1862
 
3.3%
주 1726
 
3.1%
구 1523
 
2.7%
Other values (168) 23371
42.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 34066
61.2%
Space Separator 10478
 
18.8%
Decimal Number 9953
 
17.9%
Dash Punctuation 1137
 
2.0%
Other Punctuation 6
 
< 0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 4488
 
13.2%
충 2869
 
8.4%
도 2793
 
8.2%
북 2674
 
7.8%
시 1892
 
5.6%
동 1862
 
5.5%
주 1726
 
5.1%
구 1523
 
4.5%
단 1028
 
3.0%
양 1023
 
3.0%
Other values (153) 12188
35.8%
Decimal Number
ValueCountFrequency (%)
1 1966
19.8%
2 1312
13.2%
3 974
9.8%
4 928
9.3%
5 913
9.2%
6 893
9.0%
7 824
8.3%
8 732
 
7.4%
0 711
 
7.1%
9 700
 
7.0%
Space Separator
ValueCountFrequency (%)
10478
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1137
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 34066
61.2%
Common 21576
38.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 4488
 
13.2%
충 2869
 
8.4%
도 2793
 
8.2%
북 2674
 
7.8%
시 1892
 
5.6%
동 1862
 
5.5%
주 1726
 
5.1%
구 1523
 
4.5%
단 1028
 
3.0%
양 1023
 
3.0%
Other values (153) 12188
35.8%
Common
ValueCountFrequency (%)
10478
48.6%
1 1966
 
9.1%
2 1312
 
6.1%
- 1137
 
5.3%
3 974
 
4.5%
4 928
 
4.3%
5 913
 
4.2%
6 893
 
4.1%
7 824
 
3.8%
8 732
 
3.4%
Other values (5) 1419
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 34066
61.2%
ASCII 21576
38.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10478
48.6%
1 1966
 
9.1%
2 1312
 
6.1%
- 1137
 
5.3%
3 974
 
4.5%
4 928
 
4.3%
5 913
 
4.2%
6 893
 
4.1%
7 824
 
3.8%
8 732
 
3.4%
Other values (5) 1419
 
6.6%
Hangul
ValueCountFrequency (%)
청 4488
 
13.2%
충 2869
 
8.4%
도 2793
 
8.2%
북 2674
 
7.8%
시 1892
 
5.6%
동 1862
 
5.5%
주 1726
 
5.1%
구 1523
 
4.5%
단 1028
 
3.0%
양 1023
 
3.0%
Other values (153) 12188
35.8%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct2237
Distinct (%)84.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.78939
Minimum36.457434
Maximum37.200835
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.5 KiB
2023-12-12T12:04:03.968617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.457434
5-th percentile36.610803
Q136.625792
median36.664578
Q336.982507
95-th percentile37.135288
Maximum37.200835
Range0.74340094
Interquartile range (IQR)0.35671527

Descriptive statistics

Standard deviation0.19116938
Coefficient of variation (CV)0.0051963182
Kurtosis-1.3533574
Mean36.78939
Median Absolute Deviation (MAD)0.0536896
Skewness0.53724901
Sum97675.83
Variance0.036545731
MonotonicityNot monotonic
2023-12-12T12:04:04.174149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36.98250708 12
 
0.5%
36.98307724 10
 
0.4%
36.92132634 6
 
0.2%
36.98510442 6
 
0.2%
37.152066 6
 
0.2%
36.98249125 6
 
0.2%
36.63107128 5
 
0.2%
37.00077549 5
 
0.2%
36.61848679 5
 
0.2%
36.98575139 5
 
0.2%
Other values (2227) 2589
97.5%
ValueCountFrequency (%)
36.45743443 1
< 0.1%
36.48588662 1
< 0.1%
36.4868 1
< 0.1%
36.49985244 1
< 0.1%
36.51485945 1
< 0.1%
36.51541702 1
< 0.1%
36.51560157 1
< 0.1%
36.51575808 1
< 0.1%
36.5161654 1
< 0.1%
36.51628991 1
< 0.1%
ValueCountFrequency (%)
37.20083537 1
< 0.1%
37.1844962 1
< 0.1%
37.18050646 2
0.1%
37.16389738 1
< 0.1%
37.16343019 1
< 0.1%
37.16267494 1
< 0.1%
37.16040877 1
< 0.1%
37.16031888 1
< 0.1%
37.1598583 2
0.1%
37.15970268 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct2235
Distinct (%)84.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.78468
Minimum127.3177
Maximum128.61235
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.5 KiB
2023-12-12T12:04:04.402638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.3177
5-th percentile127.42972
Q1127.4731
median127.50782
Q3128.22763
95-th percentile128.37081
Maximum128.61235
Range1.2946481
Interquartile range (IQR)0.7545264

Descriptive statistics

Standard deviation0.39516217
Coefficient of variation (CV)0.0030924066
Kurtosis-1.4539662
Mean127.78468
Median Absolute Deviation (MAD)0.0712263
Skewness0.60871458
Sum339268.31
Variance0.15615314
MonotonicityNot monotonic
2023-12-12T12:04:04.626604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.3697722 12
 
0.5%
128.3700532 10
 
0.4%
128.3582642 6
 
0.2%
128.217006 6
 
0.2%
128.3699808 6
 
0.2%
128.3701478 6
 
0.2%
128.3418344 5
 
0.2%
127.5057289 5
 
0.2%
128.2988377 5
 
0.2%
128.3698244 5
 
0.2%
Other values (2225) 2589
97.5%
ValueCountFrequency (%)
127.3177039 1
 
< 0.1%
127.3270419 1
 
< 0.1%
127.3272093 1
 
< 0.1%
127.327297 1
 
< 0.1%
127.3280463 1
 
< 0.1%
127.3282701 1
 
< 0.1%
127.3282788 1
 
< 0.1%
127.3287551 2
0.1%
127.3296159 4
0.2%
127.3312812 1
 
< 0.1%
ValueCountFrequency (%)
128.612352 1
< 0.1%
128.6106143 1
< 0.1%
128.5037498 1
< 0.1%
128.5026289 1
< 0.1%
128.499273 1
< 0.1%
128.4971228 1
< 0.1%
128.4968576 1
< 0.1%
128.4947017 1
< 0.1%
128.4929233 1
< 0.1%
128.4928193 1
< 0.1%

전화번호
Text

Distinct2467
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
2023-12-12T12:04:05.077513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.779284
Min length9

Characters and Unicode

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

Unique2373 ?
Unique (%)89.4%

Sample

1st row043-265-9770
2nd row043-293-7779
3rd row043-239-8885
4th row043-213-9889
5th row043-217-8825
ValueCountFrequency (%)
043-000-0000 64
 
2.4%
02-0000-0000 19
 
0.7%
02-1111-1111 6
 
0.2%
043-1111-1111 5
 
0.2%
043-111-1111 4
 
0.2%
043-652-3200 4
 
0.2%
043-421-2643 3
 
0.1%
02-111-1111 3
 
0.1%
043-0000-0000 3
 
0.1%
043-268-8686 3
 
0.1%
Other values (2457) 2541
95.7%
2023-12-12T12:04:05.709071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 5101
16.3%
0 4494
14.4%
3 4272
13.7%
4 3939
12.6%
2 3790
12.1%
8 1974
 
6.3%
7 1755
 
5.6%
1 1734
 
5.5%
5 1553
 
5.0%
9 1506
 
4.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 26173
83.7%
Dash Punctuation 5101
 
16.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 4494
17.2%
3 4272
16.3%
4 3939
15.0%
2 3790
14.5%
8 1974
7.5%
7 1755
 
6.7%
1 1734
 
6.6%
5 1553
 
5.9%
9 1506
 
5.8%
6 1156
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 5101
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 31274
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 5101
16.3%
0 4494
14.4%
3 4272
13.7%
4 3939
12.6%
2 3790
12.1%
8 1974
 
6.3%
7 1755
 
5.6%
1 1734
 
5.5%
5 1553
 
5.0%
9 1506
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 31274
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 5101
16.3%
0 4494
14.4%
3 4272
13.7%
4 3939
12.6%
2 3790
12.1%
8 1974
 
6.3%
7 1755
 
5.6%
1 1734
 
5.5%
5 1553
 
5.0%
9 1506
 
4.8%

관리기관명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
충청북도 청주시
1513 
충청북도 단양군
656 
충청북도 제천시
209 
충청북도 충주시
168 
충청북도 증평군
 
109

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청북도 청주시
2nd row충청북도 청주시
3rd row충청북도 청주시
4th row충청북도 청주시
5th row충청북도 청주시

Common Values

ValueCountFrequency (%)
충청북도 청주시 1513
57.0%
충청북도 단양군 656
24.7%
충청북도 제천시 209
 
7.9%
충청북도 충주시 168
 
6.3%
충청북도 증평군 109
 
4.1%

Length

2023-12-12T12:04:05.925399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:04:06.073284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 2655
50.0%
청주시 1513
28.5%
단양군 656
 
12.4%
제천시 209
 
3.9%
충주시 168
 
3.2%
증평군 109
 
2.1%

관리기관전화번호
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
043-201-1925
1513 
043-420-2146
656 
043-641-5415
209 
043-850-6775
168 
043-835-4835
 
109

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row043-201-1925
2nd row043-201-1925
3rd row043-201-1925
4th row043-201-1925
5th row043-201-1925

Common Values

ValueCountFrequency (%)
043-201-1925 1513
57.0%
043-420-2146 656
24.7%
043-641-5415 209
 
7.9%
043-850-6775 168
 
6.3%
043-835-4835 109
 
4.1%

Length

2023-12-12T12:04:06.233554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:04:06.375598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
043-201-1925 1513
57.0%
043-420-2146 656
24.7%
043-641-5415 209
 
7.9%
043-850-6775 168
 
6.3%
043-835-4835 109
 
4.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.9 KiB
Minimum2022-04-01 00:00:00
Maximum2022-04-01 00:00:00
2023-12-12T12:04:06.524792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:04:06.656024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T12:03:58.384970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:57.481055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:57.933928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:58.524850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:57.628986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:58.078758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:58.669133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:57.788852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:03:58.246922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:04:06.777448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가맹점유형코드시군구명시군구코드위도경도관리기관명관리기관전화번호
가맹점유형코드1.0000.3920.0370.3930.4690.3920.392
시군구명0.3921.0001.0000.9880.9981.0001.000
시군구코드0.0371.0001.0000.9670.9971.0001.000
위도0.3930.9880.9671.0000.9240.9880.988
경도0.4690.9980.9970.9241.0000.9980.998
관리기관명0.3921.0001.0000.9880.9981.0001.000
관리기관전화번호0.3921.0001.0000.9880.9981.0001.000
2023-12-12T12:04:06.919316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관전화번호시군구명관리기관명가맹점유형코드
관리기관전화번호1.0001.0001.0000.322
시군구명1.0001.0001.0000.322
관리기관명1.0001.0001.0000.322
가맹점유형코드0.3220.3220.3221.000
2023-12-12T12:04:07.048231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구코드위도경도가맹점유형코드시군구명관리기관명관리기관전화번호
시군구코드1.0000.8680.7150.0570.9990.9990.999
위도0.8681.0000.7190.2570.8400.8400.840
경도0.7150.7191.0000.3190.9340.9340.934
가맹점유형코드0.0570.2570.3191.0000.3220.3220.322
시군구명0.9990.8400.9340.3221.0001.0001.000
관리기관명0.9990.8400.9340.3221.0001.0001.000
관리기관전화번호0.9990.8400.9340.3221.0001.0001.000

Missing values

2023-12-12T12:03:58.865221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:03:59.121733image/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(주)맘스터치 충북대중문점1충청북도청주시43112충청북도 청주시 서원구 내수동로102번길 36 (사창동)충청북도 청주시 서원구 사창동 217-2236.632675127.456859043-265-9770충청북도 청주시043-201-19252022-04-01
11978 덮밥앤볶음밥1충청북도청주시43111충청북도 청주시 상당구 용암북로94번길 20-11 (용암동)충청북도 청주시 상당구 용암동 245236.6187127.509319043-293-7779충청북도 청주시043-201-19252022-04-01
21978 패밀리1충청북도청주시43113충청북도 청주시 흥덕구 진재로28번길 6-1 (복대동, 연송빌라)충청북도 청주시 흥덕구 복대동 300436.633543127.430109043-239-8885충청북도 청주시043-201-19252022-04-01
324시 김밥친구1충청북도청주시43114충청북도 청주시 청원구 안덕벌로52번길 6-4 (내덕동)충청북도 청주시 청원구 내덕동 111-236.657684127.494315043-213-9889충청북도 청주시043-201-19252022-04-01
425시 해장국 사천점1충청북도청주시43114충청북도 청주시 청원구 율봉로 54 (사천동)충청북도 청주시 청원구 사천동 233-19736.664164127.47638043-217-8825충청북도 청주시043-201-19252022-04-01
525시김밥1충청북도청주시43111충청북도 청주시 상당구 쇠내로 101 (금천동)충청북도 청주시 상당구 금천동 100-736.624303127.504762043-256-3578충청북도 청주시043-201-19252022-04-01
625시해장국1충청북도청주시43111충청북도 청주시 상당구 쇠내로 34 (금천동)충청북도 청주시 상당구 금천동 158-5036.624631127.497607043-225-0025충청북도 청주시043-201-19252022-04-01
725시해장국1충청북도청주시43112충청북도 청주시 서원구 구룡산로 332충청북도 청주시 서원구 수곡동 17736.618309127.481216043-285-0310충청북도 청주시043-201-19252022-04-01
82모(mo)네1충청북도청주시43113충청북도 청주시 흥덕구 장구봉로 141 (복대동)충청북도 청주시 흥덕구 복대동 239336.624745127.449039043-000-0000충청북도 청주시043-201-19252022-04-01
9357짜장.짬뽕1충청북도청주시43114충청북도 청주시 청원구 내덕로 19 (내덕동)충청북도 청주시 청원구 내덕동 647-1236.656571127.482797043-225-3357충청북도 청주시043-201-19252022-04-01
가맹점명가맹점유형코드시도명시군구명시군구코드소재지도로명주소소재지주소위도경도전화번호관리기관명관리기관전화번호데이터기준일자
2645화창가든1충청북도단양군43800충청북도 단양군 영춘면 강변로 487충청북도 단양군 영춘면 하리 426-337.069625128.486191043-423-7201충청북도 단양군043-420-21462022-04-01
2646황금물결1충청북도단양군43800충청북도 단양군 영춘면 남천1길 80충청북도 단양군 영춘면 하리 134-537.060528128.499273043-422-7005충청북도 단양군043-420-21462022-04-01
2647황금족발1충청북도단양군43800충청북도 단양군 단양읍 별곡8길 9충청북도 단양군 단양읍 별곡리 51936.984123128.369733043-422-4846충청북도 단양군043-420-21462022-04-01
2648황둔반점1충청북도단양군43800충청북도 단양군 매포읍 평동24길 8충청북도 단양군 매포읍 평동리 113937.03422128.29907043-422-1225충청북도 단양군043-420-21462022-04-01
2649황장산쉼터1충청북도단양군43800충청북도 단양군 대강면 선암계곡로 11충청북도 단양군 대강면 방곡리 7636.817497128.316188054-552-8080충청북도 단양군043-420-21462022-04-01
2650황정기사식당1충청북도단양군43800충청북도 단양군 대강면 온천로 191충청북도 단양군 대강면 황정리 192-136.881532128.358719043-0000-0000충청북도 단양군043-420-21462022-04-01
2651황하수식당1충청북도단양군43800충청북도 단양군 매포읍 단양로 1860충청북도 단양군 매포읍 평동리 146-137.030054128.308355043-422-3880충청북도 단양군043-420-21462022-04-01
2652훈이네마늘빵 2호점1충청북도단양군43800충청북도 단양군 단양읍 도전4길 36충청북도 단양군 단양읍 도전리 61336.983087128.36982402-1234-1234충청북도 단양군043-420-21462022-04-01
2653훌랄라참숯바베큐매포점1충청북도단양군43800충청북도 단양군 매포읍 평동로 124충청북도 단양군 매포읍 평동리 122537.033025128.300028043-422-9279충청북도 단양군043-420-21462022-04-01
2654흥주식당1충청북도단양군43800충청북도 단양군 영춘면 백자길 38충청북도 단양군 영춘면 백자리 90-537.04113128.48466043-423-7999충청북도 단양군043-420-21462022-04-01

Duplicate rows

Most frequently occurring

가맹점명가맹점유형코드시도명시군구명시군구코드소재지도로명주소소재지주소위도경도전화번호관리기관명관리기관전화번호데이터기준일자# duplicates
0굽네치킨 가경점1충청북도청주시43113충청북도 청주시 흥덕구 경산로 28 (가경동)충청북도 청주시 흥덕구 가경동 1478-436.623806127.435349043-236-9294충청북도 청주시043-201-19252022-04-012
1대동슈퍼2충청북도단양군43800충청북도 단양군 대강면 대강로 58-1충청북도 단양군 대강면 장림리 223-1236.922104128.353754043-422-0012충청북도 단양군043-420-21462022-04-012
2리치피자1충청북도청주시43111충청북도 청주시 상당구 용정로 8 (용정동)충청북도 청주시 상당구 용정동 96636.628692127.514714043-285-7778충청북도 청주시043-201-19252022-04-012
3신전떡볶이1충청북도청주시43113충청북도 청주시 흥덕구 송화로150번길 7-15 (송절동)충청북도 청주시 흥덕구 송절동 69936.666255127.451429043-267-3681충청북도 청주시043-201-19252022-04-012
4피자명 2호점1충청북도청주시43113충청북도 청주시 흥덕구 풍년로96번길 6 (가경동)충청북도 청주시 흥덕구 가경동 1487-236.621597127.436622043-237-0055충청북도 청주시043-201-19252022-04-012