Overview

Dataset statistics

Number of variables30
Number of observations82
Missing cells780
Missing cells (%)31.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.8 KiB
Average record size in memory259.6 B

Variable types

Categorical10
Numeric4
DateTime4
Unsupported8
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
총인원 is highly imbalanced (66.9%)Imbalance
인허가취소일자 has 82 (100.0%) missing valuesMissing
폐업일자 has 57 (69.5%) missing valuesMissing
휴업시작일자 has 82 (100.0%) missing valuesMissing
휴업종료일자 has 82 (100.0%) missing valuesMissing
재개업일자 has 82 (100.0%) missing valuesMissing
전화번호 has 34 (41.5%) missing valuesMissing
소재지우편번호 has 82 (100.0%) missing valuesMissing
지번주소 has 3 (3.7%) missing valuesMissing
도로명주소 has 6 (7.3%) missing valuesMissing
도로명우편번호 has 6 (7.3%) missing valuesMissing
업태구분명 has 82 (100.0%) missing valuesMissing
좌표정보(X) has 9 (11.0%) missing valuesMissing
좌표정보(Y) has 9 (11.0%) missing valuesMissing
축산물가공업구분명 has 82 (100.0%) missing valuesMissing
축산일련번호 has 82 (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

Reproduction

Analysis started2024-04-29 19:04:17.160279
Analysis finished2024-04-29 19:04:17.835520
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size788.0 B
3170000
82 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3170000 82
100.0%

Length

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

Common Values (Plot)

2024-04-30T04:04:17.995299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3170000 82
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct82
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.17 × 1017
Minimum3.17 × 1017
Maximum3.17 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size870.0 B
2024-04-30T04:04:18.080939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.17 × 1017
5-th percentile3.17 × 1017
Q13.17 × 1017
median3.17 × 1017
Q33.17 × 1017
95-th percentile3.17 × 1017
Maximum3.17 × 1017
Range200005
Interquartile range (IQR)90048

Descriptive statistics

Standard deviation57980.228
Coefficient of variation (CV)1.8290293 × 10-13
Kurtosis-0.015904286
Mean3.17 × 1017
Median Absolute Deviation (MAD)30016
Skewness-1.0257213
Sum7.547256 × 1018
Variance3.3617068 × 109
MonotonicityStrictly increasing
2024-04-30T04:04:18.209870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
317000001120040001 1
 
1.2%
317000001120220010 1
 
1.2%
317000001120220008 1
 
1.2%
317000001120220007 1
 
1.2%
317000001120220006 1
 
1.2%
317000001120220005 1
 
1.2%
317000001120220004 1
 
1.2%
317000001120220003 1
 
1.2%
317000001120220002 1
 
1.2%
317000001120220001 1
 
1.2%
Other values (72) 72
87.8%
ValueCountFrequency (%)
317000001120040001 1
1.2%
317000001120040002 1
1.2%
317000001120040003 1
1.2%
317000001120040004 1
1.2%
317000001120050001 1
1.2%
317000001120060001 1
1.2%
317000001120060002 1
1.2%
317000001120070001 1
1.2%
317000001120090001 1
1.2%
317000001120100001 1
1.2%
ValueCountFrequency (%)
317000001120240006 1
1.2%
317000001120240005 1
1.2%
317000001120240004 1
1.2%
317000001120240003 1
1.2%
317000001120240002 1
1.2%
317000001120240001 1
1.2%
317000001120230010 1
1.2%
317000001120230009 1
1.2%
317000001120230008 1
1.2%
317000001120230007 1
1.2%

인허가일자
Date

Distinct74
Distinct (%)90.2%
Missing0
Missing (%)0.0%
Memory size788.0 B
Minimum2004-03-30 00:00:00
Maximum2024-03-12 00:00:00
2024-04-30T04:04:18.327018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:04:18.431826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

영업상태코드
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
1
57 
3
25 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 57
69.5%
3 25
30.5%

Length

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

Common Values (Plot)

2024-04-30T04:04:18.627816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 57
69.5%
3 25
30.5%

영업상태명
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
영업/정상
57 
폐업
25 

Length

Max length5
Median length5
Mean length4.0853659
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업/정상 57
69.5%
폐업 25
30.5%

Length

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

Common Values (Plot)

2024-04-30T04:04:18.825308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 57
69.5%
폐업 25
30.5%

상세영업상태코드
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
0
57 
2
25 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 57
69.5%
2 25
30.5%

Length

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

Common Values (Plot)

2024-04-30T04:04:18.998377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 57
69.5%
2 25
30.5%

상세영업상태명
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
정상
57 
폐업
25 

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 (%)
정상 57
69.5%
폐업 25
30.5%

Length

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

Common Values (Plot)

2024-04-30T04:04:19.156329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 57
69.5%
폐업 25
30.5%

폐업일자
Date

MISSING 

Distinct25
Distinct (%)100.0%
Missing57
Missing (%)69.5%
Memory size788.0 B
Minimum2005-06-17 00:00:00
Maximum2024-03-04 00:00:00
2024-04-30T04:04:19.232810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:04:19.320288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

전화번호
Text

MISSING 

Distinct43
Distinct (%)89.6%
Missing34
Missing (%)41.5%
Memory size788.0 B
2024-04-30T04:04:19.492829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length9.5
Min length7

Characters and Unicode

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

Unique38 ?
Unique (%)79.2%

Sample

1st row856-1542
2nd row02-855-3843
3rd row892-8156
4th row805-5957
5th row838-1158
ValueCountFrequency (%)
02-891-1112 2
 
4.2%
892-5949 2
 
4.2%
805-5957 2
 
4.2%
838-1158 2
 
4.2%
804-6985 2
 
4.2%
02-867-4175 1
 
2.1%
02-896-1223 1
 
2.1%
02-6012-9988 1
 
2.1%
02-807-9977 1
 
2.1%
02-866-9228 1
 
2.1%
Other values (33) 33
68.8%
2024-04-30T04:04:19.806318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 68
14.9%
8 65
14.3%
0 60
13.2%
2 48
10.5%
5 40
8.8%
1 36
7.9%
9 30
6.6%
6 30
6.6%
7 28
6.1%
3 26
 
5.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 388
85.1%
Dash Punctuation 68
 
14.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 65
16.8%
0 60
15.5%
2 48
12.4%
5 40
10.3%
1 36
9.3%
9 30
7.7%
6 30
7.7%
7 28
7.2%
3 26
 
6.7%
4 25
 
6.4%
Dash Punctuation
ValueCountFrequency (%)
- 68
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 456
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 68
14.9%
8 65
14.3%
0 60
13.2%
2 48
10.5%
5 40
8.8%
1 36
7.9%
9 30
6.6%
6 30
6.6%
7 28
6.1%
3 26
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 456
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 68
14.9%
8 65
14.3%
0 60
13.2%
2 48
10.5%
5 40
8.8%
1 36
7.9%
9 30
6.6%
6 30
6.6%
7 28
6.1%
3 26
 
5.7%

소재지면적
Categorical

Distinct3
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size788.0 B
<NA>
61 
0.0
20 
120.13
 
1

Length

Max length6
Median length4
Mean length3.7804878
Min length3

Unique

Unique1 ?
Unique (%)1.2%

Sample

1st row0.0
2nd row0.0
3rd row0.0
4th row0.0
5th row120.13

Common Values

ValueCountFrequency (%)
<NA> 61
74.4%
0.0 20
 
24.4%
120.13 1
 
1.2%

Length

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

Common Values (Plot)

2024-04-30T04:04:20.037624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 61
74.4%
0.0 20
 
24.4%
120.13 1
 
1.2%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

지번주소
Text

MISSING 

Distinct66
Distinct (%)83.5%
Missing3
Missing (%)3.7%
Memory size788.0 B
2024-04-30T04:04:20.249155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length33
Mean length24.898734
Min length17

Characters and Unicode

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

Unique

Unique57 ?
Unique (%)72.2%

Sample

1st row서울특별시 금천구 시흥동 837-38 번지
2nd row서울특별시 금천구 독산동 970-31번지
3rd row서울특별시 금천구 독산동 1028 대덕트윈빌
4th row서울특별시 금천구 시흥동 910-4 번지
5th row서울특별시 금천구 시흥동 910-4번지
ValueCountFrequency (%)
서울특별시 79
21.4%
금천구 79
21.4%
시흥동 34
 
9.2%
독산동 26
 
7.0%
가산동 19
 
5.1%
1155 6
 
1.6%
금천롯데캐슬골드파크3차 6
 
1.6%
번지 4
 
1.1%
889-8 3
 
0.8%
883-18 3
 
0.8%
Other values (93) 111
30.0%
2024-04-30T04:04:20.587363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
336
 
17.1%
시 114
 
5.8%
1 91
 
4.6%
금 85
 
4.3%
천 85
 
4.3%
서 80
 
4.1%
동 80
 
4.1%
특 79
 
4.0%
별 79
 
4.0%
구 79
 
4.0%
Other values (95) 859
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1177
59.8%
Decimal Number 377
 
19.2%
Space Separator 336
 
17.1%
Dash Punctuation 65
 
3.3%
Uppercase Letter 11
 
0.6%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 114
 
9.7%
금 85
 
7.2%
천 85
 
7.2%
서 80
 
6.8%
동 80
 
6.8%
특 79
 
6.7%
별 79
 
6.7%
구 79
 
6.7%
울 79
 
6.7%
산 50
 
4.2%
Other values (75) 367
31.2%
Decimal Number
ValueCountFrequency (%)
1 91
24.1%
3 46
12.2%
8 45
11.9%
0 42
11.1%
5 36
 
9.5%
9 34
 
9.0%
4 27
 
7.2%
2 24
 
6.4%
7 20
 
5.3%
6 12
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
C 2
18.2%
H 2
18.2%
I 2
18.2%
Y 2
18.2%
T 1
9.1%
G 1
9.1%
B 1
9.1%
Space Separator
ValueCountFrequency (%)
336
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 65
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1177
59.8%
Common 779
39.6%
Latin 11
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 114
 
9.7%
금 85
 
7.2%
천 85
 
7.2%
서 80
 
6.8%
동 80
 
6.8%
특 79
 
6.7%
별 79
 
6.7%
구 79
 
6.7%
울 79
 
6.7%
산 50
 
4.2%
Other values (75) 367
31.2%
Common
ValueCountFrequency (%)
336
43.1%
1 91
 
11.7%
- 65
 
8.3%
3 46
 
5.9%
8 45
 
5.8%
0 42
 
5.4%
5 36
 
4.6%
9 34
 
4.4%
4 27
 
3.5%
2 24
 
3.1%
Other values (3) 33
 
4.2%
Latin
ValueCountFrequency (%)
C 2
18.2%
H 2
18.2%
I 2
18.2%
Y 2
18.2%
T 1
9.1%
G 1
9.1%
B 1
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1177
59.8%
ASCII 790
40.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
336
42.5%
1 91
 
11.5%
- 65
 
8.2%
3 46
 
5.8%
8 45
 
5.7%
0 42
 
5.3%
5 36
 
4.6%
9 34
 
4.3%
4 27
 
3.4%
2 24
 
3.0%
Other values (10) 44
 
5.6%
Hangul
ValueCountFrequency (%)
시 114
 
9.7%
금 85
 
7.2%
천 85
 
7.2%
서 80
 
6.8%
동 80
 
6.8%
특 79
 
6.7%
별 79
 
6.7%
구 79
 
6.7%
울 79
 
6.7%
산 50
 
4.2%
Other values (75) 367
31.2%

도로명주소
Text

MISSING 

Distinct69
Distinct (%)90.8%
Missing6
Missing (%)7.3%
Memory size788.0 B
2024-04-30T04:04:20.872504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length42
Mean length33.881579
Min length22

Characters and Unicode

Total characters2575
Distinct characters130
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

Unique63 ?
Unique (%)82.9%

Sample

1st row서울특별시 금천구 시흥대로148길 37 (독산동)
2nd row서울특별시 금천구 시흥대로112길 6(독산동, 대덕트윈빌)
3rd row서울특별시 금천구 금하로 710 (시흥동)
4th row서울특별시 금천구 독산로 136 (시흥동)
5th row서울특별시 금천구 시흥대로58길 5 (시흥동)
ValueCountFrequency (%)
서울특별시 76
 
15.5%
금천구 76
 
15.5%
시흥동 29
 
5.9%
독산동 22
 
4.5%
가산동 20
 
4.1%
1층 19
 
3.9%
시흥대로 18
 
3.7%
가산디지털1로 9
 
1.8%
금하로 9
 
1.8%
금천롯데캐슬골드파크3차 8
 
1.6%
Other values (145) 203
41.5%
2024-04-30T04:04:21.293043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
415
 
16.1%
시 132
 
5.1%
1 130
 
5.0%
금 94
 
3.7%
천 84
 
3.3%
동 84
 
3.3%
산 82
 
3.2%
서 78
 
3.0%
구 76
 
3.0%
별 76
 
3.0%
Other values (120) 1324
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1519
59.0%
Space Separator 415
 
16.1%
Decimal Number 402
 
15.6%
Open Punctuation 76
 
3.0%
Close Punctuation 76
 
3.0%
Other Punctuation 66
 
2.6%
Uppercase Letter 13
 
0.5%
Dash Punctuation 7
 
0.3%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 132
 
8.7%
금 94
 
6.2%
천 84
 
5.5%
동 84
 
5.5%
산 82
 
5.4%
서 78
 
5.1%
구 76
 
5.0%
별 76
 
5.0%
특 76
 
5.0%
울 76
 
5.0%
Other values (96) 661
43.5%
Decimal Number
ValueCountFrequency (%)
1 130
32.3%
2 51
 
12.7%
3 41
 
10.2%
0 40
 
10.0%
9 30
 
7.5%
7 27
 
6.7%
6 27
 
6.7%
5 24
 
6.0%
8 17
 
4.2%
4 15
 
3.7%
Uppercase Letter
ValueCountFrequency (%)
C 2
15.4%
Y 2
15.4%
T 2
15.4%
H 2
15.4%
I 2
15.4%
B 1
7.7%
A 1
7.7%
G 1
7.7%
Space Separator
ValueCountFrequency (%)
415
100.0%
Open Punctuation
ValueCountFrequency (%)
( 76
100.0%
Close Punctuation
ValueCountFrequency (%)
) 76
100.0%
Other Punctuation
ValueCountFrequency (%)
, 66
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Lowercase Letter
ValueCountFrequency (%)
b 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1519
59.0%
Common 1042
40.5%
Latin 14
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 132
 
8.7%
금 94
 
6.2%
천 84
 
5.5%
동 84
 
5.5%
산 82
 
5.4%
서 78
 
5.1%
구 76
 
5.0%
별 76
 
5.0%
특 76
 
5.0%
울 76
 
5.0%
Other values (96) 661
43.5%
Common
ValueCountFrequency (%)
415
39.8%
1 130
 
12.5%
( 76
 
7.3%
) 76
 
7.3%
, 66
 
6.3%
2 51
 
4.9%
3 41
 
3.9%
0 40
 
3.8%
9 30
 
2.9%
7 27
 
2.6%
Other values (5) 90
 
8.6%
Latin
ValueCountFrequency (%)
C 2
14.3%
Y 2
14.3%
T 2
14.3%
H 2
14.3%
I 2
14.3%
B 1
7.1%
A 1
7.1%
b 1
7.1%
G 1
7.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1519
59.0%
ASCII 1056
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
415
39.3%
1 130
 
12.3%
( 76
 
7.2%
) 76
 
7.2%
, 66
 
6.2%
2 51
 
4.8%
3 41
 
3.9%
0 40
 
3.8%
9 30
 
2.8%
7 27
 
2.6%
Other values (14) 104
 
9.8%
Hangul
ValueCountFrequency (%)
시 132
 
8.7%
금 94
 
6.2%
천 84
 
5.5%
동 84
 
5.5%
산 82
 
5.4%
서 78
 
5.1%
구 76
 
5.0%
별 76
 
5.0%
특 76
 
5.0%
울 76
 
5.0%
Other values (96) 661
43.5%

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

MISSING 

Distinct46
Distinct (%)60.5%
Missing6
Missing (%)7.3%
Infinite0
Infinite (%)0.0%
Mean8578.5921
Minimum8502
Maximum8655
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size870.0 B
2024-04-30T04:04:21.401886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8502
5-th percentile8505.5
Q18528.75
median8580.5
Q38627.25
95-th percentile8647.25
Maximum8655
Range153
Interquartile range (IQR)98.5

Descriptive statistics

Standard deviation49.540065
Coefficient of variation (CV)0.005774848
Kurtosis-1.374305
Mean8578.5921
Median Absolute Deviation (MAD)47.5
Skewness-0.15612123
Sum651973
Variance2454.2181
MonotonicityNot monotonic
2024-04-30T04:04:21.520301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=46)
ValueCountFrequency (%)
8628 7
 
8.5%
8608 6
 
7.3%
8512 5
 
6.1%
8506 4
 
4.9%
8574 3
 
3.7%
8546 3
 
3.7%
8568 2
 
2.4%
8565 2
 
2.4%
8594 2
 
2.4%
8655 2
 
2.4%
Other values (36) 40
48.8%
(Missing) 6
 
7.3%
ValueCountFrequency (%)
8502 1
 
1.2%
8503 2
 
2.4%
8504 1
 
1.2%
8506 4
4.9%
8511 1
 
1.2%
8512 5
6.1%
8517 1
 
1.2%
8520 1
 
1.2%
8523 1
 
1.2%
8526 1
 
1.2%
ValueCountFrequency (%)
8655 2
 
2.4%
8652 1
 
1.2%
8651 1
 
1.2%
8646 1
 
1.2%
8644 2
 
2.4%
8643 1
 
1.2%
8635 2
 
2.4%
8631 1
 
1.2%
8630 1
 
1.2%
8628 7
8.5%

사업장명
Text

Distinct69
Distinct (%)84.1%
Missing0
Missing (%)0.0%
Memory size788.0 B
2024-04-30T04:04:21.719116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length5.2682927
Min length3

Characters and Unicode

Total characters432
Distinct characters117
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

Unique59 ?
Unique (%)72.0%

Sample

1st row시흥오룡양국
2nd row신보생약국
3rd row토마스약국
4th row은행프라자약국
5th row은행프라자약국
ValueCountFrequency (%)
세명당약국 4
 
4.7%
약국 3
 
3.5%
은행프라자약국 3
 
3.5%
우리캐슬약국 2
 
2.3%
1층메디컬약국 2
 
2.3%
한중약국 2
 
2.3%
가산소중한약국 2
 
2.3%
친친약국 2
 
2.3%
라임약국 2
 
2.3%
조아약국 2
 
2.3%
Other values (61) 62
72.1%
2024-04-30T04:04:22.032236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 82
 
19.0%
국 82
 
19.0%
리 11
 
2.5%
가 8
 
1.9%
온 8
 
1.9%
라 8
 
1.9%
누 7
 
1.6%
중 6
 
1.4%
한 6
 
1.4%
산 6
 
1.4%
Other values (107) 208
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 425
98.4%
Space Separator 4
 
0.9%
Decimal Number 2
 
0.5%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 82
19.3%
국 82
19.3%
리 11
 
2.6%
가 8
 
1.9%
온 8
 
1.9%
라 8
 
1.9%
누 7
 
1.6%
중 6
 
1.4%
한 6
 
1.4%
산 6
 
1.4%
Other values (104) 201
47.3%
Space Separator
ValueCountFrequency (%)
4
100.0%
Decimal Number
ValueCountFrequency (%)
1 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 425
98.4%
Common 7
 
1.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 82
19.3%
국 82
19.3%
리 11
 
2.6%
가 8
 
1.9%
온 8
 
1.9%
라 8
 
1.9%
누 7
 
1.6%
중 6
 
1.4%
한 6
 
1.4%
산 6
 
1.4%
Other values (104) 201
47.3%
Common
ValueCountFrequency (%)
4
57.1%
1 2
28.6%
, 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 425
98.4%
ASCII 7
 
1.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 82
19.3%
국 82
19.3%
리 11
 
2.6%
가 8
 
1.9%
온 8
 
1.9%
라 8
 
1.9%
누 7
 
1.6%
중 6
 
1.4%
한 6
 
1.4%
산 6
 
1.4%
Other values (104) 201
47.3%
ASCII
ValueCountFrequency (%)
4
57.1%
1 2
28.6%
, 1
 
14.3%

최종수정일자
Date

UNIQUE 

Distinct82
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size788.0 B
Minimum2005-06-17 11:45:04
Maximum2024-03-12 09:44:15
2024-04-30T04:04:22.151622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:04:22.268201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
I
59 
U
23 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 59
72.0%
U 23
 
28.0%

Length

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

Common Values (Plot)

2024-04-30T04:04:22.474159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 59
72.0%
u 23
 
28.0%

데이터갱신일자
Date

Distinct55
Distinct (%)67.1%
Missing0
Missing (%)0.0%
Memory size788.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-03 00:06:00
2024-04-30T04:04:22.733181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:04:22.836087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업태구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

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

MISSING 

Distinct60
Distinct (%)82.2%
Missing9
Missing (%)11.0%
Infinite0
Infinite (%)0.0%
Mean190946.53
Minimum189121.48
Maximum192754.35
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size870.0 B
2024-04-30T04:04:22.944712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum189121.48
5-th percentile189434.72
Q1190457.12
median191218.9
Q3191447.81
95-th percentile191894.82
Maximum192754.35
Range3632.8616
Interquartile range (IQR)990.68503

Descriptive statistics

Standard deviation855.57014
Coefficient of variation (CV)0.0044806791
Kurtosis-0.36799705
Mean190946.53
Median Absolute Deviation (MAD)406.75981
Skewness-0.33082985
Sum13939097
Variance732000.26
MonotonicityNot monotonic
2024-04-30T04:04:23.064664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
191234.143902029 3
 
3.7%
191195.659641701 3
 
3.7%
191863.813276462 2
 
2.4%
189877.178943503 2
 
2.4%
189434.721897968 2
 
2.4%
189378.332493727 2
 
2.4%
189917.493331104 2
 
2.4%
190838.324818618 2
 
2.4%
192754.34619252 2
 
2.4%
191549.452179412 2
 
2.4%
Other values (50) 51
62.2%
(Missing) 9
 
11.0%
ValueCountFrequency (%)
189121.484597 1
1.2%
189378.332493727 2
2.4%
189434.721897968 2
2.4%
189452.382474246 1
1.2%
189467.124186925 1
1.2%
189522.336721798 1
1.2%
189685.516219475 1
1.2%
189877.178943503 2
2.4%
189917.493331104 2
2.4%
189920.528610917 1
1.2%
ValueCountFrequency (%)
192754.34619252 2
2.4%
192742.326147617 1
1.2%
191917.450107657 1
1.2%
191879.731412452 1
1.2%
191863.813276462 2
2.4%
191863.3608228 1
1.2%
191854.358906395 1
1.2%
191850.626105531 1
1.2%
191830.380995511 1
1.2%
191786.988598104 1
1.2%

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

MISSING 

Distinct60
Distinct (%)82.2%
Missing9
Missing (%)11.0%
Infinite0
Infinite (%)0.0%
Mean440269.39
Minimum437752.1
Maximum442286.32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size870.0 B
2024-04-30T04:04:23.192337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum437752.1
5-th percentile438685.4
Q1438993.25
median440402.31
Q3441496.95
95-th percentile442077.66
Maximum442286.32
Range4534.2234
Interquartile range (IQR)2503.6958

Descriptive statistics

Standard deviation1300.3469
Coefficient of variation (CV)0.0029535255
Kurtosis-1.3677084
Mean440269.39
Median Absolute Deviation (MAD)1337.1418
Skewness-0.020787693
Sum32139666
Variance1690902
MonotonicityNot monotonic
2024-04-30T04:04:23.307002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
438993.253764531 3
 
3.7%
439065.169432475 3
 
3.7%
440027.754203512 2
 
2.4%
442093.648596802 2
 
2.4%
441862.707622957 2
 
2.4%
442066.99866487 2
 
2.4%
442031.656022304 2
 
2.4%
439761.362000391 2
 
2.4%
438827.143732711 2
 
2.4%
439708.282614605 2
 
2.4%
Other values (50) 51
62.2%
(Missing) 9
 
11.0%
ValueCountFrequency (%)
437752.098773321 1
1.2%
437915.621690013 1
1.2%
438460.667319682 1
1.2%
438663.829528346 1
1.2%
438699.77460936 1
1.2%
438731.508615452 1
1.2%
438732.994399228 1
1.2%
438751.404574684 1
1.2%
438751.842732006 1
1.2%
438755.559027712 1
1.2%
ValueCountFrequency (%)
442286.322159 1
1.2%
442205.867457803 1
1.2%
442093.648596802 2
2.4%
442066.99866487 2
2.4%
442031.656022304 2
2.4%
442026.468974479 1
1.2%
441990.817436962 1
1.2%
441916.081648538 1
1.2%
441862.707622957 2
2.4%
441795.869666667 1
1.2%

축산업무구분명
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
동물약국
45 
<NA>
37 

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동물약국

Common Values

ValueCountFrequency (%)
동물약국 45
54.9%
<NA> 37
45.1%

Length

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

Common Values (Plot)

2024-04-30T04:04:23.512894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물약국 45
54.9%
na 37
45.1%

축산물가공업구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

축산일련번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing82
Missing (%)100.0%
Memory size870.0 B

권리주체일련번호
Categorical

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
0
45 
<NA>
37 

Length

Max length4
Median length1
Mean length2.3536585
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 45
54.9%
<NA> 37
45.1%

Length

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

Common Values (Plot)

2024-04-30T04:04:23.712498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 45
54.9%
na 37
45.1%

총인원
Categorical

IMBALANCE 

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size788.0 B
<NA>
77 
0
 
5

Length

Max length4
Median length4
Mean length3.8170732
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 77
93.9%
0 5
 
6.1%

Length

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

Common Values (Plot)

2024-04-30T04:04:23.891860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 77
93.9%
0 5
 
6.1%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)축산업무구분명축산물가공업구분명축산일련번호권리주체일련번호총인원
0317000031700000112004000120040330<NA>3폐업2폐업20080328<NA><NA><NA><NA>0.0<NA>서울특별시 금천구 시흥동 837-38 번지<NA><NA>시흥오룡양국2008-03-28 11:36:16I2018-08-31 23:59:59.0<NA><NA><NA>동물약국<NA><NA>0<NA>
1317000031700000112004000220040330<NA>1영업/정상0정상<NA><NA><NA><NA>856-15420.0<NA>서울특별시 금천구 독산동 970-31번지서울특별시 금천구 시흥대로148길 37 (독산동)8541신보생약국2012-03-08 14:26:12I2018-08-31 23:59:59.0<NA>191170.000294441436.870721동물약국<NA><NA>0<NA>
2317000031700000112004000320040330<NA>1영업/정상0정상<NA><NA><NA><NA>02-855-38430.0<NA>서울특별시 금천구 독산동 1028 대덕트윈빌서울특별시 금천구 시흥대로112길 6(독산동, 대덕트윈빌)8580토마스약국2021-07-16 13:35:19U2021-07-18 02:40:00.0<NA>191004.699476440576.060452동물약국<NA><NA>00
3317000031700000112004000420041029<NA>3폐업2폐업20050617<NA><NA><NA>892-81560.0<NA>서울특별시 금천구 시흥동 910-4 번지<NA><NA>은행프라자약국2005-06-17 11:45:04I2018-08-31 23:59:59.0<NA><NA><NA>동물약국<NA><NA>0<NA>
4317000031700000112005000120050617<NA>3폐업2폐업20070831<NA><NA><NA>805-5957120.13<NA>서울특별시 금천구 시흥동 910-4번지<NA><NA>은행프라자약국2007-08-31 11:32:50I2018-08-31 23:59:59.0<NA>191830.380996438751.404575동물약국<NA><NA>0<NA>
5317000031700000112006000120060110<NA>3폐업2폐업20121017<NA><NA><NA>838-11580.0<NA>서울특별시 금천구 가산동 151-30번지<NA><NA>가산백화점약국2012-10-17 15:45:02I2018-08-31 23:59:59.0<NA>190481.24245441556.382012동물약국<NA><NA>0<NA>
6317000031700000112006000220060512<NA>3폐업2폐업20090923<NA><NA><NA><NA>0.0<NA>서울특별시 금천구 독산동 1077-33 번지<NA><NA>새소화약국2009-09-23 09:40:18I2018-08-31 23:59:59.0<NA><NA><NA>동물약국<NA><NA>0<NA>
7317000031700000112007000120070913<NA>3폐업2폐업20160723<NA><NA><NA>805-59570.0<NA>서울특별시 금천구 시흥동 911번지서울특별시 금천구 금하로 710 (시흥동)8644은행프라자약국2016-07-27 13:50:59I2018-08-31 23:59:59.0<NA>191850.626106438751.842732동물약국<NA><NA>0<NA>
8317000031700000112009000120091015<NA>3폐업2폐업20201231<NA><NA><NA>804-69850.0<NA>서울특별시 금천구 시흥동 803-3서울특별시 금천구 독산로 136 (시흥동)8568한중약국2020-12-31 09:55:32U2021-01-02 02:40:00.0<NA>191549.452179439708.282615동물약국<NA><NA>0<NA>
9317000031700000112010000120100820<NA>3폐업2폐업20101231<NA><NA><NA>861-33010.0<NA>서울특별시 금천구 독산동 295-10 번지<NA><NA>행복한약국2010-12-31 10:03:00I2018-08-31 23:59:59.0<NA><NA><NA>동물약국<NA><NA>0<NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)축산업무구분명축산물가공업구분명축산일련번호권리주체일련번호총인원
7231700003170000011202300072023-05-01<NA>1영업/정상0정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 금천구 가산동 60-3 대륭포스트타워 5차서울특별시 금천구 디지털로9길 68, 대륭포스트타워 5차 106호 (가산동)8512가산소중한약국2023-10-18 10:22:04U2022-10-30 22:00:00.0<NA>189877.178944442093.648597<NA><NA><NA><NA><NA>
7331700003170000011202300082023-11-20<NA>1영업/정상0정상<NA><NA><NA><NA><NA><NA><NA>서울특별시 금천구 독산동 289-11서울특별시 금천구 두산로 83, 103호 (독산동)8523시온약국2023-11-20 10:00:54I2022-10-31 22:02:00.0<NA>190838.728565440861.516257<NA><NA><NA><NA><NA>
7431700003170000011202300092023-11-23<NA>3폐업2폐업2023-11-28<NA><NA><NA>02-805-5011<NA><NA>서울특별시 금천구 시흥동 830서울특별시 금천구 금하로 711 (시흥동)8574대한약국2023-11-28 10:24:34U2022-10-31 21:00:00.0<NA>191879.731412438779.175342<NA><NA><NA><NA><NA>
7531700003170000011202300102023-12-12<NA>1영업/정상0정상<NA><NA><NA><NA>0507-1325-74400.0<NA>서울특별시 금천구 시흥동 1010 벽산아파트서울특별시 금천구 금하로 793, A동 206호 (시흥동, 벽산아파트)8655벽산온누리약국2023-12-12 14:22:49I2022-11-01 23:04:00.0<NA>192754.346193438827.143733<NA><NA><NA><NA><NA>
7631700003170000011202400012024-01-08<NA>1영업/정상0정상<NA><NA><NA><NA>02-803-3481<NA><NA>서울특별시 금천구 시흥동 883-18서울특별시 금천구 시흥대로 222, 1층 (시흥동)8628세명당약국2024-01-08 10:25:29I2023-11-30 23:00:00.0<NA>191195.659642439065.169432<NA><NA><NA><NA><NA>
7731700003170000011202400022024-01-08<NA>1영업/정상0정상<NA><NA><NA><NA>02-859-6677<NA><NA>서울특별시 금천구 독산동 985서울특별시 금천구 독산로93길 41, 1층 (독산동)8543다원약국2024-01-08 10:50:58I2023-11-30 23:00:00.0<NA>191166.287524441302.206536<NA><NA><NA><NA><NA>
7831700003170000011202400032024-02-13<NA>1영업/정상0정상<NA><NA><NA><NA>02-808-7556<NA><NA>서울특별시 금천구 독산동 1155 금천롯데캐슬골드파크3차서울특별시 금천구 시흥대로 291, 310동 254호 (독산동, 금천롯데캐슬골드파크3차)8608조아약국2024-02-13 09:23:03I2023-12-01 23:05:00.0<NA>190838.324819439761.362<NA><NA><NA><NA><NA>
7931700003170000011202400042024-03-04<NA>1영업/정상0정상<NA><NA><NA><NA>02-891-1112<NA><NA>서울특별시 금천구 시흥동 889-8 비즈메드빌딩서울특별시 금천구 시흥대로 214, 비즈메드빌딩 102호 (시흥동)86281층메디컬약국2024-03-04 09:42:30I2023-12-03 00:06:00.0<NA>191234.143902438993.253765<NA><NA><NA><NA><NA>
8031700003170000011202400052024-03-04<NA>1영업/정상0정상<NA><NA><NA><NA>02-866-9228<NA><NA>서울특별시 금천구 가산동 371-47 이노플렉스1차서울특별시 금천구 가산디지털1로 151, 이노플렉스1차 103-1호 (가산동)8506친친약국2024-03-04 11:34:20I2023-12-03 00:06:00.0<NA>189434.721898441862.707623<NA><NA><NA><NA><NA>
8131700003170000011202400062024-03-12<NA>1영업/정상0정상<NA><NA><NA><NA>02-6264-0715<NA><NA>서울특별시 금천구 독산동 1023-1 서래타운서울특별시 금천구 독산로 233, 102동 101호 (독산동, 서래타운)8581휴베이스정성약국2024-03-12 09:44:15I2023-12-02 23:04:00.0<NA>191227.42228440607.715344<NA><NA><NA><NA><NA>