Overview

Dataset statistics

Number of variables27
Number of observations67
Missing cells626
Missing cells (%)34.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.1 KiB
Average record size in memory231.0 B

Variable types

Categorical7
Numeric5
DateTime6
Unsupported5
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가취소일자 has 67 (100.0%) missing valuesMissing
폐업일자 has 48 (71.6%) missing valuesMissing
휴업시작일자 has 54 (80.6%) missing valuesMissing
휴업종료일자 has 54 (80.6%) missing valuesMissing
재개업일자 has 58 (86.6%) missing valuesMissing
전화번호 has 2 (3.0%) missing valuesMissing
소재지면적 has 40 (59.7%) missing valuesMissing
소재지우편번호 has 67 (100.0%) missing valuesMissing
도로명주소 has 29 (43.3%) missing valuesMissing
도로명우편번호 has 67 (100.0%) missing valuesMissing
좌표정보(X) has 3 (4.5%) missing valuesMissing
좌표정보(Y) has 3 (4.5%) missing valuesMissing
자본금 has 67 (100.0%) missing valuesMissing
거래처 has 67 (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
소재지면적 has 1 (1.5%) zerosZeros

Reproduction

Analysis started2024-04-29 19:50:50.837254
Analysis finished2024-04-29 19:50:51.452824
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
3060000
67 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3060000 67
100.0%

Length

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

Common Values (Plot)

2024-04-30T04:50:51.596094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3060000 67
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.001112 × 1018
Minimum1.976306 × 1018
Maximum2.017306 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2024-04-30T04:50:51.679067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.976306 × 1018
5-th percentile1.990906 × 1018
Q12.002306 × 1018
median2.002306 × 1018
Q32.002306 × 1018
95-th percentile2.005306 × 1018
Maximum2.017306 × 1018
Range4.1000007 × 1016
Interquartile range (IQR)149760

Descriptive statistics

Standard deviation5.8704161 × 1015
Coefficient of variation (CV)0.002933577
Kurtosis9.2787343
Mean2.001112 × 1018
Median Absolute Deviation (MAD)0
Skewness-2.3870314
Sum4.947294 × 1018
Variance3.4461785 × 1031
MonotonicityStrictly increasing
2024-04-30T04:50:51.816854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1976306007501500001 1
 
1.5%
2002306007501200031 1
 
1.5%
2002306007501200038 1
 
1.5%
2002306007501200037 1
 
1.5%
2002306007501200035 1
 
1.5%
2002306007501200034 1
 
1.5%
2002306007501200033 1
 
1.5%
2002306007501200032 1
 
1.5%
2002306007501200030 1
 
1.5%
1976306007501500002 1
 
1.5%
Other values (57) 57
85.1%
ValueCountFrequency (%)
1976306007501500001 1
1.5%
1976306007501500002 1
1.5%
1988306009501500004 1
1.5%
1990306007501500001 1
1.5%
1992306007501500001 1
1.5%
1992306007501500002 1
1.5%
1993306007501500001 1
1.5%
1994306007501500001 1
1.5%
1999306007501500001 1
1.5%
2000306007501500001 1
1.5%
ValueCountFrequency (%)
2017306014501500001 1
1.5%
2008306009501500001 1
1.5%
2005306007501500002 1
1.5%
2005306007501500001 1
1.5%
2005306007501200002 1
1.5%
2005306007501200001 1
1.5%
2004306007501500025 1
1.5%
2004306007501500024 1
1.5%
2004306007501500011 1
1.5%
2003306007501500005 1
1.5%

인허가일자
Date

Distinct40
Distinct (%)59.7%
Missing0
Missing (%)0.0%
Memory size668.0 B
Minimum1976-06-26 00:00:00
Maximum2017-08-24 00:00:00
2024-04-30T04:50:51.934645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:52.054530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing67
Missing (%)100.0%
Memory size735.0 B

영업상태코드
Categorical

Distinct2
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
3
45 
1
22 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 45
67.2%
1 22
32.8%

Length

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

Common Values (Plot)

2024-04-30T04:50:52.259935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 45
67.2%
1 22
32.8%

영업상태명
Categorical

Distinct2
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
폐업
45 
영업/정상
22 

Length

Max length5
Median length2
Mean length2.9850746
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 45
67.2%
영업/정상 22
32.8%

Length

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

Common Values (Plot)

2024-04-30T04:50:52.449109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 45
67.2%
영업/정상 22
32.8%

상세영업상태코드
Categorical

Distinct4
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
3
45 
1
11 
6
9 
7
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 45
67.2%
1 11
 
16.4%
6 9
 
13.4%
7 2
 
3.0%

Length

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

Common Values (Plot)

2024-04-30T04:50:52.641032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 45
67.2%
1 11
 
16.4%
6 9
 
13.4%
7 2
 
3.0%

상세영업상태명
Categorical

Distinct4
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
폐지
45 
신규등록
11 
휴지사업재개
9 
영업개시
 
2

Length

Max length6
Median length2
Mean length2.9253731
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐지 45
67.2%
신규등록 11
 
16.4%
휴지사업재개 9
 
13.4%
영업개시 2
 
3.0%

Length

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

Common Values (Plot)

2024-04-30T04:50:52.833507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐지 45
67.2%
신규등록 11
 
16.4%
휴지사업재개 9
 
13.4%
영업개시 2
 
3.0%

폐업일자
Real number (ℝ)

MISSING 

Distinct19
Distinct (%)100.0%
Missing48
Missing (%)71.6%
Infinite0
Infinite (%)0.0%
Mean20137994
Minimum20071031
Maximum20220511
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2024-04-30T04:50:52.915495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20071031
5-th percentile20079212
Q120110203
median20140501
Q320170518
95-th percentile20185049
Maximum20220511
Range149480
Interquartile range (IQR)60315.5

Descriptive statistics

Standard deviation42455.624
Coefficient of variation (CV)0.002108235
Kurtosis-0.83275162
Mean20137994
Median Absolute Deviation (MAD)30320
Skewness-0.042511764
Sum3.826219 × 108
Variance1.80248 × 109
MonotonicityNot monotonic
2024-04-30T04:50:53.022103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
20181109 1
 
1.5%
20150819 1
 
1.5%
20180927 1
 
1.5%
20160516 1
 
1.5%
20120820 1
 
1.5%
20220511 1
 
1.5%
20120911 1
 
1.5%
20080602 1
 
1.5%
20131024 1
 
1.5%
20071031 1
 
1.5%
Other values (9) 9
 
13.4%
(Missing) 48
71.6%
ValueCountFrequency (%)
20071031 1
1.5%
20080121 1
1.5%
20080415 1
1.5%
20080602 1
1.5%
20100204 1
1.5%
20120202 1
1.5%
20120820 1
1.5%
20120911 1
1.5%
20131024 1
1.5%
20140501 1
1.5%
ValueCountFrequency (%)
20220511 1
1.5%
20181109 1
1.5%
20180927 1
1.5%
20180430 1
1.5%
20170821 1
1.5%
20170216 1
1.5%
20160715 1
1.5%
20160516 1
1.5%
20150819 1
1.5%
20140501 1
1.5%

휴업시작일자
Date

MISSING 

Distinct13
Distinct (%)100.0%
Missing54
Missing (%)80.6%
Memory size668.0 B
Minimum2008-11-13 00:00:00
Maximum2019-06-25 00:00:00
2024-04-30T04:50:53.107997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:53.187733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)

휴업종료일자
Date

MISSING 

Distinct13
Distinct (%)100.0%
Missing54
Missing (%)80.6%
Memory size668.0 B
Minimum2009-04-30 00:00:00
Maximum2019-06-30 00:00:00
2024-04-30T04:50:53.276110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:53.370345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)

재개업일자
Date

MISSING 

Distinct9
Distinct (%)100.0%
Missing58
Missing (%)86.6%
Memory size668.0 B
Minimum2010-12-12 00:00:00
Maximum2021-07-18 00:00:00
2024-04-30T04:50:53.454997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:53.537921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

전화번호
Text

MISSING 

Distinct65
Distinct (%)100.0%
Missing2
Missing (%)3.0%
Memory size668.0 B
2024-04-30T04:50:53.730650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length10.230769
Min length7

Characters and Unicode

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

Unique65 ?
Unique (%)100.0%

Sample

1st row02 9733122
2nd row02 22082546
3rd row02 433 1379
4th row4933001
5th row02 4375457
ValueCountFrequency (%)
02 25
 
20.3%
02432 7
 
5.7%
435 3
 
2.4%
02492 2
 
1.6%
02496 2
 
1.6%
02491 2
 
1.6%
02435 2
 
1.6%
02434 2
 
1.6%
02436 2
 
1.6%
02948 2
 
1.6%
Other values (73) 74
60.2%
2024-04-30T04:50:54.036476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 109
16.4%
0 98
14.7%
86
12.9%
4 80
12.0%
3 72
10.8%
9 51
7.7%
1 46
6.9%
5 44
6.6%
6 29
 
4.4%
7 29
 
4.4%
Other values (2) 21
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 575
86.5%
Space Separator 86
 
12.9%
Dash Punctuation 4
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 109
19.0%
0 98
17.0%
4 80
13.9%
3 72
12.5%
9 51
8.9%
1 46
8.0%
5 44
7.7%
6 29
 
5.0%
7 29
 
5.0%
8 17
 
3.0%
Space Separator
ValueCountFrequency (%)
86
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 665
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 109
16.4%
0 98
14.7%
86
12.9%
4 80
12.0%
3 72
10.8%
9 51
7.7%
1 46
6.9%
5 44
6.6%
6 29
 
4.4%
7 29
 
4.4%
Other values (2) 21
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 665
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 109
16.4%
0 98
14.7%
86
12.9%
4 80
12.0%
3 72
10.8%
9 51
7.7%
1 46
6.9%
5 44
6.6%
6 29
 
4.4%
7 29
 
4.4%
Other values (2) 21
 
3.2%

소재지면적
Real number (ℝ)

MISSING  ZEROS 

Distinct27
Distinct (%)100.0%
Missing40
Missing (%)59.7%
Infinite0
Infinite (%)0.0%
Mean856.97889
Minimum0
Maximum1472.7
Zeros1
Zeros (%)1.5%
Negative0
Negative (%)0.0%
Memory size735.0 B
2024-04-30T04:50:54.144601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile369.14
Q1585.1
median900.1
Q31062.7
95-th percentile1394.576
Maximum1472.7
Range1472.7
Interquartile range (IQR)477.6

Descriptive statistics

Standard deviation357.57177
Coefficient of variation (CV)0.41724688
Kurtosis-0.083705589
Mean856.97889
Median Absolute Deviation (MAD)306.1
Skewness-0.18757028
Sum23138.43
Variance127857.57
MonotonicityNot monotonic
2024-04-30T04:50:54.232209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1220.0 1
 
1.5%
930.8 1
 
1.5%
0.0 1
 
1.5%
679.4 1
 
1.5%
576.2 1
 
1.5%
1083.8 1
 
1.5%
554.8 1
 
1.5%
1041.6 1
 
1.5%
537.4 1
 
1.5%
904.2 1
 
1.5%
Other values (17) 17
25.4%
(Missing) 40
59.7%
ValueCountFrequency (%)
0.0 1
1.5%
336.5 1
1.5%
445.3 1
1.5%
473.0 1
1.5%
537.4 1
1.5%
554.8 1
1.5%
576.2 1
1.5%
594.0 1
1.5%
679.4 1
1.5%
754.75 1
1.5%
ValueCountFrequency (%)
1472.7 1
1.5%
1395.68 1
1.5%
1392.0 1
1.5%
1353.0 1
1.5%
1258.75 1
1.5%
1220.0 1
1.5%
1083.8 1
1.5%
1041.6 1
1.5%
955.0 1
1.5%
933.0 1
1.5%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing67
Missing (%)100.0%
Memory size735.0 B

지번주소
Text

Distinct63
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2024-04-30T04:50:54.428700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length29
Mean length20.671642
Min length17

Characters and Unicode

Total characters1385
Distinct characters42
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

Unique59 ?
Unique (%)88.1%

Sample

1st row서울특별시 중랑구 묵동 175-1
2nd row서울특별시 중랑구 망우동 490-8
3rd row서울특별시 중랑구 면목동 501-25
4th row서울특별시 중랑구 면목동 166-47
5th row서울특별시 중랑구 상봉동 109-45
ValueCountFrequency (%)
서울특별시 67
24.5%
중랑구 67
24.5%
면목동 27
 
9.9%
중화동 10
 
3.6%
망우동 10
 
3.6%
상봉동 8
 
2.9%
묵동 7
 
2.6%
신내동 5
 
1.8%
322-1 2
 
0.7%
129-35 2
 
0.7%
Other values (65) 69
25.2%
2024-04-30T04:50:54.761328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
258
18.6%
중 77
 
5.6%
서 67
 
4.8%
동 67
 
4.8%
울 67
 
4.8%
랑 67
 
4.8%
구 67
 
4.8%
시 67
 
4.8%
별 67
 
4.8%
특 67
 
4.8%
Other values (32) 514
37.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 742
53.6%
Decimal Number 320
23.1%
Space Separator 258
 
18.6%
Dash Punctuation 64
 
4.6%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
중 77
10.4%
서 67
9.0%
동 67
9.0%
울 67
9.0%
랑 67
9.0%
구 67
9.0%
시 67
9.0%
별 67
9.0%
특 67
9.0%
목 27
 
3.6%
Other values (19) 102
13.7%
Decimal Number
ValueCountFrequency (%)
1 60
18.8%
2 47
14.7%
0 34
10.6%
5 34
10.6%
4 32
10.0%
3 32
10.0%
7 24
 
7.5%
6 21
 
6.6%
9 19
 
5.9%
8 17
 
5.3%
Space Separator
ValueCountFrequency (%)
258
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 742
53.6%
Common 643
46.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
중 77
10.4%
서 67
9.0%
동 67
9.0%
울 67
9.0%
랑 67
9.0%
구 67
9.0%
시 67
9.0%
별 67
9.0%
특 67
9.0%
목 27
 
3.6%
Other values (19) 102
13.7%
Common
ValueCountFrequency (%)
258
40.1%
- 64
 
10.0%
1 60
 
9.3%
2 47
 
7.3%
0 34
 
5.3%
5 34
 
5.3%
4 32
 
5.0%
3 32
 
5.0%
7 24
 
3.7%
6 21
 
3.3%
Other values (3) 37
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 742
53.6%
ASCII 643
46.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
258
40.1%
- 64
 
10.0%
1 60
 
9.3%
2 47
 
7.3%
0 34
 
5.3%
5 34
 
5.3%
4 32
 
5.0%
3 32
 
5.0%
7 24
 
3.7%
6 21
 
3.3%
Other values (3) 37
 
5.8%
Hangul
ValueCountFrequency (%)
중 77
10.4%
서 67
9.0%
동 67
9.0%
울 67
9.0%
랑 67
9.0%
구 67
9.0%
시 67
9.0%
별 67
9.0%
특 67
9.0%
목 27
 
3.6%
Other values (19) 102
13.7%

도로명주소
Text

MISSING 

Distinct37
Distinct (%)97.4%
Missing29
Missing (%)43.3%
Memory size668.0 B
2024-04-30T04:50:54.964579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length27
Mean length23.815789
Min length22

Characters and Unicode

Total characters905
Distinct characters44
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

Unique36 ?
Unique (%)94.7%

Sample

1st row서울특별시 중랑구 동일로 922 (묵동)
2nd row서울특별시 중랑구 망우로 400 (망우동)
3rd row서울특별시 중랑구 면목로55길 6 (면목동)
4th row서울특별시 중랑구 사가정로 341 (면목동)
5th row서울특별시 중랑구 봉우재로 105 (상봉동)
ValueCountFrequency (%)
서울특별시 38
20.0%
중랑구 38
20.0%
면목동 15
 
7.9%
동일로 10
 
5.3%
중화동 7
 
3.7%
망우동 6
 
3.2%
망우로 6
 
3.2%
용마산로 5
 
2.6%
묵동 4
 
2.1%
상봉동 4
 
2.1%
Other values (51) 57
30.0%
2024-04-30T04:50:55.291271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
152
 
16.8%
동 54
 
6.0%
중 49
 
5.4%
랑 42
 
4.6%
서 38
 
4.2%
울 38
 
4.2%
) 38
 
4.2%
( 38
 
4.2%
로 38
 
4.2%
구 38
 
4.2%
Other values (34) 380
42.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 551
60.9%
Space Separator 152
 
16.8%
Decimal Number 125
 
13.8%
Close Punctuation 38
 
4.2%
Open Punctuation 38
 
4.2%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 54
 
9.8%
중 49
 
8.9%
랑 42
 
7.6%
서 38
 
6.9%
울 38
 
6.9%
로 38
 
6.9%
구 38
 
6.9%
시 38
 
6.9%
별 38
 
6.9%
특 38
 
6.9%
Other values (20) 140
25.4%
Decimal Number
ValueCountFrequency (%)
1 19
15.2%
0 16
12.8%
2 14
11.2%
6 14
11.2%
4 11
8.8%
5 11
8.8%
7 11
8.8%
8 10
8.0%
9 10
8.0%
3 9
7.2%
Space Separator
ValueCountFrequency (%)
152
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 551
60.9%
Common 354
39.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 54
 
9.8%
중 49
 
8.9%
랑 42
 
7.6%
서 38
 
6.9%
울 38
 
6.9%
로 38
 
6.9%
구 38
 
6.9%
시 38
 
6.9%
별 38
 
6.9%
특 38
 
6.9%
Other values (20) 140
25.4%
Common
ValueCountFrequency (%)
152
42.9%
) 38
 
10.7%
( 38
 
10.7%
1 19
 
5.4%
0 16
 
4.5%
2 14
 
4.0%
6 14
 
4.0%
4 11
 
3.1%
5 11
 
3.1%
7 11
 
3.1%
Other values (4) 30
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 551
60.9%
ASCII 354
39.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
152
42.9%
) 38
 
10.7%
( 38
 
10.7%
1 19
 
5.4%
0 16
 
4.5%
2 14
 
4.0%
6 14
 
4.0%
4 11
 
3.1%
5 11
 
3.1%
7 11
 
3.1%
Other values (4) 30
 
8.5%
Hangul
ValueCountFrequency (%)
동 54
 
9.8%
중 49
 
8.9%
랑 42
 
7.6%
서 38
 
6.9%
울 38
 
6.9%
로 38
 
6.9%
구 38
 
6.9%
시 38
 
6.9%
별 38
 
6.9%
특 38
 
6.9%
Other values (20) 140
25.4%

도로명우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing67
Missing (%)100.0%
Memory size735.0 B

사업장명
Text

Distinct62
Distinct (%)92.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
2024-04-30T04:50:55.525357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length25
Mean length7.4029851
Min length4

Characters and Unicode

Total characters496
Distinct characters121
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique57 ?
Unique (%)85.1%

Sample

1st row태능주유소 대신석유(주)
2nd rowSK네트웍스(주) 상봉주유소
3rd row남경상사
4th row대농2주유소
5th row대양주유소
ValueCountFrequency (%)
등대에너지 2
 
2.3%
주유소 2
 
2.3%
대성석유 2
 
2.3%
엘지석유 2
 
2.3%
쌍용석유 2
 
2.3%
신일주유소 2
 
2.3%
제3대지주유소 1
 
1.1%
현대오일뱅크(주)직영 1
 
1.1%
신우석유 1
 
1.1%
중화석유 1
 
1.1%
Other values (72) 72
81.8%
2024-04-30T04:50:55.874421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
유 61
 
12.3%
43
 
8.7%
주 37
 
7.5%
석 30
 
6.0%
소 28
 
5.6%
지 22
 
4.4%
대 16
 
3.2%
에 13
 
2.6%
너 12
 
2.4%
) 10
 
2.0%
Other values (111) 224
45.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 415
83.7%
Space Separator 43
 
8.7%
Close Punctuation 10
 
2.0%
Open Punctuation 9
 
1.8%
Uppercase Letter 9
 
1.8%
Lowercase Letter 6
 
1.2%
Decimal Number 3
 
0.6%
Other Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 61
 
14.7%
주 37
 
8.9%
석 30
 
7.2%
소 28
 
6.7%
지 22
 
5.3%
대 16
 
3.9%
에 13
 
3.1%
너 12
 
2.9%
일 8
 
1.9%
동 8
 
1.9%
Other values (93) 180
43.4%
Uppercase Letter
ValueCountFrequency (%)
K 2
22.2%
S 2
22.2%
G 1
11.1%
L 1
11.1%
E 1
11.1%
D 1
11.1%
O 1
11.1%
Lowercase Letter
ValueCountFrequency (%)
s 2
33.3%
k 1
16.7%
e 1
16.7%
l 1
16.7%
f 1
16.7%
Decimal Number
ValueCountFrequency (%)
3 2
66.7%
2 1
33.3%
Space Separator
ValueCountFrequency (%)
43
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 416
83.9%
Common 65
 
13.1%
Latin 15
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 61
 
14.7%
주 37
 
8.9%
석 30
 
7.2%
소 28
 
6.7%
지 22
 
5.3%
대 16
 
3.8%
에 13
 
3.1%
너 12
 
2.9%
일 8
 
1.9%
동 8
 
1.9%
Other values (94) 181
43.5%
Latin
ValueCountFrequency (%)
s 2
13.3%
K 2
13.3%
S 2
13.3%
k 1
6.7%
G 1
6.7%
L 1
6.7%
e 1
6.7%
l 1
6.7%
f 1
6.7%
E 1
6.7%
Other values (2) 2
13.3%
Common
ValueCountFrequency (%)
43
66.2%
) 10
 
15.4%
( 9
 
13.8%
3 2
 
3.1%
2 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 415
83.7%
ASCII 80
 
16.1%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
유 61
 
14.7%
주 37
 
8.9%
석 30
 
7.2%
소 28
 
6.7%
지 22
 
5.3%
대 16
 
3.9%
에 13
 
3.1%
너 12
 
2.9%
일 8
 
1.9%
동 8
 
1.9%
Other values (93) 180
43.4%
ASCII
ValueCountFrequency (%)
43
53.8%
) 10
 
12.5%
( 9
 
11.2%
s 2
 
2.5%
K 2
 
2.5%
3 2
 
2.5%
S 2
 
2.5%
k 1
 
1.2%
G 1
 
1.2%
L 1
 
1.2%
Other values (7) 7
 
8.8%
None
ValueCountFrequency (%)
㈜ 1
100.0%

최종수정일자
Date

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
Minimum2005-04-19 00:00:00
Maximum2024-01-19 09:48:34
2024-04-30T04:50:56.006985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:56.120550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터갱신구분
Categorical

Distinct2
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
I
46 
U
21 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 46
68.7%
U 21
31.3%

Length

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

Common Values (Plot)

2024-04-30T04:50:56.302383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 46
68.7%
u 21
31.3%

데이터갱신일자
Date

Distinct11
Distinct (%)16.4%
Missing0
Missing (%)0.0%
Memory size668.0 B
Minimum2018-08-31 23:59:59
Maximum2023-11-30 22:01:00
2024-04-30T04:50:56.383410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T04:50:56.477833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)

업태구분명
Categorical

Distinct3
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
일반판매소
38 
주유소
26 
용제판매소
 
3

Length

Max length5
Median length5
Mean length4.2238806
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주유소
2nd row주유소
3rd row용제판매소
4th row주유소
5th row주유소

Common Values

ValueCountFrequency (%)
일반판매소 38
56.7%
주유소 26
38.8%
용제판매소 3
 
4.5%

Length

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

Common Values (Plot)

2024-04-30T04:50:56.671715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반판매소 38
56.7%
주유소 26
38.8%
용제판매소 3
 
4.5%

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

MISSING 

Distinct59
Distinct (%)92.2%
Missing3
Missing (%)4.5%
Infinite0
Infinite (%)0.0%
Mean207486.28
Minimum206242.55
Maximum209681.33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2024-04-30T04:50:56.948301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum206242.55
5-th percentile206378
Q1206817.44
median207242.64
Q3208082.97
95-th percentile209152.94
Maximum209681.33
Range3438.7882
Interquartile range (IQR)1265.5279

Descriptive statistics

Standard deviation879.81716
Coefficient of variation (CV)0.004240363
Kurtosis-0.53304714
Mean207486.28
Median Absolute Deviation (MAD)490.01628
Skewness0.67474799
Sum13279122
Variance774078.24
MonotonicityNot monotonic
2024-04-30T04:50:57.068431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
208215.309352704 2
 
3.0%
207375.431284156 2
 
3.0%
206953.271926874 2
 
3.0%
206799.803684961 2
 
3.0%
206377.995331013 2
 
3.0%
206445.364711282 1
 
1.5%
209273.867955187 1
 
1.5%
209193.107720988 1
 
1.5%
209200.036845418 1
 
1.5%
208692.777244976 1
 
1.5%
Other values (49) 49
73.1%
(Missing) 3
 
4.5%
ValueCountFrequency (%)
206242.545350094 1
1.5%
206281.11993204 1
1.5%
206374.83138996 1
1.5%
206377.995331013 2
3.0%
206445.364711282 1
1.5%
206487.403526021 1
1.5%
206488.879061508 1
1.5%
206541.228349765 1
1.5%
206546.192640006 1
1.5%
206783.660453193 1
1.5%
ValueCountFrequency (%)
209681.333576462 1
1.5%
209273.867955187 1
1.5%
209200.036845418 1
1.5%
209193.107720988 1
1.5%
208925.347290046 1
1.5%
208848.343319635 1
1.5%
208835.809278666 1
1.5%
208821.980069335 1
1.5%
208702.907738068 1
1.5%
208692.777244976 1
1.5%

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

MISSING 

Distinct59
Distinct (%)92.2%
Missing3
Missing (%)4.5%
Infinite0
Infinite (%)0.0%
Mean454796.47
Minimum452698.93
Maximum457113.64
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2024-04-30T04:50:57.204170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum452698.93
5-th percentile453069.64
Q1454086.88
median454573.67
Q3455405.21
95-th percentile456919.27
Maximum457113.64
Range4414.7109
Interquartile range (IQR)1318.3377

Descriptive statistics

Standard deviation1131.5842
Coefficient of variation (CV)0.0024881112
Kurtosis-0.46047365
Mean454796.47
Median Absolute Deviation (MAD)704.83121
Skewness0.36896784
Sum29106974
Variance1280482.9
MonotonicityNot monotonic
2024-04-30T04:50:57.328699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
454296.43536491 2
 
3.0%
454422.111811383 2
 
3.0%
454107.289919254 2
 
3.0%
454577.218987322 2
 
3.0%
454925.007646142 2
 
3.0%
455956.113693969 1
 
1.5%
455174.161441817 1
 
1.5%
455400.244073494 1
 
1.5%
455420.126983755 1
 
1.5%
454559.965249431 1
 
1.5%
Other values (49) 49
73.1%
(Missing) 3
 
4.5%
ValueCountFrequency (%)
452698.927551063 1
1.5%
452707.501850576 1
1.5%
452983.43736388 1
1.5%
453068.290387442 1
1.5%
453077.280518337 1
1.5%
453236.084737592 1
1.5%
453528.548106528 1
1.5%
453563.525593799 1
1.5%
453676.29392157 1
1.5%
453738.952571757 1
1.5%
ValueCountFrequency (%)
457113.638411288 1
1.5%
457101.541834183 1
1.5%
457010.28289624 1
1.5%
456927.546198435 1
1.5%
456872.358630437 1
1.5%
456740.492226246 1
1.5%
456551.808608125 1
1.5%
456374.864410234 1
1.5%
456333.948394976 1
1.5%
456159.928498836 1
1.5%

자본금
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing67
Missing (%)100.0%
Memory size735.0 B

거래처
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing67
Missing (%)100.0%
Memory size735.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
03060000197630600750150000119760626<NA>3폐업3폐지20071031<NA><NA><NA>02 97331221353.0<NA>서울특별시 중랑구 묵동 175-1서울특별시 중랑구 동일로 922 (묵동)<NA>태능주유소 대신석유(주)2012-02-02 10:31:20I2018-08-31 23:59:59.0주유소206783.660453456740.492226<NA><NA>
13060000197630600750150000220070126<NA>3폐업3폐지201811092008111320090430<NA>02 220825461220.0<NA>서울특별시 중랑구 망우동 490-8서울특별시 중랑구 망우로 400 (망우동)<NA>SK네트웍스(주) 상봉주유소2018-11-09 16:51:14U2018-11-11 02:38:37.0주유소208463.143596455162.320714<NA><NA>
23060000198830600950150000419880119<NA>3폐업3폐지201607152015072820160727<NA>02 433 1379<NA><NA>서울특별시 중랑구 면목동 501-25서울특별시 중랑구 면목로55길 6 (면목동)<NA>남경상사2016-07-18 09:12:50I2018-08-31 23:59:59.0용제판매소207702.608098453563.525594<NA><NA>
33060000199030600750150000119900927<NA>3폐업3폐지201708212016110120171031<NA>4933001445.3<NA>서울특별시 중랑구 면목동 166-47서울특별시 중랑구 사가정로 341 (면목동)<NA>대농2주유소2017-08-21 11:01:51I2018-08-31 23:59:59.0주유소207214.645007453236.084738<NA><NA>
4306000019923060075015000011992-04-24<NA>1영업/정상6휴지사업재개<NA><NA><NA>2021-07-1802 4375457754.75<NA>서울특별시 중랑구 상봉동 109-45서울특별시 중랑구 봉우재로 105 (상봉동)<NA>대양주유소2023-11-02 15:06:16U2022-11-01 00:04:00.0주유소207426.656239454478.852686<NA><NA>
53060000199230600750150000219920424<NA>3폐업3폐지20170216<NA><NA><NA>4363651930.0<NA>서울특별시 중랑구 망우동 523-4서울특별시 중랑구 상봉로 58 (망우동)<NA>신일주유소2017-02-16 09:34:39I2018-08-31 23:59:59.0주유소208215.309353454296.435365<NA><NA>
6306000019933060075015000011993-12-30<NA>1영업/정상6휴지사업재개<NA>2018-10-102018-11-252018-11-2602 4950051797.45<NA>서울특별시 중랑구 면목동 155-57서울특별시 중랑구 동일로 654 (면목동)<NA>주식회사한화미 구도일주유소동천2023-11-02 15:09:04U2022-11-01 00:04:00.0주유소207256.682639453800.522218<NA><NA>
7306000019943060075015000011994-01-27<NA>1영업/정상6휴지사업재개<NA>2019-06-012019-06-032019-06-0302 4374072955.0<NA>서울특별시 중랑구 면목동 175-1서울특별시 중랑구 동일로 627 (면목동)<NA>면목self주유소2023-11-02 15:10:23U2022-11-01 00:04:00.0주유소206960.007725453785.620566<NA><NA>
8306000019993060075015000011999-09-21<NA>1영업/정상6휴지사업재개<NA>2011-08-222011-10-312011-10-3102 43851511258.75<NA>서울특별시 중랑구 상봉동 137-8서울특별시 중랑구 망우로 170 (상봉동)<NA>(주)태영 구도일주유소 한인2023-11-02 15:06:42U2022-11-01 00:04:00.0주유소206281.119932454463.857272<NA><NA>
93060000200030600750150000120050509<NA>3폐업3폐지<NA><NA><NA><NA>02 4325145900.1<NA>서울특별시 중랑구 상봉동 100, 160-6서울특별시 중랑구 망우로 311 (상봉동)<NA>(주)정원EDS 망우주유소2021-04-07 10:10:03U2021-04-09 02:40:00.0주유소207630.398131454983.799952<NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
573060000200330600750150000520031001<NA>3폐업3폐지<NA>2012062220130630201303210222075151537.4<NA>서울특별시 중랑구 면목동 198-56서울특별시 중랑구 중랑천로 57 (면목동)<NA>광진주유소2013-08-13 09:01:29I2018-08-31 23:59:59.0주유소206374.83139454233.591631<NA><NA>
583060000200430600750150001119870901<NA>3폐업3폐지2016051620120507201212312012111402 49136691041.6<NA>서울특별시 중랑구 면목동 50-2서울특별시 중랑구 용마산로 401 (면목동)<NA>면목동 주유소2016-05-16 16:43:56I2018-08-31 23:59:59.0주유소208432.425766454242.013174<NA><NA>
59306000020043060075015000242007-01-31<NA>1영업/정상6휴지사업재개<NA>2014-11-192014-11-232012-09-110222095132554.8<NA>서울특별시 중랑구 면목동 169-0003서울특별시 중랑구 동일로 547 (면목동)<NA>오천만주유소2023-11-02 15:09:59U2022-11-01 00:04:00.0주유소206937.932563452983.437364<NA><NA>
603060000200430600750150002520040726<NA>3폐업3폐지201809272018072720180927<NA>49633001083.8<NA>서울특별시 중랑구 망우동 359-2서울특별시 중랑구 망우로 436 (망우동)<NA>유성주유소2018-11-09 16:50:35U2018-11-11 02:38:37.0주유소208821.980069455257.057087<NA><NA>
613060000200530600750120000120050419<NA>1영업/정상1신규등록<NA><NA><NA><NA>22097775<NA><NA>서울특별시 중랑구 면목동 132-21서울특별시 중랑구 봉우재로 100 (면목동)<NA>경동에너지 판매2016-04-07 16:28:57I2018-08-31 23:59:59.0일반판매소207375.431284454422.111811<NA><NA>
623060000200530600750120000219991002<NA>3폐업3폐지20150819<NA><NA><NA>495 3945<NA><NA>서울특별시 중랑구 면목동 180-105서울특별시 중랑구 동일로101길 6 (면목동)<NA>LG중앙석유2015-08-19 10:15:47I2018-08-31 23:59:59.0일반판매소206953.271927454107.289919<NA><NA>
63306000020053060075015000012006-04-20<NA>1영업/정상6휴지사업재개<NA>2019-06-252019-06-302019-07-0102 4339990576.2<NA>서울특별시 중랑구 망우동 458-6서울특별시 중랑구 용마산로 487 (망우동)<NA>우림주유소2024-01-19 09:48:34U2023-11-30 22:01:00.0주유소208702.907738454708.363945<NA><NA>
64306000020053060075015000021993-12-08<NA>1영업/정상6휴지사업재개<NA><NA><NA><NA>02 9748356679.4<NA>서울특별시 중랑구 묵동 244-151서울특별시 중랑구 동일로 881 (묵동)<NA>범아주유소2023-11-02 15:07:09U2022-11-01 00:04:00.0주유소206788.712362456333.948395<NA><NA>
653060000200830600950150000120081016<NA>1영업/정상1신규등록<NA><NA><NA><NA>43990300.0<NA>서울특별시 중랑구 중화동 275-14 2통5반 3층서울특별시 중랑구 동일로144가길 28-7 (중화동)<NA>금호티엔씨2013-12-26 15:36:55I2018-08-31 23:59:59.0용제판매소207180.865372455899.403891<NA><NA>
66306000020173060145015000012017-08-24<NA>1영업/정상7영업개시<NA><NA><NA><NA>02-436-3651930.8<NA>서울특별시 중랑구 망우동 523-4서울특별시 중랑구 상봉로 58 (망우동)<NA>신일주유소2023-11-02 15:07:46U2022-11-01 00:04:00.0주유소208215.309353454296.435365<NA><NA>