Overview

Dataset statistics

Number of variables27
Number of observations63
Missing cells581
Missing cells (%)34.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.2 KiB
Average record size in memory230.1 B

Variable types

Categorical7
Numeric5
DateTime7
Unsupported4
Text4

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
인허가취소일자 has 63 (100.0%) missing valuesMissing
폐업일자 has 40 (63.5%) missing valuesMissing
휴업시작일자 has 58 (92.1%) missing valuesMissing
휴업종료일자 has 58 (92.1%) missing valuesMissing
재개업일자 has 60 (95.2%) missing valuesMissing
전화번호 has 1 (1.6%) missing valuesMissing
소재지면적 has 29 (46.0%) missing valuesMissing
소재지우편번호 has 63 (100.0%) missing valuesMissing
도로명주소 has 14 (22.2%) missing valuesMissing
도로명우편번호 has 47 (74.6%) missing valuesMissing
좌표정보(X) has 11 (17.5%) missing valuesMissing
좌표정보(Y) has 11 (17.5%) missing valuesMissing
자본금 has 63 (100.0%) missing valuesMissing
거래처 has 63 (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 04:30:28.655829
Analysis finished2024-05-11 04:30:29.708271
Duration1.05 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size636.0 B
3120000
63 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3120000 63
100.0%

Length

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

Common Values (Plot)

2024-05-11T04:30:30.561805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3120000 63
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct63
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9976295 × 1018
Minimum1.975312 × 1018
Maximum2.011312 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2024-05-11T04:30:31.042306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.975312 × 1018
5-th percentile1.977512 × 1018
Q11.993312 × 1018
median2.001312 × 1018
Q32.004312 × 1018
95-th percentile2.004312 × 1018
Maximum2.011312 × 1018
Range3.6000009 × 1016
Interquartile range (IQR)1.1000002 × 1016

Descriptive statistics

Standard deviation8.9023841 × 1015
Coefficient of variation (CV)0.0044564742
Kurtosis0.50635485
Mean1.9976295 × 1018
Median Absolute Deviation (MAD)3.0000018 × 1015
Skewness-1.1423493
Sum-3.276552 × 1018
Variance7.9252443 × 1031
MonotonicityStrictly increasing
2024-05-11T04:30:31.986001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1975312007501200025 1
 
1.6%
1975312007501500012 1
 
1.6%
2003312009301500011 1
 
1.6%
2003312009301500013 1
 
1.6%
2004312009301200001 1
 
1.6%
2004312009301500001 1
 
1.6%
2004312009301500002 1
 
1.6%
2004312009301500003 1
 
1.6%
2004312009301500004 1
 
1.6%
2004312009301500005 1
 
1.6%
Other values (53) 53
84.1%
ValueCountFrequency (%)
1975312007501200025 1
1.6%
1975312007501500012 1
1.6%
1975312011901500007 1
1.6%
1977312007501200029 1
1.6%
1979312007501200038 1
1.6%
1980312007501200037 1
1.6%
1985312007501200042 1
1.6%
1985312007501200051 1
1.6%
1987312007501200053 1
1.6%
1988312007501200054 1
1.6%
ValueCountFrequency (%)
2011312016001500001 1
1.6%
2008312011901500001 1
1.6%
2004312009301500024 1
1.6%
2004312009301500023 1
1.6%
2004312009301500022 1
1.6%
2004312009301500021 1
1.6%
2004312009301500020 1
1.6%
2004312009301500019 1
1.6%
2004312009301500018 1
1.6%
2004312009301500017 1
1.6%
Distinct42
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Memory size636.0 B
Minimum1968-11-18 00:00:00
Maximum2013-04-10 00:00:00
2024-05-11T04:30:32.708122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:33.671479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)100.0%
Memory size699.0 B
Distinct3
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size636.0 B
3
43 
1
19 
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
3 43
68.3%
1 19
30.2%
4 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T04:30:34.693408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 43
68.3%
1 19
30.2%
4 1
 
1.6%

영업상태명
Categorical

Distinct3
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size636.0 B
폐업
43 
영업/정상
19 
취소/말소/만료/정지/중지
 
1

Length

Max length14
Median length2
Mean length3.0952381
Min length2

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 43
68.3%
영업/정상 19
30.2%
취소/말소/만료/정지/중지 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T04:30:35.363450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 43
68.3%
영업/정상 19
30.2%
취소/말소/만료/정지/중지 1
 
1.6%
Distinct5
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size636.0 B
3
43 
1
12 
7
6
 
2
2
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
3 43
68.3%
1 12
 
19.0%
7 5
 
7.9%
6 2
 
3.2%
2 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T04:30:36.228732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 43
68.3%
1 12
 
19.0%
7 5
 
7.9%
6 2
 
3.2%
2 1
 
1.6%
Distinct5
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size636.0 B
폐지
43 
신규등록
12 
영업개시
휴지사업재개
 
2
등록취소
 
1

Length

Max length6
Median length2
Mean length2.6984127
Min length2

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
폐지 43
68.3%
신규등록 12
 
19.0%
영업개시 5
 
7.9%
휴지사업재개 2
 
3.2%
등록취소 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T04:30:37.242582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐지 43
68.3%
신규등록 12
 
19.0%
영업개시 5
 
7.9%
휴지사업재개 2
 
3.2%
등록취소 1
 
1.6%

폐업일자
Date

MISSING 

Distinct19
Distinct (%)82.6%
Missing40
Missing (%)63.5%
Memory size636.0 B
Minimum2008-09-24 00:00:00
Maximum2023-10-31 00:00:00
2024-05-11T04:30:37.796586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:38.338151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)

휴업시작일자
Date

MISSING 

Distinct5
Distinct (%)100.0%
Missing58
Missing (%)92.1%
Memory size636.0 B
Minimum2010-12-27 00:00:00
Maximum2014-08-01 00:00:00
2024-05-11T04:30:38.684131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:39.014550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

휴업종료일자
Date

MISSING 

Distinct5
Distinct (%)100.0%
Missing58
Missing (%)92.1%
Memory size636.0 B
Minimum2011-05-30 00:00:00
Maximum2014-12-31 00:00:00
2024-05-11T04:30:39.367969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:39.656687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=5)

재개업일자
Date

MISSING 

Distinct3
Distinct (%)100.0%
Missing60
Missing (%)95.2%
Memory size636.0 B
Minimum2011-04-01 00:00:00
Maximum2023-05-08 00:00:00
2024-05-11T04:30:39.932683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:40.419991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

전화번호
Text

MISSING 

Distinct55
Distinct (%)88.7%
Missing1
Missing (%)1.6%
Memory size636.0 B
2024-05-11T04:30:40.970331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length10.822581
Min length9

Characters and Unicode

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

Unique48 ?
Unique (%)77.4%

Sample

1st row02 3235222
2nd row02 3250886
3rd row02 336 0611
4th row02 3634459
5th row02 3736465
ValueCountFrequency (%)
02 36
36.0%
000203388045 2
 
2.0%
000207350333 2
 
2.0%
3045523 2
 
2.0%
000203724998 2
 
2.0%
000207363708 2
 
2.0%
000203045522 2
 
2.0%
3758181 2
 
2.0%
3250886 1
 
1.0%
000203356152 1
 
1.0%
Other values (48) 48
48.0%
2024-05-11T04:30:42.019632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 183
27.3%
3 108
16.1%
2 103
15.4%
5 55
 
8.2%
7 44
 
6.6%
40
 
6.0%
6 38
 
5.7%
8 31
 
4.6%
4 27
 
4.0%
1 23
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 631
94.0%
Space Separator 40
 
6.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 183
29.0%
3 108
17.1%
2 103
16.3%
5 55
 
8.7%
7 44
 
7.0%
6 38
 
6.0%
8 31
 
4.9%
4 27
 
4.3%
1 23
 
3.6%
9 19
 
3.0%
Space Separator
ValueCountFrequency (%)
40
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 671
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 183
27.3%
3 108
16.1%
2 103
15.4%
5 55
 
8.2%
7 44
 
6.6%
40
 
6.0%
6 38
 
5.7%
8 31
 
4.6%
4 27
 
4.0%
1 23
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 671
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 183
27.3%
3 108
16.1%
2 103
15.4%
5 55
 
8.2%
7 44
 
6.6%
40
 
6.0%
6 38
 
5.7%
8 31
 
4.6%
4 27
 
4.0%
1 23
 
3.4%

소재지면적
Real number (ℝ)

MISSING 

Distinct30
Distinct (%)88.2%
Missing29
Missing (%)46.0%
Infinite0
Infinite (%)0.0%
Mean706.55588
Minimum295
Maximum1577
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2024-05-11T04:30:42.443335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum295
5-th percentile322.89
Q1413.5925
median684.5
Q3924.54
95-th percentile1243.75
Maximum1577
Range1282
Interquartile range (IQR)510.9475

Descriptive statistics

Standard deviation312.90866
Coefficient of variation (CV)0.4428647
Kurtosis0.30994047
Mean706.55588
Median Absolute Deviation (MAD)270.315
Skewness0.73659289
Sum24022.9
Variance97911.828
MonotonicityNot monotonic
2024-05-11T04:30:42.970894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
760.4 2
 
3.2%
617.0 2
 
3.2%
413.0 2
 
3.2%
988.4 2
 
3.2%
410.0 1
 
1.6%
726.55 1
 
1.6%
332.2 1
 
1.6%
709.0 1
 
1.6%
759.3 1
 
1.6%
397.0 1
 
1.6%
Other values (20) 20
31.7%
(Missing) 29
46.0%
ValueCountFrequency (%)
295.0 1
1.6%
305.6 1
1.6%
332.2 1
1.6%
333.8 1
1.6%
336.6 1
1.6%
397.0 1
1.6%
410.0 1
1.6%
413.0 2
3.2%
415.37 1
1.6%
482.3 1
1.6%
ValueCountFrequency (%)
1577.0 1
1.6%
1260.0 1
1.6%
1235.0 1
1.6%
1074.4 1
1.6%
1008.0 1
1.6%
988.4 2
3.2%
986.7 1
1.6%
947.0 1
1.6%
857.16 1
1.6%
826.0 1
1.6%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)100.0%
Memory size699.0 B
Distinct59
Distinct (%)93.7%
Missing0
Missing (%)0.0%
Memory size636.0 B
2024-05-11T04:30:43.682225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length33
Mean length23.84127
Min length19

Characters and Unicode

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

Unique

Unique56 ?
Unique (%)88.9%

Sample

1st row서울특별시 서대문구 연희동 353-77
2nd row서울특별시 서대문구 연희동 86-7
3rd row서울특별시 서대문구 연희동 220-55 구도일주유소
4th row서울특별시 서대문구 북아현동 180-8
5th row서울특별시 서대문구 남가좌동 260-153
ValueCountFrequency (%)
서울특별시 63
22.7%
서대문구 58
20.9%
남가좌동 12
 
4.3%
연희동 11
 
4.0%
홍은동 8
 
2.9%
북가좌동 8
 
2.9%
홍제동 6
 
2.2%
창천동 4
 
1.4%
북아현동 4
 
1.4%
727-9 3
 
1.1%
Other values (86) 100
36.1%
2024-05-11T04:30:44.721488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
264
17.6%
123
 
8.2%
66
 
4.4%
64
 
4.3%
63
 
4.2%
63
 
4.2%
63
 
4.2%
63
 
4.2%
60
 
4.0%
- 60
 
4.0%
Other values (72) 613
40.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 869
57.9%
Decimal Number 303
 
20.2%
Space Separator 264
 
17.6%
Dash Punctuation 60
 
4.0%
Uppercase Letter 4
 
0.3%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
123
14.2%
66
 
7.6%
64
 
7.4%
63
 
7.2%
63
 
7.2%
63
 
7.2%
63
 
7.2%
60
 
6.9%
60
 
6.9%
22
 
2.5%
Other values (56) 222
25.5%
Decimal Number
ValueCountFrequency (%)
1 51
16.8%
2 45
14.9%
3 36
11.9%
4 30
9.9%
6 29
9.6%
7 29
9.6%
9 25
8.3%
8 20
 
6.6%
5 19
 
6.3%
0 19
 
6.3%
Uppercase Letter
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%
Space Separator
ValueCountFrequency (%)
264
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 869
57.9%
Common 629
41.9%
Latin 4
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
123
14.2%
66
 
7.6%
64
 
7.4%
63
 
7.2%
63
 
7.2%
63
 
7.2%
63
 
7.2%
60
 
6.9%
60
 
6.9%
22
 
2.5%
Other values (56) 222
25.5%
Common
ValueCountFrequency (%)
264
42.0%
- 60
 
9.5%
1 51
 
8.1%
2 45
 
7.2%
3 36
 
5.7%
4 30
 
4.8%
6 29
 
4.6%
7 29
 
4.6%
9 25
 
4.0%
8 20
 
3.2%
Other values (4) 40
 
6.4%
Latin
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 869
57.9%
ASCII 633
42.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
264
41.7%
- 60
 
9.5%
1 51
 
8.1%
2 45
 
7.1%
3 36
 
5.7%
4 30
 
4.7%
6 29
 
4.6%
7 29
 
4.6%
9 25
 
3.9%
8 20
 
3.2%
Other values (6) 44
 
7.0%
Hangul
ValueCountFrequency (%)
123
14.2%
66
 
7.6%
64
 
7.4%
63
 
7.2%
63
 
7.2%
63
 
7.2%
63
 
7.2%
60
 
6.9%
60
 
6.9%
22
 
2.5%
Other values (56) 222
25.5%

도로명주소
Text

MISSING 

Distinct46
Distinct (%)93.9%
Missing14
Missing (%)22.2%
Memory size636.0 B
2024-05-11T04:30:45.230504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length38
Median length32
Mean length27.142857
Min length24

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)87.8%

Sample

1st row서울특별시 서대문구 연희로 52-6 (연희동)
2nd row서울특별시 서대문구 연희로 141 (연희동)
3rd row서울특별시 서대문구 성산로 312, 구도일주유소 (연희동)
4th row서울특별시 서대문구 북아현로 71 (북아현동)
5th row서울특별시 서대문구 신촌로11길 61 (창천동)
ValueCountFrequency (%)
서울특별시 49
19.1%
서대문구 45
17.6%
연희동 10
 
3.9%
연희로 8
 
3.1%
홍은동 8
 
3.1%
북가좌동 6
 
2.3%
홍제동 6
 
2.3%
가좌로 5
 
2.0%
통일로 5
 
2.0%
남가좌동 4
 
1.6%
Other values (81) 110
43.0%
2024-05-11T04:30:46.017962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
224
 
16.8%
95
 
7.1%
( 50
 
3.8%
50
 
3.8%
50
 
3.8%
) 50
 
3.8%
50
 
3.8%
49
 
3.7%
49
 
3.7%
49
 
3.7%
Other values (87) 614
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 834
62.7%
Space Separator 224
 
16.8%
Decimal Number 154
 
11.6%
Open Punctuation 50
 
3.8%
Close Punctuation 50
 
3.8%
Other Punctuation 8
 
0.6%
Dash Punctuation 6
 
0.5%
Uppercase Letter 4
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
95
 
11.4%
50
 
6.0%
50
 
6.0%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
47
 
5.6%
Other values (70) 297
35.6%
Decimal Number
ValueCountFrequency (%)
1 38
24.7%
2 24
15.6%
5 16
10.4%
6 14
 
9.1%
3 14
 
9.1%
4 13
 
8.4%
0 12
 
7.8%
7 10
 
6.5%
8 7
 
4.5%
9 6
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%
Space Separator
ValueCountFrequency (%)
224
100.0%
Open Punctuation
ValueCountFrequency (%)
( 50
100.0%
Close Punctuation
ValueCountFrequency (%)
) 50
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 834
62.7%
Common 492
37.0%
Latin 4
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
95
 
11.4%
50
 
6.0%
50
 
6.0%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
47
 
5.6%
Other values (70) 297
35.6%
Common
ValueCountFrequency (%)
224
45.5%
( 50
 
10.2%
) 50
 
10.2%
1 38
 
7.7%
2 24
 
4.9%
5 16
 
3.3%
6 14
 
2.8%
3 14
 
2.8%
4 13
 
2.6%
0 12
 
2.4%
Other values (5) 37
 
7.5%
Latin
ValueCountFrequency (%)
K 2
50.0%
S 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 834
62.7%
ASCII 496
37.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
224
45.2%
( 50
 
10.1%
) 50
 
10.1%
1 38
 
7.7%
2 24
 
4.8%
5 16
 
3.2%
6 14
 
2.8%
3 14
 
2.8%
4 13
 
2.6%
0 12
 
2.4%
Other values (7) 41
 
8.3%
Hangul
ValueCountFrequency (%)
95
 
11.4%
50
 
6.0%
50
 
6.0%
50
 
6.0%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
49
 
5.9%
47
 
5.6%
Other values (70) 297
35.6%

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

MISSING 

Distinct15
Distinct (%)93.8%
Missing47
Missing (%)74.6%
Infinite0
Infinite (%)0.0%
Mean3687.6875
Minimum3619
Maximum3784
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2024-05-11T04:30:46.348728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3619
5-th percentile3629.5
Q13644.25
median3696
Q33717
95-th percentile3769.75
Maximum3784
Range165
Interquartile range (IQR)72.75

Descriptive statistics

Standard deviation49.533448
Coefficient of variation (CV)0.013432117
Kurtosis-0.75583514
Mean3687.6875
Median Absolute Deviation (MAD)40
Skewness0.35870314
Sum59003
Variance2453.5625
MonotonicityNot monotonic
2024-05-11T04:30:46.592948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
3633 2
 
3.2%
3716 1
 
1.6%
3619 1
 
1.6%
3720 1
 
1.6%
3714 1
 
1.6%
3647 1
 
1.6%
3636 1
 
1.6%
3653 1
 
1.6%
3726 1
 
1.6%
3784 1
 
1.6%
Other values (5) 5
 
7.9%
(Missing) 47
74.6%
ValueCountFrequency (%)
3619 1
1.6%
3633 2
3.2%
3636 1
1.6%
3647 1
1.6%
3653 1
1.6%
3659 1
1.6%
3693 1
1.6%
3699 1
1.6%
3706 1
1.6%
3714 1
1.6%
ValueCountFrequency (%)
3784 1
1.6%
3765 1
1.6%
3726 1
1.6%
3720 1
1.6%
3716 1
1.6%
3714 1
1.6%
3706 1
1.6%
3699 1
1.6%
3693 1
1.6%
3659 1
1.6%
Distinct61
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size636.0 B
2024-05-11T04:30:47.088062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length18
Mean length8.1428571
Min length2

Characters and Unicode

Total characters513
Distinct characters126
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

Unique59 ?
Unique (%)93.7%

Sample

1st row순팔에너지
2nd row현대오일뱅크(주)직영연희현대주유소
3rd row(주)한화미 구도일주유소 두꺼비
4th row능안석유
5th row삼흥석유
ValueCountFrequency (%)
주)홍남주유소 2
 
2.6%
에이치디현대오일뱅크(주)직영 2
 
2.6%
홍은주유소 2
 
2.6%
연희주유소 2
 
2.6%
대일석유 2
 
2.6%
폐지처리 1
 
1.3%
문화촌(중복입력으로 1
 
1.3%
남정주유소 1
 
1.3%
지에스칼텍스(주)가좌점 1
 
1.3%
신우주유소 1
 
1.3%
Other values (62) 62
80.5%
2024-05-11T04:30:47.958416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
51
 
9.9%
48
 
9.4%
( 27
 
5.3%
) 27
 
5.3%
26
 
5.1%
19
 
3.7%
18
 
3.5%
15
 
2.9%
14
 
2.7%
12
 
2.3%
Other values (116) 256
49.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 431
84.0%
Open Punctuation 27
 
5.3%
Close Punctuation 27
 
5.3%
Space Separator 14
 
2.7%
Uppercase Letter 10
 
1.9%
Lowercase Letter 2
 
0.4%
Other Symbol 1
 
0.2%
Decimal Number 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
51
 
11.8%
48
 
11.1%
26
 
6.0%
19
 
4.4%
18
 
4.2%
15
 
3.5%
12
 
2.8%
9
 
2.1%
8
 
1.9%
8
 
1.9%
Other values (104) 217
50.3%
Uppercase Letter
ValueCountFrequency (%)
S 4
40.0%
K 3
30.0%
E 1
 
10.0%
N 1
 
10.0%
M 1
 
10.0%
Lowercase Letter
ValueCountFrequency (%)
k 1
50.0%
s 1
50.0%
Open Punctuation
ValueCountFrequency (%)
( 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27
100.0%
Space Separator
ValueCountFrequency (%)
14
100.0%
Other Symbol
ValueCountFrequency (%)
1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 432
84.2%
Common 69
 
13.5%
Latin 12
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
51
 
11.8%
48
 
11.1%
26
 
6.0%
19
 
4.4%
18
 
4.2%
15
 
3.5%
12
 
2.8%
9
 
2.1%
8
 
1.9%
8
 
1.9%
Other values (105) 218
50.5%
Latin
ValueCountFrequency (%)
S 4
33.3%
K 3
25.0%
k 1
 
8.3%
s 1
 
8.3%
E 1
 
8.3%
N 1
 
8.3%
M 1
 
8.3%
Common
ValueCountFrequency (%)
( 27
39.1%
) 27
39.1%
14
20.3%
2 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 431
84.0%
ASCII 81
 
15.8%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
51
 
11.8%
48
 
11.1%
26
 
6.0%
19
 
4.4%
18
 
4.2%
15
 
3.5%
12
 
2.8%
9
 
2.1%
8
 
1.9%
8
 
1.9%
Other values (104) 217
50.3%
ASCII
ValueCountFrequency (%)
( 27
33.3%
) 27
33.3%
14
17.3%
S 4
 
4.9%
K 3
 
3.7%
k 1
 
1.2%
s 1
 
1.2%
2 1
 
1.2%
E 1
 
1.2%
N 1
 
1.2%
None
ValueCountFrequency (%)
1
100.0%

최종수정일자
Date

UNIQUE 

Distinct63
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size636.0 B
Minimum2002-09-16 00:00:00
Maximum2024-03-25 14:18:53
2024-05-11T04:30:48.364810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:48.979413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct2
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size636.0 B
I
42 
U
21 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 42
66.7%
U 21
33.3%

Length

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

Common Values (Plot)

2024-05-11T04:30:49.714417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 42
66.7%
u 21
33.3%
Distinct20
Distinct (%)31.7%
Missing0
Missing (%)0.0%
Memory size636.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-02 22:07:00
2024-05-11T04:30:49.991797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T04:30:50.405978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)

업태구분명
Categorical

Distinct3
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size636.0 B
주유소
34 
일반판매소
27 
용제판매소
 
2

Length

Max length5
Median length3
Mean length3.9206349
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반판매소
2nd row주유소
3rd row주유소
4th row일반판매소
5th row일반판매소

Common Values

ValueCountFrequency (%)
주유소 34
54.0%
일반판매소 27
42.9%
용제판매소 2
 
3.2%

Length

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

Common Values (Plot)

2024-05-11T04:30:50.915731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주유소 34
54.0%
일반판매소 27
42.9%
용제판매소 2
 
3.2%

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

MISSING 

Distinct43
Distinct (%)82.7%
Missing11
Missing (%)17.5%
Infinite0
Infinite (%)0.0%
Mean194692.59
Minimum191434.89
Maximum203405.72
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2024-05-11T04:30:51.132200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum191434.89
5-th percentile191906.3
Q1193208.84
median194082.29
Q3195428.29
95-th percentile201184.58
Maximum203405.72
Range11970.834
Interquartile range (IQR)2219.4442

Descriptive statistics

Standard deviation2623.6735
Coefficient of variation (CV)0.01347598
Kurtosis5.3301561
Mean194692.59
Median Absolute Deviation (MAD)951.69241
Skewness2.1630468
Sum10124015
Variance6883662.8
MonotonicityNot monotonic
2024-05-11T04:30:51.446463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
203405.721138531 3
 
4.8%
193447.061786569 3
 
4.8%
195386.798626154 2
 
3.2%
195462.16750326 2
 
3.2%
193969.903312051 2
 
3.2%
193130.600891 2
 
3.2%
193201.0902255 2
 
3.2%
194318.160797684 1
 
1.6%
192210.660533043 1
 
1.6%
196259.607806599 1
 
1.6%
Other values (33) 33
52.4%
(Missing) 11
 
17.5%
ValueCountFrequency (%)
191434.887463719 1
1.6%
191533.188591152 1
1.6%
191736.295456676 1
1.6%
192045.390877396 1
1.6%
192210.660533043 1
1.6%
192211.628331859 1
1.6%
192760.827056034 1
1.6%
192882.545271948 1
1.6%
193130.600891 2
3.2%
193150.568005 1
1.6%
ValueCountFrequency (%)
203405.721138531 3
4.8%
199367.291009454 1
 
1.6%
196525.591393872 1
 
1.6%
196403.286823931 1
 
1.6%
196259.607806599 1
 
1.6%
195919.24699074 1
 
1.6%
195792.965700727 1
 
1.6%
195765.084238415 1
 
1.6%
195525.670223111 1
 
1.6%
195462.16750326 2
3.2%

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

MISSING 

Distinct43
Distinct (%)82.7%
Missing11
Missing (%)17.5%
Infinite0
Infinite (%)0.0%
Mean451778.3
Minimum443926.33
Maximum455290.68
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2024-05-11T04:30:51.706344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum443926.33
5-th percentile444306.9
Q1451173.76
median452281.53
Q3453306.11
95-th percentile454796.34
Maximum455290.68
Range11364.35
Interquartile range (IQR)2132.345

Descriptive statistics

Standard deviation2542.3298
Coefficient of variation (CV)0.0056273835
Kurtosis4.5041805
Mean451778.3
Median Absolute Deviation (MAD)1050.5521
Skewness-2.0311081
Sum23492472
Variance6463440.6
MonotonicityNot monotonic
2024-05-11T04:30:51.982368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
443926.327308964 3
 
4.8%
453332.086866044 3
 
4.8%
454801.317451886 2
 
3.2%
453544.92754918 2
 
3.2%
451891.090959018 2
 
3.2%
452622.365184 2
 
3.2%
453642.484590864 2
 
3.2%
453156.063553934 1
 
1.6%
453297.445396786 1
 
1.6%
452003.400133964 1
 
1.6%
Other values (33) 33
52.4%
(Missing) 11
 
17.5%
ValueCountFrequency (%)
443926.327308964 3
4.8%
444618.275228343 1
 
1.6%
450364.796288178 1
 
1.6%
450561.60587991 1
 
1.6%
450664.906576968 1
 
1.6%
450724.988814088 1
 
1.6%
450728.003306486 1
 
1.6%
450755.756657398 1
 
1.6%
450841.063021388 1
 
1.6%
450972.327957594 1
 
1.6%
ValueCountFrequency (%)
455290.677092044 1
 
1.6%
454801.317451886 2
3.2%
454792.269278016 1
 
1.6%
454077.940524278 1
 
1.6%
453642.484590864 2
3.2%
453544.92754918 2
3.2%
453473.190785987 1
 
1.6%
453332.086866044 3
4.8%
453297.445396786 1
 
1.6%
453215.0823555 1
 
1.6%

자본금
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)100.0%
Memory size699.0 B

거래처
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing63
Missing (%)100.0%
Memory size699.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
03120000197531200750120002519750911<NA>1영업/정상1신규등록<NA><NA><NA><NA>02 3235222<NA><NA>서울특별시 서대문구 연희동 353-77서울특별시 서대문구 연희로 52-6 (연희동)<NA>순팔에너지2022-11-14 17:21:54U2021-10-31 23:06:00.0일반판매소193601.633872451178.38186<NA><NA>
13120000197531200750150001219750423<NA>3폐업3폐지20150301<NA><NA><NA>02 3250886811.8<NA>서울특별시 서대문구 연희동 86-7서울특별시 서대문구 연희로 141 (연희동)<NA>현대오일뱅크(주)직영연희현대주유소2015-03-03 17:36:31I2018-08-31 23:59:59.0주유소194031.198255451989.211722<NA><NA>
2312000019753120119015000071975-03-08<NA>1영업/정상7영업개시<NA>2013-03-012013-06-30<NA>02 336 06111235.0<NA>서울특별시 서대문구 연희동 220-55 구도일주유소서울특별시 서대문구 성산로 312, 구도일주유소 (연희동)3716(주)한화미 구도일주유소 두꺼비2023-09-12 15:14:38U2022-12-08 23:04:00.0주유소193295.909036451531.90909<NA><NA>
33120000197731200750120002919771210<NA>3폐업3폐지20141108<NA><NA><NA>02 3634459<NA><NA>서울특별시 서대문구 북아현동 180-8서울특별시 서대문구 북아현로 71 (북아현동)<NA>능안석유2014-11-14 10:31:56I2018-08-31 23:59:59.0일반판매소195919.246991451227.236219<NA><NA>
43120000197931200750120003819790214<NA>3폐업3폐지<NA><NA><NA><NA>02 3736465<NA><NA>서울특별시 서대문구 남가좌동 260-153<NA><NA>삼흥석유2002-09-16 00:00:00I2018-08-31 23:59:59.0일반판매소<NA><NA><NA><NA>
53120000198031200750120003719800501<NA>3폐업3폐지<NA><NA><NA><NA>02 3073800<NA><NA>서울특별시 서대문구 북가좌동 68-82<NA><NA>동신석유2009-02-27 15:37:04I2018-08-31 23:59:59.0일반판매소<NA><NA><NA><NA>
63120000198531200750120004219850326<NA>3폐업3폐지20090227<NA><NA><NA>02 3051977<NA><NA>서울특별시 서대문구 북가좌동 418-20<NA><NA>서문이동석유2009-02-27 15:24:28I2018-08-31 23:59:59.0일반판매소<NA><NA><NA><NA>
73120000198531200750120005119850619<NA>3폐업3폐지<NA><NA><NA><NA>02 3620693<NA><NA>서울특별시 서대문구 북아현동 159-37<NA><NA>사우디석유2003-02-04 00:00:00I2018-08-31 23:59:59.0일반판매소195792.965701450724.988814<NA><NA>
83120000198731200750120005319870313<NA>3폐업3폐지20081024<NA><NA><NA>02 3728567<NA><NA>서울특별시 서대문구 남가좌동 124-382<NA><NA>종합석유상사2008-10-24 11:15:57I2018-08-31 23:59:59.0일반판매소<NA><NA><NA><NA>
93120000198831200750120005419881025<NA>3폐업3폐지20160801<NA><NA><NA>02 3350440<NA><NA>서울특별시 서대문구 창천동 53-66서울특별시 서대문구 신촌로11길 61 (창천동)<NA>대우석유2016-08-03 16:31:28I2018-08-31 23:59:59.0일반판매소194133.388348450755.756657<NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)자본금거래처
533120000200431200930150001719930616<NA>3폐업3폐지20110531<NA><NA><NA>000203075751413.0<NA>서울특별시 서대문구 남가좌동 76-145 16통2반서울특별시 서대문구 모래내로 203 (남가좌동)<NA>(주)홍남주유소2011-05-31 16:19:14I2018-08-31 23:59:59.0주유소193130.600891452622.365184<NA><NA>
543120000200431200930150001820040519<NA>3폐업3폐지20180402<NA><NA><NA>000203722557295.0<NA>서울특별시 서대문구 홍은동 342-16서울특별시 서대문구 가좌로 146 (홍은동)<NA>(주)건화 홍은주유소2018-05-23 19:42:43I2018-08-31 23:59:59.0주유소193201.090225453642.484591<NA><NA>
553120000200431200930150001919930909<NA>3폐업3폐지<NA><NA><NA><NA>02 3720162397.0<NA>서울특별시 서대문구 남가좌동 241-48<NA><NA>명지주유소2007-03-05 00:00:00I2018-08-31 23:59:59.0주유소<NA><NA><NA><NA>
563120000200431200930150002019930616<NA>1영업/정상7영업개시<NA>2013112620140101<NA>000203622156759.3<NA>서울특별시 서대문구 대신동 16-7 SK 행촌 제2주유소서울특별시 서대문구 성산로 490, SK 행촌 제2주유소 (대신동)3765행촌 제2주유소2022-09-02 18:44:36U2021-12-09 00:04:00.0주유소194764.600441450972.327958<NA><NA>
573120000200431200930150002120040519<NA>3폐업3폐지20180206<NA><NA><NA>000203954300617.0<NA>서울특별시 서대문구 홍제동 279-10서울특별시 서대문구 세검정로 87 (홍제동)<NA>문화촌(중복입력으로 폐지처리)2018-05-01 17:57:33I2018-08-31 23:59:59.0주유소195386.798626454801.317452<NA><NA>
583120000200431200930150002220040519<NA>1영업/정상7영업개시<NA>201408012014123120120224000203045522709.0<NA>서울특별시 서대문구 홍은동 379-6 신우주유소서울특별시 서대문구 가좌로 106, 신우주유소 (홍은동)3659(주)미래아스팔트 신우주유소2022-01-20 16:36:18U2022-01-22 02:40:00.0주유소193447.061787453332.086866<NA><NA>
593120000200431200930150002320040519<NA>1영업/정상1신규등록<NA><NA><NA><NA>000203059828332.2<NA>서울특별시 서대문구 남가좌동 329-34서울특별시 서대문구 모래내로 243 (남가좌동)3693남정주유소2020-05-22 21:44:15U2020-05-24 02:40:00.0주유소193352.234633452599.960623<NA><NA>
603120000200431200930150002420040519<NA>3폐업3폐지20150728<NA><NA><NA>000203758600726.55<NA>서울특별시 서대문구 북가좌동 392-5서울특별시 서대문구 수색로 153 (북가좌동)<NA>유풍주유소2018-05-01 18:15:10I2018-08-31 23:59:59.0주유소191434.887464452608.926771<NA><NA>
613120000200831201190150000120080909<NA>1영업/정상1신규등록<NA><NA><NA><NA>023855555<NA><NA>서울특별시 서대문구 북가좌동 293-4서울특별시 서대문구 응암로 94 (북가좌동)<NA>SM켐2018-04-05 21:33:26I2018-08-31 23:59:59.0용제판매소192211.628332453215.082356<NA><NA>
623120000201131201600150000120130410<NA>1영업/정상7영업개시<NA><NA><NA><NA><NA>410.0<NA>서울특별시 서대문구 남가좌동 80-26서울특별시 서대문구 모래내로 205 (남가좌동)<NA>㈜가재울뉴타운주유소2020-05-23 14:21:30U2020-05-26 02:40:00.0주유소193150.568005452637.96087<NA><NA>