Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells10
Missing cells (%)1.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory49.3 B

Variable types

Text3
Categorical2
DateTime1

Dataset

Description대구광역시 동구_자원봉사자 할인가맹점 현황_20230413
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15052511&dataSetDetailId=150525111eec67d244ef0&provdMethod=FILE

Alerts

연락처 has 10 (10.0%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 18:32:52.215664
Analysis finished2023-12-10 18:32:53.933875
Duration1.72 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업소명
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-11T03:32:54.205956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length7.95
Min length3

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row대광상사
2nd row큰집삼계탕
3rd row부부식당
4th row태종대식당
5th row옛날그맛짜장
ValueCountFrequency (%)
동화사 8
 
5.9%
gm대우 2
 
1.5%
방촌점 2
 
1.5%
대광상사 1
 
0.7%
대청이용원 1
 
0.7%
세미미용실 1
 
0.7%
대구루비다육 1
 
0.7%
일 1
 
0.7%
사람과 1
 
0.7%
집단시설지구(산중식당 1
 
0.7%
Other values (116) 116
85.9%
2023-12-11T03:32:54.884085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
35
 
4.4%
( 23
 
2.9%
) 23
 
2.9%
식 20
 
2.5%
사 18
 
2.3%
동 17
 
2.1%
스 17
 
2.1%
당 16
 
2.0%
구 13
 
1.6%
집 12
 
1.5%
Other values (236) 601
75.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 700
88.1%
Space Separator 35
 
4.4%
Open Punctuation 23
 
2.9%
Close Punctuation 23
 
2.9%
Uppercase Letter 6
 
0.8%
Other Symbol 3
 
0.4%
Other Punctuation 3
 
0.4%
Decimal Number 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
식 20
 
2.9%
사 18
 
2.6%
동 17
 
2.4%
스 17
 
2.4%
당 16
 
2.3%
구 13
 
1.9%
집 12
 
1.7%
점 12
 
1.7%
화 11
 
1.6%
지 11
 
1.6%
Other values (224) 553
79.0%
Uppercase Letter
ValueCountFrequency (%)
M 2
33.3%
G 2
33.3%
B 1
16.7%
H 1
16.7%
Other Punctuation
ValueCountFrequency (%)
" 2
66.7%
& 1
33.3%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
8 1
50.0%
Space Separator
ValueCountFrequency (%)
35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 703
88.4%
Common 86
 
10.8%
Latin 6
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
식 20
 
2.8%
사 18
 
2.6%
동 17
 
2.4%
스 17
 
2.4%
당 16
 
2.3%
구 13
 
1.8%
집 12
 
1.7%
점 12
 
1.7%
화 11
 
1.6%
지 11
 
1.6%
Other values (225) 556
79.1%
Common
ValueCountFrequency (%)
35
40.7%
( 23
26.7%
) 23
26.7%
" 2
 
2.3%
& 1
 
1.2%
0 1
 
1.2%
8 1
 
1.2%
Latin
ValueCountFrequency (%)
M 2
33.3%
G 2
33.3%
B 1
16.7%
H 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 700
88.1%
ASCII 92
 
11.6%
None 3
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
35
38.0%
( 23
25.0%
) 23
25.0%
" 2
 
2.2%
M 2
 
2.2%
G 2
 
2.2%
B 1
 
1.1%
& 1
 
1.1%
H 1
 
1.1%
0 1
 
1.1%
Hangul
ValueCountFrequency (%)
식 20
 
2.9%
사 18
 
2.6%
동 17
 
2.4%
스 17
 
2.4%
당 16
 
2.3%
구 13
 
1.9%
집 12
 
1.7%
점 12
 
1.7%
화 11
 
1.6%
지 11
 
1.6%
Other values (224) 553
79.0%
None
ValueCountFrequency (%)
㈜ 3
100.0%

업종
Categorical

Distinct31
Distinct (%)31.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
음식점
43 
자동차정비
8 
미용업
6 
세탁소
5 
꽃집
 
4
Other values (26)
34 

Length

Max length5
Median length3
Mean length3.12
Min length2

Unique

Unique19 ?
Unique (%)19.0%

Sample

1st row설비자재업
2nd row음식점
3rd row음식점
4th row음식점
5th row음식점

Common Values

ValueCountFrequency (%)
음식점 43
43.0%
자동차정비 8
 
8.0%
미용업 6
 
6.0%
세탁소 5
 
5.0%
꽃집 4
 
4.0%
기타 3
 
3.0%
영화관 2
 
2.0%
학원 2
 
2.0%
화장품 2
 
2.0%
식품제조 2
 
2.0%
Other values (21) 23
23.0%

Length

2023-12-11T03:32:55.160996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
음식점 43
43.0%
자동차정비 8
 
8.0%
미용업 6
 
6.0%
세탁소 5
 
5.0%
꽃집 4
 
4.0%
기타 3
 
3.0%
식품제조 2
 
2.0%
서점 2
 
2.0%
이용업 2
 
2.0%
화장품 2
 
2.0%
Other values (21) 23
23.0%

도로명 주소
Text

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-11T03:32:55.743526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length31
Mean length24.16
Min length20

Characters and Unicode

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

Unique

Unique98 ?
Unique (%)98.0%

Sample

1st row대구광역시 동구 화랑로 499 (용계동)
2nd row대구광역시 동구 효목로1길 21 (효목동)
3rd row대구광역시 동구 반야월로32길 61-2 (신기동)
4th row대구광역시 동구 팔공로24길 19-10 (불로동)
5th row대구광역시 동구 아양로49길 2 (신암동)
ValueCountFrequency (%)
대구광역시 100
20.0%
동구 100
20.0%
신천동 15
 
3.0%
효목동 15
 
3.0%
용수동 11
 
2.2%
불로동 10
 
2.0%
팔공산로185길 9
 
1.8%
신암동 7
 
1.4%
팔공로51길 6
 
1.2%
효신로 6
 
1.2%
Other values (160) 220
44.1%
2023-12-11T03:32:56.617451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
403
16.7%
동 228
 
9.4%
구 200
 
8.3%
로 110
 
4.6%
대 102
 
4.2%
역 101
 
4.2%
시 101
 
4.2%
( 100
 
4.1%
광 100
 
4.1%
) 100
 
4.1%
Other values (89) 871
36.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1414
58.5%
Space Separator 403
 
16.7%
Decimal Number 371
 
15.4%
Open Punctuation 100
 
4.1%
Close Punctuation 100
 
4.1%
Dash Punctuation 15
 
0.6%
Other Punctuation 13
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 228
16.1%
구 200
14.1%
로 110
 
7.8%
대 102
 
7.2%
역 101
 
7.1%
시 101
 
7.1%
광 100
 
7.1%
길 59
 
4.2%
신 45
 
3.2%
효 35
 
2.5%
Other values (74) 333
23.6%
Decimal Number
ValueCountFrequency (%)
1 97
26.1%
2 47
12.7%
5 47
12.7%
3 36
 
9.7%
9 29
 
7.8%
6 27
 
7.3%
4 27
 
7.3%
8 26
 
7.0%
0 18
 
4.9%
7 17
 
4.6%
Space Separator
ValueCountFrequency (%)
403
100.0%
Open Punctuation
ValueCountFrequency (%)
( 100
100.0%
Close Punctuation
ValueCountFrequency (%)
) 100
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%
Other Punctuation
ValueCountFrequency (%)
, 13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1414
58.5%
Common 1002
41.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 228
16.1%
구 200
14.1%
로 110
 
7.8%
대 102
 
7.2%
역 101
 
7.1%
시 101
 
7.1%
광 100
 
7.1%
길 59
 
4.2%
신 45
 
3.2%
효 35
 
2.5%
Other values (74) 333
23.6%
Common
ValueCountFrequency (%)
403
40.2%
( 100
 
10.0%
) 100
 
10.0%
1 97
 
9.7%
2 47
 
4.7%
5 47
 
4.7%
3 36
 
3.6%
9 29
 
2.9%
6 27
 
2.7%
4 27
 
2.7%
Other values (5) 89
 
8.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1414
58.5%
ASCII 1002
41.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
403
40.2%
( 100
 
10.0%
) 100
 
10.0%
1 97
 
9.7%
2 47
 
4.7%
5 47
 
4.7%
3 36
 
3.6%
9 29
 
2.9%
6 27
 
2.7%
4 27
 
2.7%
Other values (5) 89
 
8.9%
Hangul
ValueCountFrequency (%)
동 228
16.1%
구 200
14.1%
로 110
 
7.8%
대 102
 
7.2%
역 101
 
7.1%
시 101
 
7.1%
광 100
 
7.1%
길 59
 
4.2%
신 45
 
3.2%
효 35
 
2.5%
Other values (74) 333
23.6%

연락처
Text

MISSING 

Distinct88
Distinct (%)97.8%
Missing10
Missing (%)10.0%
Memory size932.0 B
2023-12-11T03:32:57.072767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.977778
Min length9

Characters and Unicode

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

Unique86 ?
Unique (%)95.6%

Sample

1st row053-984-9132
2nd row053-743-1532
3rd row053-964-3117
4th row053-983-3477
5th row053-985-5888
ValueCountFrequency (%)
053-295-3399 2
 
2.2%
053-982-3730 2
 
2.2%
053-984-9132 1
 
1.1%
053-751-5235 1
 
1.1%
053-985-4082 1
 
1.1%
053-982-1755 1
 
1.1%
053-982-0128 1
 
1.1%
053-982-0126 1
 
1.1%
053-982-7999 1
 
1.1%
053-755-5561 1
 
1.1%
Other values (78) 78
86.7%
2023-12-11T03:32:57.792835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 179
16.6%
5 156
14.5%
0 151
14.0%
3 140
13.0%
9 94
8.7%
8 81
7.5%
7 63
 
5.8%
4 62
 
5.8%
1 60
 
5.6%
2 48
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 899
83.4%
Dash Punctuation 179
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 156
17.4%
0 151
16.8%
3 140
15.6%
9 94
10.5%
8 81
9.0%
7 63
7.0%
4 62
 
6.9%
1 60
 
6.7%
2 48
 
5.3%
6 44
 
4.9%
Dash Punctuation
ValueCountFrequency (%)
- 179
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1078
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 179
16.6%
5 156
14.5%
0 151
14.0%
3 140
13.0%
9 94
8.7%
8 81
7.5%
7 63
 
5.8%
4 62
 
5.8%
1 60
 
5.6%
2 48
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1078
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 179
16.6%
5 156
14.5%
0 151
14.0%
3 140
13.0%
9 94
8.7%
8 81
7.5%
7 63
 
5.8%
4 62
 
5.8%
1 60
 
5.6%
2 48
 
4.5%

할인내용(할인율)
Categorical

Distinct43
Distinct (%)43.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
전체품목10%
21 
전체품목 5%
18 
전체품목 10%
14 
10%
5 
5%
 
3
Other values (38)
39 

Length

Max length54
Median length41
Mean length9.66
Min length2

Unique

Unique37 ?
Unique (%)37.0%

Sample

1st row전체품목10%
2nd row전체품목 5%
3rd row국밥 500원 할인
4th row전체품목10%
5th row전체품목 5%

Common Values

ValueCountFrequency (%)
전체품목10% 21
21.0%
전체품목 5% 18
18.0%
전체품목 10% 14
14.0%
10% 5
 
5.0%
5% 3
 
3.0%
정비공임 10% 2
 
2.0%
전체품목 10%(현금결제시/사주상담 제외) 1
 
1.0%
베이커리 구입 시 아메리카노 또는 탄산 증정(토스트, 베이글 구입시 제외) 1
 
1.0%
국밥 500원 할인 1
 
1.0%
전체품목10%(배달제외,2만원이상) 1
 
1.0%
Other values (33) 33
33.0%

Length

2023-12-11T03:32:58.111850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전체품목 39
18.7%
10 28
13.4%
5 27
 
12.9%
전체품목10 21
 
10.0%
할인 8
 
3.8%
제외 5
 
2.4%
2,000원 4
 
1.9%
전품목 4
 
1.9%
공임 2
 
1.0%
500원 2
 
1.0%
Other values (65) 69
33.0%

지정일자
Date

Distinct15
Distinct (%)15.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2015-04-20 00:00:00
Maximum2021-12-03 00:00:00
2023-12-11T03:32:58.303640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T03:32:58.493775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)

Correlations

2023-12-11T03:32:58.626134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명업종도로명 주소연락처할인내용(할인율)지정일자
업소명1.0001.0001.0001.0001.0001.000
업종1.0001.0001.0001.0000.9120.743
도로명 주소1.0001.0001.0000.9970.0000.952
연락처1.0001.0000.9971.0000.9940.872
할인내용(할인율)1.0000.9120.0000.9941.0000.913
지정일자1.0000.7430.9520.8720.9131.000
2023-12-11T03:32:59.261194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
할인내용(할인율)업종
할인내용(할인율)1.0000.374
업종0.3741.000
2023-12-11T03:32:59.483444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종할인내용(할인율)
업종1.0000.374
할인내용(할인율)0.3741.000

Missing values

2023-12-11T03:32:53.620131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T03:32:53.862283image/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대광상사설비자재업대구광역시 동구 화랑로 499 (용계동)053-984-9132전체품목10%2015-04-20
1큰집삼계탕음식점대구광역시 동구 효목로1길 21 (효목동)053-743-1532전체품목 5%2015-04-20
2부부식당음식점대구광역시 동구 반야월로32길 61-2 (신기동)053-964-3117국밥 500원 할인2015-04-20
3태종대식당음식점대구광역시 동구 팔공로24길 19-10 (불로동)053-983-3477전체품목10%2015-04-20
4옛날그맛짜장음식점대구광역시 동구 아양로49길 2 (신암동)053-985-5888전체품목 5%2015-04-20
5통큰갈비음식점대구광역시 동구 해동로 169 (검사동)053-982-1080전체품목10%2015-04-20
6영남향기세탁(영남세탁)세탁소대구광역시 동구 동촌로 190 (방촌동, 영남네오빌)053-983-6466전체품목10%2015-04-20
7스타미용실미용업대구광역시 동구 팔공로24길 19-7 (불로동)<NA>전체품목 10%2015-04-20
8대성헤어명가이용업대구광역시 동구 해동로 129 (입석동)053-984-0411전체품목10%2015-04-20
9나루터 세탁소세탁소대구광역시 동구 동부로32길 87 (신천동)053-754-5535전체품목 10%2015-04-20
업소명업종도로명 주소연락처할인내용(할인율)지정일자
90(주)사람과연근 플러스자연식품제조대구광역시 동구 송라로 50(신천동)053-756-125610%2021-08-06
91효목인테리어인테리어대구광역시 동구 효신로 50-1(효목동)<NA>5%2021-08-06
92㈜아쿠아월드기타대구광역시 동구 동부로 149(신천동)053-247-8899입장료 50%(동반2인포함)2021-11-02
93골든벨 어린이서점서점대구광역시 동구 금강로 13(신서동)053-295-3399전품목 10%2021-11-02
94㈜ 카맨모터스자동차정비대구광역시 동구 안심로59길 26(각산동)053-965-1900전품목 20%2021-11-02
95스타태권스쿨학원대구광역시 동구 효동로15길 14(효목동)053-957-5175월 수련비 10%2021-11-02
96동화사 집단시설지구(한솔식당)음식점대구광역시 동구 팔공산로199길 14(용수동)053-982-3730전체품목10%2021-11-02
97동화사 집단시설지구(팔공산온천관광호텔)호텔대구광역시 동구 팔공산로185길 11(용수동)053-985-8080객실20%+온천사우나30%+식음료10%2021-11-02
98귀한 공인중개사 사무소공인중개사대구광역시 동구 팔공로51길 11, 115호(봉무동)053-981-96005%2021-12-03
99슈슈베이킹음식점대구광역시 동구 팔공로51길 11, 111호(봉무동)<NA>10%2021-12-03