Overview

Dataset statistics

Number of variables30
Number of observations86
Missing cells1109
Missing cells (%)43.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory21.9 KiB
Average record size in memory260.5 B

Variable types

Categorical9
Numeric5
Unsupported10
Text4
DateTime2

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),업소구분명,소재지,지정일자,신청일자,항목값1
Author광진구
URLhttps://data.seoul.go.kr/dataList/OA-19456/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
항목값1 has constant value ""Constant
데이터갱신구분 is highly imbalanced (72.9%)Imbalance
업소구분명 is highly imbalanced (58.4%)Imbalance
인허가취소일자 has 86 (100.0%) missing valuesMissing
폐업일자 has 86 (100.0%) missing valuesMissing
휴업시작일자 has 86 (100.0%) missing valuesMissing
휴업종료일자 has 86 (100.0%) missing valuesMissing
재개업일자 has 86 (100.0%) missing valuesMissing
전화번호 has 86 (100.0%) missing valuesMissing
소재지면적 has 86 (100.0%) missing valuesMissing
도로명주소 has 82 (95.3%) missing valuesMissing
도로명우편번호 has 86 (100.0%) missing valuesMissing
업태구분명 has 86 (100.0%) missing valuesMissing
좌표정보(X) has 80 (93.0%) missing valuesMissing
좌표정보(Y) has 80 (93.0%) missing valuesMissing
소재지 has 4 (4.7%) missing valuesMissing
지정일자 has 86 (100.0%) missing valuesMissing
신청일자 has 3 (3.5%) 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
지정일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-29 19:56:12.836436
Analysis finished2024-04-29 19:56:13.504089
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
3040000
86 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3040000 86
100.0%

Length

2024-04-30T04:56:13.581318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:13.664771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3040000 86
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct86
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.0400001 × 1017
Minimum3.0400001 × 1017
Maximum3.0400001 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-04-30T04:56:13.766042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation32227.74
Coefficient of variation (CV)1.060123 × 10-13
Kurtosis4.0084308
Mean3.0400001 × 1017
Median Absolute Deviation (MAD)0
Skewness2.4299509
Sum7.6972571 × 1018
Variance1.0386272 × 109
MonotonicityStrictly increasing
2024-04-30T04:56:13.888259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
304000014199900001 1
 
1.2%
304000014199900066 1
 
1.2%
304000014199900074 1
 
1.2%
304000014199900073 1
 
1.2%
304000014199900072 1
 
1.2%
304000014199900071 1
 
1.2%
304000014199900070 1
 
1.2%
304000014199900069 1
 
1.2%
304000014199900068 1
 
1.2%
304000014199900067 1
 
1.2%
Other values (76) 76
88.4%
ValueCountFrequency (%)
304000014199900001 1
1.2%
304000014199900002 1
1.2%
304000014199900003 1
1.2%
304000014199900004 1
1.2%
304000014199900005 1
1.2%
304000014199900006 1
1.2%
304000014199900007 1
1.2%
304000014199900008 1
1.2%
304000014199900009 1
1.2%
304000014199900010 1
1.2%
ValueCountFrequency (%)
304000014200000029 1
1.2%
304000014200000026 1
1.2%
304000014200000022 1
1.2%
304000014200000021 1
1.2%
304000014200000020 1
1.2%
304000014200000017 1
1.2%
304000014200000016 1
1.2%
304000014200000015 1
1.2%
304000014200000014 1
1.2%
304000014200000013 1
1.2%

인허가일자
Real number (ℝ)

Distinct36
Distinct (%)41.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19998013
Minimum19990513
Maximum20001221
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-04-30T04:56:14.018288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19990513
5-th percentile19991048
Q119993449
median20000104
Q320000612
95-th percentile20000980
Maximum20001221
Range10708
Interquartile range (IQR)7163.5

Descriptive statistics

Standard deviation4066.207
Coefficient of variation (CV)0.00020333055
Kurtosis-0.72595485
Mean19998013
Median Absolute Deviation (MAD)511.5
Skewness-1.1220161
Sum1.7198291 × 109
Variance16534040
MonotonicityNot monotonic
2024-04-30T04:56:14.143586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
20000104 18
20.9%
19991230 10
 
11.6%
20000103 9
 
10.5%
20000718 7
 
8.1%
20000102 4
 
4.7%
19991231 2
 
2.3%
20000114 2
 
2.3%
20000107 2
 
2.3%
20000316 2
 
2.3%
20000602 2
 
2.3%
Other values (26) 28
32.6%
ValueCountFrequency (%)
19990513 1
 
1.2%
19990903 1
 
1.2%
19991015 1
 
1.2%
19991025 1
 
1.2%
19991028 1
 
1.2%
19991106 1
 
1.2%
19991111 1
 
1.2%
19991125 1
 
1.2%
19991221 2
 
2.3%
19991230 10
11.6%
ValueCountFrequency (%)
20001221 1
 
1.2%
20001101 1
 
1.2%
20001022 1
 
1.2%
20001005 2
 
2.3%
20000907 1
 
1.2%
20000829 1
 
1.2%
20000825 1
 
1.2%
20000721 1
 
1.2%
20000718 7
8.1%
20000716 1
 
1.2%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

영업상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
1
86 

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

Length

2024-04-30T04:56:14.259625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:14.348559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 86
100.0%

영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
영업/정상
86 

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

Length

2024-04-30T04:56:14.445159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:14.523619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 86
100.0%

상세영업상태코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
11
86 

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

Length

2024-04-30T04:56:14.612917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:14.697117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11 86
100.0%

상세영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
영업
86 

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

Length

2024-04-30T04:56:14.782105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:14.864196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 86
100.0%

폐업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

전화번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

소재지우편번호
Categorical

Distinct5
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size820.0 B
143221
22 
143222
19 
143224
18 
143223
15 
143191
12 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
143221 22
25.6%
143222 19
22.1%
143224 18
20.9%
143223 15
17.4%
143191 12
14.0%

Length

2024-04-30T04:56:14.945460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:15.052141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
143221 22
25.6%
143222 19
22.1%
143224 18
20.9%
143223 15
17.4%
143191 12
14.0%

지번주소
Text

UNIQUE 

Distinct86
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size820.0 B
2024-04-30T04:56:15.277021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length22.604651
Min length18

Characters and Unicode

Total characters1944
Distinct characters27
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

Unique86 ?
Unique (%)100.0%

Sample

1st row서울특별시 광진구 중곡동 644-1
2nd row서울특별시 광진구 중곡동 640-4
3rd row서울특별시 광진구 중곡동 254-2
4th row서울특별시 광진구 중곡동 165-1
5th row서울특별시 광진구 중곡동 230-5 번지
ValueCountFrequency (%)
서울특별시 86
24.7%
광진구 86
24.7%
중곡동 74
21.3%
자양동 12
 
3.4%
번지 4
 
1.1%
84-1 1
 
0.3%
18-111 1
 
0.3%
89-4 1
 
0.3%
75-48 1
 
0.3%
106-15 1
 
0.3%
Other values (81) 81
23.3%
2024-04-30T04:56:15.657780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
528
27.2%
서 86
 
4.4%
특 86
 
4.4%
별 86
 
4.4%
시 86
 
4.4%
광 86
 
4.4%
진 86
 
4.4%
구 86
 
4.4%
동 86
 
4.4%
울 86
 
4.4%
Other values (17) 642
33.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 954
49.1%
Space Separator 528
27.2%
Decimal Number 378
 
19.4%
Dash Punctuation 84
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 86
9.0%
특 86
9.0%
별 86
9.0%
시 86
9.0%
광 86
9.0%
진 86
9.0%
구 86
9.0%
동 86
9.0%
울 86
9.0%
중 74
7.8%
Other values (5) 106
11.1%
Decimal Number
ValueCountFrequency (%)
1 75
19.8%
2 62
16.4%
5 45
11.9%
4 39
10.3%
3 34
9.0%
6 31
8.2%
0 28
 
7.4%
9 26
 
6.9%
7 20
 
5.3%
8 18
 
4.8%
Space Separator
ValueCountFrequency (%)
528
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 990
50.9%
Hangul 954
49.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 86
9.0%
특 86
9.0%
별 86
9.0%
시 86
9.0%
광 86
9.0%
진 86
9.0%
구 86
9.0%
동 86
9.0%
울 86
9.0%
중 74
7.8%
Other values (5) 106
11.1%
Common
ValueCountFrequency (%)
528
53.3%
- 84
 
8.5%
1 75
 
7.6%
2 62
 
6.3%
5 45
 
4.5%
4 39
 
3.9%
3 34
 
3.4%
6 31
 
3.1%
0 28
 
2.8%
9 26
 
2.6%
Other values (2) 38
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 990
50.9%
Hangul 954
49.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
528
53.3%
- 84
 
8.5%
1 75
 
7.6%
2 62
 
6.3%
5 45
 
4.5%
4 39
 
3.9%
3 34
 
3.4%
6 31
 
3.1%
0 28
 
2.8%
9 26
 
2.6%
Other values (2) 38
 
3.8%
Hangul
ValueCountFrequency (%)
서 86
9.0%
특 86
9.0%
별 86
9.0%
시 86
9.0%
광 86
9.0%
진 86
9.0%
구 86
9.0%
동 86
9.0%
울 86
9.0%
중 74
7.8%
Other values (5) 106
11.1%

도로명주소
Text

MISSING 

Distinct4
Distinct (%)100.0%
Missing82
Missing (%)95.3%
Memory size820.0 B
2024-04-30T04:56:15.815225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length27.5
Mean length26.75
Min length26

Characters and Unicode

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

Unique

Unique4 ?
Unique (%)100.0%

Sample

1st row서울특별시 광진구 능동로47길 37-1 (중곡동)
2nd row서울특별시 광진구 용마산로24길 14 (중곡동)
3rd row서울특별시 광진구 자양로19길 63 (자양동)
4th row서울특별시 광진구 뚝섬로55길 39 (자양동)
ValueCountFrequency (%)
서울특별시 4
20.0%
광진구 4
20.0%
중곡동 2
10.0%
자양동 2
10.0%
능동로47길 1
 
5.0%
37-1 1
 
5.0%
용마산로24길 1
 
5.0%
14 1
 
5.0%
자양로19길 1
 
5.0%
63 1
 
5.0%
Other values (2) 2
10.0%
2024-04-30T04:56:16.078453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20
 
18.7%
동 5
 
4.7%
구 4
 
3.7%
( 4
 
3.7%
울 4
 
3.7%
길 4
 
3.7%
로 4
 
3.7%
) 4
 
3.7%
서 4
 
3.7%
진 4
 
3.7%
Other values (23) 50
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 61
57.0%
Space Separator 20
 
18.7%
Decimal Number 17
 
15.9%
Open Punctuation 4
 
3.7%
Close Punctuation 4
 
3.7%
Dash Punctuation 1
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 5
 
8.2%
구 4
 
6.6%
울 4
 
6.6%
길 4
 
6.6%
로 4
 
6.6%
서 4
 
6.6%
진 4
 
6.6%
광 4
 
6.6%
시 4
 
6.6%
별 4
 
6.6%
Other values (11) 20
32.8%
Decimal Number
ValueCountFrequency (%)
4 3
17.6%
3 3
17.6%
1 3
17.6%
9 2
11.8%
5 2
11.8%
7 2
11.8%
2 1
 
5.9%
6 1
 
5.9%
Space Separator
ValueCountFrequency (%)
20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 61
57.0%
Common 46
43.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 5
 
8.2%
구 4
 
6.6%
울 4
 
6.6%
길 4
 
6.6%
로 4
 
6.6%
서 4
 
6.6%
진 4
 
6.6%
광 4
 
6.6%
시 4
 
6.6%
별 4
 
6.6%
Other values (11) 20
32.8%
Common
ValueCountFrequency (%)
20
43.5%
( 4
 
8.7%
) 4
 
8.7%
4 3
 
6.5%
3 3
 
6.5%
1 3
 
6.5%
9 2
 
4.3%
5 2
 
4.3%
7 2
 
4.3%
2 1
 
2.2%
Other values (2) 2
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 61
57.0%
ASCII 46
43.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
20
43.5%
( 4
 
8.7%
) 4
 
8.7%
4 3
 
6.5%
3 3
 
6.5%
1 3
 
6.5%
9 2
 
4.3%
5 2
 
4.3%
7 2
 
4.3%
2 1
 
2.2%
Other values (2) 2
 
4.3%
Hangul
ValueCountFrequency (%)
동 5
 
8.2%
구 4
 
6.6%
울 4
 
6.6%
길 4
 
6.6%
로 4
 
6.6%
서 4
 
6.6%
진 4
 
6.6%
광 4
 
6.6%
시 4
 
6.6%
별 4
 
6.6%
Other values (11) 20
32.8%

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

사업장명
Text

Distinct82
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Memory size820.0 B
2024-04-30T04:56:16.316895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length4
Mean length4.4534884
Min length3

Characters and Unicode

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

Unique

Unique79 ?
Unique (%)91.9%

Sample

1st row빙그레슈퍼
2nd row종합전기내용
3rd row우정슈퍼
4th row대성슈퍼
5th row건어물상회
ValueCountFrequency (%)
우리슈퍼 3
 
3.5%
대성슈퍼 2
 
2.3%
제일슈퍼 2
 
2.3%
자양슈퍼 1
 
1.2%
농협하나로마트 1
 
1.2%
중곡공판장 1
 
1.2%
벨마트 1
 
1.2%
중앙슈퍼 1
 
1.2%
농협식품전문점 1
 
1.2%
소망슈퍼 1
 
1.2%
Other values (72) 72
83.7%
2024-04-30T04:56:16.696100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
퍼 45
 
11.7%
슈 43
 
11.2%
마 19
 
5.0%
트 14
 
3.7%
성 13
 
3.4%
중 9
 
2.3%
상 8
 
2.1%
곡 8
 
2.1%
신 7
 
1.8%
회 7
 
1.8%
Other values (105) 210
54.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 379
99.0%
Uppercase Letter 2
 
0.5%
Open Punctuation 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
퍼 45
 
11.9%
슈 43
 
11.3%
마 19
 
5.0%
트 14
 
3.7%
성 13
 
3.4%
중 9
 
2.4%
상 8
 
2.1%
곡 8
 
2.1%
신 7
 
1.8%
회 7
 
1.8%
Other values (101) 206
54.4%
Uppercase Letter
ValueCountFrequency (%)
G 1
50.0%
L 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 379
99.0%
Common 2
 
0.5%
Latin 2
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
퍼 45
 
11.9%
슈 43
 
11.3%
마 19
 
5.0%
트 14
 
3.7%
성 13
 
3.4%
중 9
 
2.4%
상 8
 
2.1%
곡 8
 
2.1%
신 7
 
1.8%
회 7
 
1.8%
Other values (101) 206
54.4%
Common
ValueCountFrequency (%)
( 1
50.0%
) 1
50.0%
Latin
ValueCountFrequency (%)
G 1
50.0%
L 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 379
99.0%
ASCII 4
 
1.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
퍼 45
 
11.9%
슈 43
 
11.3%
마 19
 
5.0%
트 14
 
3.7%
성 13
 
3.4%
중 9
 
2.4%
상 8
 
2.1%
곡 8
 
2.1%
신 7
 
1.8%
회 7
 
1.8%
Other values (101) 206
54.4%
ASCII
ValueCountFrequency (%)
( 1
25.0%
) 1
25.0%
G 1
25.0%
L 1
25.0%

최종수정일자
Date

Distinct83
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size820.0 B
Minimum2007-06-30 09:57:25
Maximum2020-12-21 18:44:24
2024-04-30T04:56:16.842808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:56:16.960720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size820.0 B
U
82 
I
 
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
U 82
95.3%
I 4
 
4.7%

Length

2024-04-30T04:56:17.072329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:17.156327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
u 82
95.3%
i 4
 
4.7%

데이터갱신일자
Date

Distinct3
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size820.0 B
Minimum2018-08-31 23:59:59
Maximum2020-12-23 02:40:00
2024-04-30T04:56:17.223399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:56:17.308778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

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

MISSING 

Distinct6
Distinct (%)100.0%
Missing80
Missing (%)93.0%
Infinite0
Infinite (%)0.0%
Mean207434.54
Minimum206999.44
Maximum208155.96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-04-30T04:56:17.408894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum206999.44
5-th percentile207008.86
Q1207060.58
median207372.21
Q3207656.07
95-th percentile208034.53
Maximum208155.96
Range1156.5217
Interquartile range (IQR)595.4956

Descriptive statistics

Standard deviation457.71108
Coefficient of variation (CV)0.0022065327
Kurtosis-0.75935735
Mean207434.54
Median Absolute Deviation (MAD)316.55145
Skewness0.69195752
Sum1244607.2
Variance209499.43
MonotonicityNot monotonic
2024-04-30T04:56:17.498070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
207037.142194149 1
 
1.2%
208155.958194355 1
 
1.2%
207670.24509546 1
 
1.2%
207613.550996972 1
 
1.2%
206999.436481133 1
 
1.2%
207130.877304261 1
 
1.2%
(Missing) 80
93.0%
ValueCountFrequency (%)
206999.436481133 1
1.2%
207037.142194149 1
1.2%
207130.877304261 1
1.2%
207613.550996972 1
1.2%
207670.24509546 1
1.2%
208155.958194355 1
1.2%
ValueCountFrequency (%)
208155.958194355 1
1.2%
207670.24509546 1
1.2%
207613.550996972 1
1.2%
207130.877304261 1
1.2%
207037.142194149 1
1.2%
206999.436481133 1
1.2%

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

MISSING 

Distinct6
Distinct (%)100.0%
Missing80
Missing (%)93.0%
Infinite0
Infinite (%)0.0%
Mean450181.53
Minimum447851.91
Maximum451812.58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-04-30T04:56:17.594454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum447851.91
5-th percentile447999.42
Q1448904.72
median450774.3
Q3451389.49
95-th percentile451717.97
Maximum451812.58
Range3960.6711
Interquartile range (IQR)2484.7679

Descriptive statistics

Standard deviation1664.2471
Coefficient of variation (CV)0.0036968356
Kurtosis-1.734892
Mean450181.53
Median Absolute Deviation (MAD)849.06053
Skewness-0.67443322
Sum2701089.2
Variance2769718.4
MonotonicityNot monotonic
2024-04-30T04:56:17.689736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
451255.53510176 1
 
1.2%
450293.068253288 1
 
1.2%
451434.142903478 1
 
1.2%
451812.581517442 1
 
1.2%
448441.941315648 1
 
1.2%
447851.910419294 1
 
1.2%
(Missing) 80
93.0%
ValueCountFrequency (%)
447851.910419294 1
1.2%
448441.941315648 1
1.2%
450293.068253288 1
1.2%
451255.53510176 1
1.2%
451434.142903478 1
1.2%
451812.581517442 1
1.2%
ValueCountFrequency (%)
451812.581517442 1
1.2%
451434.142903478 1
1.2%
451255.53510176 1
1.2%
450293.068253288 1
1.2%
448441.941315648 1
1.2%
447851.910419294 1
1.2%

업소구분명
Categorical

IMBALANCE 

Distinct3
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size820.0 B
종료
75 
지정
8 
<NA>
 
3

Length

Max length4
Median length2
Mean length2.0697674
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
종료 75
87.2%
지정 8
 
9.3%
<NA> 3
 
3.5%

Length

2024-04-30T04:56:17.809881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:17.910249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종료 75
87.2%
지정 8
 
9.3%
na 3
 
3.5%

소재지
Text

MISSING 

Distinct82
Distinct (%)100.0%
Missing4
Missing (%)4.7%
Memory size820.0 B
2024-04-30T04:56:18.152951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length26
Mean length24.890244
Min length19

Characters and Unicode

Total characters2041
Distinct characters33
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

Unique82 ?
Unique (%)100.0%

Sample

1st row서울특별시 광진구 중곡1동 644번지1호
2nd row서울특별시 광진구 중곡동 640번지4
3rd row서울특별시 광진구 중곡동 254번지2호
4th row서울특별시 광진구 중곡동 165번지 1 호
5th row서울특별시 광진구 중곡동 241번지 6 호
ValueCountFrequency (%)
서울특별시 82
17.6%
광진구 82
17.6%
중곡동 69
14.8%
호 68
14.6%
1 13
 
2.8%
자양동 11
 
2.4%
5 7
 
1.5%
150번지 4
 
0.9%
241번지 3
 
0.6%
18번지 3
 
0.6%
Other values (109) 123
26.5%
2024-04-30T04:56:18.547928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
543
26.6%
구 83
 
4.1%
서 82
 
4.0%
특 82
 
4.0%
별 82
 
4.0%
시 82
 
4.0%
광 82
 
4.0%
진 82
 
4.0%
울 82
 
4.0%
동 82
 
4.0%
Other values (23) 759
37.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1127
55.2%
Space Separator 543
26.6%
Decimal Number 363
 
17.8%
Dash Punctuation 8
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 83
 
7.4%
서 82
 
7.3%
특 82
 
7.3%
별 82
 
7.3%
시 82
 
7.3%
광 82
 
7.3%
진 82
 
7.3%
울 82
 
7.3%
동 82
 
7.3%
번 74
 
6.6%
Other values (11) 314
27.9%
Decimal Number
ValueCountFrequency (%)
1 73
20.1%
2 59
16.3%
5 43
11.8%
4 38
10.5%
3 32
8.8%
6 30
8.3%
0 27
 
7.4%
9 25
 
6.9%
7 19
 
5.2%
8 17
 
4.7%
Space Separator
ValueCountFrequency (%)
543
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1127
55.2%
Common 914
44.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 83
 
7.4%
서 82
 
7.3%
특 82
 
7.3%
별 82
 
7.3%
시 82
 
7.3%
광 82
 
7.3%
진 82
 
7.3%
울 82
 
7.3%
동 82
 
7.3%
번 74
 
6.6%
Other values (11) 314
27.9%
Common
ValueCountFrequency (%)
543
59.4%
1 73
 
8.0%
2 59
 
6.5%
5 43
 
4.7%
4 38
 
4.2%
3 32
 
3.5%
6 30
 
3.3%
0 27
 
3.0%
9 25
 
2.7%
7 19
 
2.1%
Other values (2) 25
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1127
55.2%
ASCII 914
44.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
543
59.4%
1 73
 
8.0%
2 59
 
6.5%
5 43
 
4.7%
4 38
 
4.2%
3 32
 
3.5%
6 30
 
3.3%
0 27
 
3.0%
9 25
 
2.7%
7 19
 
2.1%
Other values (2) 25
 
2.7%
Hangul
ValueCountFrequency (%)
구 83
 
7.4%
서 82
 
7.3%
특 82
 
7.3%
별 82
 
7.3%
시 82
 
7.3%
광 82
 
7.3%
진 82
 
7.3%
울 82
 
7.3%
동 82
 
7.3%
번 74
 
6.6%
Other values (11) 314
27.9%

지정일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing86
Missing (%)100.0%
Memory size906.0 B

신청일자
Real number (ℝ)

MISSING 

Distinct35
Distinct (%)42.2%
Missing3
Missing (%)3.5%
Infinite0
Infinite (%)0.0%
Mean19998157
Minimum19990513
Maximum20001221
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-04-30T04:56:18.665425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19990513
5-th percentile19991025
Q120000102
median20000104
Q320000616
95-th percentile20000997
Maximum20001221
Range10708
Interquartile range (IQR)514

Descriptive statistics

Standard deviation4011.7998
Coefficient of variation (CV)0.00020060847
Kurtosis-0.49965296
Mean19998157
Median Absolute Deviation (MAD)512
Skewness-1.2145533
Sum1.6598471 × 109
Variance16094538
MonotonicityNot monotonic
2024-04-30T04:56:18.778098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
20000104 17
19.8%
19991230 9
 
10.5%
20000103 8
 
9.3%
20000718 6
 
7.0%
20000102 4
 
4.7%
20000616 3
 
3.5%
20001005 2
 
2.3%
20000602 2
 
2.3%
20000114 2
 
2.3%
20000107 2
 
2.3%
Other values (25) 28
32.6%
(Missing) 3
 
3.5%
ValueCountFrequency (%)
19990513 1
1.2%
19990718 1
1.2%
19990903 1
1.2%
19991015 1
1.2%
19991025 1
1.2%
19991028 1
1.2%
19991106 1
1.2%
19991113 1
1.2%
19991128 1
1.2%
19991221 2
2.3%
ValueCountFrequency (%)
20001221 1
 
1.2%
20001101 1
 
1.2%
20001022 1
 
1.2%
20001005 2
 
2.3%
20000929 2
 
2.3%
20000908 1
 
1.2%
20000828 1
 
1.2%
20000825 1
 
1.2%
20000721 1
 
1.2%
20000718 6
7.0%

항목값1
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
관급봉투
86 

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

Length

2024-04-30T04:56:18.883173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T04:56:19.158481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
관급봉투 86
100.0%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
0304000030400001419990000119991231<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 644-1<NA><NA>빙그레슈퍼2020-10-15 12:17:24U2020-10-17 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡1동 644번지1호<NA>20000929관급봉투
1304000030400001419990000219991231<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 640-4<NA><NA>종합전기내용2020-10-15 12:18:17U2020-10-17 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 640번지4<NA>20000929관급봉투
2304000030400001419990000319991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 254-2<NA><NA>우정슈퍼2020-10-15 12:23:48U2020-10-17 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 254번지2호<NA>19991230관급봉투
3304000030400001419990000419991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 165-1<NA><NA>대성슈퍼2020-12-21 18:06:23U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 165번지 1 호<NA>19991230관급봉투
4304000030400001419990000519991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 230-5 번지<NA><NA>건어물상회2007-06-30 09:57:25I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
5304000030400001419990000619991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 241-6서울특별시 광진구 능동로47길 37-1 (중곡동)<NA>제일쌀상회2020-12-21 17:57:42U2020-12-23 02:40:00.0<NA>207037.142194451255.535102종료서울특별시 광진구 중곡동 241번지 6 호<NA>19991230관급봉투
6304000030400001419990000719991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 241-52<NA><NA>중곡지물포2020-12-21 17:58:36U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 241번지 52 호<NA>19991230관급봉투
7304000030400001419990000819991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 242-1<NA><NA>보성종합슈퍼2020-12-21 17:59:54U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 242번지 1 호<NA>19991230관급봉투
8304000030400001419990000919991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 231-37 번지<NA><NA>세정마트2007-06-30 09:57:25I2018-08-31 23:59:59.0<NA><NA><NA>지정서울특별시 광진구 중곡동 231번지 37 호<NA>19991230관급봉투
9304000030400001419990001019991230<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 256-33<NA><NA>남원슈퍼2020-12-21 18:01:42U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 256번지 33 호<NA>19991230관급봉투
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)업소구분명소재지지정일자신청일자항목값1
76304000030400001420000001320000602<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 245-23<NA><NA>동양슈퍼마켓2020-12-21 18:03:18U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 245번지 23 호<NA>20000602관급봉투
77304000030400001420000001420000713<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 259-20<NA><NA>우리슈퍼2020-12-21 18:03:56U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 259번지 20 호<NA>20000713관급봉투
78304000030400001420000001520000721<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 229-5<NA><NA>(주)해태유통2020-12-21 18:04:41U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 229번지 5 호<NA>20000721관급봉투
79304000030400001420000001620000602<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 247-29<NA><NA>성동마트2020-12-21 18:05:11U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 247번지 29 호<NA>20000602관급봉투
80304000030400001420000001719991025<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 234-15<NA><NA>중곡전원마트2020-12-21 18:05:35U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 234번지 15 호<NA>19991025관급봉투
81304000030400001420000002020000907<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 248-35<NA><NA>영신마트2020-12-21 18:07:19U2020-12-23 02:40:00.0<NA><NA><NA>지정서울특별시 광진구 중곡동 248-35<NA>20000908관급봉투
82304000030400001420000002120000604<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 233-21<NA><NA>만복상회2020-12-21 18:07:51U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 233번지 21 호<NA>20000603관급봉투
83304000030400001420000002220001005<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143221서울특별시 광진구 중곡동 239-16<NA><NA>소망마트2020-12-21 18:08:29U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 239번지 16 호<NA>20001005관급봉투
84304000030400001420000002620000102<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143222서울특별시 광진구 중곡동 341-1 번지<NA><NA>제일슈퍼2007-06-30 09:57:25I2018-08-31 23:59:59.0<NA><NA><NA><NA><NA><NA><NA>관급봉투
85304000030400001420000002920001005<NA>1영업/정상11영업<NA><NA><NA><NA><NA><NA>143222서울특별시 광진구 중곡동 51-1<NA><NA>동일슈퍼2020-12-21 18:11:17U2020-12-23 02:40:00.0<NA><NA><NA>종료서울특별시 광진구 중곡동 51번지 1 호<NA>20001005관급봉투