Overview

Dataset statistics

Number of variables44
Number of observations69
Missing cells715
Missing cells (%)23.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.6 KiB
Average record size in memory379.9 B

Variable types

Categorical22
Text5
DateTime3
Unsupported9
Numeric4
Boolean1

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),위생업태명,남성종사자수,여성종사자수,영업장주변구분명,등급구분명,급수시설구분명,총인원,본사종업원수,공장사무직종업원수,공장판매직종업원수,공장생산직종업원수,건물소유구분명,보증액,월세액,다중이용업소여부,시설총규모,전통업소지정번호,전통업소주된음식,홈페이지
Author노원구
URLhttps://data.seoul.go.kr/dataList/OA-18037/S/1/datasetView.do

Alerts

개방자치단체코드 has constant value ""Constant
업태구분명 has constant value ""Constant
다중이용업소여부 has constant value ""Constant
급수시설구분명 is highly imbalanced (68.1%)Imbalance
인허가취소일자 has 69 (100.0%) missing valuesMissing
폐업일자 has 19 (27.5%) missing valuesMissing
휴업시작일자 has 69 (100.0%) missing valuesMissing
휴업종료일자 has 69 (100.0%) missing valuesMissing
재개업일자 has 69 (100.0%) missing valuesMissing
전화번호 has 30 (43.5%) missing valuesMissing
소재지면적 has 4 (5.8%) missing valuesMissing
지번주소 has 1 (1.4%) missing valuesMissing
도로명주소 has 11 (15.9%) missing valuesMissing
도로명우편번호 has 15 (21.7%) missing valuesMissing
좌표정보(X) has 2 (2.9%) missing valuesMissing
좌표정보(Y) has 2 (2.9%) missing valuesMissing
영업장주변구분명 has 69 (100.0%) missing valuesMissing
등급구분명 has 69 (100.0%) missing valuesMissing
다중이용업소여부 has 10 (14.5%) missing valuesMissing
전통업소지정번호 has 69 (100.0%) missing valuesMissing
전통업소주된음식 has 69 (100.0%) missing valuesMissing
홈페이지 has 69 (100.0%) missing valuesMissing
관리번호 has unique valuesUnique
최종수정일자 has unique valuesUnique
인허가취소일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업시작일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
재개업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
영업장주변구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
등급구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
전통업소지정번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
전통업소주된음식 is an unsupported type, check if it needs cleaning or further analysisUnsupported
홈페이지 is an unsupported type, check if it needs cleaning or further analysisUnsupported
소재지면적 has 1 (1.4%) zerosZeros

Reproduction

Analysis started2024-05-11 08:01:31.090497
Analysis finished2024-05-11 08:01:31.728602
Duration0.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
3100000
69 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3100000 69
100.0%

Length

2024-05-11T17:01:31.812349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:31.930948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3100000 69
100.0%

관리번호
Text

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-05-11T17:01:32.122960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length22
Mean length22
Min length22

Characters and Unicode

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

Unique69 ?
Unique (%)100.0%

Sample

1st row3100000-122-2008-00001
2nd row3100000-122-2008-00002
3rd row3100000-122-2008-00003
4th row3100000-122-2008-00004
5th row3100000-122-2008-00005
ValueCountFrequency (%)
3100000-122-2008-00001 1
 
1.4%
3100000-122-2011-00007 1
 
1.4%
3100000-122-2017-00001 1
 
1.4%
3100000-122-2016-00001 1
 
1.4%
3100000-122-2015-00004 1
 
1.4%
3100000-122-2015-00003 1
 
1.4%
3100000-122-2015-00002 1
 
1.4%
3100000-122-2015-00001 1
 
1.4%
3100000-122-2013-00002 1
 
1.4%
3100000-122-2014-00001 1
 
1.4%
Other values (59) 59
85.5%
2024-05-11T17:01:32.494339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 717
47.2%
2 230
 
15.2%
1 209
 
13.8%
- 207
 
13.6%
3 85
 
5.6%
8 21
 
1.4%
7 12
 
0.8%
4 11
 
0.7%
9 11
 
0.7%
5 9
 
0.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1311
86.4%
Dash Punctuation 207
 
13.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 717
54.7%
2 230
 
17.5%
1 209
 
15.9%
3 85
 
6.5%
8 21
 
1.6%
7 12
 
0.9%
4 11
 
0.8%
9 11
 
0.8%
5 9
 
0.7%
6 6
 
0.5%
Dash Punctuation
ValueCountFrequency (%)
- 207
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1518
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 717
47.2%
2 230
 
15.2%
1 209
 
13.8%
- 207
 
13.6%
3 85
 
5.6%
8 21
 
1.4%
7 12
 
0.8%
4 11
 
0.7%
9 11
 
0.7%
5 9
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1518
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 717
47.2%
2 230
 
15.2%
1 209
 
13.8%
- 207
 
13.6%
3 85
 
5.6%
8 21
 
1.4%
7 12
 
0.8%
4 11
 
0.7%
9 11
 
0.7%
5 9
 
0.6%
Distinct65
Distinct (%)94.2%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2008-03-18 00:00:00
Maximum2024-03-13 00:00:00
2024-05-11T17:01:32.645264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T17:01:32.818587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
3
50 
1
19 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 50
72.5%
1 19
 
27.5%

Length

2024-05-11T17:01:32.946481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:33.071876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 50
72.5%
1 19
 
27.5%

영업상태명
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
폐업
50 
영업/정상
19 

Length

Max length5
Median length2
Mean length2.826087
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row영업/정상
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 50
72.5%
영업/정상 19
 
27.5%

Length

2024-05-11T17:01:33.199134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:33.318290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 50
72.5%
영업/정상 19
 
27.5%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
2
50 
1
19 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 50
72.5%
1 19
 
27.5%

Length

2024-05-11T17:01:33.447629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:33.565713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 50
72.5%
1 19
 
27.5%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
폐업
50 
영업
19 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row영업
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 50
72.5%
영업 19
 
27.5%

Length

2024-05-11T17:01:33.682725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:33.799341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 50
72.5%
영업 19
 
27.5%

폐업일자
Date

MISSING 

Distinct46
Distinct (%)92.0%
Missing19
Missing (%)27.5%
Memory size684.0 B
Minimum2009-12-16 00:00:00
Maximum2023-10-17 00:00:00
2024-05-11T17:01:33.927266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T17:01:34.089684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

전화번호
Text

MISSING 

Distinct37
Distinct (%)94.9%
Missing30
Missing (%)43.5%
Memory size684.0 B
2024-05-11T17:01:34.297232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.102564
Min length9

Characters and Unicode

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

Unique35 ?
Unique (%)89.7%

Sample

1st row02 9342422
2nd row02 9513961
3rd row029737972
4th row02 939 9579
5th row02 9347420
ValueCountFrequency (%)
02 31
34.1%
031 3
 
3.3%
4075 2
 
2.2%
029737972 2
 
2.2%
909 2
 
2.2%
939 2
 
2.2%
931 1
 
1.1%
4705835 1
 
1.1%
5929878 1
 
1.1%
34210151 1
 
1.1%
Other values (45) 45
49.5%
2024-05-11T17:01:35.005512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
71
16.4%
0 62
14.3%
2 54
12.5%
9 48
11.1%
7 38
8.8%
5 37
8.5%
1 34
7.9%
4 31
7.2%
3 30
6.9%
6 14
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 362
83.6%
Space Separator 71
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 62
17.1%
2 54
14.9%
9 48
13.3%
7 38
10.5%
5 37
10.2%
1 34
9.4%
4 31
8.6%
3 30
8.3%
6 14
 
3.9%
8 14
 
3.9%
Space Separator
ValueCountFrequency (%)
71
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 433
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
71
16.4%
0 62
14.3%
2 54
12.5%
9 48
11.1%
7 38
8.8%
5 37
8.5%
1 34
7.9%
4 31
7.2%
3 30
6.9%
6 14
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 433
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
71
16.4%
0 62
14.3%
2 54
12.5%
9 48
11.1%
7 38
8.8%
5 37
8.5%
1 34
7.9%
4 31
7.2%
3 30
6.9%
6 14
 
3.2%

소재지면적
Real number (ℝ)

MISSING  ZEROS 

Distinct55
Distinct (%)84.6%
Missing4
Missing (%)5.8%
Infinite0
Infinite (%)0.0%
Mean62.383231
Minimum0
Maximum950.52
Zeros1
Zeros (%)1.4%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-05-11T17:01:35.197835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile6.34
Q119.58
median31.16
Q348.08
95-th percentile100.76
Maximum950.52
Range950.52
Interquartile range (IQR)28.5

Descriptive statistics

Standard deviation154.26006
Coefficient of variation (CV)2.4727809
Kurtosis28.412553
Mean62.383231
Median Absolute Deviation (MAD)13.14
Skewness5.3513901
Sum4054.91
Variance23796.166
MonotonicityNot monotonic
2024-05-11T17:01:35.374139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
33.0 5
 
7.2%
3.3 2
 
2.9%
30.0 2
 
2.9%
66.0 2
 
2.9%
27.0 2
 
2.9%
19.17 2
 
2.9%
21.6 2
 
2.9%
866.9 1
 
1.4%
16.52 1
 
1.4%
25.0 1
 
1.4%
Other values (45) 45
65.2%
(Missing) 4
 
5.8%
ValueCountFrequency (%)
0.0 1
1.4%
3.3 2
2.9%
6.0 1
1.4%
7.7 1
1.4%
10.0 1
1.4%
11.26 1
1.4%
11.36 1
1.4%
13.0 1
1.4%
13.2 1
1.4%
14.4 1
1.4%
ValueCountFrequency (%)
950.52 1
1.4%
866.9 1
1.4%
144.0 1
1.4%
100.95 1
1.4%
100.0 1
1.4%
73.8 1
1.4%
72.76 1
1.4%
69.12 1
1.4%
66.11 1
1.4%
66.0 2
2.9%
Distinct34
Distinct (%)49.3%
Missing0
Missing (%)0.0%
Memory size684.0 B
139837
139240
139818
 
4
139809
 
4
139810
 
3
Other values (29)
43 

Length

Max length7
Median length6
Mean length6.057971
Min length4

Unique

Unique19 ?
Unique (%)27.5%

Sample

1st row139837
2nd row139876
3rd row139240
4th row139810
5th row139837

Common Values

ValueCountFrequency (%)
139837 8
 
11.6%
139240 7
 
10.1%
139818 4
 
5.8%
139809 4
 
5.8%
139810 3
 
4.3%
139872 3
 
4.3%
139845 3
 
4.3%
139813 3
 
4.3%
139847 3
 
4.3%
139814 2
 
2.9%
Other values (24) 29
42.0%

Length

2024-05-11T17:01:35.523753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
139837 8
 
11.6%
139240 7
 
10.1%
139818 4
 
5.8%
139809 4
 
5.8%
139810 3
 
4.3%
139872 3
 
4.3%
139845 3
 
4.3%
139813 3
 
4.3%
139847 3
 
4.3%
139846 2
 
2.9%
Other values (24) 29
42.0%

지번주소
Text

MISSING 

Distinct65
Distinct (%)95.6%
Missing1
Missing (%)1.4%
Memory size684.0 B
2024-05-11T17:01:35.824121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length30.5
Mean length24.25
Min length18

Characters and Unicode

Total characters1649
Distinct characters83
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

Unique62 ?
Unique (%)91.2%

Sample

1st row서울특별시 노원구 상계동 1038-2 외1필지 가동
2nd row서울특별시 노원구 상계동 1267 토마토파르코
3rd row서울특별시 노원구 공릉동 708 공릉2단지아파트상가 107호
4th row서울특별시 노원구 상계동 1293 불암현대아파트 상가동 120호
5th row서울특별시 노원구 상계동 1105-67
ValueCountFrequency (%)
서울특별시 68
20.8%
노원구 68
20.8%
상계동 36
 
11.0%
공릉동 15
 
4.6%
월계동 10
 
3.1%
1층 8
 
2.4%
하계동 5
 
1.5%
토마토파르코 2
 
0.6%
276-6 2
 
0.6%
102호 2
 
0.6%
Other values (101) 111
33.9%
2024-05-11T17:01:36.251001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
309
18.7%
1 93
 
5.6%
72
 
4.4%
69
 
4.2%
69
 
4.2%
69
 
4.2%
69
 
4.2%
68
 
4.1%
68
 
4.1%
68
 
4.1%
Other values (73) 695
42.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 899
54.5%
Decimal Number 378
22.9%
Space Separator 309
 
18.7%
Dash Punctuation 55
 
3.3%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%
Other Punctuation 2
 
0.1%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
72
 
8.0%
69
 
7.7%
69
 
7.7%
69
 
7.7%
69
 
7.7%
68
 
7.6%
68
 
7.6%
68
 
7.6%
68
 
7.6%
54
 
6.0%
Other values (57) 225
25.0%
Decimal Number
ValueCountFrequency (%)
1 93
24.6%
5 38
10.1%
3 37
 
9.8%
2 35
 
9.3%
0 34
 
9.0%
6 32
 
8.5%
4 30
 
7.9%
7 28
 
7.4%
9 26
 
6.9%
8 25
 
6.6%
Space Separator
ValueCountFrequency (%)
309
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 55
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 899
54.5%
Common 748
45.4%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
72
 
8.0%
69
 
7.7%
69
 
7.7%
69
 
7.7%
69
 
7.7%
68
 
7.6%
68
 
7.6%
68
 
7.6%
68
 
7.6%
54
 
6.0%
Other values (57) 225
25.0%
Common
ValueCountFrequency (%)
309
41.3%
1 93
 
12.4%
- 55
 
7.4%
5 38
 
5.1%
3 37
 
4.9%
2 35
 
4.7%
0 34
 
4.5%
6 32
 
4.3%
4 30
 
4.0%
7 28
 
3.7%
Other values (5) 57
 
7.6%
Latin
ValueCountFrequency (%)
B 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 899
54.5%
ASCII 750
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
309
41.2%
1 93
 
12.4%
- 55
 
7.3%
5 38
 
5.1%
3 37
 
4.9%
2 35
 
4.7%
0 34
 
4.5%
6 32
 
4.3%
4 30
 
4.0%
7 28
 
3.7%
Other values (6) 59
 
7.9%
Hangul
ValueCountFrequency (%)
72
 
8.0%
69
 
7.7%
69
 
7.7%
69
 
7.7%
69
 
7.7%
68
 
7.6%
68
 
7.6%
68
 
7.6%
68
 
7.6%
54
 
6.0%
Other values (57) 225
25.0%

도로명주소
Text

MISSING 

Distinct58
Distinct (%)100.0%
Missing11
Missing (%)15.9%
Memory size684.0 B
2024-05-11T17:01:36.555122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length77
Median length41
Mean length37.534483
Min length22

Characters and Unicode

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

Unique58 ?
Unique (%)100.0%

Sample

1st row서울특별시 노원구 동일로 1700, 421호 (상계동, 토마토파르코)
2nd row서울특별시 노원구 동일로 1127, 107호 (공릉동, 공릉2단지아파트상가)
3rd row서울특별시 노원구 덕릉로118길 29, 상가동 1층 120호 (상계동, 불암현대아파트)
4th row서울특별시 노원구 동일로237다길 52 (상계동)
5th row서울특별시 노원구 상계로17길 20 (상계동)
ValueCountFrequency (%)
서울특별시 58
 
14.0%
노원구 58
 
14.0%
상계동 34
 
8.2%
1층 17
 
4.1%
공릉동 11
 
2.7%
월계동 11
 
2.7%
102호 5
 
1.2%
동일로 5
 
1.2%
동일로184길 4
 
1.0%
3층 3
 
0.7%
Other values (162) 208
50.2%
2024-05-11T17:01:36.990722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
356
 
16.4%
1 127
 
5.8%
86
 
4.0%
, 70
 
3.2%
65
 
3.0%
2 62
 
2.8%
) 61
 
2.8%
( 61
 
2.8%
60
 
2.8%
59
 
2.7%
Other values (95) 1170
53.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1179
54.2%
Decimal Number 433
 
19.9%
Space Separator 356
 
16.4%
Other Punctuation 70
 
3.2%
Close Punctuation 61
 
2.8%
Open Punctuation 61
 
2.8%
Dash Punctuation 13
 
0.6%
Uppercase Letter 4
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
 
7.3%
65
 
5.5%
60
 
5.1%
59
 
5.0%
59
 
5.0%
59
 
5.0%
59
 
5.0%
58
 
4.9%
58
 
4.9%
58
 
4.9%
Other values (77) 558
47.3%
Decimal Number
ValueCountFrequency (%)
1 127
29.3%
2 62
14.3%
3 53
12.2%
0 47
 
10.9%
4 38
 
8.8%
5 28
 
6.5%
7 22
 
5.1%
6 21
 
4.8%
8 18
 
4.2%
9 17
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
E 2
50.0%
B 1
25.0%
A 1
25.0%
Space Separator
ValueCountFrequency (%)
356
100.0%
Other Punctuation
ValueCountFrequency (%)
, 70
100.0%
Close Punctuation
ValueCountFrequency (%)
) 61
100.0%
Open Punctuation
ValueCountFrequency (%)
( 61
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1179
54.2%
Common 994
45.7%
Latin 4
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
 
7.3%
65
 
5.5%
60
 
5.1%
59
 
5.0%
59
 
5.0%
59
 
5.0%
59
 
5.0%
58
 
4.9%
58
 
4.9%
58
 
4.9%
Other values (77) 558
47.3%
Common
ValueCountFrequency (%)
356
35.8%
1 127
 
12.8%
, 70
 
7.0%
2 62
 
6.2%
) 61
 
6.1%
( 61
 
6.1%
3 53
 
5.3%
0 47
 
4.7%
4 38
 
3.8%
5 28
 
2.8%
Other values (5) 91
 
9.2%
Latin
ValueCountFrequency (%)
E 2
50.0%
B 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1179
54.2%
ASCII 998
45.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
356
35.7%
1 127
 
12.7%
, 70
 
7.0%
2 62
 
6.2%
) 61
 
6.1%
( 61
 
6.1%
3 53
 
5.3%
0 47
 
4.7%
4 38
 
3.8%
5 28
 
2.8%
Other values (8) 95
 
9.5%
Hangul
ValueCountFrequency (%)
86
 
7.3%
65
 
5.5%
60
 
5.1%
59
 
5.0%
59
 
5.0%
59
 
5.0%
59
 
5.0%
58
 
4.9%
58
 
4.9%
58
 
4.9%
Other values (77) 558
47.3%

도로명우편번호
Real number (ℝ)

MISSING 

Distinct37
Distinct (%)68.5%
Missing15
Missing (%)21.7%
Infinite0
Infinite (%)0.0%
Mean1733.5926
Minimum1608
Maximum1899
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-05-11T17:01:37.145365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1608
5-th percentile1614.95
Q11638
median1682
Q31844
95-th percentile1898
Maximum1899
Range291
Interquartile range (IQR)206

Descriptive statistics

Standard deviation106.67753
Coefficient of variation (CV)0.061535524
Kurtosis-1.668048
Mean1733.5926
Median Absolute Deviation (MAD)58
Skewness0.37550388
Sum93614
Variance11380.095
MonotonicityNot monotonic
2024-05-11T17:01:37.292233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
1638 4
 
5.8%
1898 3
 
4.3%
1844 3
 
4.3%
1684 3
 
4.3%
1830 3
 
4.3%
1665 2
 
2.9%
1848 2
 
2.9%
1634 2
 
2.9%
1624 2
 
2.9%
1643 2
 
2.9%
Other values (27) 28
40.6%
(Missing) 15
21.7%
ValueCountFrequency (%)
1608 1
 
1.4%
1609 1
 
1.4%
1613 1
 
1.4%
1616 1
 
1.4%
1624 2
2.9%
1629 1
 
1.4%
1631 1
 
1.4%
1634 2
2.9%
1635 1
 
1.4%
1638 4
5.8%
ValueCountFrequency (%)
1899 1
 
1.4%
1898 3
4.3%
1896 2
2.9%
1867 1
 
1.4%
1860 1
 
1.4%
1858 1
 
1.4%
1851 1
 
1.4%
1848 2
2.9%
1845 1
 
1.4%
1844 3
4.3%
Distinct67
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-05-11T17:01:37.545117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length13
Mean length7.057971
Min length2

Characters and Unicode

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

Unique

Unique65 ?
Unique (%)94.2%

Sample

1st row농협FS 상계물류출장소
2nd row(주)선명푸드
3rd row대농바이오영농조합농수산
4th row대신푸드 서울지사
5th row(주)푸드동원
ValueCountFrequency (%)
주식회사 6
 
6.5%
케이제이푸드 2
 
2.2%
태서식품 2
 
2.2%
서울지사 2
 
2.2%
대농바이오영농조합농수산 2
 
2.2%
함박식품 1
 
1.1%
주)청미원식품 1
 
1.1%
농업회사법인 1
 
1.1%
상계지점 1
 
1.1%
대상베스코(주 1
 
1.1%
Other values (74) 74
79.6%
2024-05-11T17:01:37.977363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25
 
5.1%
23
 
4.7%
20
 
4.1%
17
 
3.5%
16
 
3.3%
( 14
 
2.9%
) 14
 
2.9%
14
 
2.9%
11
 
2.3%
11
 
2.3%
Other values (152) 322
66.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 421
86.4%
Space Separator 25
 
5.1%
Open Punctuation 14
 
2.9%
Close Punctuation 14
 
2.9%
Uppercase Letter 11
 
2.3%
Other Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
23
 
5.5%
20
 
4.8%
17
 
4.0%
16
 
3.8%
14
 
3.3%
11
 
2.6%
11
 
2.6%
11
 
2.6%
11
 
2.6%
9
 
2.1%
Other values (140) 278
66.0%
Uppercase Letter
ValueCountFrequency (%)
S 3
27.3%
F 2
18.2%
D 2
18.2%
L 1
 
9.1%
H 1
 
9.1%
M 1
 
9.1%
T 1
 
9.1%
Other Punctuation
ValueCountFrequency (%)
. 1
50.0%
/ 1
50.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 421
86.4%
Common 55
 
11.3%
Latin 11
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
23
 
5.5%
20
 
4.8%
17
 
4.0%
16
 
3.8%
14
 
3.3%
11
 
2.6%
11
 
2.6%
11
 
2.6%
11
 
2.6%
9
 
2.1%
Other values (140) 278
66.0%
Latin
ValueCountFrequency (%)
S 3
27.3%
F 2
18.2%
D 2
18.2%
L 1
 
9.1%
H 1
 
9.1%
M 1
 
9.1%
T 1
 
9.1%
Common
ValueCountFrequency (%)
25
45.5%
( 14
25.5%
) 14
25.5%
. 1
 
1.8%
/ 1
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 421
86.4%
ASCII 66
 
13.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
25
37.9%
( 14
21.2%
) 14
21.2%
S 3
 
4.5%
F 2
 
3.0%
D 2
 
3.0%
. 1
 
1.5%
L 1
 
1.5%
H 1
 
1.5%
M 1
 
1.5%
Other values (2) 2
 
3.0%
Hangul
ValueCountFrequency (%)
23
 
5.5%
20
 
4.8%
17
 
4.0%
16
 
3.8%
14
 
3.3%
11
 
2.6%
11
 
2.6%
11
 
2.6%
11
 
2.6%
9
 
2.1%
Other values (140) 278
66.0%

최종수정일자
Date

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2008-08-12 09:06:44
Maximum2024-03-13 13:30:39
2024-05-11T17:01:38.159140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T17:01:38.352506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
I
40 
U
29 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowI
2nd rowU
3rd rowI
4th rowU
5th rowU

Common Values

ValueCountFrequency (%)
I 40
58.0%
U 29
42.0%

Length

2024-05-11T17:01:38.496051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:38.601573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 40
58.0%
u 29
42.0%
Distinct32
Distinct (%)46.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
2018-08-31 23:59:59.0
34 
2021-09-16 02:40:00.0
2021-08-06 02:40:00.0
 
2
2021-10-28 02:40:00.0
 
1
2019-03-28 02:40:00.0
 
1
Other values (27)
27 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique29 ?
Unique (%)42.0%

Sample

1st row2018-08-31 23:59:59.0
2nd row2021-01-31 02:40:00.0
3rd row2018-08-31 23:59:59.0
4th row2021-09-16 02:40:00.0
5th row2021-09-16 02:40:00.0

Common Values

ValueCountFrequency (%)
2018-08-31 23:59:59.0 34
49.3%
2021-09-16 02:40:00.0 4
 
5.8%
2021-08-06 02:40:00.0 2
 
2.9%
2021-10-28 02:40:00.0 1
 
1.4%
2019-03-28 02:40:00.0 1
 
1.4%
2020-12-12 02:40:00.0 1
 
1.4%
2021-12-26 02:40:00.0 1
 
1.4%
2020-10-24 02:40:00.0 1
 
1.4%
2020-09-04 02:40:00.0 1
 
1.4%
2021-12-29 02:40:00.0 1
 
1.4%
Other values (22) 22
31.9%

Length

2024-05-11T17:01:38.711397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2018-08-31 34
24.6%
23:59:59.0 34
24.6%
02:40:00.0 23
16.7%
2021-09-16 4
 
2.9%
00:08:00.0 2
 
1.4%
22:00:00.0 2
 
1.4%
2021-12-07 2
 
1.4%
2021-10-31 2
 
1.4%
2021-08-06 2
 
1.4%
2021-10-09 1
 
0.7%
Other values (32) 32
23.2%

업태구분명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
집단급식소 식품판매업
69 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row집단급식소 식품판매업
2nd row집단급식소 식품판매업
3rd row집단급식소 식품판매업
4th row집단급식소 식품판매업
5th row집단급식소 식품판매업

Common Values

ValueCountFrequency (%)
집단급식소 식품판매업 69
100.0%

Length

2024-05-11T17:01:38.838573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:38.931864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
집단급식소 69
50.0%
식품판매업 69
50.0%

좌표정보(X)
Real number (ℝ)

MISSING 

Distinct60
Distinct (%)89.6%
Missing2
Missing (%)2.9%
Infinite0
Infinite (%)0.0%
Mean205960.06
Minimum204525.9
Maximum207296.87
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-05-11T17:01:39.034295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum204525.9
5-th percentile204605.63
Q1205054.06
median206175.59
Q3206600.89
95-th percentile207083.11
Maximum207296.87
Range2770.962
Interquartile range (IQR)1546.8315

Descriptive statistics

Standard deviation857.92587
Coefficient of variation (CV)0.0041654963
Kurtosis-1.3310686
Mean205960.06
Median Absolute Deviation (MAD)700.8097
Skewness-0.28635723
Sum13799324
Variance736036.81
MonotonicityNot monotonic
2024-05-11T17:01:39.178958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
206505.502253248 2
 
2.9%
204855.557180678 2
 
2.9%
207083.109226474 2
 
2.9%
207074.881686427 2
 
2.9%
204932.271577452 2
 
2.9%
206156.733065162 2
 
2.9%
206594.474351648 2
 
2.9%
205227.311831513 1
 
1.4%
205385.531198398 1
 
1.4%
206652.055955646 1
 
1.4%
Other values (50) 50
72.5%
(Missing) 2
 
2.9%
ValueCountFrequency (%)
204525.903979787 1
1.4%
204580.819432231 1
1.4%
204581.530700899 1
1.4%
204585.410085358 1
1.4%
204652.810032 1
1.4%
204734.215962567 1
1.4%
204737.508832979 1
1.4%
204738.040906241 1
1.4%
204750.707725 1
1.4%
204855.557180678 2
2.9%
ValueCountFrequency (%)
207296.865929891 1
1.4%
207266.309693444 1
1.4%
207131.576339305 1
1.4%
207083.109226474 2
2.9%
207074.881686427 2
2.9%
206966.805542515 1
1.4%
206948.010916259 1
1.4%
206899.827287 1
1.4%
206844.984180858 1
1.4%
206822.49898149 1
1.4%

좌표정보(Y)
Real number (ℝ)

MISSING 

Distinct60
Distinct (%)89.6%
Missing2
Missing (%)2.9%
Infinite0
Infinite (%)0.0%
Mean460698.02
Minimum457170.95
Maximum464199.05
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-05-11T17:01:39.335845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum457170.95
5-th percentile457430.59
Q1458022.9
median461797.48
Q3462901.05
95-th percentile463768.43
Maximum464199.05
Range7028.1004
Interquartile range (IQR)4878.1442

Descriptive statistics

Standard deviation2446.566
Coefficient of variation (CV)0.0053105634
Kurtosis-1.731414
Mean460698.02
Median Absolute Deviation (MAD)1971.4663
Skewness-0.14889311
Sum30866767
Variance5985685.3
MonotonicityNot monotonic
2024-05-11T17:01:39.501991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
457953.648749554 2
 
2.9%
464199.048415229 2
 
2.9%
457849.860898568 2
 
2.9%
463222.345449377 2
 
2.9%
457409.966707104 2
 
2.9%
459169.464921021 2
 
2.9%
458013.119839851 2
 
2.9%
457170.948044949 1
 
1.4%
457590.352240344 1
 
1.4%
462558.789149166 1
 
1.4%
Other values (50) 50
72.5%
(Missing) 2
 
2.9%
ValueCountFrequency (%)
457170.948044949 1
1.4%
457409.966707104 2
2.9%
457422.030817503 1
1.4%
457450.548718732 1
1.4%
457552.114597613 1
1.4%
457574.052910992 1
1.4%
457590.352240344 1
1.4%
457591.325 1
1.4%
457660.523388564 1
1.4%
457849.860898568 2
2.9%
ValueCountFrequency (%)
464199.048415229 2
2.9%
463777.629639984 1
1.4%
463768.944060895 1
1.4%
463767.235264912 1
1.4%
463724.591075496 1
1.4%
463401.987926472 1
1.4%
463389.40284285 1
1.4%
463290.410210672 1
1.4%
463247.302380066 1
1.4%
463223.665937 1
1.4%

위생업태명
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
집단급식소 식품판매업
59 
<NA>
10 

Length

Max length11
Median length11
Mean length9.9855072
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row집단급식소 식품판매업
2nd row집단급식소 식품판매업
3rd row집단급식소 식품판매업
4th row집단급식소 식품판매업
5th row집단급식소 식품판매업

Common Values

ValueCountFrequency (%)
집단급식소 식품판매업 59
85.5%
<NA> 10
 
14.5%

Length

2024-05-11T17:01:39.720936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:39.850698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
집단급식소 59
46.1%
식품판매업 59
46.1%
na 10
 
7.8%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
56 
0
13 

Length

Max length4
Median length4
Mean length3.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 56
81.2%
0 13
 
18.8%

Length

2024-05-11T17:01:39.982517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:40.100026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 56
81.2%
0 13
 
18.8%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
56 
0
13 

Length

Max length4
Median length4
Mean length3.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 56
81.2%
0 13
 
18.8%

Length

2024-05-11T17:01:40.216171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:40.324514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 56
81.2%
0 13
 
18.8%

영업장주변구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

등급구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

급수시설구분명
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
65 
상수도전용
 
4

Length

Max length5
Median length4
Mean length4.057971
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 65
94.2%
상수도전용 4
 
5.8%

Length

2024-05-11T17:01:40.458331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:40.572563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 65
94.2%
상수도전용 4
 
5.8%

총인원
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
56 
0
13 

Length

Max length4
Median length4
Mean length3.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 56
81.2%
0 13
 
18.8%

Length

2024-05-11T17:01:40.690875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:40.804101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 56
81.2%
0 13
 
18.8%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
44 
0
25 

Length

Max length4
Median length4
Mean length2.9130435
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 44
63.8%
0 25
36.2%

Length

2024-05-11T17:01:40.928746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:41.051086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 44
63.8%
0 25
36.2%
Distinct4
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
42 
0
24 
3
 
2
1
 
1

Length

Max length4
Median length4
Mean length2.826087
Min length1

Unique

Unique1 ?
Unique (%)1.4%

Sample

1st row0
2nd row0
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 42
60.9%
0 24
34.8%
3 2
 
2.9%
1 1
 
1.4%

Length

2024-05-11T17:01:41.177281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:41.334601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 42
60.9%
0 24
34.8%
3 2
 
2.9%
1 1
 
1.4%
Distinct4
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
43 
0
24 
1
 
1
3
 
1

Length

Max length4
Median length4
Mean length2.8695652
Min length1

Unique

Unique2 ?
Unique (%)2.9%

Sample

1st row0
2nd row0
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 43
62.3%
0 24
34.8%
1 1
 
1.4%
3 1
 
1.4%

Length

2024-05-11T17:01:41.488100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:41.611827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 43
62.3%
0 24
34.8%
1 1
 
1.4%
3 1
 
1.4%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
44 
0
25 

Length

Max length4
Median length4
Mean length2.9130435
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 44
63.8%
0 25
36.2%

Length

2024-05-11T17:01:41.738871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:41.865318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 44
63.8%
0 25
36.2%
Distinct3
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
33 
자가
20 
임대
16 

Length

Max length4
Median length2
Mean length2.9565217
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 33
47.8%
자가 20
29.0%
임대 16
23.2%

Length

2024-05-11T17:01:42.002162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:42.130313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 33
47.8%
자가 20
29.0%
임대 16
23.2%

보증액
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
56 
0
13 

Length

Max length4
Median length4
Mean length3.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 56
81.2%
0 13
 
18.8%

Length

2024-05-11T17:01:42.250237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:42.376174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 56
81.2%
0 13
 
18.8%

월세액
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
56 
0
13 

Length

Max length4
Median length4
Mean length3.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row0
5th row0

Common Values

ValueCountFrequency (%)
<NA> 56
81.2%
0 13
 
18.8%

Length

2024-05-11T17:01:42.479153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:42.624942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 56
81.2%
0 13
 
18.8%

다중이용업소여부
Boolean

CONSTANT  MISSING 

Distinct1
Distinct (%)1.7%
Missing10
Missing (%)14.5%
Memory size270.0 B
False
59 
(Missing)
10 
ValueCountFrequency (%)
False 59
85.5%
(Missing) 10
 
14.5%
2024-05-11T17:01:43.033003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

시설총규모
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
0
59 
<NA>
10 

Length

Max length4
Median length1
Mean length1.4347826
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 59
85.5%
<NA> 10
 
14.5%

Length

2024-05-11T17:01:43.150411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T17:01:43.278594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 59
85.5%
na 10
 
14.5%

전통업소지정번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

전통업소주된음식
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

홈페이지
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing69
Missing (%)100.0%
Memory size753.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)위생업태명남성종사자수여성종사자수영업장주변구분명등급구분명급수시설구분명총인원본사종업원수공장사무직종업원수공장판매직종업원수공장생산직종업원수건물소유구분명보증액월세액다중이용업소여부시설총규모전통업소지정번호전통업소주된음식홈페이지
031000003100000-122-2008-0000120080318<NA>3폐업2폐업20100225<NA><NA><NA>02 9342422950.52139837서울특별시 노원구 상계동 1038-2 외1필지 가동<NA><NA>농협FS 상계물류출장소2009-01-22 14:11:03I2018-08-31 23:59:59.0집단급식소 식품판매업204738.040906463290.410211집단급식소 식품판매업<NA><NA><NA><NA><NA><NA>0000<NA><NA><NA>N0<NA><NA><NA>
131000003100000-122-2008-0000220080318<NA>1영업/정상1영업<NA><NA><NA><NA>02 951396132.96139876서울특별시 노원구 상계동 1267 토마토파르코서울특별시 노원구 동일로 1700, 421호 (상계동, 토마토파르코)1624(주)선명푸드2021-01-29 13:58:48U2021-01-31 02:40:00.0집단급식소 식품판매업204855.557181464199.048415집단급식소 식품판매업<NA><NA><NA><NA><NA><NA>0000<NA><NA><NA>N0<NA><NA><NA>
231000003100000-122-2008-0000320080521<NA>3폐업2폐업20170407<NA><NA><NA>02973797221.6139240서울특별시 노원구 공릉동 708 공릉2단지아파트상가 107호서울특별시 노원구 동일로 1127, 107호 (공릉동, 공릉2단지아파트상가)1851대농바이오영농조합농수산2017-04-07 15:13:10I2018-08-31 23:59:59.0집단급식소 식품판매업206059.274181458660.029586집단급식소 식품판매업<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>N0<NA><NA><NA>
331000003100000-122-2008-0000420080703<NA>3폐업2폐업20210906<NA><NA><NA>02 939 957911.26139810서울특별시 노원구 상계동 1293 불암현대아파트 상가동 120호서울특별시 노원구 덕릉로118길 29, 상가동 1층 120호 (상계동, 불암현대아파트)1646대신푸드 서울지사2021-09-14 15:25:06U2021-09-16 02:40:00.0집단급식소 식품판매업207131.576339462829.181657집단급식소 식품판매업00<NA><NA><NA>00000<NA>00N0<NA><NA><NA>
431000003100000-122-2008-0000520080710<NA>3폐업2폐업20210906<NA><NA><NA>02 9347420<NA>139837서울특별시 노원구 상계동 1105-67서울특별시 노원구 동일로237다길 52 (상계동)1609(주)푸드동원2021-09-14 15:29:55U2021-09-16 02:40:00.0집단급식소 식품판매업204581.530701463724.591075집단급식소 식품판매업00<NA><NA><NA>00000<NA>00N0<NA><NA><NA>
531000003100000-122-2008-0000620080804<NA>3폐업2폐업20211025<NA><NA><NA><NA><NA>139818서울특별시 노원구 상계동 389-555서울특별시 노원구 상계로17길 20 (상계동)1684(주)원터상사2021-10-26 14:59:41U2021-10-28 02:40:00.0집단급식소 식품판매업205912.254205461827.402394집단급식소 식품판매업00<NA><NA><NA>00000<NA>00N0<NA><NA><NA>
631000003100000-122-2008-0000720080812<NA>3폐업2폐업20111123<NA><NA><NA><NA>0.0139818서울특별시 노원구 상계동 389-376<NA><NA>맛미유통2008-08-12 09:06:44I2018-08-31 23:59:59.0집단급식소 식품판매업205953.547255461945.894988집단급식소 식품판매업<NA><NA><NA><NA>상수도전용<NA><NA>3<NA><NA>임대<NA><NA>N0<NA><NA><NA>
731000003100000-122-2008-0000820080911<NA>3폐업2폐업20180420<NA><NA><NA>02 975 666733.0139846서울특별시 노원구 월계동 429-75서울특별시 노원구 석계로 63 (월계동)1896삼육두유2018-04-20 14:46:14I2018-08-31 23:59:59.0집단급식소 식품판매업205474.779367457552.114598집단급식소 식품판매업<NA><NA><NA><NA><NA><NA><NA>11<NA>임대<NA><NA>N0<NA><NA><NA>
831000003100000-122-2008-0000920080916<NA>3폐업2폐업20190326<NA><NA><NA>02 9375146<NA>139809서울특별시 노원구 상계동 71-178서울특별시 노원구 덕릉로126라길 2 (상계동, 상계동 1구역8블럭14롯트)1643삼육식품 공릉대리점2019-03-26 13:34:06U2019-03-28 02:40:00.0집단급식소 식품판매업207296.86593463159.428901집단급식소 식품판매업<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>N0<NA><NA><NA>
931000003100000-122-2008-0001020080924<NA>3폐업2폐업20120102<NA><NA><NA>02 937255534.0139837서울특별시 노원구 상계동 1107-129<NA><NA>옥 당2010-01-29 11:05:30I2018-08-31 23:59:59.0집단급식소 식품판매업204525.90398463777.62964집단급식소 식품판매업<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>자가<NA><NA>N0<NA><NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)위생업태명남성종사자수여성종사자수영업장주변구분명등급구분명급수시설구분명총인원본사종업원수공장사무직종업원수공장판매직종업원수공장생산직종업원수건물소유구분명보증액월세액다중이용업소여부시설총규모전통업소지정번호전통업소주된음식홈페이지
5931000003100000-122-2018-0000320180720<NA>1영업/정상1영업<NA><NA><NA><NA><NA>20.0139814서울특별시 노원구 상계동 138-159서울특별시 노원구 한글비석로24바길 48, 1층 1호 (상계동)1659(주)아라푸드2021-10-07 09:32:57U2021-10-09 02:40:00.0집단급식소 식품판매업206278.41482462528.074481집단급식소 식품판매업00<NA><NA><NA>00000임대00N0<NA><NA><NA>
6031000003100000-122-2019-0000120190820<NA>1영업/정상1영업<NA><NA><NA><NA><NA>34.81139872서울특별시 노원구 하계동 276-1 한국야쿠르트 하계관리점서울특별시 노원구 공릉로59가길 9, 한국야쿠르트 하계관리점 212호 (하계동)1830더브러푸드2021-10-14 09:26:18U2021-10-16 02:40:00.0집단급식소 식품판매업206201.840029459064.752797집단급식소 식품판매업00<NA><NA><NA>00000<NA>00N0<NA><NA><NA>
6131000003100000-122-2019-0000220190905<NA>1영업/정상1영업<NA><NA><NA><NA>02 943331439.6139846서울특별시 노원구 월계동 475-35 영광상가서울특별시 노원구 광운로2나길 11, 영광상가 A동 101호 (월계동)1899한국농협김치 북부총판2022-11-15 14:19:58U2021-10-31 23:07:00.0집단급식소 식품판매업205227.311832457170.948045<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6231000003100000-122-2020-0000120200428<NA>1영업/정상1영업<NA><NA><NA><NA><NA>28.31139837서울특별시 노원구 상계동 1055 공인중개사서울특별시 노원구 동일로237길 37, 상가동 1층 104, 105호 (상계동)1613서울북부티엠에스(서울북부TMS)2020-04-28 11:15:56I2020-04-30 00:23:21.0집단급식소 식품판매업204585.410085463389.402843집단급식소 식품판매업<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>N0<NA><NA><NA>
6331000003100000-122-2021-0000120210308<NA>1영업/정상1영업<NA><NA><NA><NA>0704062175337.34139811서울특별시 노원구 상계동 111-272서울특별시 노원구 상계로35가길 6, 1층 2호 (상계동)1635서울우유 태성유통2022-03-04 15:58:58I2022-03-10 13:22:36.0집단급식소 식품판매업<NA><NA>집단급식소 식품판매업00<NA><NA><NA>00000임대00N0<NA><NA><NA>
6431000003100000-122-2023-000012023-03-13<NA>1영업/정상1영업<NA><NA><NA><NA>02 931 622211.36139-822서울특별시 노원구 상계동 649 12단지 종합상가서울특별시 노원구 동일로 1538, 12단지 종합상가 지하1층 4호중 일부 6호 (상계동)1674호정2023-03-13 17:48:11I2022-12-02 23:05:00.0집단급식소 식품판매업205039.2221462624.307077<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6531000003100000-122-2023-000022023-07-28<NA>3폐업2폐업2023-10-17<NA><NA><NA><NA>3.3139-240서울특별시 노원구 공릉동 513-48 주인맨션서울특별시 노원구 동일로184길 35, 지하1층 E 92호 (공릉동, 주인맨션)1844미소식품2023-10-17 10:44:49U2022-10-30 23:09:00.0집단급식소 식품판매업206594.474352458013.11984<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6631000003100000-122-2023-000032023-08-09<NA>1영업/정상1영업<NA><NA><NA><NA><NA>3.3139-240서울특별시 노원구 공릉동 513-48 주인맨션서울특별시 노원구 동일로184길 35, B1층 E-85호 (공릉동, 주인맨션)1844참좋은식품2023-08-09 09:48:01I2022-12-07 23:01:00.0집단급식소 식품판매업206594.474352458013.11984<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6731000003100000-122-2023-000042023-09-21<NA>1영업/정상1영업<NA><NA><NA><NA>02 931400113.0139-927서울특별시 노원구 중계동 445 염광아파트서울특별시 노원구 덕릉로79길 23, 상가동 102호 (중계동, 염광아파트)1701아이누리중랑튼튼2023-09-21 10:18:49I2022-12-08 22:03:00.0집단급식소 식품판매업206367.374707461535.726024<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>
6831000003100000-122-2024-000012024-03-13<NA>1영업/정상1영업<NA><NA><NA><NA>02 756 724113.2139-810서울특별시 노원구 상계동 101-13 성원빌딩서울특별시 노원구 덕릉로115길 8, 성원빌딩 지하1층 102호 (상계동)1638(주)피노핀2024-03-13 13:30:39I2023-12-02 23:06:00.0집단급식소 식품판매업206795.370007462716.329869<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>