Overview

Dataset statistics

Number of variables30
Number of observations411
Missing cells6071
Missing cells (%)49.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory104.9 KiB
Average record size in memory261.3 B

Variable types

Categorical8
Numeric4
Unsupported13
Text3
DateTime2

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가일자 has constant value ""Constant
영업상태코드 has constant value ""Constant
영업상태명 has constant value ""Constant
상세영업상태코드 has constant value ""Constant
상세영업상태명 has constant value ""Constant
최종수정일자 has constant value ""Constant
데이터갱신구분 has constant value ""Constant
데이터갱신일자 has constant value ""Constant
항목값1 has constant value ""Constant
인허가취소일자 has 411 (100.0%) missing valuesMissing
폐업일자 has 411 (100.0%) missing valuesMissing
휴업시작일자 has 411 (100.0%) missing valuesMissing
휴업종료일자 has 411 (100.0%) missing valuesMissing
재개업일자 has 411 (100.0%) missing valuesMissing
전화번호 has 24 (5.8%) missing valuesMissing
소재지면적 has 411 (100.0%) missing valuesMissing
소재지우편번호 has 6 (1.5%) missing valuesMissing
도로명주소 has 411 (100.0%) missing valuesMissing
도로명우편번호 has 411 (100.0%) missing valuesMissing
업태구분명 has 411 (100.0%) missing valuesMissing
좌표정보(X) has 349 (84.9%) missing valuesMissing
좌표정보(Y) has 349 (84.9%) missing valuesMissing
업소구분명 has 411 (100.0%) missing valuesMissing
소재지 has 411 (100.0%) missing valuesMissing
지정일자 has 411 (100.0%) missing valuesMissing
신청일자 has 411 (100.0%) missing valuesMissing
관리번호 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
업소구분명 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-04-06 11:55:15.618108
Analysis finished2024-04-06 11:55:16.169407
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
3070000
411 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3070000 411
100.0%

Length

2024-04-06T20:55:16.264155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:16.454787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3070000 411
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct411
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.0700039 × 1017
Minimum3.0700001 × 1017
Maximum3.0701041 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2024-04-06T20:55:16.741592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.0700001 × 1017
5-th percentile3.0700001 × 1017
Q13.0700001 × 1017
median3.0700001 × 1017
Q33.0700001 × 1017
95-th percentile3.0700001 × 1017
Maximum3.0701041 × 1017
Range1.04 × 1013
Interquartile range (IQR)192

Descriptive statistics

Standard deviation1.952602 × 1012
Coefficient of variation (CV)6.3602588 × 10-6
Kurtosis22.727998
Mean3.0700039 × 1017
Median Absolute Deviation (MAD)128
Skewness4.9615947
Sum-2.9500467 × 1018
Variance3.8126544 × 1024
MonotonicityStrictly increasing
2024-04-06T20:55:17.103686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
307000014200000001 1
 
0.2%
307000014200000272 1
 
0.2%
307000014200000282 1
 
0.2%
307000014200000281 1
 
0.2%
307000014200000280 1
 
0.2%
307000014200000279 1
 
0.2%
307000014200000278 1
 
0.2%
307000014200000277 1
 
0.2%
307000014200000276 1
 
0.2%
307000014200000275 1
 
0.2%
Other values (401) 401
97.6%
ValueCountFrequency (%)
307000014200000001 1
0.2%
307000014200000002 1
0.2%
307000014200000003 1
0.2%
307000014200000004 1
0.2%
307000014200000005 1
0.2%
307000014200000006 1
0.2%
307000014200000007 1
0.2%
307000014200000008 1
0.2%
307000014200000009 1
0.2%
307000014200000010 1
0.2%
ValueCountFrequency (%)
307010414200000118 1
0.2%
307010414200000117 1
0.2%
307010414200000116 1
0.2%
307010414200000115 1
0.2%
307010414200000114 1
0.2%
307010414200000113 1
0.2%
307010414200000112 1
0.2%
307010414200000111 1
0.2%
307010414200000110 1
0.2%
307010414200000109 1
0.2%

인허가일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
20000101
411 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20000101 411
100.0%

Length

2024-04-06T20:55:17.390764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:17.562088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20000101 411
100.0%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

영업상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
1
411 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 411
100.0%

Length

2024-04-06T20:55:17.755030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:17.916709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 411
100.0%

영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
영업/정상
411 

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 (%)
영업/정상 411
100.0%

Length

2024-04-06T20:55:18.067082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:18.221161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 411
100.0%

상세영업상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
11
411 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
11 411
100.0%

Length

2024-04-06T20:55:18.390647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:18.535154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11 411
100.0%

상세영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
영업
411 

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 (%)
영업 411
100.0%

Length

2024-04-06T20:55:18.697612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:18.850212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 411
100.0%

폐업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

전화번호
Text

MISSING 

Distinct370
Distinct (%)95.6%
Missing24
Missing (%)5.8%
Memory size3.3 KiB
2024-04-06T20:55:19.346944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.780362
Min length2

Characters and Unicode

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

Unique353 ?
Unique (%)91.2%

Sample

1st row02 762 9888
2nd row02 763 9721
3rd row02 36735754
4th row02764 0619
5th row02924 1135
ValueCountFrequency (%)
02 384
33.5%
912 38
 
3.3%
914 32
 
2.8%
915 28
 
2.4%
917 22
 
1.9%
918 21
 
1.8%
913 19
 
1.7%
916 15
 
1.3%
919 14
 
1.2%
941 11
 
1.0%
Other values (404) 561
49.0%
2024-04-06T20:55:20.196168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1090
23.9%
2 658
14.4%
0 550
12.1%
9 541
11.9%
1 391
 
8.6%
4 269
 
5.9%
7 228
 
5.0%
8 222
 
4.9%
6 214
 
4.7%
3 201
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3469
76.1%
Space Separator 1090
 
23.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 658
19.0%
0 550
15.9%
9 541
15.6%
1 391
11.3%
4 269
7.8%
7 228
 
6.6%
8 222
 
6.4%
6 214
 
6.2%
3 201
 
5.8%
5 195
 
5.6%
Space Separator
ValueCountFrequency (%)
1090
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4559
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1090
23.9%
2 658
14.4%
0 550
12.1%
9 541
11.9%
1 391
 
8.6%
4 269
 
5.9%
7 228
 
5.0%
8 222
 
4.9%
6 214
 
4.7%
3 201
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4559
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1090
23.9%
2 658
14.4%
0 550
12.1%
9 541
11.9%
1 391
 
8.6%
4 269
 
5.9%
7 228
 
5.0%
8 222
 
4.9%
6 214
 
4.7%
3 201
 
4.4%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

소재지우편번호
Real number (ℝ)

MISSING 

Distinct34
Distinct (%)8.4%
Missing6
Missing (%)1.5%
Infinite0
Infinite (%)0.0%
Mean136106.61
Minimum136021
Maximum136152
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2024-04-06T20:55:20.557492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum136021
5-th percentile136031
Q1136102
median136113
Q3136142
95-th percentile136151
Maximum136152
Range131
Interquartile range (IQR)40

Descriptive statistics

Standard deviation41.224269
Coefficient of variation (CV)0.00030288219
Kurtosis-0.66879132
Mean136106.61
Median Absolute Deviation (MAD)28
Skewness-0.82727105
Sum55123179
Variance1699.4404
MonotonicityNot monotonic
2024-04-06T20:55:20.799122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
136102 33
 
8.0%
136141 32
 
7.8%
136151 31
 
7.5%
136143 28
 
6.8%
136142 26
 
6.3%
136113 21
 
5.1%
136131 21
 
5.1%
136103 20
 
4.9%
136112 19
 
4.6%
136152 17
 
4.1%
Other values (24) 157
38.2%
ValueCountFrequency (%)
136021 11
2.7%
136022 9
2.2%
136031 4
 
1.0%
136032 4
 
1.0%
136033 2
 
0.5%
136034 8
1.9%
136035 1
 
0.2%
136041 11
2.7%
136042 10
2.4%
136043 2
 
0.5%
ValueCountFrequency (%)
136152 17
4.1%
136151 31
7.5%
136143 28
6.8%
136142 26
6.3%
136141 32
7.8%
136134 6
 
1.5%
136133 7
 
1.7%
136132 11
 
2.7%
136131 21
5.1%
136120 9
 
2.2%

지번주소
Text

Distinct383
Distinct (%)93.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-04-06T20:55:21.287526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length22.844282
Min length18

Characters and Unicode

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

Unique

Unique356 ?
Unique (%)86.6%

Sample

1st row서울특별시 성북구 성북동 184-48번지
2nd row서울특별시 성북구 길음동 133-1 번지
3rd row서울특별시 성북구 성북동 175-3 번지
4th row서울특별시 성북구 성북동 173-45 번지
5th row서울특별시 성북구 성북동 184-5 번지
ValueCountFrequency (%)
서울특별시 411
24.7%
성북구 411
24.7%
장위동 86
 
5.2%
정릉동 69
 
4.1%
길음동 53
 
3.2%
석관동 49
 
2.9%
하월곡동 47
 
2.8%
성북동 19
 
1.1%
번지 18
 
1.1%
삼선동1가 11
 
0.7%
Other values (398) 492
29.5%
2024-04-06T20:55:22.060235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1691
18.0%
동 444
 
4.7%
성 430
 
4.6%
북 430
 
4.6%
서 411
 
4.4%
특 411
 
4.4%
별 411
 
4.4%
시 411
 
4.4%
구 411
 
4.4%
울 411
 
4.4%
Other values (36) 3928
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5497
58.5%
Decimal Number 1856
 
19.8%
Space Separator 1691
 
18.0%
Dash Punctuation 345
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 444
 
8.1%
성 430
 
7.8%
북 430
 
7.8%
서 411
 
7.5%
특 411
 
7.5%
별 411
 
7.5%
시 411
 
7.5%
구 411
 
7.5%
울 411
 
7.5%
지 411
 
7.5%
Other values (24) 1316
23.9%
Decimal Number
ValueCountFrequency (%)
1 328
17.7%
2 284
15.3%
3 224
12.1%
5 174
9.4%
4 171
9.2%
6 151
8.1%
7 146
7.9%
8 144
7.8%
0 123
 
6.6%
9 111
 
6.0%
Space Separator
ValueCountFrequency (%)
1691
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 345
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5497
58.5%
Common 3892
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 444
 
8.1%
성 430
 
7.8%
북 430
 
7.8%
서 411
 
7.5%
특 411
 
7.5%
별 411
 
7.5%
시 411
 
7.5%
구 411
 
7.5%
울 411
 
7.5%
지 411
 
7.5%
Other values (24) 1316
23.9%
Common
ValueCountFrequency (%)
1691
43.4%
- 345
 
8.9%
1 328
 
8.4%
2 284
 
7.3%
3 224
 
5.8%
5 174
 
4.5%
4 171
 
4.4%
6 151
 
3.9%
7 146
 
3.8%
8 144
 
3.7%
Other values (2) 234
 
6.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5497
58.5%
ASCII 3892
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1691
43.4%
- 345
 
8.9%
1 328
 
8.4%
2 284
 
7.3%
3 224
 
5.8%
5 174
 
4.5%
4 171
 
4.4%
6 151
 
3.9%
7 146
 
3.8%
8 144
 
3.7%
Other values (2) 234
 
6.0%
Hangul
ValueCountFrequency (%)
동 444
 
8.1%
성 430
 
7.8%
북 430
 
7.8%
서 411
 
7.5%
특 411
 
7.5%
별 411
 
7.5%
시 411
 
7.5%
구 411
 
7.5%
울 411
 
7.5%
지 411
 
7.5%
Other values (24) 1316
23.9%

도로명주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

사업장명
Text

Distinct338
Distinct (%)82.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2024-04-06T20:55:22.643934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length4
Mean length4.3309002
Min length2

Characters and Unicode

Total characters1780
Distinct characters247
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

Unique282 ?
Unique (%)68.6%

Sample

1st row유성슈퍼
2nd row신성슈퍼
3rd row일광슈퍼
4th row당진슈퍼
5th row하이퍼
ValueCountFrequency (%)
충남상회 6
 
1.5%
현대슈퍼 5
 
1.2%
태양슈퍼 4
 
1.0%
대성상회 3
 
0.7%
화신슈퍼 3
 
0.7%
경기상회 3
 
0.7%
알뜰슈퍼 3
 
0.7%
럭키슈퍼 3
 
0.7%
제일슈퍼 3
 
0.7%
바이더웨이 3
 
0.7%
Other values (328) 376
91.3%
2024-04-06T20:55:23.684086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
퍼 235
 
13.2%
슈 227
 
12.8%
상 55
 
3.1%
회 54
 
3.0%
마 42
 
2.4%
트 36
 
2.0%
성 34
 
1.9%
대 29
 
1.6%
일 28
 
1.6%
식 25
 
1.4%
Other values (237) 1015
57.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1756
98.7%
Decimal Number 11
 
0.6%
Uppercase Letter 6
 
0.3%
Close Punctuation 3
 
0.2%
Open Punctuation 3
 
0.2%
Space Separator 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
퍼 235
 
13.4%
슈 227
 
12.9%
상 55
 
3.1%
회 54
 
3.1%
마 42
 
2.4%
트 36
 
2.1%
성 34
 
1.9%
대 29
 
1.7%
일 28
 
1.6%
식 25
 
1.4%
Other values (224) 991
56.4%
Decimal Number
ValueCountFrequency (%)
2 5
45.5%
8 2
 
18.2%
1 2
 
18.2%
7 1
 
9.1%
5 1
 
9.1%
Uppercase Letter
ValueCountFrequency (%)
M 2
33.3%
L 1
16.7%
G 1
16.7%
P 1
16.7%
A 1
16.7%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1756
98.7%
Common 18
 
1.0%
Latin 6
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
퍼 235
 
13.4%
슈 227
 
12.9%
상 55
 
3.1%
회 54
 
3.1%
마 42
 
2.4%
트 36
 
2.1%
성 34
 
1.9%
대 29
 
1.7%
일 28
 
1.6%
식 25
 
1.4%
Other values (224) 991
56.4%
Common
ValueCountFrequency (%)
2 5
27.8%
) 3
16.7%
( 3
16.7%
8 2
 
11.1%
1 2
 
11.1%
1
 
5.6%
7 1
 
5.6%
5 1
 
5.6%
Latin
ValueCountFrequency (%)
M 2
33.3%
L 1
16.7%
G 1
16.7%
P 1
16.7%
A 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1756
98.7%
ASCII 24
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
퍼 235
 
13.4%
슈 227
 
12.9%
상 55
 
3.1%
회 54
 
3.1%
마 42
 
2.4%
트 36
 
2.1%
성 34
 
1.9%
대 29
 
1.7%
일 28
 
1.6%
식 25
 
1.4%
Other values (224) 991
56.4%
ASCII
ValueCountFrequency (%)
2 5
20.8%
) 3
12.5%
( 3
12.5%
M 2
 
8.3%
8 2
 
8.3%
1 2
 
8.3%
1
 
4.2%
7 1
 
4.2%
5 1
 
4.2%
L 1
 
4.2%
Other values (3) 3
12.5%

최종수정일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2007-07-07 10:53:03
Maximum2007-07-07 10:53:03
2024-04-06T20:55:23.949965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:55:24.172715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

데이터갱신구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
I
411 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 411
100.0%

Length

2024-04-06T20:55:24.385368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:24.549082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 411
100.0%

데이터갱신일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2018-08-31 23:59:59
Maximum2018-08-31 23:59:59
2024-04-06T20:55:24.711852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:55:24.872651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

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

MISSING 

Distinct54
Distinct (%)87.1%
Missing349
Missing (%)84.9%
Infinite0
Infinite (%)0.0%
Mean201152.81
Minimum199586.32
Maximum203816.44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2024-04-06T20:55:25.121382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum199586.32
5-th percentile200319.11
Q1200693.93
median200950.31
Q3201703.52
95-th percentile202174.4
Maximum203816.44
Range4230.1197
Interquartile range (IQR)1009.5899

Descriptive statistics

Standard deviation728.14748
Coefficient of variation (CV)0.0036198723
Kurtosis1.8269754
Mean201152.81
Median Absolute Deviation (MAD)389.0373
Skewness0.86092756
Sum12471474
Variance530198.75
MonotonicityNot monotonic
2024-04-06T20:55:25.429348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
200816.344238319 2
 
0.5%
200903.886917978 2
 
0.5%
200411.312306379 2
 
0.5%
200581.409413913 2
 
0.5%
200958.125106784 2
 
0.5%
200561.518557513 2
 
0.5%
200741.963977497 2
 
0.5%
201067.523284949 2
 
0.5%
201501.307649613 1
 
0.2%
199837.11157416 1
 
0.2%
Other values (44) 44
 
10.7%
(Missing) 349
84.9%
ValueCountFrequency (%)
199586.316865115 1
0.2%
199837.11157416 1
0.2%
200024.336811609 1
0.2%
200314.25744795 1
0.2%
200411.312306379 2
0.5%
200413.110715796 1
0.2%
200522.415695433 1
0.2%
200532.780077511 1
0.2%
200561.023055864 1
0.2%
200561.518557513 2
0.5%
ValueCountFrequency (%)
203816.436582932 1
0.2%
202708.637121517 1
0.2%
202337.55683043 1
0.2%
202174.745737989 1
0.2%
202167.843649001 1
0.2%
202091.806121325 1
0.2%
202082.466938048 1
0.2%
202014.415969113 1
0.2%
201943.271198685 1
0.2%
201926.747831961 1
0.2%

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

MISSING 

Distinct54
Distinct (%)87.1%
Missing349
Missing (%)84.9%
Infinite0
Infinite (%)0.0%
Mean454618.93
Minimum453343.13
Maximum456587.14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2024-04-06T20:55:25.692576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum453343.13
5-th percentile453774.32
Q1454035.41
median454278.37
Q3454804.18
95-th percentile456292.83
Maximum456587.14
Range3244.0152
Interquartile range (IQR)768.76222

Descriptive statistics

Standard deviation882.37852
Coefficient of variation (CV)0.001940919
Kurtosis-0.40875079
Mean454618.93
Median Absolute Deviation (MAD)285.91184
Skewness1.0012478
Sum28186373
Variance778591.86
MonotonicityNot monotonic
2024-04-06T20:55:25.964068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
454107.061436595 2
 
0.5%
454319.272828482 2
 
0.5%
454124.448282521 2
 
0.5%
454035.41298412 2
 
0.5%
454427.048875529 2
 
0.5%
453992.603099186 2
 
0.5%
454203.998751061 2
 
0.5%
454414.94348423 2
 
0.5%
454326.472833263 1
 
0.2%
455999.120922495 1
 
0.2%
Other values (44) 44
 
10.7%
(Missing) 349
84.9%
ValueCountFrequency (%)
453343.12522896 1
0.2%
453465.464747132 1
0.2%
453645.974523798 1
0.2%
453772.600740674 1
0.2%
453806.971027431 1
0.2%
453812.512175364 1
0.2%
453852.612596623 1
0.2%
453916.592150753 1
0.2%
453916.670772169 1
0.2%
453935.41755901 1
0.2%
ValueCountFrequency (%)
456587.140422813 1
0.2%
456364.927504671 1
0.2%
456313.303151189 1
0.2%
456294.650901009 1
0.2%
456258.324520165 1
0.2%
456237.009614023 1
0.2%
456139.771981689 1
0.2%
456083.520399909 1
0.2%
456081.632470872 1
0.2%
455999.120922495 1
0.2%

업소구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

소재지
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

지정일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

신청일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing411
Missing (%)100.0%
Memory size3.7 KiB

항목값1
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
관급봉투
411 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row관급봉투
2nd row관급봉투
3rd row관급봉투
4th row관급봉투
5th row관급봉투

Common Values

ValueCountFrequency (%)
관급봉투 411
100.0%

Length

2024-04-06T20:55:26.230940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:55:26.385153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관급봉투 411
100.0%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
0307000030700001420000000120000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 762 9888<NA>136021서울특별시 성북구 성북동 184-48번지<NA><NA>유성슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA>200314.257448454263.650763<NA><NA><NA><NA>관급봉투
1307000030700001420000000220000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 763 9721<NA>136021서울특별시 성북구 길음동 133-1 번지<NA><NA>신성슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
2307000030700001420000000320000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 175-3 번지<NA><NA>일광슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
3307000030700001420000000420000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 173-45 번지<NA><NA>당진슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
4307000030700001420000000520000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 184-5 번지<NA><NA>하이퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
5307000030700001420000000620000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 184-88 번지<NA><NA>명백슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
6307000030700001420000000720000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 183-2 번지<NA><NA>곰실슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
7307000030700001420000000820000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 36735754<NA>136021서울특별시 성북구 성북동 2-43번지<NA><NA>정아슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA>200024.336812454830.436614<NA><NA><NA><NA>관급봉투
8307000030700001420000000920000101<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>136021서울특별시 성북구 성북동 170-46 번지<NA><NA>서울슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
9307000030700001420000001020000101<NA>1영업/정상11영업<NA><NA><NA><NA>02764 0619<NA>136021서울특별시 성북구 성북동 104-29 번지<NA><NA>경진상회2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
401307000030701041420000010920000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 916 4020<NA>136102서울특별시 성북구 정릉동 508 번지 로얄2층<NA><NA>스카이하이퍼마켓2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
402307000030701041420000011020000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 912 3631<NA>136102서울특별시 성북구 정릉동 577-12번지<NA><NA>충남상회2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
403307000030701041420000011120000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 914 4956<NA>136102서울특별시 성북구 정릉동 105-2번지<NA><NA>충남상회2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
404307000030701041420000011220000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 914 1799<NA>136102서울특별시 성북구 정릉동 420-17번지<NA><NA>매일식품2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
405307000030701041420000011320000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 917 5125<NA>136102서울특별시 성북구 정릉동 465-4번지<NA><NA>럭키공판장2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
406307000030701041420000011420000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 912 2019<NA>136102서울특별시 성북구 정릉동 227-54번지<NA><NA>화남슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
407307000030701041420000011520000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 942 2477<NA>136102서울특별시 성북구 정릉동 192-271번지<NA><NA>서경할인마트2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
408307000030701041420000011620000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 916 2185<NA>136102서울특별시 성북구 정릉동 559-209번지<NA><NA>원일상회2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
409307000030701041420000011720000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 912 4288<NA>136102서울특별시 성북구 정릉동 559-209번지<NA><NA>숭덕정육점2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
410307000030701041420000011820000101<NA>1영업/정상11영업<NA><NA><NA><NA>02 918 8920<NA>136103서울특별시 성북구 정릉동 760-8번지<NA><NA>정릉슈퍼2007-07-07 10:53:03I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투