Overview

Dataset statistics

Number of variables30
Number of observations69
Missing cells962
Missing cells (%)46.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.6 KiB
Average record size in memory260.9 B

Variable types

Categorical9
Numeric3
Unsupported11
Text5
DateTime2

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),업소구분명,소재지,지정일자,신청일자,항목값1
Author은평구
URLhttps://data.seoul.go.kr/dataList/OA-19463/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
업소구분명 has constant value ""Constant
항목값1 has constant value ""Constant
좌표정보(X) is highly imbalanced (89.1%)Imbalance
좌표정보(Y) is highly imbalanced (89.1%)Imbalance
인허가취소일자 has 69 (100.0%) missing valuesMissing
폐업일자 has 69 (100.0%) missing valuesMissing
휴업시작일자 has 69 (100.0%) missing valuesMissing
휴업종료일자 has 69 (100.0%) missing valuesMissing
재개업일자 has 69 (100.0%) missing valuesMissing
전화번호 has 67 (97.1%) missing valuesMissing
소재지면적 has 69 (100.0%) missing valuesMissing
도로명주소 has 68 (98.6%) missing valuesMissing
도로명우편번호 has 69 (100.0%) missing valuesMissing
업태구분명 has 69 (100.0%) missing valuesMissing
업소구분명 has 68 (98.6%) missing valuesMissing
소재지 has 69 (100.0%) missing valuesMissing
지정일자 has 69 (100.0%) missing valuesMissing
신청일자 has 69 (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

Reproduction

Analysis started2024-04-06 11:44:40.278354
Analysis finished2024-04-06 11:44:40.819579
Duration0.54 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
3110000
69 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3110000 69
100.0%

Length

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

Common Values (Plot)

2024-04-06T20:44:41.135256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3110000 69
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.1100001 × 1017
Minimum3.1100001 × 1017
Maximum3.1100001 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-04-06T20:44:41.314662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.1100001 × 1017
5-th percentile3.1100001 × 1017
Q13.1100001 × 1017
median3.1100001 × 1017
Q33.1100001 × 1017
95-th percentile3.1100001 × 1017
Maximum3.1100001 × 1017
Range212
Interquartile range (IQR)64

Descriptive statistics

Standard deviation56.501952
Coefficient of variation (CV)1.8167829 × 10-16
Kurtosis0.48543908
Mean3.1100001 × 1017
Median Absolute Deviation (MAD)0
Skewness1.7387696
Sum3.0122569 × 1018
Variance3192.4706
MonotonicityStrictly increasing
2024-04-06T20:44:41.573169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
311000014200000001 1
 
1.4%
311000014200000102 1
 
1.4%
311000014200000109 1
 
1.4%
311000014200000108 1
 
1.4%
311000014200000107 1
 
1.4%
311000014200000106 1
 
1.4%
311000014200000104 1
 
1.4%
311000014200000103 1
 
1.4%
311000014200000101 1
 
1.4%
311000014200000151 1
 
1.4%
Other values (59) 59
85.5%
ValueCountFrequency (%)
311000014200000001 1
1.4%
311000014200000058 1
1.4%
311000014200000059 1
1.4%
311000014200000060 1
1.4%
311000014200000061 1
1.4%
311000014200000062 1
1.4%
311000014200000063 1
1.4%
311000014200000064 1
1.4%
311000014200000065 1
1.4%
311000014200000066 1
1.4%
ValueCountFrequency (%)
311000014200000213 1
1.4%
311000014200000212 1
1.4%
311000014200000165 1
1.4%
311000014200000164 1
1.4%
311000014200000163 1
1.4%
311000014200000162 1
1.4%
311000014200000161 1
1.4%
311000014200000160 1
1.4%
311000014200000159 1
1.4%
311000014200000158 1
1.4%

인허가일자
Real number (ℝ)

Distinct33
Distinct (%)47.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19993545
Minimum19980724
Maximum20000731
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-04-06T20:44:41.918141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19980724
5-th percentile19980819
Q119990210
median20000311
Q320000531
95-th percentile20000731
Maximum20000731
Range20007
Interquartile range (IQR)10321

Descriptive statistics

Standard deviation8114.0573
Coefficient of variation (CV)0.00040583385
Kurtosis-1.2859025
Mean19993545
Median Absolute Deviation (MAD)420
Skewness-0.5823955
Sum1.3795546 × 109
Variance65837926
MonotonicityNot monotonic
2024-04-06T20:44:42.225716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
20000731 11
15.9%
20000412 8
 
11.6%
20000531 8
 
11.6%
19980827 4
 
5.8%
20000624 2
 
2.9%
19991020 2
 
2.9%
19990712 2
 
2.9%
19990212 2
 
2.9%
19980922 2
 
2.9%
19980820 2
 
2.9%
Other values (23) 26
37.7%
ValueCountFrequency (%)
19980724 1
 
1.4%
19980814 2
2.9%
19980818 1
 
1.4%
19980820 2
2.9%
19980827 4
5.8%
19980831 1
 
1.4%
19980922 2
2.9%
19981026 1
 
1.4%
19981104 1
 
1.4%
19981207 1
 
1.4%
ValueCountFrequency (%)
20000731 11
15.9%
20000624 2
 
2.9%
20000607 1
 
1.4%
20000531 8
11.6%
20000508 1
 
1.4%
20000421 1
 
1.4%
20000412 8
11.6%
20000404 2
 
2.9%
20000311 1
 
1.4%
20000215 1
 
1.4%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

영업상태코드
Categorical

CONSTANT 

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

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 69
100.0%

Length

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

Common Values (Plot)

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

영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
영업/정상
69 

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

Length

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

Common Values (Plot)

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

상세영업상태코드
Categorical

CONSTANT 

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

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 69
100.0%

Length

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

Common Values (Plot)

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

상세영업상태명
Categorical

CONSTANT 

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

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

Length

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

Common Values (Plot)

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

폐업일자
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

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

전화번호
Text

MISSING 

Distinct2
Distinct (%)100.0%
Missing67
Missing (%)97.1%
Memory size684.0 B
2024-04-06T20:44:43.909309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length11
Min length11

Characters and Unicode

Total characters22
Distinct characters8
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

Unique2 ?
Unique (%)100.0%

Sample

1st row02 373 5101
2nd row02 309 7011
ValueCountFrequency (%)
02 2
33.3%
373 1
16.7%
5101 1
16.7%
309 1
16.7%
7011 1
16.7%
2024-04-06T20:44:44.369524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 5
22.7%
4
18.2%
1 4
18.2%
3 3
13.6%
2 2
 
9.1%
7 2
 
9.1%
5 1
 
4.5%
9 1
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 18
81.8%
Space Separator 4
 
18.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5
27.8%
1 4
22.2%
3 3
16.7%
2 2
 
11.1%
7 2
 
11.1%
5 1
 
5.6%
9 1
 
5.6%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 22
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 5
22.7%
4
18.2%
1 4
18.2%
3 3
13.6%
2 2
 
9.1%
7 2
 
9.1%
5 1
 
4.5%
9 1
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 22
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 5
22.7%
4
18.2%
1 4
18.2%
3 3
13.6%
2 2
 
9.1%
7 2
 
9.1%
5 1
 
4.5%
9 1
 
4.5%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

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

Distinct7
Distinct (%)10.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122068.64
Minimum122014
Maximum122120
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-04-06T20:44:44.621437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum122014
5-th percentile122014
Q1122051
median122082
Q3122100
95-th percentile122100
Maximum122120
Range106
Interquartile range (IQR)49

Descriptive statistics

Standard deviation30.77144
Coefficient of variation (CV)0.00025208309
Kurtosis-0.85662844
Mean122068.64
Median Absolute Deviation (MAD)18
Skewness-0.61907113
Sum8422736
Variance946.8815
MonotonicityNot monotonic
2024-04-06T20:44:44.805137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
122082 20
29.0%
122100 18
26.1%
122051 16
23.2%
122014 10
14.5%
122090 2
 
2.9%
122020 2
 
2.9%
122120 1
 
1.4%
ValueCountFrequency (%)
122014 10
14.5%
122020 2
 
2.9%
122051 16
23.2%
122082 20
29.0%
122090 2
 
2.9%
122100 18
26.1%
122120 1
 
1.4%
ValueCountFrequency (%)
122120 1
 
1.4%
122100 18
26.1%
122090 2
 
2.9%
122082 20
29.0%
122051 16
23.2%
122020 2
 
2.9%
122014 10
14.5%

지번주소
Text

Distinct68
Distinct (%)98.6%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-04-06T20:44:45.266082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length25
Mean length24.768116
Min length20

Characters and Unicode

Total characters1709
Distinct characters36
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

Unique67 ?
Unique (%)97.1%

Sample

1st row서울특별시 은평구 진관동 299-61 번지
2nd row서울특별시 은평구 응암동 254-27 번지
3rd row서울특별시 은평구 응암동 283-29 번지
4th row서울특별시 은평구 응암동 297-82 번지
5th row서울특별시 은평구 응암동 296-46 번지
ValueCountFrequency (%)
서울특별시 69
20.1%
은평구 69
20.1%
번지 68
19.8%
신사동 20
 
5.8%
증산동 18
 
5.2%
갈현동 16
 
4.7%
응암동 10
 
2.9%
210-14 2
 
0.6%
녹번동 2
 
0.6%
수색동 2
 
0.6%
Other values (68) 68
19.8%
2024-04-06T20:44:46.041729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
422
24.7%
번 71
 
4.2%
서 69
 
4.0%
평 69
 
4.0%
울 69
 
4.0%
동 69
 
4.0%
구 69
 
4.0%
지 69
 
4.0%
은 69
 
4.0%
시 69
 
4.0%
Other values (26) 664
38.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 897
52.5%
Space Separator 422
24.7%
Decimal Number 322
 
18.8%
Dash Punctuation 68
 
4.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
번 71
 
7.9%
서 69
 
7.7%
평 69
 
7.7%
울 69
 
7.7%
동 69
 
7.7%
구 69
 
7.7%
지 69
 
7.7%
은 69
 
7.7%
시 69
 
7.7%
별 69
 
7.7%
Other values (14) 205
22.9%
Decimal Number
ValueCountFrequency (%)
1 68
21.1%
2 54
16.8%
3 47
14.6%
4 28
8.7%
0 27
 
8.4%
9 24
 
7.5%
8 22
 
6.8%
6 19
 
5.9%
5 18
 
5.6%
7 15
 
4.7%
Space Separator
ValueCountFrequency (%)
422
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 68
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 897
52.5%
Common 812
47.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
번 71
 
7.9%
서 69
 
7.7%
평 69
 
7.7%
울 69
 
7.7%
동 69
 
7.7%
구 69
 
7.7%
지 69
 
7.7%
은 69
 
7.7%
시 69
 
7.7%
별 69
 
7.7%
Other values (14) 205
22.9%
Common
ValueCountFrequency (%)
422
52.0%
1 68
 
8.4%
- 68
 
8.4%
2 54
 
6.7%
3 47
 
5.8%
4 28
 
3.4%
0 27
 
3.3%
9 24
 
3.0%
8 22
 
2.7%
6 19
 
2.3%
Other values (2) 33
 
4.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 897
52.5%
ASCII 812
47.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
422
52.0%
1 68
 
8.4%
- 68
 
8.4%
2 54
 
6.7%
3 47
 
5.8%
4 28
 
3.4%
0 27
 
3.3%
9 24
 
3.0%
8 22
 
2.7%
6 19
 
2.3%
Other values (2) 33
 
4.1%
Hangul
ValueCountFrequency (%)
번 71
 
7.9%
서 69
 
7.7%
평 69
 
7.7%
울 69
 
7.7%
동 69
 
7.7%
구 69
 
7.7%
지 69
 
7.7%
은 69
 
7.7%
시 69
 
7.7%
별 69
 
7.7%
Other values (14) 205
22.9%

도로명주소
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing68
Missing (%)98.6%
Memory size684.0 B
2024-04-06T20:44:46.304490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length26
Mean length26
Min length26

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row서울특별시 은평구 은평터널로 125 (신사동)
ValueCountFrequency (%)
서울특별시 1
20.0%
은평구 1
20.0%
은평터널로 1
20.0%
125 1
20.0%
신사동 1
20.0%
2024-04-06T20:44:46.809895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5
19.2%
은 2
 
7.7%
평 2
 
7.7%
서 1
 
3.8%
1 1
 
3.8%
동 1
 
3.8%
사 1
 
3.8%
신 1
 
3.8%
( 1
 
3.8%
5 1
 
3.8%
Other values (10) 10
38.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16
61.5%
Space Separator 5
 
19.2%
Decimal Number 3
 
11.5%
Open Punctuation 1
 
3.8%
Close Punctuation 1
 
3.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
은 2
12.5%
평 2
12.5%
서 1
 
6.2%
동 1
 
6.2%
사 1
 
6.2%
신 1
 
6.2%
널 1
 
6.2%
로 1
 
6.2%
울 1
 
6.2%
터 1
 
6.2%
Other values (4) 4
25.0%
Decimal Number
ValueCountFrequency (%)
1 1
33.3%
5 1
33.3%
2 1
33.3%
Space Separator
ValueCountFrequency (%)
5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16
61.5%
Common 10
38.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
은 2
12.5%
평 2
12.5%
서 1
 
6.2%
동 1
 
6.2%
사 1
 
6.2%
신 1
 
6.2%
널 1
 
6.2%
로 1
 
6.2%
울 1
 
6.2%
터 1
 
6.2%
Other values (4) 4
25.0%
Common
ValueCountFrequency (%)
5
50.0%
1 1
 
10.0%
( 1
 
10.0%
5 1
 
10.0%
2 1
 
10.0%
) 1
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16
61.5%
ASCII 10
38.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5
50.0%
1 1
 
10.0%
( 1
 
10.0%
5 1
 
10.0%
2 1
 
10.0%
) 1
 
10.0%
Hangul
ValueCountFrequency (%)
은 2
12.5%
평 2
12.5%
서 1
 
6.2%
동 1
 
6.2%
사 1
 
6.2%
신 1
 
6.2%
널 1
 
6.2%
로 1
 
6.2%
울 1
 
6.2%
터 1
 
6.2%
Other values (4) 4
25.0%

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

사업장명
Text

Distinct67
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-04-06T20:44:47.341586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length4
Mean length4.6086957
Min length3

Characters and Unicode

Total characters318
Distinct characters125
Distinct categories5 ?
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문석상회
2nd row은성슈퍼
3rd row대일슈퍼
4th row연화슈퍼
5th row신흥슈퍼
ValueCountFrequency (%)
은성슈퍼 2
 
2.9%
엄마손마트 2
 
2.9%
한다사유통 1
 
1.4%
대흥상회 1
 
1.4%
대성상회 1
 
1.4%
샛별문방구 1
 
1.4%
현대슈퍼 1
 
1.4%
부자슈퍼 1
 
1.4%
대희슈퍼 1
 
1.4%
윤창슈퍼 1
 
1.4%
Other values (57) 57
82.6%
2024-04-06T20:44:48.479190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
퍼 26
 
8.2%
슈 23
 
7.2%
마 22
 
6.9%
트 18
 
5.7%
상 10
 
3.1%
대 10
 
3.1%
회 10
 
3.1%
구 5
 
1.6%
하 5
 
1.6%
장 5
 
1.6%
Other values (115) 184
57.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 311
97.8%
Uppercase Letter 4
 
1.3%
Close Punctuation 1
 
0.3%
Open Punctuation 1
 
0.3%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
퍼 26
 
8.4%
슈 23
 
7.4%
마 22
 
7.1%
트 18
 
5.8%
상 10
 
3.2%
대 10
 
3.2%
회 10
 
3.2%
구 5
 
1.6%
하 5
 
1.6%
장 5
 
1.6%
Other values (109) 177
56.9%
Uppercase Letter
ValueCountFrequency (%)
M 2
50.0%
P 1
25.0%
A 1
25.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 311
97.8%
Latin 4
 
1.3%
Common 3
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
퍼 26
 
8.4%
슈 23
 
7.4%
마 22
 
7.1%
트 18
 
5.8%
상 10
 
3.2%
대 10
 
3.2%
회 10
 
3.2%
구 5
 
1.6%
하 5
 
1.6%
장 5
 
1.6%
Other values (109) 177
56.9%
Latin
ValueCountFrequency (%)
M 2
50.0%
P 1
25.0%
A 1
25.0%
Common
ValueCountFrequency (%)
) 1
33.3%
( 1
33.3%
. 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 311
97.8%
ASCII 7
 
2.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
퍼 26
 
8.4%
슈 23
 
7.4%
마 22
 
7.1%
트 18
 
5.8%
상 10
 
3.2%
대 10
 
3.2%
회 10
 
3.2%
구 5
 
1.6%
하 5
 
1.6%
장 5
 
1.6%
Other values (109) 177
56.9%
ASCII
ValueCountFrequency (%)
M 2
28.6%
) 1
14.3%
( 1
14.3%
P 1
14.3%
. 1
14.3%
A 1
14.3%

최종수정일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2007-07-14 10:24:07
Maximum2007-07-14 10:24:07
2024-04-06T20:44:48.934876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:44:49.561290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

데이터갱신구분
Categorical

CONSTANT 

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

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 69
100.0%

Length

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

Common Values (Plot)

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

데이터갱신일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2018-08-31 23:59:59
Maximum2018-08-31 23:59:59
2024-04-06T20:44:50.429466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:44:50.661602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

좌표정보(X)
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
68 
191531.129298248
 
1

Length

Max length16
Median length4
Mean length4.173913
Min length4

Unique

Unique1 ?
Unique (%)1.4%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 68
98.6%
191531.129298248 1
 
1.4%

Length

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

Common Values (Plot)

2024-04-06T20:44:51.088898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 68
98.6%
191531.129298248 1
 
1.4%

좌표정보(Y)
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
<NA>
68 
454267.76660499
 
1

Length

Max length15
Median length4
Mean length4.1594203
Min length4

Unique

Unique1 ?
Unique (%)1.4%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 68
98.6%
454267.76660499 1
 
1.4%

Length

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

Common Values (Plot)

2024-04-06T20:44:51.477638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 68
98.6%
454267.76660499 1
 
1.4%

업소구분명
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing68
Missing (%)98.6%
Memory size684.0 B
2024-04-06T20:44:51.605335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters2
Distinct characters2
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row지정
ValueCountFrequency (%)
지정 1
100.0%
2024-04-06T20:44:51.962829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
지 1
50.0%
정 1
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 1
50.0%
정 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 1
50.0%
정 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
지 1
50.0%
정 1
50.0%

소재지
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

항목값1
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
관급봉투
69 

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 (%)
관급봉투 69
100.0%

Length

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

Common Values (Plot)

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

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
0311000031100001420000000120000624<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122120서울특별시 은평구 진관동 299-61 번지<NA><NA>문석상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA>지정<NA><NA><NA>관급봉투
1311000031100001420000005820000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 254-27 번지<NA><NA>은성슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
2311000031100001420000005920000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 283-29 번지<NA><NA>대일슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
3311000031100001420000006020000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 297-82 번지<NA><NA>연화슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
4311000031100001420000006120000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 296-46 번지<NA><NA>신흥슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
5311000031100001420000006220000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 603-14 번지<NA><NA>대우상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
6311000031100001420000006320000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 263-103 번지<NA><NA>은혜슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
7311000031100001420000006420000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 299-73 번지<NA><NA>진영상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
8311000031100001420000006520000412<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 291-7 번지<NA><NA>은평식품2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
9311000031100001420000006620000404<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122014서울특별시 은평구 응암동 297-35 번지<NA><NA>만물할인마트2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
59311000031100001420000015819980827<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 285-97 번지<NA><NA>원희식품2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
60311000031100001420000015919980827<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 281-138 번지<NA><NA>중앙상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
61311000031100001420000016019980820<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 12-335 번지<NA><NA>충남슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
62311000031100001420000016119980820<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 276-2 번지<NA><NA>대원상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
63311000031100001420000016219980818<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 15-1 번지<NA><NA>명랑쌀상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
64311000031100001420000016319980814<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 12-439 번지<NA><NA>대흥상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
65311000031100001420000016419980814<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 433-13 번지<NA><NA>한다사유통2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
66311000031100001420000016519980724<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>122051서울특별시 은평구 갈현동 409-6 번지<NA><NA>샛별문방구2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
67311000031100001420000021220000531<NA>1영업/정상11영업<NA><NA><NA><NA>02 373 5101<NA>122100서울특별시 은평구 증산동 205-9 번지<NA><NA>대성상회2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
68311000031100001420000021320000531<NA>1영업/정상11영업<NA><NA><NA><NA>02 309 7011<NA>122100서울특별시 은평구 증산동 194-10 번지<NA><NA>오복슈퍼2007-07-14 10:24:07I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투