Overview

Dataset statistics

Number of variables4
Number of observations39
Missing cells18
Missing cells (%)11.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory35.4 B

Variable types

Text3
DateTime1

Dataset

Description대구광역시 동구 관내 행정사사무소 현황 데이터입니다. 이 데이터는 상호명, 주소, 연락처, 개업신고일 등의 항목을 포함합니다.
Author대구광역시 동구
URLhttps://www.data.go.kr/data/15028795/fileData.do

Alerts

전화번호 has 18 (46.2%) missing valuesMissing
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:27:40.212669
Analysis finished2023-12-12 06:27:40.700940
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct38
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-12T15:27:40.899929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length10.102564
Min length5

Characters and Unicode

Total characters394
Distinct characters111
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

Unique37 ?
Unique (%)94.9%

Sample

1st rowE&F행정사사무소
2nd row가람행정사사무소
3rd row강라 행정사 사무소
4th row김명환행정사사무소
5th row대경연합행정사사무소
ValueCountFrequency (%)
사무소 10
 
14.9%
행정사 8
 
11.9%
행정사사무소 4
 
6.0%
대경연합행정사사무소 2
 
3.0%
정도 1
 
1.5%
정안행정사 1
 
1.5%
정해수행정사사무소 1
 
1.5%
제일행정사사무소 1
 
1.5%
찰스행정사 1
 
1.5%
충효행정 1
 
1.5%
Other values (37) 37
55.2%
2023-12-12T15:27:41.332018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 67
17.0%
정 44
 
11.2%
행 39
 
9.9%
무 33
 
8.4%
소 33
 
8.4%
28
 
7.1%
이 5
 
1.3%
수 4
 
1.0%
경 4
 
1.0%
김 4
 
1.0%
Other values (101) 133
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 336
85.3%
Space Separator 28
 
7.1%
Lowercase Letter 15
 
3.8%
Uppercase Letter 5
 
1.3%
Open Punctuation 3
 
0.8%
Close Punctuation 3
 
0.8%
Other Punctuation 2
 
0.5%
Dash Punctuation 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 67
19.9%
정 44
13.1%
행 39
 
11.6%
무 33
 
9.8%
소 33
 
9.8%
이 5
 
1.5%
수 4
 
1.2%
경 4
 
1.2%
김 4
 
1.2%
대 3
 
0.9%
Other values (81) 100
29.8%
Lowercase Letter
ValueCountFrequency (%)
a 3
20.0%
r 2
13.3%
e 2
13.3%
n 2
13.3%
u 1
 
6.7%
o 1
 
6.7%
s 1
 
6.7%
v 1
 
6.7%
i 1
 
6.7%
l 1
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
T 1
20.0%
W 1
20.0%
H 1
20.0%
E 1
20.0%
F 1
20.0%
Space Separator
ValueCountFrequency (%)
28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 336
85.3%
Common 38
 
9.6%
Latin 20
 
5.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 67
19.9%
정 44
13.1%
행 39
 
11.6%
무 33
 
9.8%
소 33
 
9.8%
이 5
 
1.5%
수 4
 
1.2%
경 4
 
1.2%
김 4
 
1.2%
대 3
 
0.9%
Other values (81) 100
29.8%
Latin
ValueCountFrequency (%)
a 3
15.0%
r 2
 
10.0%
e 2
 
10.0%
n 2
 
10.0%
u 1
 
5.0%
o 1
 
5.0%
T 1
 
5.0%
W 1
 
5.0%
s 1
 
5.0%
v 1
 
5.0%
Other values (5) 5
25.0%
Common
ValueCountFrequency (%)
28
73.7%
( 3
 
7.9%
) 3
 
7.9%
& 2
 
5.3%
- 2
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 336
85.3%
ASCII 58
 
14.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 67
19.9%
정 44
13.1%
행 39
 
11.6%
무 33
 
9.8%
소 33
 
9.8%
이 5
 
1.5%
수 4
 
1.2%
경 4
 
1.2%
김 4
 
1.2%
대 3
 
0.9%
Other values (81) 100
29.8%
ASCII
ValueCountFrequency (%)
28
48.3%
( 3
 
5.2%
) 3
 
5.2%
a 3
 
5.2%
& 2
 
3.4%
r 2
 
3.4%
- 2
 
3.4%
e 2
 
3.4%
n 2
 
3.4%
u 1
 
1.7%
Other values (10) 10
 
17.2%

주소
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-12T15:27:41.700476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length43
Mean length29.410256
Min length20

Characters and Unicode

Total characters1147
Distinct characters116
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

Unique39 ?
Unique (%)100.0%

Sample

1st row대구광역시 동구 동대구로 489， 대구무역회관 8층 (신천동)
2nd row대구광역시 동구 반야월로26길 58 (율하동)
3rd row대구광역시 동구 효동로 3， 2층 (효목동)
4th row대구광역시 동구 신암북로 53-7， 409호 (신암동)
5th row대구광역시 동구 동부로22길 60 (신천동)
ValueCountFrequency (%)
대구광역시 39
 
16.7%
동구 39
 
16.7%
방촌동 5
 
2.1%
동촌로 5
 
2.1%
2층 5
 
2.1%
1층 4
 
1.7%
신천동 4
 
1.7%
신암동 4
 
1.7%
동대구로 3
 
1.3%
아양로 3
 
1.3%
Other values (111) 123
52.6%
2023-12-12T15:27:42.223775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
195
17.0%
동 108
 
9.4%
구 84
 
7.3%
대 46
 
4.0%
역 40
 
3.5%
( 39
 
3.4%
광 39
 
3.4%
시 39
 
3.4%
) 39
 
3.4%
1 38
 
3.3%
Other values (106) 480
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 641
55.9%
Space Separator 195
 
17.0%
Decimal Number 190
 
16.6%
Open Punctuation 39
 
3.4%
Close Punctuation 39
 
3.4%
Other Punctuation 37
 
3.2%
Dash Punctuation 3
 
0.3%
Uppercase Letter 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 108
16.8%
구 84
13.1%
대 46
 
7.2%
역 40
 
6.2%
광 39
 
6.1%
시 39
 
6.1%
로 37
 
5.8%
호 21
 
3.3%
신 21
 
3.3%
층 15
 
2.3%
Other values (87) 191
29.8%
Decimal Number
ValueCountFrequency (%)
1 38
20.0%
2 30
15.8%
3 24
12.6%
0 18
9.5%
6 17
8.9%
7 15
 
7.9%
8 15
 
7.9%
5 14
 
7.4%
4 13
 
6.8%
9 6
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
K 1
33.3%
T 1
33.3%
D 1
33.3%
Other Punctuation
ValueCountFrequency (%)
， 36
97.3%
/ 1
 
2.7%
Space Separator
ValueCountFrequency (%)
195
100.0%
Open Punctuation
ValueCountFrequency (%)
( 39
100.0%
Close Punctuation
ValueCountFrequency (%)
) 39
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 641
55.9%
Common 503
43.9%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 108
16.8%
구 84
13.1%
대 46
 
7.2%
역 40
 
6.2%
광 39
 
6.1%
시 39
 
6.1%
로 37
 
5.8%
호 21
 
3.3%
신 21
 
3.3%
층 15
 
2.3%
Other values (87) 191
29.8%
Common
ValueCountFrequency (%)
195
38.8%
( 39
 
7.8%
) 39
 
7.8%
1 38
 
7.6%
， 36
 
7.2%
2 30
 
6.0%
3 24
 
4.8%
0 18
 
3.6%
6 17
 
3.4%
7 15
 
3.0%
Other values (6) 52
 
10.3%
Latin
ValueCountFrequency (%)
K 1
33.3%
T 1
33.3%
D 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 641
55.9%
ASCII 470
41.0%
None 36
 
3.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
195
41.5%
( 39
 
8.3%
) 39
 
8.3%
1 38
 
8.1%
2 30
 
6.4%
3 24
 
5.1%
0 18
 
3.8%
6 17
 
3.6%
7 15
 
3.2%
8 15
 
3.2%
Other values (8) 40
 
8.5%
Hangul
ValueCountFrequency (%)
동 108
16.8%
구 84
13.1%
대 46
 
7.2%
역 40
 
6.2%
광 39
 
6.1%
시 39
 
6.1%
로 37
 
5.8%
호 21
 
3.3%
신 21
 
3.3%
층 15
 
2.3%
Other values (87) 191
29.8%
None
ValueCountFrequency (%)
， 36
100.0%

전화번호
Text

MISSING 

Distinct21
Distinct (%)100.0%
Missing18
Missing (%)46.2%
Memory size444.0 B
2023-12-12T15:27:42.477951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.047619
Min length12

Characters and Unicode

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

Unique21 ?
Unique (%)100.0%

Sample

1st row053-955-2518
2nd row053-283-2483
3rd row053-941-9995
4th row053-982-4984
5th row053-247-5812
ValueCountFrequency (%)
053-955-2518 1
 
4.8%
053-965-4585 1
 
4.8%
053-951-6003 1
 
4.8%
053-216-1999 1
 
4.8%
053-945-5308 1
 
4.8%
053-710-7970 1
 
4.8%
053-215-5025 1
 
4.8%
053-268-8484 1
 
4.8%
053-981-9206 1
 
4.8%
053-742-5002 1
 
4.8%
Other values (11) 11
52.4%
2023-12-12T15:27:42.824027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 42
16.6%
5 38
15.0%
0 35
13.8%
3 26
10.3%
9 21
8.3%
2 21
8.3%
8 21
8.3%
1 16
 
6.3%
4 16
 
6.3%
7 11
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 211
83.4%
Dash Punctuation 42
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 38
18.0%
0 35
16.6%
3 26
12.3%
9 21
10.0%
2 21
10.0%
8 21
10.0%
1 16
7.6%
4 16
7.6%
7 11
 
5.2%
6 6
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 253
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 42
16.6%
5 38
15.0%
0 35
13.8%
3 26
10.3%
9 21
8.3%
2 21
8.3%
8 21
8.3%
1 16
 
6.3%
4 16
 
6.3%
7 11
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 253
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 42
16.6%
5 38
15.0%
0 35
13.8%
3 26
10.3%
9 21
8.3%
2 21
8.3%
8 21
8.3%
1 16
 
6.3%
4 16
 
6.3%
7 11
 
4.3%

개업신고일
Date

Distinct38
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2003-09-06 00:00:00
Maximum2023-09-13 00:00:00
2023-12-12T15:27:42.967421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:27:43.116267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

Correlations

2023-12-12T15:27:43.238091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명주소전화번호개업신고일
업체명1.0001.0001.0000.994
주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
개업신고일0.9941.0001.0001.000

Missing values

2023-12-12T15:27:40.564065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:27:40.662728image/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

업체명주소전화번호개업신고일
0E&F행정사사무소대구광역시 동구 동대구로 489， 대구무역회관 8층 (신천동)<NA>2019-05-08
1가람행정사사무소대구광역시 동구 반야월로26길 58 (율하동)053-955-25182017-11-13
2강라 행정사 사무소대구광역시 동구 효동로 3， 2층 (효목동)<NA>2023-09-04
3김명환행정사사무소대구광역시 동구 신암북로 53-7， 409호 (신암동)053-283-24832003-12-02
4대경연합행정사사무소대구광역시 동구 동부로22길 60 (신천동)<NA>2019-02-25
5대경연합행정사사무소대구광역시 동구 대현로 137， 2층 (신암동)053-941-99952021-03-26
6대구창업센터송홍길대구광역시 동구 화랑로 427 (방촌동)053-982-49842007-02-28
7동호행정사사무소대구광역시 동구 동호로 132， 308동 1209호 (신서동， 영조아름다운나날)<NA>2018-06-02
8박경진행정사사무소대구광역시 동구 방촌동 886번지 8호053-247-58122023-02-17
9박희권 행정사 사무소대구광역시 동구 송라로32길 32， 104호 (신암동， 동대구 우방 아이유쉘)053-941-74002021-06-12
업체명주소전화번호개업신고일
29토지보상전문컨설팅(정현필 행정사 사무소)대구광역시 동구 동호로3길 7， 3층(동호동)<NA>2022-12-20
30푸른행정사 김동호 사무소대구광역시 동구 동호로 47， 201동 1103호 (동호동， 상록아파트/상록아이투빌아파트)053-215-50252023-07-10
31하리버스(Ha-li-verse)대구광역시 동구 동부로 34， 1층 (신천동)<NA>2023-09-13
32한반도 행정사 사무소대구광역시 동구 장등로 46， 601호 (신천동， 오성파크2차)<NA>2020-08-06
33행정법률 광장 행정사사무소대구광역시 동구 동대구로 496， 301호(신천동)053-710-79702021-07-30
34행정사무소 민익대구광역시 동구 아양로 81， 105호(신암동， 호창메디타워) (신암동)053-945-53082023-08-08
35행정사사무소 동행대구광역시 동구 해동로 39(지저동)053-216-19992023-02-16
36행정사이수철사무소대구광역시 동구 효동로1길 66 (효목동)053-951-60032012-09-03
37김경수행정사사무소대구광역시 동구 동내로 76， 1층 104호(동내동)053-984-88522021-10-19
38김용덕행정사사무소대구광역시 동구 동촌로 68 (검사동)<NA>2012-01-03