Overview

Dataset statistics

Number of variables4
Number of observations21
Missing cells4
Missing cells (%)4.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory804.0 B
Average record size in memory38.3 B

Variable types

Text3
DateTime1

Dataset

Description부산광역시금정구행정사사무소현황_20230905
Author부산광역시 금정구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15028822

Alerts

전화번호 has 4 (19.0%) missing valuesMissing
업체명 has unique valuesUnique
주소 has unique valuesUnique
개업신고일 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:51:34.594878
Analysis finished2023-12-10 16:51:34.943726
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-11T01:51:35.078399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length10
Mean length7.9047619
Min length5

Characters and Unicode

Total characters166
Distinct characters60
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

Unique21 ?
Unique (%)100.0%

Sample

1st row바른행정사사무소
2nd row행정사무소 동승
3rd row이광호 행정사 사무소
4th row염인출 행정사 공인중개사사무소
5th row승룡사무소
ValueCountFrequency (%)
행정사 3
 
11.1%
바른행정사사무소 1
 
3.7%
다감행정사 1
 
3.7%
변천수 1
 
3.7%
배현지사무소 1
 
3.7%
행정사김철성사무소 1
 
3.7%
김형주행정사 1
 
3.7%
행정사감병기사무소 1
 
3.7%
박준목사무소 1
 
3.7%
배인근행정사사무소 1
 
3.7%
Other values (15) 15
55.6%
2023-12-11T01:51:35.428862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
33
19.9%
17
 
10.2%
17
 
10.2%
15
 
9.0%
15
 
9.0%
6
 
3.6%
3
 
1.8%
3
 
1.8%
2
 
1.2%
2
 
1.2%
Other values (50) 53
31.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 160
96.4%
Space Separator 6
 
3.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
33
20.6%
17
 
10.6%
17
 
10.6%
15
 
9.4%
15
 
9.4%
3
 
1.9%
3
 
1.9%
2
 
1.2%
2
 
1.2%
2
 
1.2%
Other values (49) 51
31.9%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 160
96.4%
Common 6
 
3.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
33
20.6%
17
 
10.6%
17
 
10.6%
15
 
9.4%
15
 
9.4%
3
 
1.9%
3
 
1.9%
2
 
1.2%
2
 
1.2%
2
 
1.2%
Other values (49) 51
31.9%
Common
ValueCountFrequency (%)
6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 160
96.4%
ASCII 6
 
3.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
33
20.6%
17
 
10.6%
17
 
10.6%
15
 
9.4%
15
 
9.4%
3
 
1.9%
3
 
1.9%
2
 
1.2%
2
 
1.2%
2
 
1.2%
Other values (49) 51
31.9%
ASCII
ValueCountFrequency (%)
6
100.0%

주소
Text

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2023-12-11T01:51:35.666518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length38
Mean length30.571429
Min length20

Characters and Unicode

Total characters642
Distinct characters82
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

Unique21 ?
Unique (%)100.0%

Sample

1st row부산광역시 금정구 동부곡로15번길 110, 501호(부곡동, 한보아파트)
2nd row부산광역시 금정구 기찰로102번길 32, 402호(부곡동, 비스타빌)
3rd row부산광역시 금정구 청룡로 42, 103-1호(청룡동, 금정 더 유엘 프리미어)
4th row부산광역시 금정구 금정로 62, 청암타워 지하1층 (장전동)
5th row부산광역시 금정구 서동로175번길 25-4(서동, 대영주택)
ValueCountFrequency (%)
부산광역시 21
 
17.8%
금정구 21
 
17.8%
부곡동 4
 
3.4%
구서동 3
 
2.5%
장전동 2
 
1.7%
2층 2
 
1.7%
구서중앙로 2
 
1.7%
5 2
 
1.7%
구서로 2
 
1.7%
금강로 2
 
1.7%
Other values (57) 57
48.3%
2023-12-11T01:51:36.022184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
97
 
15.1%
34
 
5.3%
33
 
5.1%
26
 
4.0%
26
 
4.0%
23
 
3.6%
23
 
3.6%
21
 
3.3%
21
 
3.3%
21
 
3.3%
Other values (72) 317
49.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 384
59.8%
Decimal Number 101
 
15.7%
Space Separator 97
 
15.1%
Close Punctuation 20
 
3.1%
Open Punctuation 20
 
3.1%
Other Punctuation 16
 
2.5%
Dash Punctuation 3
 
0.5%
Uppercase Letter 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
34
 
8.9%
33
 
8.6%
26
 
6.8%
26
 
6.8%
23
 
6.0%
23
 
6.0%
21
 
5.5%
21
 
5.5%
21
 
5.5%
21
 
5.5%
Other values (56) 135
35.2%
Decimal Number
ValueCountFrequency (%)
1 20
19.8%
2 19
18.8%
5 15
14.9%
0 13
12.9%
3 8
 
7.9%
6 7
 
6.9%
4 7
 
6.9%
7 6
 
5.9%
9 4
 
4.0%
8 2
 
2.0%
Space Separator
ValueCountFrequency (%)
97
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Other Punctuation
ValueCountFrequency (%)
, 16
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 384
59.8%
Common 257
40.0%
Latin 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
34
 
8.9%
33
 
8.6%
26
 
6.8%
26
 
6.8%
23
 
6.0%
23
 
6.0%
21
 
5.5%
21
 
5.5%
21
 
5.5%
21
 
5.5%
Other values (56) 135
35.2%
Common
ValueCountFrequency (%)
97
37.7%
) 20
 
7.8%
( 20
 
7.8%
1 20
 
7.8%
2 19
 
7.4%
, 16
 
6.2%
5 15
 
5.8%
0 13
 
5.1%
3 8
 
3.1%
6 7
 
2.7%
Other values (5) 22
 
8.6%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 384
59.8%
ASCII 258
40.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
97
37.6%
) 20
 
7.8%
( 20
 
7.8%
1 20
 
7.8%
2 19
 
7.4%
, 16
 
6.2%
5 15
 
5.8%
0 13
 
5.0%
3 8
 
3.1%
6 7
 
2.7%
Other values (6) 23
 
8.9%
Hangul
ValueCountFrequency (%)
34
 
8.9%
33
 
8.6%
26
 
6.8%
26
 
6.8%
23
 
6.0%
23
 
6.0%
21
 
5.5%
21
 
5.5%
21
 
5.5%
21
 
5.5%
Other values (56) 135
35.2%

전화번호
Text

MISSING 

Distinct17
Distinct (%)100.0%
Missing4
Missing (%)19.0%
Memory size300.0 B
2023-12-11T01:51:36.204326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique17 ?
Unique (%)100.0%

Sample

1st row051-581-3622
2nd row051-508-4006
3rd row051-581-7292
4th row051-581-9614
5th row051-515-6001
ValueCountFrequency (%)
051-581-3622 1
 
5.9%
051-504-1966 1
 
5.9%
051-466-2122 1
 
5.9%
051-515-8986 1
 
5.9%
051-515-4286 1
 
5.9%
051-515-8015 1
 
5.9%
051-514-0293 1
 
5.9%
051-518-6800 1
 
5.9%
051-515-3411 1
 
5.9%
051-508-4006 1
 
5.9%
Other values (7) 7
41.2%
2023-12-11T01:51:36.514131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 45
22.1%
1 37
18.1%
- 34
16.7%
0 31
15.2%
2 14
 
6.9%
6 12
 
5.9%
8 11
 
5.4%
4 8
 
3.9%
9 7
 
3.4%
3 4
 
2.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 170
83.3%
Dash Punctuation 34
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 45
26.5%
1 37
21.8%
0 31
18.2%
2 14
 
8.2%
6 12
 
7.1%
8 11
 
6.5%
4 8
 
4.7%
9 7
 
4.1%
3 4
 
2.4%
7 1
 
0.6%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 204
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 45
22.1%
1 37
18.1%
- 34
16.7%
0 31
15.2%
2 14
 
6.9%
6 12
 
5.9%
8 11
 
5.4%
4 8
 
3.9%
9 7
 
3.4%
3 4
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 204
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 45
22.1%
1 37
18.1%
- 34
16.7%
0 31
15.2%
2 14
 
6.9%
6 12
 
5.9%
8 11
 
5.4%
4 8
 
3.9%
9 7
 
3.4%
3 4
 
2.0%

개업신고일
Date

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
Minimum1999-06-05 00:00:00
Maximum2023-06-09 00:00:00
2023-12-11T01:51:36.639790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:51:36.769384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

Correlations

2023-12-11T01:51:36.868236image/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-11T01:51:34.793131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:51:34.902915image/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바른행정사사무소부산광역시 금정구 동부곡로15번길 110, 501호(부곡동, 한보아파트)051-581-36222022-05-30
1행정사무소 동승부산광역시 금정구 기찰로102번길 32, 402호(부곡동, 비스타빌)<NA>2022-08-18
2이광호 행정사 사무소부산광역시 금정구 청룡로 42, 103-1호(청룡동, 금정 더 유엘 프리미어)051-508-40062022-09-01
3염인출 행정사 공인중개사사무소부산광역시 금정구 금정로 62, 청암타워 지하1층 (장전동)051-581-72922023-06-09
4승룡사무소부산광역시 금정구 서동로175번길 25-4(서동, 대영주택)<NA>1999-11-23
5행정사임순옥사무소부산광역시 금정구 부곡온천천로 202 (구서동, 남영하이빌)051-581-96142012-12-28
6종로행정사부산광역시 금정구 구서로 7(구서동)051-515-60012009-03-04
7한국번역센터부산광역시 금정구 중앙대로 1961(구서동)<NA>2007-06-14
8행정사조익선사무소부산광역시 금정구 금강로 308 (장전동)051-515-22022018-05-08
9다감행정사부산광역시 금정구 동현로39번길 34 (부곡동)051-515-59552021-02-15
업체명주소전화번호개업신고일
11김재섭행정사사무소부산광역시 금정구 구서중앙로 5, B동 5층 506호(구서동,부일산호맨션)<NA>2019-11-18
12미루행정사부산광역시 금정구 금강로 460 (구서동)051-515-34112011-03-28
13배인근행정사사무소부산광역시 금정구 부곡로42번길 83 (부곡동)051-504-19662012-08-09
14박준목사무소부산광역시 금정구 동부곡로47번길 11 (부곡동)051-518-68001999-06-05
15행정사감병기사무소부산광역시 금정구 중앙대로2007번길 17, 2층 (남산동)051-514-02932012-06-26
16김형주행정사부산광역시 금정구 구서중앙로 52, 7동 905호 (구서동, 우성아파트)051-515-80151999-06-14
17행정사김철성사무소부산광역시 금정구 체육공원로 126(구서동)051-515-42862010-11-03
18배현지사무소부산광역시 금정구 금강로555번길 25(구서동)051-515-89862000-10-25
19변천수 행정사부산광역시 금정구 부곡로 152-1 (부곡동)051-466-21222020-09-09
20대한민국행정사사무소부산광역시 금정구 중앙대로1629번길 16, 삼환스퀘어 2층 223호(부곡동)051-621-54592021-11-09