Overview

Dataset statistics

Number of variables44
Number of observations24
Missing cells423
Missing cells (%)40.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.0 KiB
Average record size in memory384.5 B

Variable types

Categorical12
Text6
Numeric9
Unsupported15
DateTime1
Boolean1

Dataset

Description개방자치단체코드,관리번호,인허가일자,인허가취소일자,영업상태코드,영업상태명,상세영업상태코드,상세영업상태명,폐업일자,휴업시작일자,휴업종료일자,재개업일자,전화번호,소재지면적,소재지우편번호,지번주소,도로명주소,도로명우편번호,사업장명,최종수정일자,데이터갱신구분,데이터갱신일자,업태구분명,좌표정보(X),좌표정보(Y),위생업태명,남성종사자수,여성종사자수,영업장주변구분명,등급구분명,급수시설구분명,총인원,본사종업원수,공장사무직종업원수,공장판매직종업원수,공장생산직종업원수,건물소유구분명,보증액,월세액,다중이용업소여부,시설총규모,전통업소지정번호,전통업소주된음식,홈페이지
Author성북구
URLhttps://data.seoul.go.kr/dataList/OA-18559/S/1/datasetView.do

Alerts

개방자치단체코드 has constant value ""Constant
데이터갱신일자 is highly imbalanced (57.6%)Imbalance
인허가취소일자 has 24 (100.0%) missing valuesMissing
폐업일자 has 8 (33.3%) missing valuesMissing
휴업시작일자 has 24 (100.0%) missing valuesMissing
휴업종료일자 has 24 (100.0%) missing valuesMissing
재개업일자 has 24 (100.0%) missing valuesMissing
소재지면적 has 7 (29.2%) missing valuesMissing
도로명주소 has 15 (62.5%) missing valuesMissing
도로명우편번호 has 15 (62.5%) missing valuesMissing
좌표정보(X) has 3 (12.5%) missing valuesMissing
좌표정보(Y) has 3 (12.5%) missing valuesMissing
남성종사자수 has 6 (25.0%) missing valuesMissing
여성종사자수 has 6 (25.0%) missing valuesMissing
총인원 has 24 (100.0%) missing valuesMissing
본사종업원수 has 24 (100.0%) missing valuesMissing
공장사무직종업원수 has 24 (100.0%) missing valuesMissing
공장판매직종업원수 has 24 (100.0%) missing valuesMissing
공장생산직종업원수 has 24 (100.0%) missing valuesMissing
건물소유구분명 has 24 (100.0%) missing valuesMissing
보증액 has 24 (100.0%) missing valuesMissing
월세액 has 24 (100.0%) missing valuesMissing
전통업소지정번호 has 24 (100.0%) missing valuesMissing
전통업소주된음식 has 24 (100.0%) missing valuesMissing
홈페이지 has 24 (100.0%) missing valuesMissing
관리번호 has unique valuesUnique
인허가일자 has unique valuesUnique
전화번호 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
본사종업원수 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
보증액 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 9 (37.5%) zerosZeros
여성종사자수 has 9 (37.5%) zerosZeros
시설총규모 has 7 (29.2%) zerosZeros

Reproduction

Analysis started2024-04-06 11:22:39.794465
Analysis finished2024-04-06 11:22:40.571135
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

개방자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
3070000
24 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3070000 24
100.0%

Length

2024-04-06T20:22:40.706143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:40.917873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3070000 24
100.0%

관리번호
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2024-04-06T20:22:41.198291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length22
Mean length22
Min length22

Characters and Unicode

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

Unique24 ?
Unique (%)100.0%

Sample

1st row3070000-102-1967-07652
2nd row3070000-102-1968-07693
3rd row3070000-102-1970-07691
4th row3070000-102-1971-07653
5th row3070000-102-1972-07692
ValueCountFrequency (%)
3070000-102-1967-07652 1
 
4.2%
3070000-102-1968-07693 1
 
4.2%
3070000-102-2005-00002 1
 
4.2%
3070000-102-2005-00001 1
 
4.2%
3070000-102-2004-00001 1
 
4.2%
3070000-102-2003-00001 1
 
4.2%
3070000-102-2002-00001 1
 
4.2%
3070000-102-2001-11071 1
 
4.2%
3070000-102-2001-10866 1
 
4.2%
3070000-102-2000-10406 1
 
4.2%
Other values (14) 14
58.3%
2024-04-06T20:22:41.873476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 220
41.7%
- 72
 
13.6%
1 57
 
10.8%
7 46
 
8.7%
2 43
 
8.1%
3 34
 
6.4%
9 19
 
3.6%
6 17
 
3.2%
5 9
 
1.7%
4 7
 
1.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 456
86.4%
Dash Punctuation 72
 
13.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 220
48.2%
1 57
 
12.5%
7 46
 
10.1%
2 43
 
9.4%
3 34
 
7.5%
9 19
 
4.2%
6 17
 
3.7%
5 9
 
2.0%
4 7
 
1.5%
8 4
 
0.9%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 528
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 220
41.7%
- 72
 
13.6%
1 57
 
10.8%
7 46
 
8.7%
2 43
 
8.1%
3 34
 
6.4%
9 19
 
3.6%
6 17
 
3.2%
5 9
 
1.7%
4 7
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 528
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 220
41.7%
- 72
 
13.6%
1 57
 
10.8%
7 46
 
8.7%
2 43
 
8.1%
3 34
 
6.4%
9 19
 
3.6%
6 17
 
3.2%
5 9
 
1.7%
4 7
 
1.3%

인허가일자
Real number (ℝ)

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19892717
Minimum19680215
Maximum20110623
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:42.194447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19680215
5-th percentile19692370
Q119730998
median20000562
Q320013177
95-th percentile20050502
Maximum20110623
Range430408
Interquartile range (IQR)282178.75

Descriptive statistics

Standard deviation153921.42
Coefficient of variation (CV)0.0077375763
Kurtosis-1.8717022
Mean19892717
Median Absolute Deviation (MAD)75053.5
Skewness-0.24262433
Sum4.7742521 × 108
Variance2.3691802 × 1010
MonotonicityNot monotonic
2024-04-06T20:22:42.520143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
19690916 1
 
4.2%
20000622 1
 
4.2%
20110623 1
 
4.2%
20050517 1
 
4.2%
20050418 1
 
4.2%
20040621 1
 
4.2%
20030828 1
 
4.2%
20020828 1
 
4.2%
20010627 1
 
4.2%
20010402 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
19680215 1
4.2%
19690916 1
4.2%
19700610 1
4.2%
19711102 1
4.2%
19721209 1
4.2%
19730901 1
4.2%
19731031 1
4.2%
19740228 1
4.2%
19740401 1
4.2%
19750224 1
4.2%
ValueCountFrequency (%)
20110623 1
4.2%
20050517 1
4.2%
20050418 1
4.2%
20040621 1
4.2%
20030828 1
4.2%
20020828 1
4.2%
20010627 1
4.2%
20010402 1
4.2%
20000724 1
4.2%
20000626 1
4.2%

인허가취소일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

영업상태코드
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
3
16 
1
8 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 16
66.7%
1 8
33.3%

Length

2024-04-06T20:22:42.826726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:43.049383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 16
66.7%
1 8
33.3%

영업상태명
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
폐업
16 
영업/정상
8 

Length

Max length5
Median length2
Mean length3
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 16
66.7%
영업/정상 8
33.3%

Length

2024-04-06T20:22:43.293984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:43.495478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 16
66.7%
영업/정상 8
33.3%

상세영업상태코드
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
2
16 
1
8 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 16
66.7%
1 8
33.3%

Length

2024-04-06T20:22:43.680094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:43.843822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 16
66.7%
1 8
33.3%

상세영업상태명
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
폐업
16 
영업
8 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
폐업 16
66.7%
영업 8
33.3%

Length

2024-04-06T20:22:44.016037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:44.202219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 16
66.7%
영업 8
33.3%

폐업일자
Real number (ℝ)

MISSING 

Distinct16
Distinct (%)100.0%
Missing8
Missing (%)33.3%
Infinite0
Infinite (%)0.0%
Mean20036251
Minimum19950630
Maximum20120313
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:44.360022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19950630
5-th percentile19957964
Q120000213
median20050925
Q320075290
95-th percentile20098500
Maximum20120313
Range169683
Interquartile range (IQR)75076.75

Descriptive statistics

Standard deviation51991.222
Coefficient of variation (CV)0.0025948578
Kurtosis-1.1385601
Mean20036251
Median Absolute Deviation (MAD)40349
Skewness-0.18451762
Sum3.2058002 × 108
Variance2.7030872 × 109
MonotonicityNot monotonic
2024-04-06T20:22:44.593967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
20010531 1
 
4.2%
20070316 1
 
4.2%
20050720 1
 
4.2%
20090211 1
 
4.2%
20090624 1
 
4.2%
20120313 1
 
4.2%
20001031 1
 
4.2%
19950630 1
 
4.2%
20000201 1
 
4.2%
20060814 1
 
4.2%
Other values (6) 6
25.0%
(Missing) 8
33.3%
ValueCountFrequency (%)
19950630 1
4.2%
19960408 1
4.2%
19971229 1
4.2%
20000201 1
4.2%
20000217 1
4.2%
20001031 1
4.2%
20010531 1
4.2%
20050720 1
4.2%
20051130 1
4.2%
20060411 1
4.2%
ValueCountFrequency (%)
20120313 1
4.2%
20091229 1
4.2%
20090624 1
4.2%
20090211 1
4.2%
20070316 1
4.2%
20060814 1
4.2%
20060411 1
4.2%
20051130 1
4.2%
20050720 1
4.2%
20010531 1
4.2%

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

전화번호
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2024-04-06T20:22:44.847429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length10
Min length2

Characters and Unicode

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

Unique24 ?
Unique (%)100.0%

Sample

1st row02 9120420
2nd row0207620161
3rd row0209121080
4th row02 9130038
5th row02 7620151
ValueCountFrequency (%)
02 18
40.0%
924 2
 
4.4%
0262321472 1
 
2.2%
6823 1
 
2.2%
929 1
 
2.2%
9230277 1
 
2.2%
9277776 1
 
2.2%
1669 1
 
2.2%
943 1
 
2.2%
9593501 1
 
2.2%
Other values (17) 17
37.8%
2024-04-06T20:22:45.316475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 50
20.8%
0 47
19.6%
9 31
12.9%
25
10.4%
1 18
 
7.5%
6 14
 
5.8%
7 13
 
5.4%
3 13
 
5.4%
5 12
 
5.0%
4 9
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 215
89.6%
Space Separator 25
 
10.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 50
23.3%
0 47
21.9%
9 31
14.4%
1 18
 
8.4%
6 14
 
6.5%
7 13
 
6.0%
3 13
 
6.0%
5 12
 
5.6%
4 9
 
4.2%
8 8
 
3.7%
Space Separator
ValueCountFrequency (%)
25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 240
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 50
20.8%
0 47
19.6%
9 31
12.9%
25
10.4%
1 18
 
7.5%
6 14
 
5.8%
7 13
 
5.4%
3 13
 
5.4%
5 12
 
5.0%
4 9
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 240
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 50
20.8%
0 47
19.6%
9 31
12.9%
25
10.4%
1 18
 
7.5%
6 14
 
5.8%
7 13
 
5.4%
3 13
 
5.4%
5 12
 
5.0%
4 9
 
3.8%

소재지면적
Text

MISSING 

Distinct17
Distinct (%)100.0%
Missing7
Missing (%)29.2%
Memory size324.0 B
2024-04-06T20:22:45.616547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length5.7058824
Min length5

Characters and Unicode

Total characters97
Distinct characters12
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

Unique17 ?
Unique (%)100.0%

Sample

1st row127.84
2nd row92.08
3rd row70.03
4th row84.54
5th row362.75
ValueCountFrequency (%)
127.84 1
 
5.9%
94.76 1
 
5.9%
106.52 1
 
5.9%
53.01 1
 
5.9%
94.08 1
 
5.9%
190.60 1
 
5.9%
557.78 1
 
5.9%
409.72 1
 
5.9%
280.13 1
 
5.9%
92.08 1
 
5.9%
Other values (7) 7
41.2%
2024-04-06T20:22:46.124540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 17
17.5%
0 14
14.4%
2 10
10.3%
8 8
8.2%
3 8
8.2%
1 7
7.2%
7 7
7.2%
4 7
7.2%
9 7
7.2%
5 6
 
6.2%
Other values (2) 6
 
6.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 79
81.4%
Other Punctuation 18
 
18.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 14
17.7%
2 10
12.7%
8 8
10.1%
3 8
10.1%
1 7
8.9%
7 7
8.9%
4 7
8.9%
9 7
8.9%
5 6
7.6%
6 5
 
6.3%
Other Punctuation
ValueCountFrequency (%)
. 17
94.4%
, 1
 
5.6%

Most occurring scripts

ValueCountFrequency (%)
Common 97
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
. 17
17.5%
0 14
14.4%
2 10
10.3%
8 8
8.2%
3 8
8.2%
1 7
7.2%
7 7
7.2%
4 7
7.2%
9 7
7.2%
5 6
 
6.2%
Other values (2) 6
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 97
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 17
17.5%
0 14
14.4%
2 10
10.3%
8 8
8.2%
3 8
8.2%
1 7
7.2%
7 7
7.2%
4 7
7.2%
9 7
7.2%
5 6
 
6.2%
Other values (2) 6
 
6.2%

소재지우편번호
Real number (ℝ)

Distinct16
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean136514.25
Minimum136035
Maximum136873
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:46.393416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum136035
5-th percentile136036
Q1136069.75
median136801
Q3136834
95-th percentile136871.5
Maximum136873
Range838
Interquartile range (IQR)764.25

Descriptive statistics

Standard deviation389.27438
Coefficient of variation (CV)0.0028515293
Kurtosis-2.0217001
Mean136514.25
Median Absolute Deviation (MAD)67
Skewness-0.36054274
Sum3276342
Variance151534.54
MonotonicityNot monotonic
2024-04-06T20:22:46.669496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
136873 2
 
8.3%
136858 2
 
8.3%
136800 2
 
8.3%
136084 2
 
8.3%
136823 2
 
8.3%
136819 2
 
8.3%
136051 2
 
8.3%
136036 2
 
8.3%
136140 1
 
4.2%
136035 1
 
4.2%
Other values (6) 6
25.0%
ValueCountFrequency (%)
136035 1
4.2%
136036 2
8.3%
136051 2
8.3%
136054 1
4.2%
136075 1
4.2%
136084 2
8.3%
136140 1
4.2%
136800 2
8.3%
136802 1
4.2%
136819 2
8.3%
ValueCountFrequency (%)
136873 2
8.3%
136863 1
4.2%
136859 1
4.2%
136858 2
8.3%
136826 1
4.2%
136823 2
8.3%
136819 2
8.3%
136802 1
4.2%
136800 2
8.3%
136140 1
4.2%

지번주소
Text

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
2024-04-06T20:22:47.125590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length32
Mean length25.541667
Min length20

Characters and Unicode

Total characters613
Distinct characters59
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

Unique22 ?
Unique (%)91.7%

Sample

1st row서울특별시 성북구 하월곡동 88-71번지
2nd row서울특별시 성북구 성북동 323번지
3rd row서울특별시 성북구 종암동 3-75번지
4th row서울특별시 성북구 종암동 16-4번지
5th row서울특별시 성북구 성북동 330-115번지
ValueCountFrequency (%)
서울특별시 24
22.9%
성북구 24
22.9%
종암동 4
 
3.8%
길음동 3
 
2.9%
석관동 2
 
1.9%
337-1번지 2
 
1.9%
성북동 2
 
1.9%
장위동 2
 
1.9%
동선동1가 2
 
1.9%
하월곡동 2
 
1.9%
Other values (34) 38
36.2%
2024-04-06T20:22:47.793733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
105
 
17.1%
1 32
 
5.2%
동 30
 
4.9%
지 28
 
4.6%
성 26
 
4.2%
북 26
 
4.2%
서 24
 
3.9%
울 24
 
3.9%
특 24
 
3.9%
별 24
 
3.9%
Other values (49) 270
44.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 354
57.7%
Decimal Number 124
 
20.2%
Space Separator 105
 
17.1%
Dash Punctuation 22
 
3.6%
Other Punctuation 4
 
0.7%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 30
 
8.5%
지 28
 
7.9%
성 26
 
7.3%
북 26
 
7.3%
서 24
 
6.8%
울 24
 
6.8%
특 24
 
6.8%
별 24
 
6.8%
시 24
 
6.8%
구 24
 
6.8%
Other values (34) 100
28.2%
Decimal Number
ValueCountFrequency (%)
1 32
25.8%
3 22
17.7%
5 14
11.3%
7 13
10.5%
2 13
10.5%
4 12
 
9.7%
8 6
 
4.8%
0 5
 
4.0%
6 4
 
3.2%
9 3
 
2.4%
Space Separator
ValueCountFrequency (%)
105
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 354
57.7%
Common 259
42.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 30
 
8.5%
지 28
 
7.9%
성 26
 
7.3%
북 26
 
7.3%
서 24
 
6.8%
울 24
 
6.8%
특 24
 
6.8%
별 24
 
6.8%
시 24
 
6.8%
구 24
 
6.8%
Other values (34) 100
28.2%
Common
ValueCountFrequency (%)
105
40.5%
1 32
 
12.4%
- 22
 
8.5%
3 22
 
8.5%
5 14
 
5.4%
7 13
 
5.0%
2 13
 
5.0%
4 12
 
4.6%
8 6
 
2.3%
0 5
 
1.9%
Other values (5) 15
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 354
57.7%
ASCII 259
42.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
105
40.5%
1 32
 
12.4%
- 22
 
8.5%
3 22
 
8.5%
5 14
 
5.4%
7 13
 
5.0%
2 13
 
5.0%
4 12
 
4.6%
8 6
 
2.3%
0 5
 
1.9%
Other values (5) 15
 
5.8%
Hangul
ValueCountFrequency (%)
동 30
 
8.5%
지 28
 
7.9%
성 26
 
7.3%
북 26
 
7.3%
서 24
 
6.8%
울 24
 
6.8%
특 24
 
6.8%
별 24
 
6.8%
시 24
 
6.8%
구 24
 
6.8%
Other values (34) 100
28.2%

도로명주소
Text

MISSING 

Distinct9
Distinct (%)100.0%
Missing15
Missing (%)62.5%
Memory size324.0 B
2024-04-06T20:22:48.102055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length29
Mean length29
Min length24

Characters and Unicode

Total characters261
Distinct characters49
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

Unique9 ?
Unique (%)100.0%

Sample

1st row서울특별시 성북구 동소문로 225-3 (길음동)
2nd row서울특별시 성북구 종암로22길 7 (종암동)
3rd row서울특별시 성북구 보문로 78 (보문동4가, 지하1층)
4th row서울특별시 성북구 아리랑로 3 (동소문동6가)
5th row서울특별시 성북구 아리랑로 3 (동소문동6가,(지하1층))
ValueCountFrequency (%)
서울특별시 9
18.8%
성북구 9
18.8%
3 3
 
6.2%
아리랑로 3
 
6.2%
보문로 2
 
4.2%
78 2
 
4.2%
지하1층 2
 
4.2%
길음동 1
 
2.1%
4 1
 
2.1%
동선동1가 1
 
2.1%
Other values (15) 15
31.2%
2024-04-06T20:22:48.704066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
39
 
14.9%
동 17
 
6.5%
) 10
 
3.8%
( 10
 
3.8%
문 10
 
3.8%
구 9
 
3.4%
로 9
 
3.4%
울 9
 
3.4%
서 9
 
3.4%
북 9
 
3.4%
Other values (39) 130
49.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 165
63.2%
Space Separator 39
 
14.9%
Decimal Number 32
 
12.3%
Close Punctuation 10
 
3.8%
Open Punctuation 10
 
3.8%
Other Punctuation 4
 
1.5%
Dash Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 17
 
10.3%
문 10
 
6.1%
구 9
 
5.5%
로 9
 
5.5%
울 9
 
5.5%
서 9
 
5.5%
북 9
 
5.5%
성 9
 
5.5%
시 9
 
5.5%
별 9
 
5.5%
Other values (25) 66
40.0%
Decimal Number
ValueCountFrequency (%)
2 7
21.9%
1 6
18.8%
4 4
12.5%
3 4
12.5%
7 3
9.4%
0 2
 
6.2%
6 2
 
6.2%
5 2
 
6.2%
8 2
 
6.2%
Space Separator
ValueCountFrequency (%)
39
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 165
63.2%
Common 96
36.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 17
 
10.3%
문 10
 
6.1%
구 9
 
5.5%
로 9
 
5.5%
울 9
 
5.5%
서 9
 
5.5%
북 9
 
5.5%
성 9
 
5.5%
시 9
 
5.5%
별 9
 
5.5%
Other values (25) 66
40.0%
Common
ValueCountFrequency (%)
39
40.6%
) 10
 
10.4%
( 10
 
10.4%
2 7
 
7.3%
1 6
 
6.2%
, 4
 
4.2%
4 4
 
4.2%
3 4
 
4.2%
7 3
 
3.1%
0 2
 
2.1%
Other values (4) 7
 
7.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 165
63.2%
ASCII 96
36.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
39
40.6%
) 10
 
10.4%
( 10
 
10.4%
2 7
 
7.3%
1 6
 
6.2%
, 4
 
4.2%
4 4
 
4.2%
3 4
 
4.2%
7 3
 
3.1%
0 2
 
2.1%
Other values (4) 7
 
7.3%
Hangul
ValueCountFrequency (%)
동 17
 
10.3%
문 10
 
6.1%
구 9
 
5.5%
로 9
 
5.5%
울 9
 
5.5%
서 9
 
5.5%
북 9
 
5.5%
성 9
 
5.5%
시 9
 
5.5%
별 9
 
5.5%
Other values (25) 66
40.0%

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

MISSING 

Distinct7
Distinct (%)77.8%
Missing15
Missing (%)62.5%
Infinite0
Infinite (%)0.0%
Mean2822.4444
Minimum2721
Maximum2852
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:48.903713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2721
5-th percentile2751.4
Q12829
median2830
Q32846
95-th percentile2852
Maximum2852
Range131
Interquartile range (IQR)17

Descriptive statistics

Standard deviation41.692659
Coefficient of variation (CV)0.014771826
Kurtosis5.0400971
Mean2822.4444
Median Absolute Deviation (MAD)16
Skewness-2.180108
Sum25402
Variance1738.2778
MonotonicityNot monotonic
2024-04-06T20:22:49.083991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
2852 2
 
8.3%
2830 2
 
8.3%
2721 1
 
4.2%
2797 1
 
4.2%
2829 1
 
4.2%
2846 1
 
4.2%
2845 1
 
4.2%
(Missing) 15
62.5%
ValueCountFrequency (%)
2721 1
4.2%
2797 1
4.2%
2829 1
4.2%
2830 2
8.3%
2845 1
4.2%
2846 1
4.2%
2852 2
8.3%
ValueCountFrequency (%)
2852 2
8.3%
2846 1
4.2%
2845 1
4.2%
2830 2
8.3%
2829 1
4.2%
2797 1
4.2%
2721 1
4.2%

사업장명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2024-04-06T20:22:49.408688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length7
Mean length4.375
Min length2

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)100.0%

Sample

1st row뉴OB
2nd row(주)대원각
3rd row삼성민속주점
4th row야광스텐드빠
5th row예향
ValueCountFrequency (%)
뉴ob 1
 
3.7%
지덱 1
 
3.7%
놀자뮤직타운 1
 
3.7%
발리 1
 
3.7%
하트노래 1
 
3.7%
무학 1
 
3.7%
나이트크럽 1
 
3.7%
뉴월드 1
 
3.7%
카니발 1
 
3.7%
여우 1
 
3.7%
Other values (17) 17
63.0%
2024-04-06T20:22:49.962492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
스 4
 
3.8%
주 4
 
3.8%
뉴 3
 
2.9%
카 3
 
2.9%
3
 
2.9%
점 3
 
2.9%
이 3
 
2.9%
바 3
 
2.9%
니 2
 
1.9%
지 2
 
1.9%
Other values (64) 75
71.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 98
93.3%
Space Separator 3
 
2.9%
Uppercase Letter 2
 
1.9%
Open Punctuation 1
 
1.0%
Close Punctuation 1
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
스 4
 
4.1%
주 4
 
4.1%
뉴 3
 
3.1%
카 3
 
3.1%
점 3
 
3.1%
이 3
 
3.1%
바 3
 
3.1%
니 2
 
2.0%
지 2
 
2.0%
직 2
 
2.0%
Other values (59) 69
70.4%
Uppercase Letter
ValueCountFrequency (%)
B 1
50.0%
O 1
50.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 98
93.3%
Common 5
 
4.8%
Latin 2
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
스 4
 
4.1%
주 4
 
4.1%
뉴 3
 
3.1%
카 3
 
3.1%
점 3
 
3.1%
이 3
 
3.1%
바 3
 
3.1%
니 2
 
2.0%
지 2
 
2.0%
직 2
 
2.0%
Other values (59) 69
70.4%
Common
ValueCountFrequency (%)
3
60.0%
( 1
 
20.0%
) 1
 
20.0%
Latin
ValueCountFrequency (%)
B 1
50.0%
O 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 98
93.3%
ASCII 7
 
6.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
스 4
 
4.1%
주 4
 
4.1%
뉴 3
 
3.1%
카 3
 
3.1%
점 3
 
3.1%
이 3
 
3.1%
바 3
 
3.1%
니 2
 
2.0%
지 2
 
2.0%
직 2
 
2.0%
Other values (59) 69
70.4%
ASCII
ValueCountFrequency (%)
3
42.9%
( 1
 
14.3%
B 1
 
14.3%
) 1
 
14.3%
O 1
 
14.3%

최종수정일자
Date

Distinct17
Distinct (%)70.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2001-12-12 00:00:00
Maximum2020-09-14 16:52:17
2024-04-06T20:22:50.134720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T20:22:50.343821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)

데이터갱신구분
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
I
20 
U
4 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 20
83.3%
U 4
 
16.7%

Length

2024-04-06T20:22:50.550657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:50.814702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 20
83.3%
u 4
 
16.7%

데이터갱신일자
Categorical

IMBALANCE 

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
2018-08-31 23:59:59.0
20 
2019-09-29 02:40:00.0
 
1
2018-11-07 02:37:12.0
 
1
2020-09-16 02:40:00.0
 
1
2019-10-25 02:40:00.0
 
1

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique4 ?
Unique (%)16.7%

Sample

1st row2018-08-31 23:59:59.0
2nd row2018-08-31 23:59:59.0
3rd row2018-08-31 23:59:59.0
4th row2018-08-31 23:59:59.0
5th row2018-08-31 23:59:59.0

Common Values

ValueCountFrequency (%)
2018-08-31 23:59:59.0 20
83.3%
2019-09-29 02:40:00.0 1
 
4.2%
2018-11-07 02:37:12.0 1
 
4.2%
2020-09-16 02:40:00.0 1
 
4.2%
2019-10-25 02:40:00.0 1
 
4.2%

Length

2024-04-06T20:22:51.150098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:51.563247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018-08-31 20
41.7%
23:59:59.0 20
41.7%
02:40:00.0 3
 
6.2%
2019-09-29 1
 
2.1%
2018-11-07 1
 
2.1%
02:37:12.0 1
 
2.1%
2020-09-16 1
 
2.1%
2019-10-25 1
 
2.1%

업태구분명
Categorical

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
룸살롱
11 
카바레
6 
스텐드바
4 
요정
2 
관광호텔나이트(디스코)
 
1

Length

Max length12
Median length3
Mean length3.4583333
Min length2

Unique

Unique1 ?
Unique (%)4.2%

Sample

1st row카바레
2nd row요정
3rd row룸살롱
4th row스텐드바
5th row요정

Common Values

ValueCountFrequency (%)
룸살롱 11
45.8%
카바레 6
25.0%
스텐드바 4
 
16.7%
요정 2
 
8.3%
관광호텔나이트(디스코) 1
 
4.2%

Length

2024-04-06T20:22:52.110801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:52.338784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
룸살롱 11
45.8%
카바레 6
25.0%
스텐드바 4
 
16.7%
요정 2
 
8.3%
관광호텔나이트(디스코 1
 
4.2%

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

MISSING 

Distinct19
Distinct (%)90.5%
Missing3
Missing (%)12.5%
Infinite0
Infinite (%)0.0%
Mean202259.96
Minimum198545.88
Maximum205217.6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:52.894653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum198545.88
5-th percentile199387.31
Q1201394.71
median201865.42
Q3202859.06
95-th percentile205216.61
Maximum205217.6
Range6671.7264
Interquartile range (IQR)1464.3485

Descriptive statistics

Standard deviation1727.8018
Coefficient of variation (CV)0.0085424806
Kurtosis0.38064156
Mean202259.96
Median Absolute Deviation (MAD)597.8735
Skewness0.11215182
Sum4247459.2
Variance2985299
MonotonicityNot monotonic
2024-04-06T20:22:53.088901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
201810.388914346 2
 
8.3%
204906.231827898 2
 
8.3%
201358.388613986 1
 
4.2%
201414.192716298 1
 
4.2%
201386.544353134 1
 
4.2%
201394.713957557 1
 
4.2%
205216.606119451 1
 
4.2%
201363.138481996 1
 
4.2%
202571.112398571 1
 
4.2%
205217.602420555 1
 
4.2%
Other values (9) 9
37.5%
(Missing) 3
 
12.5%
ValueCountFrequency (%)
198545.876020342 1
4.2%
199387.31320078 1
4.2%
201358.388613986 1
4.2%
201363.138481996 1
4.2%
201386.544353134 1
4.2%
201394.713957557 1
4.2%
201414.192716298 1
4.2%
201536.883548815 1
4.2%
201810.388914346 2
8.3%
201865.41760815 1
4.2%
ValueCountFrequency (%)
205217.602420555 1
4.2%
205216.606119451 1
4.2%
204906.231827898 2
8.3%
202988.136368971 1
4.2%
202859.062438797 1
4.2%
202571.112398571 1
4.2%
202551.784562238 1
4.2%
202463.291109829 1
4.2%
201905.866341748 1
4.2%
201865.41760815 1
4.2%

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

MISSING 

Distinct19
Distinct (%)90.5%
Missing3
Missing (%)12.5%
Infinite0
Infinite (%)0.0%
Mean455137.99
Minimum453337.05
Maximum456753.87
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:53.273282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum453337.05
5-th percentile453337.05
Q1454514.75
median455179.19
Q3456061.41
95-th percentile456715.56
Maximum456753.87
Range3416.8195
Interquartile range (IQR)1546.6613

Descriptive statistics

Standard deviation1080.2306
Coefficient of variation (CV)0.0023734133
Kurtosis-0.89710268
Mean455137.99
Median Absolute Deviation (MAD)766.41756
Skewness-0.12029924
Sum9557897.8
Variance1166898.1
MonotonicityNot monotonic
2024-04-06T20:22:53.441770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
453337.054032254 2
 
8.3%
456420.949081137 2
 
8.3%
454534.250493585 1
 
4.2%
454407.004970482 1
 
4.2%
454412.772727911 1
 
4.2%
454544.984917895 1
 
4.2%
456753.873513306 1
 
4.2%
454514.752552042 1
 
4.2%
456435.426313848 1
 
4.2%
456715.560473867 1
 
4.2%
Other values (9) 9
37.5%
(Missing) 3
 
12.5%
ValueCountFrequency (%)
453337.054032254 2
8.3%
453432.985430094 1
4.2%
454407.004970482 1
4.2%
454412.772727911 1
4.2%
454514.752552042 1
4.2%
454534.250493585 1
4.2%
454544.984917895 1
4.2%
454556.210968626 1
4.2%
454980.927178232 1
4.2%
455179.190284136 1
4.2%
ValueCountFrequency (%)
456753.873513306 1
4.2%
456715.560473867 1
4.2%
456435.426313848 1
4.2%
456420.949081137 2
8.3%
456061.413843849 1
4.2%
455616.421897889 1
4.2%
455541.255496062 1
4.2%
455408.348757444 1
4.2%
455286.462033212 1
4.2%
455179.190284136 1
4.2%

위생업태명
Categorical

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
룸살롱
11 
카바레
6 
스텐드바
4 
요정
2 
관광호텔나이트(디스코)
 
1

Length

Max length12
Median length3
Mean length3.4583333
Min length2

Unique

Unique1 ?
Unique (%)4.2%

Sample

1st row카바레
2nd row요정
3rd row룸살롱
4th row스텐드바
5th row요정

Common Values

ValueCountFrequency (%)
룸살롱 11
45.8%
카바레 6
25.0%
스텐드바 4
 
16.7%
요정 2
 
8.3%
관광호텔나이트(디스코) 1
 
4.2%

Length

2024-04-06T20:22:53.664202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:53.812661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
룸살롱 11
45.8%
카바레 6
25.0%
스텐드바 4
 
16.7%
요정 2
 
8.3%
관광호텔나이트(디스코 1
 
4.2%

남성종사자수
Real number (ℝ)

MISSING  ZEROS 

Distinct7
Distinct (%)38.9%
Missing6
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean5.3333333
Minimum0
Maximum62
Zeros9
Zeros (%)37.5%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:53.971445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile18.65
Maximum62
Range62
Interquartile range (IQR)3

Descriptive statistics

Standard deviation14.438511
Coefficient of variation (CV)2.7072207
Kurtosis16.292176
Mean5.3333333
Median Absolute Deviation (MAD)1
Skewness3.9715346
Sum96
Variance208.47059
MonotonicityNot monotonic
2024-04-06T20:22:54.150547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 9
37.5%
2 3
 
12.5%
3 2
 
8.3%
6 1
 
4.2%
11 1
 
4.2%
62 1
 
4.2%
5 1
 
4.2%
(Missing) 6
25.0%
ValueCountFrequency (%)
0 9
37.5%
2 3
 
12.5%
3 2
 
8.3%
5 1
 
4.2%
6 1
 
4.2%
11 1
 
4.2%
62 1
 
4.2%
ValueCountFrequency (%)
62 1
 
4.2%
11 1
 
4.2%
6 1
 
4.2%
5 1
 
4.2%
3 2
 
8.3%
2 3
 
12.5%
0 9
37.5%

여성종사자수
Real number (ℝ)

MISSING  ZEROS 

Distinct8
Distinct (%)44.4%
Missing6
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean2.7777778
Minimum0
Maximum14
Zeros9
Zeros (%)37.5%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:54.296174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.5
Q34.75
95-th percentile11.45
Maximum14
Range14
Interquartile range (IQR)4.75

Descriptive statistics

Standard deviation4.1381376
Coefficient of variation (CV)1.4897295
Kurtosis2.4320523
Mean2.7777778
Median Absolute Deviation (MAD)0.5
Skewness1.7017741
Sum50
Variance17.124183
MonotonicityNot monotonic
2024-04-06T20:22:54.493251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 9
37.5%
5 2
 
8.3%
1 2
 
8.3%
11 1
 
4.2%
14 1
 
4.2%
3 1
 
4.2%
4 1
 
4.2%
6 1
 
4.2%
(Missing) 6
25.0%
ValueCountFrequency (%)
0 9
37.5%
1 2
 
8.3%
3 1
 
4.2%
4 1
 
4.2%
5 2
 
8.3%
6 1
 
4.2%
11 1
 
4.2%
14 1
 
4.2%
ValueCountFrequency (%)
14 1
 
4.2%
11 1
 
4.2%
6 1
 
4.2%
5 2
 
8.3%
4 1
 
4.2%
3 1
 
4.2%
1 2
 
8.3%
0 9
37.5%

영업장주변구분명
Categorical

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
주택가주변
7 
<NA>
7 
유흥업소밀집지역
6 
기타
3 
결혼예식장주변
1 

Length

Max length8
Median length7
Mean length5.1666667
Min length2

Unique

Unique1 ?
Unique (%)4.2%

Sample

1st row주택가주변
2nd row주택가주변
3rd row주택가주변
4th row주택가주변
5th row주택가주변

Common Values

ValueCountFrequency (%)
주택가주변 7
29.2%
<NA> 7
29.2%
유흥업소밀집지역 6
25.0%
기타 3
12.5%
결혼예식장주변 1
 
4.2%

Length

2024-04-06T20:22:54.730026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:54.895386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주택가주변 7
29.2%
na 7
29.2%
유흥업소밀집지역 6
25.0%
기타 3
12.5%
결혼예식장주변 1
 
4.2%

등급구분명
Categorical

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
<NA>
10 
을
6 
기타
6 
자율
 
1
지도
 
1

Length

Max length4
Median length2
Mean length2.5833333
Min length1

Unique

Unique2 ?
Unique (%)8.3%

Sample

1st row을
2nd row을
3rd row을
4th row을
5th row자율

Common Values

ValueCountFrequency (%)
<NA> 10
41.7%
을 6
25.0%
기타 6
25.0%
자율 1
 
4.2%
지도 1
 
4.2%

Length

2024-04-06T20:22:55.090140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:55.290728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 10
41.7%
을 6
25.0%
기타 6
25.0%
자율 1
 
4.2%
지도 1
 
4.2%

급수시설구분명
Categorical

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
상수도전용
19 
<NA>
5 

Length

Max length5
Median length5
Mean length4.7916667
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상수도전용
2nd row상수도전용
3rd row상수도전용
4th row상수도전용
5th row상수도전용

Common Values

ValueCountFrequency (%)
상수도전용 19
79.2%
<NA> 5
 
20.8%

Length

2024-04-06T20:22:55.482554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T20:22:55.649748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상수도전용 19
79.2%
na 5
 
20.8%

총인원
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

본사종업원수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

공장사무직종업원수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

공장판매직종업원수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

공장생산직종업원수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

건물소유구분명
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

보증액
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

월세액
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

다중이용업소여부
Boolean

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size156.0 B
False
16 
True
8 
ValueCountFrequency (%)
False 16
66.7%
True 8
33.3%
2024-04-06T20:22:55.776742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

시설총규모
Real number (ℝ)

ZEROS 

Distinct18
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean206.295
Minimum0
Maximum1202.3
Zeros7
Zeros (%)29.2%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-06T20:22:55.996974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median94.42
Q3245.99
95-th percentile842.122
Maximum1202.3
Range1202.3
Interquartile range (IQR)245.99

Descriptive statistics

Standard deviation300.66818
Coefficient of variation (CV)1.4574671
Kurtosis5.1168016
Mean206.295
Median Absolute Deviation (MAD)94.42
Skewness2.2520468
Sum4951.08
Variance90401.352
MonotonicityNot monotonic
2024-04-06T20:22:56.185306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
0.0 7
29.2%
94.76 1
 
4.2%
98.03 1
 
4.2%
106.52 1
 
4.2%
53.01 1
 
4.2%
94.08 1
 
4.2%
190.6 1
 
4.2%
557.78 1
 
4.2%
409.72 1
 
4.2%
280.13 1
 
4.2%
Other values (8) 8
33.3%
ValueCountFrequency (%)
0.0 7
29.2%
53.01 1
 
4.2%
70.03 1
 
4.2%
84.54 1
 
4.2%
92.08 1
 
4.2%
94.08 1
 
4.2%
94.76 1
 
4.2%
98.03 1
 
4.2%
106.52 1
 
4.2%
127.84 1
 
4.2%
ValueCountFrequency (%)
1202.3 1
4.2%
892.3 1
4.2%
557.78 1
4.2%
409.72 1
4.2%
362.75 1
4.2%
280.13 1
4.2%
234.61 1
4.2%
190.6 1
4.2%
127.84 1
4.2%
106.52 1
4.2%

전통업소지정번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

전통업소주된음식
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

홈페이지
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Sample

개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)위생업태명남성종사자수여성종사자수영업장주변구분명등급구분명급수시설구분명총인원본사종업원수공장사무직종업원수공장판매직종업원수공장생산직종업원수건물소유구분명보증액월세액다중이용업소여부시설총규모전통업소지정번호전통업소주된음식홈페이지
030700003070000-102-1967-0765219690916<NA>3폐업2폐업19950630<NA><NA><NA>02 9120420<NA>136873서울특별시 성북구 하월곡동 88-71번지<NA><NA>뉴OB2001-12-12 00:00:00I2018-08-31 23:59:59.0카바레202463.29111456061.413844카바레611주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N0.0<NA><NA><NA>
130700003070000-102-1968-0769319680215<NA>3폐업2폐업20000201<NA><NA><NA>0207620161<NA>136823서울특별시 성북구 성북동 323번지<NA><NA>(주)대원각2001-12-12 00:00:00I2018-08-31 23:59:59.0요정199387.313201455179.190284요정1114주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N0.0<NA><NA><NA>
230700003070000-102-1970-0769119700610<NA>3폐업2폐업20051130<NA><NA><NA>0209121080127.84136858서울특별시 성북구 종암동 3-75번지<NA><NA>삼성민속주점2001-12-12 00:00:00I2018-08-31 23:59:59.0룸살롱<NA><NA>룸살롱33주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N127.84<NA><NA><NA>
330700003070000-102-1971-0765319711102<NA>3폐업2폐업19960408<NA><NA><NA>02 9130038<NA>136858서울특별시 성북구 종암동 16-4번지<NA><NA>야광스텐드빠2001-12-12 00:00:00I2018-08-31 23:59:59.0스텐드바<NA><NA>스텐드바25주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N0.0<NA><NA><NA>
430700003070000-102-1972-0769219721209<NA>3폐업2폐업19971229<NA><NA><NA>02 7620151<NA>136823서울특별시 성북구 성북동 330-115번지<NA><NA>예향2001-12-12 00:00:00I2018-08-31 23:59:59.0요정198545.87602454980.927178요정<NA><NA>주택가주변자율상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N0.0<NA><NA><NA>
530700003070000-102-1973-0765019731031<NA>1영업/정상1영업<NA><NA><NA><NA>020912272092.08136800서울특별시 성북구 길음동 877-195번지서울특별시 성북구 동소문로 225-3 (길음동)2721로또2019-09-27 14:27:55U2019-09-29 02:40:00.0스텐드바201865.417608455541.255496스텐드바<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>Y92.08<NA><NA><NA>
630700003070000-102-1973-0768919730901<NA>3폐업2폐업20091229<NA><NA><NA>020926559570.03136075서울특별시 성북구 안암동5가 104-119번지 ,104-129<NA><NA>세종2007-08-30 10:22:16I2018-08-31 23:59:59.0룸살롱202551.784562453432.98543룸살롱34주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N70.03<NA><NA><NA>
730700003070000-102-1974-0765119740401<NA>1영업/정상1영업<NA><NA><NA><NA>02 917765384.54136859서울특별시 성북구 종암동 3-1235번지서울특별시 성북구 종암로22길 7 (종암동)2797스카이 노래밤2017-02-03 10:00:24I2018-08-31 23:59:59.0카바레202988.136369455286.462033카바레<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>Y84.54<NA><NA><NA>
830700003070000-102-1974-0769119740228<NA>1영업/정상1영업<NA><NA><NA><NA>02 924 8842362.75136084서울특별시 성북구 보문동4가 77-2번지 외3필지(76번지포함)서울특별시 성북구 보문로 78 (보문동4가, 지하1층)2852팝콘뮤직타운2018-06-07 16:02:58I2018-08-31 23:59:59.0카바레201810.388914453337.054032카바레<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>Y362.75<NA><NA><NA>
930700003070000-102-1975-0764919750224<NA>3폐업2폐업20000217<NA><NA><NA>0209126902<NA>136802서울특별시 성북구 길음동 535-20번지<NA><NA>방콕2001-12-12 00:00:00I2018-08-31 23:59:59.0스텐드바201905.866342455616.421898스텐드바26주택가주변을상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N0.0<NA><NA><NA>
개방자치단체코드관리번호인허가일자인허가취소일자영업상태코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자전화번호소재지면적소재지우편번호지번주소도로명주소도로명우편번호사업장명최종수정일자데이터갱신구분데이터갱신일자업태구분명좌표정보(X)좌표정보(Y)위생업태명남성종사자수여성종사자수영업장주변구분명등급구분명급수시설구분명총인원본사종업원수공장사무직종업원수공장판매직종업원수공장생산직종업원수건물소유구분명보증액월세액다중이용업소여부시설총규모전통업소지정번호전통업소주된음식홈페이지
1430700003070000-102-2000-1035320000626<NA>3폐업2폐업20120313<NA><NA><NA>02 9268515234.61136036서울특별시 성북구 동소문동6가 133-1번지서울특별시 성북구 아리랑로 3 (동소문동6가)2830아싸2013-11-15 09:31:06I2018-08-31 23:59:59.0룸살롱201358.388614454534.250494룸살롱00기타기타상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N234.61<NA><NA><NA>
1530700003070000-102-2000-1040620000724<NA>3폐업2폐업20090624<NA><NA><NA>02 9436004280.13136140서울특별시 성북구 장위동 45-12번지 ,13,14,25<NA><NA>바다 가요주점2008-05-09 11:16:48I2018-08-31 23:59:59.0룸살롱205217.602421456715.560474룸살롱00<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>N280.13<NA><NA><NA>
1630700003070000-102-2001-1086620010402<NA>3폐업2폐업20090211<NA><NA><NA>02 985933394.76136800서울특별시 성북구 길음동 25-7번지<NA><NA>여우2010-02-05 14:13:19I2018-08-31 23:59:59.0룸살롱202571.112399456435.426314룸살롱21결혼예식장주변기타상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N94.76<NA><NA><NA>
1730700003070000-102-2001-1107120010627<NA>1영업/정상1영업<NA><NA><NA><NA>02 9271950409.72136036서울특별시 성북구 동소문동6가 133-2번지 (지하1층)서울특별시 성북구 아리랑로 3 (동소문동6가,(지하1층))2830카니발2018-11-05 14:37:29U2018-11-07 02:37:12.0룸살롱201363.138482454514.752552룸살롱00유흥업소밀집지역기타상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>Y409.72<NA><NA><NA>
1830700003070000-102-2002-0000120020828<NA>3폐업2폐업20050720<NA><NA><NA>02 9593501557.78136819서울특별시 성북구 석관동 337-1번지<NA><NA>뉴월드 나이트크럽2005-03-02 00:00:00I2018-08-31 23:59:59.0스텐드바204906.231828456420.949081스텐드바<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>N557.78<NA><NA><NA>
1930700003070000-102-2003-0000120030828<NA>3폐업2폐업20070316<NA><NA><NA>02 943 1669190.60136826서울특별시 성북구 장위동 45-1번지<NA><NA>무학2003-08-28 00:00:00I2018-08-31 23:59:59.0카바레205216.606119456753.873513카바레00<NA><NA>상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>N190.6<NA><NA><NA>
2030700003070000-102-2004-0000120040621<NA>1영업/정상1영업<NA><NA><NA><NA>02 927777694.08136054서울특별시 성북구 동선동4가 7 외 1필지서울특별시 성북구 아리랑로 4 (동선동4가,외 1필지)2829하트노래2020-09-14 16:52:17U2020-09-16 02:40:00.0룸살롱201394.713958454544.984918룸살롱00<NA><NA>상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>Y94.08<NA><NA><NA>
2130700003070000-102-2005-0000120050418<NA>1영업/정상1영업<NA><NA><NA><NA>02 923027753.01136035서울특별시 성북구 동소문동5가 85번지서울특별시 성북구 동소문로20길 12 (동소문동5가)2846발리2017-02-03 10:02:05I2018-08-31 23:59:59.0룸살롱201386.544353454412.772728룸살롱00유흥업소밀집지역<NA>상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>Y53.01<NA><NA><NA>
2230700003070000-102-2005-0000220050517<NA>1영업/정상1영업<NA><NA><NA><NA>02 929 6823106.52136051서울특별시 성북구 동선동1가 2-12번지서울특별시 성북구 동소문로20나길 3 (동선동1가)2845놀자뮤직타운2019-10-23 13:37:06U2019-10-25 02:40:00.0룸살롱201414.192716454407.00497룸살롱00유흥업소밀집지역<NA>상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>Y106.52<NA><NA><NA>
2330700003070000-102-2011-0000120110623<NA>1영업/정상1영업<NA><NA><NA><NA>02 924 859498.03136084서울특별시 성북구 보문동4가 77-2번지 브라운관광호텔 지하1층서울특별시 성북구 보문로 78 (보문동4가,브라운관광호텔 지하1층)2852올챙이주점2017-02-03 10:02:52I2018-08-31 23:59:59.0룸살롱201810.388914453337.054032룸살롱<NA><NA>기타<NA>상수도전용<NA><NA><NA><NA><NA><NA><NA><NA>Y98.03<NA><NA><NA>