Overview

Dataset statistics

Number of variables6
Number of observations238
Missing cells153
Missing cells (%)10.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.5 KiB
Average record size in memory49.6 B

Variable types

Numeric1
Categorical2
Text3

Dataset

Description인천광역시 서구의 식품자동판매기영업의 현황(업종명, 업소명, 소재지, 전화번호 등) 에 관하여 데이터를 제공합니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15089485&srcSe=7661IVAWM27C61E190

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 153 (64.3%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-18 02:52:46.468338
Analysis finished2024-03-18 02:52:47.255945
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct238
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean119.5
Minimum1
Maximum238
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.2 KiB
2024-03-18T11:52:47.327490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12.85
Q160.25
median119.5
Q3178.75
95-th percentile226.15
Maximum238
Range237
Interquartile range (IQR)118.5

Descriptive statistics

Standard deviation68.848868
Coefficient of variation (CV)0.57614116
Kurtosis-1.2
Mean119.5
Median Absolute Deviation (MAD)59.5
Skewness0
Sum28441
Variance4740.1667
MonotonicityStrictly increasing
2024-03-18T11:52:47.461525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
165 1
 
0.4%
153 1
 
0.4%
154 1
 
0.4%
155 1
 
0.4%
156 1
 
0.4%
157 1
 
0.4%
158 1
 
0.4%
159 1
 
0.4%
160 1
 
0.4%
Other values (228) 228
95.8%
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 (%)
238 1
0.4%
237 1
0.4%
236 1
0.4%
235 1
0.4%
234 1
0.4%
233 1
0.4%
232 1
0.4%
231 1
0.4%
230 1
0.4%
229 1
0.4%

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
식품자동판매기영업
238 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row식품자동판매기영업
2nd row식품자동판매기영업
3rd row식품자동판매기영업
4th row식품자동판매기영업
5th row식품자동판매기영업

Common Values

ValueCountFrequency (%)
식품자동판매기영업 238
100.0%

Length

2024-03-18T11:52:47.563419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T11:52:47.820542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
식품자동판매기영업 238
100.0%
Distinct237
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-03-18T11:52:48.008848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length18
Mean length9.1470588
Min length2

Characters and Unicode

Total characters2177
Distinct characters315
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

Unique236 ?
Unique (%)99.2%

Sample

1st row인천초은고등학교자판기
2nd row세븐일레븐 인천가좌초원점
3rd row청라고 자판기
4th row가좌고등학교 자판기
5th rowCU서구서곶점
ValueCountFrequency (%)
이마트24 10
 
3.1%
씨유 8
 
2.5%
나우커피 8
 
2.5%
무인카페나우커피 7
 
2.2%
세븐일레븐 6
 
1.9%
자판기 4
 
1.2%
gs25 4
 
1.2%
무인카페 3
 
0.9%
라커룸 2
 
0.6%
지에스25 2
 
0.6%
Other values (267) 267
83.2%
2024-03-18T11:52:48.399709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
133
 
6.1%
84
 
3.9%
58
 
2.7%
2 50
 
2.3%
41
 
1.9%
39
 
1.8%
38
 
1.7%
37
 
1.7%
37
 
1.7%
37
 
1.7%
Other values (305) 1623
74.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1825
83.8%
Decimal Number 106
 
4.9%
Space Separator 84
 
3.9%
Uppercase Letter 74
 
3.4%
Lowercase Letter 35
 
1.6%
Close Punctuation 26
 
1.2%
Open Punctuation 26
 
1.2%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
133
 
7.3%
58
 
3.2%
41
 
2.2%
39
 
2.1%
38
 
2.1%
37
 
2.0%
37
 
2.0%
37
 
2.0%
36
 
2.0%
34
 
1.9%
Other values (268) 1335
73.2%
Lowercase Letter
ValueCountFrequency (%)
e 5
14.3%
a 4
11.4%
n 3
8.6%
f 3
8.6%
i 3
8.6%
c 3
8.6%
o 2
 
5.7%
l 2
 
5.7%
u 2
 
5.7%
m 2
 
5.7%
Other values (5) 6
17.1%
Uppercase Letter
ValueCountFrequency (%)
S 19
25.7%
G 19
25.7%
C 13
17.6%
U 12
16.2%
R 2
 
2.7%
K 2
 
2.7%
F 1
 
1.4%
B 1
 
1.4%
T 1
 
1.4%
L 1
 
1.4%
Other values (3) 3
 
4.1%
Decimal Number
ValueCountFrequency (%)
2 50
47.2%
4 28
26.4%
5 19
 
17.9%
1 7
 
6.6%
0 2
 
1.9%
Space Separator
ValueCountFrequency (%)
84
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1825
83.8%
Common 243
 
11.2%
Latin 109
 
5.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
133
 
7.3%
58
 
3.2%
41
 
2.2%
39
 
2.1%
38
 
2.1%
37
 
2.0%
37
 
2.0%
37
 
2.0%
36
 
2.0%
34
 
1.9%
Other values (268) 1335
73.2%
Latin
ValueCountFrequency (%)
S 19
17.4%
G 19
17.4%
C 13
11.9%
U 12
11.0%
e 5
 
4.6%
a 4
 
3.7%
n 3
 
2.8%
f 3
 
2.8%
i 3
 
2.8%
c 3
 
2.8%
Other values (18) 25
22.9%
Common
ValueCountFrequency (%)
84
34.6%
2 50
20.6%
4 28
 
11.5%
) 26
 
10.7%
( 26
 
10.7%
5 19
 
7.8%
1 7
 
2.9%
0 2
 
0.8%
& 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1825
83.8%
ASCII 352
 
16.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
133
 
7.3%
58
 
3.2%
41
 
2.2%
39
 
2.1%
38
 
2.1%
37
 
2.0%
37
 
2.0%
37
 
2.0%
36
 
2.0%
34
 
1.9%
Other values (268) 1335
73.2%
ASCII
ValueCountFrequency (%)
84
23.9%
2 50
14.2%
4 28
 
8.0%
) 26
 
7.4%
( 26
 
7.4%
S 19
 
5.4%
G 19
 
5.4%
5 19
 
5.4%
C 13
 
3.7%
U 12
 
3.4%
Other values (27) 56
15.9%
Distinct228
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2024-03-18T11:52:48.683905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length23
Mean length18.491597
Min length14

Characters and Unicode

Total characters4401
Distinct characters140
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique219 ?
Unique (%)92.0%

Sample

1st row인천광역시 서구 청라에메랄드로 42
2nd row인천광역시 서구 가정로112번길 13
3rd row인천광역시 서구 담지로86번길 16-14
4th row인천광역시 서구 장고개로287번길 24
5th row인천광역시 서구 대평로56번길 17
ValueCountFrequency (%)
인천광역시 238
24.9%
서구 238
24.9%
가정로 9
 
0.9%
1 7
 
0.7%
2 7
 
0.7%
16 6
 
0.6%
18 5
 
0.5%
청라라임로 5
 
0.5%
검단로 5
 
0.5%
율도로 5
 
0.5%
Other values (299) 432
45.1%
2024-03-18T11:52:49.114328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
724
16.5%
253
 
5.7%
240
 
5.5%
239
 
5.4%
238
 
5.4%
238
 
5.4%
238
 
5.4%
238
 
5.4%
236
 
5.4%
1 180
 
4.1%
Other values (130) 1577
35.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2769
62.9%
Decimal Number 872
 
19.8%
Space Separator 724
 
16.5%
Dash Punctuation 34
 
0.8%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
253
9.1%
240
 
8.7%
239
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
236
 
8.5%
124
 
4.5%
122
 
4.4%
Other values (116) 603
21.8%
Decimal Number
ValueCountFrequency (%)
1 180
20.6%
2 122
14.0%
3 96
11.0%
4 87
10.0%
8 77
8.8%
6 65
 
7.5%
0 64
 
7.3%
7 62
 
7.1%
5 60
 
6.9%
9 59
 
6.8%
Space Separator
ValueCountFrequency (%)
724
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2769
62.9%
Common 1632
37.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
253
9.1%
240
 
8.7%
239
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
236
 
8.5%
124
 
4.5%
122
 
4.4%
Other values (116) 603
21.8%
Common
ValueCountFrequency (%)
724
44.4%
1 180
 
11.0%
2 122
 
7.5%
3 96
 
5.9%
4 87
 
5.3%
8 77
 
4.7%
6 65
 
4.0%
0 64
 
3.9%
7 62
 
3.8%
5 60
 
3.7%
Other values (4) 95
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2769
62.9%
ASCII 1632
37.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
724
44.4%
1 180
 
11.0%
2 122
 
7.5%
3 96
 
5.9%
4 87
 
5.3%
8 77
 
4.7%
6 65
 
4.0%
0 64
 
3.9%
7 62
 
3.8%
5 60
 
3.7%
Other values (4) 95
 
5.8%
Hangul
ValueCountFrequency (%)
253
9.1%
240
 
8.7%
239
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
238
 
8.6%
236
 
8.5%
124
 
4.5%
122
 
4.4%
Other values (116) 603
21.8%

전화번호
Text

MISSING 

Distinct83
Distinct (%)97.6%
Missing153
Missing (%)64.3%
Memory size2.0 KiB
2024-03-18T11:52:49.388942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.047059
Min length12

Characters and Unicode

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

Unique81 ?
Unique (%)95.3%

Sample

1st row032-561-0006
2nd row032-561-0019
3rd row032-561-1422
4th row032-561-2314
5th row032-561-2909
ValueCountFrequency (%)
032-467-4134 2
 
2.4%
070-4493-7699 2
 
2.4%
032-577-5590 1
 
1.2%
032-662-5224 1
 
1.2%
032-568-8758 1
 
1.2%
032-567-9002 1
 
1.2%
032-567-8127 1
 
1.2%
032-567-7759 1
 
1.2%
032-567-3685 1
 
1.2%
032-566-6656 1
 
1.2%
Other values (73) 73
85.9%
2024-03-18T11:52:49.699067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 170
16.6%
2 140
13.7%
0 127
12.4%
3 115
11.2%
5 112
10.9%
7 93
9.1%
6 74
7.2%
8 54
 
5.3%
1 52
 
5.1%
4 50
 
4.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 854
83.4%
Dash Punctuation 170
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 140
16.4%
0 127
14.9%
3 115
13.5%
5 112
13.1%
7 93
10.9%
6 74
8.7%
8 54
 
6.3%
1 52
 
6.1%
4 50
 
5.9%
9 37
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 170
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1024
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 170
16.6%
2 140
13.7%
0 127
12.4%
3 115
11.2%
5 112
10.9%
7 93
9.1%
6 74
7.2%
8 54
 
5.3%
1 52
 
5.1%
4 50
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1024
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 170
16.6%
2 140
13.7%
0 127
12.4%
3 115
11.2%
5 112
10.9%
7 93
9.1%
6 74
7.2%
8 54
 
5.3%
1 52
 
5.1%
4 50
 
4.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2022-09-06
238 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-09-06
2nd row2022-09-06
3rd row2022-09-06
4th row2022-09-06
5th row2022-09-06

Common Values

ValueCountFrequency (%)
2022-09-06 238
100.0%

Length

2024-03-18T11:52:49.817485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T11:52:49.899690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-09-06 238
100.0%

Interactions

2024-03-18T11:52:47.013841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T11:52:49.941719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번전화번호
연번1.0001.000
전화번호1.0001.000

Missing values

2024-03-18T11:52:47.120026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T11:52:47.216255image/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식품자동판매기영업인천초은고등학교자판기인천광역시 서구 청라에메랄드로 42<NA>2022-09-06
12식품자동판매기영업세븐일레븐 인천가좌초원점인천광역시 서구 가정로112번길 13<NA>2022-09-06
23식품자동판매기영업청라고 자판기인천광역시 서구 담지로86번길 16-14<NA>2022-09-06
34식품자동판매기영업가좌고등학교 자판기인천광역시 서구 장고개로287번길 24<NA>2022-09-06
45식품자동판매기영업CU서구서곶점인천광역시 서구 대평로56번길 17<NA>2022-09-06
56식품자동판매기영업CU석남감동점인천광역시 서구 염곡로311번길 2<NA>2022-09-06
67식품자동판매기영업이마트24서구원당점인천광역시 서구 고산후로161번안길 40<NA>2022-09-06
78식품자동판매기영업샛별인천광역시 서구 고산로40번길 30<NA>2022-09-06
89식품자동판매기영업세븐일레븐청라인천점인천광역시 서구 청라커낼로288번길 10<NA>2022-09-06
910식품자동판매기영업세븐일레븐원창우앤이점인천광역시 서구 북항로32번길 66<NA>2022-09-06
연번업종명업소명소재지전화번호데이터기준일자
228229식품자동판매기영업꿀민턴스포츠센터인천광역시 서구 봉화로 33<NA>2022-09-06
229230식품자동판매기영업나우커피 금곡초선교점인천광역시 서구 완정로228번길 12<NA>2022-09-06
230231식품자동판매기영업GS25 마전스타점인천광역시 서구 마전로99번길 10<NA>2022-09-06
231232식품자동판매기영업나우커피간재울점인천광역시 서구 승학로434번길 1<NA>2022-09-06
232233식품자동판매기영업지에스25 불로센트럴인천광역시 서구 검단로 748<NA>2022-09-06
233234식품자동판매기영업오늘도커피인천광역시 서구 청라한내로72번길 7-31<NA>2022-09-06
234235식품자동판매기영업조이피플인천광역시 서구 원석로196번길 44<NA>2022-09-06
235236식품자동판매기영업나우커피(검단사거리점)인천광역시 서구 검단로487번길 29<NA>2022-09-06
236237식품자동판매기영업(주)이마트에브리데이인천SK리더스뷰점인천광역시 서구 가정로 437<NA>2022-09-06
237238식품자동판매기영업씨유청라진영점인천광역시 서구 청라라임로 71<NA>2022-09-06