Overview

Dataset statistics

Number of variables29
Number of observations2454
Missing cells18909
Missing cells (%)26.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory599.2 KiB
Average record size in memory250.1 B

Variable types

Numeric12
Categorical7
Unsupported4
Text5
DateTime1

Dataset

Description6270000_대구광역시_04_15_01_P_옥외광고업_2월
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=DMI_0000084279&dataSetDetailId=DDI_0000084308&provdMethod=FILE

Alerts

개방서비스명 has constant value ""Constant
개방서비스ID has constant value ""Constant
상세영업상태명 is highly imbalanced (57.4%)Imbalance
재개업일자 is highly imbalanced (98.9%)Imbalance
인허가취소일자 has 2454 (100.0%) missing valuesMissing
폐업일자 has 884 (36.0%) missing valuesMissing
휴업시작일자 has 2419 (98.6%) missing valuesMissing
휴업종료일자 has 2419 (98.6%) missing valuesMissing
소재지전화 has 615 (25.1%) missing valuesMissing
소재지면적 has 2454 (100.0%) missing valuesMissing
소재지우편번호 has 2454 (100.0%) missing valuesMissing
소재지전체주소 has 44 (1.8%) missing valuesMissing
도로명전체주소 has 521 (21.2%) missing valuesMissing
도로명우편번호 has 1233 (50.2%) missing valuesMissing
업태구분명 has 2454 (100.0%) missing valuesMissing
좌표정보(X) has 448 (18.3%) missing valuesMissing
좌표정보(Y) has 448 (18.3%) missing valuesMissing
영업내용 has 62 (2.5%) 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

Reproduction

Analysis started2023-12-10 20:50:24.881578
Analysis finished2023-12-10 20:50:26.759977
Duration1.88 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct2454
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1227.5
Minimum1
Maximum2454
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:26.916178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile123.65
Q1614.25
median1227.5
Q31840.75
95-th percentile2331.35
Maximum2454
Range2453
Interquartile range (IQR)1226.5

Descriptive statistics

Standard deviation708.5531
Coefficient of variation (CV)0.57723267
Kurtosis-1.2
Mean1227.5
Median Absolute Deviation (MAD)613.5
Skewness0
Sum3012285
Variance502047.5
MonotonicityStrictly increasing
2023-12-11T05:50:27.153536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1641 1
 
< 0.1%
1634 1
 
< 0.1%
1635 1
 
< 0.1%
1636 1
 
< 0.1%
1637 1
 
< 0.1%
1638 1
 
< 0.1%
1639 1
 
< 0.1%
1640 1
 
< 0.1%
1642 1
 
< 0.1%
Other values (2444) 2444
99.6%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2454 1
< 0.1%
2453 1
< 0.1%
2452 1
< 0.1%
2451 1
< 0.1%
2450 1
< 0.1%
2449 1
< 0.1%
2448 1
< 0.1%
2447 1
< 0.1%
2446 1
< 0.1%
2445 1
< 0.1%

개방서비스명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
옥외광고업
2454 

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 (%)
옥외광고업 2454
100.0%

Length

2023-12-11T05:50:27.375008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:27.543636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
옥외광고업 2454
100.0%

개방서비스ID
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
04_15_01_P
2454 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
04_15_01_P 2454
100.0%

Length

2023-12-11T05:50:27.711240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:27.864067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
04_15_01_p 2454
100.0%

개방자치단체코드
Real number (ℝ)

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3442559.1
Minimum3410000
Maximum3480000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:27.994595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3410000
5-th percentile3410000
Q13420000
median3440000
Q33460000
95-th percentile3470000
Maximum3480000
Range70000
Interquartile range (IQR)40000

Descriptive statistics

Standard deviation21304.089
Coefficient of variation (CV)0.0061884455
Kurtosis-1.262425
Mean3442559.1
Median Absolute Deviation (MAD)20000
Skewness-0.044746149
Sum8.44804 × 109
Variance4.5386422 × 108
MonotonicityIncreasing
2023-12-11T05:50:28.198303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3460000 391
15.9%
3470000 380
15.5%
3420000 349
14.2%
3450000 345
14.1%
3430000 331
13.5%
3410000 318
13.0%
3440000 254
10.4%
3480000 86
 
3.5%
ValueCountFrequency (%)
3410000 318
13.0%
3420000 349
14.2%
3430000 331
13.5%
3440000 254
10.4%
3450000 345
14.1%
3460000 391
15.9%
3470000 380
15.5%
3480000 86
 
3.5%
ValueCountFrequency (%)
3480000 86
 
3.5%
3470000 380
15.5%
3460000 391
15.9%
3450000 345
14.1%
3440000 254
10.4%
3430000 331
13.5%
3420000 349
14.2%
3410000 318
13.0%

관리번호
Real number (ℝ)

Distinct2450
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0040472 × 1018
Minimum1.985345 × 1018
Maximum2.020348 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:28.437148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.985345 × 1018
5-th percentile1.991343 × 1018
Q11.998348 × 1018
median2.002347 × 1018
Q32.0103448 × 1018
95-th percentile2.018341 × 1018
Maximum2.020348 × 1018
Range3.5003032 × 1016
Interquartile range (IQR)1.1996757 × 1016

Descriptive statistics

Standard deviation7.950307 × 1015
Coefficient of variation (CV)0.0039671256
Kurtosis-0.78334443
Mean2.0040472 × 1018
Median Absolute Deviation (MAD)5.0010002 × 1015
Skewness0.23814811
Sum-7.3488501 × 1018
Variance6.3207381 × 1031
MonotonicityNot monotonic
2023-12-11T05:50:28.708591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2008341004708500001 3
 
0.1%
2002345006108200003 2
 
0.1%
2006348009008200005 2
 
0.1%
2004346005708200023 1
 
< 0.1%
2003346005708200009 1
 
< 0.1%
2004346005708200017 1
 
< 0.1%
2004346005708200019 1
 
< 0.1%
2004346005708200020 1
 
< 0.1%
2004346005708200021 1
 
< 0.1%
2004346005708200022 1
 
< 0.1%
Other values (2440) 2440
99.4%
ValueCountFrequency (%)
1985345000008200001 1
< 0.1%
1985345000008200002 1
< 0.1%
1985345000008200003 1
< 0.1%
1985345000008200004 1
< 0.1%
1985345000008200005 1
< 0.1%
1985345000008200006 1
< 0.1%
1985345000008200007 1
< 0.1%
1987345000008200001 1
< 0.1%
1987345000008200002 1
< 0.1%
1988345000008200001 1
< 0.1%
ValueCountFrequency (%)
2020348032408500001 1
< 0.1%
2020347016908500001 1
< 0.1%
2020346011808500001 1
< 0.1%
2020345015408500001 1
< 0.1%
2020344012708500001 1
< 0.1%
2020342017808500001 1
< 0.1%
2020342015308500001 1
< 0.1%
2020341015308500002 1
< 0.1%
2020341015308500001 1
< 0.1%
2019348032408500003 1
< 0.1%

인허가일자
Real number (ℝ)

Distinct1820
Distinct (%)74.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20045875
Minimum19850408
Maximum20200225
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:28.966555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19850408
5-th percentile19910418
Q119990518
median20030714
Q320120383
95-th percentile20180813
Maximum20200225
Range349817
Interquartile range (IQR)129865.75

Descriptive statistics

Standard deviation82829.707
Coefficient of variation (CV)0.0041320075
Kurtosis-0.91278108
Mean20045875
Median Absolute Deviation (MAD)59702.5
Skewness0.10744316
Sum4.9192578 × 1010
Variance6.8607604 × 109
MonotonicityNot monotonic
2023-12-11T05:50:29.246427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19910415 33
 
1.3%
19910312 20
 
0.8%
20000407 8
 
0.3%
20000428 6
 
0.2%
20000607 6
 
0.2%
19980615 5
 
0.2%
19910704 5
 
0.2%
20081104 5
 
0.2%
20010910 5
 
0.2%
19910715 5
 
0.2%
Other values (1810) 2356
96.0%
ValueCountFrequency (%)
19850408 1
 
< 0.1%
19850701 3
0.1%
19850726 1
 
< 0.1%
19850808 2
0.1%
19850831 4
0.2%
19850903 1
 
< 0.1%
19870330 1
 
< 0.1%
19870831 2
0.1%
19880204 1
 
< 0.1%
19880420 1
 
< 0.1%
ValueCountFrequency (%)
20200225 1
 
< 0.1%
20200218 1
 
< 0.1%
20200214 2
0.1%
20200206 1
 
< 0.1%
20200205 1
 
< 0.1%
20200121 2
0.1%
20200115 1
 
< 0.1%
20200110 1
 
< 0.1%
20191226 1
 
< 0.1%
20191209 3
0.1%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2454
Missing (%)100.0%
Memory size21.7 KiB

영업상태구분코드
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
3
1527 
1
897 
2
 
17
4
 
13

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 1527
62.2%
1 897
36.6%
2 17
 
0.7%
4 13
 
0.5%

Length

2023-12-11T05:50:29.489767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:29.669222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 1527
62.2%
1 897
36.6%
2 17
 
0.7%
4 13
 
0.5%

영업상태명
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
폐업
1527 
영업/정상
897 
휴업
 
17
취소/말소/만료/정지/중지
 
13

Length

Max length14
Median length2
Mean length3.1601467
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 1527
62.2%
영업/정상 897
36.6%
휴업 17
 
0.7%
취소/말소/만료/정지/중지 13
 
0.5%

Length

2023-12-11T05:50:29.854868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:30.020195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 1527
62.2%
영업/정상 897
36.6%
휴업 17
 
0.7%
취소/말소/만료/정지/중지 13
 
0.5%

상세영업상태코드
Real number (ℝ)

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.788916
Minimum1
Maximum71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:30.162508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q120
median40
Q340
95-th percentile40
Maximum71
Range70
Interquartile range (IQR)20

Descriptive statistics

Standard deviation11.986143
Coefficient of variation (CV)0.37705415
Kurtosis0.29625971
Mean31.788916
Median Absolute Deviation (MAD)0
Skewness-0.81542443
Sum78010
Variance143.66761
MonotonicityNot monotonic
2023-12-11T05:50:30.375858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
40 1527
62.2%
20 765
31.2%
1 129
 
5.3%
30 17
 
0.7%
70 12
 
0.5%
10 2
 
0.1%
71 1
 
< 0.1%
60 1
 
< 0.1%
ValueCountFrequency (%)
1 129
 
5.3%
10 2
 
0.1%
20 765
31.2%
30 17
 
0.7%
40 1527
62.2%
60 1
 
< 0.1%
70 12
 
0.5%
71 1
 
< 0.1%
ValueCountFrequency (%)
71 1
 
< 0.1%
70 12
 
0.5%
60 1
 
< 0.1%
40 1527
62.2%
30 17
 
0.7%
20 765
31.2%
10 2
 
0.1%
1 129
 
5.3%

상세영업상태명
Categorical

IMBALANCE 

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
폐업
1527 
정상
765 
<NA>
 
129
휴업
 
17
취소
 
12
Other values (3)
 
4

Length

Max length8
Median length2
Mean length2.1100244
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 1527
62.2%
정상 765
31.2%
<NA> 129
 
5.3%
휴업 17
 
0.7%
취소 12
 
0.5%
설립신청 2
 
0.1%
신청취소(취하) 1
 
< 0.1%
부분가동 1
 
< 0.1%

Length

2023-12-11T05:50:30.607602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:30.807958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 1527
62.2%
정상 765
31.2%
na 129
 
5.3%
휴업 17
 
0.7%
취소 12
 
0.5%
설립신청 2
 
0.1%
신청취소(취하 1
 
< 0.1%
부분가동 1
 
< 0.1%

폐업일자
Real number (ℝ)

MISSING 

Distinct974
Distinct (%)62.0%
Missing884
Missing (%)36.0%
Infinite0
Infinite (%)0.0%
Mean20076719
Minimum19910107
Maximum20200213
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:31.037835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19910107
5-th percentile19980570
Q120031016
median20061227
Q320121126
95-th percentile20180525
Maximum20200213
Range290106
Interquartile range (IQR)90109.75

Descriptive statistics

Standard deviation61575.914
Coefficient of variation (CV)0.0030670307
Kurtosis-0.47741636
Mean20076719
Median Absolute Deviation (MAD)40400
Skewness-0.023073136
Sum3.1520449 × 1010
Variance3.7915932 × 109
MonotonicityNot monotonic
2023-12-11T05:50:31.317569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20051212 55
 
2.2%
20060817 28
 
1.1%
20061109 25
 
1.0%
20060306 21
 
0.9%
20091217 19
 
0.8%
20080819 14
 
0.6%
20020312 13
 
0.5%
20021022 13
 
0.5%
19961119 12
 
0.5%
20061113 12
 
0.5%
Other values (964) 1358
55.3%
(Missing) 884
36.0%
ValueCountFrequency (%)
19910107 1
< 0.1%
19910312 1
< 0.1%
19911119 1
< 0.1%
19911211 1
< 0.1%
19920107 1
< 0.1%
19920210 1
< 0.1%
19920311 1
< 0.1%
19920803 1
< 0.1%
19921227 1
< 0.1%
19930218 1
< 0.1%
ValueCountFrequency (%)
20200213 1
 
< 0.1%
20200205 1
 
< 0.1%
20200203 1
 
< 0.1%
20200129 1
 
< 0.1%
20200114 1
 
< 0.1%
20200107 1
 
< 0.1%
20191231 3
0.1%
20191230 1
 
< 0.1%
20191220 2
0.1%
20191219 1
 
< 0.1%

휴업시작일자
Real number (ℝ)

MISSING 

Distinct33
Distinct (%)94.3%
Missing2419
Missing (%)98.6%
Infinite0
Infinite (%)0.0%
Mean20120770
Minimum20060904
Maximum20191116
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:31.571620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20060904
5-th percentile20060992
Q120085555
median20110929
Q320165874
95-th percentile20190948
Maximum20191116
Range130212
Interquartile range (IQR)80319

Descriptive statistics

Standard deviation43930.741
Coefficient of variation (CV)0.0021833528
Kurtosis-1.3027828
Mean20120770
Median Absolute Deviation (MAD)30004
Skewness0.28576632
Sum7.0422696 × 108
Variance1.92991 × 109
MonotonicityNot monotonic
2023-12-11T05:50:31.833565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
20110929 2
 
0.1%
20140730 2
 
0.1%
20190919 1
 
< 0.1%
20170915 1
 
< 0.1%
20090101 1
 
< 0.1%
20061031 1
 
< 0.1%
20060904 1
 
< 0.1%
20170907 1
 
< 0.1%
20080923 1
 
< 0.1%
20091016 1
 
< 0.1%
Other values (23) 23
 
0.9%
(Missing) 2419
98.6%
ValueCountFrequency (%)
20060904 1
< 0.1%
20060905 1
< 0.1%
20061030 1
< 0.1%
20061031 1
< 0.1%
20071218 1
< 0.1%
20080115 1
< 0.1%
20080923 1
< 0.1%
20080925 1
< 0.1%
20081009 1
< 0.1%
20090101 1
< 0.1%
ValueCountFrequency (%)
20191116 1
< 0.1%
20191016 1
< 0.1%
20190919 1
< 0.1%
20190301 1
< 0.1%
20180628 1
< 0.1%
20171010 1
< 0.1%
20170915 1
< 0.1%
20170907 1
< 0.1%
20170818 1
< 0.1%
20160930 1
< 0.1%

휴업종료일자
Real number (ℝ)

MISSING 

Distinct30
Distinct (%)85.7%
Missing2419
Missing (%)98.6%
Infinite0
Infinite (%)0.0%
Mean22415386
Minimum20061030
Maximum99991231
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:32.063915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20061030
5-th percentile20070727
Q120100380
median20130331
Q320181024
95-th percentile20211046
Maximum99991231
Range79930201
Interquartile range (IQR)80644

Descriptive statistics

Standard deviation13498453
Coefficient of variation (CV)0.60219587
Kurtosis34.999161
Mean22415386
Median Absolute Deviation (MAD)39315
Skewness5.9159764
Sum7.8453852 × 108
Variance1.8220824 × 1014
MonotonicityNot monotonic
2023-12-11T05:50:32.308258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
20181231 3
 
0.1%
20141231 3
 
0.1%
20120429 2
 
0.1%
20201020 1
 
< 0.1%
20101231 1
 
< 0.1%
20111030 1
 
< 0.1%
20070904 1
 
< 0.1%
20100115 1
 
< 0.1%
20180817 1
 
< 0.1%
20101015 1
 
< 0.1%
Other values (20) 20
 
0.8%
(Missing) 2419
98.6%
ValueCountFrequency (%)
20061030 1
< 0.1%
20070314 1
< 0.1%
20070904 1
< 0.1%
20081231 1
< 0.1%
20090824 1
< 0.1%
20091008 1
< 0.1%
20091016 1
< 0.1%
20100115 1
< 0.1%
20100330 1
< 0.1%
20100430 1
< 0.1%
ValueCountFrequency (%)
99991231 1
 
< 0.1%
20211116 1
 
< 0.1%
20211016 1
 
< 0.1%
20210228 1
 
< 0.1%
20201020 1
 
< 0.1%
20200907 1
 
< 0.1%
20181231 3
0.1%
20180817 1
 
< 0.1%
20180409 1
 
< 0.1%
20150328 1
 
< 0.1%

재개업일자
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
<NA>
2449 
20141008
 
2
20121121
 
1
20100503
 
1
20181228
 
1

Length

Max length8
Median length4
Mean length4.00815
Min length4

Unique

Unique3 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 2449
99.8%
20141008 2
 
0.1%
20121121 1
 
< 0.1%
20100503 1
 
< 0.1%
20181228 1
 
< 0.1%

Length

2023-12-11T05:50:32.581686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:50:32.815118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 2449
99.8%
20141008 2
 
0.1%
20121121 1
 
< 0.1%
20100503 1
 
< 0.1%
20181228 1
 
< 0.1%

소재지전화
Text

MISSING 

Distinct1635
Distinct (%)88.9%
Missing615
Missing (%)25.1%
Memory size19.3 KiB
2023-12-11T05:50:33.307204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length11.00435
Min length3

Characters and Unicode

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

Unique1457 ?
Unique (%)79.2%

Sample

1st row05342400 90
2nd row0534230 333
3rd row053 4286100
4th row053 4212060
5th row0534213 600
ValueCountFrequency (%)
053 1583
39.0%
768 12
 
0.3%
744 9
 
0.2%
621 9
 
0.2%
765 9
 
0.2%
383 9
 
0.2%
563 8
 
0.2%
354 8
 
0.2%
763 8
 
0.2%
654 8
 
0.2%
Other values (1805) 2399
59.1%
2023-12-11T05:50:34.139332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 3619
17.9%
3 2987
14.8%
0 2746
13.6%
2242
11.1%
6 1503
7.4%
2 1437
 
7.1%
4 1393
 
6.9%
7 1194
 
5.9%
1 1180
 
5.8%
8 989
 
4.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 17995
88.9%
Space Separator 2242
 
11.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 3619
20.1%
3 2987
16.6%
0 2746
15.3%
6 1503
8.4%
2 1437
 
8.0%
4 1393
 
7.7%
7 1194
 
6.6%
1 1180
 
6.6%
8 989
 
5.5%
9 947
 
5.3%
Space Separator
ValueCountFrequency (%)
2242
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 20237
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 3619
17.9%
3 2987
14.8%
0 2746
13.6%
2242
11.1%
6 1503
7.4%
2 1437
 
7.1%
4 1393
 
6.9%
7 1194
 
5.9%
1 1180
 
5.8%
8 989
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 20237
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 3619
17.9%
3 2987
14.8%
0 2746
13.6%
2242
11.1%
6 1503
7.4%
2 1437
 
7.1%
4 1393
 
6.9%
7 1194
 
5.9%
1 1180
 
5.8%
8 989
 
4.9%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2454
Missing (%)100.0%
Memory size21.7 KiB

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2454
Missing (%)100.0%
Memory size21.7 KiB

소재지전체주소
Text

MISSING 

Distinct2157
Distinct (%)89.5%
Missing44
Missing (%)1.8%
Memory size19.3 KiB
2023-12-11T05:50:34.797971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length41
Mean length22.663071
Min length13

Characters and Unicode

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

Unique

Unique1946 ?
Unique (%)80.7%

Sample

1st row대구광역시 중구 대봉동 122-18
2nd row대구광역시 중구 삼덕동3가 26-3
3rd row대구광역시 중구 대봉동 730-2번지
4th row대구광역시 중구 남산동 2466번지 보성황실아파트107-105호
5th row대구광역시 중구 봉산동 235-11번지 3층
ValueCountFrequency (%)
대구광역시 2400
23.7%
달서구 383
 
3.8%
수성구 370
 
3.7%
북구 344
 
3.4%
동구 337
 
3.3%
서구 326
 
3.2%
중구 308
 
3.0%
남구 246
 
2.4%
대명동 173
 
1.7%
평리동 113
 
1.1%
Other values (2438) 5114
50.6%
2023-12-11T05:50:35.718094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10172
18.6%
구 4743
 
8.7%
동 2786
 
5.1%
대 2706
 
5.0%
1 2484
 
4.5%
지 2463
 
4.5%
시 2429
 
4.4%
광 2408
 
4.4%
역 2401
 
4.4%
번 2387
 
4.4%
Other values (257) 19639
36.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 31034
56.8%
Decimal Number 11248
 
20.6%
Space Separator 10172
 
18.6%
Dash Punctuation 2116
 
3.9%
Uppercase Letter 25
 
< 0.1%
Close Punctuation 8
 
< 0.1%
Open Punctuation 7
 
< 0.1%
Other Punctuation 5
 
< 0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 4743
15.3%
동 2786
 
9.0%
대 2706
 
8.7%
지 2463
 
7.9%
시 2429
 
7.8%
광 2408
 
7.8%
역 2401
 
7.7%
번 2387
 
7.7%
서 746
 
2.4%
성 608
 
2.0%
Other values (224) 7357
23.7%
Uppercase Letter
ValueCountFrequency (%)
B 9
36.0%
A 4
16.0%
C 2
 
8.0%
M 2
 
8.0%
J 1
 
4.0%
F 1
 
4.0%
W 1
 
4.0%
S 1
 
4.0%
P 1
 
4.0%
H 1
 
4.0%
Other values (2) 2
 
8.0%
Decimal Number
ValueCountFrequency (%)
1 2484
22.1%
2 1479
13.1%
3 1293
11.5%
4 1017
9.0%
5 909
 
8.1%
0 883
 
7.9%
6 883
 
7.9%
7 805
 
7.2%
8 763
 
6.8%
9 732
 
6.5%
Other Punctuation
ValueCountFrequency (%)
, 3
60.0%
. 1
 
20.0%
/ 1
 
20.0%
Close Punctuation
ValueCountFrequency (%)
) 7
87.5%
] 1
 
12.5%
Math Symbol
ValueCountFrequency (%)
< 1
50.0%
> 1
50.0%
Space Separator
ValueCountFrequency (%)
10172
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2116
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 31034
56.8%
Common 23558
43.1%
Latin 26
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 4743
15.3%
동 2786
 
9.0%
대 2706
 
8.7%
지 2463
 
7.9%
시 2429
 
7.8%
광 2408
 
7.8%
역 2401
 
7.7%
번 2387
 
7.7%
서 746
 
2.4%
성 608
 
2.0%
Other values (224) 7357
23.7%
Common
ValueCountFrequency (%)
10172
43.2%
1 2484
 
10.5%
- 2116
 
9.0%
2 1479
 
6.3%
3 1293
 
5.5%
4 1017
 
4.3%
5 909
 
3.9%
0 883
 
3.7%
6 883
 
3.7%
7 805
 
3.4%
Other values (10) 1517
 
6.4%
Latin
ValueCountFrequency (%)
B 9
34.6%
A 4
15.4%
C 2
 
7.7%
M 2
 
7.7%
J 1
 
3.8%
F 1
 
3.8%
W 1
 
3.8%
S 1
 
3.8%
P 1
 
3.8%
H 1
 
3.8%
Other values (3) 3
 
11.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 31034
56.8%
ASCII 23584
43.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10172
43.1%
1 2484
 
10.5%
- 2116
 
9.0%
2 1479
 
6.3%
3 1293
 
5.5%
4 1017
 
4.3%
5 909
 
3.9%
0 883
 
3.7%
6 883
 
3.7%
7 805
 
3.4%
Other values (23) 1543
 
6.5%
Hangul
ValueCountFrequency (%)
구 4743
15.3%
동 2786
 
9.0%
대 2706
 
8.7%
지 2463
 
7.9%
시 2429
 
7.8%
광 2408
 
7.8%
역 2401
 
7.7%
번 2387
 
7.7%
서 746
 
2.4%
성 608
 
2.0%
Other values (224) 7357
23.7%

도로명전체주소
Text

MISSING 

Distinct1804
Distinct (%)93.3%
Missing521
Missing (%)21.2%
Memory size19.3 KiB
2023-12-11T05:50:36.495584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length47
Mean length25.696327
Min length19

Characters and Unicode

Total characters49671
Distinct characters321
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1691 ?
Unique (%)87.5%

Sample

1st row대구광역시 중구 명륜로 115 (봉산동,3층)
2nd row대구광역시 중구 서성로 26 (계산동2가,정무빌딩4층)
3rd row대구광역시 중구 달구벌대로414길 33 (남산동,대득빌딩3층)
4th row대구광역시 중구 달성로21길 37 (달성동)
5th row대구광역시 중구 동덕로30길 151 (동인동4가)
ValueCountFrequency (%)
대구광역시 1933
 
19.2%
달서구 364
 
3.6%
수성구 299
 
3.0%
동구 258
 
2.6%
북구 239
 
2.4%
남구 237
 
2.4%
중구 235
 
2.3%
서구 231
 
2.3%
대명동 164
 
1.6%
평리동 73
 
0.7%
Other values (1968) 6023
59.9%
2023-12-11T05:50:37.851185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8717
17.5%
구 3985
 
8.0%
대 2530
 
5.1%
동 2468
 
5.0%
시 1962
 
3.9%
광 1950
 
3.9%
역 1936
 
3.9%
( 1877
 
3.8%
) 1877
 
3.8%
로 1856
 
3.7%
Other values (311) 20513
41.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 29085
58.6%
Space Separator 8717
 
17.5%
Decimal Number 7327
 
14.8%
Open Punctuation 1877
 
3.8%
Close Punctuation 1877
 
3.8%
Dash Punctuation 418
 
0.8%
Other Punctuation 340
 
0.7%
Uppercase Letter 27
 
0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 3985
 
13.7%
대 2530
 
8.7%
동 2468
 
8.5%
시 1962
 
6.7%
광 1950
 
6.7%
역 1936
 
6.7%
로 1856
 
6.4%
길 906
 
3.1%
서 751
 
2.6%
성 614
 
2.1%
Other values (279) 10127
34.8%
Uppercase Letter
ValueCountFrequency (%)
A 6
22.2%
B 6
22.2%
M 3
11.1%
F 2
 
7.4%
J 2
 
7.4%
S 2
 
7.4%
D 1
 
3.7%
W 1
 
3.7%
C 1
 
3.7%
H 1
 
3.7%
Other values (2) 2
 
7.4%
Decimal Number
ValueCountFrequency (%)
1 1612
22.0%
2 1098
15.0%
3 940
12.8%
4 664
9.1%
5 603
 
8.2%
6 544
 
7.4%
0 525
 
7.2%
7 503
 
6.9%
9 435
 
5.9%
8 403
 
5.5%
Other Punctuation
ValueCountFrequency (%)
, 337
99.1%
· 2
 
0.6%
. 1
 
0.3%
Math Symbol
ValueCountFrequency (%)
> 1
50.0%
< 1
50.0%
Space Separator
ValueCountFrequency (%)
8717
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1877
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1877
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 418
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 29085
58.6%
Common 20558
41.4%
Latin 28
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 3985
 
13.7%
대 2530
 
8.7%
동 2468
 
8.5%
시 1962
 
6.7%
광 1950
 
6.7%
역 1936
 
6.7%
로 1856
 
6.4%
길 906
 
3.1%
서 751
 
2.6%
성 614
 
2.1%
Other values (279) 10127
34.8%
Common
ValueCountFrequency (%)
8717
42.4%
( 1877
 
9.1%
) 1877
 
9.1%
1 1612
 
7.8%
2 1098
 
5.3%
3 940
 
4.6%
4 664
 
3.2%
5 603
 
2.9%
6 544
 
2.6%
0 525
 
2.6%
Other values (9) 2101
 
10.2%
Latin
ValueCountFrequency (%)
A 6
21.4%
B 6
21.4%
M 3
10.7%
F 2
 
7.1%
J 2
 
7.1%
S 2
 
7.1%
D 1
 
3.6%
W 1
 
3.6%
c 1
 
3.6%
C 1
 
3.6%
Other values (3) 3
10.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 29085
58.6%
ASCII 20584
41.4%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8717
42.3%
( 1877
 
9.1%
) 1877
 
9.1%
1 1612
 
7.8%
2 1098
 
5.3%
3 940
 
4.6%
4 664
 
3.2%
5 603
 
2.9%
6 544
 
2.6%
0 525
 
2.6%
Other values (21) 2127
 
10.3%
Hangul
ValueCountFrequency (%)
구 3985
 
13.7%
대 2530
 
8.7%
동 2468
 
8.5%
시 1962
 
6.7%
광 1950
 
6.7%
역 1936
 
6.7%
로 1856
 
6.4%
길 906
 
3.1%
서 751
 
2.6%
성 614
 
2.1%
Other values (279) 10127
34.8%
None
ValueCountFrequency (%)
· 2
100.0%

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

MISSING 

Distinct658
Distinct (%)53.9%
Missing1233
Missing (%)50.2%
Infinite0
Infinite (%)0.0%
Mean305058.42
Minimum41019
Maximum711882
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:50:38.261396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum41019
5-th percentile41196
Q141968
median42424
Q3704390
95-th percentile704953
Maximum711882
Range670863
Interquartile range (IQR)662422

Descriptive statistics

Standard deviation324207.95
Coefficient of variation (CV)1.0627733
Kurtosis-1.8259511
Mean305058.42
Median Absolute Deviation (MAD)925
Skewness0.42067478
Sum3.7247633 × 108
Variance1.051108 × 1011
MonotonicityNot monotonic
2023-12-11T05:50:38.570607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
704080 21
 
0.9%
704932 19
 
0.8%
704060 13
 
0.5%
704817 11
 
0.4%
42216 9
 
0.4%
704825 9
 
0.4%
704823 8
 
0.3%
704953 8
 
0.3%
42134 8
 
0.3%
704824 7
 
0.3%
Other values (648) 1108
45.2%
(Missing) 1233
50.2%
ValueCountFrequency (%)
41019 1
 
< 0.1%
41026 1
 
< 0.1%
41028 2
0.1%
41030 1
 
< 0.1%
41033 1
 
< 0.1%
41046 1
 
< 0.1%
41055 1
 
< 0.1%
41056 1
 
< 0.1%
41059 3
0.1%
41063 2
0.1%
ValueCountFrequency (%)
711882 1
 
< 0.1%
711874 2
0.1%
711863 1
 
< 0.1%
711860 1
 
< 0.1%
711856 1
 
< 0.1%
711854 1
 
< 0.1%
711845 1
 
< 0.1%
711834 2
0.1%
711833 3
0.1%
711830 2
0.1%

사업장명
Text

Distinct1972
Distinct (%)80.4%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
2023-12-11T05:50:39.037268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length21
Mean length5.6189894
Min length2

Characters and Unicode

Total characters13789
Distinct characters517
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1608 ?
Unique (%)65.5%

Sample

1st row(주)한국도시광고
2nd row제일애드컴
3rd row삼호기획 그래픽
4th row(주)일광기획
5th row비쥬애드컴(주)
ValueCountFrequency (%)
주식회사 48
 
1.8%
디자인 28
 
1.0%
광고회사 10
 
0.4%
광고기획 9
 
0.3%
애드 8
 
0.3%
하나광고 7
 
0.3%
기획 6
 
0.2%
주 6
 
0.2%
현대광고사 6
 
0.2%
factory 5
 
0.2%
Other values (2021) 2540
95.0%
2023-12-11T05:51:36.216316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 1092
 
7.9%
고 1041
 
7.5%
사 637
 
4.6%
인 410
 
3.0%
주 398
 
2.9%
기 361
 
2.6%
) 358
 
2.6%
( 354
 
2.6%
디 317
 
2.3%
획 316
 
2.3%
Other values (507) 8505
61.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12463
90.4%
Close Punctuation 358
 
2.6%
Open Punctuation 354
 
2.6%
Uppercase Letter 270
 
2.0%
Space Separator 219
 
1.6%
Decimal Number 51
 
0.4%
Other Punctuation 37
 
0.3%
Lowercase Letter 32
 
0.2%
Dash Punctuation 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 1092
 
8.8%
고 1041
 
8.4%
사 637
 
5.1%
인 410
 
3.3%
주 398
 
3.2%
기 361
 
2.9%
디 317
 
2.5%
획 316
 
2.5%
이 269
 
2.2%
자 248
 
2.0%
Other values (448) 7374
59.2%
Uppercase Letter
ValueCountFrequency (%)
D 25
 
9.3%
S 23
 
8.5%
C 22
 
8.1%
A 21
 
7.8%
M 19
 
7.0%
O 18
 
6.7%
N 17
 
6.3%
E 16
 
5.9%
G 13
 
4.8%
L 13
 
4.8%
Other values (14) 83
30.7%
Lowercase Letter
ValueCountFrequency (%)
e 5
15.6%
i 4
12.5%
s 4
12.5%
n 4
12.5%
g 3
9.4%
a 2
 
6.2%
x 1
 
3.1%
w 1
 
3.1%
r 1
 
3.1%
d 1
 
3.1%
Other values (6) 6
18.8%
Decimal Number
ValueCountFrequency (%)
1 11
21.6%
2 10
19.6%
3 10
19.6%
0 8
15.7%
5 5
9.8%
7 4
 
7.8%
8 1
 
2.0%
6 1
 
2.0%
4 1
 
2.0%
Other Punctuation
ValueCountFrequency (%)
. 17
45.9%
& 14
37.8%
" 2
 
5.4%
, 2
 
5.4%
/ 1
 
2.7%
· 1
 
2.7%
Close Punctuation
ValueCountFrequency (%)
) 358
100.0%
Open Punctuation
ValueCountFrequency (%)
( 354
100.0%
Space Separator
ValueCountFrequency (%)
219
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12463
90.4%
Common 1024
 
7.4%
Latin 302
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 1092
 
8.8%
고 1041
 
8.4%
사 637
 
5.1%
인 410
 
3.3%
주 398
 
3.2%
기 361
 
2.9%
디 317
 
2.5%
획 316
 
2.5%
이 269
 
2.2%
자 248
 
2.0%
Other values (448) 7374
59.2%
Latin
ValueCountFrequency (%)
D 25
 
8.3%
S 23
 
7.6%
C 22
 
7.3%
A 21
 
7.0%
M 19
 
6.3%
O 18
 
6.0%
N 17
 
5.6%
E 16
 
5.3%
G 13
 
4.3%
L 13
 
4.3%
Other values (30) 115
38.1%
Common
ValueCountFrequency (%)
) 358
35.0%
( 354
34.6%
219
21.4%
. 17
 
1.7%
& 14
 
1.4%
1 11
 
1.1%
2 10
 
1.0%
3 10
 
1.0%
0 8
 
0.8%
- 5
 
0.5%
Other values (9) 18
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12463
90.4%
ASCII 1325
 
9.6%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 1092
 
8.8%
고 1041
 
8.4%
사 637
 
5.1%
인 410
 
3.3%
주 398
 
3.2%
기 361
 
2.9%
디 317
 
2.5%
획 316
 
2.5%
이 269
 
2.2%
자 248
 
2.0%
Other values (448) 7374
59.2%
ASCII
ValueCountFrequency (%)
) 358
27.0%
( 354
26.7%
219
16.5%
D 25
 
1.9%
S 23
 
1.7%
C 22
 
1.7%
A 21
 
1.6%
M 19
 
1.4%
O 18
 
1.4%
N 17
 
1.3%
Other values (48) 249
18.8%
None
ValueCountFrequency (%)
· 1
100.0%

최종수정시점
Real number (ℝ)

Distinct2383
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0106493 × 1013
Minimum1.9850701 × 1013
Maximum2.0200225 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:51:36.440067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9850701 × 1013
5-th percentile1.9947008 × 1013
Q12.0071122 × 1013
median2.0120917 × 1013
Q32.0170502 × 1013
95-th percentile2.0190909 × 1013
Maximum2.0200225 × 1013
Range3.4952417 × 1011
Interquartile range (IQR)9.9379759 × 1010

Descriptive statistics

Standard deviation7.625322 × 1010
Coefficient of variation (CV)0.0037924674
Kurtosis0.21800596
Mean2.0106493 × 1013
Median Absolute Deviation (MAD)4.9795041 × 1010
Skewness-0.99445934
Sum4.9341334 × 1016
Variance5.8145535 × 1021
MonotonicityNot monotonic
2023-12-11T05:51:36.673251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19910415000000 21
 
0.9%
20000407000000 4
 
0.2%
20000406000000 3
 
0.1%
19910329000000 3
 
0.1%
19910713000000 3
 
0.1%
20000428000000 3
 
0.1%
20000129000000 3
 
0.1%
20020202000000 2
 
0.1%
20010316000000 2
 
0.1%
19920212000000 2
 
0.1%
Other values (2373) 2408
98.1%
ValueCountFrequency (%)
19850701000000 2
0.1%
19850726000000 1
< 0.1%
19850903000000 1
< 0.1%
19870831000000 1
< 0.1%
19880420000000 1
< 0.1%
19880708000000 1
< 0.1%
19900710000000 1
< 0.1%
19910320000000 1
< 0.1%
19910321000000 1
< 0.1%
19910325000000 1
< 0.1%
ValueCountFrequency (%)
20200225165313 1
< 0.1%
20200219171504 1
< 0.1%
20200218163034 1
< 0.1%
20200218151746 1
< 0.1%
20200217095806 1
< 0.1%
20200217095756 1
< 0.1%
20200214144434 1
< 0.1%
20200213163949 1
< 0.1%
20200212092157 1
< 0.1%
20200211180128 1
< 0.1%

데이터갱신구분
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
I
2065 
U
389 

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 2065
84.1%
U 389
 
15.9%

Length

2023-12-11T05:51:36.920857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T05:51:37.080819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 2065
84.1%
u 389
 
15.9%

데이터갱신일자
Date

Distinct205
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Memory size19.3 KiB
Minimum2018-08-31 23:59:59
Maximum2020-02-27 00:23:23
2023-12-11T05:51:37.253374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:51:37.487061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2454
Missing (%)100.0%
Memory size21.7 KiB

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

MISSING 

Distinct1734
Distinct (%)86.4%
Missing448
Missing (%)18.3%
Infinite0
Infinite (%)0.0%
Mean342787.47
Minimum204099.91
Maximum357984.66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:51:37.760134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum204099.91
5-th percentile335022.64
Q1340084.14
median343238
Q3345813.08
95-th percentile350706.17
Maximum357984.66
Range153884.75
Interquartile range (IQR)5728.9407

Descriptive statistics

Standard deviation6894.7724
Coefficient of variation (CV)0.02011384
Kurtosis118.23847
Mean342787.47
Median Absolute Deviation (MAD)2912.1117
Skewness-7.7716107
Sum6.8763166 × 108
Variance47537887
MonotonicityNot monotonic
2023-12-11T05:51:37.976387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
347600.95534 7
 
0.3%
345549.11017 6
 
0.2%
348394.245106 6
 
0.2%
344912.358902 6
 
0.2%
346678.067969 5
 
0.2%
347123.859769 5
 
0.2%
345664.831537 4
 
0.2%
344686.259338 4
 
0.2%
334931.565205 4
 
0.2%
342980.514054 4
 
0.2%
Other values (1724) 1955
79.7%
(Missing) 448
 
18.3%
ValueCountFrequency (%)
204099.910435955 1
 
< 0.1%
272048.425701 2
0.1%
272090.012398 3
0.1%
272109.126923 1
 
< 0.1%
272365.578438 1
 
< 0.1%
328311.018298 1
 
< 0.1%
328432.256141 1
 
< 0.1%
329214.669612 1
 
< 0.1%
329730.035818 2
0.1%
329760.456196 1
 
< 0.1%
ValueCountFrequency (%)
357984.664409 1
< 0.1%
357963.405909 1
< 0.1%
356811.019382137 1
< 0.1%
356668.763448 1
< 0.1%
356331.110923 1
< 0.1%
356326.175134 1
< 0.1%
355963.682846 1
< 0.1%
355540.646175 1
< 0.1%
355522.260979 1
< 0.1%
355494.930268 1
< 0.1%

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

MISSING 

Distinct1735
Distinct (%)86.5%
Missing448
Missing (%)18.3%
Infinite0
Infinite (%)0.0%
Mean263896.54
Minimum242528.2
Maximum448866.37
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.7 KiB
2023-12-11T05:51:38.233454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum242528.2
5-th percentile257987.02
Q1261486.5
median263417.83
Q3265309.69
95-th percentile269860.49
Maximum448866.37
Range206338.18
Interquartile range (IQR)3823.1886

Descriptive statistics

Standard deviation9139.4334
Coefficient of variation (CV)0.034632639
Kurtosis190.43698
Mean263896.54
Median Absolute Deviation (MAD)1911.854
Skewness12.231064
Sum5.2937645 × 108
Variance83529243
MonotonicityNot monotonic
2023-12-11T05:51:38.456979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
269860.486838 7
 
0.3%
264222.665286 6
 
0.2%
268253.830253 6
 
0.2%
268620.845678 6
 
0.2%
266537.581353 5
 
0.2%
264683.827139 5
 
0.2%
263958.880864 4
 
0.2%
265183.718118 4
 
0.2%
259242.528512 4
 
0.2%
267632.860744 4
 
0.2%
Other values (1725) 1955
79.7%
(Missing) 448
 
18.3%
ValueCountFrequency (%)
242528.196096 1
< 0.1%
242553.0 1
< 0.1%
243603.85282 1
< 0.1%
244175.449233 1
< 0.1%
244223.605603 1
< 0.1%
244361.0 1
< 0.1%
244393.413228 1
< 0.1%
244490.89219 1
< 0.1%
244504.04518 1
< 0.1%
244584.666286 1
< 0.1%
ValueCountFrequency (%)
448866.372871866 1
 
< 0.1%
386080.358948 1
 
< 0.1%
385675.458397 1
 
< 0.1%
385221.514184 3
0.1%
385018.334086 2
0.1%
274749.657016 2
0.1%
274283.354392 1
 
< 0.1%
274032.68864 1
 
< 0.1%
274028.639393 1
 
< 0.1%
273971.404297 1
 
< 0.1%

영업내용
Text

MISSING 

Distinct602
Distinct (%)25.2%
Missing62
Missing (%)2.5%
Memory size19.3 KiB
2023-12-11T05:51:38.943379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length56
Median length38
Mean length8.9201505
Min length1

Characters and Unicode

Total characters21337
Distinct characters269
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique452 ?
Unique (%)18.9%

Sample

1st row옥외광고업
2nd row옥외광고업
3rd row광고물제작및 설치
4th row옥외광고업.서비스
5th row옥외광고업
ValueCountFrequency (%)
제작 499
 
11.2%
광고물제작 455
 
10.2%
옥외광고물제작 443
 
9.9%
및 416
 
9.3%
옥외광고물 354
 
7.9%
옥외광고업 192
 
4.3%
대행 147
 
3.3%
설치 145
 
3.3%
광고대행 132
 
3.0%
광고물 125
 
2.8%
Other values (482) 1545
34.7%
2023-12-11T05:51:39.677974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 2293
10.7%
고 2280
10.7%
2054
 
9.6%
제 1989
 
9.3%
작 1892
 
8.9%
물 1760
 
8.2%
외 1313
 
6.2%
옥 1300
 
6.1%
및 497
 
2.3%
, 478
 
2.2%
Other values (259) 5481
25.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18360
86.0%
Space Separator 2054
 
9.6%
Other Punctuation 605
 
2.8%
Open Punctuation 93
 
0.4%
Close Punctuation 92
 
0.4%
Decimal Number 49
 
0.2%
Uppercase Letter 48
 
0.2%
Dash Punctuation 26
 
0.1%
Control 8
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 2293
12.5%
고 2280
12.4%
제 1989
10.8%
작 1892
10.3%
물 1760
9.6%
외 1313
 
7.2%
옥 1300
 
7.1%
및 497
 
2.7%
판 392
 
2.1%
업 371
 
2.0%
Other values (228) 4273
23.3%
Decimal Number
ValueCountFrequency (%)
0 15
30.6%
2 8
16.3%
1 8
16.3%
3 4
 
8.2%
4 4
 
8.2%
6 4
 
8.2%
5 3
 
6.1%
8 2
 
4.1%
9 1
 
2.0%
Uppercase Letter
ValueCountFrequency (%)
E 13
27.1%
D 13
27.1%
L 13
27.1%
P 3
 
6.2%
S 3
 
6.2%
C 2
 
4.2%
N 1
 
2.1%
Other Punctuation
ValueCountFrequency (%)
, 478
79.0%
. 58
 
9.6%
: 45
 
7.4%
· 15
 
2.5%
/ 8
 
1.3%
？ 1
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 92
98.9%
[ 1
 
1.1%
Close Punctuation
ValueCountFrequency (%)
) 91
98.9%
] 1
 
1.1%
Math Symbol
ValueCountFrequency (%)
< 1
50.0%
> 1
50.0%
Space Separator
ValueCountFrequency (%)
2054
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%
Control
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 18360
86.0%
Common 2929
 
13.7%
Latin 48
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 2293
12.5%
고 2280
12.4%
제 1989
10.8%
작 1892
10.3%
물 1760
9.6%
외 1313
 
7.2%
옥 1300
 
7.1%
및 497
 
2.7%
판 392
 
2.1%
업 371
 
2.0%
Other values (228) 4273
23.3%
Common
ValueCountFrequency (%)
2054
70.1%
, 478
 
16.3%
( 92
 
3.1%
) 91
 
3.1%
. 58
 
2.0%
: 45
 
1.5%
- 26
 
0.9%
· 15
 
0.5%
0 15
 
0.5%
/ 8
 
0.3%
Other values (14) 47
 
1.6%
Latin
ValueCountFrequency (%)
E 13
27.1%
D 13
27.1%
L 13
27.1%
P 3
 
6.2%
S 3
 
6.2%
C 2
 
4.2%
N 1
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 18359
86.0%
ASCII 2961
 
13.9%
None 16
 
0.1%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 2293
12.5%
고 2280
12.4%
제 1989
10.8%
작 1892
10.3%
물 1760
9.6%
외 1313
 
7.2%
옥 1300
 
7.1%
및 497
 
2.7%
판 392
 
2.1%
업 371
 
2.0%
Other values (227) 4272
23.3%
ASCII
ValueCountFrequency (%)
2054
69.4%
, 478
 
16.1%
( 92
 
3.1%
) 91
 
3.1%
. 58
 
2.0%
: 45
 
1.5%
- 26
 
0.9%
0 15
 
0.5%
E 13
 
0.4%
D 13
 
0.4%
Other values (19) 76
 
2.6%
None
ValueCountFrequency (%)
· 15
93.8%
？ 1
 
6.2%
Compat Jamo
ValueCountFrequency (%)
ㅇ 1
100.0%

Sample

번호개방서비스명개방서비스ID개방자치단체코드관리번호인허가일자인허가취소일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지면적소재지우편번호소재지전체주소도로명전체주소도로명우편번호사업장명최종수정시점데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
01옥외광고업04_15_01_P3410000200334100160820000920030602<NA>3폐업40폐업20061115<NA><NA><NA>05342400 90<NA><NA>대구광역시 중구 대봉동 122-18<NA><NA>(주)한국도시광고20030602000000I2018-08-31 23:59:59.0<NA><NA><NA>옥외광고업
12옥외광고업04_15_01_P3410000200334100160820001020030610<NA>3폐업40폐업20040616<NA><NA><NA>0534230 333<NA><NA>대구광역시 중구 삼덕동3가 26-3<NA><NA>제일애드컴20130725154635I2018-08-31 23:59:59.0<NA><NA><NA>옥외광고업
23옥외광고업04_15_01_P3410000200234100160820000420020208<NA>3폐업40폐업20061024<NA><NA><NA>053 4286100<NA><NA>대구광역시 중구 대봉동 730-2번지<NA><NA>삼호기획 그래픽20140305095932I2018-08-31 23:59:59.0<NA><NA><NA>광고물제작및 설치
34옥외광고업04_15_01_P3410000200534100160820001120050805<NA>3폐업40폐업20070319<NA><NA><NA>053 4212060<NA><NA>대구광역시 중구 남산동 2466번지 보성황실아파트107-105호<NA><NA>(주)일광기획20050805000000I2018-08-31 23:59:59.0<NA><NA><NA>옥외광고업.서비스
45옥외광고업04_15_01_P3410000200534100160820001220050809<NA>3폐업40폐업20090904<NA><NA><NA>0534213 600<NA><NA>대구광역시 중구 봉산동 235-11번지 3층대구광역시 중구 명륜로 115 (봉산동,3층)<NA>비쥬애드컴(주)20090916101012I2018-08-31 23:59:59.0<NA>344168.84425263379.594084옥외광고업
56옥외광고업04_15_01_P3410000200534100160820001320051107<NA>3폐업40폐업20080129<NA><NA><NA>053 2558191<NA><NA>대구광역시 중구 계산동2가 2-2번지 정무빌딩4층대구광역시 중구 서성로 26 (계산동2가,정무빌딩4층)<NA>채널-320080129171224I2018-08-31 23:59:59.0<NA>343296.850164264344.275581옥외광고업
67옥외광고업04_15_01_P3410000200734100470850000120070801<NA>3폐업40폐업20080407<NA><NA><NA><NA><NA><NA>대구광역시 중구 남산동 570-3번지 대득빌딩3층대구광역시 중구 달구벌대로414길 33 (남산동,대득빌딩3층)<NA>디비엔에이20080407175844I2018-08-31 23:59:59.0<NA>343501.926109263867.511992광고대행.제작.전문디자인업.
78옥외광고업04_15_01_P3410000200734100470850000620070821<NA>3폐업40폐업20101221<NA><NA><NA>5658279<NA><NA>대구광역시 중구 달성동 218-8번지대구광역시 중구 달성로21길 37 (달성동)<NA>이노애드주식회사20101221140040I2018-08-31 23:59:59.0<NA>342677.957824265059.525937광고대행업
89옥외광고업04_15_01_P3410000200734100470850000720071005<NA>3폐업40폐업20140831<NA><NA><NA>4224410<NA><NA>대구광역시 중구 동인동4가 541-13번지대구광역시 중구 동덕로30길 151 (동인동4가)<NA>세진광고20141204100009I2018-08-31 23:59:59.0<NA>345529.339417264052.682216간판제작.시공
910옥외광고업04_15_01_P3410000200734100470850000820071016<NA>3폐업40폐업20080612<NA><NA><NA><NA><NA><NA>대구광역시 중구 동인동3가 356-1번지 사무실1층(지하작업장)대구광역시 중구 태평로 292 (동인동3가,사무실1층(지하작업장))<NA>(주)에스엘코리아20080613114333I2018-08-31 23:59:59.0<NA>345246.668018264832.097799사인,간판디자인 및 제작설치
번호개방서비스명개방서비스ID개방자치단체코드관리번호인허가일자인허가취소일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지면적소재지우편번호소재지전체주소도로명전체주소도로명우편번호사업장명최종수정시점데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
24442445옥외광고업04_15_01_P3480000200634800900820000220060404<NA>3폐업40폐업20061031<NA><NA><NA>053 7670062<NA><NA>대구광역시 달성군 가창면 용계리 233-13번지<NA><NA>주식회사 일류(제2공장)20080108171511I2018-08-31 23:59:59.0<NA><NA><NA>종합광고대행, 간판,실내인테리어 기획 시공
24452446옥외광고업04_15_01_P3480000200634800900820000420060608<NA>3폐업40폐업20080624<NA><NA><NA><NA><NA><NA>대구광역시 달성군 유가읍 금리 185-3번지<NA><NA>문애드20080703133031I2018-08-31 23:59:59.0<NA><NA><NA>옥외광고물 제작 설치
24462447옥외광고업04_15_01_P3480000200634800900820000520060615<NA>3폐업40폐업20080616<NA><NA><NA>6333857<NA><NA>대구광역시 달성군 화원읍 구라리 950번지대구광역시 달성군 화원읍 구라1길 49-36<NA>(주)하나디자인20080619190242I2018-08-31 23:59:59.0<NA>334360.317825257914.054094옥외광고물 제작.설치
24472448옥외광고업04_15_01_P3480000200634800900820000620060616<NA>3폐업40폐업20060905<NA><NA><NA>053 6141223<NA><NA>대구광역시 달성군 논공읍 남리 1142-9번지대구광역시 달성군 논공읍 논공로 790<NA>세진광고기획20060616000000I2018-08-31 23:59:59.0<NA>330284.058097248568.014606옥외광고물 제작 설치
24482449옥외광고업04_15_01_P3480000201434803240850000320140714<NA>3폐업40폐업20180806<NA><NA><NA>0536161185<NA><NA><NA>대구광역시 달성군 옥포면 옥계길 70-10711845(주) 한국조경산업20180808095152I2018-08-31 23:59:59.0<NA>331772.546074255983.538134옥외광고물 제작 설치
24492450옥외광고업04_15_01_P3480000201434803240850000420141029<NA>3폐업40폐업20141111<NA><NA><NA><NA><NA><NA>대구광역시 달성군 다사읍 매곡리 1522-14번지대구광역시 달성군 다사읍 대실역북로5길 54-3711812예나20141111130548I2018-08-31 23:59:59.0<NA>332293.610446263797.802367옥외전광판
24502451옥외광고업04_15_01_P3480000201734802770850000120161014<NA>3폐업40폐업20180111<NA><NA><NA>053 611 5612<NA><NA>대구광역시 달성군 유가읍 금리 1149번지대구광역시 달성군 유가면 테크노중앙대로1길 38-16, 1층43024디자인1번가20180111160424I2018-08-31 23:59:59.0<NA>331630.0242553.0옥내·외 광고물 기획 및 제작, 디자인 기획
24512452옥외광고업04_15_01_P3480000200734800900820000120070205<NA>3폐업40폐업20080619<NA><NA><NA>053 6113600<NA><NA>대구광역시 달성군 논공읍 금포리 944-2번지대구광역시 달성군 논공읍 비슬로 1887<NA>포앰테크20080619185934I2018-08-31 23:59:59.0<NA>329214.669612254222.034897옥외광고물 제작.설치
24522453옥외광고업04_15_01_P3480000200734802870850000120071106<NA>3폐업40폐업20091103<NA><NA><NA><NA><NA><NA>대구광역시 달성군 가창면 용계리 233-13번지대구광역시 달성군 가창면 가창로213길 16711860주식회사 지애드20111031085036I2018-08-31 23:59:59.0<NA>346498.887536256644.6839옥외 광고물 제작 및 시공, 스크린 인쇄
24532454옥외광고업04_15_01_P3480000200934802870850000320170228<NA>3폐업40폐업20191125<NA><NA><NA>053 631 6400<NA><NA>대구광역시 달성군 화원읍 천내리 100-4번지대구광역시 달성군 화원읍 성천로 114, 매일광고 2층42948매일광고20191125094924U2019-11-27 02:40:00.0<NA>334966.101483257238.945915광고물제작, 설치