Overview

Dataset statistics

Number of variables5
Number of observations192
Missing cells91
Missing cells (%)9.5%
Duplicate rows1
Duplicate rows (%)0.5%
Total size in memory7.6 KiB
Average record size in memory40.7 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description인천 광역시 서구 관내에 위치한 위탁급식영업(업종명, 업소명, 소재지(도로명), 전화번호)현행 데이터 입니다.
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15089639&srcSe=7661IVAWM27C61E190

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 1 (0.5%) duplicate rowsDuplicates
전화번호 has 91 (47.4%) missing valuesMissing

Reproduction

Analysis started2024-01-28 12:07:15.472449
Analysis finished2024-01-28 12:07:15.953116
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
위탁급식영업
192 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row위탁급식영업
2nd row위탁급식영업
3rd row위탁급식영업
4th row위탁급식영업
5th row위탁급식영업

Common Values

ValueCountFrequency (%)
위탁급식영업 192
100.0%

Length

2024-01-28T21:07:16.008398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T21:07:16.099081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
위탁급식영업 192
100.0%

업소명
Text

Distinct188
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-01-28T21:07:16.274136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length19
Mean length10
Min length2

Characters and Unicode

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

Unique

Unique185 ?
Unique (%)96.4%

Sample

1st rowCJ프레시웨이(주)TPC점
2nd row(주)동원홈푸드 인천도시가스
3rd row(주)현대그린푸드 현대차인천하이테크센터지점
4th row(주)영타운FOOD서비스 경신공업
5th row아라마크(주)삼양사 인천1공장
ValueCountFrequency (%)
주)아워홈 11
 
4.3%
주)동원홈푸드 7
 
2.7%
주식회사 5
 
2.0%
구내식당 4
 
1.6%
밥줄래홈푸드(주 3
 
1.2%
주)한성세종푸드 2
 
0.8%
푸드하우스 2
 
0.8%
씨제이프레시웨이(주 2
 
0.8%
베스트푸드서비스 2
 
0.8%
주)후니드 2
 
0.8%
Other values (215) 216
84.4%
2024-01-28T21:07:16.586386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 87
 
4.5%
( 82
 
4.3%
) 82
 
4.3%
식 71
 
3.7%
64
 
3.3%
드 64
 
3.3%
푸 59
 
3.1%
당 56
 
2.9%
스 52
 
2.7%
점 48
 
2.5%
Other values (273) 1255
65.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1635
85.2%
Open Punctuation 82
 
4.3%
Close Punctuation 82
 
4.3%
Space Separator 64
 
3.3%
Uppercase Letter 42
 
2.2%
Decimal Number 10
 
0.5%
Lowercase Letter 3
 
0.2%
Dash Punctuation 1
 
0.1%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 87
 
5.3%
식 71
 
4.3%
드 64
 
3.9%
푸 59
 
3.6%
당 56
 
3.4%
스 52
 
3.2%
점 48
 
2.9%
이 41
 
2.5%
구 32
 
2.0%
인 30
 
1.8%
Other values (247) 1095
67.0%
Uppercase Letter
ValueCountFrequency (%)
C 8
19.0%
S 6
14.3%
F 4
9.5%
O 4
9.5%
G 3
 
7.1%
D 3
 
7.1%
P 3
 
7.1%
J 2
 
4.8%
T 2
 
4.8%
K 2
 
4.8%
Other values (5) 5
11.9%
Decimal Number
ValueCountFrequency (%)
2 4
40.0%
1 3
30.0%
4 2
20.0%
3 1
 
10.0%
Lowercase Letter
ValueCountFrequency (%)
o 2
66.7%
d 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 82
100.0%
Close Punctuation
ValueCountFrequency (%)
) 82
100.0%
Space Separator
ValueCountFrequency (%)
64
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1635
85.2%
Common 240
 
12.5%
Latin 45
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 87
 
5.3%
식 71
 
4.3%
드 64
 
3.9%
푸 59
 
3.6%
당 56
 
3.4%
스 52
 
3.2%
점 48
 
2.9%
이 41
 
2.5%
구 32
 
2.0%
인 30
 
1.8%
Other values (247) 1095
67.0%
Latin
ValueCountFrequency (%)
C 8
17.8%
S 6
13.3%
F 4
8.9%
O 4
8.9%
G 3
 
6.7%
D 3
 
6.7%
P 3
 
6.7%
J 2
 
4.4%
T 2
 
4.4%
o 2
 
4.4%
Other values (7) 8
17.8%
Common
ValueCountFrequency (%)
( 82
34.2%
) 82
34.2%
64
26.7%
2 4
 
1.7%
1 3
 
1.2%
4 2
 
0.8%
3 1
 
0.4%
- 1
 
0.4%
/ 1
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1635
85.2%
ASCII 285
 
14.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 87
 
5.3%
식 71
 
4.3%
드 64
 
3.9%
푸 59
 
3.6%
당 56
 
3.4%
스 52
 
3.2%
점 48
 
2.9%
이 41
 
2.5%
구 32
 
2.0%
인 30
 
1.8%
Other values (247) 1095
67.0%
ASCII
ValueCountFrequency (%)
( 82
28.8%
) 82
28.8%
64
22.5%
C 8
 
2.8%
S 6
 
2.1%
2 4
 
1.4%
F 4
 
1.4%
O 4
 
1.4%
G 3
 
1.1%
1 3
 
1.1%
Other values (16) 25
 
8.8%

소재지(도로명)
Text

Distinct172
Distinct (%)89.6%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
2024-01-28T21:07:16.834998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length84
Median length43
Mean length30.151042
Min length9

Characters and Unicode

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

Unique

Unique171 ?
Unique (%)89.1%

Sample

1st row인천광역시 서구 백범로603번길 24 (가좌동)
2nd row인천광역시 서구 백범로934번길 23 (가좌동, 178-24)
3rd row인천광역시 서구 가좌로83번길 22 (가좌동)
4th row<REPLACE>
5th row인천광역시 서구 백범로718번길 6, 1층 (가좌동)
ValueCountFrequency (%)
서구 172
 
14.9%
인천광역시 172
 
14.9%
가좌동 55
 
4.8%
1층 55
 
4.8%
오류동 39
 
3.4%
원창동 29
 
2.5%
replace 21
 
1.8%
3층 13
 
1.1%
일부호 12
 
1.0%
청라동 11
 
1.0%
Other values (378) 578
50.0%
2024-01-28T21:07:17.237029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
965
 
16.7%
1 215
 
3.7%
동 214
 
3.7%
( 202
 
3.5%
) 202
 
3.5%
서 199
 
3.4%
인 187
 
3.2%
천 183
 
3.2%
구 177
 
3.1%
로 177
 
3.1%
Other values (252) 3068
53.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3229
55.8%
Space Separator 965
 
16.7%
Decimal Number 800
 
13.8%
Open Punctuation 202
 
3.5%
Close Punctuation 202
 
3.5%
Uppercase Letter 180
 
3.1%
Other Punctuation 148
 
2.6%
Math Symbol 42
 
0.7%
Dash Punctuation 21
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 214
 
6.6%
서 199
 
6.2%
인 187
 
5.8%
천 183
 
5.7%
구 177
 
5.5%
로 177
 
5.5%
역 173
 
5.4%
시 173
 
5.4%
광 172
 
5.3%
층 119
 
3.7%
Other values (216) 1455
45.1%
Uppercase Letter
ValueCountFrequency (%)
E 43
23.9%
A 25
13.9%
R 23
12.8%
C 23
12.8%
P 22
12.2%
L 21
11.7%
B 5
 
2.8%
T 4
 
2.2%
S 2
 
1.1%
U 2
 
1.1%
Other values (8) 10
 
5.6%
Decimal Number
ValueCountFrequency (%)
1 215
26.9%
2 105
13.1%
3 95
11.9%
4 81
 
10.1%
6 60
 
7.5%
5 53
 
6.6%
0 53
 
6.6%
7 48
 
6.0%
8 48
 
6.0%
9 42
 
5.2%
Other Punctuation
ValueCountFrequency (%)
, 146
98.6%
. 2
 
1.4%
Math Symbol
ValueCountFrequency (%)
< 21
50.0%
> 21
50.0%
Space Separator
ValueCountFrequency (%)
965
100.0%
Open Punctuation
ValueCountFrequency (%)
( 202
100.0%
Close Punctuation
ValueCountFrequency (%)
) 202
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3229
55.8%
Common 2380
41.1%
Latin 180
 
3.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 214
 
6.6%
서 199
 
6.2%
인 187
 
5.8%
천 183
 
5.7%
구 177
 
5.5%
로 177
 
5.5%
역 173
 
5.4%
시 173
 
5.4%
광 172
 
5.3%
층 119
 
3.7%
Other values (216) 1455
45.1%
Common
ValueCountFrequency (%)
965
40.5%
1 215
 
9.0%
( 202
 
8.5%
) 202
 
8.5%
, 146
 
6.1%
2 105
 
4.4%
3 95
 
4.0%
4 81
 
3.4%
6 60
 
2.5%
5 53
 
2.2%
Other values (8) 256
 
10.8%
Latin
ValueCountFrequency (%)
E 43
23.9%
A 25
13.9%
R 23
12.8%
C 23
12.8%
P 22
12.2%
L 21
11.7%
B 5
 
2.8%
T 4
 
2.2%
S 2
 
1.1%
U 2
 
1.1%
Other values (8) 10
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3229
55.8%
ASCII 2560
44.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
965
37.7%
1 215
 
8.4%
( 202
 
7.9%
) 202
 
7.9%
, 146
 
5.7%
2 105
 
4.1%
3 95
 
3.7%
4 81
 
3.2%
6 60
 
2.3%
5 53
 
2.1%
Other values (26) 436
17.0%
Hangul
ValueCountFrequency (%)
동 214
 
6.6%
서 199
 
6.2%
인 187
 
5.8%
천 183
 
5.7%
구 177
 
5.5%
로 177
 
5.5%
역 173
 
5.4%
시 173
 
5.4%
광 172
 
5.3%
층 119
 
3.7%
Other values (216) 1455
45.1%

전화번호
Text

MISSING 

Distinct95
Distinct (%)94.1%
Missing91
Missing (%)47.4%
Memory size1.6 KiB
2024-01-28T21:07:17.448659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.960396
Min length10

Characters and Unicode

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

Unique90 ?
Unique (%)89.1%

Sample

1st row032-580-0214
2nd row032-589-6200
3rd row032-578-2350
4th row032-581-9127
5th row032-570-8054
ValueCountFrequency (%)
032-584-7151 3
 
3.0%
02-6966-9274 2
 
2.0%
02-589-3550 2
 
2.0%
080-234-7575 2
 
2.0%
031-748-3600 2
 
2.0%
032-583-9988 1
 
1.0%
070-4624-5258 1
 
1.0%
031-721-4335 1
 
1.0%
1544-8272 1
 
1.0%
032-572-2952 1
 
1.0%
Other values (85) 85
84.2%
2024-01-28T21:07:18.078489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 203
16.8%
- 202
16.7%
2 159
13.2%
3 128
10.6%
5 118
9.8%
8 76
 
6.3%
6 76
 
6.3%
1 72
 
6.0%
7 67
 
5.5%
4 54
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1006
83.3%
Dash Punctuation 202
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 203
20.2%
2 159
15.8%
3 128
12.7%
5 118
11.7%
8 76
 
7.6%
6 76
 
7.6%
1 72
 
7.2%
7 67
 
6.7%
4 54
 
5.4%
9 53
 
5.3%
Dash Punctuation
ValueCountFrequency (%)
- 202
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1208
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 203
16.8%
- 202
16.7%
2 159
13.2%
3 128
10.6%
5 118
9.8%
8 76
 
6.3%
6 76
 
6.3%
1 72
 
6.0%
7 67
 
5.5%
4 54
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1208
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 203
16.8%
- 202
16.7%
2 159
13.2%
3 128
10.6%
5 118
9.8%
8 76
 
6.3%
6 76
 
6.3%
1 72
 
6.0%
7 67
 
5.5%
4 54
 
4.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-10-26 00:00:00
Maximum2023-10-26 00:00:00
2024-01-28T21:07:18.187069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T21:07:18.262766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-01-28T21:07:15.813340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T21:07:15.914872image/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위탁급식영업CJ프레시웨이(주)TPC점인천광역시 서구 백범로603번길 24 (가좌동)032-580-02142023-10-26
1위탁급식영업(주)동원홈푸드 인천도시가스인천광역시 서구 백범로934번길 23 (가좌동, 178-24)032-589-62002023-10-26
2위탁급식영업(주)현대그린푸드 현대차인천하이테크센터지점인천광역시 서구 가좌로83번길 22 (가좌동)032-578-23502023-10-26
3위탁급식영업(주)영타운FOOD서비스 경신공업<REPLACE>032-581-91272023-10-26
4위탁급식영업아라마크(주)삼양사 인천1공장인천광역시 서구 백범로718번길 6, 1층 (가좌동)032-570-80542023-10-26
5위탁급식영업진흥주물인천광역시 서구 원전로 27 (경서동)032-584-99012023-10-26
6위탁급식영업미래그린식당인천광역시 서구 중봉대로198번길 33 (가좌동, 602-36)032-572-34552023-10-26
7위탁급식영업(주)동원홈푸드 이오시스템인천광역시 서구 가재울로 38 (가좌동)032-290-16132023-10-26
8위탁급식영업비케이테크 구내식당인천광역시 서구 건지로97번길 33-32 (석남동, 223-233)032-575-12012023-10-26
9위탁급식영업연우푸드인천광역시 서구 가좌로 92, 4층 (가좌동)032-717-61902023-10-26
업종명업소명소재지(도로명)전화번호데이터기준일자
182위탁급식영업원창식당인천광역시 서구 북항단지로101번길 29, 1층 (원창동)<NA>2023-10-26
183위탁급식영업주식회사 가원푸드<REPLACE><NA>2023-10-26
184위탁급식영업행복이머무는곳인천광역시 서구 드림로 174 (백석동)<NA>2023-10-26
185위탁급식영업쿠킹스토리인천광역시 서구 검단로 46 (주)정우프랜트 1층 (오류동)<NA>2023-10-26
186위탁급식영업나인프라임푸드-아주인천레미콘인천광역시 서구 중봉대로198번길 2, 바동 1층일부 (가좌동)02-582-90902023-10-26
187위탁급식영업엄마밥상인천광역시 서구 보도진로42번길 8, 1층 (가좌동)<NA>2023-10-26
188위탁급식영업전라도한식뷔페인천광역시 서구 열우물로 221, 화미식자재 주식회사 (가좌동)<NA>2023-10-26
189위탁급식영업(주)동원홈푸드 검단로지스틱스파크점인천광역시 서구 드림로 700, 켄달스퀘어검단로지스틱스파크 9층 일부호 (당하동)02-589-60622023-10-26
190위탁급식영업현송 국립환경인재개발원점인천광역시 서구 환경로 42, 국립환경인재개발원 1층 (오류동)<NA>2023-10-26
191위탁급식영업씨에프지 주식회사인천광역시 서구 오류로26번길 9, 1층 (오류동)031-497-11802023-10-26

Duplicate rows

Most frequently occurring

업종명업소명소재지(도로명)전화번호데이터기준일자# duplicates
0위탁급식영업드림푸드<REPLACE><NA>2023-10-262