Overview

Dataset statistics

Number of variables3
Number of observations29
Missing cells3
Missing cells (%)3.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory828.0 B
Average record size in memory28.6 B

Variable types

Text3

Dataset

Description서울특별시 성동구 내에 위치한 행정사사무소 현황을 제공합니다. 업체명, 도로명주소, 전화번호 등의 정보를 포함하고 있습니다.
URLhttps://www.data.go.kr/data/15028790/fileData.do

Alerts

전화번호 has 3 (10.3%) missing valuesMissing
사무소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:13:59.420237
Analysis finished2023-12-12 07:13:59.778713
Duration0.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사무소명
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T16:13:59.952017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length10.034483
Min length5

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row행정서사 조한곤 사무소
2nd row이봉영행정사무소
3rd row한국행정사협회김용균행정사사무소
4th row행정사 김기찬사무소
5th row하이코리아 행정사사무소
ValueCountFrequency (%)
행정사사무소 12
21.1%
행정사 6
 
10.5%
행정사무소 3
 
5.3%
행정서사 1
 
1.8%
최정묵 1
 
1.8%
디암 1
 
1.8%
이스트 1
 
1.8%
추자 1
 
1.8%
박용선사무소 1
 
1.8%
성동행정사 1
 
1.8%
Other values (29) 29
50.9%
2023-12-12T16:14:00.374025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 52
17.9%
정 34
11.7%
행 30
 
10.3%
28
 
9.6%
무 27
 
9.3%
소 26
 
8.9%
박 5
 
1.7%
이 4
 
1.4%
영 4
 
1.4%
김 3
 
1.0%
Other values (67) 78
26.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 258
88.7%
Space Separator 28
 
9.6%
Decimal Number 3
 
1.0%
Open Punctuation 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 52
20.2%
정 34
13.2%
행 30
11.6%
무 27
 
10.5%
소 26
 
10.1%
박 5
 
1.9%
이 4
 
1.6%
영 4
 
1.6%
김 3
 
1.2%
한 3
 
1.2%
Other values (62) 70
27.1%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
9 1
33.3%
Space Separator
ValueCountFrequency (%)
28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 258
88.7%
Common 33
 
11.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 52
20.2%
정 34
13.2%
행 30
11.6%
무 27
 
10.5%
소 26
 
10.1%
박 5
 
1.9%
이 4
 
1.6%
영 4
 
1.6%
김 3
 
1.2%
한 3
 
1.2%
Other values (62) 70
27.1%
Common
ValueCountFrequency (%)
28
84.8%
1 2
 
6.1%
( 1
 
3.0%
) 1
 
3.0%
9 1
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 258
88.7%
ASCII 33
 
11.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 52
20.2%
정 34
13.2%
행 30
11.6%
무 27
 
10.5%
소 26
 
10.1%
박 5
 
1.9%
이 4
 
1.6%
영 4
 
1.6%
김 3
 
1.2%
한 3
 
1.2%
Other values (62) 70
27.1%
ASCII
ValueCountFrequency (%)
28
84.8%
1 2
 
6.1%
( 1
 
3.0%
) 1
 
3.0%
9 1
 
3.0%

도로명주소
Text

Distinct27
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T16:14:00.682064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length38
Mean length30.241379
Min length20

Characters and Unicode

Total characters877
Distinct characters95
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

Unique25 ?
Unique (%)86.2%

Sample

1st row서울시 성동구 왕십리광장로 10-1(행당동)
2nd row서울시 성동구 왕십리광장로 10-1(행당동)
3rd row서울시 성동구 마장로35길 68, 306호(마장동, MS빌딩)
4th row서울시 성동구 자동차시장1길 70(용답동)
5th row서울시 성동구 동일로 123(성수동2가, 선빌딩)
ValueCountFrequency (%)
서울시 29
 
18.7%
성동구 29
 
18.7%
왕십리광장로 4
 
2.6%
자동차시장1길 4
 
2.6%
왕십리로 3
 
1.9%
동일로 2
 
1.3%
아차산로17길 2
 
1.3%
70 2
 
1.3%
센트라스 2
 
1.3%
410 2
 
1.3%
Other values (72) 76
49.0%
2023-12-12T16:14:01.199241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
126
 
14.4%
동 72
 
8.2%
1 40
 
4.6%
성 39
 
4.4%
시 35
 
4.0%
서 30
 
3.4%
구 29
 
3.3%
) 29
 
3.3%
울 29
 
3.3%
( 29
 
3.3%
Other values (85) 419
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 506
57.7%
Decimal Number 149
 
17.0%
Space Separator 126
 
14.4%
Close Punctuation 29
 
3.3%
Open Punctuation 29
 
3.3%
Other Punctuation 26
 
3.0%
Dash Punctuation 7
 
0.8%
Uppercase Letter 5
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 72
 
14.2%
성 39
 
7.7%
시 35
 
6.9%
서 30
 
5.9%
구 29
 
5.7%
울 29
 
5.7%
로 23
 
4.5%
호 20
 
4.0%
가 13
 
2.6%
장 12
 
2.4%
Other values (66) 204
40.3%
Decimal Number
ValueCountFrequency (%)
1 40
26.8%
2 22
14.8%
0 21
14.1%
7 15
 
10.1%
3 14
 
9.4%
8 11
 
7.4%
5 10
 
6.7%
4 7
 
4.7%
9 5
 
3.4%
6 4
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
B 2
40.0%
I 1
20.0%
M 1
20.0%
S 1
20.0%
Space Separator
ValueCountFrequency (%)
126
100.0%
Close Punctuation
ValueCountFrequency (%)
) 29
100.0%
Open Punctuation
ValueCountFrequency (%)
( 29
100.0%
Other Punctuation
ValueCountFrequency (%)
, 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 506
57.7%
Common 366
41.7%
Latin 5
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 72
 
14.2%
성 39
 
7.7%
시 35
 
6.9%
서 30
 
5.9%
구 29
 
5.7%
울 29
 
5.7%
로 23
 
4.5%
호 20
 
4.0%
가 13
 
2.6%
장 12
 
2.4%
Other values (66) 204
40.3%
Common
ValueCountFrequency (%)
126
34.4%
1 40
 
10.9%
) 29
 
7.9%
( 29
 
7.9%
, 26
 
7.1%
2 22
 
6.0%
0 21
 
5.7%
7 15
 
4.1%
3 14
 
3.8%
8 11
 
3.0%
Other values (5) 33
 
9.0%
Latin
ValueCountFrequency (%)
B 2
40.0%
I 1
20.0%
M 1
20.0%
S 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 506
57.7%
ASCII 371
42.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
126
34.0%
1 40
 
10.8%
) 29
 
7.8%
( 29
 
7.8%
, 26
 
7.0%
2 22
 
5.9%
0 21
 
5.7%
7 15
 
4.0%
3 14
 
3.8%
8 11
 
3.0%
Other values (9) 38
 
10.2%
Hangul
ValueCountFrequency (%)
동 72
 
14.2%
성 39
 
7.7%
시 35
 
6.9%
서 30
 
5.9%
구 29
 
5.7%
울 29
 
5.7%
로 23
 
4.5%
호 20
 
4.0%
가 13
 
2.6%
장 12
 
2.4%
Other values (66) 204
40.3%

전화번호
Text

MISSING 

Distinct25
Distinct (%)96.2%
Missing3
Missing (%)10.3%
Memory size364.0 B
2023-12-12T16:14:01.443219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.730769
Min length11

Characters and Unicode

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

Unique24 ?
Unique (%)92.3%

Sample

1st row02-2297-9934
2nd row02-2297-5454
3rd row070-7628-7889
4th row02-780-1274
5th row02-461-8870
ValueCountFrequency (%)
02-415-5111 2
 
7.7%
02-878-2006 1
 
3.8%
02-2297-9934 1
 
3.8%
02-463-8129 1
 
3.8%
02-2293-6109 1
 
3.8%
02-2232-9388 1
 
3.8%
02-2293-4643 1
 
3.8%
02-463-1208 1
 
3.8%
02-2299-3266 1
 
3.8%
02-2287-4599 1
 
3.8%
Other values (15) 15
57.7%
2023-12-12T16:14:01.881950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 62
20.3%
- 52
17.0%
0 40
13.1%
1 22
 
7.2%
9 22
 
7.2%
7 21
 
6.9%
8 20
 
6.6%
3 20
 
6.6%
4 17
 
5.6%
5 17
 
5.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 253
83.0%
Dash Punctuation 52
 
17.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 62
24.5%
0 40
15.8%
1 22
 
8.7%
9 22
 
8.7%
7 21
 
8.3%
8 20
 
7.9%
3 20
 
7.9%
4 17
 
6.7%
5 17
 
6.7%
6 12
 
4.7%
Dash Punctuation
ValueCountFrequency (%)
- 52
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 305
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 62
20.3%
- 52
17.0%
0 40
13.1%
1 22
 
7.2%
9 22
 
7.2%
7 21
 
6.9%
8 20
 
6.6%
3 20
 
6.6%
4 17
 
5.6%
5 17
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 305
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 62
20.3%
- 52
17.0%
0 40
13.1%
1 22
 
7.2%
9 22
 
7.2%
7 21
 
6.9%
8 20
 
6.6%
3 20
 
6.6%
4 17
 
5.6%
5 17
 
5.6%

Correlations

2023-12-12T16:14:01.994164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사무소명도로명주소전화번호
사무소명1.0001.0001.000
도로명주소1.0001.0000.962
전화번호1.0000.9621.000

Missing values

2023-12-12T16:13:59.645483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:13:59.741971image/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행정서사 조한곤 사무소서울시 성동구 왕십리광장로 10-1(행당동)02-2297-9934
1이봉영행정사무소서울시 성동구 왕십리광장로 10-1(행당동)02-2297-5454
2한국행정사협회김용균행정사사무소서울시 성동구 마장로35길 68, 306호(마장동, MS빌딩)070-7628-7889
3행정사 김기찬사무소서울시 성동구 자동차시장1길 70(용답동)02-780-1274
4하이코리아 행정사사무소서울시 성동구 동일로 123(성수동2가, 선빌딩)02-461-8870
5삼정 행정사사무소서울시 성동구 광나루로8길 10(성수동2가, 에이스성수타워1)02-6959-2797
6다인솔루션 행정사 합동사무소서울시 성동구 고산자로 284, 308호(행당동, 성동샤르망)02-832-3877
7파크 행정사무소서울시 성동구 왕십리로 410, I동 177호(하왕십리동, 센트라스)02-2082-4535
8119 행정사무소서울시 성동구 자동차시장1길 70, B동 2층 나열 2-2호(용답동, 장안평중고자동차시장)02-732-4143
9박지영 행정사무소서울시 성동구 왕십리로 410, 6층 603호(도선동, 센트라스 153타워)02-3390-9973
사무소명도로명주소전화번호
19성동행정사서울시 성동구 왕십리광장로 8-1(행당동)02-2292-5261
20정남채 행정사사무소서울시 성동구 고산자로 203, 301호(행당동, 현농빌딩)02-2281-0074
21최정묵 행정사사무소(삼오사)서울시 성동구 왕십리로20길 34(홍익동)02-2287-4599
22행정사 박부근사무소서울시 성동구 행당로 1(금호동1가)02-2299-3266
23행정사 박의양사무소서울시 성동구 광나루로 291(송정동)02-463-1208
24성동 행정사사무소서울시 성동구 왕십리광장로 8-1(행당동)02-2293-4643
25행정사 신충호사무소서울시 성동구 동호로2길 17-9(금호동4가)02-2232-9388
26이윤영 법무행정사서울시 성동구 왕십리로 318, 401호(도선동, 명빌동)02-2293-6109
27정병일 행정사사무소서울시 성동구 금호산9가길 59-25, 101호(금호동2가, 금산빌라)<NA>
28청구행정사사무소서울시 성동구 자동차시장1길 18(용답동)02-3471-2115