Overview

Dataset statistics

Number of variables8
Number of observations39
Missing cells8
Missing cells (%)2.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory68.4 B

Variable types

Numeric1
DateTime1
Text4
Categorical2

Dataset

Description전라남도 여수시에 영업신고를 하고 사무소를 둔 행정사사무소 현황(명칭, 운영상태, 행정사종류, 성명, 사무소 주소 및 전화번호를 기재)
Author전라남도 여수시
URLhttps://www.data.go.kr/data/15108006/fileData.do

Alerts

운영상태 has constant value ""Constant
행정사종류 has constant value ""Constant
사무소 전화번호 has 8 (20.5%) missing valuesMissing
일련번호 has unique valuesUnique
행정사 성명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 03:19:01.549735
Analysis finished2023-12-12 03:19:02.444568
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20
Minimum1
Maximum39
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2023-12-12T12:19:02.565620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.9
Q110.5
median20
Q329.5
95-th percentile37.1
Maximum39
Range38
Interquartile range (IQR)19

Descriptive statistics

Standard deviation11.401754
Coefficient of variation (CV)0.57008771
Kurtosis-1.2
Mean20
Median Absolute Deviation (MAD)10
Skewness0
Sum780
Variance130
MonotonicityStrictly increasing
2023-12-12T12:19:02.771683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
1 1
 
2.6%
2 1
 
2.6%
23 1
 
2.6%
24 1
 
2.6%
25 1
 
2.6%
26 1
 
2.6%
27 1
 
2.6%
28 1
 
2.6%
29 1
 
2.6%
30 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
1 1
2.6%
2 1
2.6%
3 1
2.6%
4 1
2.6%
5 1
2.6%
6 1
2.6%
7 1
2.6%
8 1
2.6%
9 1
2.6%
10 1
2.6%
ValueCountFrequency (%)
39 1
2.6%
38 1
2.6%
37 1
2.6%
36 1
2.6%
35 1
2.6%
34 1
2.6%
33 1
2.6%
32 1
2.6%
31 1
2.6%
30 1
2.6%

신고일자
Date

Distinct38
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum1996-03-19 00:00:00
Maximum2022-10-12 00:00:00
2023-12-12T12:19:02.963246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:19:03.165043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

사무소명칭
Text

Distinct38
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-12T12:19:03.473555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length8.4871795
Min length2

Characters and Unicode

Total characters331
Distinct characters87
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

Unique37 ?
Unique (%)94.9%

Sample

1st row권오봉행정사사무소
2nd row여수행정사사무소
3rd row알파고 행정사 사무소
4th row공감행정사사무소
5th row다올행정사
ValueCountFrequency (%)
행정사사무소 4
 
7.7%
행정사 3
 
5.8%
사무소 3
 
5.8%
황금대서소 2
 
3.8%
김태명행정사사무소 1
 
1.9%
행정사무소 1
 
1.9%
행정사류기현사무소 1
 
1.9%
김영락행정사사무소 1
 
1.9%
백석진행정사사무소 1
 
1.9%
행정사김광남사무소 1
 
1.9%
Other values (34) 34
65.4%
2023-12-12T12:19:03.990501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 64
19.3%
정 37
 
11.2%
행 36
 
10.9%
소 35
 
10.6%
무 33
 
10.0%
13
 
3.9%
서 4
 
1.2%
이 4
 
1.2%
김 4
 
1.2%
대 3
 
0.9%
Other values (77) 98
29.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 318
96.1%
Space Separator 13
 
3.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 64
20.1%
정 37
 
11.6%
행 36
 
11.3%
소 35
 
11.0%
무 33
 
10.4%
서 4
 
1.3%
이 4
 
1.3%
김 4
 
1.3%
대 3
 
0.9%
황 2
 
0.6%
Other values (76) 96
30.2%
Space Separator
ValueCountFrequency (%)
13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 318
96.1%
Common 13
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 64
20.1%
정 37
 
11.6%
행 36
 
11.3%
소 35
 
11.0%
무 33
 
10.4%
서 4
 
1.3%
이 4
 
1.3%
김 4
 
1.3%
대 3
 
0.9%
황 2
 
0.6%
Other values (76) 96
30.2%
Common
ValueCountFrequency (%)
13
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 318
96.1%
ASCII 13
 
3.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 64
20.1%
정 37
 
11.6%
행 36
 
11.3%
소 35
 
11.0%
무 33
 
10.4%
서 4
 
1.3%
이 4
 
1.3%
김 4
 
1.3%
대 3
 
0.9%
황 2
 
0.6%
Other values (76) 96
30.2%
ASCII
ValueCountFrequency (%)
13
100.0%

운영상태
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
영업중
39 

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 (%)
영업중 39
100.0%

Length

2023-12-12T12:19:04.200727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:19:04.354192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 39
100.0%

행정사종류
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
일반행정사
39 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
일반행정사 39
100.0%

Length

2023-12-12T12:19:04.497101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:19:04.641290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반행정사 39
100.0%

행정사 성명
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-12T12:19:04.892900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters117
Distinct characters72
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

Unique39 ?
Unique (%)100.0%

Sample

1st row권오봉
2nd row박종윤
3rd row장기생
4th row정미영
5th row장윤기
ValueCountFrequency (%)
권오봉 1
 
2.6%
서우진 1
 
2.6%
김광남 1
 
2.6%
차만철 1
 
2.6%
송해경 1
 
2.6%
강선호 1
 
2.6%
김태명 1
 
2.6%
조길두 1
 
2.6%
김영락 1
 
2.6%
백석진 1
 
2.6%
Other values (29) 29
74.4%
2023-12-12T12:19:05.326742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 6
 
5.1%
이 5
 
4.3%
박 4
 
3.4%
종 4
 
3.4%
호 4
 
3.4%
영 4
 
3.4%
순 3
 
2.6%
기 3
 
2.6%
주 3
 
2.6%
권 2
 
1.7%
Other values (62) 79
67.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 117
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 6
 
5.1%
이 5
 
4.3%
박 4
 
3.4%
종 4
 
3.4%
호 4
 
3.4%
영 4
 
3.4%
순 3
 
2.6%
기 3
 
2.6%
주 3
 
2.6%
권 2
 
1.7%
Other values (62) 79
67.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 117
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 6
 
5.1%
이 5
 
4.3%
박 4
 
3.4%
종 4
 
3.4%
호 4
 
3.4%
영 4
 
3.4%
순 3
 
2.6%
기 3
 
2.6%
주 3
 
2.6%
권 2
 
1.7%
Other values (62) 79
67.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 117
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 6
 
5.1%
이 5
 
4.3%
박 4
 
3.4%
종 4
 
3.4%
호 4
 
3.4%
영 4
 
3.4%
순 3
 
2.6%
기 3
 
2.6%
주 3
 
2.6%
권 2
 
1.7%
Other values (62) 79
67.5%

사무소 주소
Text

Distinct37
Distinct (%)94.9%
Missing0
Missing (%)0.0%
Memory size444.0 B
2023-12-12T12:19:05.678460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length34
Mean length24.25641
Min length18

Characters and Unicode

Total characters946
Distinct characters103
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique35 ?
Unique (%)89.7%

Sample

1st row전라남도 여수시 시청로 34， 이레타운 2층， 201호(학동)
2nd row전라남도 여수시 신월로 676， 3층 제4호실(국동)
3rd row전라남도 여수시 새터로 9(신기동)
4th row전라남도 여수시 웅천로 292， 1108동 1501호(웅천동， 웅천 포레스트 부영 1단지)
5th row전라남도 여수시 도원로 148-1， 1층(안산동)
ValueCountFrequency (%)
전라남도 39
 
18.5%
여수시 39
 
18.5%
학동 8
 
3.8%
동문로 8
 
3.8%
관문동 6
 
2.8%
고소동 3
 
1.4%
망마로 3
 
1.4%
2층 3
 
1.4%
39 2
 
0.9%
봉산동 2
 
0.9%
Other values (89) 98
46.4%
2023-12-12T12:19:06.209434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
172
18.2%
동 46
 
4.9%
남 42
 
4.4%
도 41
 
4.3%
시 40
 
4.2%
라 40
 
4.2%
전 39
 
4.1%
여 39
 
4.1%
수 39
 
4.1%
( 34
 
3.6%
Other values (93) 414
43.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 551
58.2%
Space Separator 172
 
18.2%
Decimal Number 129
 
13.6%
Open Punctuation 34
 
3.6%
Close Punctuation 34
 
3.6%
Other Punctuation 18
 
1.9%
Dash Punctuation 8
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 46
 
8.3%
남 42
 
7.6%
도 41
 
7.4%
시 40
 
7.3%
라 40
 
7.3%
전 39
 
7.1%
여 39
 
7.1%
수 39
 
7.1%
로 30
 
5.4%
문 14
 
2.5%
Other values (77) 181
32.8%
Decimal Number
ValueCountFrequency (%)
1 27
20.9%
3 25
19.4%
2 15
11.6%
4 13
10.1%
5 12
9.3%
0 12
9.3%
6 10
 
7.8%
9 6
 
4.7%
7 5
 
3.9%
8 4
 
3.1%
Other Punctuation
ValueCountFrequency (%)
， 17
94.4%
. 1
 
5.6%
Space Separator
ValueCountFrequency (%)
172
100.0%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 34
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 551
58.2%
Common 395
41.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 46
 
8.3%
남 42
 
7.6%
도 41
 
7.4%
시 40
 
7.3%
라 40
 
7.3%
전 39
 
7.1%
여 39
 
7.1%
수 39
 
7.1%
로 30
 
5.4%
문 14
 
2.5%
Other values (77) 181
32.8%
Common
ValueCountFrequency (%)
172
43.5%
( 34
 
8.6%
) 34
 
8.6%
1 27
 
6.8%
3 25
 
6.3%
， 17
 
4.3%
2 15
 
3.8%
4 13
 
3.3%
5 12
 
3.0%
0 12
 
3.0%
Other values (6) 34
 
8.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 551
58.2%
ASCII 378
40.0%
None 17
 
1.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
172
45.5%
( 34
 
9.0%
) 34
 
9.0%
1 27
 
7.1%
3 25
 
6.6%
2 15
 
4.0%
4 13
 
3.4%
5 12
 
3.2%
0 12
 
3.2%
6 10
 
2.6%
Other values (5) 24
 
6.3%
Hangul
ValueCountFrequency (%)
동 46
 
8.3%
남 42
 
7.6%
도 41
 
7.4%
시 40
 
7.3%
라 40
 
7.3%
전 39
 
7.1%
여 39
 
7.1%
수 39
 
7.1%
로 30
 
5.4%
문 14
 
2.5%
Other values (77) 181
32.8%
None
ValueCountFrequency (%)
， 17
100.0%

사무소 전화번호
Text

MISSING 

Distinct30
Distinct (%)96.8%
Missing8
Missing (%)20.5%
Memory size444.0 B
2023-12-12T12:19:06.454978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.645161
Min length1

Characters and Unicode

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

Unique29 ?
Unique (%)93.5%

Sample

1st row061-807-3535
2nd row061-644-0905
3rd row061-681-5323
4th row061-682-1136
5th row
ValueCountFrequency (%)
061-664-2626 2
 
6.7%
061-686-8838 1
 
3.3%
061-807-3535 1
 
3.3%
061-681-6666 1
 
3.3%
061-664-5238 1
 
3.3%
061-666-1149 1
 
3.3%
061-684-8558 1
 
3.3%
061-683-2502 1
 
3.3%
061-662-8585 1
 
3.3%
061-666-3161 1
 
3.3%
Other values (19) 19
63.3%
2023-12-12T12:19:06.897467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 89
24.7%
- 60
16.6%
1 46
12.7%
0 41
11.4%
8 25
 
6.9%
2 23
 
6.4%
5 21
 
5.8%
4 16
 
4.4%
3 15
 
4.2%
9 15
 
4.2%
Other values (2) 10
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.1%
Dash Punctuation 60
 
16.6%
Space Separator 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 89
29.7%
1 46
15.3%
0 41
13.7%
8 25
 
8.3%
2 23
 
7.7%
5 21
 
7.0%
4 16
 
5.3%
3 15
 
5.0%
9 15
 
5.0%
7 9
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 361
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 89
24.7%
- 60
16.6%
1 46
12.7%
0 41
11.4%
8 25
 
6.9%
2 23
 
6.4%
5 21
 
5.8%
4 16
 
4.4%
3 15
 
4.2%
9 15
 
4.2%
Other values (2) 10
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 361
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 89
24.7%
- 60
16.6%
1 46
12.7%
0 41
11.4%
8 25
 
6.9%
2 23
 
6.4%
5 21
 
5.8%
4 16
 
4.4%
3 15
 
4.2%
9 15
 
4.2%
Other values (2) 10
 
2.8%

Interactions

2023-12-12T12:19:01.973853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T12:19:07.034985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호신고일자사무소명칭행정사 성명사무소 주소사무소 전화번호
일련번호1.0000.9330.9331.0000.8660.945
신고일자0.9331.0001.0001.0001.0001.000
사무소명칭0.9331.0001.0001.0001.0001.000
행정사 성명1.0001.0001.0001.0001.0001.000
사무소 주소0.8661.0001.0001.0001.0001.000
사무소 전화번호0.9451.0001.0001.0001.0001.000

Missing values

2023-12-12T12:19:02.164011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:19:02.362456image/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

일련번호신고일자사무소명칭운영상태행정사종류행정사 성명사무소 주소사무소 전화번호
012022-10-11권오봉행정사사무소영업중일반행정사권오봉전라남도 여수시 시청로 34， 이레타운 2층， 201호(학동)061-807-3535
122022-09-21여수행정사사무소영업중일반행정사박종윤전라남도 여수시 신월로 676， 3층 제4호실(국동)061-644-0905
232022-07-01알파고 행정사 사무소영업중일반행정사장기생전라남도 여수시 새터로 9(신기동)061-681-5323
342022-06-22공감행정사사무소영업중일반행정사정미영전라남도 여수시 웅천로 292， 1108동 1501호(웅천동， 웅천 포레스트 부영 1단지)<NA>
452022-03-28다올행정사영업중일반행정사장윤기전라남도 여수시 도원로 148-1， 1층(안산동)061-682-1136
562022-02-07한려공인행정사사무소영업중일반행정사주명순전라남도 여수시 흥국로 31， .(학동)<NA>
672021-12-29해빙 행정사 컨설팅영업중일반행정사강동규전라남도 여수시 원학동길 7(학동)
782021-11-26방철희 행정사사무소영업중일반행정사방철희전라남도 여수시 흥국로 70， 3층(신기동)<NA>
892021-06-02희망행정사영업중일반행정사양창승전라남도 여수시 박람회길 61， 104동1002호 (덕충동， 엑스포힐스테이트1단지)061-642-9858
9102021-05-26무료상담 행정사사무소영업중일반행정사나종순전라남도 여수시 돌산읍 평사로 536-51<NA>
일련번호신고일자사무소명칭운영상태행정사종류행정사 성명사무소 주소사무소 전화번호
29302003-06-17문학행정대서소영업중일반행정사전문현전라남도 여수시 동문로 39 (관문동)061-662-8585
30312012-08-09미주행정사사무소영업중일반행정사주수원전라남도 여수시 화산로 35 (화장동)061-683-2502
31322012-12-31행정사이만종사무소영업중일반행정사이만종전라남도 여수시 망마로 33 (학동)061-684-8558
32331999-09-08이관형행정사사무소영업중일반행정사이관형전라남도 여수시 어항로 49-1 (봉산동)<NA>
33341997-09-22행정사제일합동사무소영업중일반행정사이영대전라남도 여수시 동문로 42 (고소동)061-666-1149
34351998-10-12황금대서소영업중일반행정사김종운전라남도 여수시 동문로 43-1 (관문동)061-664-2626
35361998-10-12황금대서소영업중일반행정사황순주전라남도 여수시 동문로 43-1 (관문동)061-664-2626
36371999-03-15행정사신근호사무소영업중일반행정사신근호전라남도 여수시 동문로 35-1 (관문동)061-664-5238
37381999-07-19행정사류기현사무소영업중일반행정사류기현전라남도 여수시 동문로 39 (관문동)061-666-2923
38391999-12-29연합행정사사무소영업중일반행정사정우호전라남도 여수시 구봉1길 5 (국동)<NA>