Overview

Dataset statistics

Number of variables9
Number of observations27
Missing cells8
Missing cells (%)3.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory76.9 B

Variable types

DateTime1
Categorical4
Text4

Dataset

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

Alerts

영업여부 has constant value ""Constant
구군명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
행정사종류 is highly imbalanced (77.1%)Imbalance
전화번호 has 8 (29.6%) missing valuesMissing

Reproduction

Analysis started2023-12-10 16:31:01.461247
Analysis finished2023-12-10 16:31:02.807824
Duration1.35 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct24
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2001-09-10 00:00:00
Maximum2023-05-22 00:00:00
2023-12-11T01:31:02.890824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:31:03.082067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)

행정사종류
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
일반행정사
26 
해사행정사
 
1

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique1 ?
Unique (%)3.7%

Sample

1st row일반행정사
2nd row일반행정사
3rd row일반행정사
4th row일반행정사
5th row일반행정사

Common Values

ValueCountFrequency (%)
일반행정사 26
96.3%
해사행정사 1
 
3.7%

Length

2023-12-11T01:31:03.286272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:31:03.446463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반행정사 26
96.3%
해사행정사 1
 
3.7%

성명
Text

Distinct26
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-11T01:31:03.649855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)92.6%

Sample

1st row유한봉
2nd row장연도
3rd row서형찬
4th row정자현
5th row김덕준
ValueCountFrequency (%)
이정율 2
 
7.4%
유한봉 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 (16) 16
59.3%
2023-12-11T01:31:04.091276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6
 
7.4%
5
 
6.2%
4
 
4.9%
3
 
3.7%
3
 
3.7%
3
 
3.7%
2
 
2.5%
2
 
2.5%
2
 
2.5%
2
 
2.5%
Other values (44) 49
60.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 81
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
6
 
7.4%
5
 
6.2%
4
 
4.9%
3
 
3.7%
3
 
3.7%
3
 
3.7%
2
 
2.5%
2
 
2.5%
2
 
2.5%
2
 
2.5%
Other values (44) 49
60.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 81
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
6
 
7.4%
5
 
6.2%
4
 
4.9%
3
 
3.7%
3
 
3.7%
3
 
3.7%
2
 
2.5%
2
 
2.5%
2
 
2.5%
2
 
2.5%
Other values (44) 49
60.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 81
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
6
 
7.4%
5
 
6.2%
4
 
4.9%
3
 
3.7%
3
 
3.7%
3
 
3.7%
2
 
2.5%
2
 
2.5%
2
 
2.5%
2
 
2.5%
Other values (44) 49
60.5%
Distinct25
Distinct (%)92.6%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-11T01:31:04.341805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length11
Mean length9.1481481
Min length5

Characters and Unicode

Total characters247
Distinct characters69
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique23 ?
Unique (%)85.2%

Sample

1st row행정사유한봉사무소
2nd row장연도행정사사무소
3rd row서형찬행정사사무소
4th row행정사 정자현사무소
5th row행정사합동사무소
ValueCountFrequency (%)
행정사 7
 
16.7%
사무소 5
 
11.9%
행정사사무소 3
 
7.1%
k&n 2
 
4.8%
해율행정사사무소 2
 
4.8%
서형찬행정사사무소 1
 
2.4%
진로행정사 1
 
2.4%
행정사유한봉사무소 1
 
2.4%
박정필 1
 
2.4%
해송 1
 
2.4%
Other values (18) 18
42.9%
2023-12-11T01:31:04.748078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
50
20.2%
32
13.0%
27
10.9%
23
 
9.3%
23
 
9.3%
15
 
6.1%
3
 
1.2%
N 3
 
1.2%
K 3
 
1.2%
& 2
 
0.8%
Other values (59) 66
26.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 215
87.0%
Space Separator 15
 
6.1%
Uppercase Letter 13
 
5.3%
Other Punctuation 2
 
0.8%
Open Punctuation 1
 
0.4%
Close Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
50
23.3%
32
14.9%
27
12.6%
23
10.7%
23
10.7%
3
 
1.4%
2
 
0.9%
2
 
0.9%
2
 
0.9%
2
 
0.9%
Other values (47) 49
22.8%
Uppercase Letter
ValueCountFrequency (%)
N 3
23.1%
K 3
23.1%
L 2
15.4%
P 1
 
7.7%
G 1
 
7.7%
O 1
 
7.7%
B 1
 
7.7%
A 1
 
7.7%
Space Separator
ValueCountFrequency (%)
15
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 215
87.0%
Common 19
 
7.7%
Latin 13
 
5.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
50
23.3%
32
14.9%
27
12.6%
23
10.7%
23
10.7%
3
 
1.4%
2
 
0.9%
2
 
0.9%
2
 
0.9%
2
 
0.9%
Other values (47) 49
22.8%
Latin
ValueCountFrequency (%)
N 3
23.1%
K 3
23.1%
L 2
15.4%
P 1
 
7.7%
G 1
 
7.7%
O 1
 
7.7%
B 1
 
7.7%
A 1
 
7.7%
Common
ValueCountFrequency (%)
15
78.9%
& 2
 
10.5%
( 1
 
5.3%
) 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 215
87.0%
ASCII 32
 
13.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
50
23.3%
32
14.9%
27
12.6%
23
10.7%
23
10.7%
3
 
1.4%
2
 
0.9%
2
 
0.9%
2
 
0.9%
2
 
0.9%
Other values (47) 49
22.8%
ASCII
ValueCountFrequency (%)
15
46.9%
N 3
 
9.4%
K 3
 
9.4%
& 2
 
6.2%
L 2
 
6.2%
P 1
 
3.1%
( 1
 
3.1%
) 1
 
3.1%
G 1
 
3.1%
O 1
 
3.1%
Other values (2) 2
 
6.2%
Distinct24
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-11T01:31:05.025461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length39
Mean length32.407407
Min length22

Characters and Unicode

Total characters875
Distinct characters87
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 (%)77.8%

Sample

1st row부산광역시 수영구 수영로 521 (광안동)
2nd row부산광역시 수영구 구락로 59 (수영동)
3rd row부산광역시 수영구 광일로 70, 1205호 (광안동, 광안메르빌)
4th row부산광역시 수영구 광서로10번길 74 (광안동)
5th row부산광역시 수영구 수영로 지하 482 (남천동)
ValueCountFrequency (%)
부산광역시 27
 
16.2%
수영구 27
 
16.2%
광안동 8
 
4.8%
수영로 7
 
4.2%
민락동 4
 
2.4%
수영동 4
 
2.4%
망미동 4
 
2.4%
남천동 4
 
2.4%
3층 3
 
1.8%
29-1 2
 
1.2%
Other values (69) 77
46.1%
2023-12-11T01:31:05.467747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
140
 
16.0%
46
 
5.3%
43
 
4.9%
42
 
4.8%
35
 
4.0%
1 30
 
3.4%
29
 
3.3%
28
 
3.2%
28
 
3.2%
28
 
3.2%
Other values (77) 426
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 503
57.5%
Decimal Number 147
 
16.8%
Space Separator 140
 
16.0%
Open Punctuation 27
 
3.1%
Close Punctuation 27
 
3.1%
Other Punctuation 24
 
2.7%
Dash Punctuation 6
 
0.7%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
46
 
9.1%
43
 
8.5%
42
 
8.3%
35
 
7.0%
29
 
5.8%
28
 
5.6%
28
 
5.6%
28
 
5.6%
27
 
5.4%
27
 
5.4%
Other values (61) 170
33.8%
Decimal Number
ValueCountFrequency (%)
1 30
20.4%
2 22
15.0%
0 20
13.6%
4 18
12.2%
3 17
11.6%
8 9
 
6.1%
9 9
 
6.1%
6 8
 
5.4%
5 8
 
5.4%
7 6
 
4.1%
Space Separator
ValueCountFrequency (%)
140
100.0%
Open Punctuation
ValueCountFrequency (%)
( 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 27
100.0%
Other Punctuation
ValueCountFrequency (%)
, 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Uppercase Letter
ValueCountFrequency (%)
G 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 503
57.5%
Common 371
42.4%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
46
 
9.1%
43
 
8.5%
42
 
8.3%
35
 
7.0%
29
 
5.8%
28
 
5.6%
28
 
5.6%
28
 
5.6%
27
 
5.4%
27
 
5.4%
Other values (61) 170
33.8%
Common
ValueCountFrequency (%)
140
37.7%
1 30
 
8.1%
( 27
 
7.3%
) 27
 
7.3%
, 24
 
6.5%
2 22
 
5.9%
0 20
 
5.4%
4 18
 
4.9%
3 17
 
4.6%
8 9
 
2.4%
Other values (5) 37
 
10.0%
Latin
ValueCountFrequency (%)
G 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 503
57.5%
ASCII 372
42.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
140
37.6%
1 30
 
8.1%
( 27
 
7.3%
) 27
 
7.3%
, 24
 
6.5%
2 22
 
5.9%
0 20
 
5.4%
4 18
 
4.8%
3 17
 
4.6%
8 9
 
2.4%
Other values (6) 38
 
10.2%
Hangul
ValueCountFrequency (%)
46
 
9.1%
43
 
8.5%
42
 
8.3%
35
 
7.0%
29
 
5.8%
28
 
5.6%
28
 
5.6%
28
 
5.6%
27
 
5.4%
27
 
5.4%
Other values (61) 170
33.8%

전화번호
Text

MISSING 

Distinct18
Distinct (%)94.7%
Missing8
Missing (%)29.6%
Memory size348.0 B
2023-12-11T01:31:05.689543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.105263
Min length12

Characters and Unicode

Total characters230
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 (%)89.5%

Sample

1st row051-751-2788
2nd row051-759-4306
3rd row051-754-7243
4th row051-624-0556
5th row051-758-9290
ValueCountFrequency (%)
051-623-3999 2
 
10.5%
051-753-1102 1
 
5.3%
051-751-2788 1
 
5.3%
070-4065-6103 1
 
5.3%
051-636-7999 1
 
5.3%
051-755-3100 1
 
5.3%
051-625-2351 1
 
5.3%
051-759-8942 1
 
5.3%
051-753-4760 1
 
5.3%
051-756-3618 1
 
5.3%
Other values (8) 8
42.1%
2023-12-11T01:31:06.067383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 38
16.5%
5 37
16.1%
0 31
13.5%
1 27
11.7%
7 22
9.6%
6 17
7.4%
3 15
 
6.5%
9 14
 
6.1%
2 12
 
5.2%
4 10
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 192
83.5%
Dash Punctuation 38
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 37
19.3%
0 31
16.1%
1 27
14.1%
7 22
11.5%
6 17
8.9%
3 15
7.8%
9 14
 
7.3%
2 12
 
6.2%
4 10
 
5.2%
8 7
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 38
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 230
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 38
16.5%
5 37
16.1%
0 31
13.5%
1 27
11.7%
7 22
9.6%
6 17
7.4%
3 15
 
6.5%
9 14
 
6.1%
2 12
 
5.2%
4 10
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 230
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 38
16.5%
5 37
16.1%
0 31
13.5%
1 27
11.7%
7 22
9.6%
6 17
7.4%
3 15
 
6.5%
9 14
 
6.1%
2 12
 
5.2%
4 10
 
4.3%

영업여부
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
영업중
27 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 27
100.0%

Length

2023-12-11T01:31:06.268975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:31:06.366747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 27
100.0%

구군명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
부산광역시 수영구
27 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시 수영구
2nd row부산광역시 수영구
3rd row부산광역시 수영구
4th row부산광역시 수영구
5th row부산광역시 수영구

Common Values

ValueCountFrequency (%)
부산광역시 수영구 27
100.0%

Length

2023-12-11T01:31:06.469892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:31:06.577860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부산광역시 27
50.0%
수영구 27
50.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-07-01
27 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-01
2nd row2023-07-01
3rd row2023-07-01
4th row2023-07-01
5th row2023-07-01

Common Values

ValueCountFrequency (%)
2023-07-01 27
100.0%

Length

2023-12-11T01:31:06.683463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:31:06.774053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-01 27
100.0%

Correlations

2023-12-11T01:31:06.859197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신고연월일행정사종류성명사무소명칭도로명주소전화번호
신고연월일1.0000.0001.0001.0000.9971.000
행정사종류0.0001.0000.0000.0000.000NaN
성명1.0000.0001.0001.0001.0001.000
사무소명칭1.0000.0001.0001.0001.0001.000
도로명주소0.9970.0001.0001.0001.0001.000
전화번호1.000NaN1.0001.0001.0001.000

Missing values

2023-12-11T01:31:02.398950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:31:02.712969image/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

신고연월일행정사종류성명사무소명칭도로명주소전화번호영업여부구군명데이터기준일자
02001-09-10일반행정사유한봉행정사유한봉사무소부산광역시 수영구 수영로 521 (광안동)051-751-2788영업중부산광역시 수영구2023-07-01
12003-09-25일반행정사장연도장연도행정사사무소부산광역시 수영구 구락로 59 (수영동)051-759-4306영업중부산광역시 수영구2023-07-01
22003-10-16일반행정사서형찬서형찬행정사사무소부산광역시 수영구 광일로 70, 1205호 (광안동, 광안메르빌)<NA>영업중부산광역시 수영구2023-07-01
32005-10-10일반행정사정자현행정사 정자현사무소부산광역시 수영구 광서로10번길 74 (광안동)051-754-7243영업중부산광역시 수영구2023-07-01
42006-02-02일반행정사김덕준행정사합동사무소부산광역시 수영구 수영로 지하 482 (남천동)051-624-0556영업중부산광역시 수영구2023-07-01
52006-09-22일반행정사황구화황구화행정사부산광역시 수영구 광안해변로 433 (민락동)051-758-9290영업중부산광역시 수영구2023-07-01
62006-12-28일반행정사허종수행정사허종수사무소부산광역시 수영구 호암로29번길 50 (광안자이)<NA>영업중부산광역시 수영구2023-07-01
72007-01-08일반행정사이성대행정사이성대사무소부산광역시 수영구 수영로 지하 482 (남천동)051-611-5753영업중부산광역시 수영구2023-07-01
82012-05-11일반행정사천영오천영오행정사부산광역시 수영구 망미번영로52번길 26 (수영동)051-754-6868영업중부산광역시 수영구2023-07-01
92012-11-21일반행정사서민국민국일반행정사사무소부산광역시 수영구 수영로 721, 901호 (수영동, 수영리첸빌)070-4250-3671영업중부산광역시 수영구2023-07-01
신고연월일행정사종류성명사무소명칭도로명주소전화번호영업여부구군명데이터기준일자
172017-04-03일반행정사정상식정상식행정사사무소부산광역시 수영구 과정로42번길 30 (망미동)051-755-3100영업중부산광역시 수영구2023-07-01
182018-07-18일반행정사남재근K&N 행정사사무소부산광역시 수영구 민락본동로 29-1, 3층 (민락동)051-623-3999영업중부산광역시 수영구2023-07-01
192018-07-18일반행정사김종년K&N 행정사사무소부산광역시 수영구 민락본동로 29-1, 3층 (민락동)051-623-3999영업중부산광역시 수영구2023-07-01
202018-10-17일반행정사유도형PNK행정사사무소부산광역시 수영구 광서로10번길 24, 203호 (광안동, 토명비취빌)051-636-7999영업중부산광역시 수영구2023-07-01
212021-06-14일반행정사이정율해율행정사사무소부산광역시 수영구 수영로 641, 101동 1810호 (광안동, 힐탑더블시티)051-754-7772영업중부산광역시 수영구2023-07-01
222021-06-14해사행정사이정율해율행정사사무소부산광역시 수영구 수영로 641, 101동 1810호 (광안동, 힐탑더블시티)<NA>영업중부산광역시 수영구2023-07-01
232021-11-01일반행정사이평엽글로벌(GLOBAL) 행정사 사무소부산광역시 수영구 광서로 54, 1동 201호(광안동, 상아아파트)<NA>영업중부산광역시 수영구2023-07-01
242022-03-14일반행정사유병석경기 행정사 사무소부산광역시 수영구 광일로67번길 68, 103동 104호(광안동, 광명아파트)<NA>영업중부산광역시 수영구2023-07-01
252023-04-13일반행정사김도현해송 행정사사무소부산광역시 수영구 남천동로108번길 20, 4층 G 3호 (남천동)<NA>영업중부산광역시 수영구2023-07-01
262023-05-22일반행정사김혜림신정행정사사무소부산광역시 수영구 수영로642번길 28, 3층 (광안동)<NA>영업중부산광역시 수영구2023-07-01