Overview

Dataset statistics

Number of variables32
Number of observations3828
Missing cells42724
Missing cells (%)34.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 MiB
Average record size in memory278.0 B

Variable types

Numeric17
Categorical7
Text4
Unsupported3
DateTime1

Dataset

Description6270000_대구광역시_08_26_02_P_방문판매업_5월
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=DMI_0000085136&dataSetDetailId=DDI_0000085170&provdMethod=FILE

Alerts

개방서비스명 has constant value ""Constant
개방서비스ID has constant value ""Constant
재개업일자 is highly imbalanced (99.4%)Imbalance
데이터갱신구분 is highly imbalanced (56.1%)Imbalance
인허가취소일자 has 3374 (88.1%) missing valuesMissing
폐업일자 has 2297 (60.0%) missing valuesMissing
휴업시작일자 has 3821 (99.8%) missing valuesMissing
휴업종료일자 has 3821 (99.8%) missing valuesMissing
소재지전화 has 585 (15.3%) missing valuesMissing
소재지면적 has 3828 (100.0%) missing valuesMissing
소재지우편번호 has 2390 (62.4%) missing valuesMissing
소재지전체주소 has 686 (17.9%) missing valuesMissing
도로명전체주소 has 1132 (29.6%) missing valuesMissing
도로명우편번호 has 2278 (59.5%) missing valuesMissing
업태구분명 has 3828 (100.0%) missing valuesMissing
좌표정보(X) has 1112 (29.0%) missing valuesMissing
좌표정보(Y) has 1112 (29.0%) missing valuesMissing
자산규모 has 2875 (75.1%) missing valuesMissing
부채총액 has 2881 (75.3%) missing valuesMissing
자본금 has 2876 (75.1%) missing valuesMissing
판매방식명 has 3828 (100.0%) missing valuesMissing
자산규모 is highly skewed (γ1 = 26.13417418)Skewed
부채총액 is highly skewed (γ1 = 23.21516472)Skewed
자본금 is highly skewed (γ1 = 22.54931281)Skewed
번호 has unique valuesUnique
관리번호 has unique valuesUnique
소재지면적 is an unsupported type, check if it needs cleaning or further analysisUnsupported
업태구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
판매방식명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
자산규모 has 210 (5.5%) zerosZeros
부채총액 has 525 (13.7%) zerosZeros
자본금 has 190 (5.0%) zerosZeros

Reproduction

Analysis started2024-04-19 06:22:06.250202
Analysis finished2024-04-19 06:22:07.423330
Duration1.17 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct3828
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1914.5
Minimum1
Maximum3828
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:07.497480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile192.35
Q1957.75
median1914.5
Q32871.25
95-th percentile3636.65
Maximum3828
Range3827
Interquartile range (IQR)1913.5

Descriptive statistics

Standard deviation1105.1927
Coefficient of variation (CV)0.57727487
Kurtosis-1.2
Mean1914.5
Median Absolute Deviation (MAD)957
Skewness0
Sum7328706
Variance1221451
MonotonicityStrictly increasing
2024-04-19T15:22:07.639560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
2559 1
 
< 0.1%
2547 1
 
< 0.1%
2548 1
 
< 0.1%
2549 1
 
< 0.1%
2550 1
 
< 0.1%
2551 1
 
< 0.1%
2552 1
 
< 0.1%
2553 1
 
< 0.1%
2554 1
 
< 0.1%
Other values (3818) 3818
99.7%
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 (%)
3828 1
< 0.1%
3827 1
< 0.1%
3826 1
< 0.1%
3825 1
< 0.1%
3824 1
< 0.1%
3823 1
< 0.1%
3822 1
< 0.1%
3821 1
< 0.1%
3820 1
< 0.1%
3819 1
< 0.1%

개방서비스명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
방문판매업
3828 

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 (%)
방문판매업 3828
100.0%

Length

2024-04-19T15:22:07.802418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:07.896825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
방문판매업 3828
100.0%

개방서비스ID
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
08_26_02_P
3828 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
08_26_02_P 3828
100.0%

Length

2024-04-19T15:22:07.999380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:08.088258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
08_26_02_p 3828
100.0%

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

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3440838.6
Minimum3410000
Maximum3480000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:08.166236image/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 deviation23258.29
Coefficient of variation (CV)0.0067594831
Kurtosis-1.4666191
Mean3440838.6
Median Absolute Deviation (MAD)20000
Skewness0.014977321
Sum1.317153 × 1010
Variance5.4094806 × 108
MonotonicityIncreasing
2024-04-19T15:22:08.270143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
3410000 770
20.1%
3470000 653
17.1%
3420000 642
16.8%
3460000 595
15.5%
3450000 420
11.0%
3440000 369
9.6%
3430000 234
 
6.1%
3480000 145
 
3.8%
ValueCountFrequency (%)
3410000 770
20.1%
3420000 642
16.8%
3430000 234
 
6.1%
3440000 369
9.6%
3450000 420
11.0%
3460000 595
15.5%
3470000 653
17.1%
3480000 145
 
3.8%
ValueCountFrequency (%)
3480000 145
 
3.8%
3470000 653
17.1%
3460000 595
15.5%
3450000 420
11.0%
3440000 369
9.6%
3430000 234
 
6.1%
3420000 642
16.8%
3410000 770
20.1%

관리번호
Real number (ℝ)

UNIQUE 

Distinct3828
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0095102 × 1018
Minimum1.996341 × 1018
Maximum2.020348 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:08.432060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.996341 × 1018
5-th percentile1.999341 × 1018
Q12.005341 × 1018
median2.009346 × 1018
Q32.014345 × 1018
95-th percentile2.019342 × 1018
Maximum2.020348 × 1018
Range2.4007029 × 1016
Interquartile range (IQR)9.0040028 × 1015

Descriptive statistics

Standard deviation6.0325816 × 1015
Coefficient of variation (CV)0.0030020159
Kurtosis-0.83418478
Mean2.0095102 × 1018
Median Absolute Deviation (MAD)4.9969965 × 1015
Skewness-0.093821038
Sum1.1291625 × 1017
Variance3.6392041 × 1031
MonotonicityNot monotonic
2024-04-19T15:22:08.646522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1997341007123200031 1
 
< 0.1%
2016346014023200004 1
 
< 0.1%
2013346014023200002 1
 
< 0.1%
2010346010223200025 1
 
< 0.1%
2013346014023200003 1
 
< 0.1%
2013346014023200008 1
 
< 0.1%
2010346011723200024 1
 
< 0.1%
2013346014023200011 1
 
< 0.1%
2015346014023200011 1
 
< 0.1%
2015346014023200012 1
 
< 0.1%
Other values (3818) 3818
99.7%
ValueCountFrequency (%)
1996341007123200001 1
< 0.1%
1996341007123200002 1
< 0.1%
1996341007123200003 1
< 0.1%
1996341007123200004 1
< 0.1%
1996341007123200005 1
< 0.1%
1996341007123200006 1
< 0.1%
1996341007123200007 1
< 0.1%
1996341007123200008 1
< 0.1%
1996341007123200009 1
< 0.1%
1996341007123200010 1
< 0.1%
ValueCountFrequency (%)
2020348036523200003 1
< 0.1%
2020348036523200002 1
< 0.1%
2020348036523200001 1
< 0.1%
2020347018123200013 1
< 0.1%
2020347018123200012 1
< 0.1%
2020347018123200011 1
< 0.1%
2020347018123200010 1
< 0.1%
2020347018123200009 1
< 0.1%
2020347018123200008 1
< 0.1%
2020347018123200007 1
< 0.1%

인허가일자
Real number (ℝ)

Distinct2573
Distinct (%)67.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20090516
Minimum19960812
Maximum20200527
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:08.816354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19960812
5-th percentile19990524
Q120050119
median20090528
Q320140327
95-th percentile20190121
Maximum20200527
Range239715
Interquartile range (IQR)90208.5

Descriptive statistics

Standard deviation59592.412
Coefficient of variation (CV)0.0029661961
Kurtosis-0.80759326
Mean20090516
Median Absolute Deviation (MAD)49406
Skewness-0.061777277
Sum7.6906496 × 1010
Variance3.5512555 × 109
MonotonicityNot monotonic
2024-04-19T15:22:09.153742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20070529 14
 
0.4%
20170628 10
 
0.3%
20110106 8
 
0.2%
19960902 8
 
0.2%
20050402 8
 
0.2%
20110104 7
 
0.2%
20170629 7
 
0.2%
20041026 7
 
0.2%
20100111 7
 
0.2%
20111228 6
 
0.2%
Other values (2563) 3746
97.9%
ValueCountFrequency (%)
19960812 1
 
< 0.1%
19960814 1
 
< 0.1%
19960827 2
 
0.1%
19960830 1
 
< 0.1%
19960902 8
0.2%
19960904 1
 
< 0.1%
19960905 1
 
< 0.1%
19960911 1
 
< 0.1%
19961004 1
 
< 0.1%
19961104 2
 
0.1%
ValueCountFrequency (%)
20200527 1
< 0.1%
20200521 1
< 0.1%
20200514 1
< 0.1%
20200513 1
< 0.1%
20200508 2
0.1%
20200506 1
< 0.1%
20200504 1
< 0.1%
20200424 1
< 0.1%
20200422 1
< 0.1%
20200421 1
< 0.1%

인허가취소일자
Real number (ℝ)

MISSING 

Distinct54
Distinct (%)11.9%
Missing3374
Missing (%)88.1%
Infinite0
Infinite (%)0.0%
Mean20089939
Minimum20031210
Maximum20180530
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:09.284050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20031210
5-th percentile20070920
Q120080812
median20090122
Q320090217
95-th percentile20130739
Maximum20180530
Range149320
Interquartile range (IQR)9405

Descriptive statistics

Standard deviation17143.055
Coefficient of variation (CV)0.00085331544
Kurtosis6.1339044
Mean20089939
Median Absolute Deviation (MAD)95
Skewness1.7947013
Sum9.1208323 × 109
Variance2.9388434 × 108
MonotonicityNot monotonic
2024-04-19T15:22:09.445610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20090217 97
 
2.5%
20090122 81
 
2.1%
20090123 56
 
1.5%
20120823 22
 
0.6%
20080715 22
 
0.6%
20081128 19
 
0.5%
20070920 17
 
0.4%
20071008 15
 
0.4%
20080812 13
 
0.3%
20080703 12
 
0.3%
Other values (44) 100
 
2.6%
(Missing) 3374
88.1%
ValueCountFrequency (%)
20031210 3
 
0.1%
20061122 1
 
< 0.1%
20070611 2
 
0.1%
20070706 1
 
< 0.1%
20070820 5
 
0.1%
20070910 2
 
0.1%
20070914 1
 
< 0.1%
20070920 17
0.4%
20071002 1
 
< 0.1%
20071008 15
0.4%
ValueCountFrequency (%)
20180530 1
 
< 0.1%
20161026 1
 
< 0.1%
20160105 4
 
0.1%
20151230 1
 
< 0.1%
20150717 1
 
< 0.1%
20150714 1
 
< 0.1%
20150623 1
 
< 0.1%
20141215 1
 
< 0.1%
20130917 1
 
< 0.1%
20130802 11
0.3%
Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
3
1700 
4
1348 
1
775 
2
 
5

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 1700
44.4%
4 1348
35.2%
1 775
20.2%
2 5
 
0.1%

Length

2024-04-19T15:22:09.568365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:09.663797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 1700
44.4%
4 1348
35.2%
1 775
20.2%
2 5
 
0.1%

영업상태명
Categorical

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
폐업
1700 
취소/말소/만료/정지/중지
1348 
영업/정상
775 
휴업
 
5

Length

Max length14
Median length5
Mean length6.8330721
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 1700
44.4%
취소/말소/만료/정지/중지 1348
35.2%
영업/정상 775
20.2%
휴업 5
 
0.1%

Length

2024-04-19T15:22:09.774148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:09.880144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 1700
44.4%
취소/말소/만료/정지/중지 1348
35.2%
영업/정상 775
20.2%
휴업 5
 
0.1%

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

Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.6496865
Minimum1
Maximum8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:09.993169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median3
Q34
95-th percentile7
Maximum8
Range7
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.0582851
Coefficient of variation (CV)0.56396217
Kurtosis-0.80363892
Mean3.6496865
Median Absolute Deviation (MAD)1
Skewness0.56283198
Sum13971
Variance4.2365377
MonotonicityNot monotonic
2024-04-19T15:22:10.107699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
3 1700
44.4%
7 889
23.2%
1 770
20.1%
4 459
 
12.0%
2 5
 
0.1%
6 4
 
0.1%
8 1
 
< 0.1%
ValueCountFrequency (%)
1 770
20.1%
2 5
 
0.1%
3 1700
44.4%
4 459
 
12.0%
6 4
 
0.1%
7 889
23.2%
8 1
 
< 0.1%
ValueCountFrequency (%)
8 1
 
< 0.1%
7 889
23.2%
6 4
 
0.1%
4 459
 
12.0%
3 1700
44.4%
2 5
 
0.1%
1 770
20.1%
Distinct7
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
폐업처리
1700 
직권말소
889 
정상영업
770 
직권취소
459 
휴업처리
 
5
Other values (2)
 
5

Length

Max length6
Median length4
Mean length4.0020899
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row직권말소
2nd row직권말소
3rd row직권말소
4th row직권말소
5th row직권말소

Common Values

ValueCountFrequency (%)
폐업처리 1700
44.4%
직권말소 889
23.2%
정상영업 770
20.1%
직권취소 459
 
12.0%
휴업처리 5
 
0.1%
타시군구전입 4
 
0.1%
영업재개 1
 
< 0.1%

Length

2024-04-19T15:22:10.260607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:10.384747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업처리 1700
44.4%
직권말소 889
23.2%
정상영업 770
20.1%
직권취소 459
 
12.0%
휴업처리 5
 
0.1%
타시군구전입 4
 
0.1%
영업재개 1
 
< 0.1%

폐업일자
Real number (ℝ)

MISSING 

Distinct1098
Distinct (%)71.7%
Missing2297
Missing (%)60.0%
Infinite0
Infinite (%)0.0%
Mean20126530
Minimum19970508
Maximum20200514
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:10.520271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19970508
5-th percentile20070818
Q120100326
median20121231
Q320151116
95-th percentile20190612
Maximum20200514
Range230006
Interquartile range (IQR)50789.5

Descriptive statistics

Standard deviation37224.931
Coefficient of variation (CV)0.0018495454
Kurtosis-0.45537561
Mean20126530
Median Absolute Deviation (MAD)29500
Skewness0.048167867
Sum3.0813717 × 1010
Variance1.3856955 × 109
MonotonicityNot monotonic
2024-04-19T15:22:10.697872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20130916 11
 
0.3%
20121231 7
 
0.2%
20101130 6
 
0.2%
20131028 6
 
0.2%
20130819 6
 
0.2%
20131023 6
 
0.2%
20101203 6
 
0.2%
20140120 5
 
0.1%
20131230 5
 
0.1%
20131022 5
 
0.1%
Other values (1088) 1468
38.3%
(Missing) 2297
60.0%
ValueCountFrequency (%)
19970508 1
< 0.1%
19990629 1
< 0.1%
20020502 1
< 0.1%
20020801 1
< 0.1%
20030418 1
< 0.1%
20040224 1
< 0.1%
20040317 1
< 0.1%
20040605 1
< 0.1%
20040612 1
< 0.1%
20040625 1
< 0.1%
ValueCountFrequency (%)
20200514 1
< 0.1%
20200511 1
< 0.1%
20200508 1
< 0.1%
20200414 2
0.1%
20200407 1
< 0.1%
20200403 1
< 0.1%
20200401 1
< 0.1%
20200331 1
< 0.1%
20200323 2
0.1%
20200320 2
0.1%

휴업시작일자
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)100.0%
Missing3821
Missing (%)99.8%
Infinite0
Infinite (%)0.0%
Mean20119272
Minimum19970415
Maximum20200320
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:10.823721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19970415
5-th percentile20009479
Q120110666
median20130715
Q320156061
95-th percentile20188590
Maximum20200320
Range229905
Interquartile range (IQR)45394.5

Descriptive statistics

Standard deviation72992.933
Coefficient of variation (CV)0.0036280106
Kurtosis3.4506
Mean20119272
Median Absolute Deviation (MAD)30086
Skewness-1.5992882
Sum1.408349 × 108
Variance5.3279683 × 109
MonotonicityNot monotonic
2024-04-19T15:22:10.986601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20100629 1
 
< 0.1%
20200320 1
 
< 0.1%
20130715 1
 
< 0.1%
20161219 1
 
< 0.1%
19970415 1
 
< 0.1%
20120704 1
 
< 0.1%
20150903 1
 
< 0.1%
(Missing) 3821
99.8%
ValueCountFrequency (%)
19970415 1
< 0.1%
20100629 1
< 0.1%
20120704 1
< 0.1%
20130715 1
< 0.1%
20150903 1
< 0.1%
20161219 1
< 0.1%
20200320 1
< 0.1%
ValueCountFrequency (%)
20200320 1
< 0.1%
20161219 1
< 0.1%
20150903 1
< 0.1%
20130715 1
< 0.1%
20120704 1
< 0.1%
20100629 1
< 0.1%
19970415 1
< 0.1%

휴업종료일자
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)100.0%
Missing3821
Missing (%)99.8%
Infinite0
Infinite (%)0.0%
Mean20131882
Minimum19990415
Maximum20200620
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size33.8 KiB
2024-04-19T15:22:11.103646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19990415
5-th percentile20026479
Q120120479
median20160229
Q320165475
95-th percentile20191530
Maximum20200620
Range210205
Interquartile range (IQR)44996

Descriptive statistics

Standard deviation68677.272
Coefficient of variation (CV)0.0034113688
Kurtosis3.5480631
Mean20131882
Median Absolute Deviation (MAD)29900
Skewness-1.7379191
Sum1.4092317 × 108
Variance4.7165677 × 109
MonotonicityNot monotonic
2024-04-19T15:22:11.219529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20110629 1
 
< 0.1%
20200620 1
 
< 0.1%
20160630 1
 
< 0.1%
20170320 1
 
< 0.1%
19990415 1
 
< 0.1%
20130329 1
 
< 0.1%
20160229 1
 
< 0.1%
(Missing) 3821
99.8%
ValueCountFrequency (%)
19990415 1
< 0.1%
20110629 1
< 0.1%
20130329 1
< 0.1%
20160229 1
< 0.1%
20160630 1
< 0.1%
20170320 1
< 0.1%
20200620 1
< 0.1%
ValueCountFrequency (%)
20200620 1
< 0.1%
20170320 1
< 0.1%
20160630 1
< 0.1%
20160229 1
< 0.1%
20130329 1
< 0.1%
20110629 1
< 0.1%
19990415 1
< 0.1%

재개업일자
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size30.0 KiB
<NA>
3824 
20161102
 
1
20090304
 
1
20180525
 
1
20190402
 
1

Length

Max length8
Median length4
Mean length4.0041797
Min length4

Unique

Unique4 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 3824
99.9%
20161102 1
 
< 0.1%
20090304 1
 
< 0.1%
20180525 1
 
< 0.1%
20190402 1
 
< 0.1%

Length

2024-04-19T15:22:11.355817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:22:11.478103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 3824
99.9%
20161102 1
 
< 0.1%
20090304 1
 
< 0.1%
20180525 1
 
< 0.1%
20190402 1
 
< 0.1%

소재지전화
Text

MISSING 

Distinct2987
Distinct (%)92.1%
Missing585
Missing (%)15.3%
Memory size30.0 KiB
2024-04-19T15:22:11.755585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length12
Mean length11.362936
Min length1

Characters and Unicode

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

Unique

Unique2819 ?
Unique (%)86.9%

Sample

1st row053 426 1461
2nd row053 252 2048
3rd row053 423 2409
4th row053 252 5977
5th row053 421 4714
ValueCountFrequency (%)
053 1321
 
22.7%
256 47
 
0.8%
429 46
 
0.8%
421 36
 
0.6%
255 35
 
0.6%
423 35
 
0.6%
426 32
 
0.6%
424 32
 
0.6%
422 31
 
0.5%
252 29
 
0.5%
Other values (3047) 4170
71.7%
2024-04-19T15:22:12.170064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/