Overview

Dataset statistics

Number of variables4
Number of observations136
Missing cells49
Missing cells (%)9.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory33.0 B

Variable types

Text3
DateTime1

Dataset

Description행정사법 제10조(행정사업의 신고)에 따른 행정사 업을 영위하고 있는 사무소의 목록으로 업체명,주소,전화번호,개업신고일 등의 정보를 나타냄
URLhttps://www.data.go.kr/data/15028752/fileData.do

Alerts

전화번호 has 49 (36.0%) missing valuesMissing

Reproduction

Analysis started2023-12-12 14:35:53.161281
Analysis finished2023-12-12 14:35:53.894747
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct135
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T23:35:54.112344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16
Mean length9.3823529
Min length2

Characters and Unicode

Total characters1276
Distinct characters203
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique134 ?
Unique (%)98.5%

Sample

1st row행정사서진원사무소
2nd row동반행정사사무소 경남지사
3rd row행정사 김종호사무소
4th row류판수행정사무소
5th row보광행정사사무소
ValueCountFrequency (%)
사무소 22
 
10.7%
행정사 20
 
9.7%
행정사사무소 14
 
6.8%
조우국제행정사무소 2
 
1.0%
창원 2
 
1.0%
한림행정사사무소 1
 
0.5%
리걸행정사사무소 1
 
0.5%
밝은행정사 1
 
0.5%
행정사성영도사무소 1
 
0.5%
세계로행정사사무소 1
 
0.5%
Other values (141) 141
68.4%
2023-12-12T23:35:54.581341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
238
18.7%
139
 
10.9%
131
 
10.3%
128
 
10.0%
126
 
9.9%
70
 
5.5%
12
 
0.9%
10
 
0.8%
10
 
0.8%
10
 
0.8%
Other values (193) 402
31.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1186
92.9%
Space Separator 70
 
5.5%
Uppercase Letter 7
 
0.5%
Open Punctuation 3
 
0.2%
Close Punctuation 3
 
0.2%
Decimal Number 3
 
0.2%
Lowercase Letter 3
 
0.2%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
238
20.1%
139
 
11.7%
131
 
11.0%
128
 
10.8%
126
 
10.6%
12
 
1.0%
10
 
0.8%
10
 
0.8%
10
 
0.8%
10
 
0.8%
Other values (177) 372
31.4%
Uppercase Letter
ValueCountFrequency (%)
S 2
28.6%
O 1
14.3%
B 1
14.3%
J 1
14.3%
Y 1
14.3%
K 1
14.3%
Decimal Number
ValueCountFrequency (%)
3 1
33.3%
5 1
33.3%
6 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
o 1
33.3%
r 1
33.3%
p 1
33.3%
Space Separator
ValueCountFrequency (%)
70
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1184
92.8%
Common 80
 
6.3%
Latin 10
 
0.8%
Han 2
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
238
20.1%
139
 
11.7%
131
 
11.1%
128
 
10.8%
126
 
10.6%
12
 
1.0%
10
 
0.8%
10
 
0.8%
10
 
0.8%
10
 
0.8%
Other values (175) 370
31.2%
Latin
ValueCountFrequency (%)
S 2
20.0%
O 1
10.0%
B 1
10.0%
J 1
10.0%
o 1
10.0%
r 1
10.0%
p 1
10.0%
Y 1
10.0%
K 1
10.0%
Common
ValueCountFrequency (%)
70
87.5%
( 3
 
3.8%
) 3
 
3.8%
3 1
 
1.2%
5 1
 
1.2%
6 1
 
1.2%
& 1
 
1.2%
Han
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1184
92.8%
ASCII 90
 
7.1%
CJK 2
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
238
20.1%
139
 
11.7%
131
 
11.1%
128
 
10.8%
126
 
10.6%
12
 
1.0%
10
 
0.8%
10
 
0.8%
10
 
0.8%
10
 
0.8%
Other values (175) 370
31.2%
ASCII
ValueCountFrequency (%)
70
77.8%
( 3
 
3.3%
) 3
 
3.3%
S 2
 
2.2%
3 1
 
1.1%
5 1
 
1.1%
6 1
 
1.1%
O 1
 
1.1%
B 1
 
1.1%
J 1
 
1.1%
Other values (6) 6
 
6.7%
CJK
ValueCountFrequency (%)
1
50.0%
1
50.0%

주소
Text

Distinct134
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-12-12T23:35:55.107123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length47
Mean length34.419118
Min length22

Characters and Unicode

Total characters4681
Distinct characters183
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

Unique132 ?
Unique (%)97.1%

Sample

1st row경상남도 창원시 성산구 원이대로393번길 32 (반지동)
2nd row경상남도 창원시 성산구 창원대로 726, 11-4호 (내동, 내동상가아파트)
3rd row경상남도 창원시 성산구 용지로 151, 502호(용호동)
4th row경상남도 창원시 성산구 동산로220번길 29 (사파동, 은하빌딩 1층)
5th row경상남도 창원시 성산구 동산로220번길 33 (사파동, 경희빌딩)
ValueCountFrequency (%)
경상남도 136
 
14.7%
창원시 136
 
14.7%
마산합포구 41
 
4.4%
성산구 40
 
4.3%
의창구 23
 
2.5%
마산회원구 20
 
2.2%
진해구 12
 
1.3%
장군동4가 10
 
1.1%
사파동 10
 
1.1%
동산로220번길 8
 
0.9%
Other values (386) 490
52.9%
2023-12-12T23:35:55.886229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
792
 
16.9%
181
 
3.9%
180
 
3.8%
172
 
3.7%
1 156
 
3.3%
153
 
3.3%
152
 
3.2%
143
 
3.1%
141
 
3.0%
141
 
3.0%
Other values (173) 2470
52.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2792
59.6%
Space Separator 792
 
16.9%
Decimal Number 730
 
15.6%
Open Punctuation 114
 
2.4%
Close Punctuation 114
 
2.4%
Other Punctuation 92
 
2.0%
Dash Punctuation 31
 
0.7%
Uppercase Letter 16
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
181
 
6.5%
180
 
6.4%
172
 
6.2%
153
 
5.5%
152
 
5.4%
143
 
5.1%
141
 
5.1%
141
 
5.1%
138
 
4.9%
118
 
4.2%
Other values (146) 1273
45.6%
Uppercase Letter
ValueCountFrequency (%)
T 3
18.8%
N 2
12.5%
E 2
12.5%
A 2
12.5%
O 1
 
6.2%
H 1
 
6.2%
B 1
 
6.2%
P 1
 
6.2%
S 1
 
6.2%
X 1
 
6.2%
Decimal Number
ValueCountFrequency (%)
1 156
21.4%
2 122
16.7%
0 87
11.9%
3 85
11.6%
4 62
 
8.5%
5 56
 
7.7%
6 47
 
6.4%
9 41
 
5.6%
7 40
 
5.5%
8 34
 
4.7%
Other Punctuation
ValueCountFrequency (%)
86
93.5%
· 6
 
6.5%
Space Separator
ValueCountFrequency (%)
792
100.0%
Open Punctuation
ValueCountFrequency (%)
( 114
100.0%
Close Punctuation
ValueCountFrequency (%)
) 114
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 31
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2792
59.6%
Common 1873
40.0%
Latin 16
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
181
 
6.5%
180
 
6.4%
172
 
6.2%
153
 
5.5%
152
 
5.4%
143
 
5.1%
141
 
5.1%
141
 
5.1%
138
 
4.9%
118
 
4.2%
Other values (146) 1273
45.6%
Common
ValueCountFrequency (%)
792
42.3%
1 156
 
8.3%
2 122
 
6.5%
( 114
 
6.1%
) 114
 
6.1%
0 87
 
4.6%
86
 
4.6%
3 85
 
4.5%
4 62
 
3.3%
5 56
 
3.0%
Other values (6) 199
 
10.6%
Latin
ValueCountFrequency (%)
T 3
18.8%
N 2
12.5%
E 2
12.5%
A 2
12.5%
O 1
 
6.2%
H 1
 
6.2%
B 1
 
6.2%
P 1
 
6.2%
S 1
 
6.2%
X 1
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2792
59.6%
ASCII 1797
38.4%
None 92
 
2.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
792
44.1%
1 156
 
8.7%
2 122
 
6.8%
( 114
 
6.3%
) 114
 
6.3%
0 87
 
4.8%
3 85
 
4.7%
4 62
 
3.5%
5 56
 
3.1%
6 47
 
2.6%
Other values (15) 162
 
9.0%
Hangul
ValueCountFrequency (%)
181
 
6.5%
180
 
6.4%
172
 
6.2%
153
 
5.5%
152
 
5.4%
143
 
5.1%
141
 
5.1%
141
 
5.1%
138
 
4.9%
118
 
4.2%
Other values (146) 1273
45.6%
None
ValueCountFrequency (%)
86
93.5%
· 6
 
6.5%

전화번호
Text

MISSING 

Distinct82
Distinct (%)94.3%
Missing49
Missing (%)36.0%
Memory size1.2 KiB
2023-12-12T23:35:56.288256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.16092
Min length1

Characters and Unicode

Total characters971
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique81 ?
Unique (%)93.1%

Sample

1st row070-4226-3344
2nd row055-267-6782
3rd row055-275-6789
4th row055-263-5000
5th row055-264-8555
ValueCountFrequency (%)
055-294-1250 1
 
1.2%
055-543-6678 1
 
1.2%
055-224-1288 1
 
1.2%
055-266-9900 1
 
1.2%
070-7431-8007 1
 
1.2%
055-247-5089 1
 
1.2%
055-256-2325 1
 
1.2%
055-224-4090 1
 
1.2%
055-245-4809 1
 
1.2%
055-545-4960 1
 
1.2%
Other values (71) 71
87.7%
2023-12-12T23:35:56.858332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 199
20.5%
- 158
16.3%
0 133
13.7%
2 130
13.4%
6 64
 
6.6%
4 57
 
5.9%
3 52
 
5.4%
7 47
 
4.8%
1 45
 
4.6%
8 42
 
4.3%
Other values (2) 44
 
4.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 807
83.1%
Dash Punctuation 158
 
16.3%
Space Separator 6
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 199
24.7%
0 133
16.5%
2 130
16.1%
6 64
 
7.9%
4 57
 
7.1%
3 52
 
6.4%
7 47
 
5.8%
1 45
 
5.6%
8 42
 
5.2%
9 38
 
4.7%
Dash Punctuation
ValueCountFrequency (%)
- 158
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 971
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 199
20.5%
- 158
16.3%
0 133
13.7%
2 130
13.4%
6 64
 
6.6%
4 57
 
5.9%
3 52
 
5.4%
7 47
 
4.8%
1 45
 
4.6%
8 42
 
4.3%
Other values (2) 44
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 971
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 199
20.5%
- 158
16.3%
0 133
13.7%
2 130
13.4%
6 64
 
6.6%
4 57
 
5.9%
3 52
 
5.4%
7 47
 
4.8%
1 45
 
4.6%
8 42
 
4.3%
Other values (2) 44
 
4.5%
Distinct119
Distinct (%)87.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum1995-10-25 00:00:00
Maximum2023-06-19 00:00:00
2023-12-12T23:35:57.059989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:35:57.218873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Missing values

2023-12-12T23:35:53.422568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:35:53.854491image/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행정사서진원사무소경상남도 창원시 성산구 원이대로393번길 32 (반지동)070-4226-33442009-04-09
1동반행정사사무소 경남지사경상남도 창원시 성산구 창원대로 726, 11-4호 (내동, 내동상가아파트)<NA>2023-05-26
2행정사 김종호사무소경상남도 창원시 성산구 용지로 151, 502호(용호동)055-267-67822021-12-15
3류판수행정사무소경상남도 창원시 성산구 동산로220번길 29 (사파동, 은하빌딩 1층)<NA>2009-10-12
4보광행정사사무소경상남도 창원시 성산구 동산로220번길 33 (사파동, 경희빌딩)055-275-67891998-09-07
5동효창행정사사무소경상남도 창원시 성산구 창이대로684번길 6 (사파동)055-263-50001996-07-08
6창원비자번역행정사사무소경상남도 창원시 성산구 연덕로184번길 48, 공단상가 104호 (내동)055-264-85552023-05-23
7행정사 신용대 사무소경상남도 창원시 성산구 창원천로94번길 19, 104동 1606호 (대원동)2023-05-10
8김정완 행정사 사무소경상남도 창원시 성산구 중앙대로 33, 대흥인터빌 제1513호(중앙동 101-2) (중앙동)<NA>2023-06-19
9출입국전문 행정사경상남도 창원시 마산합포구 중앙동로 10, 2층(중앙동2가, 중앙우방아파트)<NA>2023-02-16
업체명주소전화번호개업신고일
126행정사김영규사무소경상남도 창원시 마산합포구 완월동7길 10-1 (중앙동3가)055-244-76171995-10-25
127삼주행정사무소경상남도 창원시 마산합포구 상남동 11번지 6호 비잔틴빌딩 808호<NA>2011-09-26
128거림행정사사무소경상남도 창원시 성산구 가양로 97, 103호 (남양동, 개나리아파트)2003-09-30
129허남칠행정사사무소경상남도 창원시 성산구 비음로4번길 35-1 (사파동)1999-02-18
130산림행정사사무소경상남도 창원시 의창구 남산로9번길 9, 101호 (팔용동, 동광아트빌)055-252-67032011-11-22
131스피드행정사사무소경상남도 창원시 의창구 북면 천주로 1291-20<NA>2011-03-11
132이영주행정사사무소경상남도 창원시 의창구 도계로 135 (명서동)055-288-60342003-07-29
133숙철행정사사무소경상남도 창원시 성산구 상남로216번길 1(신월동)<NA>2021-12-15
134경남행정심판사무소경상남도 창원시 성산구 신월로 42, 425호(신월동)<NA>2021-12-15
135이우형행정사사무소경상남도 창원시 의창구 원이대로55번길 21-6 (도계동)<NA>2003-12-16