Overview

Dataset statistics

Number of variables30
Number of observations25
Missing cells262
Missing cells (%)34.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.5 KiB
Average record size in memory264.3 B

Variable types

Categorical8
Numeric6
DateTime3
Unsupported9
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가취소일자 has 25 (100.0%) missing valuesMissing
폐업일자 has 18 (72.0%) missing valuesMissing
휴업시작일자 has 25 (100.0%) missing valuesMissing
휴업종료일자 has 25 (100.0%) missing valuesMissing
재개업일자 has 25 (100.0%) missing valuesMissing
전화번호 has 4 (16.0%) missing valuesMissing
소재지우편번호 has 25 (100.0%) missing valuesMissing
도로명주소 has 2 (8.0%) missing valuesMissing
도로명우편번호 has 7 (28.0%) missing valuesMissing
업태구분명 has 25 (100.0%) missing valuesMissing
좌표정보(X) has 3 (12.0%) missing valuesMissing
좌표정보(Y) has 3 (12.0%) missing valuesMissing
축산물가공업구분명 has 25 (100.0%) missing valuesMissing
축산일련번호 has 25 (100.0%) missing valuesMissing
총인원 has 25 (100.0%) missing valuesMissing
관리번호 has unique valuesUnique
최종수정일자 has unique valuesUnique
인허가취소일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업시작일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
재개업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
소재지우편번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
업태구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
축산물가공업구분명 is an unsupported type, check if it needs cleaning or further analysisUnsupported
축산일련번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported
총인원 is an unsupported type, check if it needs cleaning or further analysisUnsupported
소재지면적 has 14 (56.0%) zerosZeros

Reproduction

Analysis started2024-05-11 04:27:38.488038
Analysis finished2024-05-11 04:27:39.644397
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
3000000
25 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3000000 25
100.0%

Length

2024-05-11T04:27:39.910350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:40.511099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3000000 25
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3 × 1017
Minimum3 × 1017
Maximum3 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:27:40.891289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3 × 1017
5-th percentile3 × 1017
Q13 × 1017
median3 × 1017
Q33 × 1017
95-th percentile3 × 1017
Maximum3 × 1017
Range480000
Interquartile range (IQR)120000

Descriptive statistics

Standard deviation107910.16
Coefficient of variation (CV)3.5970053 × 10-13
Kurtosis1.825685
Mean3 × 1017
Median Absolute Deviation (MAD)59968
Skewness-1.023781
Sum7.5 × 1018
Variance1.1644602 × 1010
MonotonicityStrictly increasing
2024-05-11T04:27:41.405135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
300000001019750001 1
 
4.0%
300000001019910001 1
 
4.0%
300000001020230001 1
 
4.0%
300000001020220001 1
 
4.0%
300000001020200001 1
 
4.0%
300000001020170001 1
 
4.0%
300000001020160001 1
 
4.0%
300000001020130007 1
 
4.0%
300000001020130006 1
 
4.0%
300000001020130004 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
300000001019750001 1
4.0%
300000001019910001 1
4.0%
300000001019950001 1
4.0%
300000001019950002 1
4.0%
300000001019990001 1
4.0%
300000001020010001 1
4.0%
300000001020010002 1
4.0%
300000001020020001 1
4.0%
300000001020040001 1
4.0%
300000001020050001 1
4.0%
ValueCountFrequency (%)
300000001020230001 1
4.0%
300000001020220001 1
4.0%
300000001020200001 1
4.0%
300000001020170001 1
4.0%
300000001020160001 1
4.0%
300000001020130007 1
4.0%
300000001020130006 1
4.0%
300000001020130004 1
4.0%
300000001020130003 1
4.0%
300000001020130002 1
4.0%
Distinct21
Distinct (%)84.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
Minimum1975-05-06 00:00:00
Maximum2023-08-21 00:00:00
2024-05-11T04:27:41.870652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:27:42.348135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B
Distinct4
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
1
12 
3
2
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 12
48.0%
3 7
28.0%
2 4
 
16.0%
4 2
 
8.0%

Length

2024-05-11T04:27:42.972486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:43.389495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 12
48.0%
3 7
28.0%
2 4
 
16.0%
4 2
 
8.0%

영업상태명
Categorical

Distinct4
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
영업/정상
12 
폐업
휴업
취소/말소/만료/정지/중지

Length

Max length14
Median length5
Mean length4.4
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업/정상 12
48.0%
폐업 7
28.0%
휴업 4
 
16.0%
취소/말소/만료/정지/중지 2
 
8.0%

Length

2024-05-11T04:27:43.839868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:44.326654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 12
48.0%
폐업 7
28.0%
휴업 4
 
16.0%
취소/말소/만료/정지/중지 2
 
8.0%
Distinct4
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
0
12 
2
1
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2
2nd row2
3rd row2
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 12
48.0%
2 7
28.0%
1 4
 
16.0%
4 2
 
8.0%

Length

2024-05-11T04:27:44.793862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:45.155479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 12
48.0%
2 7
28.0%
1 4
 
16.0%
4 2
 
8.0%
Distinct4
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
정상
12 
폐업
휴업
말소

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
정상 12
48.0%
폐업 7
28.0%
휴업 4
 
16.0%
말소 2
 
8.0%

Length

2024-05-11T04:27:45.551908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:45.874517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 12
48.0%
폐업 7
28.0%
휴업 4
 
16.0%
말소 2
 
8.0%

폐업일자
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)100.0%
Missing18
Missing (%)72.0%
Infinite0
Infinite (%)0.0%
Mean20130688
Minimum20040807
Maximum20181030
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:27:46.221359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20040807
5-th percentile20049633
Q120100266
median20151021
Q320170714
95-th percentile20177938
Maximum20181030
Range140223
Interquartile range (IQR)70447

Descriptive statistics

Standard deviation54598.874
Coefficient of variation (CV)0.0027122209
Kurtosis-0.65512966
Mean20130688
Median Absolute Deviation (MAD)20714
Skewness-0.97903156
Sum1.4091482 × 108
Variance2.981037 × 109
MonotonicityNot monotonic
2024-05-11T04:27:46.783082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20130307 1
 
4.0%
20151021 1
 
4.0%
20040807 1
 
4.0%
20070226 1
 
4.0%
20170704 1
 
4.0%
20170723 1
 
4.0%
20181030 1
 
4.0%
(Missing) 18
72.0%
ValueCountFrequency (%)
20040807 1
4.0%
20070226 1
4.0%
20130307 1
4.0%
20151021 1
4.0%
20170704 1
4.0%
20170723 1
4.0%
20181030 1
4.0%
ValueCountFrequency (%)
20181030 1
4.0%
20170723 1
4.0%
20170704 1
4.0%
20151021 1
4.0%
20130307 1
4.0%
20070226 1
4.0%
20040807 1
4.0%

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

전화번호
Text

MISSING 

Distinct15
Distinct (%)71.4%
Missing4
Missing (%)16.0%
Memory size332.0 B
2024-05-11T04:27:47.302467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length8
Mean length8.6666667
Min length7

Characters and Unicode

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

Unique12 ?
Unique (%)57.1%

Sample

1st row733-5060
2nd row3672-8441
3rd row379-7575
4th row732-3827
5th row02-744-9098
ValueCountFrequency (%)
732-3827 5
23.8%
379-7575 2
 
9.5%
3216-7582 2
 
9.5%
733-5060 1
 
4.8%
3672-8441 1
 
4.8%
02-744-9098 1
 
4.8%
391-4575 1
 
4.8%
764-0075 1
 
4.8%
3917502 1
 
4.8%
3676-1190 1
 
4.8%
Other values (5) 5
23.8%
2024-05-11T04:27:48.492943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7 35
19.2%
3 27
14.8%
2 27
14.8%
- 23
12.6%
5 15
8.2%
0 14
 
7.7%
8 12
 
6.6%
6 9
 
4.9%
9 7
 
3.8%
1 7
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 159
87.4%
Dash Punctuation 23
 
12.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 35
22.0%
3 27
17.0%
2 27
17.0%
5 15
9.4%
0 14
 
8.8%
8 12
 
7.5%
6 9
 
5.7%
9 7
 
4.4%
1 7
 
4.4%
4 6
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 182
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
7 35
19.2%
3 27
14.8%
2 27
14.8%
- 23
12.6%
5 15
8.2%
0 14
 
7.7%
8 12
 
6.6%
6 9
 
4.9%
9 7
 
3.8%
1 7
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 182
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7 35
19.2%
3 27
14.8%
2 27
14.8%
- 23
12.6%
5 15
8.2%
0 14
 
7.7%
8 12
 
6.6%
6 9
 
4.9%
9 7
 
3.8%
1 7
 
3.8%

소재지면적
Real number (ℝ)

ZEROS 

Distinct12
Distinct (%)48.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.408
Minimum0
Maximum326.5
Zeros14
Zeros (%)56.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:27:48.960341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q344.9
95-th percentile184.1
Maximum326.5
Range326.5
Interquartile range (IQR)44.9

Descriptive statistics

Standard deviation76.169143
Coefficient of variation (CV)1.9831583
Kurtosis8.7155226
Mean38.408
Median Absolute Deviation (MAD)0
Skewness2.866318
Sum960.2
Variance5801.7384
MonotonicityNot monotonic
2024-05-11T04:27:49.429901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
0.0 14
56.0%
20.3 1
 
4.0%
53.7 1
 
4.0%
46.22 1
 
4.0%
26.29 1
 
4.0%
196.0 1
 
4.0%
22.21 1
 
4.0%
42.58 1
 
4.0%
45.0 1
 
4.0%
326.5 1
 
4.0%
Other values (2) 2
 
8.0%
ValueCountFrequency (%)
0.0 14
56.0%
20.3 1
 
4.0%
22.21 1
 
4.0%
26.29 1
 
4.0%
42.58 1
 
4.0%
44.9 1
 
4.0%
45.0 1
 
4.0%
46.22 1
 
4.0%
53.7 1
 
4.0%
136.5 1
 
4.0%
ValueCountFrequency (%)
326.5 1
4.0%
196.0 1
4.0%
136.5 1
4.0%
53.7 1
4.0%
46.22 1
4.0%
45.0 1
4.0%
44.9 1
4.0%
42.58 1
4.0%
26.29 1
4.0%
22.21 1
4.0%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B
Distinct20
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2024-05-11T04:27:50.241123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length36
Mean length24
Min length14

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)76.0%

Sample

1st row서울특별시 종로구 연건동 188번지
2nd row서울특별시 종로구 무악동
3rd row서울특별시 종로구 평창동 289-2 번지
4th row서울특별시 종로구 명륜2가 5-99번지 1통3반 방산빌라 402호
5th row서울특별시 종로구 평창동 158-1 글로리아타운
ValueCountFrequency (%)
서울특별시 25
21.2%
종로구 25
21.2%
효자동 6
 
5.1%
31번지 6
 
5.1%
평창동 4
 
3.4%
홍지동 2
 
1.7%
숭인동 2
 
1.7%
504호 1
 
0.8%
경희궁자이 1
 
0.8%
125-3번지 1
 
0.8%
Other values (45) 45
38.1%
2024-05-11T04:27:51.499103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
112
18.7%
1 27
 
4.5%
26
 
4.3%
25
 
4.2%
25
 
4.2%
25
 
4.2%
25
 
4.2%
25
 
4.2%
25
 
4.2%
25
 
4.2%
Other values (64) 260
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 361
60.2%
Space Separator 112
 
18.7%
Decimal Number 110
 
18.3%
Dash Punctuation 17
 
2.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
26
 
7.2%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
24
 
6.6%
22
 
6.1%
Other values (52) 114
31.6%
Decimal Number
ValueCountFrequency (%)
1 27
24.5%
2 20
18.2%
3 13
11.8%
5 10
 
9.1%
8 9
 
8.2%
0 8
 
7.3%
4 8
 
7.3%
7 6
 
5.5%
9 6
 
5.5%
6 3
 
2.7%
Space Separator
ValueCountFrequency (%)
112
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 361
60.2%
Common 239
39.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
26
 
7.2%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
24
 
6.6%
22
 
6.1%
Other values (52) 114
31.6%
Common
ValueCountFrequency (%)
112
46.9%
1 27
 
11.3%
2 20
 
8.4%
- 17
 
7.1%
3 13
 
5.4%
5 10
 
4.2%
8 9
 
3.8%
0 8
 
3.3%
4 8
 
3.3%
7 6
 
2.5%
Other values (2) 9
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 361
60.2%
ASCII 239
39.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
112
46.9%
1 27
 
11.3%
2 20
 
8.4%
- 17
 
7.1%
3 13
 
5.4%
5 10
 
4.2%
8 9
 
3.8%
0 8
 
3.3%
4 8
 
3.3%
7 6
 
2.5%
Other values (2) 9
 
3.8%
Hangul
ValueCountFrequency (%)
26
 
7.2%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
25
 
6.9%
24
 
6.6%
22
 
6.1%
Other values (52) 114
31.6%

도로명주소
Text

MISSING 

Distinct18
Distinct (%)78.3%
Missing2
Missing (%)8.0%
Memory size332.0 B
2024-05-11T04:27:52.149433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length38
Mean length27.304348
Min length23

Characters and Unicode

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

Unique

Unique17 ?
Unique (%)73.9%

Sample

1st row서울특별시 종로구 통일로 238, 지층 (무악동)
2nd row서울특별시 종로구 창경궁로 261 (명륜2가)
3rd row서울특별시 종로구 평창문화로 75, 글로리아타운 111호 (평창동)
4th row서울특별시 종로구 자하문로 66-2 (효자동)
5th row서울특별시 종로구 지봉로 53-1 (창신동)
ValueCountFrequency (%)
서울특별시 23
17.8%
종로구 23
17.8%
자하문로 10
 
7.8%
66-2 6
 
4.7%
효자동 6
 
4.7%
평창동 3
 
2.3%
평창문화로 2
 
1.6%
2층 2
 
1.6%
지봉로 2
 
1.6%
숭인동 2
 
1.6%
Other values (49) 50
38.8%
2024-05-11T04:27:53.387292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
106
 
16.9%
45
 
7.2%
23
 
3.7%
( 23
 
3.7%
23
 
3.7%
23
 
3.7%
23
 
3.7%
23
 
3.7%
23
 
3.7%
23
 
3.7%
Other values (71) 293
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 377
60.0%
Space Separator 106
 
16.9%
Decimal Number 82
 
13.1%
Open Punctuation 23
 
3.7%
Close Punctuation 23
 
3.7%
Dash Punctuation 9
 
1.4%
Other Punctuation 8
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
45
 
11.9%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
22
 
5.8%
18
 
4.8%
Other values (56) 131
34.7%
Decimal Number
ValueCountFrequency (%)
1 18
22.0%
2 18
22.0%
6 14
17.1%
3 13
15.9%
9 7
 
8.5%
5 6
 
7.3%
7 2
 
2.4%
0 2
 
2.4%
4 1
 
1.2%
8 1
 
1.2%
Space Separator
ValueCountFrequency (%)
106
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 377
60.0%
Common 251
40.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
45
 
11.9%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
22
 
5.8%
18
 
4.8%
Other values (56) 131
34.7%
Common
ValueCountFrequency (%)
106
42.2%
( 23
 
9.2%
) 23
 
9.2%
1 18
 
7.2%
2 18
 
7.2%
6 14
 
5.6%
3 13
 
5.2%
- 9
 
3.6%
, 8
 
3.2%
9 7
 
2.8%
Other values (5) 12
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 377
60.0%
ASCII 251
40.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
106
42.2%
( 23
 
9.2%
) 23
 
9.2%
1 18
 
7.2%
2 18
 
7.2%
6 14
 
5.6%
3 13
 
5.2%
- 9
 
3.6%
, 8
 
3.2%
9 7
 
2.8%
Other values (5) 12
 
4.8%
Hangul
ValueCountFrequency (%)
45
 
11.9%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
23
 
6.1%
22
 
5.8%
18
 
4.8%
Other values (56) 131
34.7%

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

MISSING 

Distinct13
Distinct (%)72.2%
Missing7
Missing (%)28.0%
Infinite0
Infinite (%)0.0%
Mean3049.4444
Minimum3007
Maximum3165
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:27:53.831314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3007
5-th percentile3007.85
Q13030.5
median3042
Q33061.5
95-th percentile3115.7
Maximum3165
Range158
Interquartile range (IQR)31

Descriptive statistics

Standard deviation38.681539
Coefficient of variation (CV)0.012684782
Kurtosis3.8798399
Mean3049.4444
Median Absolute Deviation (MAD)16.5
Skewness1.7410195
Sum54890
Variance1496.2614
MonotonicityNot monotonic
2024-05-11T04:27:54.349148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
3042 6
24.0%
3030 1
 
4.0%
3075 1
 
4.0%
3009 1
 
4.0%
3021 1
 
4.0%
3068 1
 
4.0%
3008 1
 
4.0%
3007 1
 
4.0%
3040 1
 
4.0%
3165 1
 
4.0%
Other values (3) 3
12.0%
(Missing) 7
28.0%
ValueCountFrequency (%)
3007 1
 
4.0%
3008 1
 
4.0%
3009 1
 
4.0%
3021 1
 
4.0%
3030 1
 
4.0%
3032 1
 
4.0%
3040 1
 
4.0%
3042 6
24.0%
3068 1
 
4.0%
3075 1
 
4.0%
ValueCountFrequency (%)
3165 1
 
4.0%
3107 1
 
4.0%
3076 1
 
4.0%
3075 1
 
4.0%
3068 1
 
4.0%
3042 6
24.0%
3040 1
 
4.0%
3032 1
 
4.0%
3030 1
 
4.0%
3021 1
 
4.0%
Distinct18
Distinct (%)72.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2024-05-11T04:27:54.832173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length6
Mean length6.4
Min length5

Characters and Unicode

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

Unique

Unique15 ?
Unique (%)60.0%

Sample

1st row홍수의과병원
2nd row독립문동물병원
3rd row평화동물병원
4th row대학로동물병원
5th row월드펫동물병원
ValueCountFrequency (%)
효자동물병원 6
22.2%
월드펫동물병원 2
 
7.4%
평창동물병원 2
 
7.4%
광화문동물병원 1
 
3.7%
홍수의과병원 1
 
3.7%
우리동물병원 1
 
3.7%
폴라동물병원 1
 
3.7%
선동물병원 1
 
3.7%
동물병원 1
 
3.7%
바른 1
 
3.7%
Other values (10) 10
37.0%
2024-05-11T04:27:55.923659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
25
15.6%
25
15.6%
24
15.0%
24
15.0%
6
 
3.8%
6
 
3.8%
3
 
1.9%
3
 
1.9%
2
 
1.2%
2
 
1.2%
Other values (35) 40
25.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 158
98.8%
Space Separator 2
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
25
15.8%
25
15.8%
24
15.2%
24
15.2%
6
 
3.8%
6
 
3.8%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
Other values (34) 38
24.1%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 158
98.8%
Common 2
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
25
15.8%
25
15.8%
24
15.2%
24
15.2%
6
 
3.8%
6
 
3.8%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
Other values (34) 38
24.1%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 158
98.8%
ASCII 2
 
1.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
25
15.8%
25
15.8%
24
15.2%
24
15.2%
6
 
3.8%
6
 
3.8%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
Other values (34) 38
24.1%
ASCII
ValueCountFrequency (%)
2
100.0%

최종수정일자
Date

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
Minimum2004-08-07 13:01:45
Maximum2024-04-26 10:03:10
2024-05-11T04:27:56.495675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:27:57.071955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
Distinct2
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
I
16 
U

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 16
64.0%
U 9
36.0%

Length

2024-05-11T04:27:57.593441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:27:57.918514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 16
64.0%
u 9
36.0%
Distinct12
Distinct (%)48.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-03 22:08:00
2024-05-11T04:27:58.304331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:27:58.803004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

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

MISSING 

Distinct16
Distinct (%)72.7%
Missing3
Missing (%)12.0%
Infinite0
Infinite (%)0.0%
Mean198028.24
Minimum196296.92
Maximum201451.46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:27:59.325557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum196296.92
5-th percentile196313.81
Q1196935.05
median197364.61
Q3199299.6
95-th percentile201311.74
Maximum201451.46
Range5154.543
Interquartile range (IQR)2364.5475

Descriptive statistics

Standard deviation1736.5281
Coefficient of variation (CV)0.0087690936
Kurtosis-0.34481354
Mean198028.24
Median Absolute Deviation (MAD)522.00535
Skewness1.0827065
Sum4356621.2
Variance3015529.9
MonotonicityNot monotonic
2024-05-11T04:27:59.859897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
197364.614476836 6
24.0%
196842.609122384 2
 
8.0%
197374.347630839 1
 
4.0%
200079.663985257 1
 
4.0%
201451.464239337 1
 
4.0%
197278.891939281 1
 
4.0%
197383.197504794 1
 
4.0%
196444.558512343 1
 
4.0%
196296.921233318 1
 
4.0%
201312.324500599 1
 
4.0%
Other values (6) 6
24.0%
(Missing) 3
12.0%
ValueCountFrequency (%)
196296.921233318 1
 
4.0%
196308.215602977 1
 
4.0%
196420.140799836 1
 
4.0%
196444.558512343 1
 
4.0%
196842.609122384 2
 
8.0%
197212.364862058 1
 
4.0%
197278.891939281 1
 
4.0%
197364.614476836 6
24.0%
197374.347630839 1
 
4.0%
197383.197504794 1
 
4.0%
ValueCountFrequency (%)
201451.464239337 1
 
4.0%
201312.324500599 1
 
4.0%
201300.617267399 1
 
4.0%
200079.663985257 1
 
4.0%
199947.178659037 1
 
4.0%
199938.394948321 1
 
4.0%
197383.197504794 1
 
4.0%
197374.347630839 1
 
4.0%
197364.614476836 6
24.0%
197278.891939281 1
 
4.0%

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

MISSING 

Distinct16
Distinct (%)72.7%
Missing3
Missing (%)12.0%
Infinite0
Infinite (%)0.0%
Mean453878.52
Minimum452397.07
Maximum456055.21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-05-11T04:28:00.391574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum452397.07
5-th percentile452517.19
Q1453179.09
median453303.29
Q3454840.31
95-th percentile455988.57
Maximum456055.21
Range3658.1314
Interquartile range (IQR)1661.2141

Descriptive statistics

Standard deviation1205.7256
Coefficient of variation (CV)0.002656494
Kurtosis-0.72621259
Mean453878.52
Median Absolute Deviation (MAD)435.35449
Skewness0.8541207
Sum9985327.4
Variance1453774.2
MonotonicityNot monotonic
2024-05-11T04:28:00.933421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
453303.293915738 6
24.0%
455844.995397014 2
 
8.0%
452611.452584222 1
 
4.0%
453836.098562833 1
 
4.0%
453137.690825347 1
 
4.0%
453572.355620921 1
 
4.0%
452972.118568389 1
 
4.0%
455996.128787691 1
 
4.0%
452397.074356224 1
 
4.0%
452934.470658927 1
 
4.0%
Other values (6) 6
24.0%
(Missing) 3
12.0%
ValueCountFrequency (%)
452397.074356224 1
 
4.0%
452512.234050389 1
 
4.0%
452611.452584222 1
 
4.0%
452934.470658927 1
 
4.0%
452972.118568389 1
 
4.0%
453137.690825347 1
 
4.0%
453303.293915738 6
24.0%
453572.355620921 1
 
4.0%
453593.826987348 1
 
4.0%
453805.179643767 1
 
4.0%
ValueCountFrequency (%)
456055.205802855 1
 
4.0%
455996.128787691 1
 
4.0%
455844.995397014 2
 
8.0%
455218.757468473 1
 
4.0%
455175.041431888 1
 
4.0%
453836.098562833 1
 
4.0%
453805.179643767 1
 
4.0%
453593.826987348 1
 
4.0%
453572.355620921 1
 
4.0%
453303.293915738 6
24.0%
Distinct2
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
동물병원
20 
<NA>

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동물병원
2nd row동물병원
3rd row동물병원
4th row동물병원
5th row<NA>

Common Values

ValueCountFrequency (%)
동물병원 20
80.0%
<NA> 5
 
20.0%

Length

2024-05-11T04:28:01.389086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:28:01.731417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물병원 20
80.0%
na 5
 
20.0%

축산물가공업구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

축산일련번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B
Distinct2
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
0
20 
<NA>

Length

Max length4
Median length1
Mean length1.6
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 20
80.0%
<NA> 5
 
20.0%

Length

2024-05-11T04:28:02.077749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T04:28:02.401557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 20
80.0%
na 5
 
20.0%

총인원
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing25
Missing (%)100.0%
Memory size357.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)축산업무구분명축산물가공업구분명축산일련번호권리주체일련번호총인원
0300000030000000101975000119750506<NA>3폐업2폐업20130307<NA><NA><NA><NA>0.0<NA>서울특별시 종로구 연건동 188번지<NA><NA>홍수의과병원2013-04-01 17:52:02I2018-08-31 23:59:59.0<NA><NA><NA>동물병원<NA><NA>0<NA>
1300000030000000101991000120130311<NA>3폐업2폐업20151021<NA><NA><NA>733-50600.0<NA>서울특별시 종로구 무악동서울특별시 종로구 통일로 238, 지층 (무악동)3030독립문동물병원2015-10-21 16:29:02I2018-08-31 23:59:59.0<NA>196296.921233452397.074356동물병원<NA><NA>0<NA>
2300000030000000101995000119950811<NA>3폐업2폐업20040807<NA><NA><NA><NA>20.3<NA>서울특별시 종로구 평창동 289-2 번지<NA><NA>평화동물병원2004-08-07 13:01:45I2018-08-31 23:59:59.0<NA><NA><NA>동물병원<NA><NA>0<NA>
3300000030000000101995000219950905<NA>1영업/정상0정상<NA><NA><NA><NA>3672-844153.7<NA>서울특별시 종로구 명륜2가 5-99번지 1통3반 방산빌라 402호서울특별시 종로구 창경궁로 261 (명륜2가)3075대학로동물병원2019-04-29 17:30:23U2019-05-01 02:40:00.0<NA>199947.178659453593.826987동물병원<NA><NA>0<NA>
430000003000000010199900011999-04-23<NA>1영업/정상0정상<NA><NA><NA><NA>379-75750.0<NA>서울특별시 종로구 평창동 158-1 글로리아타운서울특별시 종로구 평창문화로 75, 글로리아타운 111호 (평창동)3009월드펫동물병원2023-03-17 15:58:31U2022-12-02 23:09:00.0<NA>197212.364862456055.205803<NA><NA><NA><NA><NA>
5300000030000000102001000120130304<NA>2휴업1휴업<NA><NA><NA><NA>732-38270.0<NA>서울특별시 종로구 효자동 31번지서울특별시 종로구 자하문로 66-2 (효자동)3042효자동물병원2014-12-31 09:41:37I2018-08-31 23:59:59.0<NA>197364.614477453303.293916동물병원<NA><NA>0<NA>
6300000030000000102001000220011211<NA>1영업/정상0정상<NA><NA><NA><NA>02-744-90980.0<NA>서울특별시 종로구 창신동 80-1서울특별시 종로구 지봉로 53-1 (창신동)<NA>해동물병원2020-11-10 13:02:15U2020-11-17 02:40:00.0<NA>201300.617267452512.23405동물병원<NA><NA>0<NA>
7300000030000000102002000120021025<NA>1영업/정상0정상<NA><NA><NA><NA>391-457546.22<NA>서울특별시 종로구 홍지동 127-7번지 5통5반 지층 3호서울특별시 종로구 자하문로 293 (홍지동)3021북악동물병원2019-04-29 17:31:33U2019-05-01 02:40:00.0<NA>196420.1408455175.041432동물병원<NA><NA>0<NA>
8300000030000000102004000120040908<NA>3폐업2폐업20070226<NA><NA><NA>3216-758226.29<NA>서울특별시 종로구 평창동 289-2번지서울특별시 종로구 세검정로 313 (평창동)<NA>평창동물병원2007-02-26 15:57:46I2018-08-31 23:59:59.0<NA>196842.609122455844.995397동물병원<NA><NA>0<NA>
9300000030000000102005000120051024<NA>3폐업2폐업20170704<NA><NA><NA>764-0075196.0<NA>서울특별시 종로구 명륜1가 135번지 한신1차아파트4-1506서울특별시 종로구 혜화로 11 (명륜1가)3068성현동물병원2017-07-04 13:54:16I2018-08-31 23:59:59.0<NA>199938.394948453805.179644동물병원<NA><NA>0<NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)축산업무구분명축산물가공업구분명축산일련번호권리주체일련번호총인원
15300000030000000102013000220010604<NA>2휴업1휴업<NA><NA><NA><NA>732-38270.0<NA>서울특별시 종로구 효자동 31번지서울특별시 종로구 자하문로 66-2 (효자동)3042효자동물병원2014-12-31 09:43:33I2018-08-31 23:59:59.0<NA>197364.614477453303.293916동물병원<NA><NA>0<NA>
16300000030000000102013000320010604<NA>2휴업1휴업<NA><NA><NA><NA>732-38270.0<NA>서울특별시 종로구 효자동 31번지서울특별시 종로구 자하문로 66-2 (효자동)3042효자동물병원2014-12-31 09:44:30I2018-08-31 23:59:59.0<NA>197364.614477453303.293916동물병원<NA><NA>0<NA>
17300000030000000102013000420010604<NA>4취소/말소/만료/정지/중지4말소<NA><NA><NA><NA>732-38270.0<NA>서울특별시 종로구 효자동 31번지서울특별시 종로구 자하문로 66-2 (효자동)3042효자동물병원2014-12-31 09:44:57I2018-08-31 23:59:59.0<NA>197364.614477453303.293916동물병원<NA><NA>0<NA>
18300000030000000102013000620130304<NA>3폐업2폐업20181030<NA><NA><NA>732-38270.0<NA>서울특별시 종로구 효자동 31번지서울특별시 종로구 자하문로 66-2 (효자동)3042효자동물병원2018-10-30 14:52:41U2018-11-01 02:36:04.0<NA>197364.614477453303.293916동물병원<NA><NA>0<NA>
19300000030000000102013000720130514<NA>4취소/말소/만료/정지/중지4말소<NA><NA><NA><NA>379-75750.0<NA>서울특별시 종로구 신영동 249-6번지서울특별시 종로구 진흥로 473 (신영동)3007월드펫동물병원2018-06-14 10:56:04I2018-08-31 23:59:59.0<NA>196444.558512455996.128788동물병원<NA><NA>0<NA>
20300000030000000102016000120160211<NA>1영업/정상0정상<NA><NA><NA><NA>722-82750.0<NA>서울특별시 종로구 통인동 147-7 씨에스코즈빌서울특별시 종로구 자하문로 35-3, 씨에스코즈빌 101호 (통인동)3040광화문동물병원2020-07-31 15:26:29U2020-08-02 02:40:00.0<NA>197383.197505452972.118568동물병원<NA><NA>0<NA>
2130000003000000010201700012017-11-16<NA>1영업/정상0정상<NA><NA><NA><NA><NA>0.0<NA>서울특별시 종로구 홍파동 42-13 경희궁자이 2단지 상가동 2229호서울특별시 종로구 송월길 99, 상가동 2층 2229호 (홍파동, 경희궁자이 2단지)3165경희궁 바른 동물병원2023-03-31 09:34:28U2022-12-04 00:02:00.0<NA><NA><NA><NA><NA><NA><NA><NA>
22300000030000000102020000120200517<NA>1영업/정상0정상<NA><NA><NA><NA>02-733-6030326.5<NA>서울특별시 종로구 신교동 70-10번지서울특별시 종로구 자하문로 95, 신교빌딩 1층 (신교동)3032선동물병원2020-05-17 10:59:48I2020-05-19 00:23:19.0<NA>197278.891939453572.355621동물병원<NA><NA>0<NA>
23300000030000000102022000120220613<NA>1영업/정상0정상<NA><NA><NA><NA><NA>136.5<NA>서울특별시 종로구 숭인동 20-138 지1층서울특별시 종로구 낙산길 311, 지1층 (숭인동)3107폴라동물병원2022-06-13 16:55:05I2021-12-05 23:05:00.0<NA>201451.464239453137.690825<NA><NA><NA><NA><NA>
2430000003000000010202300012023-08-21<NA>1영업/정상0정상<NA><NA><NA><NA>02-762-758244.9<NA>서울특별시 종로구 혜화동 53-11 2층서울특별시 종로구 창경궁로35길 19, 2층 (혜화동)3076뉴욕동물병원2023-08-21 09:57:11I2022-12-07 22:03:00.0<NA>200079.663985453836.098563<NA><NA><NA><NA><NA>