Overview

Dataset statistics

Number of variables27
Number of observations64
Missing cells585
Missing cells (%)33.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.4 KiB
Average record size in memory230.1 B

Variable types

Categorical8
Numeric5
DateTime6
Unsupported4
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가취소일자 has 64 (100.0%) missing valuesMissing
폐업일자 has 37 (57.8%) missing valuesMissing
휴업시작일자 has 55 (85.9%) missing valuesMissing
휴업종료일자 has 55 (85.9%) missing valuesMissing
재개업일자 has 58 (90.6%) missing valuesMissing
전화번호 has 6 (9.4%) missing valuesMissing
소재지면적 has 27 (42.2%) missing valuesMissing
소재지우편번호 has 64 (100.0%) missing valuesMissing
도로명주소 has 27 (42.2%) missing valuesMissing
도로명우편번호 has 56 (87.5%) missing valuesMissing
좌표정보(X) has 4 (6.2%) missing valuesMissing
좌표정보(Y) has 4 (6.2%) missing valuesMissing
자본금 has 64 (100.0%) missing valuesMissing
거래처 has 64 (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

Reproduction

Analysis started2024-05-11 05:22:45.810841
Analysis finished2024-05-11 05:22:46.276999
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size644.0 B
3050000
64 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3050000 64
100.0%

Length

2024-05-11T14:22:46.371041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:46.489672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3050000 64
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9909456 × 1018
Minimum1.976305 × 1018
Maximum2.010305 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2024-05-11T14:22:46.647884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.976305 × 1018
5-th percentile1.976305 × 1018
Q11.984305 × 1018
median1.992305 × 1018
Q31.994305 × 1018
95-th percentile2.005005 × 1018
Maximum2.010305 × 1018
Range3.4000003 × 1016
Interquartile range (IQR)1 × 1016

Descriptive statistics

Standard deviation8.7891839 × 1015
Coefficient of variation (CV)0.0044145776
Kurtosis-0.5593391
Mean1.9909456 × 1018
Median Absolute Deviation (MAD)6.5 × 1015
Skewness-0.080628539
Sum-1.706688 × 1018
Variance7.7249754 × 1031
MonotonicityStrictly increasing
2024-05-11T14:22:46.839184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1976305008201500002 1
 
1.6%
1992305008201500022 1
 
1.6%
1993305008201500024 1
 
1.6%
1993305008201500025 1
 
1.6%
1993305008201500026 1
 
1.6%
1993305008201500027 1
 
1.6%
1993305008201500028 1
 
1.6%
1993305008201500029 1
 
1.6%
1993305008201500030 1
 
1.6%
1993305008201500031 1
 
1.6%
Other values (54) 54
84.4%
ValueCountFrequency (%)
1976305008201500002 1
1.6%
1976305008201500003 1
1.6%
1976305008201500004 1
1.6%
1976305008201500005 1
1.6%
1976305008201500007 1
1.6%
1976305008201500008 1
1.6%
1976305008201500009 1
1.6%
1976305008201500011 1
1.6%
1976305008201500012 1
1.6%
1979305008201500013 1
1.6%
ValueCountFrequency (%)
2010305011301200001 1
1.6%
2006305008201500011 1
1.6%
2006305008201500010 1
1.6%
2005305008201500001 1
1.6%
2003305008201500036 1
1.6%
2003305008201500027 1
1.6%
2003305008201200003 1
1.6%
2002305008201500002 1
1.6%
2002305008201500001 1
1.6%
2001305008201200001 1
1.6%
Distinct49
Distinct (%)76.6%
Missing0
Missing (%)0.0%
Memory size644.0 B
Minimum1976-04-27 00:00:00
Maximum2010-06-08 00:00:00
2024-05-11T14:22:47.037067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:47.249010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing64
Missing (%)100.0%
Memory size708.0 B
Distinct3
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size644.0 B
3
34 
1
28 
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 34
53.1%
1 28
43.8%
2 2
 
3.1%

Length

2024-05-11T14:22:47.435648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:47.956859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 34
53.1%
1 28
43.8%
2 2
 
3.1%

영업상태명
Categorical

Distinct3
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size644.0 B
폐업
34 
영업/정상
28 
휴업
 
2

Length

Max length5
Median length2
Mean length3.3125
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 34
53.1%
영업/정상 28
43.8%
휴업 2
 
3.1%

Length

2024-05-11T14:22:48.135661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:48.321349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 34
53.1%
영업/정상 28
43.8%
휴업 2
 
3.1%
Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
3
34 
1
21 
6
5
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 34
53.1%
1 21
32.8%
6 7
 
10.9%
5 2
 
3.1%

Length

2024-05-11T14:22:48.500465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:48.693387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 34
53.1%
1 21
32.8%
6 7
 
10.9%
5 2
 
3.1%
Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
폐지
34 
신규등록
21 
휴지사업재개
사업휴지
 
2

Length

Max length6
Median length2
Mean length3.15625
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row폐지
2nd row신규등록
3rd row휴지사업재개
4th row휴지사업재개
5th row신규등록

Common Values

ValueCountFrequency (%)
폐지 34
53.1%
신규등록 21
32.8%
휴지사업재개 7
 
10.9%
사업휴지 2
 
3.1%

Length

2024-05-11T14:22:48.876570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:49.056462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐지 34
53.1%
신규등록 21
32.8%
휴지사업재개 7
 
10.9%
사업휴지 2
 
3.1%

폐업일자
Date

MISSING 

Distinct20
Distinct (%)74.1%
Missing37
Missing (%)57.8%
Memory size644.0 B
Minimum2000-01-01 00:00:00
Maximum2023-03-31 00:00:00
2024-05-11T14:22:49.211178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:49.420300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)

휴업시작일자
Date

MISSING 

Distinct9
Distinct (%)100.0%
Missing55
Missing (%)85.9%
Memory size644.0 B
Minimum2009-02-04 00:00:00
Maximum2024-05-01 00:00:00
2024-05-11T14:22:49.605481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:49.794452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

휴업종료일자
Date

MISSING 

Distinct9
Distinct (%)100.0%
Missing55
Missing (%)85.9%
Memory size644.0 B
Minimum2010-02-03 00:00:00
Maximum2025-04-30 00:00:00
2024-05-11T14:22:49.930507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:50.087811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

재개업일자
Date

MISSING 

Distinct6
Distinct (%)100.0%
Missing58
Missing (%)90.6%
Memory size644.0 B
Minimum2011-03-14 00:00:00
Maximum2024-04-19 00:00:00
2024-05-11T14:22:50.266076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:50.412896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

전화번호
Text

MISSING 

Distinct54
Distinct (%)93.1%
Missing6
Missing (%)9.4%
Memory size644.0 B
2024-05-11T14:22:50.697387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length10.310345
Min length9

Characters and Unicode

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

Unique

Unique50 ?
Unique (%)86.2%

Sample

1st row02 9262677
2nd row02-966-5451
3rd row02 924 5189
4th row070 82564617
5th row02 9669190
ValueCountFrequency (%)
02 26
30.2%
0222427115 2
 
2.3%
0222165151 2
 
2.3%
0222164666 2
 
2.3%
0222441972 2
 
2.3%
9275276 1
 
1.2%
0222172017 1
 
1.2%
9262677 1
 
1.2%
0222152939 1
 
1.2%
22420556 1
 
1.2%
Other values (47) 47
54.7%
2024-05-11T14:22:51.208295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 155
25.9%
0 81
13.5%
6 59
 
9.9%
1 51
 
8.5%
4 49
 
8.2%
9 47
 
7.9%
5 45
 
7.5%
7 33
 
5.5%
33
 
5.5%
8 18
 
3.0%
Other values (2) 27
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 555
92.8%
Space Separator 33
 
5.5%
Dash Punctuation 10
 
1.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 155
27.9%
0 81
14.6%
6 59
 
10.6%
1 51
 
9.2%
4 49
 
8.8%
9 47
 
8.5%
5 45
 
8.1%
7 33
 
5.9%
8 18
 
3.2%
3 17
 
3.1%
Space Separator
ValueCountFrequency (%)
33
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 598
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 155
25.9%
0 81
13.5%
6 59
 
9.9%
1 51
 
8.5%
4 49
 
8.2%
9 47
 
7.9%
5 45
 
7.5%
7 33
 
5.5%
33
 
5.5%
8 18
 
3.0%
Other values (2) 27
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 598
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 155
25.9%
0 81
13.5%
6 59
 
9.9%
1 51
 
8.5%
4 49
 
8.2%
9 47
 
7.9%
5 45
 
7.5%
7 33
 
5.5%
33
 
5.5%
8 18
 
3.0%
Other values (2) 27
 
4.5%

소재지면적
Real number (ℝ)

MISSING 

Distinct34
Distinct (%)91.9%
Missing27
Missing (%)42.2%
Infinite0
Infinite (%)0.0%
Mean841.38054
Minimum208
Maximum2513.3
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2024-05-11T14:22:51.427211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum208
5-th percentile351.56
Q1526
median760
Q3961.25
95-th percentile1704.18
Maximum2513.3
Range2305.3
Interquartile range (IQR)435.25

Descriptive statistics

Standard deviation479.55252
Coefficient of variation (CV)0.56995912
Kurtosis4.1169038
Mean841.38054
Median Absolute Deviation (MAD)234
Skewness1.8209369
Sum31131.08
Variance229970.62
MonotonicityNot monotonic
2024-05-11T14:22:51.620800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
526.0 2
 
3.1%
844.6 2
 
3.1%
512.0 2
 
3.1%
529.0 1
 
1.6%
822.5 1
 
1.6%
661.8 1
 
1.6%
1242.0 1
 
1.6%
1516.7 1
 
1.6%
825.5 1
 
1.6%
365.2 1
 
1.6%
Other values (24) 24
37.5%
(Missing) 27
42.2%
ValueCountFrequency (%)
208.0 1
1.6%
297.0 1
1.6%
365.2 1
1.6%
386.0 1
1.6%
393.0 1
1.6%
447.13 1
1.6%
510.0 1
1.6%
512.0 2
3.1%
526.0 2
3.1%
529.0 1
1.6%
ValueCountFrequency (%)
2513.3 1
1.6%
2161.7 1
1.6%
1589.8 1
1.6%
1516.7 1
1.6%
1242.0 1
1.6%
1162.0 1
1.6%
1138.0 1
1.6%
1035.05 1
1.6%
1003.0 1
1.6%
961.25 1
1.6%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing64
Missing (%)100.0%
Memory size708.0 B
Distinct63
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size644.0 B
2024-05-11T14:22:51.991573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length34
Mean length22.625
Min length18

Characters and Unicode

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

Unique

Unique62 ?
Unique (%)96.9%

Sample

1st row서울특별시 동대문구 신설동 92-27 92-27.36.37.62.96.1효
2nd row서울특별시 동대문구 용두동 40-9
3rd row서울특별시 동대문구 제기동 136-237
4th row서울특별시 동대문구 전농동 26-5
5th row서울특별시 동대문구 청량리동 205-86
ValueCountFrequency (%)
서울특별시 64
23.6%
동대문구 64
23.6%
장안동 14
 
5.2%
용두동 10
 
3.7%
휘경동 8
 
3.0%
전농동 7
 
2.6%
이문동 7
 
2.6%
답십리동 6
 
2.2%
제기동 6
 
2.2%
청량리동 4
 
1.5%
Other values (74) 81
29.9%
2024-05-11T14:22:52.549889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
242
16.7%
129
 
8.9%
71
 
4.9%
65
 
4.5%
64
 
4.4%
64
 
4.4%
64
 
4.4%
- 64
 
4.4%
64
 
4.4%
64
 
4.4%
Other values (52) 557
38.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 816
56.4%
Decimal Number 318
 
22.0%
Space Separator 242
 
16.7%
Dash Punctuation 64
 
4.4%
Other Punctuation 8
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
129
15.8%
71
8.7%
65
8.0%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
14
 
1.7%
Other values (38) 153
18.8%
Decimal Number
ValueCountFrequency (%)
1 58
18.2%
3 42
13.2%
2 41
12.9%
5 37
11.6%
6 30
9.4%
4 26
8.2%
7 23
 
7.2%
0 21
 
6.6%
8 20
 
6.3%
9 20
 
6.3%
Other Punctuation
ValueCountFrequency (%)
. 7
87.5%
, 1
 
12.5%
Space Separator
ValueCountFrequency (%)
242
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 816
56.4%
Common 632
43.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
129
15.8%
71
8.7%
65
8.0%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
14
 
1.7%
Other values (38) 153
18.8%
Common
ValueCountFrequency (%)
242
38.3%
- 64
 
10.1%
1 58
 
9.2%
3 42
 
6.6%
2 41
 
6.5%
5 37
 
5.9%
6 30
 
4.7%
4 26
 
4.1%
7 23
 
3.6%
0 21
 
3.3%
Other values (4) 48
 
7.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 816
56.4%
ASCII 632
43.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
242
38.3%
- 64
 
10.1%
1 58
 
9.2%
3 42
 
6.6%
2 41
 
6.5%
5 37
 
5.9%
6 30
 
4.7%
4 26
 
4.1%
7 23
 
3.6%
0 21
 
3.3%
Other values (4) 48
 
7.6%
Hangul
ValueCountFrequency (%)
129
15.8%
71
8.7%
65
8.0%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
64
7.8%
14
 
1.7%
Other values (38) 153
18.8%

도로명주소
Text

MISSING 

Distinct36
Distinct (%)97.3%
Missing27
Missing (%)42.2%
Memory size644.0 B
2024-05-11T14:22:52.915177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length31
Mean length25.810811
Min length23

Characters and Unicode

Total characters955
Distinct characters76
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

Unique35 ?
Unique (%)94.6%

Sample

1st row서울특별시 동대문구 고산자로 405 (용두동)
2nd row서울특별시 동대문구 안암로 168 (제기동)
3rd row서울특별시 동대문구 전농로 121 (전농동)
4th row서울특별시 동대문구 홍릉로 87 (청량리동)
5th row서울특별시 동대문구 왕산로 289 (청량리동)
ValueCountFrequency (%)
서울특별시 37
19.5%
동대문구 37
19.5%
전농동 6
 
3.2%
제기동 5
 
2.6%
휘경동 5
 
2.6%
이문동 5
 
2.6%
망우로 4
 
2.1%
한천로 4
 
2.1%
장안동 4
 
2.1%
용두동 4
 
2.1%
Other values (65) 79
41.6%
2024-05-11T14:22:53.517897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
153
 
16.0%
76
 
8.0%
44
 
4.6%
43
 
4.5%
38
 
4.0%
38
 
4.0%
38
 
4.0%
) 38
 
4.0%
( 37
 
3.9%
37
 
3.9%
Other values (66) 413
43.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 610
63.9%
Space Separator 153
 
16.0%
Decimal Number 110
 
11.5%
Close Punctuation 38
 
4.0%
Open Punctuation 37
 
3.9%
Other Punctuation 5
 
0.5%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
76
12.5%
44
 
7.2%
43
 
7.0%
38
 
6.2%
38
 
6.2%
38
 
6.2%
37
 
6.1%
37
 
6.1%
37
 
6.1%
37
 
6.1%
Other values (51) 185
30.3%
Decimal Number
ValueCountFrequency (%)
1 20
18.2%
2 17
15.5%
3 15
13.6%
5 12
10.9%
0 10
9.1%
4 9
8.2%
8 8
 
7.3%
7 7
 
6.4%
9 6
 
5.5%
6 6
 
5.5%
Space Separator
ValueCountFrequency (%)
153
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Open Punctuation
ValueCountFrequency (%)
( 37
100.0%
Other Punctuation
ValueCountFrequency (%)
, 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 610
63.9%
Common 345
36.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
76
12.5%
44
 
7.2%
43
 
7.0%
38
 
6.2%
38
 
6.2%
38
 
6.2%
37
 
6.1%
37
 
6.1%
37
 
6.1%
37
 
6.1%
Other values (51) 185
30.3%
Common
ValueCountFrequency (%)
153
44.3%
) 38
 
11.0%
( 37
 
10.7%
1 20
 
5.8%
2 17
 
4.9%
3 15
 
4.3%
5 12
 
3.5%
0 10
 
2.9%
4 9
 
2.6%
8 8
 
2.3%
Other values (5) 26
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 610
63.9%
ASCII 345
36.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
153
44.3%
) 38
 
11.0%
( 37
 
10.7%
1 20
 
5.8%
2 17
 
4.9%
3 15
 
4.3%
5 12
 
3.5%
0 10
 
2.9%
4 9
 
2.6%
8 8
 
2.3%
Other values (5) 26
 
7.5%
Hangul
ValueCountFrequency (%)
76
12.5%
44
 
7.2%
43
 
7.0%
38
 
6.2%
38
 
6.2%
38
 
6.2%
37
 
6.1%
37
 
6.1%
37
 
6.1%
37
 
6.1%
Other values (51) 185
30.3%

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

MISSING 

Distinct8
Distinct (%)100.0%
Missing56
Missing (%)87.5%
Infinite0
Infinite (%)0.0%
Mean2540
Minimum2425
Maximum2629
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2024-05-11T14:22:53.724986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2425
5-th percentile2449.15
Q12500.75
median2544.5
Q32584
95-th percentile2619.55
Maximum2629
Range204
Interquartile range (IQR)83.25

Descriptive statistics

Standard deviation65.487185
Coefficient of variation (CV)0.025782356
Kurtosis-0.036988332
Mean2540
Median Absolute Deviation (MAD)46
Skewness-0.45420241
Sum20320
Variance4288.5714
MonotonicityNot monotonic
2024-05-11T14:22:53.872674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2602 1
 
1.6%
2425 1
 
1.6%
2494 1
 
1.6%
2629 1
 
1.6%
2550 1
 
1.6%
2578 1
 
1.6%
2503 1
 
1.6%
2539 1
 
1.6%
(Missing) 56
87.5%
ValueCountFrequency (%)
2425 1
1.6%
2494 1
1.6%
2503 1
1.6%
2539 1
1.6%
2550 1
1.6%
2578 1
1.6%
2602 1
1.6%
2629 1
1.6%
ValueCountFrequency (%)
2629 1
1.6%
2602 1
1.6%
2578 1
1.6%
2550 1
1.6%
2539 1
1.6%
2503 1
1.6%
2494 1
1.6%
2425 1
1.6%
Distinct62
Distinct (%)96.9%
Missing0
Missing (%)0.0%
Memory size644.0 B
2024-05-11T14:22:54.254439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length17
Mean length7.3125
Min length2

Characters and Unicode

Total characters468
Distinct characters111
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

Unique60 ?
Unique (%)93.8%

Sample

1st row신설동주유소
2nd row대성산업(주) 동마장주유소
3rd row풍한주유소
4th row재정주유소
5th row(주)홍릉주유소
ValueCountFrequency (%)
동부주유소 2
 
2.5%
삼원주유소 2
 
2.5%
주)안국에너지 2
 
2.5%
대성산업(주 2
 
2.5%
sk스피드주유소 1
 
1.3%
주)재건에너지 1
 
1.3%
한덕주유소 1
 
1.3%
동서울고속주유소 1
 
1.3%
용일주유소 1
 
1.3%
재원에너지(주 1
 
1.3%
Other values (65) 65
82.3%
2024-05-11T14:22:54.910325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
57
 
12.2%
55
 
11.8%
37
 
7.9%
( 18
 
3.8%
) 18
 
3.8%
17
 
3.6%
16
 
3.4%
15
 
3.2%
14
 
3.0%
13
 
2.8%
Other values (101) 208
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 409
87.4%
Open Punctuation 18
 
3.8%
Close Punctuation 18
 
3.8%
Space Separator 15
 
3.2%
Uppercase Letter 6
 
1.3%
Decimal Number 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
57
 
13.9%
55
 
13.4%
37
 
9.0%
17
 
4.2%
16
 
3.9%
14
 
3.4%
13
 
3.2%
12
 
2.9%
11
 
2.7%
8
 
2.0%
Other values (92) 169
41.3%
Uppercase Letter
ValueCountFrequency (%)
K 2
33.3%
S 2
33.3%
G 1
16.7%
L 1
16.7%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
3 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Space Separator
ValueCountFrequency (%)
15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 409
87.4%
Common 53
 
11.3%
Latin 6
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
57
 
13.9%
55
 
13.4%
37
 
9.0%
17
 
4.2%
16
 
3.9%
14
 
3.4%
13
 
3.2%
12
 
2.9%
11
 
2.7%
8
 
2.0%
Other values (92) 169
41.3%
Common
ValueCountFrequency (%)
( 18
34.0%
) 18
34.0%
15
28.3%
2 1
 
1.9%
3 1
 
1.9%
Latin
ValueCountFrequency (%)
K 2
33.3%
S 2
33.3%
G 1
16.7%
L 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 409
87.4%
ASCII 59
 
12.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
57
 
13.9%
55
 
13.4%
37
 
9.0%
17
 
4.2%
16
 
3.9%
14
 
3.4%
13
 
3.2%
12
 
2.9%
11
 
2.7%
8
 
2.0%
Other values (92) 169
41.3%
ASCII
ValueCountFrequency (%)
( 18
30.5%
) 18
30.5%
15
25.4%
K 2
 
3.4%
S 2
 
3.4%
2 1
 
1.7%
G 1
 
1.7%
L 1
 
1.7%
3 1
 
1.7%

최종수정일자
Date

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
Minimum2006-02-28 00:00:00
Maximum2024-05-02 17:08:42
2024-05-11T14:22:55.165092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:55.431308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct2
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size644.0 B
U
36 
I
28 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
U 36
56.2%
I 28
43.8%

Length

2024-05-11T14:22:55.655699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:55.836742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
u 36
56.2%
i 28
43.8%
Distinct24
Distinct (%)37.5%
Missing0
Missing (%)0.0%
Memory size644.0 B
2018-08-31 23:59:59.0
28 
2021-12-06 00:09:00.0
2022-11-30 22:00:00.0
2022-12-05 21:00:00.0
2021-06-30 02:40:00.0
 
2
Other values (19)
21 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique17 ?
Unique (%)26.6%

Sample

1st row2018-08-31 23:59:59.0
2nd row2021-12-06 00:09:00.0
3rd row2021-12-06 00:09:00.0
4th row2022-01-22 02:40:00.0
5th row2021-12-05 21:00:00.0

Common Values

ValueCountFrequency (%)
2018-08-31 23:59:59.0 28
43.8%
2021-12-06 00:09:00.0 5
 
7.8%
2022-11-30 22:00:00.0 5
 
7.8%
2022-12-05 21:00:00.0 3
 
4.7%
2021-06-30 02:40:00.0 2
 
3.1%
2021-12-06 22:08:00.0 2
 
3.1%
2022-11-30 23:06:00.0 2
 
3.1%
2021-07-09 02:40:00.0 1
 
1.6%
2022-01-22 02:40:00.0 1
 
1.6%
2021-12-05 21:00:00.0 1
 
1.6%
Other values (14) 14
21.9%

Length

2024-05-11T14:22:55.984139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2018-08-31 28
21.9%
23:59:59.0 28
21.9%
2022-11-30 8
 
6.2%
02:40:00.0 8
 
6.2%
2021-12-06 7
 
5.5%
00:09:00.0 6
 
4.7%
22:00:00.0 5
 
3.9%
21:00:00.0 4
 
3.1%
22:08:00.0 3
 
2.3%
2022-12-05 3
 
2.3%
Other values (26) 28
21.9%

업태구분명
Categorical

Distinct3
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size644.0 B
주유소
39 
일반판매소
22 
용제판매소
 
3

Length

Max length5
Median length3
Mean length3.78125
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주유소
2nd row주유소
3rd row주유소
4th row주유소
5th row주유소

Common Values

ValueCountFrequency (%)
주유소 39
60.9%
일반판매소 22
34.4%
용제판매소 3
 
4.7%

Length

2024-05-11T14:22:56.161834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:56.340687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 39
60.9%
일반판매소 22
34.4%
용제판매소 3
 
4.7%

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

MISSING 

Distinct55
Distinct (%)91.7%
Missing4
Missing (%)6.2%
Infinite0
Infinite (%)0.0%
Mean204611.4
Minimum202162.52
Maximum206478
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2024-05-11T14:22:56.512925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum202162.52
5-th percentile202408.12
Q1203369.66
median204990.81
Q3205672.05
95-th percentile206063.75
Maximum206478
Range4315.4785
Interquartile range (IQR)2302.3905

Descriptive statistics

Standard deviation1271.8922
Coefficient of variation (CV)0.0062161355
Kurtosis-1.1102196
Mean204611.4
Median Absolute Deviation (MAD)905.64792
Skewness-0.50405767
Sum12276684
Variance1617709.8
MonotonicityNot monotonic
2024-05-11T14:22:56.745859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
205377.431831779 2
 
3.1%
206063.752810253 2
 
3.1%
205518.080890579 2
 
3.1%
205664.324409611 2
 
3.1%
205386.3391499 2
 
3.1%
203263.557393993 1
 
1.6%
202410.388286235 1
 
1.6%
202162.522822675 1
 
1.6%
202532.440558463 1
 
1.6%
205987.067570254 1
 
1.6%
Other values (45) 45
70.3%
(Missing) 4
 
6.2%
ValueCountFrequency (%)
202162.522822675 1
1.6%
202193.511960331 1
1.6%
202365.012759151 1
1.6%
202410.388286235 1
1.6%
202532.440558463 1
1.6%
202572.480304067 1
1.6%
202650.009041038 1
1.6%
202794.023804738 1
1.6%
202929.480858008 1
1.6%
203111.040081449 1
1.6%
ValueCountFrequency (%)
206478.001297999 1
1.6%
206361.170131484 1
1.6%
206063.752810253 2
3.1%
206035.720178201 1
1.6%
206010.215000823 1
1.6%
205987.067570254 1
1.6%
205941.750825049 1
1.6%
205938.507488273 1
1.6%
205903.356713794 1
1.6%
205870.721417915 1
1.6%

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

MISSING 

Distinct55
Distinct (%)91.7%
Missing4
Missing (%)6.2%
Infinite0
Infinite (%)0.0%
Mean453026.13
Minimum450990.78
Maximum455698.62
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size708.0 B
2024-05-11T14:22:56.994124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum450990.78
5-th percentile451106.99
Q1452015.74
median452874.41
Q3453858.31
95-th percentile455372.45
Maximum455698.62
Range4707.8359
Interquartile range (IQR)1842.5772

Descriptive statistics

Standard deviation1242.8611
Coefficient of variation (CV)0.0027434644
Kurtosis-0.45589033
Mean453026.13
Median Absolute Deviation (MAD)899.37565
Skewness0.37685937
Sum27181568
Variance1544703.6
MonotonicityNot monotonic
2024-05-11T14:22:57.265980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
451112.370883917 2
 
3.1%
450990.782258934 2
 
3.1%
454209.95759739 2
 
3.1%
451975.036039262 2
 
3.1%
455698.618208393 2
 
3.1%
452379.200327814 1
 
1.6%
453236.227624898 1
 
1.6%
452158.56818082 1
 
1.6%
452018.964174605 1
 
1.6%
451004.764350926 1
 
1.6%
Other values (45) 45
70.3%
(Missing) 4
 
6.2%
ValueCountFrequency (%)
450990.782258934 2
3.1%
451004.764350926 1
1.6%
451112.370883917 2
3.1%
451324.249313797 1
1.6%
451633.697664393 1
1.6%
451645.270581134 1
1.6%
451850.933336121 1
1.6%
451861.665766823 1
1.6%
451868.839862804 1
1.6%
451975.036039262 2
3.1%
ValueCountFrequency (%)
455698.618208393 2
3.1%
455646.698112552 1
1.6%
455358.018155144 1
1.6%
455195.9389813 1
1.6%
455027.043547087 1
1.6%
454465.795874125 1
1.6%
454326.558995892 1
1.6%
454256.30749021 1
1.6%
454209.95759739 2
3.1%
454108.779719723 1
1.6%

자본금
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing64
Missing (%)100.0%
Memory size708.0 B

거래처
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing64
Missing (%)100.0%
Memory size708.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
03050000197630500820150000219760508<NA>3폐업3폐지20100428<NA><NA><NA>02 92626772161.7<NA>서울특별시 동대문구 신설동 92-27 92-27.36.37.62.96.1효<NA><NA>신설동주유소2010-04-28 10:09:09I2018-08-31 23:59:59.0주유소<NA><NA><NA><NA>
13050000197630500820150000319760526<NA>1영업/정상1신규등록<NA><NA><NA><NA>02-966-54512513.3<NA>서울특별시 동대문구 용두동 40-9서울특별시 동대문구 고산자로 405 (용두동)<NA>대성산업(주) 동마장주유소2022-06-07 15:18:20U2021-12-06 00:09:00.0주유소203331.947102452924.869125<NA><NA>
23050000197630500820150000419760531<NA>1영업/정상6휴지사업재개<NA>20110801201201312011121002 924 5189726.15<NA>서울특별시 동대문구 제기동 136-237서울특별시 동대문구 안암로 168 (제기동)<NA>풍한주유소2022-06-07 15:14:20U2021-12-06 00:09:00.0주유소203111.040081454105.546246<NA><NA>
33050000197630500820150000519760427<NA>1영업/정상6휴지사업재개<NA>201208222012102220121022070 82564617393.0<NA>서울특별시 동대문구 전농동 26-5서울특별시 동대문구 전농로 121 (전농동)<NA>재정주유소2022-01-20 15:24:10U2022-01-22 02:40:00.0주유소205004.411928452602.634402<NA><NA>
43050000197630500820150000719760524<NA>1영업/정상1신규등록<NA><NA><NA><NA>02 9669190630.0<NA>서울특별시 동대문구 청량리동 205-86서울특별시 동대문구 홍릉로 87 (청량리동)<NA>(주)홍릉주유소2022-06-28 09:51:18U2021-12-05 21:00:00.0주유소203698.354286453959.827646<NA><NA>
5305000019763050082015000081976-05-26<NA>2휴업5사업휴지<NA>2024-05-012025-04-30<NA>02-966-9400961.25<NA>서울특별시 동대문구 청량리동 18-46서울특별시 동대문구 왕산로 289 (청량리동)<NA>대성산업(주) 청량리주유소2024-05-02 17:08:42U2023-12-05 00:04:00.0주유소204492.404369453792.093526<NA><NA>
63050000197630500820150000919760524<NA>3폐업3폐지20000101<NA><NA><NA>02 9624101797.0<NA>서울특별시 동대문구 이문동 341-32<NA><NA>동진상사동부주유소2017-11-24 11:23:01I2018-08-31 23:59:59.0주유소204977.200864454465.795874<NA><NA>
73050000197630500820150001119760524<NA>1영업/정상1신규등록<NA><NA><NA><NA>0222441972512.0<NA>서울특별시 동대문구 휘경동 275-6서울특별시 동대문구 망우로 90 (휘경동)<NA>(주)안국에너지 삼원주유소2021-06-28 14:55:17U2021-06-30 02:40:00.0주유소205518.080891454209.957597<NA><NA>
8305000019763050082015000121976-05-26<NA>1영업/정상6휴지사업재개<NA>2011-08-122012-02-13<NA>02 22425145873.0<NA>서울특별시 동대문구 휘경동 34-10서울특별시 동대문구 망우로 126 (휘경동)<NA>(주) 파랑에너지2023-12-07 17:57:26U2022-11-02 00:09:00.0주유소205852.529249454326.558996<NA><NA>
93050000197930500820150001319790824<NA>3폐업3폐지<NA><NA><NA><NA>02224495721003.0<NA>서울특별시 동대문구 장안동 284-1<NA><NA>동부주유소2006-07-21 00:00:00I2018-08-31 23:59:59.0주유소206478.001298453115.33976<NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
543050000200130500820120000120010820<NA>1영업/정상1신규등록<NA><NA><NA><NA><NA><NA><NA>서울특별시 동대문구 제기동 135-152서울특별시 동대문구 제기로 27 (제기동, 135-152))<NA>주식회사 미래에너지2023-01-18 17:49:18U2022-11-30 22:00:00.0일반판매소203122.450942453822.477847<NA><NA>
553050000200230500820150000120021126<NA>3폐업3폐지20140201<NA><NA><NA>0222164666<NA><NA>서울특별시 동대문구 장안동 415-15<NA><NA>현대오일뱅크(주)직영 한천주유소2018-02-19 13:42:37I2018-08-31 23:59:59.0주유소205377.431832451112.370884<NA><NA>
56305000020023050082015000022002-12-04<NA>1영업/정상6휴지사업재개<NA><NA><NA>2024-04-19029656006526.0<NA>서울특별시 동대문구 이문동 255-119서울특별시 동대문구 이문로 191 (이문동)<NA>경동주유소2024-04-18 17:01:40U2023-12-03 22:02:00.0주유소205386.33915455698.618208<NA><NA>
573050000200330500820120000320030725<NA>1영업/정상1신규등록<NA><NA><NA><NA><NA><NA><NA>서울특별시 동대문구 청량리동 56-7서울특별시 동대문구 왕산로43다길 6 (청량리동)<NA>동신2013-11-11 17:23:48I2018-08-31 23:59:59.0일반판매소204092.060879453748.949544<NA><NA>
58305000020033050082015000271993-12-16<NA>1영업/정상1신규등록<NA><NA><NA><NA>0222165151844.6<NA>서울특별시 동대문구 장안동 466-8서울특별시 동대문구 천호대로 453 (장안동)<NA>에이치디현대오일뱅크(주)직영 스피드주유소2023-04-13 10:38:23U2022-12-03 23:05:00.0주유소206063.75281450990.782259<NA><NA>
593050000200330500820150003620030718<NA>3폐업3폐지20170719<NA><NA><NA>02224271151162.0<NA>서울특별시 동대문구 장안동 164-2<NA><NA>SK글로벌(주) 공유주유소2018-02-19 13:45:43I2018-08-31 23:59:59.0주유소205664.32441451975.036039<NA><NA>
603050000200530500820150000120051228<NA>3폐업3폐지<NA><NA><NA><NA><NA><NA><NA>서울특별시 동대문구 답십리동 36-15 6통5반<NA><NA>구정2006-02-28 00:00:00I2018-08-31 23:59:59.0용제판매소205087.566812452090.417123<NA><NA>
613050000200630500820150001020060414<NA>1영업/정상1신규등록<NA><NA><NA><NA>0222441972512.0<NA>서울특별시 동대문구 휘경동 275-6서울특별시 동대문구 망우로 90 (휘경동)<NA>(주)안국에너지 삼원주유소2022-07-26 13:48:19U2021-12-06 22:08:00.0주유소205518.080891454209.957597<NA><NA>
623050000200630500820150001120060725<NA>3폐업3폐지<NA><NA><NA><NA>02 9220967<NA><NA>서울특별시 동대문구 용두동 100-1 대명랜드마크 1710호<NA><NA>하리켐2010-08-09 14:12:54I2018-08-31 23:59:59.0용제판매소202929.480858452835.105671<NA><NA>
633050000201030501130120000120100608<NA>1영업/정상1신규등록<NA><NA><NA><NA><NA><NA><NA>서울특별시 동대문구 제기동 135-58서울특별시 동대문구 제기로 27 (제기동)<NA>(주)한솔에너지2023-01-18 17:44:42U2022-11-30 22:00:00.0일반판매소203113.394536453824.476092<NA><NA>