Overview

Dataset statistics

Number of variables6
Number of observations21
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory56.3 B

Variable types

Categorical1
Text2
Numeric2
DateTime1

Dataset

Description대구광역시_북구_어린이기호식품 우수판매업소 현황_20190708
Author대구광역시 북구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15029673&dataSetDetailId=150296731ae3864b0eb42_201907081013&provdMethod=FILE

Alerts

데이터기준일 has constant value ""Constant
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 19:02:23.851026
Analysis finished2023-12-10 19:02:25.119795
Duration1.27 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

운영형태
Categorical

Distinct4
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
학교매점
8 
휴게음식점
5 
일반음식점
4 
문구점
4 

Length

Max length5
Median length4
Mean length4.2380952
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row학교매점
3rd row학교매점
4th row휴게음식점
5th row문구점

Common Values

ValueCountFrequency (%)
학교매점 8
38.1%
휴게음식점 5
23.8%
일반음식점 4
19.0%
문구점 4
19.0%

Length

2023-12-11T04:02:25.244222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:02:25.416275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학교매점 8
38.1%
휴게음식점 5
23.8%
일반음식점 4
19.0%
문구점 4
19.0%

업소명
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-11T04:02:25.639915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length7
Min length3

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row신전떡볶이
2nd row경명여중 학교매점
3rd row경명여고 학교매점
4th row델리치
5th row동이문구사
ValueCountFrequency (%)
학교매점 5
 
16.1%
매점 3
 
9.7%
신전떡볶이 1
 
3.2%
영진고 1
 
3.2%
성북분식 1
 
3.2%
아빠와크레파스 1
 
3.2%
김밥매니아(동변점 1
 
3.2%
바른손분식 1
 
3.2%
우주문구사 1
 
3.2%
신전떡볶이학남점 1
 
3.2%
Other values (15) 15
48.4%
2023-12-11T04:02:26.001332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 11
 
7.5%
10
 
6.8%
학 9
 
6.1%
매 9
 
6.1%
교 8
 
5.4%
고 7
 
4.8%
여 5
 
3.4%
이 4
 
2.7%
경 4
 
2.7%
등 3
 
2.0%
Other values (50) 77
52.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 134
91.2%
Space Separator 10
 
6.8%
Close Punctuation 1
 
0.7%
Open Punctuation 1
 
0.7%
Other Punctuation 1
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 11
 
8.2%
학 9
 
6.7%
매 9
 
6.7%
교 8
 
6.0%
고 7
 
5.2%
여 5
 
3.7%
이 4
 
3.0%
경 4
 
3.0%
등 3
 
2.2%
볶 3
 
2.2%
Other values (46) 71
53.0%
Space Separator
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 134
91.2%
Common 13
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 11
 
8.2%
학 9
 
6.7%
매 9
 
6.7%
교 8
 
6.0%
고 7
 
5.2%
여 5
 
3.7%
이 4
 
3.0%
경 4
 
3.0%
등 3
 
2.2%
볶 3
 
2.2%
Other values (46) 71
53.0%
Common
ValueCountFrequency (%)
10
76.9%
) 1
 
7.7%
( 1
 
7.7%
, 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 134
91.2%
ASCII 13
 
8.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 11
 
8.2%
학 9
 
6.7%
매 9
 
6.7%
교 8
 
6.0%
고 7
 
5.2%
여 5
 
3.7%
이 4
 
3.0%
경 4
 
3.0%
등 3
 
2.2%
볶 3
 
2.2%
Other values (46) 71
53.0%
ASCII
ValueCountFrequency (%)
10
76.9%
) 1
 
7.7%
( 1
 
7.7%
, 1
 
7.7%

소재지도로명주소
Text

Distinct20
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-11T04:02:26.300604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length26
Mean length24.52381
Min length20

Characters and Unicode

Total characters515
Distinct characters58
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique19 ?
Unique (%)90.5%

Sample

1st row대구광역시 북구 칠성로17길 13(칠성동2가)
2nd row대구광역시 북구 칠성로17길 18(칠성동2가)
3rd row대구광역시 북구 칠성로17길 18(칠성동2가)
4th row대구광역시 북구 옥산로17길 50(침산동,침산제일아파트 상가 7호)
5th row대구광역시 북구 연암로25길 26(산격동)
ValueCountFrequency (%)
대구광역시 21
23.3%
북구 21
23.3%
칠성로17길 3
 
3.3%
상가 2
 
2.2%
서변로21길 2
 
2.2%
태전로 2
 
2.2%
18(칠성동2가 2
 
2.2%
15(서변동 1
 
1.1%
침산로21길 1
 
1.1%
100(태전동 1
 
1.1%
Other values (34) 34
37.8%
2023-12-11T04:02:26.763453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
69
 
13.4%
구 42
 
8.2%
동 28
 
5.4%
1 24
 
4.7%
북 23
 
4.5%
대 22
 
4.3%
로 21
 
4.1%
( 21
 
4.1%
) 21
 
4.1%
광 21
 
4.1%
Other values (48) 223
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 317
61.6%
Decimal Number 84
 
16.3%
Space Separator 69
 
13.4%
Open Punctuation 21
 
4.1%
Close Punctuation 21
 
4.1%
Other Punctuation 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 42
13.2%
동 28
 
8.8%
북 23
 
7.3%
대 22
 
6.9%
로 21
 
6.6%
광 21
 
6.6%
시 21
 
6.6%
역 21
 
6.6%
길 17
 
5.4%
산 11
 
3.5%
Other values (34) 90
28.4%
Decimal Number
ValueCountFrequency (%)
1 24
28.6%
2 11
13.1%
7 10
11.9%
0 8
 
9.5%
5 7
 
8.3%
6 6
 
7.1%
3 5
 
6.0%
9 5
 
6.0%
8 4
 
4.8%
4 4
 
4.8%
Space Separator
ValueCountFrequency (%)
69
100.0%
Open Punctuation
ValueCountFrequency (%)
( 21
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 317
61.6%
Common 198
38.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 42
13.2%
동 28
 
8.8%
북 23
 
7.3%
대 22
 
6.9%
로 21
 
6.6%
광 21
 
6.6%
시 21
 
6.6%
역 21
 
6.6%
길 17
 
5.4%
산 11
 
3.5%
Other values (34) 90
28.4%
Common
ValueCountFrequency (%)
69
34.8%
1 24
 
12.1%
( 21
 
10.6%
) 21
 
10.6%
2 11
 
5.6%
7 10
 
5.1%
0 8
 
4.0%
5 7
 
3.5%
6 6
 
3.0%
3 5
 
2.5%
Other values (4) 16
 
8.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 317
61.6%
ASCII 198
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
69
34.8%
1 24
 
12.1%
( 21
 
10.6%
) 21
 
10.6%
2 11
 
5.6%
7 10
 
5.1%
0 8
 
4.0%
5 7
 
3.5%
6 6
 
3.0%
3 5
 
2.5%
Other values (4) 16
 
8.1%
Hangul
ValueCountFrequency (%)
구 42
13.2%
동 28
 
8.8%
북 23
 
7.3%
대 22
 
6.9%
로 21
 
6.6%
광 21
 
6.6%
시 21
 
6.6%
역 21
 
6.6%
길 17
 
5.4%
산 11
 
3.5%
Other values (34) 90
28.4%

위도
Real number (ℝ)

Distinct20
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.909098
Minimum35.879846
Maximum35.944743
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-11T04:02:26.952909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.879846
5-th percentile35.880835
Q135.894695
median35.90218
Q335.925576
95-th percentile35.944181
Maximum35.944743
Range0.06489718
Interquartile range (IQR)0.03088142

Descriptive statistics

Standard deviation0.020372463
Coefficient of variation (CV)0.00056733431
Kurtosis-1.0923813
Mean35.909098
Median Absolute Deviation (MAD)0.01752679
Skewness0.2334976
Sum754.09106
Variance0.00041503726
MonotonicityNot monotonic
2023-12-11T04:02:27.131662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
35.88083532 2
 
9.5%
35.87984629 1
 
4.8%
35.92901956 1
 
4.8%
35.89239082 1
 
4.8%
35.9255764 1
 
4.8%
35.92556645 1
 
4.8%
35.91967589 1
 
4.8%
35.91970697 1
 
4.8%
35.94418055 1
 
4.8%
35.94474347 1
 
4.8%
Other values (10) 10
47.6%
ValueCountFrequency (%)
35.87984629 1
4.8%
35.88083532 2
9.5%
35.88897838 1
4.8%
35.89239082 1
4.8%
35.89469498 1
4.8%
35.897215 1
4.8%
35.90008049 1
4.8%
35.90066448 1
4.8%
35.90189949 1
4.8%
35.90218018 1
4.8%
ValueCountFrequency (%)
35.94474347 1
4.8%
35.94418055 1
4.8%
35.93001392 1
4.8%
35.92972537 1
4.8%
35.92901956 1
4.8%
35.9255764 1
4.8%
35.92556645 1
4.8%
35.91970697 1
4.8%
35.91967589 1
4.8%
35.90323103 1
4.8%

경도
Real number (ℝ)

Distinct20
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.58901
Minimum128.54122
Maximum128.62211
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-11T04:02:27.291355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128.54122
5-th percentile128.54184
Q1128.58682
median128.59504
Q3128.60343
95-th percentile128.62154
Maximum128.62211
Range0.0808895
Interquartile range (IQR)0.0166043

Descriptive statistics

Standard deviation0.024646141
Coefficient of variation (CV)0.000191666
Kurtosis-0.21932692
Mean128.58901
Median Absolute Deviation (MAD)0.008388
Skewness-0.76409192
Sum2700.3692
Variance0.00060743226
MonotonicityNot monotonic
2023-12-11T04:02:27.453640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
128.5985926 2
 
9.5%
128.5981089 1
 
4.8%
128.5418404 1
 
4.8%
128.5893864 1
 
4.8%
128.5950408 1
 
4.8%
128.5952291 1
 
4.8%
128.6034288 1
 
4.8%
128.6044152 1
 
4.8%
128.5515207 1
 
4.8%
128.569891 1
 
4.8%
Other values (10) 10
47.6%
ValueCountFrequency (%)
128.5412246 1
4.8%
128.5418404 1
4.8%
128.5510785 1
4.8%
128.5515207 1
4.8%
128.569891 1
4.8%
128.5868245 1
4.8%
128.5872612 1
4.8%
128.5876421 1
4.8%
128.5893864 1
4.8%
128.5944292 1
4.8%
ValueCountFrequency (%)
128.6221141 1
4.8%
128.6215392 1
4.8%
128.6202645 1
4.8%
128.6107734 1
4.8%
128.6044152 1
4.8%
128.6034288 1
4.8%
128.5985926 2
9.5%
128.5981089 1
4.8%
128.5952291 1
4.8%
128.5950408 1
4.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
Minimum2019-07-08 00:00:00
Maximum2019-07-08 00:00:00
2023-12-11T04:02:27.593054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:02:27.699124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T04:02:24.578511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:02:24.191211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:02:24.703549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:02:24.418578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T04:02:27.801073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운영형태업소명소재지도로명주소위도경도
운영형태1.0001.0001.0000.0000.577
업소명1.0001.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.0001.000
위도0.0001.0001.0001.0000.698
경도0.5771.0001.0000.6981.000
2023-12-11T04:02:27.925837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도운영형태
위도1.000-0.4420.000
경도-0.4421.0000.277
운영형태0.0000.2771.000

Missing values

2023-12-11T04:02:24.911569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T04:02:25.057090image/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

운영형태업소명소재지도로명주소위도경도데이터기준일
0일반음식점신전떡볶이대구광역시 북구 칠성로17길 13(칠성동2가)35.879846128.5981092019-07-08
1학교매점경명여중 학교매점대구광역시 북구 칠성로17길 18(칠성동2가)35.880835128.5985932019-07-08
2학교매점경명여고 학교매점대구광역시 북구 칠성로17길 18(칠성동2가)35.880835128.5985932019-07-08
3휴게음식점델리치대구광역시 북구 옥산로17길 50(침산동,침산제일아파트 상가 7호)35.888978128.5868252019-07-08
4문구점동이문구사대구광역시 북구 연암로25길 26(산격동)35.897215128.5944292019-07-08
5휴게음식점로얄떡볶이대구광역시 북구 동북로37길 56(산격동)35.90218128.6107732019-07-08
6학교매점성화중, 성화여고 학교 매점대구광역시 북구 복현로 140(복현동)35.903231128.6202642019-07-08
7학교매점경상고등 학교매점대구광역시 북구 공항로 15길 24(복현동)35.901899128.6215392019-07-08
8학교매점경상여고 학교매점대구광역시 북구 침산남로 9길 173(침산동)35.90008128.5872612019-07-08
9문구점푸른서점대구광역시 북구 침산남로9길 180(침산동)35.900664128.5876422019-07-08
운영형태업소명소재지도로명주소위도경도데이터기준일
11학교매점강북고등학교 매점대구광역시 북구 태전로 100(태전동)35.929725128.5412252019-07-08
12학교매점영송여자고등학교 매점대구광역시 북구 태전로 92(태전동)35.92902128.541842019-07-08
13휴게음식점둘리분식대구광역시 북구 태암로5길 18(태전동)35.930014128.5510782019-07-08
14일반음식점신전떡볶이학남점대구광역시 북구 학남로17길 2(국우동)35.944743128.5698912019-07-08
15문구점우주문구사대구광역시 북구 칠곡중앙대로110길 6(읍내동)35.944181128.5515212019-07-08
16휴게음식점바른손분식대구광역시 북구 동변로14길 7(동변동)35.919707128.6044152019-07-08
17일반음식점김밥매니아(동변점)대구광역시 북구 동변로 69(동변동)35.919676128.6034292019-07-08
18문구점아빠와크레파스대구광역시 북구 서변로21길 13(서변동)35.925566128.5952292019-07-08
19휴게음식점성북분식대구광역시 북구 서변로21길 15(서변동)35.925576128.5950412019-07-08
20일반음식점김밥짱대구광역시 북구 침산로21길 36, 106동104호(침산동,쌍용아파트 상가)35.892391128.5893862019-07-08