Overview

Dataset statistics

Number of variables26
Number of observations220
Missing cells1605
Missing cells (%)28.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory47.4 KiB
Average record size in memory220.6 B

Variable types

Categorical8
Numeric4
DateTime6
Unsupported4
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
재개업일자 is highly imbalanced (95.8%)Imbalance
인허가취소일자 has 220 (100.0%) missing valuesMissing
폐업일자 has 83 (37.7%) missing valuesMissing
휴업시작일자 has 216 (98.2%) missing valuesMissing
휴업종료일자 has 216 (98.2%) missing valuesMissing
전화번호 has 66 (30.0%) missing valuesMissing
소재지면적 has 220 (100.0%) missing valuesMissing
소재지우편번호 has 220 (100.0%) missing valuesMissing
지번주소 has 5 (2.3%) missing valuesMissing
도로명주소 has 7 (3.2%) missing valuesMissing
도로명우편번호 has 126 (57.3%) missing valuesMissing
업태구분명 has 220 (100.0%) missing valuesMissing
좌표정보(X) has 3 (1.4%) missing valuesMissing
좌표정보(Y) has 3 (1.4%) 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

Reproduction

Analysis started2024-04-29 19:28:44.278043
Analysis finished2024-04-29 19:28:44.989961
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
3140000
220 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3140000 220
100.0%

Length

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

Common Values (Plot)

2024-04-30T04:28:45.128781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3140000 220
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct220
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0066958 × 1018
Minimum1.991314 × 1018
Maximum2.023314 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-04-30T04:28:45.221664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.991314 × 1018
5-th percentile1.991314 × 1018
Q12.000314 × 1018
median2.005314 × 1018
Q32.014314 × 1018
95-th percentile2.021314 × 1018
Maximum2.023314 × 1018
Range3.2000017 × 1016
Interquartile range (IQR)1.400001 × 1016

Descriptive statistics

Standard deviation9.0129145 × 1015
Coefficient of variation (CV)0.0044914204
Kurtosis-0.8632209
Mean2.0066958 × 1018
Median Absolute Deviation (MAD)6.0000057 × 1015
Skewness0.0089018589
Sum-1.2487751 × 1018
Variance8.1232628 × 1031
MonotonicityStrictly increasing
2024-04-30T04:28:45.330662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1991314008408200003 1
 
0.5%
2011314014108500005 1
 
0.5%
2010314014108500001 1
 
0.5%
2010314014108500002 1
 
0.5%
2010314014108500003 1
 
0.5%
2010314014108500004 1
 
0.5%
2010314014108500005 1
 
0.5%
2010314014108500006 1
 
0.5%
2010314014108500007 1
 
0.5%
2011314014108500001 1
 
0.5%
Other values (210) 210
95.5%
ValueCountFrequency (%)
1991314008408200003 1
0.5%
1991314008408200005 1
0.5%
1991314008408200007 1
0.5%
1991314008408200009 1
0.5%
1991314008408200013 1
0.5%
1991314008408200014 1
0.5%
1991314008408200015 1
0.5%
1991314008408200016 1
0.5%
1991314008408200017 1
0.5%
1991314008408200018 1
0.5%
ValueCountFrequency (%)
2023314025208500006 1
0.5%
2023314025208500005 1
0.5%
2023314025208500004 1
0.5%
2023314025208500003 1
0.5%
2023314025208500002 1
0.5%
2023314025208500001 1
0.5%
2022314025208500002 1
0.5%
2022314025208500001 1
0.5%
2021314025208500006 1
0.5%
2021314025208500005 1
0.5%

인허가일자
Date

Distinct193
Distinct (%)87.7%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum1991-05-04 00:00:00
Maximum2024-04-05 00:00:00
2024-04-30T04:28:45.449616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:45.563272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

영업상태코드
Categorical

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
3
141 
1
72 
4
 
5
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 141
64.1%
1 72
32.7%
4 5
 
2.3%
2 2
 
0.9%

Length

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

Common Values (Plot)

2024-04-30T04:28:45.749779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 141
64.1%
1 72
32.7%
4 5
 
2.3%
2 2
 
0.9%

영업상태명
Categorical

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
폐업
141 
영업/정상
72 
취소/말소/만료/정지/중지
 
5
휴업
 
2

Length

Max length14
Median length2
Mean length3.2545455
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐업
2nd row취소/말소/만료/정지/중지
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 141
64.1%
영업/정상 72
32.7%
취소/말소/만료/정지/중지 5
 
2.3%
휴업 2
 
0.9%

Length

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

Common Values (Plot)

2024-04-30T04:28:45.943714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 141
64.1%
영업/정상 72
32.7%
취소/말소/만료/정지/중지 5
 
2.3%
휴업 2
 
0.9%

상세영업상태코드
Categorical

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
40
141 
20
72 
50
 
5
30
 
2

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row40
2nd row50
3rd row40
4th row40
5th row40

Common Values

ValueCountFrequency (%)
40 141
64.1%
20 72
32.7%
50 5
 
2.3%
30 2
 
0.9%

Length

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

Common Values (Plot)

2024-04-30T04:28:46.109365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
40 141
64.1%
20 72
32.7%
50 5
 
2.3%
30 2
 
0.9%

상세영업상태명
Categorical

Distinct4
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
폐업
141 
정상
72 
영업정지
 
5
휴업
 
2

Length

Max length4
Median length2
Mean length2.0454545
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 141
64.1%
정상 72
32.7%
영업정지 5
 
2.3%
휴업 2
 
0.9%

Length

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

Common Values (Plot)

2024-04-30T04:28:46.372150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 141
64.1%
정상 72
32.7%
영업정지 5
 
2.3%
휴업 2
 
0.9%

폐업일자
Date

MISSING 

Distinct101
Distinct (%)73.7%
Missing83
Missing (%)37.7%
Memory size1.8 KiB
Minimum2005-06-22 00:00:00
Maximum2023-05-31 00:00:00
2024-04-30T04:28:46.469557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:46.573308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

휴업시작일자
Date

MISSING 

Distinct4
Distinct (%)100.0%
Missing216
Missing (%)98.2%
Memory size1.8 KiB
Minimum2012-11-02 00:00:00
Maximum2023-06-12 00:00:00
2024-04-30T04:28:46.661993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:46.740507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

휴업종료일자
Date

MISSING 

Distinct4
Distinct (%)100.0%
Missing216
Missing (%)98.2%
Memory size1.8 KiB
Minimum2013-10-20 00:00:00
Maximum2027-06-11 00:00:00
2024-04-30T04:28:46.823818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:46.897745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

재개업일자
Categorical

IMBALANCE 

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
<NA>
219 
20180625
 
1

Length

Max length8
Median length4
Mean length4.0181818
Min length4

Unique

Unique1 ?
Unique (%)0.5%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 219
99.5%
20180625 1
 
0.5%

Length

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

Common Values (Plot)

2024-04-30T04:28:47.095267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 219
99.5%
20180625 1
 
0.5%

전화번호
Text

MISSING 

Distinct149
Distinct (%)96.8%
Missing66
Missing (%)30.0%
Memory size1.8 KiB
2024-04-30T04:28:47.279398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11.5
Mean length10.961039
Min length8

Characters and Unicode

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

Unique144 ?
Unique (%)93.5%

Sample

1st row02 26932382
2nd row02 26963003
3rd row0226053809
4th row0226423204
5th row0226926479
ValueCountFrequency (%)
02 77
32.2%
26968410 2
 
0.8%
0226944094 2
 
0.8%
0226913211 2
 
0.8%
0226982443 2
 
0.8%
26928425 2
 
0.8%
070 2
 
0.8%
0220651136 1
 
0.4%
0226958667 1
 
0.4%
0226957907 1
 
0.4%
Other values (147) 147
61.5%
2024-04-30T04:28:47.650605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 383
22.7%
0 293
17.4%
6 220
13.0%
158
9.4%
9 126
 
7.5%
4 102
 
6.0%
3 99
 
5.9%
1 84
 
5.0%
5 81
 
4.8%
7 77
 
4.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1530
90.6%
Space Separator 158
 
9.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 383
25.0%
0 293
19.2%
6 220
14.4%
9 126
 
8.2%
4 102
 
6.7%
3 99
 
6.5%
1 84
 
5.5%
5 81
 
5.3%
7 77
 
5.0%
8 65
 
4.2%
Space Separator
ValueCountFrequency (%)
158
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1688
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 383
22.7%
0 293
17.4%
6 220
13.0%
158
9.4%
9 126
 
7.5%
4 102
 
6.0%
3 99
 
5.9%
1 84
 
5.0%
5 81
 
4.8%
7 77
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1688
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 383
22.7%
0 293
17.4%
6 220
13.0%
158
9.4%
9 126
 
7.5%
4 102
 
6.0%
3 99
 
5.9%
1 84
 
5.0%
5 81
 
4.8%
7 77
 
4.6%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

지번주소
Text

MISSING 

Distinct88
Distinct (%)40.9%
Missing5
Missing (%)2.3%
Memory size1.8 KiB
2024-04-30T04:28:47.845167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length37
Mean length24.2
Min length18

Characters and Unicode

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

Unique

Unique62 ?
Unique (%)28.8%

Sample

1st row서울특별시 양천구 신월동 **-**번지
2nd row서울특별시 양천구 신월동 510-1
3rd row서울특별시 양천구 신정동 ****-*번지
4th row서울특별시 양천구 신정동 ****-*번지
5th row서울특별시 양천구 신월동 **-**번지
ValueCountFrequency (%)
서울특별시 215
22.2%
양천구 215
22.2%
번지 163
16.9%
신월동 99
10.2%
신정동 63
 
6.5%
목동 53
 
5.5%
48
 
5.0%
호 33
 
3.4%
층 10
 
1.0%
현대**타워 4
 
0.4%
Other values (56) 64
 
6.6%
2024-04-30T04:28:48.153655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 1096
21.1%
910
17.5%
동 231
 
4.4%
양 216
 
4.2%
천 216
 
4.2%
서 215
 
4.1%
특 215
 
4.1%
별 215
 
4.1%
시 215
 
4.1%
구 215
 
4.1%
Other values (107) 1459
28.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2953
56.8%
Other Punctuation 1100
 
21.1%
Space Separator 910
 
17.5%
Dash Punctuation 207
 
4.0%
Decimal Number 26
 
0.5%
Uppercase Letter 5
 
0.1%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 231
 
7.8%
양 216
 
7.3%
천 216
 
7.3%
서 215
 
7.3%
특 215
 
7.3%
별 215
 
7.3%
시 215
 
7.3%
구 215
 
7.3%
울 215
 
7.3%
지 171
 
5.8%
Other values (90) 829
28.1%
Decimal Number
ValueCountFrequency (%)
1 7
26.9%
0 6
23.1%
8 4
15.4%
5 3
11.5%
3 2
 
7.7%
4 2
 
7.7%
7 1
 
3.8%
2 1
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
B 2
40.0%
C 2
40.0%
A 1
20.0%
Other Punctuation
ValueCountFrequency (%)
* 1096
99.6%
, 4
 
0.4%
Space Separator
ValueCountFrequency (%)
910
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 207
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2953
56.8%
Common 2245
43.1%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 231
 
7.8%
양 216
 
7.3%
천 216
 
7.3%
서 215
 
7.3%
특 215
 
7.3%
별 215
 
7.3%
시 215
 
7.3%
구 215
 
7.3%
울 215
 
7.3%
지 171
 
5.8%
Other values (90) 829
28.1%
Common
ValueCountFrequency (%)
* 1096
48.8%
910
40.5%
- 207
 
9.2%
1 7
 
0.3%
0 6
 
0.3%
, 4
 
0.2%
8 4
 
0.2%
5 3
 
0.1%
3 2
 
0.1%
4 2
 
0.1%
Other values (4) 4
 
0.2%
Latin
ValueCountFrequency (%)
B 2
40.0%
C 2
40.0%
A 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2953
56.8%
ASCII 2250
43.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 1096
48.7%
910
40.4%
- 207
 
9.2%
1 7
 
0.3%
0 6
 
0.3%
, 4
 
0.2%
8 4
 
0.2%
5 3
 
0.1%
3 2
 
0.1%
4 2
 
0.1%
Other values (7) 9
 
0.4%
Hangul
ValueCountFrequency (%)
동 231
 
7.8%
양 216
 
7.3%
천 216
 
7.3%
서 215
 
7.3%
특 215
 
7.3%
별 215
 
7.3%
시 215
 
7.3%
구 215
 
7.3%
울 215
 
7.3%
지 171
 
5.8%
Other values (90) 829
28.1%

도로명주소
Text

MISSING 

Distinct156
Distinct (%)73.2%
Missing7
Missing (%)3.2%
Memory size1.8 KiB
2024-04-30T04:28:48.335220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length44
Mean length28.450704
Min length21

Characters and Unicode

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

Unique

Unique125 ?
Unique (%)58.7%

Sample

1st row서울특별시 양천구 가로공원로 *** (신월동)
2nd row서울특별시 양천구 오목로 58 (신월동)
3rd row서울특별시 양천구 신월로 *** (신정동)
4th row서울특별시 양천구 신월로 *** (신정동)
5th row서울특별시 양천구 화곡로 *** (신월동)
ValueCountFrequency (%)
서울특별시 213
18.0%
양천구 213
18.0%
209
17.7%
신월동 86
 
7.3%
신정동 58
 
4.9%
호 45
 
3.8%
목동 41
 
3.5%
층 30
 
2.5%
목동동로 16
 
1.4%
남부순환로 15
 
1.3%
Other values (114) 258
21.8%
2024-04-30T04:28:48.648734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1041
17.2%
* 856
 
14.1%
동 296
 
4.9%
양 223
 
3.7%
서 221
 
3.6%
로 221
 
3.6%
시 214
 
3.5%
특 213
 
3.5%
별 213
 
3.5%
천 213
 
3.5%
Other values (129) 2349
38.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3573
59.0%
Space Separator 1041
 
17.2%
Other Punctuation 970
 
16.0%
Close Punctuation 213
 
3.5%
Open Punctuation 213
 
3.5%
Dash Punctuation 28
 
0.5%
Decimal Number 15
 
0.2%
Uppercase Letter 7
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 296
 
8.3%
양 223
 
6.2%
서 221
 
6.2%
로 221
 
6.2%
시 214
 
6.0%
특 213
 
6.0%
별 213
 
6.0%
천 213
 
6.0%
구 213
 
6.0%
울 213
 
6.0%
Other values (113) 1333
37.3%
Decimal Number
ValueCountFrequency (%)
6 3
20.0%
3 3
20.0%
1 3
20.0%
8 2
13.3%
2 2
13.3%
0 1
 
6.7%
5 1
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
B 4
57.1%
C 2
28.6%
A 1
 
14.3%
Other Punctuation
ValueCountFrequency (%)
* 856
88.2%
, 114
 
11.8%
Space Separator
ValueCountFrequency (%)
1041
100.0%
Close Punctuation
ValueCountFrequency (%)
) 213
100.0%
Open Punctuation
ValueCountFrequency (%)
( 213
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3573
59.0%
Common 2480
40.9%
Latin 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 296
 
8.3%
양 223
 
6.2%
서 221
 
6.2%
로 221
 
6.2%
시 214
 
6.0%
특 213
 
6.0%
별 213
 
6.0%
천 213
 
6.0%
구 213
 
6.0%
울 213
 
6.0%
Other values (113) 1333
37.3%
Common
ValueCountFrequency (%)
1041
42.0%
* 856
34.5%
) 213
 
8.6%
( 213
 
8.6%
, 114
 
4.6%
- 28
 
1.1%
6 3
 
0.1%
3 3
 
0.1%
1 3
 
0.1%
8 2
 
0.1%
Other values (3) 4
 
0.2%
Latin
ValueCountFrequency (%)
B 4
57.1%
C 2
28.6%
A 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3573
59.0%
ASCII 2487
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1041
41.9%
* 856
34.4%
) 213
 
8.6%
( 213
 
8.6%
, 114
 
4.6%
- 28
 
1.1%
B 4
 
0.2%
6 3
 
0.1%
3 3
 
0.1%
1 3
 
0.1%
Other values (6) 9
 
0.4%
Hangul
ValueCountFrequency (%)
동 296
 
8.3%
양 223
 
6.2%
서 221
 
6.2%
로 221
 
6.2%
시 214
 
6.0%
특 213
 
6.0%
별 213
 
6.0%
천 213
 
6.0%
구 213
 
6.0%
울 213
 
6.0%
Other values (113) 1333
37.3%

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

MISSING 

Distinct65
Distinct (%)69.1%
Missing126
Missing (%)57.3%
Infinite0
Infinite (%)0.0%
Mean51187.777
Minimum7903
Maximum158861
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-04-30T04:28:48.764292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7903
5-th percentile7907.95
Q17932
median8014
Q3158067.75
95-th percentile158812
Maximum158861
Range150958
Interquartile range (IQR)150135.75

Descriptive statistics

Standard deviation68438.722
Coefficient of variation (CV)1.337013
Kurtosis-1.1104828
Mean51187.777
Median Absolute Deviation (MAD)86
Skewness0.95580573
Sum4811651
Variance4.6838587 × 109
MonotonicityNot monotonic
2024-04-30T04:28:48.869701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7932 7
 
3.2%
7906 3
 
1.4%
8104 3
 
1.4%
158723 3
 
1.4%
7920 3
 
1.4%
7959 3
 
1.4%
158093 3
 
1.4%
7917 2
 
0.9%
158073 2
 
0.9%
158846 2
 
0.9%
Other values (55) 63
28.6%
(Missing) 126
57.3%
ValueCountFrequency (%)
7903 1
 
0.5%
7905 1
 
0.5%
7906 3
1.4%
7909 1
 
0.5%
7917 2
0.9%
7920 3
1.4%
7921 1
 
0.5%
7926 2
0.9%
7927 2
0.9%
7928 2
0.9%
ValueCountFrequency (%)
158861 1
 
0.5%
158846 2
0.9%
158845 1
 
0.5%
158812 2
0.9%
158811 1
 
0.5%
158808 1
 
0.5%
158764 1
 
0.5%
158723 3
1.4%
158718 1
 
0.5%
158096 1
 
0.5%

사업장명
Text

Distinct210
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
2024-04-30T04:28:49.076432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length5.5681818
Min length2

Characters and Unicode

Total characters1225
Distinct characters229
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

Unique201 ?
Unique (%)91.4%

Sample

1st row중앙광고
2nd row21세기광고
3rd row행복광고
4th row삼정광고
5th row아주공사
ValueCountFrequency (%)
주식회사 7
 
2.9%
그린광고 3
 
1.3%
미성광고 2
 
0.8%
더좋은엘이디 2
 
0.8%
애드 2
 
0.8%
디자인 2
 
0.8%
유원광고기업 2
 
0.8%
국제광고 2
 
0.8%
다미광고 2
 
0.8%
예인아트 2
 
0.8%
Other values (210) 213
89.1%
2024-04-30T04:28:49.401790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 65
 
5.3%
고 62
 
5.1%
주 47
 
3.8%
인 43
 
3.5%
기 41
 
3.3%
) 37
 
3.0%
( 37
 
3.0%
디 34
 
2.8%
스 32
 
2.6%
획 31
 
2.5%
Other values (219) 796
65.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1115
91.0%
Close Punctuation 37
 
3.0%
Open Punctuation 37
 
3.0%
Space Separator 19
 
1.6%
Decimal Number 8
 
0.7%
Uppercase Letter 5
 
0.4%
Lowercase Letter 4
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 65
 
5.8%
고 62
 
5.6%
주 47
 
4.2%
인 43
 
3.9%
기 41
 
3.7%
디 34
 
3.0%
스 32
 
2.9%
획 31
 
2.8%
이 29
 
2.6%
드 28
 
2.5%
Other values (205) 703
63.0%
Uppercase Letter
ValueCountFrequency (%)
S 1
20.0%
D 1
20.0%
R 1
20.0%
M 1
20.0%
C 1
20.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
25.0%
e 1
25.0%
o 1
25.0%
m 1
25.0%
Decimal Number
ValueCountFrequency (%)
2 5
62.5%
1 3
37.5%
Close Punctuation
ValueCountFrequency (%)
) 37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Space Separator
ValueCountFrequency (%)
19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1115
91.0%
Common 101
 
8.2%
Latin 9
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 65
 
5.8%
고 62
 
5.6%
주 47
 
4.2%
인 43
 
3.9%
기 41
 
3.7%
디 34
 
3.0%
스 32
 
2.9%
획 31
 
2.8%
이 29
 
2.6%
드 28
 
2.5%
Other values (205) 703
63.0%
Latin
ValueCountFrequency (%)
c 1
11.1%
e 1
11.1%
o 1
11.1%
m 1
11.1%
S 1
11.1%
D 1
11.1%
R 1
11.1%
M 1
11.1%
C 1
11.1%
Common
ValueCountFrequency (%)
) 37
36.6%
( 37
36.6%
19
18.8%
2 5
 
5.0%
1 3
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1115
91.0%
ASCII 110
 
9.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 65
 
5.8%
고 62
 
5.6%
주 47
 
4.2%
인 43
 
3.9%
기 41
 
3.7%
디 34
 
3.0%
스 32
 
2.9%
획 31
 
2.8%
이 29
 
2.6%
드 28
 
2.5%
Other values (205) 703
63.0%
ASCII
ValueCountFrequency (%)
) 37
33.6%
( 37
33.6%
19
17.3%
2 5
 
4.5%
1 3
 
2.7%
c 1
 
0.9%
e 1
 
0.9%
o 1
 
0.9%
m 1
 
0.9%
S 1
 
0.9%
Other values (4) 4
 
3.6%

최종수정일자
Date

UNIQUE 

Distinct220
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum1991-05-14 00:00:00
Maximum2024-04-11 09:10:10
2024-04-30T04:28:49.707281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:49.833986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

Distinct2
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
I
157 
U
63 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 157
71.4%
U 63
28.6%

Length

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

Common Values (Plot)

2024-04-30T04:28:50.031205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 157
71.4%
u 63
28.6%

데이터갱신일자
Date

Distinct67
Distinct (%)30.5%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
Minimum2018-08-31 23:59:59
Maximum2023-12-03 23:03:00
2024-04-30T04:28:50.139905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:28:50.263920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing220
Missing (%)100.0%
Memory size2.1 KiB

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

MISSING 

Distinct189
Distinct (%)87.1%
Missing3
Missing (%)1.4%
Infinite0
Infinite (%)0.0%
Mean186794.77
Minimum184325.62
Maximum189430.98
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-04-30T04:28:50.383623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum184325.62
5-th percentile184940.2
Q1185464.59
median186815.33
Q3187901.22
95-th percentile188957.89
Maximum189430.98
Range5105.3617
Interquartile range (IQR)2436.6322

Descriptive statistics

Standard deviation1396.4396
Coefficient of variation (CV)0.0074757958
Kurtosis-1.3055386
Mean186794.77
Median Absolute Deviation (MAD)1241.8576
Skewness0.12369467
Sum40534465
Variance1950043.4
MonotonicityNot monotonic
2024-04-30T04:28:50.544770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
188953.066831076 6
 
2.7%
186221.415138447 4
 
1.8%
188584.345447275 3
 
1.4%
185152.306258581 2
 
0.9%
185105.224152535 2
 
0.9%
185573.477163629 2
 
0.9%
185436.243312496 2
 
0.9%
187744.48609271 2
 
0.9%
188881.05829212 2
 
0.9%
184448.497335143 2
 
0.9%
Other values (179) 190
86.4%
(Missing) 3
 
1.4%
ValueCountFrequency (%)
184325.616204517 1
0.5%
184448.497335143 2
0.9%
184642.060749294 1
0.5%
184682.570481069 1
0.5%
184758.160681476 1
0.5%
184779.911324296 1
0.5%
184824.216779793 1
0.5%
184844.878863426 1
0.5%
184890.666467089 2
0.9%
184952.58622774 1
0.5%
ValueCountFrequency (%)
189430.977860634 1
0.5%
189388.779571528 1
0.5%
189311.02246611 1
0.5%
189128.248867296 1
0.5%
189078.224808079 1
0.5%
189057.436700075 1
0.5%
189042.496526196 2
0.9%
189042.400273025 1
0.5%
188988.388504794 1
0.5%
188977.171050288 1
0.5%

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

MISSING 

Distinct189
Distinct (%)87.1%
Missing3
Missing (%)1.4%
Infinite0
Infinite (%)0.0%
Mean447347.05
Minimum444982.89
Maximum449696.22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-04-30T04:28:50.669571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum444982.89
5-th percentile446022.75
Q1446713.99
median447192.59
Q3447932.27
95-th percentile449316
Maximum449696.22
Range4713.3298
Interquartile range (IQR)1218.2771

Descriptive statistics

Standard deviation963.0564
Coefficient of variation (CV)0.0021528171
Kurtosis0.072971721
Mean447347.05
Median Absolute Deviation (MAD)591.51794
Skewness0.44683961
Sum97074310
Variance927477.63
MonotonicityNot monotonic
2024-04-30T04:28:50.790988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
447333.569187997 6
 
2.7%
447192.585364129 4
 
1.8%
447255.070457495 3
 
1.4%
447932.268189185 2
 
0.9%
446543.818510161 2
 
0.9%
447137.685780275 2
 
0.9%
447544.724584535 2
 
0.9%
446767.791667847 2
 
0.9%
446564.254923985 2
 
0.9%
448167.004353631 2
 
0.9%
Other values (179) 190
86.4%
(Missing) 3
 
1.4%
ValueCountFrequency (%)
444982.894549103 1
0.5%
445070.749071939 2
0.9%
445073.76201045 1
0.5%
445477.850556888 1
0.5%
445768.146016485 1
0.5%
445827.441199077 1
0.5%
445946.301564284 1
0.5%
445984.041714478 1
0.5%
446003.941216623 1
0.5%
446018.063168796 1
0.5%
ValueCountFrequency (%)
449696.22433709 1
0.5%
449687.225627323 1
0.5%
449649.016215774 1
0.5%
449444.832183667 1
0.5%
449395.974853592 1
0.5%
449394.675249633 1
0.5%
449380.074012936 1
0.5%
449363.193667633 1
0.5%
449360.732222656 1
0.5%
449347.98891697 1
0.5%

영업내용
Categorical

Distinct41
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
옥외광고물 등 제작
81 
옥외광고물 제작
58 
<NA>
25 
옥외광고업
 
6
옥외광고물 제작 및 설치
 
5
Other values (36)
45 

Length

Max length18
Median length16
Mean length8.6409091
Min length4

Unique

Unique30 ?
Unique (%)13.6%

Sample

1st row옥외광고물 등 제작
2nd row<NA>
3rd row옥외광고물 등 제작
4th row옥외광고물 제작
5th row옥외광고물 제작

Common Values

ValueCountFrequency (%)
옥외광고물 등 제작 81
36.8%
옥외광고물 제작 58
26.4%
<NA> 25
 
11.4%
옥외광고업 6
 
2.7%
옥외광고물 제작 및 설치 5
 
2.3%
옥외광고물 제작 설치 4
 
1.8%
옥외광고물등 제작 3
 
1.4%
옥외광고대행 2
 
0.9%
옥외광고물 등 제작 및 대행 2
 
0.9%
광고물제작 2
 
0.9%
Other values (31) 32
 
14.5%

Length

2024-04-30T04:28:50.901012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제작 162
31.2%
옥외광고물 156
30.0%
등 87
16.7%
na 25
 
4.8%
및 14
 
2.7%
설치 9
 
1.7%
간판 8
 
1.5%
옥외광고업 7
 
1.3%
대행 5
 
1.0%
광고물 4
 
0.8%
Other values (30) 43
 
8.3%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
03140000199131400840820000319910504<NA>3폐업40폐업20101105<NA><NA><NA>02 26932382<NA><NA>서울특별시 양천구 신월동 **-**번지서울특별시 양천구 가로공원로 *** (신월동)<NA>중앙광고2011-04-05 15:43:56I2018-08-31 23:59:59.0<NA>185107.344342448286.808494옥외광고물 등 제작
13140000199131400840820000519910504<NA>4취소/말소/만료/정지/중지50영업정지<NA><NA><NA><NA>02 26963003<NA><NA>서울특별시 양천구 신월동 510-1서울특별시 양천구 오목로 58 (신월동)<NA>21세기광고2022-12-19 17:06:19U2021-11-01 22:01:00.0<NA>186148.086395446679.296891<NA>
23140000199131400840820000719910504<NA>3폐업40폐업20100709<NA><NA><NA>0226053809<NA><NA>서울특별시 양천구 신정동 ****-*번지서울특별시 양천구 신월로 *** (신정동)<NA>행복광고2011-04-05 15:44:44I2018-08-31 23:59:59.0<NA>186737.931737446648.984649옥외광고물 등 제작
33140000199131400840820000919910504<NA>3폐업40폐업20080403<NA><NA><NA>0226423204<NA><NA>서울특별시 양천구 신정동 ****-*번지서울특별시 양천구 신월로 *** (신정동)<NA>삼정광고2008-04-05 13:17:25I2018-08-31 23:59:59.0<NA>187169.069648446567.166557옥외광고물 제작
43140000199131400840820001319910504<NA>3폐업40폐업20090115<NA><NA><NA>0226926479<NA><NA>서울특별시 양천구 신월동 **-**번지서울특별시 양천구 화곡로 *** (신월동)<NA>아주공사2009-01-20 09:00:51I2018-08-31 23:59:59.0<NA>185197.99384448649.142096옥외광고물 제작
53140000199131400840820001419910514<NA>1영업/정상20정상<NA><NA><NA><NA>02 26950447<NA><NA>서울특별시 양천구 신월동 **-*번지서울특별시 양천구 남부순환로 *** (신월동)158093오색광고2014-10-10 15:25:40I2018-08-31 23:59:59.0<NA>184682.570481448260.582907옥외광고물 등 제작
63140000199131400840820001519910514<NA>3폐업40폐업20210930<NA><NA><NA>02 26462082<NA><NA>서울특별시 양천구 신월동 **-*서울특별시 양천구 곰달래로**길 ** (신월동)7917하나광고2021-10-06 10:04:22U2021-10-08 02:40:00.0<NA>185258.076424448238.854294옥외광고물 등 제작
73140000199131400840820001619910514<NA>3폐업40폐업20210621<NA><NA><NA>02 26461480<NA><NA>서울특별시 양천구 신정동 ***-**서울특별시 양천구 오목로**길 ** (신정동)7943아멘광고2021-06-22 17:20:42U2021-06-24 02:40:00.0<NA>187185.587643447102.037458옥외광고물 등 제작
83140000199131400840820001719910514<NA>3폐업40폐업20060508<NA><NA><NA>02 26958878<NA><NA>서울특별시 양천구 신월동 ***-*번지서울특별시 양천구 곰달래로*길 **-* (신월동)<NA>영광광고1991-05-14 00:00:00I2018-08-31 23:59:59.0<NA>185179.423385447784.1033옥외광고물 제작
93140000199131400840820001820080111<NA>3폐업40폐업20220907<NA><NA><NA>02 26903321<NA><NA>서울특별시 양천구 신월동 ***-*서울특별시 양천구 월정로 * (신월동)8028영진광고2022-09-13 07:23:36U2021-12-08 23:05:00.0<NA>186164.802709446482.211102<NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
2103140000202131402520850000520090403<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 신월동 **-*서울특별시 양천구 곰달래로**길 **, *층 (신월동)7917금강광고2021-10-25 10:19:08U2021-10-27 02:40:00.0<NA>185258.076424448238.854294간판, 현수막 제작 및 시공
2113140000202131402520850000620211210<NA>3폐업40폐업20220307<NA><NA><NA><NA><NA><NA>서울특별시 양천구 목동 ***-***서울특별시 양천구 목동동로**길 *, *층 (목동)8005(주)스튜디오스프링2022-03-07 15:59:41U2022-03-10 02:40:00.0<NA>188604.301151446921.747171옥외광고업 등
2123140000202231402520850000120100504<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 신정동 ****-* 레몬테라스서울특별시 양천구 목동로*길 *-*, *층 (신정동, 레몬테라스)8023드림웍스2022-05-27 17:34:24I2021-12-04 22:09:00.0<NA>187868.287322446771.973557<NA>
2133140000202231402520850000220200221<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 남부순환로 ***, ***호 (신월동)7928리디자인2022-06-30 09:02:25I2021-12-07 00:02:00.0<NA>185588.112351446611.369233<NA>
214314000020233140252085000012023-02-09<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 신월동 ***-**서울특별시 양천구 곰달래로*길 **, *층 (신월동)7927유별2023-02-10 10:36:26I2022-12-01 23:02:00.0<NA>185487.296193447167.591905<NA>
215314000020233140252085000022023-04-04<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 신정동 ***-**서울특별시 양천구 신정중앙로 **, *층 *호 (신정동)7939(주)에프에이 일렉콤2023-04-06 14:00:46I2022-12-04 00:08:00.0<NA>186954.825962447314.744403<NA>
216314000020233140252085000032017-04-17<NA>1영업/정상20정상<NA><NA><NA><NA>02 26323457<NA><NA>서울특별시 양천구 목동 ***-*서울특별시 양천구 목동중앙북로 ***-*, 동군빌딩 *층 (목동)7968한강씨엔씨2023-04-28 14:11:25I2022-12-03 21:00:00.0<NA>189078.224808449363.193668<NA>
217314000020233140252085000042023-09-18<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 목동 ***-* 페르하임 제비**호서울특별시 양천구 목동중앙서로 **, *층 제비**호 (목동, 페르하임)7966재원애드컴2023-11-02 16:11:06U2022-11-01 00:04:00.0<NA>188056.097472447817.444189<NA>
218314000020233140252085000052023-10-23<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 목동 ***-*서울특별시 양천구 등촌로 **, *층 (목동)7959제일광고기획2023-10-23 15:09:08I2022-10-30 22:05:00.0<NA>187896.513289448358.278613<NA>
219314000020233140252085000062023-12-12<NA>1영업/정상20정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 양천구 신월동 ***-**서울특별시 양천구 월정로**길 ** (신월동)7926천지광고2023-12-14 14:04:21I2022-11-01 23:06:00.0<NA>185541.278077447311.079585<NA>