Overview

Dataset statistics

Number of variables5
Number of observations22
Missing cells6
Missing cells (%)5.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1012.0 B
Average record size in memory46.0 B

Variable types

Text3
DateTime1
Categorical1

Dataset

Description대구광역시 중구 관내 업무신고를 한 행정사 현황에 대한 데이터로, 행정사 사무소 명칭, 주소, 전화번호, 개업신고일에 대한 자료를 제공합니다.
Author대구광역시 중구
URLhttps://www.data.go.kr/data/3075412/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 6 (27.3%) missing valuesMissing
사무소 명칭 has unique valuesUnique

Reproduction

Analysis started2023-12-12 03:02:01.343737
Analysis finished2023-12-12 03:02:01.862418
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사무소 명칭
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T12:02:02.034628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9.5
Mean length9.1818182
Min length7

Characters and Unicode

Total characters202
Distinct characters65
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row가교국제행정사사무소
2nd row김양식 행정사
3rd row마중행정사 사무소
4th row문성행정사사무소
5th row비상행정사사무소
ValueCountFrequency (%)
행정사 8
20.5%
사무소 6
 
15.4%
가교국제행정사사무소 1
 
2.6%
월드번역사무소 1
 
2.6%
행정사최규열사무소 1
 
2.6%
행정사이상무사무소 1
 
2.6%
어울림 1
 
2.6%
행정사법인 1
 
2.6%
손호경 1
 
2.6%
배춘봉사무소 1
 
2.6%
Other values (17) 17
43.6%
2023-12-12T12:02:02.517018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 34
16.8%
행 18
 
8.9%
정 18
 
8.9%
무 18
 
8.9%
소 18
 
8.9%
17
 
8.4%
역 4
 
2.0%
번 4
 
2.0%
국 3
 
1.5%
우 3
 
1.5%
Other values (55) 65
32.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 184
91.1%
Space Separator 17
 
8.4%
Other Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 34
18.5%
행 18
 
9.8%
정 18
 
9.8%
무 18
 
9.8%
소 18
 
9.8%
역 4
 
2.2%
번 4
 
2.2%
국 3
 
1.6%
우 3
 
1.6%
어 3
 
1.6%
Other values (53) 61
33.2%
Space Separator
ValueCountFrequency (%)
17
100.0%
Other Punctuation
ValueCountFrequency (%)
· 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 184
91.1%
Common 18
 
8.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 34
18.5%
행 18
 
9.8%
정 18
 
9.8%
무 18
 
9.8%
소 18
 
9.8%
역 4
 
2.2%
번 4
 
2.2%
국 3
 
1.6%
우 3
 
1.6%
어 3
 
1.6%
Other values (53) 61
33.2%
Common
ValueCountFrequency (%)
17
94.4%
· 1
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 184
91.1%
ASCII 17
 
8.4%
None 1
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 34
18.5%
행 18
 
9.8%
정 18
 
9.8%
무 18
 
9.8%
소 18
 
9.8%
역 4
 
2.2%
번 4
 
2.2%
국 3
 
1.6%
우 3
 
1.6%
어 3
 
1.6%
Other values (53) 61
33.2%
ASCII
ValueCountFrequency (%)
17
100.0%
None
ValueCountFrequency (%)
· 1
100.0%

소재지 도로명주소
Text

Distinct21
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T12:02:02.868470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length34.5
Mean length32.363636
Min length21

Characters and Unicode

Total characters712
Distinct characters70
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

Unique20 ?
Unique (%)90.9%

Sample

1st row대구광역시 중구 중앙대로 327-5(남산동)
2nd row대구광역시 중구 태평로 177， 2층 201호 (태평로1가， 태평라이프아파트)
3rd row대구광역시 중구 태평로 177， 태평라이프상가 2층 221호(태평로1가， 태평라이프아파트)
4th row대구광역시 중구 중앙대로 347 (남산동)
5th row대구광역시 중구 동덕로 115， 진석타워 309호 (삼덕동2가)
ValueCountFrequency (%)
대구광역시 22
 
16.5%
중구 22
 
16.5%
115， 5
 
3.8%
동덕로 5
 
3.8%
남산동 4
 
3.0%
태평로 4
 
3.0%
177， 4
 
3.0%
2층 4
 
3.0%
태평라이프아파트 4
 
3.0%
201호 2
 
1.5%
Other values (51) 57
42.9%
2023-12-12T12:02:03.348113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
111
 
15.6%
구 45
 
6.3%
1 39
 
5.5%
대 28
 
3.9%
2 28
 
3.9%
로 26
 
3.7%
동 26
 
3.7%
중 24
 
3.4%
광 23
 
3.2%
역 22
 
3.1%
Other values (60) 340
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 403
56.6%
Decimal Number 133
 
18.7%
Space Separator 111
 
15.6%
Open Punctuation 22
 
3.1%
Close Punctuation 22
 
3.1%
Other Punctuation 18
 
2.5%
Dash Punctuation 2
 
0.3%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 45
 
11.2%
대 28
 
6.9%
로 26
 
6.5%
동 26
 
6.5%
중 24
 
6.0%
광 23
 
5.7%
역 22
 
5.5%
시 22
 
5.5%
가 16
 
4.0%
평 15
 
3.7%
Other values (44) 156
38.7%
Decimal Number
ValueCountFrequency (%)
1 39
29.3%
2 28
21.1%
7 16
12.0%
3 11
 
8.3%
5 10
 
7.5%
0 9
 
6.8%
4 9
 
6.8%
8 6
 
4.5%
9 3
 
2.3%
6 2
 
1.5%
Space Separator
ValueCountFrequency (%)
111
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%
Other Punctuation
ValueCountFrequency (%)
， 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
M 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 403
56.6%
Common 308
43.3%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 45
 
11.2%
대 28
 
6.9%
로 26
 
6.5%
동 26
 
6.5%
중 24
 
6.0%
광 23
 
5.7%
역 22
 
5.5%
시 22
 
5.5%
가 16
 
4.0%
평 15
 
3.7%
Other values (44) 156
38.7%
Common
ValueCountFrequency (%)
111
36.0%
1 39
 
12.7%
2 28
 
9.1%
( 22
 
7.1%
) 22
 
7.1%
， 18
 
5.8%
7 16
 
5.2%
3 11
 
3.6%
5 10
 
3.2%
0 9
 
2.9%
Other values (5) 22
 
7.1%
Latin
ValueCountFrequency (%)
M 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 403
56.6%
ASCII 291
40.9%
None 18
 
2.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
111
38.1%
1 39
 
13.4%
2 28
 
9.6%
( 22
 
7.6%
) 22
 
7.6%
7 16
 
5.5%
3 11
 
3.8%
5 10
 
3.4%
0 9
 
3.1%
4 9
 
3.1%
Other values (5) 14
 
4.8%
Hangul
ValueCountFrequency (%)
구 45
 
11.2%
대 28
 
6.9%
로 26
 
6.5%
동 26
 
6.5%
중 24
 
6.0%
광 23
 
5.7%
역 22
 
5.5%
시 22
 
5.5%
가 16
 
4.0%
평 15
 
3.7%
Other values (44) 156
38.7%
None
ValueCountFrequency (%)
， 18
100.0%

전화번호
Text

MISSING 

Distinct16
Distinct (%)100.0%
Missing6
Missing (%)27.3%
Memory size308.0 B
2023-12-12T12:02:03.537348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.8125
Min length9

Characters and Unicode

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

Unique16 ?
Unique (%)100.0%

Sample

1st row053-746-8880
2nd row053-426-0986
3rd row053-424-3004
4th row053-425-0111
5th row053-255-3280
ValueCountFrequency (%)
053-571-5700 1
 
6.2%
053-426-0986 1
 
6.2%
053-424-3004 1
 
6.2%
053-425-0111 1
 
6.2%
053-255-3280 1
 
6.2%
053-323-6751 1
 
6.2%
1599-8723 1
 
6.2%
053-422-8690 1
 
6.2%
053-746-8880 1
 
6.2%
053-422-0191 1
 
6.2%
Other values (6) 6
37.5%
2023-12-12T12:02:04.126143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 31
16.4%
- 31
16.4%
0 25
13.2%
3 23
12.2%
2 18
9.5%
4 14
7.4%
8 13
6.9%
7 11
 
5.8%
1 11
 
5.8%
6 6
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 158
83.6%
Dash Punctuation 31
 
16.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 31
19.6%
0 25
15.8%
3 23
14.6%
2 18
11.4%
4 14
8.9%
8 13
8.2%
7 11
 
7.0%
1 11
 
7.0%
6 6
 
3.8%
9 6
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 189
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 31
16.4%
- 31
16.4%
0 25
13.2%
3 23
12.2%
2 18
9.5%
4 14
7.4%
8 13
6.9%
7 11
 
5.8%
1 11
 
5.8%
6 6
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 189
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 31
16.4%
- 31
16.4%
0 25
13.2%
3 23
12.2%
2 18
9.5%
4 14
7.4%
8 13
6.9%
7 11
 
5.8%
1 11
 
5.8%
6 6
 
3.2%

개업신고일자
Date

Distinct21
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
Minimum1989-05-26 00:00:00
Maximum2022-10-14 00:00:00
2023-12-12T12:02:04.246448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:02:04.361243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
2022-10-31
22 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-31
2nd row2022-10-31
3rd row2022-10-31
4th row2022-10-31
5th row2022-10-31

Common Values

ValueCountFrequency (%)
2022-10-31 22
100.0%

Length

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

Common Values (Plot)

2023-12-12T12:02:04.583998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-31 22
100.0%

Correlations

2023-12-12T12:02:04.647128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사무소 명칭소재지 도로명주소전화번호개업신고일자
사무소 명칭1.0001.0001.0001.000
소재지 도로명주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
개업신고일자1.0001.0001.0001.000

Missing values

2023-12-12T12:02:01.646003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:02:01.793683image/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가교국제행정사사무소대구광역시 중구 중앙대로 327-5(남산동)053-746-88802022-09-292022-10-31
1김양식 행정사대구광역시 중구 태평로 177， 2층 201호 (태평로1가， 태평라이프아파트)<NA>2019-01-042022-10-31
2마중행정사 사무소대구광역시 중구 태평로 177， 태평라이프상가 2층 221호(태평로1가， 태평라이프아파트)<NA>2021-07-302022-10-31
3문성행정사사무소대구광역시 중구 중앙대로 347 (남산동)<NA>2005-10-212022-10-31
4비상행정사사무소대구광역시 중구 동덕로 115， 진석타워 309호 (삼덕동2가)053-426-09862015-08-242022-10-31
5세종행정사사무소대구광역시 중구 큰장로24안길 42 (대신동)053-424-30042015-04-062022-10-31
6에덴외국어번역사무소대구광역시 중구 국채보상로125길 633 (공평동)053-425-01111989-05-262022-10-31
7여산 행정·문화연구소대구광역시 중구 남성로 14， 201호 (남성로)053-255-32802017-12-212022-10-31
8오병우외국어번역사무소대구광역시 중구 남산로 12 (남산동)053-323-67511999-05-102022-10-31
9우리 행정사 사무소대구광역시 중구 남산로 85， 대광M타워 4층 7호 (남산동)1599-87232021-01-142022-10-31
사무소 명칭소재지 도로명주소전화번호개업신고일자데이터기준일자
12참벗 행정사 사무소대구광역시 중구 동덕로 115， 902호 내 210(삼덕동2가)<NA>2022-04-012022-10-31
13창이 행정사 사무소대구광역시 중구 태평로 177， 태평라이프상가 2층 221호(태평로1가， 태평라이프아파트)<NA>2021-07-302022-10-31
14타임번역서비스대구광역시 중구 국채보상로 685 (동인동2가)053-422-86901991-10-252022-10-31
15행정사 김승한 사무소대구광역시 중구 태평로 177， 227-1호 (태평로1가， 태평라이프아파트 상가)053-422-01912017-02-272022-10-31
16행정사 배춘봉사무소대구광역시 중구 남산로3길 8 (남산동)053-581-53482012-12-122022-10-31
17행정사 손호경대구광역시 중구 달구벌대로447길 77， 101동 402호 (삼덕동3가， 삼덕청아람리슈빌아파트)053-742-82412008-11-282022-10-31
18행정사법인 어울림대구광역시 중구 동덕로 115， 1118호(삼덕동2가)053-255-13452021-08-262022-10-31
19행정사이상무사무소대구광역시 중구 동덕로 115， 1109호(삼덕동2가)053-255-58772022-09-082022-10-31
20행정사최규열사무소대구광역시 중구 국채보상로150길 38 (동인동4가)053-425-97771994-09-022022-10-31
21혜담 행정사 사무소대구광역시 중구 동덕로 115， 1313호(삼덕동2가)<NA>2022-10-142022-10-31