gimi9 Pandas Profiling

Dataset statistics

Number of variables	19
Number of observations	3745
Missing cells	28517
Missing cells (%)	40.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	610.9 KiB
Average record size in memory	167.0 B

Variable types

Numeric	8
Text	2
Unsupported	6
Categorical	3

Dataset

Description	파일 다운로드
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15052/S/1/datasetView.do

Alerts

`영업상태명` has constant value ""	Constant
`자격소유인원수` is highly overall correlated with `재개업일자` and 1 other fields	High correlation
`상세영업상태명` is highly overall correlated with `번호` and 8 other fields	High correlation
`번호` is highly overall correlated with `상세영업상태명`	High correlation
`인허가일자` is highly overall correlated with `상세영업상태명`	High correlation
`재개업일자` is highly overall correlated with `총인원수` and 3 other fields	High correlation
`입소정원` is highly overall correlated with `상세영업상태명`	High correlation
`총인원수` is highly overall correlated with `재개업일자` and 1 other fields	High correlation
`위치정보(X)` is highly overall correlated with `재개업일자` and 1 other fields	High correlation
`위치정보(Y)` is highly overall correlated with `인허가번호` and 1 other fields	High correlation
`인허가번호` is highly overall correlated with `위치정보(Y)` and 1 other fields	High correlation
`자격소유인원수` is highly imbalanced (71.8%)	Imbalance
`상세영업상태명` is highly imbalanced (93.6%)	Imbalance
`도로명전체주소` has 3745 (100.0%) missing values	Missing
`폐업일자` has 3745 (100.0%) missing values	Missing
`휴업시작일자` has 3745 (100.0%) missing values	Missing
`휴업종료일자` has 3745 (100.0%) missing values	Missing
`재개업일자` has 3725 (99.5%) missing values	Missing
`소재지면적` has 3745 (100.0%) missing values	Missing
`소재지우편번호` has 3745 (100.0%) missing values	Missing
`입소정원` has 58 (1.5%) missing values	Missing
`총인원수` has 450 (12.0%) missing values	Missing
`위치정보(X)` has 907 (24.2%) missing values	Missing
`위치정보(Y)` has 907 (24.2%) missing values	Missing
`입소정원` is highly skewed (γ1 = 45.9310573)	Skewed
`번호` has unique values	Unique
`도로명전체주소` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`폐업일자` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`휴업시작일자` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`휴업종료일자` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`소재지면적` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`소재지우편번호` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`입소정원` has 1317 (35.2%) zeros	Zeros
`총인원수` has 2197 (58.7%) zeros	Zeros

Reproduction

Analysis started	2024-03-13 12:57:09.658839
Analysis finished	2024-03-13 12:57:20.768085
Duration	11.11 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	3745
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1873

Minimum	1
Maximum	3745
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	1
5-th percentile	188.2
Q1	937
median	1873
Q3	2809
95-th percentile	3557.8
Maximum	3745
Range	3744
Interquartile range (IQR)	1872

Descriptive statistics

Standard deviation	1081.2327
Coefficient of variation (CV)	0.5772732
Kurtosis	-1.2
Mean	1873
Median Absolute Deviation (MAD)	936
Skewness	0
Sum	7014385
Variance	1169064.2
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
2502	1	< 0.1%
2490	1	< 0.1%
2491	1	< 0.1%
2492	1	< 0.1%
2493	1	< 0.1%
2494	1	< 0.1%
2495	1	< 0.1%
2496	1	< 0.1%
2497	1	< 0.1%
Other values (3735)	3735	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
3745	1	< 0.1%
3744	1	< 0.1%
3743	1	< 0.1%
3742	1	< 0.1%
3741	1	< 0.1%
3740	1	< 0.1%
3739	1	< 0.1%
3738	1	< 0.1%
3737	1	< 0.1%
3736	1	< 0.1%

사업장명
Text

Distinct	3294
Distinct (%)	88.0%
Missing	0
Missing (%)	0.0%
Memory size	29.4 KiB

Length

Max length	29
Median length	20
Mean length	9.0987984
Min length	2

Characters and Unicode

Total characters	34075
Distinct characters	492
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3039 ?
Unique (%)	81.1%

Sample

1st row	백련산힐스테이트2차아파트경로당
2nd row	백련산힐스테이트1차아파트경로당
3rd row	구립양평3가경로당
4th row	큰덕경로당
5th row	마곡엠밸리6단지경로당

Value	Count	Frequency (%)
경로당	591	12.8%
은평뉴타운	21	0.5%
현대아파트경로당	16	0.3%
장수경로당	15	0.3%
한신아파트경로당	14	0.3%
삼성아파트경로당	13	0.3%
구립	13	0.3%
아파트	12	0.3%
제2경로당	11	0.2%
중앙경로당	10	0.2%
Other values (3360)	3893	84.5%

Most occurring characters

Value	Count	Frequency (%)
경	3509	10.3%
로	3487	10.2%
당	3487	10.2%
아	2017	5.9%
파	1469	4.3%
트	1428	4.2%
	865	2.5%
동	703	2.1%
)	547	1.6%
(	539	1.6%
Other values (482)	16024	47.0%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	30452	89.4%
Decimal Number	1349	4.0%
Space Separator	865	2.5%
Close Punctuation	547	1.6%
Open Punctuation	539	1.6%
Uppercase Letter	196	0.6%
Lowercase Letter	66	0.2%
Other Punctuation	43	0.1%
Dash Punctuation	18	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
경	3509	11.5%
로	3487	11.5%
당	3487	11.5%
아	2017	6.6%
파	1469	4.8%
트	1428	4.7%
동	703	2.3%
지	472	1.5%
대	419	1.4%
단	365	1.2%
Other values (431)	13096	43.0%

Uppercase Letter

Value	Count	Frequency (%)
A	50	25.5%
S	23	11.7%
H	19	9.7%
L	16	8.2%
K	15	7.7%
C	14	7.1%
P	10	5.1%
D	8	4.1%
M	7	3.6%
I	7	3.6%
Other values (7)	27	13.8%

Lowercase Letter

Value	Count	Frequency (%)
e	29	43.9%
l	8	12.1%
i	5	7.6%
s	4	6.1%
k	4	6.1%
v	3	4.5%
p	2	3.0%
r	2	3.0%
h	2	3.0%
a	1	1.5%
Other values (6)	6	9.1%

Decimal Number

Value	Count	Frequency (%)
1	412	30.5%
2	410	30.4%
3	178	13.2%
4	96	7.1%
5	72	5.3%
6	51	3.8%
7	37	2.7%
0	35	2.6%
9	30	2.2%
8	28	2.1%

Other Punctuation

Value	Count	Frequency (%)
@	30	69.8%
,	8	18.6%
.	4	9.3%
'	1	2.3%

Space Separator

Value	Count	Frequency (%)
	865	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	547	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	539	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	18	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	30452	89.4%
Common	3361	9.9%
Latin	262	0.8%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
경	3509	11.5%
로	3487	11.5%
당	3487	11.5%
아	2017	6.6%
파	1469	4.8%
트	1428	4.7%
동	703	2.3%
지	472	1.5%
대	419	1.4%
단	365	1.2%
Other values (431)	13096	43.0%

Latin

Value	Count	Frequency (%)
A	50	19.1%
e	29	11.1%
S	23	8.8%
H	19	7.3%
L	16	6.1%
K	15	5.7%
C	14	5.3%
P	10	3.8%
l	8	3.1%
D	8	3.1%
Other values (23)	70	26.7%

Common

Value	Count	Frequency (%)
	865	25.7%
)	547	16.3%
(	539	16.0%
1	412	12.3%
2	410	12.2%
3	178	5.3%
4	96	2.9%
5	72	2.1%
6	51	1.5%
7	37	1.1%
Other values (8)	154	4.6%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	30452	89.4%
ASCII	3623	10.6%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
경	3509	11.5%
로	3487	11.5%
당	3487	11.5%
아	2017	6.6%
파	1469	4.8%
트	1428	4.7%
동	703	2.3%
지	472	1.5%
대	419	1.4%
단	365	1.2%
Other values (431)	13096	43.0%

ASCII

Value	Count	Frequency (%)
	865	23.9%
)	547	15.1%
(	539	14.9%
1	412	11.4%
2	410	11.3%
3	178	4.9%
4	96	2.6%
5	72	2.0%
6	51	1.4%
A	50	1.4%
Other values (41)	403	11.1%

소재지전체주소
Text

Distinct	3228
Distinct (%)	86.2%
Missing	0
Missing (%)	0.0%
Memory size	29.4 KiB

Length

Max length	45
Median length	42
Mean length	21.259012
Min length	6

Characters and Unicode

Total characters	79615
Distinct characters	312
Distinct categories	10 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2960 ?
Unique (%)	79.0%

Sample

1st row	서울특별시 은평구 응암동 백련산힐스테이트2차아파트
2nd row	서울특별시 은평구 응암동
3rd row	서울특별시 영등포구 양평동3가 36번지
4th row	서울특별시 마포구 공덕동
5th row	서울특별시 강서구 마곡동

Value	Count	Frequency (%)
서울특별시	3744	24.9%
노원구	239	1.6%
강서구	238	1.6%
강남구	218	1.5%
구로구	194	1.3%
성북구	190	1.3%
영등포구	188	1.3%
서초구	178	1.2%
성동구	177	1.2%
마포구	175	1.2%
Other values (2964)	9466	63.1%

Most occurring characters

Value	Count	Frequency (%)
	14939	18.8%
동	4520	5.7%
서	4355	5.5%
구	4044	5.1%
시	3789	4.8%
특	3744	4.7%
별	3744	4.7%
울	3744	4.7%
지	3228	4.1%
번	3177	4.0%
Other values (302)	30331	38.1%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	50405	63.3%
Space Separator	14939	18.8%
Decimal Number	12644	15.9%
Dash Punctuation	1564	2.0%
Uppercase Letter	34	< 0.1%
Close Punctuation	9	< 0.1%
Other Punctuation	9	< 0.1%
Open Punctuation	7	< 0.1%
Lowercase Letter	3	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	4520	9.0%
서	4355	8.6%
구	4044	8.0%
시	3789	7.5%
특	3744	7.4%
별	3744	7.4%
울	3744	7.4%
지	3228	6.4%
번	3177	6.3%
강	738	1.5%
Other values (270)	15322	30.4%

Uppercase Letter

Value	Count	Frequency (%)
B	5	14.7%
L	5	14.7%
H	4	11.8%
C	4	11.8%
S	3	8.8%
K	3	8.8%
I	2	5.9%
D	2	5.9%
A	2	5.9%
V	1	2.9%
Other values (3)	3	8.8%

Decimal Number

Value	Count	Frequency (%)
1	2599	20.6%
2	1517	12.0%
3	1345	10.6%
4	1178	9.3%
0	1178	9.3%
5	1174	9.3%
7	1026	8.1%
6	999	7.9%
8	863	6.8%
9	765	6.1%

Other Punctuation

Value	Count	Frequency (%)
,	8	88.9%
.	1	11.1%

Lowercase Letter

Value	Count	Frequency (%)
c	2	66.7%
e	1	33.3%

Space Separator

Value	Count	Frequency (%)
	14939	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1564	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	50405	63.3%
Common	29173	36.6%
Latin	37	< 0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	4520	9.0%
서	4355	8.6%
구	4044	8.0%
시	3789	7.5%
특	3744	7.4%
별	3744	7.4%
울	3744	7.4%
지	3228	6.4%
번	3177	6.3%
강	738	1.5%
Other values (270)	15322	30.4%

Common

Value	Count	Frequency (%)
	14939	51.2%
1	2599	8.9%
-	1564	5.4%
2	1517	5.2%
3	1345	4.6%
4	1178	4.0%
0	1178	4.0%
5	1174	4.0%
7	1026	3.5%
6	999	3.4%
Other values (7)	1654	5.7%

Latin

Value	Count	Frequency (%)
B	5	13.5%
L	5	13.5%
H	4	10.8%
C	4	10.8%
S	3	8.1%
K	3	8.1%
I	2	5.4%
D	2	5.4%
c	2	5.4%
A	2	5.4%
Other values (5)	5	13.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	50405	63.3%
ASCII	29210	36.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14939	51.1%
1	2599	8.9%
-	1564	5.4%
2	1517	5.2%
3	1345	4.6%
4	1178	4.0%
0	1178	4.0%
5	1174	4.0%
7	1026	3.5%
6	999	3.4%
Other values (22)	1691	5.8%

Hangul

Value	Count	Frequency (%)
동	4520	9.0%
서	4355	8.6%
구	4044	8.0%
시	3789	7.5%
특	3744	7.4%
별	3744	7.4%
울	3744	7.4%
지	3228	6.4%
번	3177	6.3%
강	738	1.5%
Other values (270)	15322	30.4%

도로명전체주소
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

인허가일자
Real number (ℝ)

HIGH CORRELATION

Distinct	2192
Distinct (%)	58.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19991198

Minimum	18001021
Maximum	20180410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	18001021
5-th percentile	19840138
Q1	19911125
median	20001230
Q3	20070501
95-th percentile	20130423
Maximum	20180410
Range	2179389
Interquartile range (IQR)	159376

Descriptive statistics

Standard deviation	100858.24
Coefficient of variation (CV)	0.0050451325
Kurtosis	40.186553
Mean	19991198
Median Absolute Deviation (MAD)	70619
Skewness	-2.5358487
Sum	7.4867037 × 10¹⁰
Variance	1.0172385 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19890601	104	2.8%
20080111	104	2.8%
19890630	76	2.0%
20080109	65	1.7%
20080110	64	1.7%
19890706	52	1.4%
20080108	40	1.1%
20071126	40	1.1%
19890701	38	1.0%
19890501	37	1.0%
Other values (2182)	3125	83.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18001021	1	< 0.1%
19580101	1	< 0.1%
19600701	1	< 0.1%
19610531	1	< 0.1%
19611101	1	< 0.1%
19620701	1	< 0.1%
19630603	1	< 0.1%
19630613	1	< 0.1%
19640327	1	< 0.1%
19650101	1	< 0.1%

Value	Count	Frequency (%)
20180410	1	< 0.1%
20180406	1	< 0.1%
20180404	1	< 0.1%
20180326	1	< 0.1%
20180313	1	< 0.1%
20180228	1	< 0.1%
20180219	1	< 0.1%
20180213	2	0.1%
20180119	2	0.1%
20180110	1	< 0.1%

영업상태명
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.4 KiB

운영중	3745

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	운영중
2nd row	운영중
3rd row	운영중
4th row	운영중
5th row	운영중

Common Values

Value	Count	Frequency (%)
운영중	3745	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
운영중	3745	100.0%

폐업일자
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

휴업시작일자
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

휴업종료일자
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

재개업일자
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	20
Distinct (%)	100.0%
Missing	3725
Missing (%)	99.5%
Infinite	0
Infinite (%)	0.0%
Mean	20068143

Minimum	19810315
Maximum	20180405
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	19810315
5-th percentile	19924992
Q1	20012953
median	20106107
Q3	20150156
95-th percentile	20171686
Maximum	20180405
Range	370090
Interquartile range (IQR)	137203.75

Descriptive statistics

Standard deviation	101129.28
Coefficient of variation (CV)	0.0050392946
Kurtosis	0.4796333
Mean	20068143
Median Absolute Deviation (MAD)	55069
Skewness	-1.048947
Sum	4.0136286 × 10⁸
Variance	1.0227132 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
20150601	1	< 0.1%
20150101	1	< 0.1%
20080115	1	< 0.1%
20150323	1	< 0.1%
20171227	1	< 0.1%
20140313	1	< 0.1%
20180405	1	< 0.1%
20040513	1	< 0.1%
19931028	1	< 0.1%
20120913	1	< 0.1%
Other values (10)	10	0.3%
(Missing)	3725	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19810315	1	< 0.1%
19931028	1	< 0.1%
19950113	1	< 0.1%
19950513	1	< 0.1%
19960605	1	< 0.1%
20030402	1	< 0.1%
20040513	1	< 0.1%
20040923	1	< 0.1%
20080115	1	< 0.1%
20101103	1	< 0.1%

Value	Count	Frequency (%)
20180405	1	< 0.1%
20171227	1	< 0.1%
20151125	1	< 0.1%
20150601	1	< 0.1%
20150323	1	< 0.1%
20150101	1	< 0.1%
20141112	1	< 0.1%
20140313	1	< 0.1%
20120913	1	< 0.1%
20111111	1	< 0.1%

소재지면적
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

소재지우편번호
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	3745
Missing (%)	100.0%
Memory size	33.0 KiB

입소정원
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	140
Distinct (%)	3.8%
Missing	58
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	29.656903

Minimum	0
Maximum	4085
Zeros	1317
Zeros (%)	35.2%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	25
Q3	43
95-th percentile	84
Maximum	4085
Range	4085
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	73.383363
Coefficient of variation (CV)	2.4744109
Kurtosis	2531.6839
Mean	29.656903
Median Absolute Deviation (MAD)	25
Skewness	45.931057
Sum	109345
Variance	5385.118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1317	35.2%
30	146	3.9%
20	133	3.6%
25	108	2.9%
40	107	2.9%
50	104	2.8%
22	80	2.1%
23	65	1.7%
35	64	1.7%
21	62	1.7%
Other values (130)	1501	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1317	35.2%
1	8	0.2%
2	1	< 0.1%
3	5	0.1%
5	1	< 0.1%
10	3	0.1%
14	1	< 0.1%
15	3	0.1%
16	1	< 0.1%
18	3	0.1%

Value	Count	Frequency (%)
4085	1	< 0.1%
363	1	< 0.1%
275	1	< 0.1%
215	1	< 0.1%
214	1	< 0.1%
200	1	< 0.1%
195	1	< 0.1%
180	1	< 0.1%
165	2	0.1%
163	1	< 0.1%

자격소유인원수
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.4 KiB

0	3271
<NA>	466
1	7
2	1

Length

Max length	4
Median length	1
Mean length	1.3732977
Min length	1

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

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

Common Values

Value	Count	Frequency (%)
0	3271	87.3%
<NA>	466	12.4%
1	7	0.2%
2	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	3271	87.3%
na	466	12.4%
1	7	0.2%
2	1	< 0.1%

총인원수
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	97
Distinct (%)	2.9%
Missing	450
Missing (%)	12.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5314112

Minimum	0
Maximum	165
Zeros	2197
Zeros (%)	58.7%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	45
Maximum	165
Range	165
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	18.458214
Coefficient of variation (CV)	2.8260683
Kurtosis	17.078238
Mean	6.5314112
Median Absolute Deviation (MAD)	0
Skewness	3.8227525
Sum	21521
Variance	340.70568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2197	58.7%
1	416	11.1%
2	136	3.6%
3	68	1.8%
30	27	0.7%
60	23	0.6%
22	23	0.6%
24	21	0.6%
25	21	0.6%
20	21	0.6%
Other values (87)	342	9.1%
(Missing)	450	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2197	58.7%
1	416	11.1%
2	136	3.6%
3	68	1.8%
4	5	0.1%
5	16	0.4%
6	2	0.1%
20	21	0.6%
21	21	0.6%
22	23	0.6%

Value	Count	Frequency (%)
165	1	< 0.1%
145	1	< 0.1%
144	1	< 0.1%
139	1	< 0.1%
138	1	< 0.1%
135	2	0.1%
128	1	< 0.1%
126	1	< 0.1%
122	1	< 0.1%
120	4	0.1%

위치정보(X)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2621
Distinct (%)	92.4%
Missing	907
Missing (%)	24.2%
Infinite	0
Infinite (%)	0.0%
Mean	198846.38

Minimum	182159.3
Maximum	215422.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	182159.3
5-th percentile	185971.91
Q1	191810.14
median	200941.36
Q3	205170.64
95-th percentile	210587.12
Maximum	215422.75
Range	33263.442
Interquartile range (IQR)	13360.509

Descriptive statistics

Standard deviation	7840.8756
Coefficient of variation (CV)	0.039431824
Kurtosis	-1.0784102
Mean	198846.38
Median Absolute Deviation (MAD)	6032.5629
Skewness	-0.2070571
Sum	5.6432603 × 10⁸
Variance	61479330
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
193998.104669	9	0.2%
192855.685644	5	0.1%
202240.553902	4	0.1%
200551.396284	4	0.1%
206101.913844	4	0.1%
204321.927324	3	0.1%
204418.836684	3	0.1%
195045.515108	3	0.1%
208851.688285	3	0.1%
209744.789378	3	0.1%
Other values (2611)	2797	74.7%
(Missing)	907	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
182159.304087	1	< 0.1%
182405.42605	1	< 0.1%
182742.537963	1	< 0.1%
182801.35478	1	< 0.1%
182859.059693	1	< 0.1%
182882.878688	1	< 0.1%
182929.561796	1	< 0.1%
182945.351625	1	< 0.1%
182977.186875	1	< 0.1%
182984.581165	1	< 0.1%

Value	Count	Frequency (%)
215422.74612	1	< 0.1%
215223.60463	1	< 0.1%
215104.181061	1	< 0.1%
215097.641078	1	< 0.1%
214913.822718	1	< 0.1%
214912.807517	1	< 0.1%
213902.813009	1	< 0.1%
213749.143548	1	< 0.1%
213670.115208	1	< 0.1%
213646.900696	1	< 0.1%

위치정보(Y)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2621
Distinct (%)	92.4%
Missing	907
Missing (%)	24.2%
Infinite	0
Infinite (%)	0.0%
Mean	450240.4

Minimum	436993.64
Maximum	465314.41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	436993.64
5-th percentile	441565.79
Q1	445125.99
median	449559.8
Q3	454843.95
95-th percentile	461537.32
Maximum	465314.41
Range	28320.768
Interquartile range (IQR)	9717.961

Descriptive statistics

Standard deviation	6207.0626
Coefficient of variation (CV)	0.013786107
Kurtosis	-0.74309536
Mean	450240.4
Median Absolute Deviation (MAD)	4739.7757
Skewness	0.348025
Sum	1.2777823 × 10⁹
Variance	38527626
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
453150.854122	9	0.2%
439663.585571	5	0.1%
447598.16242	4	0.1%
445806.025612	4	0.1%
452155.691149	4	0.1%
447244.33957	3	0.1%
439958.443579	3	0.1%
443011.455008	3	0.1%
448904.553298	3	0.1%
446601.107402	3	0.1%
Other values (2611)	2797	74.7%
(Missing)	907	24.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
436993.641744	1	< 0.1%
437488.324222	2	0.1%
437684.82988	1	< 0.1%
437926.789074	1	< 0.1%
438018.443263	1	< 0.1%
438423.909375	1	< 0.1%
438460.66732	2	0.1%
438525.414483	1	< 0.1%
438580.148239	2	0.1%
438583.251827	2	0.1%

Value	Count	Frequency (%)
465314.409287	1	< 0.1%
465282.682615	1	< 0.1%
465165.043328	1	< 0.1%
465025.246647	1	< 0.1%
464905.033087	2	0.1%
464832.867314	1	< 0.1%
464814.717432	1	< 0.1%
464663.321565	1	< 0.1%
464588.079484	1	< 0.1%
464514.89393	1	< 0.1%

인허가번호
Real number (ℝ)

HIGH CORRELATION

Distinct	3744
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1252582 × 10¹⁵

Minimum	1
Maximum	3.2400002 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.0 KiB

Quantile statistics

Minimum	1
5-th percentile	3.0200002 × 10¹⁵
Q1	3.0700002 × 10¹⁵
median	3.1300002 × 10¹⁵
Q3	3.1900001 × 10¹⁵
95-th percentile	3.2300002 × 10¹⁵
Maximum	3.2400002 × 10¹⁵
Range	3.2400002 × 10¹⁵
Interquartile range (IQR)	1.1999991 × 10¹⁴

Descriptive statistics

Standard deviation	1.3674335 × 10¹⁴
Coefficient of variation (CV)	0.043754258
Kurtosis	374.66682
Mean	3.1252582 × 10¹⁵
Median Absolute Deviation (MAD)	5.999991 × 10¹³
Skewness	-16.792421
Sum	-6.7426522 × 10¹⁸
Variance	1.8698745 × 10²⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200100001	2	0.1%
3070000200600045	1	< 0.1%
3070000200700027	1	< 0.1%
3070000200700033	1	< 0.1%
3070000200500075	1	< 0.1%
3070000200600008	1	< 0.1%
3070000200600009	1	< 0.1%
3070000200600010	1	< 0.1%
3070000200600011	1	< 0.1%
3070000200600017	1	< 0.1%
Other values (3734)	3734	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
199900001	1	< 0.1%
200000001	1	< 0.1%
200100001	2	0.1%
1111111111111111	1	< 0.1%
3000000196000001	1	< 0.1%
3000000196200001	1	< 0.1%
3000000196400001	1	< 0.1%
3000000196600001	1	< 0.1%
3000000196700001	1	< 0.1%

Value	Count	Frequency (%)
3240000201800004	1	< 0.1%
3240000201800003	1	< 0.1%
3240000201700012	1	< 0.1%
3240000201700011	1	< 0.1%
3240000201700010	1	< 0.1%
3240000201700002	1	< 0.1%
3240000201600008	1	< 0.1%
3240000201600002	1	< 0.1%
3240000201400005	1	< 0.1%
3240000201400001	1	< 0.1%

상세영업상태명
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.4 KiB

운영	3717
<NA>	28

Length

Max length	4
Median length	2
Mean length	2.0149533
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	운영
2nd row	운영
3rd row	운영
4th row	운영
5th row	운영

Common Values

Value	Count	Frequency (%)
운영	3717	99.3%
<NA>	28	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
운영	3717	99.3%
na	28	0.7%

Heatmap
Table

	번호	인허가일자	재개업일자	입소정원	자격소유인원수	총인원수	위치정보(X)	위치정보(Y)	인허가번호
번호	1.000	0.260	0.383	0.000	0.000	0.387	0.809	0.789	0.055
인허가일자	0.260	1.000	0.515	0.000	0.050	0.201	0.173	0.230	0.000
재개업일자	0.383	0.515	1.000	NaN	NaN	0.000	0.000	0.350	NaN
입소정원	0.000	0.000	NaN	1.000	0.000	0.000	0.000	0.000	0.000
자격소유인원수	0.000	0.050	NaN	0.000	1.000	0.000	0.000	0.055	0.000
총인원수	0.387	0.201	0.000	0.000	0.000	1.000	0.357	0.293	0.000
위치정보(X)	0.809	0.173	0.000	0.000	0.000	0.357	1.000	0.619	0.000
위치정보(Y)	0.789	0.230	0.350	0.000	0.055	0.293	0.619	1.000	0.046
인허가번호	0.055	0.000	NaN	0.000	0.000	0.000	0.000	0.046	1.000

Heatmap
Table

	자격소유인원수	상세영업상태명
자격소유인원수	1.000	1.000
상세영업상태명	1.000	1.000

Heatmap
Table

	번호	인허가일자	재개업일자	입소정원	총인원수	위치정보(X)	위치정보(Y)	인허가번호	자격소유인원수	상세영업상태명
번호	1.000	0.106	0.239	-0.002	0.146	0.248	-0.053	0.000	0.000	1.000
인허가일자	0.106	1.000	0.247	-0.258	0.092	-0.090	-0.020	0.045	0.000	1.000
재개업일자	0.239	0.247	1.000	0.021	0.566	0.837	-0.319	-0.005	1.000	1.000
입소정원	-0.002	-0.258	0.021	1.000	0.133	0.126	0.026	0.055	0.000	1.000
총인원수	0.146	0.092	0.566	0.133	1.000	0.158	-0.062	-0.091	0.000	1.000
위치정보(X)	0.248	-0.090	0.837	0.126	0.158	1.000	0.283	-0.146	0.000	1.000
위치정보(Y)	-0.053	-0.020	-0.319	0.026	-0.062	0.283	1.000	-0.645	0.042	1.000
인허가번호	0.000	0.045	-0.005	0.055	-0.091	-0.146	-0.645	1.000	0.000	1.000
자격소유인원수	0.000	0.000	1.000	0.000	0.000	0.000	0.042	0.000	1.000	1.000
상세영업상태명	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	번호	사업장명	소재지전체주소	도로명전체주소	인허가일자	영업상태명	폐업일자	휴업시작일자	휴업종료일자	재개업일자	소재지면적	소재지우편번호	입소정원	자격소유인원수	총인원수	위치정보(X)	위치정보(Y)	인허가번호	상세영업상태명
0	1	백련산힐스테이트2차아파트경로당	서울특별시 은평구 응암동 백련산힐스테이트2차아파트	<NA>	20121009	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	3110000201600012	운영
1	2	백련산힐스테이트1차아파트경로당	서울특별시 은평구 응암동	<NA>	20131121	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	<NA>	<NA>	3110000201500015	운영
2	3	구립양평3가경로당	서울특별시 영등포구 양평동3가 36번지	<NA>	19890706	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	189979.778775	447187.580725	3180000201500006	운영
3	4	큰덕경로당	서울특별시 마포구 공덕동	<NA>	20111014	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	<NA>	<NA>	3130000201600006	운영
4	5	마곡엠밸리6단지경로당	서울특별시 강서구 마곡동	<NA>	20160801	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	58	<NA>	<NA>	<NA>	<NA>	3150000201600015	운영
5	6	흐능날 경로당	서울특별시 서초구 내곡동 1-3026번지	<NA>	20160616	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	25	<NA>	<NA>	207370.085715	440099.063839	3210000201600004	운영
6	7	공덕자이제2경로당	서울특별시 마포구 아현동	<NA>	20160629	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	<NA>	<NA>	3130000201600009	운영
7	8	마곡엠밸리3단지 경로당	서울특별시 강서구 마곡동	<NA>	20161028	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	23	<NA>	<NA>	<NA>	<NA>	3150000201600021	운영
8	9	북한산푸르지오아파트경로당	서울특별시 은평구 녹번동	<NA>	20160125	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	<NA>	<NA>	3110000201600001	운영
9	10	신대방벽산아파트경로당	서울특별시 동작구 신대방동	<NA>	20130326	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	0	<NA>	<NA>	<NA>	<NA>	3190000201300003	<NA>

	번호	사업장명	소재지전체주소	도로명전체주소	인허가일자	영업상태명	폐업일자	휴업시작일자	휴업종료일자	재개업일자	소재지면적	소재지우편번호	입소정원	자격소유인원수	총인원수	위치정보(X)	위치정보(Y)	인허가번호	상세영업상태명
3735	3736	SH공사공덕2차삼성아파트 경로당	서울특별시 마포구 공덕동	<NA>	20150203	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	36	<NA>	<NA>	<NA>	<NA>	3130000201800008	운영
3736	3737	창전삼성(아)경로당	서울특별시 마포구 창전동 창전동삼성아파트	<NA>	20060117	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	22	<NA>	<NA>	<NA>	<NA>	3130000201800009	운영
3737	3738	한강밤섬자이아파트 경로당	서울특별시 마포구 하중동 한강밤섬자이	<NA>	20120709	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	29	<NA>	<NA>	<NA>	<NA>	3130000201800010	운영
3738	3739	공덕5차래미안아파트A 경로당	서울특별시 마포구 공덕동 래미안 공덕5차	<NA>	20120118	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	28	<NA>	<NA>	<NA>	<NA>	3130000201800011	운영
3739	3740	월드컵아이파크106동 경로당	서울특별시 마포구 성산동 월드컵아이파크	<NA>	20121126	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	30	<NA>	<NA>	<NA>	<NA>	3130000201800012	운영
3740	3741	상암월드컵파크11단지 경로당	서울특별시 마포구 상암동 상암월드컵파크11단지	<NA>	20121024	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	36	<NA>	<NA>	<NA>	<NA>	3130000201800013	운영
3741	3742	상암월드컵파크12단지(아)경로당	서울특별시 마포구 상암동 상암월드컵파크12단지	<NA>	20110414	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	3130000201800014	운영
3742	3743	아현 아이파크 경로당	서울특별시 마포구 아현동 104동	<NA>	20180406	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	23	<NA>	<NA>	<NA>	<NA>	3130000201800004	운영
3743	3744	구파발10단 제3경로당	서울특별시 은평구 진관동 은평뉴타운구파발	<NA>	20121212	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	22	<NA>	<NA>	<NA>	<NA>	3110000201800003	운영
3744	3745	정릉꿈에그린(아)경로당	서울특별시 성북구 정릉동 정릉꿈에그린	<NA>	20170808	운영중	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	<NA>	3070000201800004	운영

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Decimal Number

Other Punctuation

Lowercase Letter

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample