gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	252
Missing cells	23
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	33.4 KiB
Average record size in memory	135.5 B

Variable types

Numeric	7
Text	4
DateTime	1
Categorical	4

Dataset

Description	2020-12-22
Author	지방행정인허가공개데이터
URL	https://bigdata.busan.go.kr/data/bigDataDetailView.do?menuCode=M00000000007&hdfs_file_sn=20201222133205169000

Alerts

`last_load_dttm` has constant value ""	Constant
`reference_date` is highly overall correlated with `skey` and 3 other fields	High correlation
`gugun` is highly overall correlated with `skey` and 4 other fields	High correlation
`skey` is highly overall correlated with `gugun` and 1 other fields	High correlation
`num_of_people` is highly overall correlated with `present_num_of_pp`	High correlation
`present_num_of_pp` is highly overall correlated with `num_of_people`	High correlation
`lat` is highly overall correlated with `gugun`	High correlation
`lng` is highly overall correlated with `gugun` and 1 other fields	High correlation
`instt_code` is highly overall correlated with `gugun` and 1 other fields	High correlation
`type_of_facility` is highly imbalanced (60.9%)	Imbalance
`present_num_of_pp` has 3 (1.2%) missing values	Missing
`lat` has 4 (1.6%) missing values	Missing
`lng` has 4 (1.6%) missing values	Missing
`skey` has unique values	Unique

Reproduction

Analysis started	2024-04-19 06:45:27.118290
Analysis finished	2024-04-19 06:45:33.268300
Duration	6.15 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

skey
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	252
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1741.7659

Minimum	1556
Maximum	1921
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	1556
5-th percentile	1568.55
Q1	1618.75
median	1741.5
Q3	1857.25
95-th percentile	1908.45
Maximum	1921
Range	365
Interquartile range (IQR)	238.5

Descriptive statistics

Standard deviation	119.38249
Coefficient of variation (CV)	0.068541069
Kurtosis	-1.448781
Mean	1741.7659
Median Absolute Deviation (MAD)	119.5
Skewness	-0.077593477
Sum	438925
Variance	14252.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1717	1	0.4%
1588	1	0.4%
1633	1	0.4%
1634	1	0.4%
1899	1	0.4%
1900	1	0.4%
1901	1	0.4%
1902	1	0.4%
1903	1	0.4%
1904	1	0.4%
Other values (242)	242	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1556	1	0.4%
1557	1	0.4%
1558	1	0.4%
1559	1	0.4%
1560	1	0.4%
1561	1	0.4%
1562	1	0.4%
1563	1	0.4%
1564	1	0.4%
1565	1	0.4%

Value	Count	Frequency (%)
1921	1	0.4%
1920	1	0.4%
1919	1	0.4%
1918	1	0.4%
1917	1	0.4%
1916	1	0.4%
1915	1	0.4%
1914	1	0.4%
1913	1	0.4%
1912	1	0.4%

facility_nm
Text

Distinct	243
Distinct (%)	97.2%
Missing	2
Missing (%)	0.8%
Memory size	2.1 KiB

Length

Max length	17
Median length	14
Mean length	7.332
Min length	2

Characters and Unicode

Total characters	1833
Distinct characters	248
Distinct categories	6 ?
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	236 ?
Unique (%)	94.4%

Sample

1st row	샘물지역아동센터
2nd row	주례지역아동센터
3rd row	학장지역아동센터
4th row	희망지역아동센터
5th row	아가페지역아동센터

Value	Count	Frequency (%)
지역아동센터	14	5.1%
희망지역아동센터	2	0.7%
안	2	0.7%
꿈나무지역아동센터	2	0.7%
사랑지역아동센터	2	0.7%
샘물지역아동센터	2	0.7%
다원	2	0.7%
꿈샘지역아동센터	2	0.7%
낙동지역아동센터	2	0.7%
사랑의샘	1	0.4%
Other values (242)	242	88.6%

Most occurring characters

Value	Count	Frequency (%)
동	171	9.3%
아	160	8.7%
터	160	8.7%
지	155	8.5%
센	153	8.3%
역	148	8.1%
	25	1.4%
리	21	1.1%
홈	16	0.9%
원	16	0.9%
Other values (238)	808	44.1%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1791	97.7%
Space Separator	25	1.4%
Decimal Number	8	0.4%
Uppercase Letter	5	0.3%
Open Punctuation	2	0.1%
Close Punctuation	2	0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	171	9.5%
아	160	8.9%
터	160	8.9%
지	155	8.7%
센	153	8.5%
역	148	8.3%
리	21	1.2%
홈	16	0.9%
원	16	0.9%
꿈	15	0.8%
Other values (229)	776	43.3%

Decimal Number

Value	Count	Frequency (%)
1	4	50.0%
8	2	25.0%
3	2	25.0%

Uppercase Letter

Value	Count	Frequency (%)
L	2	40.0%
C	2	40.0%
H	1	20.0%

Space Separator

Value	Count	Frequency (%)
	25	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	1791	97.7%
Common	37	2.0%
Latin	5	0.3%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	171	9.5%
아	160	8.9%
터	160	8.9%
지	155	8.7%
센	153	8.5%
역	148	8.3%
리	21	1.2%
홈	16	0.9%
원	16	0.9%
꿈	15	0.8%
Other values (229)	776	43.3%

Common

Value	Count	Frequency (%)
	25	67.6%
1	4	10.8%
(	2	5.4%
)	2	5.4%
8	2	5.4%
3	2	5.4%

Latin

Value	Count	Frequency (%)
L	2	40.0%
C	2	40.0%
H	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	1791	97.7%
ASCII	42	2.3%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
동	171	9.5%
아	160	8.9%
터	160	8.9%
지	155	8.7%
센	153	8.5%
역	148	8.3%
리	21	1.2%
홈	16	0.9%
원	16	0.9%
꿈	15	0.8%
Other values (229)	776	43.3%

ASCII

Value	Count	Frequency (%)
	25	59.5%
1	4	9.5%
(	2	4.8%
)	2	4.8%
8	2	4.8%
3	2	4.8%
L	2	4.8%
C	2	4.8%
H	1	2.4%

facility_manager
Text

Distinct	242
Distinct (%)	96.8%
Missing	2
Missing (%)	0.8%
Memory size	2.1 KiB

Length

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

Characters and Unicode

Total characters	750
Distinct characters	128
Distinct categories	1 ?
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	234 ?
Unique (%)	93.6%

Sample

1st row	박종칠
2nd row	유재용
3rd row	최인금
4th row	김진아
5th row	진영은

Value	Count	Frequency (%)
나영찬	2	0.8%
정혜인	2	0.8%
김미연	2	0.8%
이은희	2	0.8%
박명숙	2	0.8%
김경희	2	0.8%
이정미	2	0.8%
김현희	2	0.8%
김분이	1	0.4%
황기석	1	0.4%
Other values (232)	232	92.8%

Most occurring characters

Value	Count	Frequency (%)
김	64	8.5%
이	40	5.3%
희	36	4.8%
미	34	4.5%
정	31	4.1%
숙	27	3.6%
영	26	3.5%
경	25	3.3%
박	20	2.7%
진	16	2.1%
Other values (118)	431	57.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	750	100.0%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
김	64	8.5%
이	40	5.3%
희	36	4.8%
미	34	4.5%
정	31	4.1%
숙	27	3.6%
영	26	3.5%
경	25	3.3%
박	20	2.7%
진	16	2.1%
Other values (118)	431	57.5%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	750	100.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
김	64	8.5%
이	40	5.3%
희	36	4.8%
미	34	4.5%
정	31	4.1%
숙	27	3.6%
영	26	3.5%
경	25	3.3%
박	20	2.7%
진	16	2.1%
Other values (118)	431	57.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	750	100.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
김	64	8.5%
이	40	5.3%
희	36	4.8%
미	34	4.5%
정	31	4.1%
숙	27	3.6%
영	26	3.5%
경	25	3.3%
박	20	2.7%
진	16	2.1%
Other values (118)	431	57.5%

addr
Text

Distinct	246
Distinct (%)	98.4%
Missing	2
Missing (%)	0.8%
Memory size	2.1 KiB

Length

Max length	48
Median length	39
Mean length	27.792
Min length	15

Characters and Unicode

Total characters	6948
Distinct characters	239
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	242 ?
Unique (%)	96.8%

Sample

1st row	부산광역시 사상구 엄궁북로 4번길 32-10 (엄궁동)
2nd row	부산광역시 사상구 가야대로 366번길 63-6 (주례동)
3rd row	부산광역시 사상구 학감대로 49번길 28-70 (학장동) 학장종합사회복지관 3층
4th row	부산광역시 사상구 사상로 275 (덕포동)
5th row	부산광역시 사상구 새벽시장로63번길 42(감전동, 2층)

Value	Count	Frequency (%)
부산광역시	204	16.4%
해운대구	26	2.1%
남구	24	1.9%
부산진구	24	1.9%
사상구	24	1.9%
동래구	23	1.8%
사하구	21	1.7%
북구	21	1.7%
동구	20	1.6%
연제구	13	1.0%
Other values (620)	846	67.9%

Most occurring characters

Value	Count	Frequency (%)
	1009	14.5%
동	321	4.6%
구	257	3.7%
산	253	3.6%
로	246	3.5%
1	246	3.5%
부	239	3.4%
)	230	3.3%
(	230	3.3%
시	223	3.2%
Other values (229)	3694	53.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	4097	59.0%
Decimal Number	1217	17.5%
Space Separator	1009	14.5%
Close Punctuation	230	3.3%
Open Punctuation	230	3.3%
Other Punctuation	96	1.4%
Dash Punctuation	63	0.9%
Uppercase Letter	4	0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
동	321	7.8%
구	257	6.3%
산	253	6.2%
로	246	6.0%
부	239	5.8%
시	223	5.4%
광	212	5.2%
역	205	5.0%
길	150	3.7%
번	145	3.5%
Other values (209)	1846	45.1%

Decimal Number

Value	Count	Frequency (%)
1	246	20.2%
2	184	15.1%
3	160	13.1%
0	118	9.7%
4	107	8.8%
6	102	8.4%
5	89	7.3%
7	80	6.6%
9	67	5.5%
8	64	5.3%

Other Punctuation

Value	Count	Frequency (%)
,	93	96.9%
.	2	2.1%
@	1	1.0%

Uppercase Letter

Value	Count	Frequency (%)
A	3	75.0%
F	1	25.0%

Space Separator

Value	Count	Frequency (%)
	1009	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	230	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	230	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	63	100.0%

Math Symbol

Value	Count	Frequency (%)
~	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	4097	59.0%
Common	2847	41.0%
Latin	4	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
동	321	7.8%
구	257	6.3%
산	253	6.2%
로	246	6.0%
부	239	5.8%
시	223	5.4%
광	212	5.2%
역	205	5.0%
길	150	3.7%
번	145	3.5%
Other values (209)	1846	45.1%

Common

Value	Count	Frequency (%)
	1009	35.4%
1	246	8.6%
)	230	8.1%
(	230	8.1%
2	184	6.5%
3	160	5.6%
0	118	4.1%
4	107	3.8%
6	102	3.6%
,	93	3.3%
Other values (8)	368	12.9%

Latin

Value	Count	Frequency (%)
A	3	75.0%
F	1	25.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	4097	59.0%
ASCII	2851	41.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1009	35.4%
1	246	8.6%
)	230	8.1%
(	230	8.1%
2	184	6.5%
3	160	5.6%
0	118	4.1%
4	107	3.8%
6	102	3.6%
,	93	3.3%
Other values (10)	372	13.0%

Hangul

Value	Count	Frequency (%)
동	321	7.8%
구	257	6.3%
산	253	6.2%
로	246	6.0%
부	239	5.8%
시	223	5.4%
광	212	5.2%
역	205	5.0%
길	150	3.7%
번	145	3.5%
Other values (209)	1846	45.1%

installation_date
Date

Distinct	230
Distinct (%)	92.0%
Missing	2
Missing (%)	0.8%
Memory size	2.1 KiB

Minimum	1908-01-04 00:00:00
Maximum	2020-08-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

num_of_people
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	16.0%
Missing	2
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	27.176

Minimum	5
Maximum	130
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	5
5-th percentile	7
Q1	19
median	25
Q3	29
95-th percentile	50.55
Maximum	130
Range	125
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	16.338077
Coefficient of variation (CV)	0.60119506
Kurtosis	12.020469
Mean	27.176
Median Absolute Deviation (MAD)	6
Skewness	2.7900998
Sum	6794
Variance	266.93276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
29	65	25.8%
19	58	23.0%
25	25	9.9%
7	25	9.9%
35	14	5.6%
24	5	2.0%
39	5	2.0%
23	4	1.6%
33	4	1.6%
28	4	1.6%
Other values (30)	41	16.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	3	1.2%
7	25	9.9%
9	1	0.4%
10	1	0.4%
17	1	0.4%
19	58	23.0%
20	3	1.2%
21	1	0.4%
23	4	1.6%
24	5	2.0%

Value	Count	Frequency (%)
130	1	0.4%
110	1	0.4%
105	1	0.4%
96	1	0.4%
80	2	0.8%
77	1	0.4%
75	1	0.4%
72	1	0.4%
66	1	0.4%
63	1	0.4%

present_num_of_pp
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	44
Distinct (%)	17.7%
Missing	3
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	23.590361

Minimum	1
Maximum	106
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	18
median	24
Q3	29
95-th percentile	37
Maximum	106
Range	105
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	12.513576
Coefficient of variation (CV)	0.53045291
Kurtosis	11.055493
Mean	23.590361
Median Absolute Deviation (MAD)	5
Skewness	2.1433119
Sum	5874
Variance	156.58958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
19	27	10.7%
29	24	9.5%
25	18	7.1%
18	14	5.6%
28	12	4.8%
26	11	4.4%
5	10	4.0%
23	10	4.0%
24	10	4.0%
7	9	3.6%
Other values (34)	104	41.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.4%
2	1	0.4%
3	4	1.6%
5	10	4.0%
6	5	2.0%
7	9	3.6%
8	1	0.4%
10	2	0.8%
13	1	0.4%
14	6	2.4%

Value	Count	Frequency (%)
106	1	0.4%
86	1	0.4%
79	1	0.4%
70	1	0.4%
62	1	0.4%
50	1	0.4%
49	1	0.4%
48	1	0.4%
46	1	0.4%
45	1	0.4%

num_of_worker
Real number (ℝ)

Distinct	20
Distinct (%)	8.0%
Missing	2
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	4.028

Minimum	1
Maximum	44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	2
Q3	3
95-th percentile	22.55
Maximum	44
Range	43
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	6.5952411
Coefficient of variation (CV)	1.6373488
Kurtosis	15.75891
Mean	4.028
Median Absolute Deviation (MAD)	0
Skewness	3.9834318
Sum	1007
Variance	43.497205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	164	65.1%
3	51	20.2%
4	9	3.6%
1	5	2.0%
25	3	1.2%
10	3	1.2%
23	2	0.8%
30	1	0.4%
27	1	0.4%
26	1	0.4%
Other values (10)	10	4.0%
(Missing)	2	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5	2.0%
2	164	65.1%
3	51	20.2%
4	9	3.6%
5	1	0.4%
7	1	0.4%
10	3	1.2%
11	1	0.4%
20	1	0.4%
22	1	0.4%

Value	Count	Frequency (%)
44	1	0.4%
40	1	0.4%
35	1	0.4%
34	1	0.4%
33	1	0.4%
30	1	0.4%
27	1	0.4%
26	1	0.4%
25	3	1.2%
23	2	0.8%

type_of_facility
Categorical

IMBALANCE

Distinct	10
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

지역아동센터	195
공동생활가정	23
아동양육시설	16
다함께돌봄센터	6
아동복지시설	5
Other values (5)	7

Length

Max length	11
Median length	6
Mean length	6.0674603
Min length	4

Unique

Unique	3 ?
Unique (%)	1.2%

Sample

1st row	지역아동센터
2nd row	지역아동센터
3rd row	지역아동센터
4th row	지역아동센터
5th row	지역아동센터

Common Values

Value	Count	Frequency (%)
지역아동센터	195	77.4%
공동생활가정	23	9.1%
아동양육시설	16	6.3%
다함께돌봄센터	6	2.4%
아동복지시설	5	2.0%
공동생활가정(생활)	2	0.8%
<NA>	2	0.8%
자립지원시설	1	0.4%
공동생활가정(그룹홈)	1	0.4%
학대피해아동쉼터	1	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
지역아동센터	195	77.4%
공동생활가정	23	9.1%
아동양육시설	16	6.3%
다함께돌봄센터	6	2.4%
아동복지시설	5	2.0%
공동생활가정(생활	2	0.8%
na	2	0.8%
자립지원시설	1	0.4%
공동생활가정(그룹홈	1	0.4%
학대피해아동쉼터	1	0.4%

tel
Text

Distinct	250
Distinct (%)	99.2%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

Length

Max length	13
Median length	12
Mean length	12.09127
Min length	12

Characters and Unicode

Total characters	3047
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	249 ?
Unique (%)	98.8%

Sample

1st row	051-322-0675
2nd row	070-7763-1649
3rd row	051-311-4014
4th row	051-304-5098
5th row	070-7543-4619

Value	Count	Frequency (%)
051-123-1234	3	1.2%
051-508-2923	1	0.4%
051-817-8547	1	0.4%
051-333-1621	1	0.4%
051-508-1133	1	0.4%
051-897-2633	1	0.4%
051-894-9991	1	0.4%
070-7546-4926	1	0.4%
051-816-9055	1	0.4%
051-529-6692	1	0.4%
Other values (240)	240	95.2%

Most occurring characters

Value	Count	Frequency (%)
-	504	16.5%
0	476	15.6%
5	423	13.9%
1	413	13.6%
2	209	6.9%
3	198	6.5%
6	192	6.3%
7	181	5.9%
4	164	5.4%
8	153	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2543	83.5%
Dash Punctuation	504	16.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	476	18.7%
5	423	16.6%
1	413	16.2%
2	209	8.2%
3	198	7.8%
6	192	7.6%
7	181	7.1%
4	164	6.4%
8	153	6.0%
9	134	5.3%

Dash Punctuation

Value	Count	Frequency (%)
-	504	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3047	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	504	16.5%
0	476	15.6%
5	423	13.9%
1	413	13.6%
2	209	6.9%
3	198	6.5%
6	192	6.3%
7	181	5.9%
4	164	5.4%
8	153	5.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3047	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	504	16.5%
0	476	15.6%
5	423	13.9%
1	413	13.6%
2	209	6.9%
3	198	6.5%
6	192	6.3%
7	181	5.9%
4	164	5.4%
8	153	5.0%

lat
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	242
Distinct (%)	97.6%
Missing	4
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	35.160901

Minimum	35.031229
Maximum	35.339603
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	35.031229
5-th percentile	35.07708
Q1	35.123086
median	35.162769
Q3	35.199472
95-th percentile	35.2459
Maximum	35.339603
Range	0.3083744
Interquartile range (IQR)	0.076385773

Descriptive statistics

Standard deviation	0.055698851
Coefficient of variation (CV)	0.0015841133
Kurtosis	0.33499554
Mean	35.160901
Median Absolute Deviation (MAD)	0.038756617
Skewness	0.34117133
Sum	8719.9035
Variance	0.003102362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.103758	2	0.8%
35.21359	2	0.8%
35.12308572674206	2	0.8%
35.0839222289	2	0.8%
35.1473429729	2	0.8%
35.210417	2	0.8%
35.20009	1	0.4%
35.2294405	1	0.4%
35.257562	1	0.4%
35.293395	1	0.4%
Other values (232)	232	92.1%
(Missing)	4	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35.031229	1	0.4%
35.042547	1	0.4%
35.049109	1	0.4%
35.053556	1	0.4%
35.055065	1	0.4%
35.059122	1	0.4%
35.060213	1	0.4%
35.061277	1	0.4%
35.065157	1	0.4%
35.066334	1	0.4%

Value	Count	Frequency (%)
35.3396034	1	0.4%
35.32552426	1	0.4%
35.32062941	1	0.4%
35.32004502	1	0.4%
35.31935363	1	0.4%
35.293395	1	0.4%
35.293337	1	0.4%
35.266354	1	0.4%
35.259886	1	0.4%
35.257562	1	0.4%

lng
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	242
Distinct (%)	97.6%
Missing	4
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	129.05756

Minimum	128.81438
Maximum	129.22567
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	128.81438
5-th percentile	128.97271
Q1	129.01362
median	129.05511
Q3	129.09635
95-th percentile	129.17124
Maximum	129.22567
Range	0.411286
Interquartile range (IQR)	0.082731929

Descriptive statistics

Standard deviation	0.06485995
Coefficient of variation (CV)	0.00050256608
Kurtosis	0.98910321
Mean	129.05756
Median Absolute Deviation (MAD)	0.04139186
Skewness	0.021082917
Sum	32006.274
Variance	0.0042068131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
128.980943	2	0.8%
129.06395	2	0.8%
129.09635114006093	2	0.8%
129.0122328501	2	0.8%
128.9983032999	2	0.8%
129.02707	2	0.8%
129.09743	1	0.4%
129.0762614	1	0.4%
129.090458	1	0.4%
129.100009	1	0.4%
Other values (232)	232	92.1%
(Missing)	4	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
128.814384	1	0.4%
128.830894	1	0.4%
128.878345	1	0.4%
128.902814	1	0.4%
128.956367	1	0.4%
128.959391	1	0.4%
128.960501	1	0.4%
128.964789	1	0.4%
128.967403	1	0.4%
128.970707	1	0.4%

Value	Count	Frequency (%)
129.22567	1	0.4%
129.22531135	1	0.4%
129.21741075	1	0.4%
129.21574004	1	0.4%
129.21492066	1	0.4%
129.21066199	1	0.4%
129.205707	1	0.4%
129.18861625	1	0.4%
129.18705373	1	0.4%
129.184258	1	0.4%

gugun
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

부산광역시 해운대구	26
부산광역시 사상구	24
부산광역시 부산진구	24
부산광역시 남구	24
부산광역시 동래구	23
Other values (12)	131

Length

Max length	10
Median length	9
Mean length	8.8531746
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	부산광역시 사상구
2nd row	부산광역시 사상구
3rd row	부산광역시 사상구
4th row	부산광역시 사상구
5th row	부산광역시 사상구

Common Values

Value	Count	Frequency (%)
부산광역시 해운대구	26	10.3%
부산광역시 사상구	24	9.5%
부산광역시 부산진구	24	9.5%
부산광역시 남구	24	9.5%
부산광역시 동래구	23	9.1%
부산광역시 북구	21	8.3%
부산광역시 사하구	21	8.3%
부산광역시 동구	20	7.9%
부산광역시 연제구	13	5.2%
부산광역시 영도구	12	4.8%
Other values (7)	44	17.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
부산광역시	250	49.8%
해운대구	26	5.2%
사상구	24	4.8%
부산진구	24	4.8%
남구	24	4.8%
동래구	23	4.6%
북구	21	4.2%
사하구	21	4.2%
동구	20	4.0%
연제구	13	2.6%
Other values (8)	56	11.2%

reference_date
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	2.1 KiB

2020-07-31	177
2020-08-27	26
2020-09-04	20
2020-08-21	13
2020-08-31	9
Other values (2)	7

Length

Max length	10
Median length	10
Mean length	9.952381
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-07-31
2nd row	2020-07-31
3rd row	2020-07-31
4th row	2020-07-31
5th row	2020-07-31

Common Values

Value	Count	Frequency (%)
2020-07-31	177	70.2%
2020-08-27	26	10.3%
2020-09-04	20	7.9%
2020-08-21	13	5.2%
2020-08-31	9	3.6%
2020-09-01	5	2.0%
<NA>	2	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2020-07-31	177	70.2%
2020-08-27	26	10.3%
2020-09-04	20	7.9%
2020-08-21	13	5.2%
2020-08-31	9	3.6%
2020-09-01	5	2.0%
na	2	0.8%

instt_code
Real number (ℝ)

HIGH CORRELATION

Distinct	16
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3324325.4

Minimum	3250000
Maximum	3400000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.3 KiB

Quantile statistics

Minimum	3250000
5-th percentile	3270000
Q1	3290000
median	3320000
Q3	3350000
95-th percentile	3390000
Maximum	3400000
Range	150000
Interquartile range (IQR)	60000

Descriptive statistics

Standard deviation	41099.69
Coefficient of variation (CV)	0.012363317
Kurtosis	-0.89502331
Mean	3324325.4
Median Absolute Deviation (MAD)	30000
Skewness	0.30119642
Sum	8.3773 × 10⁸
Variance	1.6891845 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
3310000	26	10.3%
3330000	26	10.3%
3390000	24	9.5%
3290000	24	9.5%
3300000	23	9.1%
3320000	21	8.3%
3340000	21	8.3%
3270000	20	7.9%
3370000	13	5.2%
3280000	12	4.8%
Other values (6)	42	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3250000	5	2.0%
3260000	7	2.8%
3270000	20	7.9%
3280000	12	4.8%
3290000	24	9.5%
3300000	23	9.1%
3310000	26	10.3%
3320000	21	8.3%
3330000	26	10.3%
3340000	21	8.3%

Value	Count	Frequency (%)
3400000	11	4.4%
3390000	24	9.5%
3380000	9	3.6%
3370000	13	5.2%
3360000	5	2.0%
3350000	5	2.0%
3340000	21	8.3%
3330000	26	10.3%
3320000	21	8.3%
3310000	26	10.3%

last_load_dttm
Categorical

CONSTANT

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

2020-12-22 13:38:23	252

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-12-22 13:38:23
2nd row	2020-12-22 13:38:23
3rd row	2020-12-22 13:38:23
4th row	2020-12-22 13:38:23
5th row	2020-12-22 13:38:23

Common Values

Value	Count	Frequency (%)
2020-12-22 13:38:23	252	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2020-12-22	252	50.0%
13:38:23	252	50.0%

Heatmap
Table

	skey	num_of_people	present_num_of_pp	num_of_worker	type_of_facility	lat	lng	gugun	reference_date	instt_code
skey	1.000	0.185	0.000	0.000	0.417	0.661	0.729	0.966	0.876	0.879
num_of_people	0.185	1.000	0.928	0.795	0.860	0.390	0.246	0.556	0.000	0.530
present_num_of_pp	0.000	0.928	1.000	0.821	0.682	0.396	0.320	0.432	0.000	0.557
num_of_worker	0.000	0.795	0.821	1.000	0.662	0.397	0.207	0.562	0.000	0.463
type_of_facility	0.417	0.860	0.682	0.662	1.000	0.211	0.629	0.573	0.448	0.458
lat	0.661	0.390	0.396	0.397	0.211	1.000	0.752	0.875	0.542	0.841
lng	0.729	0.246	0.320	0.207	0.629	0.752	1.000	0.900	0.818	0.880
gugun	0.966	0.556	0.432	0.562	0.573	0.875	0.900	1.000	1.000	1.000
reference_date	0.876	0.000	0.000	0.000	0.448	0.542	0.818	1.000	1.000	0.908
instt_code	0.879	0.530	0.557	0.463	0.458	0.841	0.880	1.000	0.908	1.000

Heatmap
Table

	type_of_facility	reference_date	gugun
type_of_facility	1.000	0.240	0.274
reference_date	0.240	1.000	0.979
gugun	0.274	0.979	1.000

Heatmap
Table

	skey	num_of_people	present_num_of_pp	num_of_worker	lat	lng	instt_code	type_of_facility	gugun	reference_date
skey	1.000	0.089	0.042	-0.009	0.083	0.194	0.111	0.143	0.846	0.665
num_of_people	0.089	1.000	0.886	0.290	-0.102	-0.041	-0.086	0.443	0.260	0.000
present_num_of_pp	0.042	0.886	1.000	0.213	-0.048	-0.053	-0.078	0.394	0.183	0.000
num_of_worker	-0.009	0.290	0.213	1.000	-0.112	-0.056	-0.026	0.400	0.226	0.000
lat	0.083	-0.102	-0.048	-0.112	1.000	0.454	0.319	0.096	0.586	0.319
lng	0.194	-0.041	-0.053	-0.056	0.454	1.000	0.018	0.341	0.642	0.617
instt_code	0.111	-0.086	-0.078	-0.026	0.319	0.018	1.000	0.218	0.987	0.768
type_of_facility	0.143	0.443	0.394	0.400	0.096	0.341	0.218	1.000	0.274	0.240
gugun	0.846	0.260	0.183	0.226	0.586	0.642	0.987	0.274	1.000	0.979
reference_date	0.665	0.000	0.000	0.000	0.319	0.617	0.768	0.240	0.979	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

	skey	facility_nm	facility_manager	addr	installation_date	num_of_people	present_num_of_pp	num_of_worker	type_of_facility	tel	lat	lng	gugun	reference_date	instt_code	last_load_dttm
0	1717	샘물지역아동센터	박종칠	부산광역시 사상구 엄궁북로 4번길 32-10 (엄궁동)	2005-12-07	23	21	2	지역아동센터	051-322-0675	35.127663	128.971123	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
1	1718	주례지역아동센터	유재용	부산광역시 사상구 가야대로 366번길 63-6 (주례동)	2011-06-24	19	17	2	지역아동센터	070-7763-1649	35.148144	129.013284	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
2	1719	학장지역아동센터	최인금	부산광역시 사상구 학감대로 49번길 28-70 (학장동) 학장종합사회복지관 3층	2005-03-07	25	24	2	지역아동센터	051-311-4014	35.138652	128.989744	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
3	1720	희망지역아동센터	김진아	부산광역시 사상구 사상로 275 (덕포동)	2015-01-08	19	18	2	지역아동센터	051-304-5098	35.169386	128.982244	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
4	1721	아가페지역아동센터	진영은	부산광역시 사상구 새벽시장로63번길 42(감전동, 2층)	2020.04.08	19	19	2	지역아동센터	070-7543-4619	35.156991	128.981484	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
5	1722	천사의집	최민애	부산광역시 사상구 엄궁북로 61, 401동 102호(엄궁동, 엄궁롯데캐슬아파트)	2002-03-26	7	6	3	공동생활가정	051-322-7442	35.128171	128.977322	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
6	1723	예그린공동생활가정	이은희	부산광역시 사상구 대동로 98, 105동 102호(학장동,학장반도보라타운)	2014-10-14	7	7	4	공동생활가정	051-321-0216	35.13729	128.979171	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
7	1724	에바다드림홈	황용점	부산광역시 사상구 동주로16번길 43(주례동)	2014-12-31	7	7	3	공동생활가정	051-322-9717	35.147343	128.998303	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
8	1725	에바다리더홈	조진선	부산광역시 사상구 동주로16번길 43(주례동)	2014-12-31	7	7	3	공동생활가정	051-322-9716	35.147343	128.998303	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23
9	1726	사상구 다함께돌봄센터	김남희	부산광역시 사상구 낙동대로776번길 37(엄궁동)	2019-03-07	30	25	2	다함께돌봄센터	051-316-2660	35.129088	128.973139	부산광역시 사상구	2020-07-31	3390000	2020-12-22 13:38:23

	skey	facility_nm	facility_manager	addr	installation_date	num_of_people	present_num_of_pp	num_of_worker	type_of_facility	tel	lat	lng	gugun	reference_date	instt_code	last_load_dttm
242	1845	엘림	김양자	부산광역시 동구 초량상로79번길 27-4 (초량동)	2004-10-01	32	32	3	지역아동센터	051-466-3880	35.119334	129.03682	부산광역시 동구	2020-09-04	3270000	2020-12-22 13:38:23
243	1846	미애원	이광열	부산광역시 동구 망양로 641 (수정동)	1957-12-26	41	15	10	아동양육시설	051-468-0293	35.126199	129.03651	부산광역시 동구	2020-09-04	3270000	2020-12-22 13:38:23
244	1847	랄랄라가족그룹홈	이승준	부산광역시 동구 망양로476번길 11-1 (초량동)	2009-06-18	7	3	3	공동생활가정	051-464-8271	35.11649	129.034532	부산광역시 동구	2020-09-04	3270000	2020-12-22 13:38:23
245	1888	행복지역아동센터	장준표	부산광역시 기장군 기장읍 차성동로122번길 8	2008-10-30	35	25	3	지역아동센터	051-721-4977	35.248418	129.217411	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
246	1889	교리지역아동센터	이진호	부산광역시 기장군 기장읍 차성로417번길 25, 2층	2010-04-23	35	35	3	지역아동센터	051-724-0907	35.256466	129.21574	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
247	1890	신정LCC지역아동센터	남일식	부산광역시 기장군 정관읍 용수로 10	2010-10-21	37	32	3	지역아동센터	051-727-0191	35.325524	129.179798	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
248	1891	이레지역아동센터	박이숙	부산광역시 기장군 정관읍 구연방곡로 10, 106동 103호 (정관 센트럴파크)	2010-11-15	19	36	2	지역아동센터	051-724-0079	35.320045	129.187054	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
249	1892	꿈나무지역아동센터	김창호	부산광역시 기장군 기장읍 대청로36번길 11-12	2008-09-01	29	19	2	지역아동센터	051-723-1213	35.236924	129.214921	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
250	1893	무양지역아동센터	김효진	부산광역시 기장군 기장읍 대변로 117-3, A동 202호 (삼화그린빌라)	2011-06-22	9	8	1	지역아동센터	051-723-0621	35.228013	129.225311	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23
251	1894	모전지역아동센터	윤미영	부산광역시 기장군 정관읍 정관1로 18, 105동 101호 (이지더원1차)	2016-09-28	19	19	2	지역아동센터	051-728-0399	35.339603	129.164009	부산광역시 기장군	2020-07-31	3400000	2020-12-22 13:38:23

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Most occurring scripts

Most frequent character per script

Hangul

Most occurring blocks

Most frequent character per block

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

Math 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)

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

Most frequent character per block

ASCII

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample