Overview

Dataset statistics

Number of variables7
Number of observations45
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory61.9 B

Variable types

Numeric3
Text3
DateTime1

Dataset

Description대구광역시_북구_지역아동센터 현황_20190828
Author대구광역시 북구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15031367&dataSetDetailId=150313672c941bd8569c6_201908291444&provdMethod=FILE

Alerts

데이터기준일자 has constant value ""Constant
위도 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 위도High correlation
연번 has unique valuesUnique
시설명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2023-12-10 20:01:48.416682
Analysis finished2023-12-10 20:01:50.891676
Duration2.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2023-12-11T05:01:51.051056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2023-12-11T05:01:51.299033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

시설명
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T05:01:51.691734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length2
Mean length2.8444444
Min length2

Characters and Unicode

Total characters128
Distinct characters93
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique45 ?
Unique (%)100.0%

Sample

1st row감나무골작은학교
2nd row구세군대구칠곡
3rd row구암
4th row그린
5th row글로리
ValueCountFrequency (%)
감나무골작은학교 1
 
2.2%
서변 1
 
2.2%
솔로몬 1
 
2.2%
아이프라임 1
 
2.2%
온누리 1
 
2.2%
요나 1
 
2.2%
이튼 1
 
2.2%
좋은친구 1
 
2.2%
청보리 1
 
2.2%
칠곡 1
 
2.2%
Other values (35) 35
77.8%
2023-12-11T05:01:52.297499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
구 5
 
3.9%
나 5
 
3.9%
무 4
 
3.1%
로 3
 
2.3%
곡 3
 
2.3%
칠 3
 
2.3%
대 3
 
2.3%
리 3
 
2.3%
복 3
 
2.3%
태 2
 
1.6%
Other values (83) 94
73.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 128
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 5
 
3.9%
나 5
 
3.9%
무 4
 
3.1%
로 3
 
2.3%
곡 3
 
2.3%
칠 3
 
2.3%
대 3
 
2.3%
리 3
 
2.3%
복 3
 
2.3%
태 2
 
1.6%
Other values (83) 94
73.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 128
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 5
 
3.9%
나 5
 
3.9%
무 4
 
3.1%
로 3
 
2.3%
곡 3
 
2.3%
칠 3
 
2.3%
대 3
 
2.3%
리 3
 
2.3%
복 3
 
2.3%
태 2
 
1.6%
Other values (83) 94
73.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 128
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
구 5
 
3.9%
나 5
 
3.9%
무 4
 
3.1%
로 3
 
2.3%
곡 3
 
2.3%
칠 3
 
2.3%
대 3
 
2.3%
리 3
 
2.3%
복 3
 
2.3%
태 2
 
1.6%
Other values (83) 94
73.4%

소재지도로명주소
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T05:01:52.731051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length35
Mean length27.444444
Min length20

Characters and Unicode

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

Unique

Unique45 ?
Unique (%)100.0%

Sample

1st row대구광역시 북구 대현남로5길 14 (대현동)
2nd row대구광역시 북구 관음동로9길 15 (관음동)
3rd row대구광역시 북구 구암서로 41, 2층 (구암동, 그린빌3단지 관리실)
4th row대구광역시 북구 구리로38길 8, 3층 (국우동)
5th row대구광역시 북구 매전로 50-39, 1층 (태전동)
ValueCountFrequency (%)
대구광역시 45
 
17.9%
북구 45
 
17.9%
2층 14
 
5.6%
태전동 5
 
2.0%
구암동 5
 
2.0%
관음동 4
 
1.6%
읍내동 4
 
1.6%
산격동 3
 
1.2%
복현로 3
 
1.2%
복현동 3
 
1.2%
Other values (101) 121
48.0%
2023-12-11T05:01:53.377748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
207
 
16.8%
구 101
 
8.2%
동 63
 
5.1%
대 57
 
4.6%
북 47
 
3.8%
시 45
 
3.6%
역 45
 
3.6%
) 45
 
3.6%
광 45
 
3.6%
( 45
 
3.6%
Other values (76) 535
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 704
57.0%
Space Separator 207
 
16.8%
Decimal Number 191
 
15.5%
Close Punctuation 45
 
3.6%
Open Punctuation 45
 
3.6%
Other Punctuation 29
 
2.3%
Dash Punctuation 13
 
1.1%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 101
14.3%
동 63
 
8.9%
대 57
 
8.1%
북 47
 
6.7%
시 45
 
6.4%
역 45
 
6.4%
광 45
 
6.4%
로 44
 
6.2%
길 28
 
4.0%
층 19
 
2.7%
Other values (59) 210
29.8%
Decimal Number
ValueCountFrequency (%)
1 45
23.6%
2 39
20.4%
3 20
10.5%
4 17
 
8.9%
0 15
 
7.9%
7 14
 
7.3%
5 12
 
6.3%
9 11
 
5.8%
8 11
 
5.8%
6 7
 
3.7%
Other Punctuation
ValueCountFrequency (%)
, 28
96.6%
/ 1
 
3.4%
Space Separator
ValueCountFrequency (%)
207
100.0%
Close Punctuation
ValueCountFrequency (%)
) 45
100.0%
Open Punctuation
ValueCountFrequency (%)
( 45
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Uppercase Letter
ValueCountFrequency (%)
C 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 704
57.0%
Common 530
42.9%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 101
14.3%
동 63
 
8.9%
대 57
 
8.1%
북 47
 
6.7%
시 45
 
6.4%
역 45
 
6.4%
광 45
 
6.4%
로 44
 
6.2%
길 28
 
4.0%
층 19
 
2.7%
Other values (59) 210
29.8%
Common
ValueCountFrequency (%)
207
39.1%
) 45
 
8.5%
( 45
 
8.5%
1 45
 
8.5%
2 39
 
7.4%
, 28
 
5.3%
3 20
 
3.8%
4 17
 
3.2%
0 15
 
2.8%
7 14
 
2.6%
Other values (6) 55
 
10.4%
Latin
ValueCountFrequency (%)
C 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 704
57.0%
ASCII 531
43.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
207
39.0%
) 45
 
8.5%
( 45
 
8.5%
1 45
 
8.5%
2 39
 
7.3%
, 28
 
5.3%
3 20
 
3.8%
4 17
 
3.2%
0 15
 
2.8%
7 14
 
2.6%
Other values (7) 56
 
10.5%
Hangul
ValueCountFrequency (%)
구 101
14.3%
동 63
 
8.9%
대 57
 
8.1%
북 47
 
6.7%
시 45
 
6.4%
역 45
 
6.4%
광 45
 
6.4%
로 44
 
6.2%
길 28
 
4.0%
층 19
 
2.7%
Other values (59) 210
29.8%

위도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.920948
Minimum35.879122
Maximum35.953651
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2023-12-11T05:01:53.549529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.879122
5-th percentile35.882458
Q135.898328
median35.926692
Q335.938321
95-th percentile35.945931
Maximum35.953651
Range0.074529
Interquartile range (IQR)0.039993

Descriptive statistics

Standard deviation0.021584994
Coefficient of variation (CV)0.00060090267
Kurtosis-0.94557794
Mean35.920948
Median Absolute Deviation (MAD)0.013731
Skewness-0.57640783
Sum1616.4427
Variance0.00046591195
MonotonicityNot monotonic
2023-12-11T05:01:53.772423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
35.882337 1
 
2.2%
35.927814 1
 
2.2%
35.945495 1
 
2.2%
35.935583 1
 
2.2%
35.926692 1
 
2.2%
35.896809 1
 
2.2%
35.884341 1
 
2.2%
35.939549 1
 
2.2%
35.941405 1
 
2.2%
35.934362 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
35.879122 1
2.2%
35.880486 1
2.2%
35.882337 1
2.2%
35.882944 1
2.2%
35.884341 1
2.2%
35.892332 1
2.2%
35.894244 1
2.2%
35.89486 1
2.2%
35.896809 1
2.2%
35.897245 1
2.2%
ValueCountFrequency (%)
35.953651 1
2.2%
35.947501 1
2.2%
35.94604 1
2.2%
35.945495 1
2.2%
35.944189 1
2.2%
35.943488 1
2.2%
35.94212 1
2.2%
35.941405 1
2.2%
35.940315 1
2.2%
35.939553 1
2.2%

경도
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.57522
Minimum128.5411
Maximum128.62629
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2023-12-11T05:01:54.291719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.5411
5-th percentile128.54489
Q1128.54971
median128.56462
Q3128.59882
95-th percentile128.62393
Maximum128.62629
Range0.085189
Interquartile range (IQR)0.049106

Descriptive statistics

Standard deviation0.02792332
Coefficient of variation (CV)0.00021717496
Kurtosis-1.2710895
Mean128.57522
Median Absolute Deviation (MAD)0.019044
Skewness0.47766364
Sum5785.8851
Variance0.00077971178
MonotonicityNot monotonic
2023-12-11T05:01:54.454123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
128.606454 1
 
2.2%
128.555027 1
 
2.2%
128.547702 1
 
2.2%
128.543212 1
 
2.2%
128.559751 1
 
2.2%
128.610663 1
 
2.2%
128.61111 1
 
2.2%
128.558767 1
 
2.2%
128.547186 1
 
2.2%
128.550075 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
128.541098 1
2.2%
128.543212 1
2.2%
128.544824 1
2.2%
128.545139 1
2.2%
128.545252 1
2.2%
128.54558 1
2.2%
128.546876 1
2.2%
128.547186 1
2.2%
128.547702 1
2.2%
128.547884 1
2.2%
ValueCountFrequency (%)
128.626287 1
2.2%
128.624142 1
2.2%
128.624002 1
2.2%
128.623635 1
2.2%
128.61944 1
2.2%
128.61111 1
2.2%
128.610663 1
2.2%
128.606454 1
2.2%
128.60563 1
2.2%
128.603353 1
2.2%

전화번호
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-11T05:01:54.740812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.066667
Min length12

Characters and Unicode

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

Unique45 ?
Unique (%)100.0%

Sample

1st row053-953-5550
2nd row053-314-2907
3rd row053-322-4472
4th row070-8276-1593
5th row053-311-7922
ValueCountFrequency (%)
053-953-5550 1
 
2.2%
053-939-7879 1
 
2.2%
053-326-1691 1
 
2.2%
053-311-0339 1
 
2.2%
053-311-7117 1
 
2.2%
053-944-0265 1
 
2.2%
053-956-3160 1
 
2.2%
053-322-4331 1
 
2.2%
053-312-8632 1
 
2.2%
053-323-6263 1
 
2.2%
Other values (35) 35
77.8%
2023-12-11T05:01:55.236664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 102
18.8%
- 90
16.6%
5 75
13.8%
0 68
12.5%
2 43
7.9%
1 40
 
7.4%
9 38
 
7.0%
7 27
 
5.0%
4 25
 
4.6%
8 18
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 453
83.4%
Dash Punctuation 90
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 102
22.5%
5 75
16.6%
0 68
15.0%
2 43
9.5%
1 40
 
8.8%
9 38
 
8.4%
7 27
 
6.0%
4 25
 
5.5%
8 18
 
4.0%
6 17
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 543
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 102
18.8%
- 90
16.6%
5 75
13.8%
0 68
12.5%
2 43
7.9%
1 40
 
7.4%
9 38
 
7.0%
7 27
 
5.0%
4 25
 
4.6%
8 18
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 543
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 102
18.8%
- 90
16.6%
5 75
13.8%
0 68
12.5%
2 43
7.9%
1 40
 
7.4%
9 38
 
7.0%
7 27
 
5.0%
4 25
 
4.6%
8 18
 
3.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size492.0 B
Minimum2019-08-28 00:00:00
Maximum2019-08-28 00:00:00
2023-12-11T05:01:55.391406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:55.516684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T05:01:50.197995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:49.356992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:49.764963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:50.321003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:49.486715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:49.902732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:50.467071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:49.647815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T05:01:50.053230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T05:01:55.635626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시설명소재지도로명주소위도경도전화번호
연번1.0001.0001.0000.2700.5051.000
시설명1.0001.0001.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.0001.0001.000
위도0.2701.0001.0001.0000.5181.000
경도0.5051.0001.0000.5181.0001.000
전화번호1.0001.0001.0001.0001.0001.000
2023-12-11T05:01:55.787472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.012-0.019
위도0.0121.000-0.516
경도-0.019-0.5161.000

Missing values

2023-12-11T05:01:50.635683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T05:01:50.813404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

연번시설명소재지도로명주소위도경도전화번호데이터기준일자
01감나무골작은학교대구광역시 북구 대현남로5길 14 (대현동)35.882337128.606454053-953-55502019-08-28
12구세군대구칠곡대구광역시 북구 관음동로9길 15 (관음동)35.937304128.545252053-314-29072019-08-28
23구암대구광역시 북구 구암서로 41, 2층 (구암동, 그린빌3단지 관리실)35.940315128.564624053-322-44722019-08-28
34그린대구광역시 북구 구리로38길 8, 3층 (국우동)35.947501128.575361070-8276-15932019-08-28
45글로리대구광역시 북구 매전로 50-39, 1층 (태전동)35.909117128.547884053-311-79222019-08-28
56꿈모아대구광역시 북구 태암로3길 20 (태전동)35.930371128.549715053-321-51512019-08-28
67느티나무대구광역시 북구 태전로7길 30-11 (태전동)35.923001128.541098053-294-33172019-08-28
78다사랑대구광역시 북구 중앙대로105길 27 (칠성동2가,아트센스빌딩)35.880486128.592729053-353-43332019-08-28
89다솔대구광역시 북구 동천로24길 17-9 (동천동)35.94212128.562265070-8835-59912019-08-28
910대경맘대구광역시 북구 팔거천서로35길 5, 2층 (읍내동)35.939553128.556063070-8982-61042019-08-28
연번시설명소재지도로명주소위도경도전화번호데이터기준일자
3536태전대구광역시 북구 칠곡중앙대로69길 14-17, 2층 (태전동)35.927282128.545139053-323-88262019-08-28
3637팔달대구광역시 북구 매천로2길 19-4, C 101 (팔달동, 태운넥스빌)35.897504128.544824053-314-08822019-08-28
3738필통대구광역시 북구 복현로 72 (복현동)35.898328128.623635053-955-55292019-08-28
3839하늘대구광역시 북구 칠성로17길 4 (칠성동2가)35.879122128.598821053-424-51472019-08-28
3940해피업대구광역시 북구 학남로 77, 2층 (국우동)35.94604128.57003053-324-01822019-08-28
4041햇살가득대구광역시 북구 대천로18길 22, 3층 (동천동)35.935212128.557307053-264-05502019-08-28
4142행복나무대구광역시 북구 구암서로7, 302/105 (구암동, 부영아파트)35.937379128.564138053-312-03652019-08-28
4243행복대구광역시 북구 칠곡중앙대로91길 18, 2층 (관음동)35.93654128.546876053-202-79792019-08-28
4344화성대구광역시 북구 고성북로 31-18 (고성동3가)35.882944128.582214053-359-33992019-08-28
4445함지대구광역시 북구 동암로179(구암동)35.943488128.570585053-321-13362019-08-28