Overview

Dataset statistics

Number of variables4
Number of observations43
Missing cells31
Missing cells (%)18.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory35.0 B

Variable types

Text3
DateTime1

Dataset

Description대구광역시 동구_행정사사무소 현황_20221130
Author대구광역시 동구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15028795&dataSetDetailId=150287951d5a246065cdf&provdMethod=FILE

Alerts

전화번호 has 31 (72.1%) missing valuesMissing
주소 has unique valuesUnique

Reproduction

Analysis started2024-04-21 08:58:34.781599
Analysis finished2024-04-21 08:58:35.669043
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct42
Distinct (%)97.7%
Missing0
Missing (%)0.0%
Memory size472.0 B
2024-04-21T17:58:36.245106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length9.6046512
Min length8

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)95.3%

Sample

1st row배영희행정사사무소
2nd row우리 행정사 사무소
3rd row김기대 행정사 사무소
4th row찰스행정사 사무소
5th row충효 행정사 사무소
ValueCountFrequency (%)
사무소 13
 
17.8%
행정사 12
 
16.4%
행정사사무소 4
 
5.5%
대경연합행정사사무소 2
 
2.7%
배석범행정사사무소 1
 
1.4%
백안행정사사무소 1
 
1.4%
행정사오석태사무소 1
 
1.4%
여완섭행정사사무소 1
 
1.4%
정도 1
 
1.4%
이윤호행정사무소 1
 
1.4%
Other values (36) 36
49.3%
2024-04-21T17:58:37.125097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 83
20.1%
정 49
11.9%
행 43
10.4%
무 42
10.2%
소 42
10.2%
30
 
7.3%
대 6
 
1.5%
이 6
 
1.5%
수 6
 
1.5%
김 5
 
1.2%
Other values (79) 101
24.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 377
91.3%
Space Separator 30
 
7.3%
Lowercase Letter 3
 
0.7%
Uppercase Letter 2
 
0.5%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 83
22.0%
정 49
13.0%
행 43
11.4%
무 42
11.1%
소 42
11.1%
대 6
 
1.6%
이 6
 
1.6%
수 6
 
1.6%
김 5
 
1.3%
호 4
 
1.1%
Other values (73) 91
24.1%
Lowercase Letter
ValueCountFrequency (%)
l 2
66.7%
a 1
33.3%
Uppercase Letter
ValueCountFrequency (%)
E 1
50.0%
F 1
50.0%
Space Separator
ValueCountFrequency (%)
30
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 377
91.3%
Common 31
 
7.5%
Latin 5
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 83
22.0%
정 49
13.0%
행 43
11.4%
무 42
11.1%
소 42
11.1%
대 6
 
1.6%
이 6
 
1.6%
수 6
 
1.6%
김 5
 
1.3%
호 4
 
1.1%
Other values (73) 91
24.1%
Latin
ValueCountFrequency (%)
l 2
40.0%
a 1
20.0%
E 1
20.0%
F 1
20.0%
Common
ValueCountFrequency (%)
30
96.8%
& 1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 377
91.3%
ASCII 36
 
8.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 83
22.0%
정 49
13.0%
행 43
11.4%
무 42
11.1%
소 42
11.1%
대 6
 
1.6%
이 6
 
1.6%
수 6
 
1.6%
김 5
 
1.3%
호 4
 
1.1%
Other values (73) 91
24.1%
ASCII
ValueCountFrequency (%)
30
83.3%
l 2
 
5.6%
a 1
 
2.8%
E 1
 
2.8%
& 1
 
2.8%
F 1
 
2.8%

주소
Text

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size472.0 B
2024-04-21T17:58:38.018137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length43
Mean length29.72093
Min length20

Characters and Unicode

Total characters1278
Distinct characters123
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

Unique43 ?
Unique (%)100.0%

Sample

1st row대구광역시 동구 동내로 76， 102호(동내동)
2nd row대구광역시 동구 동대구로 432， 국제오피스텔 1511호(신천동)
3rd row대구광역시 동구 아양로8길 4(신암동)
4th row대구광역시 동구 신암로 132， 1층 11호(신암동， 신흥아파트)
5th row대구광역시 동구 동대구로 577， 110동 208호(신암동， 이안센트럴D)
ValueCountFrequency (%)
대구광역시 43
 
16.5%
동구 43
 
16.5%
신천동 5
 
1.9%
신암동 5
 
1.9%
방촌동 4
 
1.5%
동촌로 4
 
1.5%
동대구로 4
 
1.5%
2층 3
 
1.2%
아양로 3
 
1.2%
1층 3
 
1.2%
Other values (129) 143
55.0%
2024-04-21T17:58:39.178757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
217
17.0%
동 115
 
9.0%
구 94
 
7.4%
대 52
 
4.1%
시 45
 
3.5%
1 45
 
3.5%
광 44
 
3.4%
역 44
 
3.4%
로 44
 
3.4%
) 43
 
3.4%
Other values (113) 535
41.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 720
56.3%
Space Separator 217
 
17.0%
Decimal Number 213
 
16.7%
Close Punctuation 43
 
3.4%
Open Punctuation 43
 
3.4%
Other Punctuation 34
 
2.7%
Dash Punctuation 5
 
0.4%
Uppercase Letter 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 115
16.0%
구 94
13.1%
대 52
 
7.2%
시 45
 
6.2%
광 44
 
6.1%
역 44
 
6.1%
로 44
 
6.1%
신 26
 
3.6%
길 18
 
2.5%
호 17
 
2.4%
Other values (95) 221
30.7%
Decimal Number
ValueCountFrequency (%)
1 45
21.1%
2 35
16.4%
6 22
10.3%
5 21
9.9%
3 21
9.9%
0 21
9.9%
4 17
 
8.0%
7 15
 
7.0%
8 11
 
5.2%
9 5
 
2.3%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
T 1
33.3%
D 1
33.3%
Space Separator
ValueCountFrequency (%)
217
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Other Punctuation
ValueCountFrequency (%)
， 34
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 720
56.3%
Common 555
43.4%
Latin 3
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 115
16.0%
구 94
13.1%
대 52
 
7.2%
시 45
 
6.2%
광 44
 
6.1%
역 44
 
6.1%
로 44
 
6.1%
신 26
 
3.6%
길 18
 
2.5%
호 17
 
2.4%
Other values (95) 221
30.7%
Common
ValueCountFrequency (%)
217
39.1%
1 45
 
8.1%
) 43
 
7.7%
( 43
 
7.7%
2 35
 
6.3%
， 34
 
6.1%
6 22
 
4.0%
5 21
 
3.8%
3 21
 
3.8%
0 21
 
3.8%
Other values (5) 53
 
9.5%
Latin
ValueCountFrequency (%)
K 1
33.3%
T 1
33.3%
D 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 720
56.3%
ASCII 524
41.0%
None 34
 
2.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
217
41.4%
1 45
 
8.6%
) 43
 
8.2%
( 43
 
8.2%
2 35
 
6.7%
6 22
 
4.2%
5 21
 
4.0%
3 21
 
4.0%
0 21
 
4.0%
4 17
 
3.2%
Other values (7) 39
 
7.4%
Hangul
ValueCountFrequency (%)
동 115
16.0%
구 94
13.1%
대 52
 
7.2%
시 45
 
6.2%
광 44
 
6.1%
역 44
 
6.1%
로 44
 
6.1%
신 26
 
3.6%
길 18
 
2.5%
호 17
 
2.4%
Other values (95) 221
30.7%
None
ValueCountFrequency (%)
， 34
100.0%

전화번호
Text

MISSING 

Distinct12
Distinct (%)100.0%
Missing31
Missing (%)72.1%
Memory size472.0 B
2024-04-21T17:58:39.741869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12
Min length11

Characters and Unicode

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

Unique12 ?
Unique (%)100.0%

Sample

1st row053-943-943
2nd row070-8832-2079
3rd row053-749-1170
4th row053-986-5462
5th row053-957-4830
ValueCountFrequency (%)
053-943-943 1
8.3%
070-8832-2079 1
8.3%
053-749-1170 1
8.3%
053-986-5462 1
8.3%
053-957-4830 1
8.3%
053-382-0313 1
8.3%
053-981-7337 1
8.3%
053-984-2852 1
8.3%
053-252-7410 1
8.3%
053-745-9064 1
8.3%
Other values (2) 2
16.7%
2024-04-21T17:58:40.545752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 24
16.7%
0 22
15.3%
3 21
14.6%
5 17
11.8%
9 11
7.6%
4 10
6.9%
7 10
6.9%
8 9
 
6.2%
2 8
 
5.6%
1 7
 
4.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 120
83.3%
Dash Punctuation 24
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 22
18.3%
3 21
17.5%
5 17
14.2%
9 11
9.2%
4 10
8.3%
7 10
8.3%
8 9
7.5%
2 8
 
6.7%
1 7
 
5.8%
6 5
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 144
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 24
16.7%
0 22
15.3%
3 21
14.6%
5 17
11.8%
9 11
7.6%
4 10
6.9%
7 10
6.9%
8 9
 
6.2%
2 8
 
5.6%
1 7
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 144
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 24
16.7%
0 22
15.3%
3 21
14.6%
5 17
11.8%
9 11
7.6%
4 10
6.9%
7 10
6.9%
8 9
 
6.2%
2 8
 
5.6%
1 7
 
4.9%

개업신고일
Date

Distinct41
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Memory size472.0 B
Minimum2003-09-06 00:00:00
Maximum2022-04-27 00:00:00
2024-04-21T17:58:40.757267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T17:58:41.160433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)

Correlations

2024-04-21T17:58:41.309897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명주소전화번호개업신고일
업체명1.0001.0001.0000.985
주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
개업신고일0.9851.0001.0001.000

Missing values

2024-04-21T17:58:35.282969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T17:58:35.561593image/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배영희행정사사무소대구광역시 동구 동내로 76， 102호(동내동)<NA>2022-04-27
1우리 행정사 사무소대구광역시 동구 동대구로 432， 국제오피스텔 1511호(신천동)<NA>2022-02-03
2김기대 행정사 사무소대구광역시 동구 아양로8길 4(신암동)053-943-9432022-01-24
3찰스행정사 사무소대구광역시 동구 신암로 132， 1층 11호(신암동， 신흥아파트)<NA>2022-01-13
4충효 행정사 사무소대구광역시 동구 동대구로 577， 110동 208호(신암동， 이안센트럴D)070-8832-20792022-01-20
5행정법률 광장 행정사사무소대구광역시 동구 동대구로 496， 301호(신천동)<NA>2021-07-30
6서현 행정사 사무소대구광역시 동구 공항로54길 51， 102동 1206호 (지저동， 태왕아너스리버파크)053-749-11702021-07-05
7수정원 행정사 사무소대구광역시 동구 방촌로1길 57 (방촌동)<NA>2021-06-12
8박희권 행정사 사무소대구광역시 동구 송라로32길 32， 104호 (신암동， 동대구 우방 아이유쉘)<NA>2021-06-12
9한반도 행정사 사무소대구광역시 동구 장등로 46， 601호 (신천동， 오성파크2차)<NA>2020-08-06
업체명주소전화번호개업신고일
33행정사이수철사무소대구광역시 동구 효동로1길 66 (효목동)053-957-60032012-09-03
34제일행정사사무소대구광역시 동구 화랑로73길 28-7 (방촌동)053-986-11042003-09-06
35김경수행정사사무소대구광역시 동구 동내로 76， 1층 104호(동내동)<NA>2021-10-19
36이재호행정사사무소대구광역시 동구 공항로50길 56-4 (지저동)<NA>2011-12-16
37김용덕행정사사무소대구광역시 동구 동촌로 68 (검사동)<NA>2012-01-03
38에브라임행정사사무소대구광역시 동구 동부로26길 58， 401호 (신천동， 삼광빌딩)<NA>2010-02-03
39김명환행정사사무소대구광역시 동구 신암북로 53-7， 409호 (신암동)<NA>2003-12-02
40박정훈행정사사무소대구광역시 동구 동촌로11길 5-25 (입석동)<NA>2004-04-27
41백안행정사사무소대구광역시 동구 팔공산로 1676 (백안동)<NA>2005-03-08
42대구창업센터송홍길대구광역시 동구 화랑로 427 (방촌동)<NA>2007-02-28