Overview

Dataset statistics

Number of variables4
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)2.1%
Total size in memory1.6 KiB
Average record size in memory34.7 B

Variable types

Text2
DateTime1
Categorical1

Dataset

Description대구광역시 북구 관내에서 영업중인 행정사사무소 현황(업체명, 신고연월일, 소재지 주소)에 대한 정보를 제공합니다.
Author대구광역시 북구
URLhttps://www.data.go.kr/data/15028816/fileData.do

Alerts

데이터기준일 has constant value ""Constant
Dataset has 1 (2.1%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-14 09:33:50.342790
Analysis finished2024-03-14 09:33:51.335064
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

Distinct46
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-14T18:33:51.981770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length12
Mean length9.4375
Min length5

Characters and Unicode

Total characters453
Distinct characters94
Distinct categories6 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique45 ?
Unique (%)93.8%

Sample

1st row행정사 이종갑 사무소
2nd row김태봉행정사
3rd row이원탁 행정사사무소
4th row행정사 정원현 사무소
5th row합동행정사무소
ValueCountFrequency (%)
행정사 22
21.6%
사무소 15
 
14.7%
행정사사무소 5
 
4.9%
그루 3
 
2.9%
합동사무소 3
 
2.9%
세무회계 2
 
2.0%
행정사김진출사무소 1
 
1.0%
이병태 1
 
1.0%
문도영 1
 
1.0%
행정서비스 1
 
1.0%
Other values (48) 48
47.1%
2024-03-14T18:33:53.272961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 79
17.4%
54
11.9%
정 48
 
10.6%
행 44
 
9.7%
무 37
 
8.2%
소 34
 
7.5%
이 7
 
1.5%
동 6
 
1.3%
합 5
 
1.1%
영 5
 
1.1%
Other values (84) 134
29.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 392
86.5%
Space Separator 54
 
11.9%
Close Punctuation 2
 
0.4%
Open Punctuation 2
 
0.4%
Uppercase Letter 2
 
0.4%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 79
20.2%
정 48
 
12.2%
행 44
 
11.2%
무 37
 
9.4%
소 34
 
8.7%
이 7
 
1.8%
동 6
 
1.5%
합 5
 
1.3%
영 5
 
1.3%
성 4
 
1.0%
Other values (78) 123
31.4%
Uppercase Letter
ValueCountFrequency (%)
H 1
50.0%
J 1
50.0%
Space Separator
ValueCountFrequency (%)
54
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
？ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 391
86.3%
Common 59
 
13.0%
Latin 2
 
0.4%
Han 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 79
20.2%
정 48
 
12.3%
행 44
 
11.3%
무 37
 
9.5%
소 34
 
8.7%
이 7
 
1.8%
동 6
 
1.5%
합 5
 
1.3%
영 5
 
1.3%
성 4
 
1.0%
Other values (77) 122
31.2%
Common
ValueCountFrequency (%)
54
91.5%
) 2
 
3.4%
( 2
 
3.4%
？ 1
 
1.7%
Latin
ValueCountFrequency (%)
H 1
50.0%
J 1
50.0%
Han
ValueCountFrequency (%)
正 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 391
86.3%
ASCII 60
 
13.2%
None 1
 
0.2%
CJK 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 79
20.2%
정 48
 
12.3%
행 44
 
11.3%
무 37
 
9.5%
소 34
 
8.7%
이 7
 
1.8%
동 6
 
1.5%
합 5
 
1.3%
영 5
 
1.3%
성 4
 
1.0%
Other values (77) 122
31.2%
ASCII
ValueCountFrequency (%)
54
90.0%
) 2
 
3.3%
( 2
 
3.3%
H 1
 
1.7%
J 1
 
1.7%
None
ValueCountFrequency (%)
？ 1
100.0%
CJK
ValueCountFrequency (%)
正 1
100.0%

신고연월일
Date

Distinct36
Distinct (%)75.0%
Missing0
Missing (%)0.0%
Memory size512.0 B
Minimum1996-02-16 00:00:00
Maximum2023-12-04 00:00:00
2024-03-14T18:33:53.664800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:33:54.057431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)

소재지도로명주소
Text

Distinct45
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-14T18:33:55.386329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length39
Mean length31.291667
Min length21

Characters and Unicode

Total characters1502
Distinct characters108
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 (%)89.6%

Sample

1st row대구광역시 북구 대학로15길 17 (산격동)
2nd row대구광역시 북구 노원로 128 (노원동3가)
3rd row대구광역시 북구 칠성남로 225-1， A동 2층 제4호 (칠성동1가)
4th row대구광역시 북구 대현로 46 (대현동)
5th row대구광역시 북구 대현로 118-2 (대현동)
ValueCountFrequency (%)
대구광역시 48
 
15.9%
북구 48
 
15.9%
노원로 6
 
2.0%
노원동3가 6
 
2.0%
원대로 6
 
2.0%
86 3
 
1.0%
대현동 3
 
1.0%
109동 3
 
1.0%
대현로 3
 
1.0%
노원동1가 3
 
1.0%
Other values (149) 172
57.1%
2024-03-14T18:33:56.888570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
253
 
16.8%
구 98
 
6.5%
동 73
 
4.9%
1 72
 
4.8%
대 67
 
4.5%
0 50
 
3.3%
시 50
 
3.3%
북 50
 
3.3%
광 49
 
3.3%
( 48
 
3.2%
Other values (98) 692
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 819
54.5%
Decimal Number 280
 
18.6%
Space Separator 253
 
16.8%
Open Punctuation 48
 
3.2%
Close Punctuation 48
 
3.2%
Other Punctuation 46
 
3.1%
Dash Punctuation 5
 
0.3%
Uppercase Letter 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 98
 
12.0%
동 73
 
8.9%
대 67
 
8.2%
시 50
 
6.1%
북 50
 
6.1%
광 49
 
6.0%
로 48
 
5.9%
역 48
 
5.9%
원 28
 
3.4%
호 27
 
3.3%
Other values (81) 281
34.3%
Decimal Number
ValueCountFrequency (%)
1 72
25.7%
0 50
17.9%
2 40
14.3%
3 30
10.7%
5 20
 
7.1%
6 19
 
6.8%
9 19
 
6.8%
4 13
 
4.6%
8 10
 
3.6%
7 7
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
B 2
66.7%
A 1
33.3%
Space Separator
ValueCountFrequency (%)
253
100.0%
Open Punctuation
ValueCountFrequency (%)
( 48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 48
100.0%
Other Punctuation
ValueCountFrequency (%)
， 46
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 819
54.5%
Common 680
45.3%
Latin 3
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 98
 
12.0%
동 73
 
8.9%
대 67
 
8.2%
시 50
 
6.1%
북 50
 
6.1%
광 49
 
6.0%
로 48
 
5.9%
역 48
 
5.9%
원 28
 
3.4%
호 27
 
3.3%
Other values (81) 281
34.3%
Common
ValueCountFrequency (%)
253
37.2%
1 72
 
10.6%
0 50
 
7.4%
( 48
 
7.1%
) 48
 
7.1%
， 46
 
6.8%
2 40
 
5.9%
3 30
 
4.4%
5 20
 
2.9%
6 19
 
2.8%
Other values (5) 54
 
7.9%
Latin
ValueCountFrequency (%)
B 2
66.7%
A 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 819
54.5%
ASCII 637
42.4%
None 46
 
3.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
253
39.7%
1 72
 
11.3%
0 50
 
7.8%
( 48
 
7.5%
) 48
 
7.5%
2 40
 
6.3%
3 30
 
4.7%
5 20
 
3.1%
6 19
 
3.0%
9 19
 
3.0%
Other values (6) 38
 
6.0%
Hangul
ValueCountFrequency (%)
구 98
 
12.0%
동 73
 
8.9%
대 67
 
8.2%
시 50
 
6.1%
북 50
 
6.1%
광 49
 
6.0%
로 48
 
5.9%
역 48
 
5.9%
원 28
 
3.4%
호 27
 
3.3%
Other values (81) 281
34.3%
None
ValueCountFrequency (%)
， 46
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-01-09
48 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-09
2nd row2024-01-09
3rd row2024-01-09
4th row2024-01-09
5th row2024-01-09

Common Values

ValueCountFrequency (%)
2024-01-09 48
100.0%

Length

2024-03-14T18:33:57.178301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:33:57.470954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-09 48
100.0%

Correlations

2024-03-14T18:33:57.642107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명신고연월일소재지도로명주소
업체명1.0001.0001.000
신고연월일1.0001.0000.998
소재지도로명주소1.0000.9981.000

Missing values

2024-03-14T18:33:50.724790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T18:33:51.220276image/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행정사 이종갑 사무소1996-02-16대구광역시 북구 대학로15길 17 (산격동)2024-01-09
1김태봉행정사1996-04-01대구광역시 북구 노원로 128 (노원동3가)2024-01-09
2이원탁 행정사사무소2000-11-21대구광역시 북구 칠성남로 225-1， A동 2층 제4호 (칠성동1가)2024-01-09
3행정사 정원현 사무소2004-07-14대구광역시 북구 대현로 46 (대현동)2024-01-09
4합동행정사무소2006-03-16대구광역시 북구 대현로 118-2 (대현동)2024-01-09
5서정철 세무회계 사무소2008-11-28대구광역시 북구 원대로 91 (노원동1가)2024-01-09
6하영철 행정사사무소(토지수용보상센터)2009-10-05대구광역시 북구 동천로24길 9， 3층 (동천동)2024-01-09
7박준웅 행정사2010-08-02대구광역시 북구 칠곡중앙대로 549， 3층 (읍내동)2024-01-09
8김흥로 세무회계 사무소2010-12-07대구광역시 북구 원대로23길 2 (노원동1가)2024-01-09
9공익사업 토지 보상센터2012-05-23대구광역시 북구 동천로 156， 109동 1506호 (동천동)2024-01-09
업체명신고연월일소재지도로명주소데이터기준일
38행정사 차종석2023-01-26대구광역시 북구 팔달로 91， B동 201호(노원동3가)2024-01-09
39행정사 김？장 사무소2023-02-07대구광역시 북구 원대로 91， 2층(노원동1가)2024-01-09
40그루 행정사 합동사무소2023-02-10대구광역시 북구 노원로 86 (노원동3가)2024-01-09
41그루 행정사 합동사무소2023-02-10대구광역시 북구 노원로 86 (노원동3가)2024-01-09
42그루 행정사 합동사무소2023-02-10대구광역시 북구 노원로 86 (노원동3가)2024-01-09
43길 행정사 사무소2023-03-02대구광역시 북구 칠곡중앙대로53길 32， 103동 902호(태전동， 한일아파트)2024-01-09
44세종 행정사사무소2023-04-14대구광역시 북구 검단로 117， 상가동 지하층 007호 (검단동)2024-01-09
45JH행정사사무소2023-05-11대구광역시 북구 복현로 115， 101동 802호 (복현동， 복현현대맨션)2024-01-09
46류상국 행정사 사무소2023-07-04대구광역시 북구 노원로 115， 204호 (노원동3가)2024-01-09
47이음 행정사사무소2023-12-04대구광역시 북구 구암로 110， 4층 (태전동)2024-01-09

Duplicate rows

Most frequently occurring

업체명신고연월일소재지도로명주소데이터기준일# duplicates
0그루 행정사 합동사무소2023-02-10대구광역시 북구 노원로 86 (노원동3가)2024-01-093