gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	226
Missing cells	197
Missing cells (%)	5.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	30.1 KiB
Average record size in memory	136.6 B

Variable types

Categorical	5
Numeric	6
Text	5

Dataset

Description	시군구코드,지정년도,지정번호,신청일자,지정일자,취소일자,불가일자,업소명,소재지도로명,소재지지번,허가(신고)번호,업태명,주된음식,영업장면적(㎡),행정동명,급수시설구분
Author	광진구
URL	https://data.seoul.go.kr/dataList/OA-9928/S/1/datasetView.do

Alerts

`시군구코드` has constant value ""	Constant
`급수시설구분` is highly overall correlated with `지정년도` and 8 other fields	High correlation
`불가일자` is highly overall correlated with `신청일자` and 4 other fields	High correlation
`행정동명` is highly overall correlated with `불가일자` and 1 other fields	High correlation
`업태명` is highly overall correlated with `불가일자` and 1 other fields	High correlation
`지정년도` is highly overall correlated with `신청일자` and 2 other fields	High correlation
`지정번호` is highly overall correlated with `급수시설구분`	High correlation
`신청일자` is highly overall correlated with `지정년도` and 4 other fields	High correlation
`지정일자` is highly overall correlated with `지정년도` and 2 other fields	High correlation
`취소일자` is highly overall correlated with `신청일자` and 1 other fields	High correlation
`영업장면적(㎡)` is highly overall correlated with `불가일자` and 1 other fields	High correlation
`불가일자` is highly imbalanced (92.7%)	Imbalance
`지정년도` has 14 (6.2%) missing values	Missing
`지정번호` has 13 (5.8%) missing values	Missing
`지정일자` has 14 (6.2%) missing values	Missing
`취소일자` has 141 (62.4%) missing values	Missing
`주된음식` has 15 (6.6%) missing values	Missing

Reproduction

Analysis started	2024-05-11 03:25:08.848569
Analysis finished	2024-05-11 03:25:25.035590
Duration	16.19 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

시군구코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

3040000	226

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3040000
2nd row	3040000
3rd row	3040000
4th row	3040000
5th row	3040000

Common Values

Value	Count	Frequency (%)
3040000	226	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3040000	226	100.0%

지정년도
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	27
Distinct (%)	12.7%
Missing	14
Missing (%)	6.2%
Infinite	0
Infinite (%)	0.0%
Mean	2009.4858

Minimum	1998
Maximum	2029
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	1998
5-th percentile	1999
Q1	2004
median	2008
Q3	2016
95-th percentile	2022
Maximum	2029
Range	31
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.322936
Coefficient of variation (CV)	0.0036441839
Kurtosis	-0.89488317
Mean	2009.4858
Median Absolute Deviation (MAD)	5.5
Skewness	0.35267608
Sum	426011
Variance	53.625391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
2008	20	8.8%
2005	20	8.8%
2006	15	6.6%
2001	11	4.9%
2016	11	4.9%
1999	10	4.4%
2023	9	4.0%
2007	9	4.0%
2002	9	4.0%
1998	8	3.5%
Other values (17)	90	39.8%
(Missing)	14	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1998	8	3.5%
1999	10	4.4%
2000	3	1.3%
2001	11	4.9%
2002	9	4.0%
2003	8	3.5%
2004	5	2.2%
2005	20	8.8%
2006	15	6.6%
2007	9	4.0%

Value	Count	Frequency (%)
2029	1	0.4%
2023	9	4.0%
2022	6	2.7%
2021	4	1.8%
2020	5	2.2%
2019	7	3.1%
2018	7	3.1%
2017	7	3.1%
2016	11	4.9%
2015	6	2.7%

지정번호
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	157
Distinct (%)	73.7%
Missing	13
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	3747.9249

Minimum	1
Maximum	5659
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	5326
Q3	5526
95-th percentile	5642.8
Maximum	5659
Range	5658
Interquartile range (IQR)	5517

Descriptive statistics

Standard deviation	2518.124
Coefficient of variation (CV)	0.67187153
Kurtosis	-1.3294052
Mean	3747.9249
Median Absolute Deviation (MAD)	253
Skewness	-0.81717194
Sum	798308
Variance	6340948.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	10	4.4%
2	10	4.4%
6	7	3.1%
4	6	2.7%
3	6	2.7%
7	6	2.7%
9	5	2.2%
5	5	2.2%
10	4	1.8%
8	3	1.3%
Other values (147)	151	66.8%
(Missing)	13	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10	4.4%
2	10	4.4%
3	6	2.7%
4	6	2.7%
5	5	2.2%
6	7	3.1%
7	6	2.7%
8	3	1.3%
9	5	2.2%
10	4	1.8%

Value	Count	Frequency (%)
5659	1	0.4%
5658	1	0.4%
5655	1	0.4%
5654	1	0.4%
5653	1	0.4%
5652	1	0.4%
5650	1	0.4%
5648	1	0.4%
5646	1	0.4%
5645	1	0.4%

신청일자
Real number (ℝ)

HIGH CORRELATION

Distinct	50
Distinct (%)	22.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20097723

Minimum	19980220
Maximum	20230930
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	19980220
5-th percentile	19990730
Q1	20050705
median	20080716
Q3	20161021
95-th percentile	20221020
Maximum	20230930
Range	250710
Interquartile range (IQR)	110316

Descriptive statistics

Standard deviation	72200.824
Coefficient of variation (CV)	0.0035924879
Kurtosis	-1.0606431
Mean	20097723
Median Absolute Deviation (MAD)	59485.5
Skewness	0.23259774
Sum	4.5420853 × 10⁹
Variance	5.212959 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20051111	15	6.6%
20170915	15	6.6%
20080430	14	6.2%
20161021	12	5.3%
19990730	11	4.9%
20230801	9	4.0%
20011218	8	3.5%
19980220	8	3.5%
20061023	8	3.5%
20190910	7	3.1%
Other values (40)	119	52.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19980220	8	3.5%
19990730	11	4.9%
20000630	2	0.9%
20001107	1	0.4%
20010517	2	0.9%
20011218	8	3.5%
20020523	1	0.4%
20020917	1	0.4%
20021010	3	1.3%
20021230	5	2.2%

Value	Count	Frequency (%)
20230930	1	0.4%
20230801	9	4.0%
20221020	2	0.9%
20221019	2	0.9%
20221017	2	0.9%
20211015	4	1.8%
20200901	5	2.2%
20190910	7	3.1%
20180928	1	0.4%
20180903	2	0.9%

지정일자
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	39
Distinct (%)	18.4%
Missing	14
Missing (%)	6.2%
Infinite	0
Infinite (%)	0.0%
Mean	20095793

Minimum	19980220
Maximum	20290930
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	19980220
5-th percentile	19990730
Q1	20040923
median	20080620
Q3	20161021
95-th percentile	20221207
Maximum	20290930
Range	310710
Interquartile range (IQR)	120098

Descriptive statistics

Standard deviation	73328.842
Coefficient of variation (CV)	0.0036489648
Kurtosis	-0.89483045
Mean	20095793
Median Absolute Deviation (MAD)	54841
Skewness	0.35030374
Sum	4.2603082 × 10⁹
Variance	5.3771191 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
20051111	14	6.2%
20080620	12	5.3%
20161021	11	4.9%
19990730	10	4.4%
20230930	9	4.0%
20011218	8	3.5%
20061128	8	3.5%
19980220	8	3.5%
20060510	7	3.1%
20121231	7	3.1%
Other values (29)	118	52.2%
(Missing)	14	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19980220	8	3.5%
19990730	10	4.4%
20000630	2	0.9%
20001107	1	0.4%
20010517	3	1.3%
20011218	8	3.5%
20020523	1	0.4%
20021010	3	1.3%
20021030	1	0.4%
20021230	4	1.8%

Value	Count	Frequency (%)
20290930	1	0.4%
20230930	9	4.0%
20221207	6	2.7%
20211129	4	1.8%
20201111	5	2.2%
20191029	7	3.1%
20181023	7	3.1%
20171018	7	3.1%
20161021	11	4.9%
20151013	6	2.7%

취소일자
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	52
Distinct (%)	61.2%
Missing	141
Missing (%)	62.4%
Infinite	0
Infinite (%)	0.0%
Mean	20126825

Minimum	20040108
Maximum	20221031
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	20040108
5-th percentile	20060623
Q1	20071130
median	20111102
Q3	20180710
95-th percentile	20220215
Maximum	20221031
Range	180923
Interquartile range (IQR)	109580

Descriptive statistics

Standard deviation	54537.393
Coefficient of variation (CV)	0.0027096868
Kurtosis	-1.2369244
Mean	20126825
Median Absolute Deviation (MAD)	40473
Skewness	0.36349819
Sum	1.7107801 × 10⁹
Variance	2.9743272 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20070629	7	3.1%
20110906	5	2.2%
20201111	4	1.8%
20121108	4	1.8%
20071130	4	1.8%
20211129	4	1.8%
20191029	3	1.3%
20100427	3	1.3%
20221031	3	1.3%
20101130	3	1.3%
Other values (42)	45	19.9%
(Missing)	141	62.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20040108	1	0.4%
20060307	1	0.4%
20060317	1	0.4%
20060613	1	0.4%
20060622	1	0.4%
20060627	1	0.4%
20060725	1	0.4%
20060803	1	0.4%
20060811	1	0.4%
20060831	1	0.4%

Value	Count	Frequency (%)
20221031	3	1.3%
20220325	1	0.4%
20220217	1	0.4%
20220207	1	0.4%
20211129	4	1.8%
20201111	4	1.8%
20191029	3	1.3%
20190418	1	0.4%
20181023	1	0.4%
20180911	2	0.9%

불가일자
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

<NA>	224
20080620	2

Length

Max length	8
Median length	4
Mean length	4.0353982
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	224	99.1%
20080620	2	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	224	99.1%
20080620	2	0.9%

업소명
Text

Distinct	200
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

Length

Max length	24
Median length	17
Mean length	6.2345133
Min length	2

Characters and Unicode

Total characters	1409
Distinct characters	304
Distinct categories	8 ?
Distinct scripts	4 ?
Distinct blocks	3 ?

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

Unique

Unique	176 ?
Unique (%)	77.9%

Sample

1st row	명가네남원추어탕
2nd row	할매시골청국장
3rd row	장원닭한마리
4th row	중국성
5th row	본가왕뼈감자탕 어린이대공원역점

Value	Count	Frequency (%)
군자점	5	2.0%
한마음정육식당	3	1.2%
장수마을정육식당	3	1.2%
건대점	3	1.2%
구의강변점	3	1.2%
제주뜰향갈치전문점	2	0.8%
망향비빔국수	2	0.8%
매화반점	2	0.8%
지호한방삼계탕광장점	2	0.8%
마포돼지갈비	2	0.8%
Other values (205)	225	89.3%

Most occurring characters

Value	Count	Frequency (%)
점	56	4.0%
	26	1.8%
대	23	1.6%
탕	22	1.6%
장	21	1.5%
가	21	1.5%
원	20	1.4%
국	20	1.4%
치	19	1.3%
자	19	1.3%
Other values (294)	1162	82.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1343	95.3%
Space Separator	26	1.8%
Open Punctuation	11	0.8%
Close Punctuation	11	0.8%
Lowercase Letter	9	0.6%
Other Punctuation	4	0.3%
Decimal Number	3	0.2%
Uppercase Letter	2	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
점	56	4.2%
대	23	1.7%
탕	22	1.6%
장	21	1.6%
가	21	1.6%
원	20	1.5%
국	20	1.5%
치	19	1.4%
자	19	1.4%
비	19	1.4%
Other values (281)	1103	82.1%

Lowercase Letter

Value	Count	Frequency (%)
o	2	22.2%
u	2	22.2%
l	2	22.2%
d	1	11.1%
e	1	11.1%
h	1	11.1%

Decimal Number

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

Space Separator

Value	Count	Frequency (%)
	26	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	11	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	11	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	4	100.0%

Uppercase Letter

Value	Count	Frequency (%)
S	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	1341	95.2%
Common	55	3.9%
Latin	11	0.8%
Han	2	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
점	56	4.2%
대	23	1.7%
탕	22	1.6%
장	21	1.6%
가	21	1.6%
원	20	1.5%
국	20	1.5%
치	19	1.4%
자	19	1.4%
비	19	1.4%
Other values (279)	1101	82.1%

Latin

Value	Count	Frequency (%)
o	2	18.2%
S	2	18.2%
u	2	18.2%
l	2	18.2%
d	1	9.1%
e	1	9.1%
h	1	9.1%

Common

Value	Count	Frequency (%)
	26	47.3%
(	11	20.0%
)	11	20.0%
&	4	7.3%
2	2	3.6%
1	1	1.8%

Han

Value	Count	Frequency (%)
宴	1	50.0%
禧	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	1341	95.2%
ASCII	66	4.7%
CJK	2	0.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
점	56	4.2%
대	23	1.7%
탕	22	1.6%
장	21	1.6%
가	21	1.6%
원	20	1.5%
국	20	1.5%
치	19	1.4%
자	19	1.4%
비	19	1.4%
Other values (279)	1101	82.1%

ASCII

Value	Count	Frequency (%)
	26	39.4%
(	11	16.7%
)	11	16.7%
&	4	6.1%
o	2	3.0%
2	2	3.0%
S	2	3.0%
u	2	3.0%
l	2	3.0%
d	1	1.5%
Other values (3)	3	4.5%

CJK

Value	Count	Frequency (%)
宴	1	50.0%
禧	1	50.0%

소재지도로명
Text

Distinct	201
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

Length

Max length	46
Median length	42
Mean length	28.318584
Min length	23

Characters and Unicode

Total characters	6400
Distinct characters	123
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	178 ?
Unique (%)	78.8%

Sample

1st row	서울특별시 광진구 능동로37길 11, 1층 (중곡동)
2nd row	서울특별시 광진구 아차산로 327, 1층 (자양동)
3rd row	서울특별시 광진구 뚝섬로52길 8, (자양동,(101호))
4th row	서울특별시 광진구 뚝섬로 741, (구의동,,22)
5th row	서울특별시 광진구 능동로19길 8, (화양동)

Value	Count	Frequency (%)
서울특별시	226	18.3%
광진구	226	18.3%
자양동	48	3.9%
구의동	38	3.1%
1층	36	2.9%
화양동	33	2.7%
중곡동	33	2.7%
군자동	23	1.9%
아차산로	23	1.9%
능동로	18	1.5%
Other values (272)	529	42.9%

Most occurring characters

Value	Count	Frequency (%)
	1007	15.7%
동	292	4.6%
구	284	4.4%
,	272	4.2%
광	265	4.1%
)	239	3.7%
(	239	3.7%
1	236	3.7%
진	228	3.6%
시	227	3.5%
Other values (113)	3111	48.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	3664	57.2%
Space Separator	1007	15.7%
Decimal Number	950	14.8%
Other Punctuation	274	4.3%
Close Punctuation	239	3.7%
Open Punctuation	239	3.7%
Dash Punctuation	16	0.2%
Math Symbol	7	0.1%
Uppercase Letter	4	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	292	8.0%
구	284	7.8%
광	265	7.2%
진	228	6.2%
시	227	6.2%
로	227	6.2%
울	226	6.2%
서	226	6.2%
별	226	6.2%
특	226	6.2%
Other values (93)	1237	33.8%

Decimal Number

Value	Count	Frequency (%)
1	236	24.8%
2	120	12.6%
3	108	11.4%
6	77	8.1%
8	76	8.0%
4	76	8.0%
5	76	8.0%
0	73	7.7%
7	63	6.6%
9	45	4.7%

Other Punctuation

Value	Count	Frequency (%)
,	272	99.3%
/	1	0.4%
.	1	0.4%

Uppercase Letter

Value	Count	Frequency (%)
B	3	75.0%
D	1	25.0%

Space Separator

Value	Count	Frequency (%)
	1007	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	239	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	239	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16	100.0%

Math Symbol

Value	Count	Frequency (%)
~	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	3664	57.2%
Common	2732	42.7%
Latin	4	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	292	8.0%
구	284	7.8%
광	265	7.2%
진	228	6.2%
시	227	6.2%
로	227	6.2%
울	226	6.2%
서	226	6.2%
별	226	6.2%
특	226	6.2%
Other values (93)	1237	33.8%

Common

Value	Count	Frequency (%)
	1007	36.9%
,	272	10.0%
)	239	8.7%
(	239	8.7%
1	236	8.6%
2	120	4.4%
3	108	4.0%
6	77	2.8%
8	76	2.8%
4	76	2.8%
Other values (8)	282	10.3%

Latin

Value	Count	Frequency (%)
B	3	75.0%
D	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	3664	57.2%
ASCII	2736	42.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1007	36.8%
,	272	9.9%
)	239	8.7%
(	239	8.7%
1	236	8.6%
2	120	4.4%
3	108	3.9%
6	77	2.8%
8	76	2.8%
4	76	2.8%
Other values (10)	286	10.5%

Hangul

Value	Count	Frequency (%)
동	292	8.0%
구	284	7.8%
광	265	7.2%
진	228	6.2%
시	227	6.2%
로	227	6.2%
울	226	6.2%
서	226	6.2%
별	226	6.2%
특	226	6.2%
Other values (93)	1237	33.8%

소재지지번
Text

Distinct	201
Distinct (%)	88.9%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

Length

Max length	43
Median length	40
Mean length	26.774336
Min length	22

Characters and Unicode

Total characters	6051
Distinct characters	106
Distinct categories	8 ?
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	178 ?
Unique (%)	78.8%

Sample

1st row	서울특별시 광진구 중곡동 649번지 13호 1층
2nd row	서울특별시 광진구 자양동 774번지 28호 1층
3rd row	서울특별시 광진구 자양동 606번지 28호 (101호)
4th row	서울특별시 광진구 구의동 593번지 19호 ,22
5th row	서울특별시 광진구 화양동 226번지

Value	Count	Frequency (%)
서울특별시	226	18.7%
광진구	226	18.7%
자양동	58	4.8%
구의동	50	4.1%
화양동	36	3.0%
중곡동	33	2.7%
1층	31	2.6%
군자동	25	2.1%
1호	20	1.7%
2호	19	1.6%
Other values (243)	482	40.0%

Most occurring characters

Value	Count	Frequency (%)
	1585	26.2%
구	276	4.6%
1	248	4.1%
광	245	4.0%
지	236	3.9%
시	228	3.8%
진	227	3.8%
동	227	3.8%
서	226	3.7%
울	226	3.7%
Other values (96)	2327	38.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	3364	55.6%
Space Separator	1585	26.2%
Decimal Number	1048	17.3%
Other Punctuation	15	0.2%
Close Punctuation	14	0.2%
Open Punctuation	14	0.2%
Dash Punctuation	7	0.1%
Uppercase Letter	4	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
구	276	8.2%
광	245	7.3%
지	236	7.0%
시	228	6.8%
진	227	6.7%
동	227	6.7%
서	226	6.7%
울	226	6.7%
특	226	6.7%
별	226	6.7%
Other values (77)	1021	30.4%

Decimal Number

Value	Count	Frequency (%)
1	248	23.7%
2	166	15.8%
3	103	9.8%
5	102	9.7%
4	95	9.1%
6	76	7.3%
0	73	7.0%
9	68	6.5%
7	68	6.5%
8	49	4.7%

Other Punctuation

Value	Count	Frequency (%)
,	13	86.7%
.	1	6.7%
/	1	6.7%

Uppercase Letter

Value	Count	Frequency (%)
B	3	75.0%
D	1	25.0%

Space Separator

Value	Count	Frequency (%)
	1585	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	14	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	14	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	3364	55.6%
Common	2683	44.3%
Latin	4	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
구	276	8.2%
광	245	7.3%
지	236	7.0%
시	228	6.8%
진	227	6.7%
동	227	6.7%
서	226	6.7%
울	226	6.7%
특	226	6.7%
별	226	6.7%
Other values (77)	1021	30.4%

Common

Value	Count	Frequency (%)
	1585	59.1%
1	248	9.2%
2	166	6.2%
3	103	3.8%
5	102	3.8%
4	95	3.5%
6	76	2.8%
0	73	2.7%
9	68	2.5%
7	68	2.5%
Other values (7)	99	3.7%

Latin

Value	Count	Frequency (%)
B	3	75.0%
D	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	3364	55.6%
ASCII	2687	44.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1585	59.0%
1	248	9.2%
2	166	6.2%
3	103	3.8%
5	102	3.8%
4	95	3.5%
6	76	2.8%
0	73	2.7%
9	68	2.5%
7	68	2.5%
Other values (9)	103	3.8%

Hangul

Value	Count	Frequency (%)
구	276	8.2%
광	245	7.3%
지	236	7.0%
시	228	6.8%
진	227	6.7%
동	227	6.7%
서	226	6.7%
울	226	6.7%
특	226	6.7%
별	226	6.7%
Other values (77)	1021	30.4%

허가(신고)번호
Text

Distinct	203
Distinct (%)	89.8%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	4972
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	182 ?
Unique (%)	80.5%

Sample

1st row	3040000-101-2016-00001
2nd row	3040000-101-2002-00501
3rd row	3040000-101-2007-00301
4th row	3040000-101-1998-02593
5th row	3040000-101-2005-00153

Value	Count	Frequency (%)
3040000-101-2004-00099	3	1.3%
3040000-101-1996-01769	3	1.3%
3040000-101-1995-05250	2	0.9%
3040000-101-1992-00892	2	0.9%
3040000-101-2004-00411	2	0.9%
3040000-101-2004-00067	2	0.9%
3040000-101-2005-00281	2	0.9%
3040000-101-2008-00251	2	0.9%
3040000-101-1991-01236	2	0.9%
3040000-101-1986-01090	2	0.9%
Other values (193)	204	90.3%

Most occurring characters

Value	Count	Frequency (%)
0	2048	41.2%
1	729	14.7%
-	678	13.6%
3	324	6.5%
4	309	6.2%
9	261	5.2%
2	241	4.8%
8	109	2.2%
6	99	2.0%
5	94	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4294	86.4%
Dash Punctuation	678	13.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2048	47.7%
1	729	17.0%
3	324	7.5%
4	309	7.2%
9	261	6.1%
2	241	5.6%
8	109	2.5%
6	99	2.3%
5	94	2.2%
7	80	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4972	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2048	41.2%
1	729	14.7%
-	678	13.6%
3	324	6.5%
4	309	6.2%
9	261	5.2%
2	241	4.8%
8	109	2.2%
6	99	2.0%
5	94	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4972	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2048	41.2%
1	729	14.7%
-	678	13.6%
3	324	6.5%
4	309	6.2%
9	261	5.2%
2	241	4.8%
8	109	2.2%
6	99	2.0%
5	94	1.9%

업태명
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

한식	137
중국식	30
일식	15
식육(숯불구이)	14
분식	10
Other values (7)	20

Length

Max length	15
Median length	2
Mean length	2.7035398
Min length	2

Unique

Unique	4 ?
Unique (%)	1.8%

Sample

1st row	한식
2nd row	한식
3rd row	한식
4th row	중국식
5th row	한식

Common Values

Value	Count	Frequency (%)
한식	137	60.6%
중국식	30	13.3%
일식	15	6.6%
식육(숯불구이)	14	6.2%
분식	10	4.4%
호프/통닭	8	3.5%
기타	5	2.2%
경양식	3	1.3%
김밥(도시락)	1	0.4%
까페	1	0.4%
Other values (2)	2	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
한식	137	60.6%
중국식	30	13.3%
일식	15	6.6%
식육(숯불구이	14	6.2%
분식	10	4.4%
호프/통닭	8	3.5%
기타	5	2.2%
경양식	3	1.3%
김밥(도시락	1	0.4%
까페	1	0.4%
Other values (2)	2	0.9%

주된음식
Text

MISSING

Distinct	122
Distinct (%)	57.8%
Missing	15
Missing (%)	6.6%
Memory size	1.9 KiB

Length

Max length	13
Median length	11
Mean length	3.4881517
Min length	1

Characters and Unicode

Total characters	736
Distinct characters	149
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

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

Unique

Unique	90 ?
Unique (%)	42.7%

Sample

1st row	추어탕
2nd row	곱창
3rd row	갈비찜
4th row	자장면
5th row	버섯전골

Value	Count	Frequency (%)
갈비	8	3.6%
삼겹살	8	3.6%
돼지갈비	8	3.6%
양꼬치	8	3.6%
자장면	7	3.2%
추어탕	7	3.2%
냉면	6	2.7%
생선회	5	2.3%
부대찌개	5	2.3%
칼국수	5	2.3%
Other values (111)	154	69.7%

Most occurring characters

Value	Count	Frequency (%)
탕	35	4.8%
비	32	4.3%
갈	30	4.1%
지	17	2.3%
면	16	2.2%
치	16	2.2%
국	16	2.2%
삼	15	2.0%
자	14	1.9%
수	13	1.8%
Other values (139)	532	72.3%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	714	97.0%
Other Punctuation	10	1.4%
Space Separator	10	1.4%
Decimal Number	2	0.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
탕	35	4.9%
비	32	4.5%
갈	30	4.2%
지	17	2.4%
면	16	2.2%
치	16	2.2%
국	16	2.2%
삼	15	2.1%
자	14	2.0%
수	13	1.8%
Other values (136)	510	71.4%

Other Punctuation

Value	Count	Frequency (%)
,	10	100.0%

Space Separator

Value	Count	Frequency (%)
	10	100.0%

Decimal Number

Value	Count	Frequency (%)
0	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	714	97.0%
Common	22	3.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
탕	35	4.9%
비	32	4.5%
갈	30	4.2%
지	17	2.4%
면	16	2.2%
치	16	2.2%
국	16	2.2%
삼	15	2.1%
자	14	2.0%
수	13	1.8%
Other values (136)	510	71.4%

Common

Value	Count	Frequency (%)
,	10	45.5%
	10	45.5%
0	2	9.1%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	714	97.0%
ASCII	22	3.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
탕	35	4.9%
비	32	4.5%
갈	30	4.2%
지	17	2.4%
면	16	2.2%
치	16	2.2%
국	16	2.2%
삼	15	2.1%
자	14	2.0%
수	13	1.8%
Other values (136)	510	71.4%

ASCII

Value	Count	Frequency (%)
,	10	45.5%
	10	45.5%
0	2	9.1%

영업장면적(㎡)
Real number (ℝ)

HIGH CORRELATION

Distinct	200
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133.13403

Minimum	17.88
Maximum	605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 KiB

Quantile statistics

Minimum	17.88
5-th percentile	49.395
Q1	75.26
median	104.435
Q3	162.25
95-th percentile	337.5825
Maximum	605
Range	587.12
Interquartile range (IQR)	86.99

Descriptive statistics

Standard deviation	93.885255
Coefficient of variation (CV)	0.70519353
Kurtosis	6.7536636
Mean	133.13403
Median Absolute Deviation (MAD)	36.655
Skewness	2.30529
Sum	30088.29
Variance	8814.4411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
209.0	3	1.3%
156.02	3	1.3%
110.0	3	1.3%
64.48	2	0.9%
336.72	2	0.9%
238.8	2	0.9%
143.28	2	0.9%
82.82	2	0.9%
140.24	2	0.9%
420.99	2	0.9%
Other values (190)	203	89.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17.88	1	0.4%
29.25	1	0.4%
31.0	1	0.4%
33.6	1	0.4%
37.5	1	0.4%
37.91	1	0.4%
39.6	1	0.4%
41.22	1	0.4%
44.2	1	0.4%
45.2	1	0.4%

Value	Count	Frequency (%)
605.0	1	0.4%
600.97	1	0.4%
524.88	1	0.4%
420.99	2	0.9%
400.52	1	0.4%
386.25	1	0.4%
362.08	1	0.4%
352.11	1	0.4%
343.62	1	0.4%
337.87	2	0.9%

행정동명
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

화양동	36
구의제3동	29
군자동	25
자양제4동	23
광장동	18
Other values (10)	95

Length

Max length	5
Median length	5
Mean length	4.2212389
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	중곡제1동
2nd row	자양제1동
3rd row	자양제2동
4th row	구의제3동
5th row	화양동

Common Values

Value	Count	Frequency (%)
화양동	36	15.9%
구의제3동	29	12.8%
군자동	25	11.1%
자양제4동	23	10.2%
광장동	18	8.0%
자양제1동	17	7.5%
구의제1동	15	6.6%
중곡제1동	10	4.4%
자양제3동	10	4.4%
중곡제2동	10	4.4%
Other values (5)	33	14.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
화양동	36	15.9%
구의제3동	29	12.8%
군자동	25	11.1%
자양제4동	23	10.2%
광장동	18	8.0%
자양제1동	17	7.5%
구의제1동	15	6.6%
중곡제1동	10	4.4%
자양제3동	10	4.4%
중곡제2동	10	4.4%
Other values (5)	33	14.6%

급수시설구분
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	1.9 KiB

상수도전용	174
<NA>	52

Length

Max length	5
Median length	5
Mean length	4.7699115
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
상수도전용	174	77.0%
<NA>	52	23.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
상수도전용	174	77.0%
na	52	23.0%

Heatmap
Table

	지정년도	지정번호	신청일자	지정일자	취소일자	업태명	영업장면적(㎡)	행정동명
지정년도	1.000	0.814	0.967	1.000	0.424	0.300	0.000	0.355
지정번호	0.814	1.000	0.795	0.814	0.621	0.313	0.430	0.349
신청일자	0.967	0.795	1.000	0.967	0.664	0.284	0.000	0.485
지정일자	1.000	0.814	0.967	1.000	0.424	0.300	0.000	0.355
취소일자	0.424	0.621	0.664	0.424	1.000	0.000	0.000	0.478
업태명	0.300	0.313	0.284	0.300	0.000	1.000	0.134	0.501
영업장면적(㎡)	0.000	0.430	0.000	0.000	0.000	0.134	1.000	0.183
행정동명	0.355	0.349	0.485	0.355	0.478	0.501	0.183	1.000

Heatmap
Table

	급수시설구분	불가일자	행정동명	업태명
급수시설구분	1.000	1.000	1.000	1.000
불가일자	1.000	1.000	1.000	1.000
행정동명	1.000	1.000	1.000	0.206
업태명	1.000	1.000	0.206	1.000

Heatmap
Table

	지정년도	지정번호	신청일자	지정일자	취소일자	영업장면적(㎡)	불가일자	업태명	행정동명	급수시설구분
지정년도	1.000	-0.305	0.998	0.999	0.489	-0.064	0.000	0.131	0.124	1.000
지정번호	-0.305	1.000	-0.300	-0.303	0.102	0.014	0.000	0.144	0.164	1.000
신청일자	0.998	-0.300	1.000	0.999	0.525	-0.071	1.000	0.112	0.191	1.000
지정일자	0.999	-0.303	0.999	1.000	0.496	-0.065	0.000	0.131	0.124	1.000
취소일자	0.489	0.102	0.525	0.496	1.000	-0.114	0.000	0.000	0.238	1.000
영업장면적(㎡)	-0.064	0.014	-0.071	-0.065	-0.114	1.000	1.000	0.055	0.072	1.000
불가일자	0.000	0.000	1.000	0.000	0.000	1.000	1.000	1.000	1.000	1.000
업태명	0.131	0.144	0.112	0.131	0.000	0.055	1.000	1.000	0.206	1.000
행정동명	0.124	0.164	0.191	0.124	0.238	0.072	1.000	0.206	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

	시군구코드	지정년도	지정번호	신청일자	지정일자	취소일자	불가일자	업소명	소재지도로명	소재지지번	허가(신고)번호	업태명	주된음식	영업장면적(㎡)	행정동명	급수시설구분
0	3040000	2016	6	20161021	20161021	<NA>	<NA>	명가네남원추어탕	서울특별시 광진구 능동로37길 11, 1층 (중곡동)	서울특별시 광진구 중곡동 649번지 13호 1층	3040000-101-2016-00001	한식	추어탕	170.0	중곡제1동	<NA>
1	3040000	2001	5252	20050705	20010517	20071130	<NA>	할매시골청국장	서울특별시 광진구 아차산로 327, 1층 (자양동)	서울특별시 광진구 자양동 774번지 28호 1층	3040000-101-2002-00501	한식	곱창	41.22	자양제1동	상수도전용
2	3040000	2008	5560	20080430	20080620	20101130	<NA>	장원닭한마리	서울특별시 광진구 뚝섬로52길 8, (자양동,(101호))	서울특별시 광진구 자양동 606번지 28호 (101호)	3040000-101-2007-00301	한식	갈비찜	59.84	자양제2동	상수도전용
3	3040000	2002	5157	20021010	20021010	20080630	<NA>	중국성	서울특별시 광진구 뚝섬로 741, (구의동,,22)	서울특별시 광진구 구의동 593번지 19호 ,22	3040000-101-1998-02593	중국식	자장면	148.6	구의제3동	상수도전용
4	3040000	<NA>	<NA>	20081103	<NA>	20181023	<NA>	본가왕뼈감자탕 어린이대공원역점	서울특별시 광진구 능동로19길 8, (화양동)	서울특별시 광진구 화양동 226번지	3040000-101-2005-00153	한식	<NA>	93.2	화양동	상수도전용
5	3040000	2001	5268	20011218	20011218	20080930	<NA>	늘봄참숯갈비	서울특별시 광진구 자양번영로 20, (자양동)	서울특별시 광진구 자양동 600번지	3040000-101-1995-00267	식육(숯불구이)	버섯전골	101.45	자양제2동	상수도전용
6	3040000	<NA>	<NA>	20080430	<NA>	<NA>	20080620	옛집	서울특별시 광진구 아차산로76가길 18, (광장동)	서울특별시 광진구 광장동 326번지 9호	3040000-101-2006-00237	한식	<NA>	69.95	광장동	상수도전용
7	3040000	2008	5568	20081024	20081201	<NA>	<NA>	부림정	서울특별시 광진구 뚝섬로 476-7, (자양동)	서울특별시 광진구 자양동 52번지 2호	3040000-101-1979-00456	한식	갈비	112.1	자양제4동	상수도전용
8	3040000	<NA>	<NA>	20080430	<NA>	<NA>	20080620	본할머니보쌈	서울특별시 광진구 면목로 160, (중곡동)	서울특별시 광진구 중곡동 171번지 1호	3040000-101-2006-00090	한식	<NA>	80.1	중곡제3동	상수도전용
9	3040000	<NA>	<NA>	20161021	<NA>	20180911	<NA>	망향비빔국수 화양점	서울특별시 광진구 광나루로 352, 1층 (화양동)	서울특별시 광진구 화양동 21번지 1호 1층	3040000-101-2016-00219	중국식	<NA>	99.0	화양동	<NA>

	시군구코드	지정년도	지정번호	신청일자	지정일자	취소일자	불가일자	업소명	소재지도로명	소재지지번	허가(신고)번호	업태명	주된음식	영업장면적(㎡)	행정동명	급수시설구분
216	3040000	2009	5591	20090910	20091105	<NA>	<NA>	광장동 가온	서울특별시 광진구 아차산로78길 75, (광장동, 현대골든텔 106호)	서울특별시 광진구 광장동 102번지	3040000-101-2008-00119	한식	곰국수	237.7	광장동	상수도전용
217	3040000	2006	5473	20060404	20060510	20160225	<NA>	조마루뼈다귀감자탕	서울특별시 광진구 아차산로 208, (자양동)	서울특별시 광진구 자양동 8번지 3호	3040000-101-2005-00324	한식	감자탕	127.07	자양제4동	상수도전용
218	3040000	2016	9	20161021	20161021	20221031	<NA>	매운향솥	서울특별시 광진구 동일로18길 61, (자양동)	서울특별시 광진구 자양동 9번지 33호	3040000-101-2007-00304	중국식	샤브샤브	60.3	자양제4동	상수도전용
219	3040000	2015	12	20151013	20151013	<NA>	<NA>	연길왕꼬치	서울특별시 광진구 동일로18길 86, (자양동)	서울특별시 광진구 자양동 4번지 6호	3040000-101-2014-00293	중국식	양꼬치, 탕수육	195.77	자양제4동	<NA>
220	3040000	2017	9	20170915	20171018	<NA>	<NA>	정성한줄	서울특별시 광진구 아차산로 537-17, 1층 17호 (광장동)	서울특별시 광진구 광장동 582번지 1층-17	3040000-101-2016-00313	한식	김밥	45.2	광장동	<NA>
221	3040000	2017	7	20170915	20171018	<NA>	<NA>	송쉐프구의점	서울특별시 광진구 아차산로 355, 타워더모스트광진아크로텔 2층 208호 (자양동)	서울특별시 광진구 자양동 779번지 타워더모스트광진아크로텔	3040000-101-2015-00110	중국식	짜장면	193.37	자양제1동	<NA>
222	3040000	2020	4	20200901	20201111	<NA>	<NA>	고기싸롱중곡점	서울특별시 광진구 면목로 178, 1층 (중곡동)	서울특별시 광진구 중곡동 198번지 11호 1층	3040000-101-2019-00227	한식	갈비	168.61	중곡제3동	<NA>
223	3040000	2020	1	20200901	20201111	<NA>	<NA>	한촌설렁탕 군자점	서울특별시 광진구 능동로 255, 1층 (군자동)	서울특별시 광진구 군자동 242번지	3040000-101-2019-00289	한식	설렁탕	111.7	군자동	<NA>
224	3040000	2003	5367	20031203	20031203	20070629	<NA>	베트남쌀국수 미스사이공 건대점	서울특별시 광진구 능동로11길 8-13, 지1층 (화양동)	서울특별시 광진구 화양동 5번지 108호	3040000-101-1999-08431	분식	부대찌개	55.04	화양동	상수도전용
225	3040000	2004	5397	20021230	20040923	20080620	<NA>	기와집	서울특별시 광진구 면목로 32, (군자동)	서울특별시 광진구 군자동 470번지 1호	3040000-101-1997-01982	한식	보쌈정식	75.86	군자동	상수도전용

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Decimal Number

Space Separator

Open Punctuation

Close Punctuation

Other Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Han

Most occurring blocks

Most frequent character per block

Hangul

ASCII

CJK

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Uppercase Letter

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Uppercase Letter

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks