Overview

Dataset statistics

Number of variables29
Number of observations2562
Missing cells19681
Missing cells (%)26.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory625.6 KiB
Average record size in memory250.1 B

Variable types

Numeric12
Categorical7
Unsupported4
Text5
DateTime1

Dataset

Description22년02월_6270000_대구광역시_04_15_01_P_옥외광고업
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=DMI_0000092609&dataSetDetailId=DDI_0000092637&provdMethod=FILE

Alerts

개방서비스명 has constant value ""Constant
개방서비스아이디 has constant value ""Constant
상세영업상태명 is highly imbalanced (58.8%)Imbalance
재개업일자 is highly imbalanced (99.0%)Imbalance
인허가취소일자 has 2562 (100.0%) missing valuesMissing
폐업일자 has 962 (37.5%) missing valuesMissing
휴업시작일자 has 2520 (98.4%) missing valuesMissing
휴업종료일자 has 2520 (98.4%) missing valuesMissing
소재지전화 has 693 (27.0%) missing valuesMissing
소재지면적 has 2562 (100.0%) missing valuesMissing
소재지우편번호 has 2562 (100.0%) missing valuesMissing
소재지전체주소 has 50 (2.0%) missing valuesMissing
도로명전체주소 has 517 (20.2%) missing valuesMissing
도로명우편번호 has 1214 (47.4%) missing valuesMissing
업태구분명 has 2562 (100.0%) missing valuesMissing
좌표정보(X) has 445 (17.4%) missing valuesMissing
좌표정보(Y) has 445 (17.4%) missing valuesMissing
영업내용 has 67 (2.6%) 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 19:16:41.369746
Analysis finished2023-12-10 19:16:42.611958
Duration1.24 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct2562
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1281.5
Minimum1
Maximum2562
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:42.687556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile129.05
Q1641.25
median1281.5
Q31921.75
95-th percentile2433.95
Maximum2562
Range2561
Interquartile range (IQR)1280.5

Descriptive statistics

Standard deviation739.73002
Coefficient of variation (CV)0.57723763
Kurtosis-1.2
Mean1281.5
Median Absolute Deviation (MAD)640.5
Skewness0
Sum3283203
Variance547200.5
MonotonicityStrictly increasing
2023-12-11T04:16:42.839628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1923 1
 
< 0.1%
1705 1
 
< 0.1%
1706 1
 
< 0.1%
1707 1
 
< 0.1%
1708 1
 
< 0.1%
1709 1
 
< 0.1%
1710 1
 
< 0.1%
1711 1
 
< 0.1%
1712 1
 
< 0.1%
Other values (2552) 2552
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 (%)
2562 1
< 0.1%
2561 1
< 0.1%
2560 1
< 0.1%
2559 1
< 0.1%
2558 1
< 0.1%
2557 1
< 0.1%
2556 1
< 0.1%
2555 1
< 0.1%
2554 1
< 0.1%
2553 1
< 0.1%

개방서비스명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
옥외광고업
2562 

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

Length

2023-12-11T04:16:42.973964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:43.073681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
옥외광고업 2562
100.0%

개방서비스아이디
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
04_15_01_P
2562 

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

Length

2023-12-11T04:16:43.169334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:43.272963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
04_15_01_p 2562
100.0%

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

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3442806.4
Minimum3410000
Maximum3480000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:43.367587image/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 deviation21398.964
Coefficient of variation (CV)0.0062155582
Kurtosis-1.2613966
Mean3442806.4
Median Absolute Deviation (MAD)20000
Skewness-0.048135253
Sum8.82047 × 109
Variance4.5791565 × 108
MonotonicityIncreasing
2023-12-11T04:16:43.505090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3460000 407
15.9%
3470000 400
15.6%
3420000 365
14.2%
3450000 357
13.9%
3430000 341
13.3%
3410000 327
12.8%
3440000 265
10.3%
3480000 100
 
3.9%
ValueCountFrequency (%)
3410000 327
12.8%
3420000 365
14.2%
3430000 341
13.3%
3440000 265
10.3%
3450000 357
13.9%
3460000 407
15.9%
3470000 400
15.6%
3480000 100
 
3.9%
ValueCountFrequency (%)
3480000 100
 
3.9%
3470000 400
15.6%
3460000 407
15.9%
3450000 357
13.9%
3440000 265
10.3%
3430000 341
13.3%
3420000 365
14.2%
3410000 327
12.8%

관리번호
Real number (ℝ)

Distinct2558
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0048689 × 1018
Minimum1.985345 × 1018
Maximum2.022348 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:43.643627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.985345 × 1018
5-th percentile1.991344 × 1018
Q11.999343 × 1018
median2.003343 × 1018
Q32.012341 × 1018
95-th percentile2.020342 × 1018
Maximum2.022348 × 1018
Range3.7003032 × 1016
Interquartile range (IQR)1.2998007 × 1016

Descriptive statistics

Standard deviation8.571591 × 1015
Coefficient of variation (CV)0.0042753873
Kurtosis-0.84457837
Mean2.0048689 × 1018
Median Absolute Deviation (MAD)5.9980034 × 1015
Skewness0.27176749
Sum8.2792101 × 1018
Variance7.3472173 × 1031
MonotonicityNot monotonic
2023-12-11T04:16:43.831538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2008341004708500001 3
 
0.1%
2006348009008200005 2
 
0.1%
2002345006108200003 2
 
0.1%
2019341012708500003 1
 
< 0.1%
2001346005708200025 1
 
< 0.1%
2001346005708200026 1
 
< 0.1%
2001346005708200027 1
 
< 0.1%
2001346005708200028 1
 
< 0.1%
2001346005708200030 1
 
< 0.1%
2001346005708200031 1
 
< 0.1%
Other values (2548) 2548
99.5%
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 (%)
2022348032408500001 1
< 0.1%
2022344012708500001 1
< 0.1%
2022343009708500003 1
< 0.1%
2022343009708500002 1
< 0.1%
2022343009708500001 1
< 0.1%
2022342017808500001 1
< 0.1%
2022341015308500001 1
< 0.1%
2021348032408500009 1
< 0.1%
2021348032408500008 1
< 0.1%
2021348032408500007 1
< 0.1%

인허가일자
Real number (ℝ)

Distinct1897
Distinct (%)74.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20053872
Minimum19850408
Maximum20220228
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:44.067422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19850408
5-th percentile19910507
Q119990709
median20040210
Q320130704
95-th percentile20200509
Maximum20220228
Range369820
Interquartile range (IQR)139994.5

Descriptive statistics

Standard deviation88057.947
Coefficient of variation (CV)0.0043910696
Kurtosis-0.96930511
Mean20053872
Median Absolute Deviation (MAD)60506.5
Skewness0.12986231
Sum5.137802 × 1010
Variance7.754202 × 109
MonotonicityNot monotonic
2023-12-11T04:16:44.478478image/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%
20210526 6
 
0.2%
20000607 6
 
0.2%
20000428 6
 
0.2%
20081104 5
 
0.2%
20010910 5
 
0.2%
20020111 5
 
0.2%
19910715 5
 
0.2%
Other values (1887) 2463
96.1%
ValueCountFrequency (%)
19850408 1
 
< 0.1%
19850701 3
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%
19880708 1
 
< 0.1%
19890119 1
 
< 0.1%
ValueCountFrequency (%)
20220228 1
< 0.1%
20220221 1
< 0.1%
20220216 2
0.1%
20220110 1
< 0.1%
20211220 1
< 0.1%
20211213 2
0.1%
20211208 1
< 0.1%
20211130 2
0.1%
20211124 1
< 0.1%
20211110 1
< 0.1%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2562
Missing (%)100.0%
Memory size22.6 KiB
Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
3
1695 
1
832 
2
 
22
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 1695
66.2%
1 832
32.5%
2 22
 
0.9%
4 13
 
0.5%

Length

2023-12-11T04:16:44.636915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:44.755108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 1695
66.2%
1 832
32.5%
2 22
 
0.9%
4 13
 
0.5%

영업상태명
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
폐업
1695 
영업/정상
832 
휴업
 
22
취소/말소/만료/정지/중지
 
13

Length

Max length14
Median length2
Mean length3.0351288
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 1695
66.2%
영업/정상 832
32.5%
휴업 22
 
0.9%
취소/말소/만료/정지/중지 13
 
0.5%

Length

2023-12-11T04:16:44.882416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:44.997758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 1695
66.2%
영업/정상 832
32.5%
휴업 22
 
0.9%
취소/말소/만료/정지/중지 13
 
0.5%

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

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32.622951
Minimum1
Maximum71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:45.115540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation11.739456
Coefficient of variation (CV)0.35985267
Kurtosis0.67425739
Mean32.622951
Median Absolute Deviation (MAD)0
Skewness-0.99676866
Sum83580
Variance137.81483
MonotonicityNot monotonic
2023-12-11T04:16:45.267912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
40 1695
66.2%
20 700
27.3%
1 129
 
5.0%
30 22
 
0.9%
70 12
 
0.5%
10 2
 
0.1%
71 1
 
< 0.1%
60 1
 
< 0.1%
ValueCountFrequency (%)
1 129
 
5.0%
10 2
 
0.1%
20 700
27.3%
30 22
 
0.9%
40 1695
66.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 1695
66.2%
30 22
 
0.9%
20 700
27.3%
10 2
 
0.1%
1 129
 
5.0%

상세영업상태명
Categorical

IMBALANCE 

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
폐업
1695 
정상
700 
<NA>
 
129
휴업
 
22
취소
 
12
Other values (3)
 
4

Length

Max length8
Median length2
Mean length2.1053864
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 1695
66.2%
정상 700
27.3%
<NA> 129
 
5.0%
휴업 22
 
0.9%
취소 12
 
0.5%
설립신청 2
 
0.1%
신청취소(취하) 1
 
< 0.1%
부분가동 1
 
< 0.1%

Length

2023-12-11T04:16:45.461293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:45.604907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 1695
66.2%
정상 700
27.3%
na 129
 
5.0%
휴업 22
 
0.9%
취소 12
 
0.5%
설립신청 2
 
0.1%
신청취소(취하 1
 
< 0.1%
부분가동 1
 
< 0.1%

폐업일자
Real number (ℝ)

MISSING 

Distinct994
Distinct (%)62.1%
Missing962
Missing (%)37.5%
Infinite0
Infinite (%)0.0%
Mean20098920
Minimum19910107
Maximum20220210
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:45.794065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19910107
5-th percentile20010523
Q120051212
median20081214
Q320150916
95-th percentile20210607
Maximum20220210
Range310103
Interquartile range (IQR)99704.5

Descriptive statistics

Standard deviation64809.931
Coefficient of variation (CV)0.0032245479
Kurtosis-0.79370934
Mean20098920
Median Absolute Deviation (MAD)49589.5
Skewness0.18733381
Sum3.2158273 × 1010
Variance4.2003271 × 109
MonotonicityNot monotonic
2023-12-11T04:16:45.966398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20051212 55
 
2.1%
20060817 28
 
1.1%
20061109 25
 
1.0%
20060306 21
 
0.8%
20091217 19
 
0.7%
20080819 14
 
0.5%
20021022 13
 
0.5%
20061113 12
 
0.5%
20020312 12
 
0.5%
20060810 11
 
0.4%
Other values (984) 1390
54.3%
(Missing) 962
37.5%
ValueCountFrequency (%)
19910107 1
< 0.1%
19910312 1
< 0.1%
19911211 1
< 0.1%
19921227 1
< 0.1%
19930218 1
< 0.1%
19930426 1
< 0.1%
19930524 1
< 0.1%
19930723 1
< 0.1%
19930903 1
< 0.1%
19940105 1
< 0.1%
ValueCountFrequency (%)
20220210 1
< 0.1%
20220203 2
0.1%
20211231 1
< 0.1%
20211229 1
< 0.1%
20211210 1
< 0.1%
20211130 1
< 0.1%
20211110 1
< 0.1%
20211028 1
< 0.1%
20211027 1
< 0.1%
20211015 2
0.1%

휴업시작일자
Real number (ℝ)

MISSING 

Distinct39
Distinct (%)92.9%
Missing2520
Missing (%)98.4%
Infinite0
Infinite (%)0.0%
Mean20135752
Minimum20060904
Maximum20210831
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:46.131452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20060904
5-th percentile20061030
Q120090412
median20130924
Q320187883
95-th percentile20210796
Maximum20210831
Range149927
Interquartile range (IQR)97471

Descriptive statistics

Standard deviation52440.275
Coefficient of variation (CV)0.0026043366
Kurtosis-1.4619439
Mean20135752
Median Absolute Deviation (MAD)45263.5
Skewness0.11579457
Sum8.4570157 × 108
Variance2.7499824 × 109
MonotonicityNot monotonic
2023-12-11T04:16:46.304873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
20140730 2
 
0.1%
20210601 2
 
0.1%
20110929 2
 
0.1%
20190919 1
 
< 0.1%
20100219 1
 
< 0.1%
20091130 1
 
< 0.1%
20171010 1
 
< 0.1%
20080923 1
 
< 0.1%
20180628 1
 
< 0.1%
20090101 1
 
< 0.1%
Other values (29) 29
 
1.1%
(Missing) 2520
98.4%
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 (%)
20210831 1
< 0.1%
20210827 1
< 0.1%
20210806 1
< 0.1%
20210610 1
< 0.1%
20210601 2
0.1%
20210330 1
< 0.1%
20191116 1
< 0.1%
20191016 1
< 0.1%
20190919 1
< 0.1%
20190301 1
< 0.1%

휴업종료일자
Real number (ℝ)

MISSING 

Distinct36
Distinct (%)85.7%
Missing2520
Missing (%)98.4%
Infinite0
Infinite (%)0.0%
Mean23949389
Minimum20061030
Maximum99991231
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:46.451079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20061030
5-th percentile20071420
Q120100867
median20141231
Q320210733
95-th percentile20239836
Maximum99991231
Range79930201
Interquartile range (IQR)109865.5

Descriptive statistics

Standard deviation17209661
Coefficient of variation (CV)0.71858453
Kurtosis18.295864
Mean23949389
Median Absolute Deviation (MAD)41008.5
Skewness4.407463
Sum1.0058744 × 109
Variance2.9617242 × 1014
MonotonicityNot monotonic
2023-12-11T04:16:46.613621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
20141231 3
 
0.1%
20181231 3
 
0.1%
20120429 2
 
0.1%
99991231 2
 
0.1%
20100330 1
 
< 0.1%
20180409 1
 
< 0.1%
20100115 1
 
< 0.1%
20220531 1
 
< 0.1%
20101231 1
 
< 0.1%
20070314 1
 
< 0.1%
Other values (26) 26
 
1.0%
(Missing) 2520
98.4%
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 2
0.1%
20240826 1
< 0.1%
20221021 1
< 0.1%
20220805 1
< 0.1%
20220531 1
< 0.1%
20220330 1
< 0.1%
20211209 1
< 0.1%
20211116 1
< 0.1%
20211016 1
< 0.1%
20210901 1
< 0.1%

재개업일자
Categorical

IMBALANCE 

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

Length

Max length8
Median length4
Mean length4.0078064
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> 2557
99.8%
20141008 2
 
0.1%
20121121 1
 
< 0.1%
20100503 1
 
< 0.1%
20181228 1
 
< 0.1%

Length

2023-12-11T04:16:46.804551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:46.939748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 2557
99.8%
20141008 2
 
0.1%
20121121 1
 
< 0.1%
20100503 1
 
< 0.1%
20181228 1
 
< 0.1%

소재지전화
Text

MISSING 

Distinct1648
Distinct (%)88.2%
Missing693
Missing (%)27.0%
Memory size20.1 KiB
2023-12-11T04:16:47.261008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length10.99572
Min length3

Characters and Unicode

Total characters20551
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 (%)78.0%

Sample

1st row0534262131
2nd row053 2542666
3rd row053 4237504
4th row0534250770
5th row053 16680611
ValueCountFrequency (%)
053 1585
38.7%
768 12
 
0.3%
383 9
 
0.2%
744 9
 
0.2%
764 9
 
0.2%
621 9
 
0.2%
563 9
 
0.2%
765 9
 
0.2%
654 8
 
0.2%
354 8
 
0.2%
Other values (1817) 2433
59.3%
2023-12-11T04:16:47.795781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 3669
17.9%
3 3032
14.8%
0 2802
13.6%
2249
10.9%
6 1521
7.4%
2 1487
7.2%
4 1434
 
7.0%
7 1220
 
5.9%
1 1199
 
5.8%
8 990
 
4.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 18302
89.1%
Space Separator 2249
 
10.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 3669
20.0%
3 3032
16.6%
0 2802
15.3%
6 1521
8.3%
2 1487
8.1%
4 1434
 
7.8%
7 1220
 
6.7%
1 1199
 
6.6%
8 990
 
5.4%
9 948
 
5.2%
Space Separator
ValueCountFrequency (%)
2249
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 20551
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 3669
17.9%
3 3032
14.8%
0 2802
13.6%
2249
10.9%
6 1521
7.4%
2 1487
7.2%
4 1434
 
7.0%
7 1220
 
5.9%
1 1199
 
5.8%
8 990
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 20551
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 3669
17.9%
3 3032
14.8%
0 2802
13.6%
2249
10.9%
6 1521
7.4%
2 1487
7.2%
4 1434
 
7.0%
7 1220
 
5.9%
1 1199
 
5.8%
8 990
 
4.8%

소재지면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2562
Missing (%)100.0%
Memory size22.6 KiB

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2562
Missing (%)100.0%
Memory size22.6 KiB

소재지전체주소
Text

MISSING 

Distinct882
Distinct (%)35.1%
Missing50
Missing (%)2.0%
Memory size20.1 KiB
2023-12-11T04:16:48.191938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length40
Mean length22.339968
Min length13

Characters and Unicode

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

Unique

Unique517 ?
Unique (%)20.6%

Sample

1st row대구광역시 중구 동인동*가 **-*
2nd row대구광역시 중구 종로*가 **-*
3rd row대구광역시 중구 남산동 ***-**번지
4th row대구광역시 중구 삼덕동*가 ***-*번지
5th row대구광역시 중구 삼덕동*가 ***-*
ValueCountFrequency (%)
대구광역시 2502
23.7%
번지 2039
19.3%
554
 
5.2%
달서구 400
 
3.8%
수성구 382
 
3.6%
동구 358
 
3.4%
북구 354
 
3.4%
서구 335
 
3.2%
중구 318
 
3.0%
남구 255
 
2.4%
Other values (339) 3062
29.0%
2023-12-11T04:16:48.803494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 11701
20.9%
10615
18.9%
4935
8.8%
2899
 
5.2%
2822
 
5.0%
2536
 
4.5%
2509
 
4.5%
2504
 
4.5%
- 2202
 
3.9%
2119
 
3.8%
Other values (259) 11276
20.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 31548
56.2%
Other Punctuation 11706
 
20.9%
Space Separator 10615
 
18.9%
Dash Punctuation 2202
 
3.9%
Uppercase Letter 27
 
< 0.1%
Close Punctuation 9
 
< 0.1%
Open Punctuation 8
 
< 0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
4935
15.6%
2899
 
9.2%
2822
 
8.9%
2536
 
8.0%
2509
 
8.0%
2504
 
7.9%
2119
 
6.7%
2039
 
6.5%
775
 
2.5%
632
 
2.0%
Other values (235) 7778
24.7%
Uppercase Letter
ValueCountFrequency (%)
B 10
37.0%
A 4
 
14.8%
C 3
 
11.1%
M 2
 
7.4%
J 1
 
3.7%
F 1
 
3.7%
T 1
 
3.7%
P 1
 
3.7%
W 1
 
3.7%
S 1
 
3.7%
Other values (2) 2
 
7.4%
Other Punctuation
ValueCountFrequency (%)
* 11701
> 99.9%
, 3
 
< 0.1%
. 1
 
< 0.1%
/ 1
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 8
88.9%
] 1
 
11.1%
Math Symbol
ValueCountFrequency (%)
> 1
50.0%
< 1
50.0%
Space Separator
ValueCountFrequency (%)
10615
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2202
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 31548
56.2%
Common 24542
43.7%
Latin 28
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
4935
15.6%
2899
 
9.2%
2822
 
8.9%
2536
 
8.0%
2509
 
8.0%
2504
 
7.9%
2119
 
6.7%
2039
 
6.5%
775
 
2.5%
632
 
2.0%
Other values (235) 7778
24.7%
Latin
ValueCountFrequency (%)
B 10
35.7%
A 4
 
14.3%
C 3
 
10.7%
M 2
 
7.1%
J 1
 
3.6%
F 1
 
3.6%
T 1
 
3.6%
P 1
 
3.6%
W 1
 
3.6%
S 1
 
3.6%
Other values (3) 3
 
10.7%
Common
ValueCountFrequency (%)
* 11701
47.7%
10615
43.3%
- 2202
 
9.0%
( 8
 
< 0.1%
) 8
 
< 0.1%
, 3
 
< 0.1%
] 1
 
< 0.1%
. 1
 
< 0.1%
> 1
 
< 0.1%
< 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 31548
56.2%
ASCII 24570
43.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 11701
47.6%
10615
43.2%
- 2202
 
9.0%
B 10
 
< 0.1%
( 8
 
< 0.1%
) 8
 
< 0.1%
A 4
 
< 0.1%
, 3
 
< 0.1%
C 3
 
< 0.1%
M 2
 
< 0.1%
Other values (14) 14
 
0.1%
Hangul
ValueCountFrequency (%)
4935
15.6%
2899
 
9.2%
2822
 
8.9%
2536
 
8.0%
2509
 
8.0%
2504
 
7.9%
2119
 
6.7%
2039
 
6.5%
775
 
2.5%
632
 
2.0%
Other values (235) 7778
24.7%

도로명전체주소
Text

MISSING 

Distinct1463
Distinct (%)71.5%
Missing517
Missing (%)20.2%
Memory size20.1 KiB
2023-12-11T04:16:49.257119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length48
Mean length25.879218
Min length19

Characters and Unicode

Total characters52923
Distinct characters334
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

Unique1140 ?
Unique (%)55.7%

Sample

1st row대구광역시 중구 국채보상로***길 *, *층 (동인동*가)
2nd row대구광역시 중구 *·**길 ** (남산동)
3rd row대구광역시 중구 종로 **-*, *층 ****호 (종로*가)
4th row대구광역시 중구 명륜로*길 *-** (남산동)
5th row대구광역시 중구 달구벌대로***길 ** (삼덕동*가)
ValueCountFrequency (%)
2049
19.1%
대구광역시 2045
19.0%
달서구 383
 
3.6%
수성구 317
 
3.0%
동구 277
 
2.6%
북구 252
 
2.3%
남구 247
 
2.3%
중구 245
 
2.3%
서구 240
 
2.2%
대명동 174
 
1.6%
Other values (862) 4508
42.0%
2023-12-11T04:16:50.000464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9255
17.5%
* 7852
14.8%
4204
 
7.9%
2669
 
5.0%
2620
 
5.0%
2083
 
3.9%
2064
 
3.9%
2048
 
3.9%
( 1978
 
3.7%
) 1978
 
3.7%
Other values (324) 16172
30.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 30951
58.5%
Space Separator 9255
 
17.5%
Other Punctuation 8274
 
15.6%
Open Punctuation 1978
 
3.7%
Close Punctuation 1978
 
3.7%
Dash Punctuation 451
 
0.9%
Uppercase Letter 33
 
0.1%
Math Symbol 2
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
4204
 
13.6%
2669
 
8.6%
2620
 
8.5%
2083
 
6.7%
2064
 
6.7%
2048
 
6.6%
1959
 
6.3%
971
 
3.1%
794
 
2.6%
659
 
2.1%
Other values (299) 10880
35.2%
Uppercase Letter
ValueCountFrequency (%)
A 7
21.2%
B 7
21.2%
M 3
9.1%
F 2
 
6.1%
S 2
 
6.1%
C 2
 
6.1%
D 2
 
6.1%
J 2
 
6.1%
P 1
 
3.0%
E 1
 
3.0%
Other values (4) 4
12.1%
Other Punctuation
ValueCountFrequency (%)
* 7852
94.9%
, 418
 
5.1%
· 3
 
< 0.1%
. 1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
> 1
50.0%
< 1
50.0%
Space Separator
ValueCountFrequency (%)
9255
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1978
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1978
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 451
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 30951
58.5%
Common 21938
41.5%
Latin 34
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
4204
 
13.6%
2669
 
8.6%
2620
 
8.5%
2083
 
6.7%
2064
 
6.7%
2048
 
6.6%
1959
 
6.3%
971
 
3.1%
794
 
2.6%
659
 
2.1%
Other values (299) 10880
35.2%
Latin
ValueCountFrequency (%)
A 7
20.6%
B 7
20.6%
M 3
8.8%
F 2
 
5.9%
S 2
 
5.9%
C 2
 
5.9%
D 2
 
5.9%
J 2
 
5.9%
c 1
 
2.9%
P 1
 
2.9%
Other values (5) 5
14.7%
Common
ValueCountFrequency (%)
9255
42.2%
* 7852
35.8%
( 1978
 
9.0%
) 1978
 
9.0%
- 451
 
2.1%
, 418
 
1.9%
· 3
 
< 0.1%
. 1
 
< 0.1%
> 1
 
< 0.1%
< 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 30951
58.5%
ASCII 21969
41.5%
None 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9255
42.1%
* 7852
35.7%
( 1978
 
9.0%
) 1978
 
9.0%
- 451
 
2.1%
, 418
 
1.9%
A 7
 
< 0.1%
B 7
 
< 0.1%
M 3
 
< 0.1%
F 2
 
< 0.1%
Other values (14) 18
 
0.1%
Hangul
ValueCountFrequency (%)
4204
 
13.6%
2669
 
8.6%
2620
 
8.5%
2083
 
6.7%
2064
 
6.7%
2048
 
6.6%
1959
 
6.3%
971
 
3.1%
794
 
2.6%
659
 
2.1%
Other values (299) 10880
35.2%
None
ValueCountFrequency (%)
· 3
100.0%

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

MISSING 

Distinct714
Distinct (%)53.0%
Missing1214
Missing (%)47.4%
Infinite0
Infinite (%)0.0%
Mean271935.27
Minimum41007
Maximum711882
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:50.192334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum41007
5-th percentile41169.7
Q141934
median42260
Q3704060
95-th percentile704951.25
Maximum711882
Range670875
Interquartile range (IQR)662126

Descriptive statistics

Standard deviation315420.18
Coefficient of variation (CV)1.159909
Kurtosis-1.5891479
Mean271935.27
Median Absolute Deviation (MAD)725.5
Skewness0.64275626
Sum3.6656875 × 108
Variance9.9489892 × 1010
MonotonicityNot monotonic
2023-12-11T04:16:50.380093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
704080 21
 
0.8%
704932 19
 
0.7%
704060 13
 
0.5%
704817 11
 
0.4%
42134 9
 
0.4%
704825 9
 
0.4%
42162 8
 
0.3%
42216 8
 
0.3%
704823 8
 
0.3%
704953 8
 
0.3%
Other values (704) 1234
48.2%
(Missing) 1214
47.4%
ValueCountFrequency (%)
41007 1
< 0.1%
41019 2
0.1%
41026 1
< 0.1%
41028 2
0.1%
41030 1
< 0.1%
41033 1
< 0.1%
41036 1
< 0.1%
41046 1
< 0.1%
41055 2
0.1%
41056 1
< 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%
Distinct2041
Distinct (%)79.7%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
2023-12-11T04:16:50.789110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length21
Mean length5.6491023
Min length2

Characters and Unicode

Total characters14473
Distinct characters523
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

Unique1653 ?
Unique (%)64.5%

Sample

1st row디오컴퍼니
2nd row위드애드
3rd row오류(이중등록)
4th rowKS애드
5th row애플사인
ValueCountFrequency (%)
주식회사 61
 
2.2%
디자인 33
 
1.2%
광고회사 12
 
0.4%
광고기획 10
 
0.4%
애드 8
 
0.3%
하나광고 7
 
0.2%
기획 6
 
0.2%
6
 
0.2%
현대광고사 6
 
0.2%
factory 6
 
0.2%
Other values (2089) 2656
94.5%
2023-12-11T04:16:51.506243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1097
 
7.6%
1045
 
7.2%
655
 
4.5%
435
 
3.0%
429
 
3.0%
) 377
 
2.6%
( 373
 
2.6%
370
 
2.6%
346
 
2.4%
324
 
2.2%
Other values (513) 9022
62.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13061
90.2%
Close Punctuation 377
 
2.6%
Open Punctuation 373
 
2.6%
Uppercase Letter 284
 
2.0%
Space Separator 249
 
1.7%
Decimal Number 54
 
0.4%
Other Punctuation 36
 
0.2%
Lowercase Letter 34
 
0.2%
Dash Punctuation 4
 
< 0.1%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1097
 
8.4%
1045
 
8.0%
655
 
5.0%
435
 
3.3%
429
 
3.3%
370
 
2.8%
346
 
2.6%
324
 
2.5%
296
 
2.3%
268
 
2.1%
Other values (453) 7796
59.7%
Uppercase Letter
ValueCountFrequency (%)
S 25
 
8.8%
D 25
 
8.8%
C 22
 
7.7%
A 20
 
7.0%
N 19
 
6.7%
O 18
 
6.3%
M 17
 
6.0%
E 16
 
5.6%
I 14
 
4.9%
L 14
 
4.9%
Other values (14) 94
33.1%
Lowercase Letter
ValueCountFrequency (%)
e 5
14.7%
i 4
11.8%
n 4
11.8%
s 4
11.8%
g 3
8.8%
b 2
 
5.9%
o 2
 
5.9%
a 2
 
5.9%
x 1
 
2.9%
l 1
 
2.9%
Other values (6) 6
17.6%
Decimal Number
ValueCountFrequency (%)
1 12
22.2%
2 11
20.4%
3 10
18.5%
0 9
16.7%
7 4
 
7.4%
5 4
 
7.4%
4 2
 
3.7%
8 1
 
1.9%
6 1
 
1.9%
Other Punctuation
ValueCountFrequency (%)
. 17
47.2%
& 13
36.1%
, 2
 
5.6%
" 2
 
5.6%
· 1
 
2.8%
/ 1
 
2.8%
Close Punctuation
ValueCountFrequency (%)
) 377
100.0%
Open Punctuation
ValueCountFrequency (%)
( 373
100.0%
Space Separator
ValueCountFrequency (%)
249
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13061
90.2%
Common 1094
 
7.6%
Latin 318
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1097
 
8.4%
1045
 
8.0%
655
 
5.0%
435
 
3.3%
429
 
3.3%
370
 
2.8%
346
 
2.6%
324
 
2.5%
296
 
2.3%
268
 
2.1%
Other values (453) 7796
59.7%
Latin
ValueCountFrequency (%)
S 25
 
7.9%
D 25
 
7.9%
C 22
 
6.9%
A 20
 
6.3%
N 19
 
6.0%
O 18
 
5.7%
M 17
 
5.3%
E 16
 
5.0%
I 14
 
4.4%
L 14
 
4.4%
Other values (30) 128
40.3%
Common
ValueCountFrequency (%)
) 377
34.5%
( 373
34.1%
249
22.8%
. 17
 
1.6%
& 13
 
1.2%
1 12
 
1.1%
2 11
 
1.0%
3 10
 
0.9%
0 9
 
0.8%
7 4
 
0.4%
Other values (10) 19
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13061
90.2%
ASCII 1411
 
9.7%
None 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1097
 
8.4%
1045
 
8.0%
655
 
5.0%
435
 
3.3%
429
 
3.3%
370
 
2.8%
346
 
2.6%
324
 
2.5%
296
 
2.3%
268
 
2.1%
Other values (453) 7796
59.7%
ASCII
ValueCountFrequency (%)
) 377
26.7%
( 373
26.4%
249
17.6%
S 25
 
1.8%
D 25
 
1.8%
C 22
 
1.6%
A 20
 
1.4%
N 19
 
1.3%
O 18
 
1.3%
. 17
 
1.2%
Other values (49) 266
18.9%
None
ValueCountFrequency (%)
· 1
100.0%

최종수정시점
Real number (ℝ)

Distinct2491
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0117769 × 1013
Minimum1.9850701 × 1013
Maximum2.0220228 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:51.737080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9850701 × 1013
5-th percentile1.9950506 × 1013
Q12.007121 × 1013
median2.0130725 × 1013
Q32.0190801 × 1013
95-th percentile2.0210818 × 1013
Maximum2.0220228 × 1013
Range3.695272 × 1011
Interquartile range (IQR)1.1959096 × 1011

Descriptive statistics

Standard deviation8.2249589 × 1010
Coefficient of variation (CV)0.0040884052
Kurtosis-0.039466214
Mean2.0117769 × 1013
Median Absolute Deviation (MAD)5.9603058 × 1010
Skewness-0.86896445
Sum5.1541723 × 1016
Variance6.7649949 × 1021
MonotonicityNot monotonic
2023-12-11T04:16:51.974564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19910415000000 21
 
0.8%
20000407000000 4
 
0.2%
20000129000000 3
 
0.1%
19910329000000 3
 
0.1%
20000428000000 3
 
0.1%
19910713000000 3
 
0.1%
20000406000000 3
 
0.1%
19980925000000 2
 
0.1%
19910406000000 2
 
0.1%
19930614000000 2
 
0.1%
Other values (2481) 2516
98.2%
ValueCountFrequency (%)
19850701000000 2
0.1%
19850903000000 1
 
< 0.1%
19870831000000 1
 
< 0.1%
19880708000000 1
 
< 0.1%
19900710000000 1
 
< 0.1%
19910320000000 1
 
< 0.1%
19910321000000 1
 
< 0.1%
19910325000000 1
 
< 0.1%
19910329000000 3
0.1%
19910406000000 2
0.1%
ValueCountFrequency (%)
20220228200231 1
< 0.1%
20220223175714 1
< 0.1%
20220221175946 1
< 0.1%
20220221091918 1
< 0.1%
20220221090928 1
< 0.1%
20220211161256 1
< 0.1%
20220211103439 1
< 0.1%
20220210173838 1
< 0.1%
20220210144952 1
< 0.1%
20220209162608 1
< 0.1%
Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
I
1895 
U
667 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 1895
74.0%
U 667
 
26.0%

Length

2023-12-11T04:16:52.190125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:16:52.307207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 1895
74.0%
u 667
 
26.0%
Distinct420
Distinct (%)16.4%
Missing0
Missing (%)0.0%
Memory size20.1 KiB
Minimum2018-08-31 23:59:59
Maximum2022-03-02 00:22:36
2023-12-11T04:16:52.467287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:16:52.701128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2562
Missing (%)100.0%
Memory size22.6 KiB

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

MISSING 

Distinct1847
Distinct (%)87.2%
Missing445
Missing (%)17.4%
Infinite0
Infinite (%)0.0%
Mean342796.9
Minimum204099.91
Maximum357984.66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:52.918528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum204099.91
5-th percentile334940.29
Q1340030.09
median343275.53
Q3345885.11
95-th percentile351528.05
Maximum357984.66
Range153884.75
Interquartile range (IQR)5855.0257

Descriptive statistics

Standard deviation6887.2763
Coefficient of variation (CV)0.020091419
Kurtosis112.52586
Mean342796.9
Median Absolute Deviation (MAD)2946.9574
Skewness-7.3942655
Sum7.2570104 × 108
Variance47434575
MonotonicityNot monotonic
2023-12-11T04:16:53.157379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
347600.95534 7
 
0.3%
348394.245106 6
 
0.2%
344912.358902 6
 
0.2%
345549.11017 6
 
0.2%
344686.259338 5
 
0.2%
347123.859769 5
 
0.2%
346678.067969 5
 
0.2%
334931.565205 4
 
0.2%
346957.505642 4
 
0.2%
345664.831537 3
 
0.1%
Other values (1837) 2066
80.6%
(Missing) 445
 
17.4%
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%
327646.719828 1
 
< 0.1%
328311.018298 1
 
< 0.1%
328432.256141 1
 
< 0.1%
328879.899023 1
 
< 0.1%
329214.669612 1
 
< 0.1%
ValueCountFrequency (%)
357984.664409 1
< 0.1%
357963.405909 1
< 0.1%
356811.019382137 1
< 0.1%
356668.763448 1
< 0.1%
356354.333857 1
< 0.1%
356326.175134 1
< 0.1%
356197.467672 1
< 0.1%
355963.682846 1
< 0.1%
355893.403451 1
< 0.1%
355540.646175 1
< 0.1%

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

MISSING 

Distinct1848
Distinct (%)87.3%
Missing445
Missing (%)17.4%
Infinite0
Infinite (%)0.0%
Mean263811.24
Minimum240194.04
Maximum448866.37
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.6 KiB
2023-12-11T04:16:53.841668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum240194.04
5-th percentile257933.11
Q1261402.59
median263415.29
Q3265322.29
95-th percentile269860.49
Maximum448866.37
Range208672.33
Interquartile range (IQR)3919.697

Descriptive statistics

Standard deviation8996.5419
Coefficient of variation (CV)0.034102194
Kurtosis192.73206
Mean263811.24
Median Absolute Deviation (MAD)1947.2
Skewness12.14375
Sum5.5848839 × 108
Variance80937767
MonotonicityNot monotonic
2023-12-11T04:16:54.092571image/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%
263958.880864 5
 
0.2%
264683.827139 5
 
0.2%
265183.718118 4
 
0.2%
259242.528512 4
 
0.2%
266578.115481 3
 
0.1%
Other values (1838) 2066
80.6%
(Missing) 445
 
17.4%
ValueCountFrequency (%)
240194.039275 1
< 0.1%
241425.48584 1
< 0.1%
242528.196096 2
0.1%
242553.0 1
< 0.1%
242610.962686 1
< 0.1%
243603.85282 1
< 0.1%
244175.0 1
< 0.1%
244203.0 1
< 0.1%
244223.605603 1
< 0.1%
244361.0 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%
275960.486486 1
 
< 0.1%
274749.657016 2
0.1%
274283.354392 1
 
< 0.1%
274032.68864 1
 
< 0.1%
274028.639393 1
 
< 0.1%

영업내용
Text

MISSING 

Distinct644
Distinct (%)25.8%
Missing67
Missing (%)2.6%
Memory size20.1 KiB
2023-12-11T04:16:54.564896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length37
Mean length9.0476954
Min length1

Characters and Unicode

Total characters22574
Distinct characters275
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

Unique486 ?
Unique (%)19.5%

Sample

1st row옥외광고물 제작 외
2nd row옥외광고물 제작
3rd row옥외광고업
4th row옥외광고업
5th row광고.간판
ValueCountFrequency (%)
제작 535
 
11.3%
광고물제작 462
 
9.7%
453
 
9.5%
옥외광고물제작 446
 
9.4%
옥외광고물 374
 
7.9%
옥외광고업 212
 
4.5%
설치 160
 
3.4%
대행 150
 
3.2%
광고대행 149
 
3.1%
광고물 137
 
2.9%
Other values (501) 1676
35.3%
2023-12-11T04:16:55.302851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2400
10.6%
2388
10.6%
2250
 
10.0%
2046
 
9.1%
1947
 
8.6%
1811
 
8.0%
1377
 
6.1%
1361
 
6.0%
, 538
 
2.4%
534
 
2.4%
Other values (265) 5922
26.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 19321
85.6%
Space Separator 2250
 
10.0%
Other Punctuation 675
 
3.0%
Open Punctuation 96
 
0.4%
Close Punctuation 95
 
0.4%
Uppercase Letter 50
 
0.2%
Decimal Number 49
 
0.2%
Dash Punctuation 26
 
0.1%
Control 10
 
< 0.1%
Math Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2400
12.4%
2388
12.4%
2046
10.6%
1947
10.1%
1811
 
9.4%
1377
 
7.1%
1361
 
7.0%
534
 
2.8%
415
 
2.1%
404
 
2.1%
Other values (234) 4638
24.0%
Decimal Number
ValueCountFrequency (%)
0 15
30.6%
2 8
16.3%
1 8
16.3%
6 4
 
8.2%
3 4
 
8.2%
4 4
 
8.2%
5 3
 
6.1%
8 2
 
4.1%
9 1
 
2.0%
Uppercase Letter
ValueCountFrequency (%)
D 13
26.0%
L 13
26.0%
E 13
26.0%
S 4
 
8.0%
P 4
 
8.0%
C 2
 
4.0%
N 1
 
2.0%
Other Punctuation
ValueCountFrequency (%)
, 538
79.7%
. 61
 
9.0%
: 44
 
6.5%
· 21
 
3.1%
/ 10
 
1.5%
1
 
0.1%
Open Punctuation
ValueCountFrequency (%)
( 95
99.0%
[ 1
 
1.0%
Close Punctuation
ValueCountFrequency (%)
) 94
98.9%
] 1
 
1.1%
Math Symbol
ValueCountFrequency (%)
> 1
50.0%
< 1
50.0%
Space Separator
ValueCountFrequency (%)
2250
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%
Control
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19321
85.6%
Common 3203
 
14.2%
Latin 50
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2400
12.4%
2388
12.4%
2046
10.6%
1947
10.1%
1811
 
9.4%
1377
 
7.1%
1361
 
7.0%
534
 
2.8%
415
 
2.1%
404
 
2.1%
Other values (234) 4638
24.0%
Common
ValueCountFrequency (%)
2250
70.2%
, 538
 
16.8%
( 95
 
3.0%
) 94
 
2.9%
. 61
 
1.9%
: 44
 
1.4%
- 26
 
0.8%
· 21
 
0.7%
0 15
 
0.5%
10
 
0.3%
Other values (14) 49
 
1.5%
Latin
ValueCountFrequency (%)
D 13
26.0%
L 13
26.0%
E 13
26.0%
S 4
 
8.0%
P 4
 
8.0%
C 2
 
4.0%
N 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19320
85.6%
ASCII 3231
 
14.3%
None 22
 
0.1%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2400
12.4%
2388
12.4%
2046
10.6%
1947
10.1%
1811
 
9.4%
1377
 
7.1%
1361
 
7.0%
534
 
2.8%
415
 
2.1%
404
 
2.1%
Other values (233) 4637
24.0%
ASCII
ValueCountFrequency (%)
2250
69.6%
, 538
 
16.7%
( 95
 
2.9%
) 94
 
2.9%
. 61
 
1.9%
: 44
 
1.4%
- 26
 
0.8%
0 15
 
0.5%
D 13
 
0.4%
L 13
 
0.4%
Other values (19) 82
 
2.5%
None
ValueCountFrequency (%)
· 21
95.5%
1
 
4.5%
Compat Jamo
ValueCountFrequency (%)
1
100.0%

Sample

번호개방서비스명개방서비스아이디개방자치단체코드관리번호인허가일자인허가취소일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지면적소재지우편번호소재지전체주소도로명전체주소도로명우편번호사업장명최종수정시점데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
01옥외광고업04_15_01_P3410000201934101270850000320191101<NA>3폐업40폐업20210901<NA><NA><NA><NA><NA><NA>대구광역시 중구 동인동*가 **-*대구광역시 중구 국채보상로***길 *, *층 (동인동*가)41908디오컴퍼니20210901160307U2021-09-03 02:40:00.0<NA>345206.903293264425.850417옥외광고물 제작 외
12옥외광고업04_15_01_P3410000201934101270850000220190513<NA>3폐업40폐업20210126<NA><NA><NA>0534262131<NA><NA><NA>대구광역시 중구 *·**길 ** (남산동)41968위드애드20210126114353U2021-01-28 02:40:00.0<NA>343516.478139263246.517147옥외광고물 제작
23옥외광고업04_15_01_P3410000202134101530850000720211130<NA>3폐업40폐업20211130<NA><NA><NA><NA><NA><NA>대구광역시 중구 종로*가 **-*대구광역시 중구 종로 **-*, *층 ****호 (종로*가)41934오류(이중등록)20211216132120U2021-12-18 02:40:00.0<NA>343614.806882264466.012002옥외광고업
34옥외광고업04_15_01_P3410000200534100160820000720050613<NA>3폐업40폐업20061031<NA><NA><NA>053 2542666<NA><NA>대구광역시 중구 남산동 ***-**번지대구광역시 중구 명륜로*길 *-** (남산동)<NA>KS애드20130725154925I2018-08-31 23:59:59.0<NA>343431.165823263706.433306옥외광고업
45옥외광고업04_15_01_P3410000199934100160820000219990130<NA>3폐업40폐업20090116<NA><NA><NA>053 4237504<NA><NA>대구광역시 중구 삼덕동*가 ***-*번지대구광역시 중구 달구벌대로***길 ** (삼덕동*가)<NA>애플사인20090116115833I2018-08-31 23:59:59.0<NA>345164.494458263868.961281광고.간판
56옥외광고업04_15_01_P3410000202034101530850000320200710<NA>3폐업40폐업20210924<NA><NA><NA>0534250770<NA><NA>대구광역시 중구 삼덕동*가 ***-*대구광역시 중구 동덕로**길 ***, *층 (삼덕동*가)41946로엠커뮤니케이션20210930082157U2021-10-02 02:40:00.0<NA>345346.5541264067.373164인쇄물 및 옥외광고업
67옥외광고업04_15_01_P3410000201834101270850001120181010<NA>3폐업40폐업20191220<NA><NA><NA>053 16680611<NA><NA>대구광역시 중구 대봉동 *-*번지대구광역시 중구 동덕로**길 **, *층 (대봉동)41951(주)드로우(draw)20191231172957U2020-01-02 02:40:00.0<NA>345068.561037263467.715128간판 및 광고물 작성
78옥외광고업04_15_01_P3410000200234100160820000620020411<NA>3폐업40폐업20080926<NA><NA><NA><NA><NA><NA>대구광역시 중구 동인동*가 ***-*번지<NA><NA>사인 MS20130725151135I2018-08-31 23:59:59.0<NA><NA><NA>간판제조
89옥외광고업04_15_01_P3410000200234100160820000720020515<NA>3폐업40폐업20061108<NA><NA><NA>053 2523456<NA><NA>대구광역시 중구 서문로*가 **-*번지<NA><NA>대신20130725154146I2018-08-31 23:59:59.0<NA><NA><NA>광고물 제작 및 설치
910옥외광고업04_15_01_P3410000200234100160820000820020909<NA>3폐업40폐업20060804<NA><NA><NA>005302566318<NA><NA>대구광역시 중구 삼덕동*가 ***-*번지<NA><NA>D&K 디자인20090810161122I2018-08-31 23:59:59.0<NA><NA><NA>간판, 실내인테리어
번호개방서비스명개방서비스아이디개방자치단체코드관리번호인허가일자인허가취소일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지면적소재지우편번호소재지전체주소도로명전체주소도로명우편번호사업장명최종수정시점데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)영업내용
25522553옥외광고업04_15_01_P3480000200734802870850000120071106<NA>3폐업40폐업20091103<NA><NA><NA><NA><NA><NA>대구광역시 달성군 가창면 용계리 ***-**번지대구광역시 달성군 가창면 가창로***길 **711860주식회사 지애드20111031085036I2018-08-31 23:59:59.0<NA>346498.887536256644.6839옥외 광고물 제작 및 시공, 스크린 인쇄
25532554옥외광고업04_15_01_P3480000200934802870850000320170228<NA>3폐업40폐업20191125<NA><NA><NA>053 631 6400<NA><NA>대구광역시 달성군 화원읍 천내리 ***-*번지대구광역시 달성군 화원읍 성천로 ***, 매일광고 *층42948매일광고20191125094924U2019-11-27 02:40:00.0<NA>334966.101483257238.945915광고물제작, 설치
25542555옥외광고업04_15_01_P3480000201034802870850000120100412<NA>3폐업40폐업20180824<NA><NA><NA>0536110454<NA><NA>대구광역시 달성군 논공읍 금포리 ****-*번지대구광역시 달성군 논공읍 비슬로***길 **42975보은광고기획20180824171107I2018-08-31 23:59:59.0<NA>328311.018298252940.836113옥외광고물 제작 광고대행, 광고물 유지보수
25552556옥외광고업04_15_01_P3480000201034802870850000320101215<NA>3폐업40폐업20121030<NA><NA><NA>053 641 9075<NA><NA>대구광역시 달성군 화원읍 설화리 ***-*번지대구광역시 달성군 화원읍 설화본길 **<NA>이조기획20121105133320I2018-08-31 23:59:59.0<NA>334151.075175255867.065665옥외광고물제작
25562557옥외광고업04_15_01_P3480000201134802870850000120111118<NA>3폐업40폐업20191203<NA><NA><NA>053 270 9880<NA><NA>대구광역시 달성군 화원읍 천내리 ***-*번지대구광역시 달성군 화원읍 사문진로 ***-*711834엘이디샵20191203100707U2019-12-05 02:40:00.0<NA>334962.37345257180.630289LED 경관조명 및 간판
25572558옥외광고업04_15_01_P3480000201234802870850000120120924<NA>3폐업40폐업20150826<NA><NA><NA>0535849436<NA><NA>대구광역시 달성군 다사읍 세천리 ****-*번지대구광역시 달성군 다사읍 세천로*길 **<NA>태왕기업20150827152537I2018-08-31 23:59:59.0<NA>332854.487916264528.243046옥외광고 외 전기공사
25582559옥외광고업04_15_01_P3480000201734802770850000320170322<NA>3폐업40폐업20191125<NA><NA><NA><NA><NA><NA>대구광역시 달성군 현풍읍 중리 ***번지 그래피티기획대구광역시 달성군 현풍면 테크노대로 **, *층 (그래피티기획)43020그래피티기획20191125130350U2019-11-27 02:40:00.0<NA>331142.0244175.0옥외광고물 제작 설치, 광고 대행
25592560옥외광고업04_15_01_P3480000201734802770850000420170419<NA>3폐업40폐업20191031<NA><NA><NA><NA><NA><NA>대구광역시 달성군 다사읍 매곡리 ****-**번지대구광역시 달성군 다사읍 대실역북로*길 **-*, ***호 (그린하이츠)42911예나20191104093707U2019-11-06 02:40:00.0<NA>332293.610446263797.802367옥외전광판
25602561옥외광고업04_15_01_P3480000201834802770850000120180214<NA>3폐업40폐업20200203<NA><NA><NA><NA><NA><NA>대구광역시 달성군 화원읍 천내리 ***번지대구광역시 달성군 화원읍 성천로**길 **, *층42954나무향기20200203111930U2020-02-05 02:40:00.0<NA>335364.385838257289.330756안내판 제작 및 설치 보수
25612562옥외광고업04_15_01_P3480000201834802770850000320091201<NA>3폐업40폐업20190612<NA><NA><NA>053 5619101<NA><NA>대구광역시 달성군 화원읍 천내리 ***번지대구광역시 달성군 화원읍 명천로**길 **42966톱사인20190612111537U2019-06-14 02:40:00.0<NA>336181.147478256800.344781광고물제작