Overview

Dataset statistics

Number of variables27
Number of observations35
Missing cells303
Missing cells (%)32.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.9 KiB
Average record size in memory231.8 B

Variable types

Categorical7
Numeric4
DateTime7
Unsupported5
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
재개업일자 has constant value ""Constant
인허가취소일자 has 35 (100.0%) missing valuesMissing
폐업일자 has 20 (57.1%) missing valuesMissing
휴업시작일자 has 31 (88.6%) missing valuesMissing
휴업종료일자 has 31 (88.6%) missing valuesMissing
재개업일자 has 34 (97.1%) missing valuesMissing
전화번호 has 1 (2.9%) missing valuesMissing
소재지면적 has 11 (31.4%) missing valuesMissing
소재지우편번호 has 35 (100.0%) missing valuesMissing
도로명우편번호 has 35 (100.0%) missing valuesMissing
자본금 has 35 (100.0%) missing valuesMissing
거래처 has 35 (100.0%) missing valuesMissing
관리번호 has unique valuesUnique
지번주소 has unique valuesUnique
도로명주소 has unique valuesUnique
최종수정일자 has unique valuesUnique
좌표정보(X) has unique valuesUnique
좌표정보(Y) 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

Reproduction

Analysis started2024-05-11 05:23:56.080122
Analysis finished2024-05-11 05:23:56.644989
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
3090000
35 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3090000 35
100.0%

Length

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

Common Values (Plot)

2024-05-11T14:23:56.952386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3090000 35
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9923947 × 1018
Minimum1.968309 × 1018
Maximum2.009309 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2024-05-11T14:23:57.130417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.968309 × 1018
5-th percentile1.970309 × 1018
Q11.990309 × 1018
median1.993309 × 1018
Q31.996309 × 1018
95-th percentile2.005609 × 1018
Maximum2.009309 × 1018
Range4.1000002 × 1016
Interquartile range (IQR)6 × 1015

Descriptive statistics

Standard deviation9.1663435 × 1015
Coefficient of variation (CV)0.0046006664
Kurtosis1.8989717
Mean1.9923947 × 1018
Median Absolute Deviation (MAD)3 × 1015
Skewness-1.1494585
Sum-4.053161 × 1018
Variance8.4021853 × 1031
MonotonicityStrictly increasing
2024-05-11T14:23:57.372468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
1968309008701500001 1
 
2.9%
1970309008701500001 1
 
2.9%
1994309010501500002 1
 
2.9%
1995309008701500001 1
 
2.9%
1995309008701500002 1
 
2.9%
1995309010501500003 1
 
2.9%
1996309008701500002 1
 
2.9%
1996309010501200002 1
 
2.9%
1996309010501200010 1
 
2.9%
1996309010501500001 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
1968309008701500001 1
2.9%
1970309008701500001 1
2.9%
1970309010501500002 1
2.9%
1976309008701500001 1
2.9%
1986309008701500001 1
2.9%
1988309010501500001 1
2.9%
1989309008701500001 1
2.9%
1989309008701500002 1
2.9%
1990309010501200001 1
2.9%
1990309010501200002 1
2.9%
ValueCountFrequency (%)
2009309010501500952 1
2.9%
2006309008701200001 1
2.9%
2005309008701200002 1
2.9%
2001309010501200818 1
2.9%
2000309010501200005 1
2.9%
1999309010501200004 1
2.9%
1997309010501200001 1
2.9%
1996309010501500001 1
2.9%
1996309010501200010 1
2.9%
1996309010501200002 1
2.9%

인허가일자
Date

Distinct29
Distinct (%)82.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum1968-11-06 00:00:00
Maximum2009-01-30 00:00:00
2024-05-11T14:23:57.604106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:23:57.842015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

영업상태코드
Categorical

Distinct3
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size412.0 B
1
18 
3
16 
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
1 18
51.4%
3 16
45.7%
2 1
 
2.9%

Length

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

Common Values (Plot)

2024-05-11T14:23:58.324779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 18
51.4%
3 16
45.7%
2 1
 
2.9%

영업상태명
Categorical

Distinct3
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size412.0 B
영업/정상
18 
폐업
16 
휴업
 
1

Length

Max length5
Median length5
Mean length3.5428571
Min length2

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
영업/정상 18
51.4%
폐업 16
45.7%
휴업 1
 
2.9%

Length

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

Common Values (Plot)

2024-05-11T14:23:58.746347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 18
51.4%
폐업 16
45.7%
휴업 1
 
2.9%

상세영업상태코드
Categorical

Distinct5
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size412.0 B
3
16 
1
8 
7
7 
6
3 
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
3 16
45.7%
1 8
22.9%
7 7
20.0%
6 3
 
8.6%
5 1
 
2.9%

Length

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

Common Values (Plot)

2024-05-11T14:23:59.084589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 16
45.7%
1 8
22.9%
7 7
20.0%
6 3
 
8.6%
5 1
 
2.9%

상세영업상태명
Categorical

Distinct5
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size412.0 B
폐지
16 
신규등록
8 
영업개시
7 
휴지사업재개
3 
사업휴지
 
1

Length

Max length6
Median length4
Mean length3.2571429
Min length2

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
폐지 16
45.7%
신규등록 8
22.9%
영업개시 7
20.0%
휴지사업재개 3
 
8.6%
사업휴지 1
 
2.9%

Length

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

Common Values (Plot)

2024-05-11T14:23:59.497858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐지 16
45.7%
신규등록 8
22.9%
영업개시 7
20.0%
휴지사업재개 3
 
8.6%
사업휴지 1
 
2.9%

폐업일자
Date

MISSING 

Distinct15
Distinct (%)100.0%
Missing20
Missing (%)57.1%
Memory size412.0 B
Minimum2009-08-17 00:00:00
Maximum2023-05-24 00:00:00
2024-05-11T14:23:59.704504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:23:59.923540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)

휴업시작일자
Date

MISSING 

Distinct4
Distinct (%)100.0%
Missing31
Missing (%)88.6%
Memory size412.0 B
Minimum2009-10-10 00:00:00
Maximum2024-05-01 00:00:00
2024-05-11T14:24:00.105139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:24:00.309208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

휴업종료일자
Date

MISSING 

Distinct4
Distinct (%)100.0%
Missing31
Missing (%)88.6%
Memory size412.0 B
Minimum2010-05-30 00:00:00
Maximum2025-04-30 00:00:00
2024-05-11T14:24:00.552187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:24:00.777001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

재개업일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing34
Missing (%)97.1%
Memory size412.0 B
Minimum2018-06-22 00:00:00
Maximum2018-06-22 00:00:00
2024-05-11T14:24:00.954949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:24:01.110155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

전화번호
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size412.0 B
2024-05-11T14:24:01.394860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length10.794118
Min length7

Characters and Unicode

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

Unique34 ?
Unique (%)100.0%

Sample

1st row02 904 0841
2nd row00029925561
3rd row9540118
4th row0234913454
5th row0234911733
ValueCountFrequency (%)
02 21
30.4%
956 2
 
2.9%
996 2
 
2.9%
992 2
 
2.9%
6108 1
 
1.4%
4445 1
 
1.4%
0220 1
 
1.4%
908 1
 
1.4%
6543 1
 
1.4%
9025544 1
 
1.4%
Other values (36) 36
52.2%
2024-05-11T14:24:01.969552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 74
20.2%
49
13.4%
9 49
13.4%
2 47
12.8%
5 35
9.5%
4 33
9.0%
1 23
 
6.3%
3 19
 
5.2%
6 15
 
4.1%
8 12
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 318
86.6%
Space Separator 49
 
13.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 74
23.3%
9 49
15.4%
2 47
14.8%
5 35
11.0%
4 33
10.4%
1 23
 
7.2%
3 19
 
6.0%
6 15
 
4.7%
8 12
 
3.8%
7 11
 
3.5%
Space Separator
ValueCountFrequency (%)
49
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 367
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 74
20.2%
49
13.4%
9 49
13.4%
2 47
12.8%
5 35
9.5%
4 33
9.0%
1 23
 
6.3%
3 19
 
5.2%
6 15
 
4.1%
8 12
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 367
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 74
20.2%
49
13.4%
9 49
13.4%
2 47
12.8%
5 35
9.5%
4 33
9.0%
1 23
 
6.3%
3 19
 
5.2%
6 15
 
4.1%
8 12
 
3.3%

소재지면적
Real number (ℝ)

MISSING 

Distinct24
Distinct (%)100.0%
Missing11
Missing (%)31.4%
Infinite0
Infinite (%)0.0%
Mean1010.9937
Minimum262.2
Maximum2244
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2024-05-11T14:24:02.603356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum262.2
5-th percentile354.135
Q1788.175
median911.85
Q31187.625
95-th percentile1728.42
Maximum2244
Range1981.8
Interquartile range (IQR)399.45

Descriptive statistics

Standard deviation445.53029
Coefficient of variation (CV)0.4406855
Kurtosis1.5244342
Mean1010.9937
Median Absolute Deviation (MAD)204
Skewness0.86290274
Sum24263.85
Variance198497.24
MonotonicityNot monotonic
2024-05-11T14:24:03.058411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1417.0 1
 
2.9%
903.1 1
 
2.9%
779.7 1
 
2.9%
998.0 1
 
2.9%
796.0 1
 
2.9%
1312.0 1
 
2.9%
887.4 1
 
2.9%
1224.3 1
 
2.9%
776.25 1
 
2.9%
1175.4 1
 
2.9%
Other values (14) 14
40.0%
(Missing) 11
31.4%
ValueCountFrequency (%)
262.2 1
2.9%
345.0 1
2.9%
405.9 1
2.9%
721.0 1
2.9%
776.25 1
2.9%
779.7 1
2.9%
791.0 1
2.9%
796.0 1
2.9%
809.9 1
2.9%
885.5 1
2.9%
ValueCountFrequency (%)
2244.0 1
2.9%
1743.9 1
2.9%
1640.7 1
2.9%
1417.0 1
2.9%
1312.0 1
2.9%
1224.3 1
2.9%
1175.4 1
2.9%
1142.0 1
2.9%
1129.0 1
2.9%
998.0 1
2.9%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

지번주소
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2024-05-11T14:24:03.543359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length20.142857
Min length16

Characters and Unicode

Total characters705
Distinct characters32
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

Unique35 ?
Unique (%)100.0%

Sample

1st row서울특별시 도봉구 창동 715-14
2nd row서울특별시 도봉구 쌍문동 103-7
3rd row서울특별시 도봉구 도봉동 561-6
4th row서울특별시 도봉구 방학동 705-15
5th row서울특별시 도봉구 방학동 668-10
ValueCountFrequency (%)
서울특별시 35
24.5%
도봉구 35
24.5%
창동 12
 
8.4%
방학동 11
 
7.7%
도봉동 6
 
4.2%
쌍문동 6
 
4.2%
746-32 1
 
0.7%
699 1
 
0.7%
578-56 1
 
0.7%
650-65 1
 
0.7%
Other values (34) 34
23.8%
2024-05-11T14:24:04.117187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
123
17.4%
도 41
 
5.8%
봉 41
 
5.8%
서 35
 
5.0%
특 35
 
5.0%
별 35
 
5.0%
시 35
 
5.0%
구 35
 
5.0%
동 35
 
5.0%
울 35
 
5.0%
Other values (22) 255
36.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 381
54.0%
Decimal Number 166
23.5%
Space Separator 123
 
17.4%
Dash Punctuation 29
 
4.1%
Other Punctuation 6
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 41
10.8%
봉 41
10.8%
서 35
9.2%
특 35
9.2%
별 35
9.2%
시 35
9.2%
구 35
9.2%
동 35
9.2%
울 35
9.2%
창 12
 
3.1%
Other values (9) 42
11.0%
Decimal Number
ValueCountFrequency (%)
6 26
15.7%
2 25
15.1%
5 22
13.3%
7 20
12.0%
1 16
9.6%
4 14
8.4%
0 14
8.4%
3 13
7.8%
9 8
 
4.8%
8 8
 
4.8%
Space Separator
ValueCountFrequency (%)
123
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 29
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 381
54.0%
Common 324
46.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 41
10.8%
봉 41
10.8%
서 35
9.2%
특 35
9.2%
별 35
9.2%
시 35
9.2%
구 35
9.2%
동 35
9.2%
울 35
9.2%
창 12
 
3.1%
Other values (9) 42
11.0%
Common
ValueCountFrequency (%)
123
38.0%
- 29
 
9.0%
6 26
 
8.0%
2 25
 
7.7%
5 22
 
6.8%
7 20
 
6.2%
1 16
 
4.9%
4 14
 
4.3%
0 14
 
4.3%
3 13
 
4.0%
Other values (3) 22
 
6.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 381
54.0%
ASCII 324
46.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
123
38.0%
- 29
 
9.0%
6 26
 
8.0%
2 25
 
7.7%
5 22
 
6.8%
7 20
 
6.2%
1 16
 
4.9%
4 14
 
4.3%
0 14
 
4.3%
3 13
 
4.0%
Other values (3) 22
 
6.8%
Hangul
ValueCountFrequency (%)
도 41
10.8%
봉 41
10.8%
서 35
9.2%
특 35
9.2%
별 35
9.2%
시 35
9.2%
구 35
9.2%
동 35
9.2%
울 35
9.2%
창 12
 
3.1%
Other values (9) 42
11.0%

도로명주소
Text

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
2024-05-11T14:24:04.517775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length27
Mean length23.685714
Min length22

Characters and Unicode

Total characters829
Distinct characters42
Distinct categories6 ?
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 (%)100.0%

Sample

1st row서울특별시 도봉구 도봉로 558 (창동)
2nd row서울특별시 도봉구 도봉로 437 (쌍문동)
3rd row서울특별시 도봉구 도봉로 895 (도봉동)
4th row서울특별시 도봉구 도봉로 706 (방학동)
5th row서울특별시 도봉구 방학로 186 (방학동)
ValueCountFrequency (%)
서울특별시 35
20.0%
도봉구 35
20.0%
창동 12
 
6.9%
도봉로 12
 
6.9%
방학동 11
 
6.3%
도봉동 6
 
3.4%
쌍문동 6
 
3.4%
방학로 5
 
2.9%
덕릉로59가길 2
 
1.1%
삼양로 2
 
1.1%
Other values (48) 49
28.0%
2024-05-11T14:24:05.155397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
142
17.1%
봉 59
 
7.1%
도 56
 
6.8%
시 38
 
4.6%
서 35
 
4.2%
동 35
 
4.2%
특 35
 
4.2%
별 35
 
4.2%
구 35
 
4.2%
로 35
 
4.2%
Other values (32) 324
39.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 495
59.7%
Space Separator 142
 
17.1%
Decimal Number 120
 
14.5%
Close Punctuation 35
 
4.2%
Open Punctuation 35
 
4.2%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
봉 59
11.9%
도 56
11.3%
시 38
 
7.7%
서 35
 
7.1%
동 35
 
7.1%
특 35
 
7.1%
별 35
 
7.1%
구 35
 
7.1%
로 35
 
7.1%
울 35
 
7.1%
Other values (18) 97
19.6%
Decimal Number
ValueCountFrequency (%)
6 20
16.7%
1 19
15.8%
5 16
13.3%
2 12
10.0%
4 12
10.0%
7 9
7.5%
9 9
7.5%
8 8
 
6.7%
3 8
 
6.7%
0 7
 
5.8%
Space Separator
ValueCountFrequency (%)
142
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 495
59.7%
Common 334
40.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
봉 59
11.9%
도 56
11.3%
시 38
 
7.7%
서 35
 
7.1%
동 35
 
7.1%
특 35
 
7.1%
별 35
 
7.1%
구 35
 
7.1%
로 35
 
7.1%
울 35
 
7.1%
Other values (18) 97
19.6%
Common
ValueCountFrequency (%)
142
42.5%
) 35
 
10.5%
( 35
 
10.5%
6 20
 
6.0%
1 19
 
5.7%
5 16
 
4.8%
2 12
 
3.6%
4 12
 
3.6%
7 9
 
2.7%
9 9
 
2.7%
Other values (4) 25
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 495
59.7%
ASCII 334
40.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
142
42.5%
) 35
 
10.5%
( 35
 
10.5%
6 20
 
6.0%
1 19
 
5.7%
5 16
 
4.8%
2 12
 
3.6%
4 12
 
3.6%
7 9
 
2.7%
9 9
 
2.7%
Other values (4) 25
 
7.5%
Hangul
ValueCountFrequency (%)
봉 59
11.9%
도 56
11.3%
시 38
 
7.7%
서 35
 
7.1%
동 35
 
7.1%
특 35
 
7.1%
별 35
 
7.1%
구 35
 
7.1%
로 35
 
7.1%
울 35
 
7.1%
Other values (18) 97
19.6%

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

사업장명
Text

Distinct34
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size412.0 B
2024-05-11T14:24:05.611552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length17
Mean length10.4
Min length4

Characters and Unicode

Total characters364
Distinct characters99
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

Unique33 ?
Unique (%)94.3%

Sample

1st row현대오일뱅크(주)직영 창동주유소
2nd row삼미상사(주)북부주유소
3rd row지에스칼텍스(주) 도봉주유소
4th row구도일주유소 도봉
5th row지에스칼텍스(주) 방학동주유소
ValueCountFrequency (%)
주식회사 3
 
5.8%
호남석유 2
 
3.8%
구도일주유소 2
 
3.8%
지에스칼텍스(주 2
 
3.8%
합동석유 1
 
1.9%
금광석유 1
 
1.9%
형제석유 1
 
1.9%
미양석유 1
 
1.9%
에스케이대한에너지 1
 
1.9%
한이에너지 1
 
1.9%
Other values (37) 37
71.2%
2024-05-11T14:24:06.272578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 42
 
11.5%
유 33
 
9.1%
소 24
 
6.6%
17
 
4.7%
( 15
 
4.1%
) 15
 
4.1%
에 12
 
3.3%
지 11
 
3.0%
석 9
 
2.5%
이 8
 
2.2%
Other values (89) 178
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 312
85.7%
Space Separator 17
 
4.7%
Open Punctuation 15
 
4.1%
Close Punctuation 15
 
4.1%
Uppercase Letter 3
 
0.8%
Decimal Number 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 42
 
13.5%
유 33
 
10.6%
소 24
 
7.7%
에 12
 
3.8%
지 11
 
3.5%
석 9
 
2.9%
이 8
 
2.6%
너 8
 
2.6%
동 7
 
2.2%
대 7
 
2.2%
Other values (81) 151
48.4%
Uppercase Letter
ValueCountFrequency (%)
P 1
33.3%
L 1
33.3%
K 1
33.3%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 15
100.0%
Close Punctuation
ValueCountFrequency (%)
) 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 312
85.7%
Common 49
 
13.5%
Latin 3
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 42
 
13.5%
유 33
 
10.6%
소 24
 
7.7%
에 12
 
3.8%
지 11
 
3.5%
석 9
 
2.9%
이 8
 
2.6%
너 8
 
2.6%
동 7
 
2.2%
대 7
 
2.2%
Other values (81) 151
48.4%
Common
ValueCountFrequency (%)
17
34.7%
( 15
30.6%
) 15
30.6%
1 1
 
2.0%
2 1
 
2.0%
Latin
ValueCountFrequency (%)
P 1
33.3%
L 1
33.3%
K 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 312
85.7%
ASCII 52
 
14.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 42
 
13.5%
유 33
 
10.6%
소 24
 
7.7%
에 12
 
3.8%
지 11
 
3.5%
석 9
 
2.9%
이 8
 
2.6%
너 8
 
2.6%
동 7
 
2.2%
대 7
 
2.2%
Other values (81) 151
48.4%
ASCII
ValueCountFrequency (%)
17
32.7%
( 15
28.8%
) 15
28.8%
1 1
 
1.9%
2 1
 
1.9%
P 1
 
1.9%
L 1
 
1.9%
K 1
 
1.9%

최종수정일자
Date

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2007-02-06 00:00:00
Maximum2024-05-08 15:42:54
2024-05-11T14:24:06.532281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:24:06.794318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)

데이터갱신구분
Categorical

Distinct2
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
U
23 
I
12 

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 23
65.7%
I 12
34.3%

Length

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

Common Values (Plot)

2024-05-11T14:24:07.200420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
u 23
65.7%
i 12
34.3%

데이터갱신일자
Date

Distinct13
Distinct (%)37.1%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-04 23:00:00
2024-05-11T14:24:07.372217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:24:07.564461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)

업태구분명
Categorical

Distinct3
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size412.0 B
주유소
24 
일반판매소
10 
용제판매소
 
1

Length

Max length5
Median length3
Mean length3.6285714
Min length3

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
주유소 24
68.6%
일반판매소 10
28.6%
용제판매소 1
 
2.9%

Length

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

Common Values (Plot)

2024-05-11T14:24:08.052350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 24
68.6%
일반판매소 10
28.6%
용제판매소 1
 
2.9%

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

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean203326.52
Minimum201150.17
Maximum204333.95
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2024-05-11T14:24:08.261578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum201150.17
5-th percentile201966.38
Q1203050.35
median203397.54
Q3203830.67
95-th percentile204289.62
Maximum204333.95
Range3183.783
Interquartile range (IQR)780.32479

Descriptive statistics

Standard deviation738.60006
Coefficient of variation (CV)0.0036325811
Kurtosis2.5417274
Mean203326.52
Median Absolute Deviation (MAD)425.69307
Skewness-1.3182475
Sum7116428.1
Variance545530.05
MonotonicityNot monotonic
2024-05-11T14:24:08.532009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
203351.865815447 1
 
2.9%
202764.770881504 1
 
2.9%
203192.645544286 1
 
2.9%
202820.760546167 1
 
2.9%
203929.510429288 1
 
2.9%
203233.020276711 1
 
2.9%
203058.292434289 1
 
2.9%
203838.118567 1
 
2.9%
203173.997755357 1
 
2.9%
203244.618417812 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
201150.171170011 1
2.9%
201181.677772609 1
2.9%
202302.686513778 1
2.9%
202707.794159647 1
2.9%
202764.770881504 1
2.9%
202789.354462012 1
2.9%
202820.760546167 1
2.9%
202895.539313847 1
2.9%
203042.407689994 1
2.9%
203058.292434289 1
2.9%
ValueCountFrequency (%)
204333.95416765 1
2.9%
204316.826735421 1
2.9%
204277.95713217 1
2.9%
204123.904989152 1
2.9%
204117.638065096 1
2.9%
203957.909706298 1
2.9%
203929.510429288 1
2.9%
203914.548678246 1
2.9%
203838.118567 1
2.9%
203823.231146741 1
2.9%

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

UNIQUE 

Distinct35
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean461923.76
Minimum459567.41
Maximum465113.66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size447.0 B
2024-05-11T14:24:08.768418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum459567.41
5-th percentile459585.11
Q1460615.99
median462162.23
Q3462843.95
95-th percentile464245.29
Maximum465113.66
Range5546.2447
Interquartile range (IQR)2227.9569

Descriptive statistics

Standard deviation1445.9088
Coefficient of variation (CV)0.0031301894
Kurtosis-0.49133353
Mean461923.76
Median Absolute Deviation (MAD)841.69678
Skewness0.13703884
Sum16167332
Variance2090652.4
MonotonicityNot monotonic
2024-05-11T14:24:09.029634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
461358.405430652 1
 
2.9%
460298.901545302 1
 
2.9%
459591.192836869 1
 
2.9%
460249.237919641 1
 
2.9%
465113.655837614 1
 
2.9%
461421.180110786 1
 
2.9%
462221.869468667 1
 
2.9%
462464.781002 1
 
2.9%
463003.926756581 1
 
2.9%
461293.682615642 1
 
2.9%
Other values (25) 25
71.4%
ValueCountFrequency (%)
459567.411171212 1
2.9%
459570.932834528 1
2.9%
459591.192836869 1
2.9%
459886.321087767 1
2.9%
460249.237919641 1
2.9%
460298.901545302 1
2.9%
460392.345192054 1
2.9%
460481.504129296 1
2.9%
460492.700285958 1
2.9%
460739.277842462 1
2.9%
ValueCountFrequency (%)
465113.655837614 1
2.9%
464665.364497122 1
2.9%
464065.255438814 1
2.9%
463641.030222332 1
2.9%
463563.062274237 1
2.9%
463547.488476218 1
2.9%
463003.926756581 1
2.9%
462958.507305259 1
2.9%
462902.132014803 1
2.9%
462785.759842796 1
2.9%

자본금
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

거래처
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing35
Missing (%)100.0%
Memory size447.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
03090000196830900870150000119681106<NA>3폐업3폐지20131031<NA><NA><NA>02 904 0841954.0<NA>서울특별시 도봉구 창동 715-14서울특별시 도봉구 도봉로 558 (창동)<NA>현대오일뱅크(주)직영 창동주유소2013-11-01 10:25:10I2018-08-31 23:59:59.0주유소203351.865815461358.405431<NA><NA>
1309000019703090087015000011970-06-22<NA>1영업/정상1신규등록<NA><NA><NA><NA>000299255612244.0<NA>서울특별시 도봉구 쌍문동 103-7서울특별시 도봉구 도봉로 437 (쌍문동)<NA>삼미상사(주)북부주유소2023-11-15 17:57:40U2022-10-31 23:07:00.0주유소202764.770882460298.901545<NA><NA>
2309000019703090105015000021970-09-26<NA>2휴업5사업휴지<NA>2024-05-012025-04-30<NA>95401181640.7<NA>서울특별시 도봉구 도봉동 561-6서울특별시 도봉구 도봉로 895 (도봉동)<NA>지에스칼텍스(주) 도봉주유소2024-05-08 15:42:54U2023-12-04 23:00:00.0주유소203957.909706464665.364497<NA><NA>
3309000019763090087015000011976-05-24<NA>1영업/정상7영업개시<NA>2012-05-012012-09-13<NA>02349134541142.0<NA>서울특별시 도봉구 방학동 705-15서울특별시 도봉구 도봉로 706 (방학동)<NA>구도일주유소 도봉2023-10-20 09:42:52U2022-10-30 22:02:00.0주유소203776.39338462785.759843<NA><NA>
4309000019863090087015000011986-12-30<NA>1영업/정상1신규등록<NA><NA><NA><NA>0234911733920.6<NA>서울특별시 도봉구 방학동 668-10서울특별시 도봉구 방학로 186 (방학동)<NA>지에스칼텍스(주) 방학동주유소2024-03-22 11:37:46U2023-12-02 22:04:00.0주유소202707.79416462225.208428<NA><NA>
53090000198830901050150000119880909<NA>3폐업3폐지20180424<NA><NA><NA>02995 2893345.0<NA>서울특별시 도봉구 쌍문동 512-8서울특별시 도봉구 삼양로 630 (쌍문동)<NA>우이동주유소2018-04-24 16:07:10I2018-08-31 23:59:59.0주유소201181.677773461872.766489<NA><NA>
6309000019893090087015000011989-10-13<NA>1영업/정상1신규등록<NA><NA><NA><NA>02 90544411129.0<NA>서울특별시 도봉구 창동 603-84서울특별시 도봉구 덕릉로 267 (창동)<NA>대성산업(주)신창주유소2023-10-20 09:44:07U2022-10-30 22:02:00.0주유소203481.710159459886.321088<NA><NA>
73090000198930900870150000219891013<NA>3폐업3폐지20191021<NA><NA><NA>0234924732885.5<NA>서울특별시 도봉구 방학동 725-9,5,20호서울특별시 도봉구 방학로 21 (방학동)<NA>(주)소모에너지엔테크놀러지 신중계주유소2019-10-22 15:00:01U2019-10-24 02:40:00.0주유소204333.954168462162.229978<NA><NA>
83090000199030901050120000119901227<NA>3폐업3폐지20131023<NA><NA><NA>02 992 9194<NA><NA>서울특별시 도봉구 창동 562-4서울특별시 도봉구 덕릉로60길 40 (창동)<NA>수만석유2016-01-13 10:02:25I2018-08-31 23:59:59.0일반판매소203486.955202459567.411171<NA><NA>
9309000019903090105012000021990-12-27<NA>3폐업3폐지2023-05-24<NA><NA><NA>02 905 6108<NA><NA>서울특별시 도봉구 창동 578-132 2통8반서울특별시 도봉구 덕릉로59가길 56 (창동)<NA>율촌에너지2023-05-25 10:18:58U2022-12-04 22:07:00.0일반판매소203173.719956459570.932835<NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
253090000199630901050120000219960224<NA>3폐업3폐지20090817<NA><NA><NA>02 903 4445<NA><NA>서울특별시 도봉구 창동 746-32서울특별시 도봉구 도봉로 642-18 (창동)<NA>창연석유2009-08-17 10:27:17I2018-08-31 23:59:59.0일반판매소203838.118567462464.781002<NA><NA>
263090000199630901050120001019961004<NA>1영업/정상1신규등록<NA><NA><NA><NA>3493651<NA><NA>서울특별시 도봉구 방학동 622-25서울특별시 도봉구 시루봉로 246 (방학동)<NA>합동석유2021-10-22 11:33:44U2021-10-24 02:40:00.0일반판매소203173.997755463003.926757<NA><NA>
27309000019963090105015000011996-07-13<NA>1영업/정상7영업개시<NA><NA><NA><NA>02 992 0220779.7<NA>서울특별시 도봉구 쌍문동 699서울특별시 도봉구 도봉로 547 (쌍문동)<NA>한이에너지 주식회사 쌍문주유소2023-10-20 09:31:42U2022-10-30 22:02:00.0주유소203244.618418461293.682616<NA><NA>
28309000019973090105012000011997-12-19<NA>1영업/정상7영업개시<NA>2009-10-102010-05-30<NA>02 34915100<NA><NA>서울특별시 도봉구 도봉동 602-3서울특별시 도봉구 도봉로169나길 100 (도봉동)<NA>에스케이대한에너지 주식회사2023-07-05 08:08:14U2022-12-07 00:07:00.0일반판매소203769.387328463641.030222<NA><NA>
293090000199930901050120000419901227<NA>3폐업3폐지20120307<NA><NA><NA>02 900 1800<NA><NA>서울특별시 도봉구 방학동 605-27서울특별시 도봉구 시루봉로15길 28 (방학동)<NA>호남석유2012-03-07 09:28:58I2018-08-31 23:59:59.0일반판매소202789.354462462902.132015<NA><NA>
303090000200030901050120000520000408<NA>3폐업3폐지<NA><NA><NA><NA>02 9569467<NA><NA>서울특별시 도봉구 방학동 602-2서울특별시 도봉구 시루봉로17길 26 (방학동)<NA>미양석유2007-02-06 00:00:00I2018-08-31 23:59:59.0일반판매소202895.539314462958.507305<NA><NA>
313090000200130901050120081820010406<NA>3폐업3폐지20140620<NA><NA><NA><NA><NA><NA>서울특별시 도봉구 방학동 676-32서울특별시 도봉구 방학로3길 12-58 (방학동)<NA>호남석유2014-07-01 19:39:35I2018-08-31 23:59:59.0일반판매소203397.538076462215.013822<NA><NA>
323090000200530900870120000220050624<NA>3폐업3폐지20130307<NA><NA><NA>02 9550037<NA><NA>서울특별시 도봉구 도봉동 625-134서울특별시 도봉구 도봉로160길 9 (도봉동)<NA>형제석유2013-03-07 10:17:09I2018-08-31 23:59:59.0일반판매소203914.548678463547.488476<NA><NA>
333090000200630900870120000120060627<NA>1영업/정상1신규등록<NA><NA><NA><NA>02 9917302<NA><NA>서울특별시 도봉구 창동 651-83서울특별시 도봉구 도봉로112길 12 (창동)<NA>금광석유2022-11-26 13:29:28U2021-10-31 22:08:00.0일반판매소203042.40769460481.504129<NA><NA>
34309000020093090105015009522009-01-30<NA>1영업/정상7영업개시<NA><NA><NA><NA>02 34941500903.1<NA>서울특별시 도봉구 방학동 724-5서울특별시 도봉구 방학로 43 (방학동)<NA>오복주유소2023-10-20 09:27:42U2022-10-30 22:02:00.0주유소204117.638065462218.032569<NA><NA>