Overview

Dataset statistics

Number of variables6
Number of observations187
Missing cells29
Missing cells (%)2.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.1 KiB
Average record size in memory49.7 B

Variable types

Numeric1
Text3
Categorical1
DateTime1

Dataset

Description파일 다운로드
Author양천구
URLhttps://data.seoul.go.kr/dataList/OA-22097/F/1/datasetView.do

Alerts

데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 사업장구분High correlation
사업장구분 is highly overall correlated with 연번High correlation
전화번호 has 29 (15.5%) missing valuesMissing
연번 has unique valuesUnique
사업장명 has unique valuesUnique

Reproduction

Analysis started2023-12-11 04:32:37.345502
Analysis finished2023-12-11 04:32:39.574681
Duration2.23 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct187
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean94
Minimum1
Maximum187
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2023-12-11T13:32:39.676795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile10.3
Q147.5
median94
Q3140.5
95-th percentile177.7
Maximum187
Range186
Interquartile range (IQR)93

Descriptive statistics

Standard deviation54.126395
Coefficient of variation (CV)0.57581272
Kurtosis-1.2
Mean94
Median Absolute Deviation (MAD)47
Skewness0
Sum17578
Variance2929.6667
MonotonicityStrictly increasing
2023-12-11T13:32:39.886558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.5%
130 1
 
0.5%
121 1
 
0.5%
122 1
 
0.5%
123 1
 
0.5%
124 1
 
0.5%
125 1
 
0.5%
126 1
 
0.5%
127 1
 
0.5%
128 1
 
0.5%
Other values (177) 177
94.7%
ValueCountFrequency (%)
1 1
0.5%
2 1
0.5%
3 1
0.5%
4 1
0.5%
5 1
0.5%
6 1
0.5%
7 1
0.5%
8 1
0.5%
9 1
0.5%
10 1
0.5%
ValueCountFrequency (%)
187 1
0.5%
186 1
0.5%
185 1
0.5%
184 1
0.5%
183 1
0.5%
182 1
0.5%
181 1
0.5%
180 1
0.5%
179 1
0.5%
178 1
0.5%

사업장명
Text

UNIQUE 

Distinct187
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-11T13:32:40.213523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length7.1604278
Min length2

Characters and Unicode

Total characters1339
Distinct characters274
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique187 ?
Unique (%)100.0%

Sample

1st row강서고등학교
2nd row광영고등학교
3rd row광영여자고등학교
4th row금옥여자고등학교
5th row금옥중학교
ValueCountFrequency (%)
목동점 18
 
7.6%
맥도날드 5
 
2.1%
신월점 3
 
1.3%
버거킹 3
 
1.3%
등촌샤브칼국수 2
 
0.8%
더 2
 
0.8%
목동지점 2
 
0.8%
신정네거리역점 2
 
0.8%
비엔나커피하우스 1
 
0.4%
송추가마골 1
 
0.4%
Other values (197) 197
83.5%
2023-12-11T13:32:41.082704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 64
 
4.8%
교 64
 
4.8%
서 56
 
4.2%
50
 
3.7%
등 47
 
3.5%
목 45
 
3.4%
울 43
 
3.2%
동 41
 
3.1%
점 37
 
2.8%
초 33
 
2.5%
Other values (264) 859
64.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1256
93.8%
Space Separator 50
 
3.7%
Decimal Number 15
 
1.1%
Uppercase Letter 10
 
0.7%
Other Symbol 6
 
0.4%
Open Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 64
 
5.1%
교 64
 
5.1%
서 56
 
4.5%
등 47
 
3.7%
목 45
 
3.6%
울 43
 
3.4%
동 41
 
3.3%
점 37
 
2.9%
초 33
 
2.6%
신 29
 
2.3%
Other values (247) 797
63.5%
Decimal Number
ValueCountFrequency (%)
4 4
26.7%
0 2
13.3%
8 2
13.3%
7 2
13.3%
3 2
13.3%
1 2
13.3%
9 1
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
S 3
30.0%
T 2
20.0%
D 2
20.0%
F 1
 
10.0%
P 1
 
10.0%
A 1
 
10.0%
Space Separator
ValueCountFrequency (%)
50
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1262
94.2%
Common 67
 
5.0%
Latin 10
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 64
 
5.1%
교 64
 
5.1%
서 56
 
4.4%
등 47
 
3.7%
목 45
 
3.6%
울 43
 
3.4%
동 41
 
3.2%
점 37
 
2.9%
초 33
 
2.6%
신 29
 
2.3%
Other values (248) 803
63.6%
Common
ValueCountFrequency (%)
50
74.6%
4 4
 
6.0%
0 2
 
3.0%
8 2
 
3.0%
7 2
 
3.0%
3 2
 
3.0%
1 2
 
3.0%
9 1
 
1.5%
( 1
 
1.5%
) 1
 
1.5%
Latin
ValueCountFrequency (%)
S 3
30.0%
T 2
20.0%
D 2
20.0%
F 1
 
10.0%
P 1
 
10.0%
A 1
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1256
93.8%
ASCII 77
 
5.8%
None 6
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 64
 
5.1%
교 64
 
5.1%
서 56
 
4.5%
등 47
 
3.7%
목 45
 
3.6%
울 43
 
3.4%
동 41
 
3.3%
점 37
 
2.9%
초 33
 
2.6%
신 29
 
2.3%
Other values (247) 797
63.5%
ASCII
ValueCountFrequency (%)
50
64.9%
4 4
 
5.2%
S 3
 
3.9%
0 2
 
2.6%
8 2
 
2.6%
7 2
 
2.6%
3 2
 
2.6%
1 2
 
2.6%
T 2
 
2.6%
D 2
 
2.6%
Other values (6) 6
 
7.8%
None
ValueCountFrequency (%)
㈜ 6
100.0%

소재지주소
Text

Distinct172
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2023-12-11T13:32:41.600263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length19.449198
Min length15

Characters and Unicode

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

Unique

Unique160 ?
Unique (%)85.6%

Sample

1st row서울특별시 양천구 목동중앙남로 27
2nd row서울특별시 양천구 남부순환로30길 17
3rd row서울특별시 양천구 남부순환로30길 17
4th row서울특별시 양천구 신정로 213
5th row서울특별시 양천구 신정로 213
ValueCountFrequency (%)
서울특별시 187
23.8%
양천구 186
23.6%
목동동로 26
 
3.3%
오목로 16
 
2.0%
목동서로 15
 
1.9%
지하1층 15
 
1.9%
중앙로 12
 
1.5%
신월로 10
 
1.3%
2층 9
 
1.1%
안양천로 9
 
1.1%
Other values (194) 302
38.4%
2023-12-11T13:32:42.291532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
673
18.5%
서 204
 
5.6%
양 199
 
5.5%
천 196
 
5.4%
로 191
 
5.3%
별 188
 
5.2%
울 187
 
5.1%
특 187
 
5.1%
시 187
 
5.1%
구 187
 
5.1%
Other values (47) 1238
34.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2320
63.8%
Space Separator 673
 
18.5%
Decimal Number 598
 
16.4%
Other Punctuation 38
 
1.0%
Dash Punctuation 8
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 204
8.8%
양 199
8.6%
천 196
8.4%
로 191
 
8.2%
별 188
 
8.1%
울 187
 
8.1%
특 187
 
8.1%
시 187
 
8.1%
구 187
 
8.1%
동 105
 
4.5%
Other values (34) 489
21.1%
Decimal Number
ValueCountFrequency (%)
1 132
22.1%
2 90
15.1%
3 83
13.9%
5 52
 
8.7%
0 50
 
8.4%
6 44
 
7.4%
9 42
 
7.0%
4 36
 
6.0%
8 35
 
5.9%
7 34
 
5.7%
Space Separator
ValueCountFrequency (%)
673
100.0%
Other Punctuation
ValueCountFrequency (%)
, 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2320
63.8%
Common 1317
36.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 204
8.8%
양 199
8.6%
천 196
8.4%
로 191
 
8.2%
별 188
 
8.1%
울 187
 
8.1%
특 187
 
8.1%
시 187
 
8.1%
구 187
 
8.1%
동 105
 
4.5%
Other values (34) 489
21.1%
Common
ValueCountFrequency (%)
673
51.1%
1 132
 
10.0%
2 90
 
6.8%
3 83
 
6.3%
5 52
 
3.9%
0 50
 
3.8%
6 44
 
3.3%
9 42
 
3.2%
, 38
 
2.9%
4 36
 
2.7%
Other values (3) 77
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2320
63.8%
ASCII 1317
36.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
673
51.1%
1 132
 
10.0%
2 90
 
6.8%
3 83
 
6.3%
5 52
 
3.9%
0 50
 
3.8%
6 44
 
3.3%
9 42
 
3.2%
, 38
 
2.9%
4 36
 
2.7%
Other values (3) 77
 
5.8%
Hangul
ValueCountFrequency (%)
서 204
8.8%
양 199
8.6%
천 196
8.4%
로 191
 
8.2%
별 188
 
8.1%
울 187
 
8.1%
특 187
 
8.1%
시 187
 
8.1%
구 187
 
8.1%
동 105
 
4.5%
Other values (34) 489
21.1%

전화번호
Text

MISSING 

Distinct157
Distinct (%)99.4%
Missing29
Missing (%)15.5%
Memory size1.6 KiB
2023-12-11T13:32:42.626906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.164557
Min length12

Characters and Unicode

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

Unique156 ?
Unique (%)98.7%

Sample

1st row070-4022-4814
2nd row02-2650-2378
3rd row02-2603-2017
4th row02-2086-7527
5th row070-4373-5621
ValueCountFrequency (%)
070-4014-1807 2
 
1.3%
02-2699-1191 1
 
0.6%
070-4022-4814 1
 
0.6%
02-2655-0773 1
 
0.6%
02-2062-3300 1
 
0.6%
02-2648-5988 1
 
0.6%
02-6408-8980 1
 
0.6%
02-2646-8948 1
 
0.6%
02-2088-1121 1
 
0.6%
02-2652-8823 1
 
0.6%
Other values (147) 147
93.0%
2023-12-11T13:32:43.075086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 373
19.4%
0 321
16.7%
- 316
16.4%
6 196
10.2%
7 130
 
6.8%
4 113
 
5.9%
1 104
 
5.4%
5 102
 
5.3%
9 94
 
4.9%
8 90
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1606
83.6%
Dash Punctuation 316
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 373
23.2%
0 321
20.0%
6 196
12.2%
7 130
 
8.1%
4 113
 
7.0%
1 104
 
6.5%
5 102
 
6.4%
9 94
 
5.9%
8 90
 
5.6%
3 83
 
5.2%
Dash Punctuation
ValueCountFrequency (%)
- 316
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1922
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 373
19.4%
0 321
16.7%
- 316
16.4%
6 196
10.2%
7 130
 
6.8%
4 113
 
5.9%
1 104
 
5.4%
5 102
 
5.3%
9 94
 
4.9%
8 90
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1922
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 373
19.4%
0 321
16.7%
- 316
16.4%
6 196
10.2%
7 130
 
6.8%
4 113
 
5.9%
1 104
 
5.4%
5 102
 
5.3%
9 94
 
4.9%
8 90
 
4.7%

사업장구분
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
일반음식점
90 
집단급식소
88 
휴게음식점
 
9

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row집단급식소
2nd row집단급식소
3rd row집단급식소
4th row집단급식소
5th row집단급식소

Common Values

ValueCountFrequency (%)
일반음식점 90
48.1%
집단급식소 88
47.1%
휴게음식점 9
 
4.8%

Length

2023-12-11T13:32:43.256320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T13:32:43.376123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 90
48.1%
집단급식소 88
47.1%
휴게음식점 9
 
4.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-06-12 00:00:00
Maximum2023-06-12 00:00:00
2023-12-11T13:32:43.496331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T13:32:43.601616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T13:32:39.104053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T13:32:43.679078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업장구분
연번1.0000.840
사업장구분0.8401.000
2023-12-11T13:32:43.776468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업장구분
연번1.0000.744
사업장구분0.7441.000

Missing values

2023-12-11T13:32:39.334754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T13:32:39.489335image/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강서고등학교서울특별시 양천구 목동중앙남로 27070-4022-4814집단급식소2023-06-12
12광영고등학교서울특별시 양천구 남부순환로30길 1702-2650-2378집단급식소2023-06-12
23광영여자고등학교서울특별시 양천구 남부순환로30길 1702-2603-2017집단급식소2023-06-12
34금옥여자고등학교서울특별시 양천구 신정로 21302-2086-7527집단급식소2023-06-12
45금옥중학교서울특별시 양천구 신정로 213070-4373-5621집단급식소2023-06-12
56대일관광고등학교서울특별시 양천구 신정이펜1로 11070-4377-8804집단급식소2023-06-12
67목동고등학교서울특별시 양천구 목동동로2길 68070-4906-5055집단급식소2023-06-12
78목동중학교서울특별시 양천구 목동동로 172070-4468-8137집단급식소2023-06-12
89목운중학교서울특별시 양천구 목동동로 23502-2651-4062집단급식소2023-06-12
910목운초등학교서울특별시 양천구 목동동로 23502-2061-5212집단급식소2023-06-12
연번사업장명소재지주소전화번호사업장구분데이터기준일
177178할머니추어탕서울특별시 양천구 가로공원로 14602-2688-9782일반음식점2023-06-12
178179항아리보쌈서울특별시 양천구 신목로 4802-2646-9394일반음식점2023-06-12
179180현경 목동점서울특별시 양천구 오목로 31202-2061-1877일반음식점2023-06-12
180181홍농숯불갈비서울특별시 양천구 신월로15길 102-2695-6979일반음식점2023-06-12
181182황태보감서울특별시 양천구 신월로 354<NA>일반음식점2023-06-12
182183힘찬민물장어숯불구이서울특별시 양천구 중앙로 299, 1층02-2675-8226일반음식점2023-06-12
183184아웃백스테이크하우스코리아 목동점서울특별시 양천구 목동동로 29302-2168-2811일반음식점2023-06-12
184185㈜삼성웰스토리이대목동병원장례식장서울특별시 양천구 안양천로 1071, 지하1층02-2650-5124일반음식점2023-06-12
185186㈜엠에프지코리아 매드포갈릭목동점서울특별시 양천구 목동동로 233-3, 지하1층02-2061-1191일반음식점2023-06-12
186187㈜정정당당 양촌리서울특별시 양천구 목동로 23402-2643-3003일반음식점2023-06-12