Overview

Dataset statistics

Number of variables4
Number of observations50
Missing cells7
Missing cells (%)3.5%
Duplicate rows1
Duplicate rows (%)2.0%
Total size in memory1.7 KiB
Average record size in memory34.6 B

Variable types

Text3
DateTime1

Dataset

Description대구광역시 수성구 행정사 사무소 현황_20180901
Author대구광역시 수성구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15028852&dataSetDetailId=15028852296d045f475b0&provdMethod=FILE

Alerts

Dataset has 1 (2.0%) duplicate rowsDuplicates
전화번호 has 7 (14.0%) missing valuesMissing

Reproduction

Analysis started2024-04-19 05:16:52.573236
Analysis finished2024-04-19 05:16:52.924588
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

명칭
Text

Distinct47
Distinct (%)94.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-04-19T14:16:53.057268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.8
Min length5

Characters and Unicode

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

Unique

Unique45 ?
Unique (%)90.0%

Sample

1st row일반행정서사이태근사무소
2nd row일반행정서사정관수사무소
3rd row일반행정사김무부사무소
4th row토탈행정사사무소
5th row일반행정서사이홍우사무소
ValueCountFrequency (%)
행정사 14
 
17.1%
사무소 9
 
11.0%
토탈행정사사무소 3
 
3.7%
행정사사무소 3
 
3.7%
행정사무소 3
 
3.7%
킹덤합동사무소 2
 
2.4%
샤머스 1
 
1.2%
정재도 1
 
1.2%
동반행정사사무소 1
 
1.2%
장원태 1
 
1.2%
Other values (44) 44
53.7%
2024-04-19T14:16:53.390568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 79
18.0%
정 48
 
10.9%
행 44
 
10.0%
무 41
 
9.3%
소 39
 
8.9%
32
 
7.3%
일 11
 
2.5%
반 9
 
2.0%
이 8
 
1.8%
서 6
 
1.4%
Other values (77) 123
28.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 408
92.7%
Space Separator 32
 
7.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 79
19.4%
정 48
11.8%
행 44
 
10.8%
무 41
 
10.0%
소 39
 
9.6%
일 11
 
2.7%
반 9
 
2.2%
이 8
 
2.0%
서 6
 
1.5%
김 6
 
1.5%
Other values (76) 117
28.7%
Space Separator
ValueCountFrequency (%)
32
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 408
92.7%
Common 32
 
7.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 79
19.4%
정 48
11.8%
행 44
 
10.8%
무 41
 
10.0%
소 39
 
9.6%
일 11
 
2.7%
반 9
 
2.2%
이 8
 
2.0%
서 6
 
1.5%
김 6
 
1.5%
Other values (76) 117
28.7%
Common
ValueCountFrequency (%)
32
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 408
92.7%
ASCII 32
 
7.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 79
19.4%
정 48
11.8%
행 44
 
10.8%
무 41
 
10.0%
소 39
 
9.6%
일 11
 
2.7%
반 9
 
2.2%
이 8
 
2.0%
서 6
 
1.5%
김 6
 
1.5%
Other values (76) 117
28.7%
ASCII
ValueCountFrequency (%)
32
100.0%

소재지
Text

Distinct40
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2024-04-19T14:16:53.640985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length49
Mean length29.34
Min length22

Characters and Unicode

Total characters1467
Distinct characters100
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

Unique34 ?
Unique (%)68.0%

Sample

1st row대구광역시 수성구 동대구로73길 5 (범어동)
2nd row대구광역시 수성구 교학로16길 22 (만촌동)
3rd row대구광역시 수성구 동대구로73길 5 (범어동)
4th row대구광역시 수성구 수성로76길 10 (수성동2가)
5th row대구광역시 수성구 상록로 43 (범어동)
ValueCountFrequency (%)
대구광역시 50
17.4%
수성구 50
17.4%
범어동 27
 
9.4%
동대구로 19
 
6.6%
수성동2가 5
 
1.7%
수성로76길 4
 
1.4%
10 4
 
1.4%
지범로 4
 
1.4%
신매동 3
 
1.0%
355 3
 
1.0%
Other values (101) 119
41.3%
2024-04-19T14:16:54.027649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
238
 
16.2%
구 127
 
8.7%
동 80
 
5.5%
대 77
 
5.2%
수 64
 
4.4%
성 64
 
4.4%
시 52
 
3.5%
( 50
 
3.4%
역 50
 
3.4%
광 50
 
3.4%
Other values (90) 615
41.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 857
58.4%
Decimal Number 239
 
16.3%
Space Separator 238
 
16.2%
Open Punctuation 50
 
3.4%
Close Punctuation 50
 
3.4%
Other Punctuation 26
 
1.8%
Dash Punctuation 7
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 127
14.8%
동 80
 
9.3%
대 77
 
9.0%
수 64
 
7.5%
성 64
 
7.5%
시 52
 
6.1%
역 50
 
5.8%
광 50
 
5.8%
로 50
 
5.8%
범 42
 
4.9%
Other values (75) 201
23.5%
Decimal Number
ValueCountFrequency (%)
1 44
18.4%
3 38
15.9%
6 26
10.9%
2 25
10.5%
5 24
10.0%
0 23
9.6%
7 22
9.2%
9 14
 
5.9%
4 14
 
5.9%
8 9
 
3.8%
Space Separator
ValueCountFrequency (%)
238
100.0%
Open Punctuation
ValueCountFrequency (%)
( 50
100.0%
Close Punctuation
ValueCountFrequency (%)
) 50
100.0%
Other Punctuation
ValueCountFrequency (%)
, 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 857
58.4%
Common 610
41.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 127
14.8%
동 80
 
9.3%
대 77
 
9.0%
수 64
 
7.5%
성 64
 
7.5%
시 52
 
6.1%
역 50
 
5.8%
광 50
 
5.8%
로 50
 
5.8%
범 42
 
4.9%
Other values (75) 201
23.5%
Common
ValueCountFrequency (%)
238
39.0%
( 50
 
8.2%
) 50
 
8.2%
1 44
 
7.2%
3 38
 
6.2%
6 26
 
4.3%
, 26
 
4.3%
2 25
 
4.1%
5 24
 
3.9%
0 23
 
3.8%
Other values (5) 66
 
10.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 857
58.4%
ASCII 610
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
238
39.0%
( 50
 
8.2%
) 50
 
8.2%
1 44
 
7.2%
3 38
 
6.2%
6 26
 
4.3%
, 26
 
4.3%
2 25
 
4.1%
5 24
 
3.9%
0 23
 
3.8%
Other values (5) 66
 
10.8%
Hangul
ValueCountFrequency (%)
구 127
14.8%
동 80
 
9.3%
대 77
 
9.0%
수 64
 
7.5%
성 64
 
7.5%
시 52
 
6.1%
역 50
 
5.8%
광 50
 
5.8%
로 50
 
5.8%
범 42
 
4.9%
Other values (75) 201
23.5%

신고연월일
Date

Distinct43
Distinct (%)86.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
Minimum1982-03-30 00:00:00
Maximum2017-04-27 00:00:00
2024-04-19T14:16:54.178768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-19T14:16:54.297091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)

전화번호
Text

MISSING 

Distinct41
Distinct (%)95.3%
Missing7
Missing (%)14.0%
Memory size532.0 B
2024-04-19T14:16:54.508101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.046512
Min length12

Characters and Unicode

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

Unique39 ?
Unique (%)90.7%

Sample

1st row053-753-1129
2nd row053-756-2820
3rd row053-754-5516
4th row053-756-0355
5th row053-746-7676
ValueCountFrequency (%)
053-753-3300 2
 
4.7%
053-745-3577 2
 
4.7%
070-4686-9493 1
 
2.3%
053-472-9999 1
 
2.3%
053-746-4141 1
 
2.3%
053-751-1097 1
 
2.3%
053-753-1129 1
 
2.3%
053-744-5518 1
 
2.3%
053-754-8010 1
 
2.3%
053-745-3838 1
 
2.3%
Other values (31) 31
72.1%
2024-04-19T14:16:54.811379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 86
16.6%
5 78
15.1%
3 71
13.7%
0 67
12.9%
7 55
10.6%
4 42
8.1%
1 31
 
6.0%
8 29
 
5.6%
6 20
 
3.9%
9 20
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 432
83.4%
Dash Punctuation 86
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 78
18.1%
3 71
16.4%
0 67
15.5%
7 55
12.7%
4 42
9.7%
1 31
 
7.2%
8 29
 
6.7%
6 20
 
4.6%
9 20
 
4.6%
2 19
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 86
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 518
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 86
16.6%
5 78
15.1%
3 71
13.7%
0 67
12.9%
7 55
10.6%
4 42
8.1%
1 31
 
6.0%
8 29
 
5.6%
6 20
 
3.9%
9 20
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 518
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 86
16.6%
5 78
15.1%
3 71
13.7%
0 67
12.9%
7 55
10.6%
4 42
8.1%
1 31
 
6.0%
8 29
 
5.6%
6 20
 
3.9%
9 20
 
3.9%

Correlations

2024-04-19T14:16:54.914933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
명칭소재지신고연월일전화번호
명칭1.0001.0000.9820.998
소재지1.0001.0000.9691.000
신고연월일0.9820.9691.0001.000
전화번호0.9981.0001.0001.000

Missing values

2024-04-19T14:16:52.820903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-19T14:16:52.895242image/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일반행정서사이태근사무소대구광역시 수성구 동대구로73길 5 (범어동)1996-02-16053-753-1129
1일반행정서사정관수사무소대구광역시 수성구 교학로16길 22 (만촌동)1998-06-15053-756-2820
2일반행정사김무부사무소대구광역시 수성구 동대구로73길 5 (범어동)1998-09-07053-754-5516
3토탈행정사사무소대구광역시 수성구 수성로76길 10 (수성동2가)1998-11-23<NA>
4일반행정서사이홍우사무소대구광역시 수성구 상록로 43 (범어동)1999-03-02053-756-0355
5김원형 행정사대구광역시 수성구 동대구로 355 (범어동)1999-09-29053-746-7676
6일반행정사임호대구광역시 수성구 동대구로 355 (범어동)2001-01-04053-764-4887
7시원 행정사대구광역시 수성구 동대구로 386 (범어동)2012-12-20053-243-5613
8행정사 김목진대구광역시 수성구 상화로 123-12 (두산동)2012-11-12<NA>
9배희건 행정사 사무소대구광역시 수성구 동대구로 355 (범어동)2012-12-04053-741-1738
명칭소재지신고연월일전화번호
40우리행정사박재순사무소대구광역시 수성구 무학로 117 (두산동)2015-08-04<NA>
41박경수 행정사사무소대구광역시 수성구 달구벌대로649길 6 (신매동)2016-04-08053-794-2828
42대경 행정사 사무소대구광역시 수성구 달구벌대로 2370 (범어동)2015-02-11<NA>
43동서번역사무소대구광역시 수성구 동대구로 359, 4층 (범어동)1986-03-11053-429-6049
44손기덕행정사사무소대구광역시 수성구 유니버시아드로 322-1, 3층 (욱수동)2017-01-13053-793-8440
45광명행정사사무소대구광역시 수성구 동대구로73길 31 (범어동)2017-03-28053-744-4552
46샤머스 인 행정사사무소대구광역시 수성구 지범로 50-3, 2층 (지산동)2017-03-29<NA>
47동반행정사사무소대구광역시 수성구 지범로 272, 5층 (범물동)2017-04-03070-4686-9493
48로앤 행정사사무소대구광역시 수성구 동대구로 354, 5층 505호 (범어동, 브라운스톤 범어)2017-04-27053-752-0048
49가람행정사사무소대구광역시 수성구 지범로39길 56, 상가동 3호 (범물동, 범물보성타운)2017-04-27053-782-8002

Duplicate rows

Most frequently occurring

명칭소재지신고연월일전화번호# duplicates
0킹덤합동사무소대구광역시 수성구 동대구로 386 (범어동)2012-12-07053-753-33002