Overview

Dataset statistics

Number of variables27
Number of observations61
Missing cells246
Missing cells (%)14.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.8 KiB
Average record size in memory232.2 B

Variable types

Categorical14
Numeric3
DateTime4
Unsupported3
Text3

Dataset

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

Alerts

개방자치단체코드 has constant value ""Constant
휴업시작일자 is highly imbalanced (84.8%)Imbalance
휴업종료일자 is highly imbalanced (84.8%)Imbalance
재개업일자 is highly imbalanced (87.9%)Imbalance
소재지면적 is highly imbalanced (87.9%)Imbalance
도로명우편번호 is highly imbalanced (63.6%)Imbalance
업태구분명 is highly imbalanced (66.7%)Imbalance
인허가취소일자 has 61 (100.0%) missing valuesMissing
폐업일자 has 52 (85.2%) missing valuesMissing
전화번호 has 61 (100.0%) missing valuesMissing
소재지우편번호 has 61 (100.0%) missing valuesMissing
지번주소 has 1 (1.6%) missing valuesMissing
도로명주소 has 8 (13.1%) missing valuesMissing
좌표정보(X) has 1 (1.6%) missing valuesMissing
좌표정보(Y) has 1 (1.6%) 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

Reproduction

Analysis started2024-05-11 05:41:51.156604
Analysis finished2024-05-11 05:41:51.732656
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
3100000
61 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3100000 61
100.0%

Length

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

Common Values (Plot)

2024-05-11T14:41:51.981486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3100000 61
100.0%

관리번호
Real number (ℝ)

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0048018 × 1018
Minimum1.98731 × 1018
Maximum2.02431 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2024-05-11T14:41:52.120429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.98731 × 1018
5-th percentile1.99131 × 1018
Q11.99731 × 1018
median2.00331 × 1018
Q32.01031 × 1018
95-th percentile2.01931 × 1018
Maximum2.02431 × 1018
Range3.7000008 × 1016
Interquartile range (IQR)1.3 × 1016

Descriptive statistics

Standard deviation9.0822615 × 1015
Coefficient of variation (CV)0.004530254
Kurtosis-0.53659407
Mean2.0048018 × 1018
Median Absolute Deviation (MAD)6.0000013 × 1015
Skewness0.23002336
Sum-6.8342978 × 1018
Variance8.2487473 × 1031
MonotonicityStrictly increasing
2024-05-11T14:41:52.321859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1987310017302200018 1
 
1.6%
2010310010902200000 1
 
1.6%
2005310009602100001 1
 
1.6%
2005310009602200001 1
 
1.6%
2005310009602200002 1
 
1.6%
2006310009602200001 1
 
1.6%
2007310010902100001 1
 
1.6%
2007310010902200001 1
 
1.6%
2007310010902200002 1
 
1.6%
2007310010902200003 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
1987310017302200018 1
1.6%
1989310010902100001 1
1.6%
1990310009602170033 1
1.6%
1991310009602170035 1
1.6%
1991310010902100036 1
1.6%
1992310010902100001 1
1.6%
1992310017302100037 1
1.6%
1992310017302100039 1
1.6%
1995310010902100001 1
1.6%
1995310010902100008 1
1.6%
ValueCountFrequency (%)
2024310025302100001 1
1.6%
2023310025302200001 1
1.6%
2022310017302200001 1
1.6%
2019310017302200001 1
1.6%
2018310017302200003 1
1.6%
2018310017302200002 1
1.6%
2018310017302200001 1
1.6%
2017310017302200002 1
1.6%
2017310017302200001 1
1.6%
2016310017302200001 1
1.6%
Distinct57
Distinct (%)93.4%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum1987-10-30 00:00:00
Maximum2024-04-03 00:00:00
2024-05-11T14:41:52.538496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:41:52.748518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing61
Missing (%)100.0%
Memory size681.0 B
Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
1
50 
3
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 50
82.0%
3 9
 
14.8%
2 2
 
3.3%

Length

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

Common Values (Plot)

2024-05-11T14:41:53.044101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 50
82.0%
3 9
 
14.8%
2 2
 
3.3%

영업상태명
Categorical

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
영업/정상
50 
폐업
휴업
 
2

Length

Max length5
Median length5
Mean length4.4590164
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업/정상 50
82.0%
폐업 9
 
14.8%
휴업 2
 
3.3%

Length

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

Common Values (Plot)

2024-05-11T14:41:53.339227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 50
82.0%
폐업 9
 
14.8%
휴업 2
 
3.3%
Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
1
50 
3
2
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 50
82.0%
3 9
 
14.8%
2 2
 
3.3%

Length

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

Common Values (Plot)

2024-05-11T14:41:53.666344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 50
82.0%
3 9
 
14.8%
2 2
 
3.3%
Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
영업중
50 
폐업
휴업
 
2

Length

Max length3
Median length3
Mean length2.8196721
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row휴업
2nd row폐업
3rd row영업중
4th row영업중
5th row폐업

Common Values

ValueCountFrequency (%)
영업중 50
82.0%
폐업 9
 
14.8%
휴업 2
 
3.3%

Length

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

Common Values (Plot)

2024-05-11T14:41:54.458081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 50
82.0%
폐업 9
 
14.8%
휴업 2
 
3.3%

폐업일자
Date

MISSING 

Distinct9
Distinct (%)100.0%
Missing52
Missing (%)85.2%
Memory size620.0 B
Minimum2007-07-19 00:00:00
Maximum2024-02-13 00:00:00
2024-05-11T14:41:54.595009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:41:54.762943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

휴업시작일자
Categorical

IMBALANCE 

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
59 
20190429
 
1
20160408
 
1

Length

Max length8
Median length4
Mean length4.1311475
Min length4

Unique

Unique2 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 59
96.7%
20190429 1
 
1.6%
20160408 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:41:55.165855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 59
96.7%
20190429 1
 
1.6%
20160408 1
 
1.6%

휴업종료일자
Categorical

IMBALANCE 

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
59 
20190429
 
1
20160408
 
1

Length

Max length8
Median length4
Mean length4.1311475
Min length4

Unique

Unique2 ?
Unique (%)3.3%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 59
96.7%
20190429 1
 
1.6%
20160408 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:41:55.511739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 59
96.7%
20190429 1
 
1.6%
20160408 1
 
1.6%

재개업일자
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
60 
20070716
 
1

Length

Max length8
Median length4
Mean length4.0655738
Min length4

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 60
98.4%
20070716 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:41:55.844311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 60
98.4%
20070716 1
 
1.6%

전화번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing61
Missing (%)100.0%
Memory size681.0 B

소재지면적
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
60 
0
 
1

Length

Max length4
Median length4
Mean length3.9508197
Min length1

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 60
98.4%
0 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:41:56.187019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 60
98.4%
0 1
 
1.6%

소재지우편번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing61
Missing (%)100.0%
Memory size681.0 B

지번주소
Text

MISSING 

Distinct51
Distinct (%)85.0%
Missing1
Missing (%)1.6%
Memory size620.0 B
2024-05-11T14:41:56.491576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length37
Mean length22.266667
Min length17

Characters and Unicode

Total characters1336
Distinct characters77
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

Unique43 ?
Unique (%)71.7%

Sample

1st row서울특별시 노원구 공릉동 581-1
2nd row서울특별시 노원구 중계동 507-3
3rd row서울특별시 노원구 공릉동 172
4th row서울특별시 노원구 월계동 333-1 월계이마트
5th row서울특별시 노원구 상계동 705
ValueCountFrequency (%)
서울특별시 60
22.7%
노원구 60
22.7%
상계동 21
 
8.0%
공릉동 14
 
5.3%
중계동 11
 
4.2%
하계동 8
 
3.0%
월계동 6
 
2.3%
251-14 4
 
1.5%
215-4 4
 
1.5%
509 3
 
1.1%
Other values (57) 73
27.7%
2024-05-11T14:41:57.099556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
253
18.9%
70
 
5.2%
68
 
5.1%
65
 
4.9%
64
 
4.8%
60
 
4.5%
60
 
4.5%
60
 
4.5%
60
 
4.5%
60
 
4.5%
Other values (67) 516
38.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 796
59.6%
Space Separator 253
 
18.9%
Decimal Number 245
 
18.3%
Dash Punctuation 40
 
3.0%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
70
 
8.8%
68
 
8.5%
65
 
8.2%
64
 
8.0%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
51
 
6.4%
Other values (53) 178
22.4%
Decimal Number
ValueCountFrequency (%)
1 57
23.3%
2 30
12.2%
7 27
11.0%
3 27
11.0%
0 22
 
9.0%
5 21
 
8.6%
4 19
 
7.8%
6 17
 
6.9%
9 15
 
6.1%
8 10
 
4.1%
Space Separator
ValueCountFrequency (%)
253
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 40
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 796
59.6%
Common 540
40.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
70
 
8.8%
68
 
8.5%
65
 
8.2%
64
 
8.0%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
51
 
6.4%
Other values (53) 178
22.4%
Common
ValueCountFrequency (%)
253
46.9%
1 57
 
10.6%
- 40
 
7.4%
2 30
 
5.6%
7 27
 
5.0%
3 27
 
5.0%
0 22
 
4.1%
5 21
 
3.9%
4 19
 
3.5%
6 17
 
3.1%
Other values (4) 27
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 796
59.6%
ASCII 540
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
253
46.9%
1 57
 
10.6%
- 40
 
7.4%
2 30
 
5.6%
7 27
 
5.0%
3 27
 
5.0%
0 22
 
4.1%
5 21
 
3.9%
4 19
 
3.5%
6 17
 
3.1%
Other values (4) 27
 
5.0%
Hangul
ValueCountFrequency (%)
70
 
8.8%
68
 
8.5%
65
 
8.2%
64
 
8.0%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
60
 
7.5%
51
 
6.4%
Other values (53) 178
22.4%

도로명주소
Text

MISSING 

Distinct38
Distinct (%)71.7%
Missing8
Missing (%)13.1%
Memory size620.0 B
2024-05-11T14:41:57.420994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length32
Mean length25.811321
Min length22

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)47.2%

Sample

1st row서울특별시 노원구 동일로180길 14 (공릉동)
2nd row서울특별시 노원구 동일로 1229 (중계동)
3rd row서울특별시 노원구 공릉로 232 (공릉동)
4th row서울특별시 노원구 마들로3길 15, 월계이마트 (월계동)
5th row서울특별시 노원구 노해로 447 (상계동)
ValueCountFrequency (%)
서울특별시 53
19.1%
노원구 53
19.1%
상계동 17
 
6.1%
공릉동 14
 
5.1%
중계동 10
 
3.6%
노원로 8
 
2.9%
월계동 6
 
2.2%
하계동 6
 
2.2%
75 5
 
1.8%
한글비석로 5
 
1.8%
Other values (58) 100
36.1%
2024-05-11T14:41:57.905869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
226
 
16.5%
69
 
5.0%
68
 
5.0%
65
 
4.8%
55
 
4.0%
) 53
 
3.9%
( 53
 
3.9%
53
 
3.9%
53
 
3.9%
53
 
3.9%
Other values (50) 620
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 842
61.5%
Space Separator 226
 
16.5%
Decimal Number 185
 
13.5%
Close Punctuation 53
 
3.9%
Open Punctuation 53
 
3.9%
Other Punctuation 8
 
0.6%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
 
8.2%
68
 
8.1%
65
 
7.7%
55
 
6.5%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
Other values (35) 267
31.7%
Decimal Number
ValueCountFrequency (%)
1 33
17.8%
2 31
16.8%
4 29
15.7%
3 18
9.7%
7 17
9.2%
8 15
8.1%
9 14
7.6%
0 13
 
7.0%
5 11
 
5.9%
6 4
 
2.2%
Space Separator
ValueCountFrequency (%)
226
100.0%
Close Punctuation
ValueCountFrequency (%)
) 53
100.0%
Open Punctuation
ValueCountFrequency (%)
( 53
100.0%
Other Punctuation
ValueCountFrequency (%)
, 8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 842
61.5%
Common 526
38.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
 
8.2%
68
 
8.1%
65
 
7.7%
55
 
6.5%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
Other values (35) 267
31.7%
Common
ValueCountFrequency (%)
226
43.0%
) 53
 
10.1%
( 53
 
10.1%
1 33
 
6.3%
2 31
 
5.9%
4 29
 
5.5%
3 18
 
3.4%
7 17
 
3.2%
8 15
 
2.9%
9 14
 
2.7%
Other values (5) 37
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 842
61.5%
ASCII 526
38.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
226
43.0%
) 53
 
10.1%
( 53
 
10.1%
1 33
 
6.3%
2 31
 
5.9%
4 29
 
5.5%
3 18
 
3.4%
7 17
 
3.2%
8 15
 
2.9%
9 14
 
2.7%
Other values (5) 37
 
7.0%
Hangul
ValueCountFrequency (%)
69
 
8.2%
68
 
8.1%
65
 
7.7%
55
 
6.5%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
53
 
6.3%
Other values (35) 267
31.7%

도로명우편번호
Categorical

IMBALANCE 

Distinct6
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
52 
1906
 
2
1812
 
2
1803
 
2
1791
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)1.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 52
85.2%
1906 2
 
3.3%
1812 2
 
3.3%
1803 2
 
3.3%
1791 2
 
3.3%
1805 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:41:58.337135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 52
85.2%
1906 2
 
3.3%
1812 2
 
3.3%
1803 2
 
3.3%
1791 2
 
3.3%
1805 1
 
1.6%
Distinct53
Distinct (%)86.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
2024-05-11T14:41:58.688877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length15
Mean length9.8360656
Min length4

Characters and Unicode

Total characters600
Distinct characters155
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

Unique49 ?
Unique (%)80.3%

Sample

1st row석진실업(주)
2nd row노원구민회관
3rd row서울과학기술대학교
4th row(주) 이마트 월계점
5th row주식회사 태웅관리시스템
ValueCountFrequency (%)
6
 
6.1%
롯데쇼핑(주 5
 
5.1%
중계점 5
 
5.1%
노원소방서 4
 
4.1%
노원점 3
 
3.1%
한국원자력의학원 3
 
3.1%
월계점 2
 
2.0%
서울에너지공사 2
 
2.0%
원자력병원 2
 
2.0%
충전소 2
 
2.0%
Other values (62) 64
65.3%
2024-05-11T14:41:59.467674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
37
 
6.2%
30
 
5.0%
25
 
4.2%
( 21
 
3.5%
) 21
 
3.5%
16
 
2.7%
14
 
2.3%
14
 
2.3%
13
 
2.2%
13
 
2.2%
Other values (145) 396
66.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 514
85.7%
Space Separator 37
 
6.2%
Open Punctuation 21
 
3.5%
Close Punctuation 21
 
3.5%
Decimal Number 4
 
0.7%
Uppercase Letter 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
30
 
5.8%
25
 
4.9%
16
 
3.1%
14
 
2.7%
14
 
2.7%
13
 
2.5%
13
 
2.5%
13
 
2.5%
12
 
2.3%
12
 
2.3%
Other values (136) 352
68.5%
Decimal Number
ValueCountFrequency (%)
0 2
50.0%
2 1
25.0%
1 1
25.0%
Uppercase Letter
ValueCountFrequency (%)
N 1
33.3%
G 1
33.3%
C 1
33.3%
Space Separator
ValueCountFrequency (%)
37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 514
85.7%
Common 83
 
13.8%
Latin 3
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
30
 
5.8%
25
 
4.9%
16
 
3.1%
14
 
2.7%
14
 
2.7%
13
 
2.5%
13
 
2.5%
13
 
2.5%
12
 
2.3%
12
 
2.3%
Other values (136) 352
68.5%
Common
ValueCountFrequency (%)
37
44.6%
( 21
25.3%
) 21
25.3%
0 2
 
2.4%
2 1
 
1.2%
1 1
 
1.2%
Latin
ValueCountFrequency (%)
N 1
33.3%
G 1
33.3%
C 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 514
85.7%
ASCII 86
 
14.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
37
43.0%
( 21
24.4%
) 21
24.4%
0 2
 
2.3%
N 1
 
1.2%
G 1
 
1.2%
C 1
 
1.2%
2 1
 
1.2%
1 1
 
1.2%
Hangul
ValueCountFrequency (%)
30
 
5.8%
25
 
4.9%
16
 
3.1%
14
 
2.7%
14
 
2.7%
13
 
2.5%
13
 
2.5%
13
 
2.5%
12
 
2.3%
12
 
2.3%
Other values (136) 352
68.5%

최종수정일자
Date

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum2007-07-19 17:47:20
Maximum2024-04-24 09:06:37
2024-05-11T14:41:59.642451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:41:59.814260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct2
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size620.0 B
I
40 
U
21 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 40
65.6%
U 21
34.4%

Length

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

Common Values (Plot)

2024-05-11T14:42:00.087901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 40
65.6%
u 21
34.4%
Distinct25
Distinct (%)41.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum2018-08-31 23:59:59
Maximum2023-12-04 00:05:00
2024-05-11T14:42:00.211234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:42:00.384517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)

업태구분명
Categorical

IMBALANCE 

Distinct3
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size620.0 B
제조
55 
저장소
 
5
판매
 
1

Length

Max length3
Median length2
Mean length2.0819672
Min length2

Unique

Unique1 ?
Unique (%)1.6%

Sample

1st row제조
2nd row제조
3rd row제조
4th row제조
5th row제조

Common Values

ValueCountFrequency (%)
제조 55
90.2%
저장소 5
 
8.2%
판매 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:42:00.722215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제조 55
90.2%
저장소 5
 
8.2%
판매 1
 
1.6%

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

MISSING 

Distinct39
Distinct (%)65.0%
Missing1
Missing (%)1.6%
Infinite0
Infinite (%)0.0%
Mean206087.64
Minimum204616.1
Maximum209288.47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2024-05-11T14:42:00.907273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum204616.1
5-th percentile204853.74
Q1205391.07
median205985.95
Q3206719.59
95-th percentile207439.15
Maximum209288.47
Range4672.3752
Interquartile range (IQR)1328.5159

Descriptive statistics

Standard deviation925.82719
Coefficient of variation (CV)0.0044923956
Kurtosis1.5082724
Mean206087.64
Median Absolute Deviation (MAD)630.27575
Skewness1.0170026
Sum12365258
Variance857155.99
MonotonicityNot monotonic
2024-05-11T14:42:01.061067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
206203.582452672 4
 
6.6%
206719.586259379 3
 
4.9%
205931.05327036 3
 
4.9%
206981.454072644 3
 
4.9%
205320.28476675 3
 
4.9%
207192.873108421 3
 
4.9%
205391.070378059 2
 
3.3%
204842.815053968 2
 
3.3%
206204.445134058 2
 
3.3%
206102.455977834 2
 
3.3%
Other values (29) 33
54.1%
ValueCountFrequency (%)
204616.097464886 1
 
1.6%
204842.815053968 2
3.3%
204854.312535023 1
 
1.6%
205027.078637975 1
 
1.6%
205037.515151777 1
 
1.6%
205075.814875736 1
 
1.6%
205136.500230395 2
3.3%
205157.94751541 1
 
1.6%
205198.498721037 1
 
1.6%
205320.28476675 3
4.9%
ValueCountFrequency (%)
209288.472624641 1
 
1.6%
208532.777004106 1
 
1.6%
207692.762282435 1
 
1.6%
207425.804146 2
3.3%
207192.873108421 3
4.9%
207059.794767452 1
 
1.6%
206981.454072644 3
4.9%
206934.100502146 1
 
1.6%
206719.586259379 3
4.9%
206578.976039388 1
 
1.6%

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

MISSING 

Distinct39
Distinct (%)65.0%
Missing1
Missing (%)1.6%
Infinite0
Infinite (%)0.0%
Mean459869.36
Minimum457415.65
Maximum462942.06
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2024-05-11T14:42:01.209184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum457415.65
5-th percentile457785.49
Q1458960.47
median459748.44
Q3460719.69
95-th percentile461872.7
Maximum462942.06
Range5526.4141
Interquartile range (IQR)1759.2201

Descriptive statistics

Standard deviation1297.4176
Coefficient of variation (CV)0.0028212743
Kurtosis-0.65825771
Mean459869.36
Median Absolute Deviation (MAD)921.4002
Skewness0.092489675
Sum27592162
Variance1683292.4
MonotonicityNot monotonic
2024-05-11T14:42:01.332411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
459545.6383387 4
 
6.6%
460669.836412326 3
 
4.9%
459884.197207567 3
 
4.9%
458960.471391303 3
 
4.9%
461419.881795004 3
 
4.9%
458452.733971782 3
 
4.9%
458333.989216339 2
 
3.3%
461283.493404853 2
 
3.3%
460466.440748874 2
 
3.3%
459346.769704089 2
 
3.3%
Other values (29) 33
54.1%
ValueCountFrequency (%)
457415.650347823 1
 
1.6%
457486.206509046 1
 
1.6%
457736.364674901 1
 
1.6%
457788.078724646 1
 
1.6%
457827.324237033 1
 
1.6%
458162.081674971 1
 
1.6%
458333.989216339 2
3.3%
458372.125665811 1
 
1.6%
458452.733971782 3
4.9%
458521.183767914 1
 
1.6%
ValueCountFrequency (%)
462942.064441068 1
 
1.6%
462000.159901612 1
 
1.6%
461872.703749877 2
3.3%
461769.415134863 1
 
1.6%
461663.53909342 1
 
1.6%
461423.045063883 1
 
1.6%
461419.881795004 3
4.9%
461395.282179681 1
 
1.6%
461291.30503617 1
 
1.6%
461283.493404853 2
3.3%

제조구분명
Categorical

Distinct4
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
냉동
27 
<NA>
14 
일반
11 
충전

Length

Max length4
Median length2
Mean length2.4590164
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
냉동 27
44.3%
<NA> 14
23.0%
일반 11
18.0%
충전 9
 
14.8%

Length

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

Common Values (Plot)

2024-05-11T14:42:01.590314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
냉동 27
44.3%
na 14
23.0%
일반 11
18.0%
충전 9
 
14.8%
Distinct9
Distinct (%)14.8%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
24 
지정되지않음
21 
주거기타
연립
업무용
 
2
Other values (4)

Length

Max length6
Median length4
Mean length4.5081967
Min length2

Unique

Unique4 ?
Unique (%)6.6%

Sample

1st row<NA>
2nd row지정되지않음
3rd row주거기타
4th row<NA>
5th row주거기타

Common Values

ValueCountFrequency (%)
<NA> 24
39.3%
지정되지않음 21
34.4%
주거기타 7
 
11.5%
연립 3
 
4.9%
업무용 2
 
3.3%
상업기타 1
 
1.6%
공업기타 1
 
1.6%
상업용 1
 
1.6%
임야 1
 
1.6%

Length

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

Common Values (Plot)

2024-05-11T14:42:01.878927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 24
39.3%
지정되지않음 21
34.4%
주거기타 7
 
11.5%
연립 3
 
4.9%
업무용 2
 
3.3%
상업기타 1
 
1.6%
공업기타 1
 
1.6%
상업용 1
 
1.6%
임야 1
 
1.6%

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)제조구분명사업장부지용도구분명
03100000198731001730220001819871030<NA>2휴업2휴업<NA>2019042920190429<NA><NA><NA><NA>서울특별시 노원구 공릉동 581-1서울특별시 노원구 동일로180길 14 (공릉동)<NA>석진실업(주)2019-04-29 17:20:44U2019-05-01 02:40:00.0제조206578.976039457736.364675냉동<NA>
13100000198931001090210000120090610<NA>3폐업3폐업20201007<NA><NA><NA><NA><NA><NA>서울특별시 노원구 중계동 507-3서울특별시 노원구 동일로 1229 (중계동)<NA>노원구민회관2020-10-08 10:26:49U2020-10-10 02:40:00.0제조205735.958463459705.435524냉동지정되지않음
23100000199031000960217003319900924<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 공릉동 172서울특별시 노원구 공릉로 232 (공릉동)<NA>서울과학기술대학교2013-12-26 11:37:53I2018-08-31 23:59:59.0제조206981.454073458960.471391냉동주거기타
3310000019913100096021700352022-02-09<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 월계동 333-1 월계이마트서울특별시 노원구 마들로3길 15, 월계이마트 (월계동)1906(주) 이마트 월계점2024-04-16 14:21:23U2023-12-03 23:08:00.0제조205391.070378458333.989216<NA><NA>
43100000199131001090210003620100504<NA>3폐업3폐업20190321<NA><NA><NA><NA><NA><NA>서울특별시 노원구 상계동 705서울특별시 노원구 노해로 447 (상계동)<NA>주식회사 태웅관리시스템2019-03-21 15:43:32U2019-03-23 02:40:00.0제조205027.078638461291.305036냉동주거기타
53100000199231001090210000120070816<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 상계동 389-665서울특별시 노원구 한글비석로23길 8-9 (상계동)<NA>원일동명산소2017-04-26 10:08:38I2018-08-31 23:59:59.0판매206165.686593462000.159902<NA>지정되지않음
63100000199231001730210003719920622<NA>3폐업3폐업20110322<NA><NA><NA><NA><NA><NA>서울특별시 노원구 상계동 110-19서울특별시 노원구 덕릉로 803 (상계동)<NA>서울평안교회2013-12-26 11:46:33I2018-08-31 23:59:59.0제조206934.100502462942.064441일반상업기타
73100000199231001730210003919920818<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 상계동 713번지 롯데백화점서울특별시 노원구 동일로 1414 (상계동)<NA>롯데쇼핑(주) 노원점2020-02-03 15:19:44U2020-02-05 02:40:00.0제조205320.284767461419.881795냉동<NA>
83100000199531001090210000120080312<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 하계동 280-1 을지병원서울특별시 노원구 한글비석로 68 (하계동)<NA>노원을지대학교병원2019-11-07 13:28:24U2019-11-09 02:40:00.0저장소206102.455978459346.769704<NA>지정되지않음
93100000199531001090210000819951221<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 중계동 364-17 서울노원우체국서울특별시 노원구 한글비석로 232 (중계동)<NA>유경데마트2013-12-26 11:48:01I2018-08-31 23:59:59.0제조206719.586259460669.836412냉동지정되지않음
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)제조구분명사업장부지용도구분명
513100000201631001730220000120160622<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 노원로 75 (공릉동)<NA>한국원자력의학원2017-12-21 09:05:29I2018-08-31 23:59:59.0제조207425.804146458999.640861냉동업무용
523100000201731001730220000120171208<NA>1영업/정상1영업중<NA><NA><NA><NA><NA>0<NA>서울특별시 노원구 하계동 251-14 노원소방서 하계119안전센터서울특별시 노원구 화랑로 482, 공릉119 안전센터 (공릉동)1803노원소방서2019-05-23 15:41:05I2019-05-25 02:20:54.0제조206203.582453459545.638339충전<NA>
533100000201731001730220000220171226<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 하계동 251-14 노원소방서 하계119안전센터서울특별시 노원구 한글비석로1길 8, 노원소방서 하계119안전센터 (하계동)1791서울노원소방서2018-06-12 21:04:13I2018-08-31 23:59:59.0제조206203.582453459545.638339충전<NA>
543100000201831001730220000120180313<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 하계동 251-14 노원소방서 하계119안전센터서울특별시 노원구 한글비석로1길 8, 노원소방서 하계119안전센터 (하계동)1791노원소방서2018-03-13 15:25:12I2018-08-31 23:59:59.0제조206203.582453459545.638339충전<NA>
553100000201831001730220000220180313<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 공릉동 656-4번지 공릉119 안전센터서울특별시 노원구 화랑로 482, 공릉119 안전센터 (공릉동)1803노원소방서2018-03-13 16:31:01I2018-08-31 23:59:59.0제조207059.794767457415.650348충전<NA>
56310000020183100173022000032018-08-07<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 월계동 333-1 월계이마트서울특별시 노원구 마들로3길 15, 월계이마트 (월계동)1906(주)이마트 트레이더스 월계점2024-04-19 13:59:58U2023-12-03 22:01:00.0제조205391.070378458333.989216<NA><NA>
573100000201931001730220000120190319<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 공릉동 산 230-30서울특별시 노원구 화랑로 574 (공릉동)1805육군사관학교 화랑회관2019-03-18 17:46:50I2019-03-20 02:21:55.0제조<NA><NA>냉동<NA>
58310000020223100173022000012022-12-15<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 상계동 770-1 녹천교 하부(중랑천 야외아이스크장)<NA><NA>(주)겨울2023-03-07 11:13:37U2022-12-03 00:09:00.0제조204854.312535460207.585748<NA><NA>
59310000020233100253022000012023-12-28<NA>3폐업3폐업2024-02-13<NA><NA><NA><NA><NA><NA>서울특별시 노원구 공릉동 172 서울과학기술대학교<NA><NA>(주)위드레저스포츠2024-02-14 16:56:29U2023-12-01 23:06:00.0제조206981.454073458960.471391<NA><NA>
60310000020243100253021000012024-04-03<NA>1영업/정상1영업중<NA><NA><NA><NA><NA><NA><NA>서울특별시 노원구 공릉동 215-4 한국원자력의학원서울특별시 노원구 노원로 75, 한국원자력의학원 (공릉동)1812한국원자력의학원2024-04-03 14:22:09I2023-12-04 00:05:00.0제조207192.873108458452.733972<NA><NA>