Overview

Dataset statistics

Number of variables27
Number of observations28
Missing cells202
Missing cells (%)26.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.4 KiB
Average record size in memory235.7 B

Variable types

Categorical11
Numeric3
DateTime3
Unsupported6
Text4

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),제조구분명,사업장부지용도구분명
Author강북구
URLhttps://data.seoul.go.kr/dataList/OA-19010/S/1/datasetView.do

Alerts

개방자치단체코드 has constant value ""Constant
폐업일자 is highly imbalanced (57.8%)Imbalance
재개업일자 is highly imbalanced (77.8%)Imbalance
도로명우편번호 is highly imbalanced (66.9%)Imbalance
업태구분명 is highly imbalanced (77.8%)Imbalance
인허가취소일자 has 28 (100.0%) missing valuesMissing
휴업시작일자 has 28 (100.0%) missing valuesMissing
휴업종료일자 has 28 (100.0%) missing valuesMissing
전화번호 has 28 (100.0%) missing valuesMissing
소재지면적 has 28 (100.0%) missing valuesMissing
소재지우편번호 has 28 (100.0%) missing valuesMissing
지번주소 has 1 (3.6%) missing valuesMissing
도로명주소 has 7 (25.0%) missing valuesMissing
좌표정보(X) has 4 (14.3%) missing valuesMissing
좌표정보(Y) has 4 (14.3%) missing valuesMissing
사업장부지용도구분명 has 18 (64.3%) 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

Reproduction

Analysis started2024-05-10 23:59:25.129699
Analysis finished2024-05-10 23:59:26.028889
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
3080000
28 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3080000 28
100.0%

Length

2024-05-10T23:59:26.327864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:26.676801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3080000 28
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0049866 × 1018
Minimum1.982308 × 1018
Maximum2.021308 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-05-10T23:59:27.002108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.982308 × 1018
5-th percentile1.985358 × 1018
Q12.000058 × 1018
median2.006308 × 1018
Q32.011308 × 1018
95-th percentile2.019908 × 1018
Maximum2.021308 × 1018
Range3.9000007 × 1016
Interquartile range (IQR)1.1250006 × 1016

Descriptive statistics

Standard deviation1.0652957 × 1016
Coefficient of variation (CV)0.0053132313
Kurtosis-0.25633015
Mean2.0049866 × 1018
Median Absolute Deviation (MAD)5.0000047 × 1015
Skewness-0.57899192
Sum7.9939207 × 1017
Variance1.134855 × 1032
MonotonicityStrictly increasing
2024-05-10T23:59:27.464685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
1982308007502200001 1
 
3.6%
2007308009202100001 1
 
3.6%
2021308014702200002 1
 
3.6%
2021308014702200001 1
 
3.6%
2017308014702200002 1
 
3.6%
2017308014702200001 1
 
3.6%
2017308014702100001 1
 
3.6%
2011308013902200003 1
 
3.6%
2011308013902200002 1
 
3.6%
2011308013902200001 1
 
3.6%
Other values (18) 18
64.3%
ValueCountFrequency (%)
1982308007502200001 1
3.6%
1984308007502100001 1
3.6%
1987308007502100001 1
3.6%
1989308007502200001 1
3.6%
1991308007502200001 1
3.6%
1997308007502100001 1
3.6%
1999308007502200001 1
3.6%
2000308007502200002 1
3.6%
2001308007502100001 1
3.6%
2002308007502100001 1
3.6%
ValueCountFrequency (%)
2021308014702200002 1
3.6%
2021308014702200001 1
3.6%
2017308014702200002 1
3.6%
2017308014702200001 1
3.6%
2017308014702100001 1
3.6%
2011308013902200003 1
3.6%
2011308013902200002 1
3.6%
2011308013902200001 1
3.6%
2011308013902100001 1
3.6%
2010308013902100001 1
3.6%

인허가일자
Date

Distinct26
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Memory size356.0 B
Minimum1982-08-17 00:00:00
Maximum2021-09-29 00:00:00
2024-05-10T23:59:28.038838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T23:59:28.602702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

영업상태코드
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
1
22 
3
6 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 22
78.6%
3 6
 
21.4%

Length

2024-05-10T23:59:29.221431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:29.645205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 22
78.6%
3 6
 
21.4%

영업상태명
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
영업/정상
22 
폐업
6 

Length

Max length5
Median length5
Mean length4.3571429
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업/정상 22
78.6%
폐업 6
 
21.4%

Length

2024-05-10T23:59:30.159274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:30.493499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 22
78.6%
폐업 6
 
21.4%

상세영업상태코드
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
1
22 
3
6 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 22
78.6%
3 6
 
21.4%

Length

2024-05-10T23:59:30.840062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:31.147823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 22
78.6%
3 6
 
21.4%

상세영업상태명
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
영업중
22 
폐업
6 

Length

Max length3
Median length3
Mean length2.7857143
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업중 22
78.6%
폐업 6
 
21.4%

Length

2024-05-10T23:59:31.577037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:32.031662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 22
78.6%
폐업 6
 
21.4%

폐업일자
Categorical

IMBALANCE 

Distinct6
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
23 
20221201
 
1
20130226
 
1
20220524
 
1
20101125
 
1

Length

Max length8
Median length4
Mean length4.7142857
Min length4

Unique

Unique5 ?
Unique (%)17.9%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 23
82.1%
20221201 1
 
3.6%
20130226 1
 
3.6%
20220524 1
 
3.6%
20101125 1
 
3.6%
20110328 1
 
3.6%

Length

2024-05-10T23:59:32.640802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:33.185894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 23
82.1%
20221201 1
 
3.6%
20130226 1
 
3.6%
20220524 1
 
3.6%
20101125 1
 
3.6%
20110328 1
 
3.6%

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

재개업일자
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
27 
20110929
 
1

Length

Max length8
Median length4
Mean length4.1428571
Min length4

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 27
96.4%
20110929 1
 
3.6%

Length

2024-05-10T23:59:33.967414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:34.317525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 27
96.4%
20110929 1
 
3.6%

전화번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing28
Missing (%)100.0%
Memory size384.0 B

지번주소
Text

MISSING 

Distinct24
Distinct (%)88.9%
Missing1
Missing (%)3.6%
Memory size356.0 B
2024-05-10T23:59:34.768255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length27
Mean length22.074074
Min length16

Characters and Unicode

Total characters596
Distinct characters62
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

Unique21 ?
Unique (%)77.8%

Sample

1st row서울특별시 강북구 수유동 45-5
2nd row서울특별시 강북구 미아동 35-4
3rd row서울특별시 강북구 수유동 산 76 아카데미하우스
4th row서울특별시 강북구 수유동 229-11
5th row서울특별시 강북구 미아동 670-28
ValueCountFrequency (%)
서울특별시 27
21.6%
강북구 27
21.6%
미아동 15
12.0%
수유동 6
 
4.8%
번동 5
 
4.0%
70-6 3
 
2.4%
산 3
 
2.4%
194-1 2
 
1.6%
미아역 2
 
1.6%
28-6 2
 
1.6%
Other values (31) 33
26.4%
2024-05-10T23:59:35.761524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
113
19.0%
동 29
 
4.9%
서 28
 
4.7%
강 28
 
4.7%
북 28
 
4.7%
울 27
 
4.5%
특 27
 
4.5%
별 27
 
4.5%
시 27
 
4.5%
구 27
 
4.5%
Other values (52) 235
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 354
59.4%
Space Separator 113
 
19.0%
Decimal Number 106
 
17.8%
Dash Punctuation 21
 
3.5%
Uppercase Letter 1
 
0.2%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 29
 
8.2%
서 28
 
7.9%
강 28
 
7.9%
북 28
 
7.9%
울 27
 
7.6%
특 27
 
7.6%
별 27
 
7.6%
시 27
 
7.6%
구 27
 
7.6%
아 19
 
5.4%
Other values (38) 87
24.6%
Decimal Number
ValueCountFrequency (%)
1 21
19.8%
5 15
14.2%
6 14
13.2%
3 13
12.3%
7 9
8.5%
2 9
8.5%
9 9
8.5%
4 7
 
6.6%
0 5
 
4.7%
8 4
 
3.8%
Space Separator
ValueCountFrequency (%)
113
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 354
59.4%
Common 241
40.4%
Latin 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 29
 
8.2%
서 28
 
7.9%
강 28
 
7.9%
북 28
 
7.9%
울 27
 
7.6%
특 27
 
7.6%
별 27
 
7.6%
시 27
 
7.6%
구 27
 
7.6%
아 19
 
5.4%
Other values (38) 87
24.6%
Common
ValueCountFrequency (%)
113
46.9%
1 21
 
8.7%
- 21
 
8.7%
5 15
 
6.2%
6 14
 
5.8%
3 13
 
5.4%
7 9
 
3.7%
2 9
 
3.7%
9 9
 
3.7%
4 7
 
2.9%
Other values (3) 10
 
4.1%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 354
59.4%
ASCII 242
40.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
113
46.7%
1 21
 
8.7%
- 21
 
8.7%
5 15
 
6.2%
6 14
 
5.8%
3 13
 
5.4%
7 9
 
3.7%
2 9
 
3.7%
9 9
 
3.7%
4 7
 
2.9%
Other values (4) 11
 
4.5%
Hangul
ValueCountFrequency (%)
동 29
 
8.2%
서 28
 
7.9%
강 28
 
7.9%
북 28
 
7.9%
울 27
 
7.6%
특 27
 
7.6%
별 27
 
7.6%
시 27
 
7.6%
구 27
 
7.6%
아 19
 
5.4%
Other values (38) 87
24.6%

도로명주소
Text

MISSING 

Distinct18
Distinct (%)85.7%
Missing7
Missing (%)25.0%
Memory size356.0 B
2024-05-10T23:59:36.329155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length33
Mean length25.428571
Min length22

Characters and Unicode

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

Unique

Unique16 ?
Unique (%)76.2%

Sample

1st row서울특별시 강북구 도봉로 261 (수유동)
2nd row서울특별시 강북구 도봉로 214 (미아동)
3rd row서울특별시 강북구 덕릉로 114-1 (미아동)
4th row서울특별시 강북구 삼양로 648 (우이동,동아운수 차고지)
5th row서울특별시 강북구 덕릉로40다길 13 (번동)
ValueCountFrequency (%)
서울특별시 21
19.1%
강북구 21
19.1%
미아동 11
 
10.0%
도봉로 8
 
7.3%
번동 5
 
4.5%
62 3
 
2.7%
도봉로76가길 2
 
1.8%
삼양로 2
 
1.8%
수유동 2
 
1.8%
55 2
 
1.8%
Other values (30) 33
30.0%
2024-05-10T23:59:37.571554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
93
 
17.4%
서 22
 
4.1%
강 22
 
4.1%
북 22
 
4.1%
동 22
 
4.1%
특 21
 
3.9%
별 21
 
3.9%
시 21
 
3.9%
구 21
 
3.9%
울 21
 
3.9%
Other values (60) 248
46.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 325
60.9%
Space Separator 93
 
17.4%
Decimal Number 67
 
12.5%
Close Punctuation 21
 
3.9%
Open Punctuation 21
 
3.9%
Other Punctuation 6
 
1.1%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 22
 
6.8%
강 22
 
6.8%
북 22
 
6.8%
동 22
 
6.8%
특 21
 
6.5%
별 21
 
6.5%
시 21
 
6.5%
구 21
 
6.5%
울 21
 
6.5%
로 21
 
6.5%
Other values (44) 111
34.2%
Decimal Number
ValueCountFrequency (%)
1 14
20.9%
2 11
16.4%
4 8
11.9%
6 7
10.4%
3 6
9.0%
9 5
 
7.5%
5 5
 
7.5%
7 5
 
7.5%
8 4
 
6.0%
0 2
 
3.0%
Other Punctuation
ValueCountFrequency (%)
, 5
83.3%
. 1
 
16.7%
Space Separator
ValueCountFrequency (%)
93
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 325
60.9%
Common 209
39.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 22
 
6.8%
강 22
 
6.8%
북 22
 
6.8%
동 22
 
6.8%
특 21
 
6.5%
별 21
 
6.5%
시 21
 
6.5%
구 21
 
6.5%
울 21
 
6.5%
로 21
 
6.5%
Other values (44) 111
34.2%
Common
ValueCountFrequency (%)
93
44.5%
) 21
 
10.0%
( 21
 
10.0%
1 14
 
6.7%
2 11
 
5.3%
4 8
 
3.8%
6 7
 
3.3%
3 6
 
2.9%
9 5
 
2.4%
5 5
 
2.4%
Other values (6) 18
 
8.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 325
60.9%
ASCII 209
39.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
93
44.5%
) 21
 
10.0%
( 21
 
10.0%
1 14
 
6.7%
2 11
 
5.3%
4 8
 
3.8%
6 7
 
3.3%
3 6
 
2.9%
9 5
 
2.4%
5 5
 
2.4%
Other values (6) 18
 
8.6%
Hangul
ValueCountFrequency (%)
서 22
 
6.8%
강 22
 
6.8%
북 22
 
6.8%
동 22
 
6.8%
특 21
 
6.5%
별 21
 
6.5%
시 21
 
6.5%
구 21
 
6.5%
울 21
 
6.5%
로 21
 
6.5%
Other values (44) 111
34.2%

도로명우편번호
Categorical

IMBALANCE 

Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
25 
1137
 
1
1193
 
1
1133
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique3 ?
Unique (%)10.7%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 25
89.3%
1137 1
 
3.6%
1193 1
 
3.6%
1133 1
 
3.6%

Length

2024-05-10T23:59:38.321349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:38.617477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 25
89.3%
1137 1
 
3.6%
1193 1
 
3.6%
1133 1
 
3.6%

사업장명
Text

Distinct24
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-05-10T23:59:39.279952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length8.7857143
Min length4

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)75.0%

Sample

1st row대한병원
2nd row대지극장
3rd row재)기장아카데미하우스
4th row동오빌딩
5th row행전빌딩
ValueCountFrequency (%)
롯데쇼핑(주 4
 
9.1%
미아점 3
 
6.8%
서울교통공사 2
 
4.5%
북서울 2
 
4.5%
꿈의 2
 
4.5%
숲 2
 
4.5%
스케이트장 2
 
4.5%
성신여자대학교 2
 
4.5%
운정캠퍼스 2
 
4.5%
강북지사 1
 
2.3%
Other values (22) 22
50.0%
2024-05-10T23:59:40.686680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
16
 
6.5%
교 8
 
3.3%
주 7
 
2.8%
) 7
 
2.8%
스 7
 
2.8%
사 7
 
2.8%
데 6
 
2.4%
( 6
 
2.4%
롯 5
 
2.0%
서 5
 
2.0%
Other values (85) 172
69.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 212
86.2%
Space Separator 16
 
6.5%
Close Punctuation 7
 
2.8%
Open Punctuation 6
 
2.4%
Decimal Number 3
 
1.2%
Dash Punctuation 1
 
0.4%
Uppercase Letter 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 8
 
3.8%
주 7
 
3.3%
스 7
 
3.3%
사 7
 
3.3%
데 6
 
2.8%
롯 5
 
2.4%
서 5
 
2.4%
회 5
 
2.4%
대 5
 
2.4%
아 5
 
2.4%
Other values (78) 152
71.7%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
9 1
33.3%
Space Separator
ValueCountFrequency (%)
16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 212
86.2%
Common 33
 
13.4%
Latin 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 8
 
3.8%
주 7
 
3.3%
스 7
 
3.3%
사 7
 
3.3%
데 6
 
2.8%
롯 5
 
2.4%
서 5
 
2.4%
회 5
 
2.4%
대 5
 
2.4%
아 5
 
2.4%
Other values (78) 152
71.7%
Common
ValueCountFrequency (%)
16
48.5%
) 7
21.2%
( 6
 
18.2%
1 2
 
6.1%
- 1
 
3.0%
9 1
 
3.0%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 212
86.2%
ASCII 34
 
13.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
16
47.1%
) 7
20.6%
( 6
 
17.6%
1 2
 
5.9%
- 1
 
2.9%
9 1
 
2.9%
A 1
 
2.9%
Hangul
ValueCountFrequency (%)
교 8
 
3.8%
주 7
 
3.3%
스 7
 
3.3%
사 7
 
3.3%
데 6
 
2.8%
롯 5
 
2.4%
서 5
 
2.4%
회 5
 
2.4%
대 5
 
2.4%
아 5
 
2.4%
Other values (78) 152
71.7%

최종수정일자
Date

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
Minimum2001-09-21 00:00:00
Maximum2024-03-05 13:57:11
2024-05-10T23:59:41.208761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T23:59:41.931862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)

데이터갱신구분
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
U
17 
I
11 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
U 17
60.7%
I 11
39.3%

Length

2024-05-10T23:59:42.587301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:43.007689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
u 17
60.7%
i 11
39.3%

데이터갱신일자
Date

Distinct14
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-03 00:07:00
2024-05-10T23:59:43.713276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-10T23:59:44.157476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

업태구분명
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
제조
27 
저장소
 
1

Length

Max length3
Median length2
Mean length2.0357143
Min length2

Unique

Unique1 ?
Unique (%)3.6%

Sample

1st row제조
2nd row제조
3rd row제조
4th row제조
5th row제조

Common Values

ValueCountFrequency (%)
제조 27
96.4%
저장소 1
 
3.6%

Length

2024-05-10T23:59:44.751636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:45.079248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제조 27
96.4%
저장소 1
 
3.6%

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

MISSING 

Distinct19
Distinct (%)79.2%
Missing4
Missing (%)14.3%
Infinite0
Infinite (%)0.0%
Mean202117.35
Minimum200020.57
Maximum203540.98
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-05-10T23:59:45.487948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum200020.57
5-th percentile200360.66
Q1201874.04
median202187.91
Q3202625.65
95-th percentile203496.17
Maximum203540.98
Range3520.4126
Interquartile range (IQR)751.6042

Descriptive statistics

Standard deviation891.92879
Coefficient of variation (CV)0.0044129255
Kurtosis0.60805488
Mean202117.35
Median Absolute Deviation (MAD)437.73797
Skewness-0.67670769
Sum4850816.3
Variance795536.97
MonotonicityNot monotonic
2024-05-10T23:59:45.994981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
202625.646264572 3
 
10.7%
202114.967936971 2
 
7.1%
202337.451900796 2
 
7.1%
203540.984593238 2
 
7.1%
201169.158224441 1
 
3.6%
202552.220327881 1
 
3.6%
203059.299033187 1
 
3.6%
202265.854898078 1
 
3.6%
201077.651526613 1
 
3.6%
202000.513660624 1
 
3.6%
Other values (9) 9
32.1%
(Missing) 4
14.3%
ValueCountFrequency (%)
200020.571943402 1
3.6%
200234.13213979 1
3.6%
201077.651526613 1
3.6%
201169.158224441 1
3.6%
201304.023856617 1
3.6%
201494.627293774 1
3.6%
202000.513660624 1
3.6%
202024.099349951 1
3.6%
202114.967936971 2
7.1%
202132.411670676 1
3.6%
ValueCountFrequency (%)
203540.984593238 2
7.1%
203242.188048418 1
 
3.6%
203059.299033187 1
 
3.6%
202625.646264572 3
10.7%
202552.220327881 1
 
3.6%
202337.451900796 2
7.1%
202265.854898078 1
 
3.6%
202228.816586301 1
 
3.6%
202147.0 1
 
3.6%
202132.411670676 1
 
3.6%

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

MISSING 

Distinct19
Distinct (%)79.2%
Missing4
Missing (%)14.3%
Infinite0
Infinite (%)0.0%
Mean458555.58
Minimum456875.97
Maximum462056.9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-05-10T23:59:46.524491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum456875.97
5-th percentile456875.97
Q1457626.76
median458653.9
Q3459015.2
95-th percentile459903.94
Maximum462056.9
Range5180.931
Interquartile range (IQR)1388.4446

Descriptive statistics

Standard deviation1138.1926
Coefficient of variation (CV)0.0024821258
Kurtosis2.7696451
Mean458555.58
Median Absolute Deviation (MAD)483.32413
Skewness0.95824405
Sum11005334
Variance1295482.5
MonotonicityNot monotonic
2024-05-10T23:59:47.034674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
456875.973976242 3
 
10.7%
458567.140451394 2
 
7.1%
458844.213642725 2
 
7.1%
457626.759229664 2
 
7.1%
462056.904998381 1
 
3.6%
459039.560873685 1
 
3.6%
459123.878547491 1
 
3.6%
459150.572305245 1
 
3.6%
458903.026604152 1
 
3.6%
458815.97773382 1
 
3.6%
Other values (9) 9
32.1%
(Missing) 4
14.3%
ValueCountFrequency (%)
456875.973976242 3
10.7%
457480.042762118 1
 
3.6%
457508.15105304 1
 
3.6%
457626.759229664 2
7.1%
458136.342274236 1
 
3.6%
458386.056603155 1
 
3.6%
458567.140451394 2
7.1%
458617.0 1
 
3.6%
458690.802597361 1
 
3.6%
458815.97773382 1
 
3.6%
ValueCountFrequency (%)
462056.904998381 1
3.6%
459923.973286241 1
3.6%
459790.386206253 1
3.6%
459150.572305245 1
3.6%
459123.878547491 1
3.6%
459039.560873685 1
3.6%
459007.084804395 1
3.6%
458903.026604152 1
3.6%
458844.213642725 2
7.1%
458815.97773382 1
3.6%

제조구분명
Categorical

Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
12 
냉동
10 
충전
5 
일반
 
1

Length

Max length4
Median length2
Mean length2.8571429
Min length2

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 12
42.9%
냉동 10
35.7%
충전 5
17.9%
일반 1
 
3.6%

Length

2024-05-10T23:59:47.578391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-10T23:59:48.035595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 12
42.9%
냉동 10
35.7%
충전 5
17.9%
일반 1
 
3.6%

사업장부지용도구분명
Text

MISSING 

Distinct7
Distinct (%)70.0%
Missing18
Missing (%)64.3%
Memory size356.0 B
2024-05-10T23:59:48.506974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length3.6
Min length2

Characters and Unicode

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

Unique

Unique5 ?
Unique (%)50.0%

Sample

1st row상업용
2nd row상업기타
3rd row상업용
4th row주거기타
5th row주거용
ValueCountFrequency (%)
주거기타 3
30.0%
상업용 2
20.0%
상업기타 1
 
10.0%
주거용 1
 
10.0%
기타 1
 
10.0%
상업.업무용 1
 
10.0%
공원등 1
 
10.0%
2024-05-10T23:59:49.406941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 5
13.9%
타 5
13.9%
업 5
13.9%
주 4
11.1%
거 4
11.1%
상 4
11.1%
용 4
11.1%
. 1
 
2.8%
무 1
 
2.8%
공 1
 
2.8%
Other values (2) 2
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 35
97.2%
Other Punctuation 1
 
2.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 5
14.3%
타 5
14.3%
업 5
14.3%
주 4
11.4%
거 4
11.4%
상 4
11.4%
용 4
11.4%
무 1
 
2.9%
공 1
 
2.9%
원 1
 
2.9%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 35
97.2%
Common 1
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 5
14.3%
타 5
14.3%
업 5
14.3%
주 4
11.4%
거 4
11.4%
상 4
11.4%
용 4
11.4%
무 1
 
2.9%
공 1
 
2.9%
원 1
 
2.9%
Common
ValueCountFrequency (%)
. 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 35
97.2%
ASCII 1
 
2.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 5
14.3%
타 5
14.3%
업 5
14.3%
주 4
11.4%
거 4
11.4%
상 4
11.4%
용 4
11.4%
무 1
 
2.9%
공 1
 
2.9%
원 1
 
2.9%
ASCII
ValueCountFrequency (%)
. 1
100.0%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)제조구분명사업장부지용도구분명
03080000198230800750220000119820817<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 수유동 45-5<NA><NA>대한병원2017-09-16 08:36:43I2018-08-31 23:59:59.0제조<NA><NA>냉동상업용
13080000198430800750210000119840723<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 35-4<NA><NA>대지극장2003-11-04 00:00:00I2018-08-31 23:59:59.0제조<NA><NA>냉동상업기타
23080000198730800750210000120090723<NA>3폐업3폐업20221201<NA><NA><NA><NA><NA><NA>서울특별시 강북구 수유동 산 76 아카데미하우스<NA><NA>재)기장아카데미하우스2022-12-30 11:31:00U2022-12-01 00:01:00.0제조200020.571943459790.386206<NA><NA>
33080000198930800750220000119890218<NA>3폐업3폐업20130226<NA><NA><NA><NA><NA><NA>서울특별시 강북구 수유동 229-11<NA><NA>동오빌딩2013-02-26 17:11:26I2018-08-31 23:59:59.0제조<NA><NA>냉동상업용
43080000199130800750220000119910515<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 670-28<NA><NA>행전빌딩2016-11-23 16:00:13I2018-08-31 23:59:59.0제조<NA><NA>냉동주거기타
5308000019973080075021000011997-07-21<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 수유동 63서울특별시 강북구 도봉로 261 (수유동)<NA>덕우수유프라자상가2024-03-05 13:57:11U2023-12-03 00:07:00.0제조202000.513661458815.977734<NA><NA>
63080000199930800750220000120090612<NA>3폐업3폐업20220524<NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 332-2<NA><NA>소망교회2022-05-30 15:05:32U2021-12-06 00:04:00.0제조202024.09935457480.042762<NA><NA>
73080000200030800750220000220001201<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 196서울특별시 강북구 도봉로 214 (미아동)<NA>새은혜교회2022-11-28 17:04:50U2021-10-31 21:00:00.0제조202228.816586458386.056603<NA><NA>
83080000200130800750210000119870127<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 158-1서울특별시 강북구 덕릉로 114-1 (미아동)<NA>대복상회2001-09-21 00:00:00I2018-08-31 23:59:59.0저장소202265.854898459150.572305일반주거용
93080000200230800750210000120021230<NA>3폐업3폐업<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 우이동 6-1 동아운수 차고지서울특별시 강북구 삼양로 648 (우이동,동아운수 차고지)<NA>한국가스공사2006-12-01 00:00:00I2018-08-31 23:59:59.0제조201169.158224462056.904998충전주거기타
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)제조구분명사업장부지용도구분명
183080000201030801390210000120101221<NA>3폐업3폐업20110328<NA><NA><NA><NA><NA><NA>서울특별시 강북구 번동 산 28-6서울특별시 강북구 월계로 173 (번동)<NA>북서울 꿈의 숲 스케이트장2011-03-28 16:47:12I2018-08-31 23:59:59.0제조203540.984593457626.75923냉동<NA>
19308000020113080139021000012011-06-09<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 수유동 535-353 통일교육원서울특별시 강북구 4.19로 123 (수유동,통일교육원)<NA>국립통일교육원2023-07-05 09:24:24U2022-12-07 00:07:00.0제조200234.13214459923.973286<NA><NA>
203080000201130801390220000120110311<NA>1영업/정상1영업중<NA><NA><NA>20110929<NA><NA><NA>서울특별시 강북구 미아동 147 성신여대 운정캠퍼스서울특별시 강북구 도봉로76가길 55 (미아동,성신여대 운정캠퍼스)<NA>성신여자대학교 운정캠퍼스2022-06-13 16:00:26U2021-12-05 23:06:00.0제조202337.451901458844.213643<NA><NA>
213080000201130801390220000220110314<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 147 성신여자대학교 운정캠퍼스 A동서울특별시 강북구 도봉로76가길 55 (미아동)<NA>성신여자대학교 운정캠퍼스 A동2022-06-13 16:00:41U2021-12-05 23:06:00.0제조202337.451901458844.213643<NA><NA>
223080000201130801390220000320110922<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 190-1서울특별시 강북구 도봉로 242 (미아동)<NA>한국전력공사 강북지사2017-01-20 16:35:37I2018-08-31 23:59:59.0제조202132.411671458690.802597냉동<NA>
233080000201730801470210000120170922<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 도봉로 238 (미아동)<NA>에스케이텔레콤(주)-수유사옥2021-11-19 09:01:35U2021-11-21 02:40:00.0제조202147.0458617.0냉동<NA>
243080000201730801470220000120171205<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 번동 365-1 강북소방서서울특별시 강북구 한천로 911, 강북소방서 (번동)1137강북소방서2019-05-14 11:32:54U2019-05-16 02:40:00.0제조203242.188048459007.084804충전<NA>
253080000201730801470220000220171205<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 1353-6 삼각산119안전센터서울특별시 강북구 솔샘로 208 (미아동)1193삼각산119안전센터2019-05-14 11:33:22U2019-05-16 02:40:00.0제조201304.023857457508.151053충전<NA>
26308000020213080147022000012021-09-29<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 194-1 미아역<NA><NA>서울교통공사2023-06-26 11:46:40I2022-12-05 22:08:00.0제조202114.967937458567.140451<NA><NA>
27308000020213080147022000022021-09-29<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 강북구 미아동 194-1 미아역서울특별시 강북구 도봉로 지하 198, 미아역 (미아동)1133서울교통공사2023-06-26 11:46:29U2022-12-05 22:08:00.0제조202114.967937458567.140451<NA><NA>