Overview

Dataset statistics

Number of variables7
Number of observations273
Missing cells28
Missing cells (%)1.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.3 KiB
Average record size in memory57.5 B

Variable types

Numeric1
Categorical3
Text3

Dataset

Description인천광역시 남동구 아동급식 지정음식점 현황에 대한 데이터로 연번, 관할동, 가맹점명, 전화번호, 업태, 주소, 데이터기준일자를 제공합니다.
Author인천광역시 남동구
URLhttps://www.data.go.kr/data/15090597/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 관할동High correlation
관할동 is highly overall correlated with 연번High correlation
전화번호 has 28 (10.3%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:23:08.964020
Analysis finished2023-12-12 21:23:09.732788
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct273
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean137
Minimum1
Maximum273
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.5 KiB
2023-12-13T06:23:09.820937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.6
Q169
median137
Q3205
95-th percentile259.4
Maximum273
Range272
Interquartile range (IQR)136

Descriptive statistics

Standard deviation78.952517
Coefficient of variation (CV)0.57629575
Kurtosis-1.2
Mean137
Median Absolute Deviation (MAD)68
Skewness0
Sum37401
Variance6233.5
MonotonicityStrictly increasing
2023-12-13T06:23:09.979773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
181 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
185 1
 
0.4%
184 1
 
0.4%
183 1
 
0.4%
182 1
 
0.4%
180 1
 
0.4%
206 1
 
0.4%
Other values (263) 263
96.3%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%
268 1
0.4%
267 1
0.4%
266 1
0.4%
265 1
0.4%
264 1
0.4%

관할동
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
구월3동
30 
구월1동
24 
만수6동
21 
서창2동
21 
논현2동
19 
Other values (15)
158 

Length

Max length5
Median length4
Mean length4.1208791
Min length4

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row구월1동
2nd row구월1동
3rd row구월1동
4th row구월1동
5th row구월1동

Common Values

ValueCountFrequency (%)
구월3동 30
 
11.0%
구월1동 24
 
8.8%
만수6동 21
 
7.7%
서창2동 21
 
7.7%
논현2동 19
 
7.0%
만수2동 18
 
6.6%
논현1동 16
 
5.9%
논현고잔동 16
 
5.9%
구월4동 14
 
5.1%
구월2동 13
 
4.8%
Other values (10) 81
29.7%

Length

2023-12-13T06:23:10.156304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
구월3동 30
 
11.0%
구월1동 24
 
8.8%
만수6동 21
 
7.7%
서창2동 21
 
7.7%
논현2동 19
 
7.0%
만수2동 18
 
6.6%
논현1동 16
 
5.9%
논현고잔동 16
 
5.9%
구월4동 14
 
5.1%
간석3동 13
 
4.8%
Other values (10) 81
29.7%

가맹점명
Text

Distinct258
Distinct (%)94.5%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-13T06:23:10.440445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length13
Mean length7.9084249
Min length1

Characters and Unicode

Total characters2159
Distinct characters339
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique253 ?
Unique (%)92.7%

Sample

1st row파리바게트(길병원점)
2nd row본죽 인천길병원점
3rd row파리바게뜨 구월팬더점
4th rowBhc구월점
5th row뚜레쥬르구월로데오점
ValueCountFrequency (%)
김밥천국 13
 
3.4%
본죽 11
 
2.9%
파리바게뜨 11
 
2.9%
본 9
 
2.4%
죽&비빔밥 9
 
2.4%
파리바게트 8
 
2.1%
인천논현점 7
 
1.9%
구월점 4
 
1.1%
인천길병원점 3
 
0.8%
인천서창점 3
 
0.8%
Other values (281) 299
79.3%
2023-12-13T06:23:10.913858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 130
 
6.0%
104
 
4.8%
천 80
 
3.7%
리 60
 
2.8%
인 58
 
2.7%
밥 51
 
2.4%
이 43
 
2.0%
김 42
 
1.9%
구 40
 
1.9%
바 37
 
1.7%
Other values (329) 1514
70.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1962
90.9%
Space Separator 104
 
4.8%
Decimal Number 26
 
1.2%
Close Punctuation 23
 
1.1%
Open Punctuation 23
 
1.1%
Other Punctuation 11
 
0.5%
Lowercase Letter 8
 
0.4%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 130
 
6.6%
천 80
 
4.1%
리 60
 
3.1%
인 58
 
3.0%
밥 51
 
2.6%
이 43
 
2.2%
김 42
 
2.1%
구 40
 
2.0%
바 37
 
1.9%
파 35
 
1.8%
Other values (310) 1386
70.6%
Decimal Number
ValueCountFrequency (%)
2 6
23.1%
0 5
19.2%
1 5
19.2%
3 4
15.4%
9 2
 
7.7%
4 2
 
7.7%
5 1
 
3.8%
8 1
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
h 3
37.5%
e 2
25.0%
c 2
25.0%
f 1
 
12.5%
Other Punctuation
ValueCountFrequency (%)
& 10
90.9%
, 1
 
9.1%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
T 1
50.0%
Space Separator
ValueCountFrequency (%)
104
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1962
90.9%
Common 187
 
8.7%
Latin 10
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 130
 
6.6%
천 80
 
4.1%
리 60
 
3.1%
인 58
 
3.0%
밥 51
 
2.6%
이 43
 
2.2%
김 42
 
2.1%
구 40
 
2.0%
바 37
 
1.9%
파 35
 
1.8%
Other values (310) 1386
70.6%
Common
ValueCountFrequency (%)
104
55.6%
) 23
 
12.3%
( 23
 
12.3%
& 10
 
5.3%
2 6
 
3.2%
0 5
 
2.7%
1 5
 
2.7%
3 4
 
2.1%
9 2
 
1.1%
4 2
 
1.1%
Other values (3) 3
 
1.6%
Latin
ValueCountFrequency (%)
h 3
30.0%
e 2
20.0%
c 2
20.0%
B 1
 
10.0%
f 1
 
10.0%
T 1
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1962
90.9%
ASCII 197
 
9.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 130
 
6.6%
천 80
 
4.1%
리 60
 
3.1%
인 58
 
3.0%
밥 51
 
2.6%
이 43
 
2.2%
김 42
 
2.1%
구 40
 
2.0%
바 37
 
1.9%
파 35
 
1.8%
Other values (310) 1386
70.6%
ASCII
ValueCountFrequency (%)
104
52.8%
) 23
 
11.7%
( 23
 
11.7%
& 10
 
5.1%
2 6
 
3.0%
0 5
 
2.5%
1 5
 
2.5%
3 4
 
2.0%
h 3
 
1.5%
9 2
 
1.0%
Other values (9) 12
 
6.1%

전화번호
Text

MISSING 

Distinct243
Distinct (%)99.2%
Missing28
Missing (%)10.3%
Memory size2.3 KiB
2023-12-13T06:23:11.222963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.02449
Min length12

Characters and Unicode

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

Unique241 ?
Unique (%)98.4%

Sample

1st row032-461-0222
2nd row032-424-6288
3rd row032-205-6465
4th row032-466-7268
5th row032-424-7886
ValueCountFrequency (%)
032-428-5055 2
 
0.8%
032-424-6288 2
 
0.8%
032-464-8259 1
 
0.4%
032-471-7761 1
 
0.4%
032-472-6625 1
 
0.4%
032-463-9240 1
 
0.4%
032-464-6777 1
 
0.4%
032-471-7676 1
 
0.4%
032-469-5556 1
 
0.4%
032-466-4991 1
 
0.4%
Other values (233) 233
95.1%
2023-12-13T06:23:11.667378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 490
16.6%
2 475
16.1%
3 385
13.1%
0 379
12.9%
4 327
11.1%
6 226
7.7%
7 152
 
5.2%
8 150
 
5.1%
5 137
 
4.7%
1 133
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2456
83.4%
Dash Punctuation 490
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 475
19.3%
3 385
15.7%
0 379
15.4%
4 327
13.3%
6 226
9.2%
7 152
 
6.2%
8 150
 
6.1%
5 137
 
5.6%
1 133
 
5.4%
9 92
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 490
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2946
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 490
16.6%
2 475
16.1%
3 385
13.1%
0 379
12.9%
4 327
11.1%
6 226
7.7%
7 152
 
5.2%
8 150
 
5.1%
5 137
 
4.7%
1 133
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2946
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 490
16.6%
2 475
16.1%
3 385
13.1%
0 379
12.9%
4 327
11.1%
6 226
7.7%
7 152
 
5.2%
8 150
 
5.1%
5 137
 
4.7%
1 133
 
4.5%

업태
Categorical

Distinct5
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
한식
91 
분식
90 
제과점
67 
중식
19 
반찬
 
6

Length

Max length3
Median length2
Mean length2.2454212
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제과점
2nd row한식
3rd row제과점
4th row한식
5th row제과점

Common Values

ValueCountFrequency (%)
한식 91
33.3%
분식 90
33.0%
제과점 67
24.5%
중식 19
 
7.0%
반찬 6
 
2.2%

Length

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

Common Values (Plot)

2023-12-13T06:23:11.968536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한식 91
33.3%
분식 90
33.0%
제과점 67
24.5%
중식 19
 
7.0%
반찬 6
 
2.2%

주소
Text

Distinct241
Distinct (%)88.3%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-13T06:23:12.191040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length37
Mean length27.465201
Min length13

Characters and Unicode

Total characters7498
Distinct characters218
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique218 ?
Unique (%)79.9%

Sample

1st row인천광역시 남동구 구월남로 172 (구월동)
2nd row인천광역시 남동구 남동대로 784 (구월동)
3rd row인천 남동구 인주대로 661
4th row인천 남동구 구월남로 190
5th row인천광역시 남동구 인하로 497-5 (구월동, 푸른세상안과)
ValueCountFrequency (%)
남동구 274
18.8%
인천광역시 250
 
17.2%
구월동 64
 
4.4%
만수동 49
 
3.4%
논현동 44
 
3.0%
간석동 35
 
2.4%
서창동 27
 
1.9%
인천 23
 
1.6%
구월로 19
 
1.3%
구월남로 15
 
1.0%
Other values (380) 657
45.1%
2023-12-13T06:23:12.539462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1184
 
15.8%
동 532
 
7.1%
구 402
 
5.4%
남 339
 
4.5%
인 298
 
4.0%
천 282
 
3.8%
로 275
 
3.7%
시 261
 
3.5%
역 254
 
3.4%
광 253
 
3.4%
Other values (208) 3418
45.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4742
63.2%
Space Separator 1184
 
15.8%
Decimal Number 935
 
12.5%
Close Punctuation 229
 
3.1%
Open Punctuation 229
 
3.1%
Other Punctuation 116
 
1.5%
Dash Punctuation 38
 
0.5%
Uppercase Letter 25
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 532
 
11.2%
구 402
 
8.5%
남 339
 
7.1%
인 298
 
6.3%
천 282
 
5.9%
로 275
 
5.8%
시 261
 
5.5%
역 254
 
5.4%
광 253
 
5.3%
월 107
 
2.3%
Other values (181) 1739
36.7%
Uppercase Letter
ValueCountFrequency (%)
L 5
20.0%
H 4
16.0%
A 3
12.0%
S 2
 
8.0%
C 2
 
8.0%
P 2
 
8.0%
V 2
 
8.0%
T 1
 
4.0%
E 1
 
4.0%
Z 1
 
4.0%
Other values (2) 2
 
8.0%
Decimal Number
ValueCountFrequency (%)
1 189
20.2%
2 134
14.3%
4 105
11.2%
3 86
9.2%
5 83
8.9%
6 75
 
8.0%
8 73
 
7.8%
7 68
 
7.3%
0 62
 
6.6%
9 60
 
6.4%
Space Separator
ValueCountFrequency (%)
1184
100.0%
Close Punctuation
ValueCountFrequency (%)
) 229
100.0%
Open Punctuation
ValueCountFrequency (%)
( 229
100.0%
Other Punctuation
ValueCountFrequency (%)
, 116
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 38
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4742
63.2%
Common 2731
36.4%
Latin 25
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 532
 
11.2%
구 402
 
8.5%
남 339
 
7.1%
인 298
 
6.3%
천 282
 
5.9%
로 275
 
5.8%
시 261
 
5.5%
역 254
 
5.4%
광 253
 
5.3%
월 107
 
2.3%
Other values (181) 1739
36.7%
Common
ValueCountFrequency (%)
1184
43.4%
) 229
 
8.4%
( 229
 
8.4%
1 189
 
6.9%
2 134
 
4.9%
, 116
 
4.2%
4 105
 
3.8%
3 86
 
3.1%
5 83
 
3.0%
6 75
 
2.7%
Other values (5) 301
 
11.0%
Latin
ValueCountFrequency (%)
L 5
20.0%
H 4
16.0%
A 3
12.0%
S 2
 
8.0%
C 2
 
8.0%
P 2
 
8.0%
V 2
 
8.0%
T 1
 
4.0%
E 1
 
4.0%
Z 1
 
4.0%
Other values (2) 2
 
8.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4742
63.2%
ASCII 2756
36.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1184
43.0%
) 229
 
8.3%
( 229
 
8.3%
1 189
 
6.9%
2 134
 
4.9%
, 116
 
4.2%
4 105
 
3.8%
3 86
 
3.1%
5 83
 
3.0%
6 75
 
2.7%
Other values (17) 326
 
11.8%
Hangul
ValueCountFrequency (%)
동 532
 
11.2%
구 402
 
8.5%
남 339
 
7.1%
인 298
 
6.3%
천 282
 
5.9%
로 275
 
5.8%
시 261
 
5.5%
역 254
 
5.4%
광 253
 
5.3%
월 107
 
2.3%
Other values (181) 1739
36.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-09-19
273 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-19
2nd row2023-09-19
3rd row2023-09-19
4th row2023-09-19
5th row2023-09-19

Common Values

ValueCountFrequency (%)
2023-09-19 273
100.0%

Length

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

Common Values (Plot)

2023-12-13T06:23:12.767197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-19 273
100.0%

Interactions

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

Correlations

2023-12-13T06:23:12.819420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관할동업태
연번1.0000.9960.216
관할동0.9961.0000.110
업태0.2160.1101.000
2023-12-13T06:23:12.904272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관할동업태
관할동1.0000.043
업태0.0431.000
2023-12-13T06:23:12.978746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관할동업태
연번1.0000.8690.090
관할동0.8691.0000.043
업태0.0900.0431.000

Missing values

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

연번관할동가맹점명전화번호업태주소데이터기준일자
01구월1동파리바게트(길병원점)032-461-0222제과점인천광역시 남동구 구월남로 172 (구월동)2023-09-19
12구월1동본죽 인천길병원점032-424-6288한식인천광역시 남동구 남동대로 784 (구월동)2023-09-19
23구월1동파리바게뜨 구월팬더점032-205-6465제과점인천 남동구 인주대로 6612023-09-19
34구월1동Bhc구월점032-466-7268한식인천 남동구 구월남로 1902023-09-19
45구월1동뚜레쥬르구월로데오점032-424-7886제과점인천광역시 남동구 인하로 497-5 (구월동, 푸른세상안과)2023-09-19
56구월1동본 죽&비빔밥 구월아시아드점032-473-6288한식인천광역시 남동구 인하로 616 (구월동, 커뮤니티프라자)2023-09-19
67구월1동읍천리382 인천구월점032-466-0382분식인천광역시 남동구 선수촌공원로 37 (구월동, 중앙프라자)2023-09-19
78구월1동쥬쥬떡볶이<NA>분식인천광역시 남동구 용천로4번길 43-20 (구월동)2023-09-19
89구월1동투존치킨 인천구월직영점032-462-2701분식인천광역시 남동구 용천로 18 (구월동)2023-09-19
910구월1동잇츠프레시구월점<NA>한식인천광역시 남동구 인하로 568 (구월동, 아시아드타워)2023-09-19
연번관할동가맹점명전화번호업태주소데이터기준일자
263264서창2동신김밥천국032-465-2009한식인천광역시 남동구 서창남순환로 223 (서창동, 아페리온)2023-09-19
264265서창2동파리바게트 서창로데오점032-465-0927제과점인천광역시 남동구 서창남순환로 223 (서창동, 아페리온)2023-09-19
265266서창2동역전우동0410 인천서창점032-466-2826분식인천광역시 남동구 서창남순환로 223 (서창동, 아페리온)2023-09-19
266267서창2동가마솥김밥032-468-9905분식인천광역시 남동구 서창남로 109 (서창동, 인천서창엘에이치15단지)2023-09-19
267268서창2동소심032-471-7761한식인천광역시 남동구 서창방산로 51 (서창동)2023-09-19
268269서창2동59피자서창휴먼시아점032-464-8259분식인천광역시 남동구 서창남로 16-2 (서창동)2023-09-19
269270서창2동한끼식빵<NA>제과점인천광역시 남동구 운연천로 7 (서창동)2023-09-19
270271서창2동배떡서창점032-472-3777분식인천광역시 남동구 서창남로 45 (서창동, 로데오프라자)2023-09-19
271272서창2동본도시락 인천서창점032-471-4282한식인천광역시 남동구 서창방산로158번길 2 (서창동)2023-09-19
272273서창2동김안에밥있다032-433-7050분식인천광역시 남동구 서창남로 2-1 (서창동, 서창LH12단지상가)2023-09-19