Overview

Dataset statistics

Number of variables8
Number of observations40
Missing cells6
Missing cells (%)1.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory68.3 B

Variable types

Numeric1
DateTime1
Text4
Categorical2

Dataset

Description2022년 여수시 행정사 현황( 연번, 행정사 성명, 사무소 명칭, 행정사무소 도로명 주소, 행정사무소 연락처 등)
Author전라남도 여수시
URLhttps://www.data.go.kr/data/3070698/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 00:10:15.413325
Analysis finished2023-12-12 00:10:16.164793
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.5
Minimum1
Maximum40
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size492.0 B
2023-12-12T09:10:16.238039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.95
Q110.75
median20.5
Q330.25
95-th percentile38.05
Maximum40
Range39
Interquartile range (IQR)19.5

Descriptive statistics

Standard deviation11.690452
Coefficient of variation (CV)0.57026595
Kurtosis-1.2
Mean20.5
Median Absolute Deviation (MAD)10
Skewness0
Sum820
Variance136.66667
MonotonicityStrictly increasing
2023-12-12T09:10:16.429938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
1 1
 
2.5%
22 1
 
2.5%
24 1
 
2.5%
25 1
 
2.5%
26 1
 
2.5%
27 1
 
2.5%
28 1
 
2.5%
29 1
 
2.5%
30 1
 
2.5%
31 1
 
2.5%
Other values (30) 30
75.0%
ValueCountFrequency (%)
1 1
2.5%
2 1
2.5%
3 1
2.5%
4 1
2.5%
5 1
2.5%
6 1
2.5%
7 1
2.5%
8 1
2.5%
9 1
2.5%
10 1
2.5%
ValueCountFrequency (%)
40 1
2.5%
39 1
2.5%
38 1
2.5%
37 1
2.5%
36 1
2.5%
35 1
2.5%
34 1
2.5%
33 1
2.5%
32 1
2.5%
31 1
2.5%

신고일자
Date

Distinct39
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
Minimum1996-03-19 00:00:00
Maximum2022-07-01 00:00:00
2023-12-12T09:10:16.626815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:10:16.749448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)

사무소명칭
Text

Distinct39
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T09:10:16.977560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length10
Mean length8.475
Min length2

Characters and Unicode

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

Unique38 ?
Unique (%)95.0%

Sample

1st row알파고 행정사 사무소
2nd row공감행정사사무소
3rd row다올행정사
4th row한려공인행정사사무소
5th row해빙 행정사 컨설팅
ValueCountFrequency (%)
사무소 4
 
7.4%
행정사사무소 4
 
7.4%
행정사 3
 
5.6%
황금대서소 2
 
3.7%
문학행정대서소 1
 
1.9%
행정사조길두사무소 1
 
1.9%
김영락행정사사무소 1
 
1.9%
다본행정사 1
 
1.9%
행정사김광남사무소 1
 
1.9%
행정사차만철사무소 1
 
1.9%
Other values (35) 35
64.8%
2023-12-12T09:10:17.386147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 66
19.5%
정 38
 
11.2%
행 37
 
10.9%
소 36
 
10.6%
무 34
 
10.0%
14
 
4.1%
김 4
 
1.2%
이 4
 
1.2%
서 4
 
1.2%
대 3
 
0.9%
Other values (77) 99
29.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 325
95.9%
Space Separator 14
 
4.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 66
20.3%
정 38
 
11.7%
행 37
 
11.4%
소 36
 
11.1%
무 34
 
10.5%
김 4
 
1.2%
이 4
 
1.2%
서 4
 
1.2%
대 3
 
0.9%
석 2
 
0.6%
Other values (76) 97
29.8%
Space Separator
ValueCountFrequency (%)
14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 325
95.9%
Common 14
 
4.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 66
20.3%
정 38
 
11.7%
행 37
 
11.4%
소 36
 
11.1%
무 34
 
10.5%
김 4
 
1.2%
이 4
 
1.2%
서 4
 
1.2%
대 3
 
0.9%
석 2
 
0.6%
Other values (76) 97
29.8%
Common
ValueCountFrequency (%)
14
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 325
95.9%
ASCII 14
 
4.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 66
20.3%
정 38
 
11.7%
행 37
 
11.4%
소 36
 
11.1%
무 34
 
10.5%
김 4
 
1.2%
이 4
 
1.2%
서 4
 
1.2%
대 3
 
0.9%
석 2
 
0.6%
Other values (76) 97
29.8%
ASCII
ValueCountFrequency (%)
14
100.0%

운영상태
Categorical

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
영업중
40 

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

Length

2023-12-12T09:10:17.504394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:10:17.589751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 40
100.0%

행정사종류
Categorical

CONSTANT 

Distinct1
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size452.0 B
일반행정사
40 

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 (%)
일반행정사 40
100.0%

Length

2023-12-12T09:10:17.685606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:10:17.773151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반행정사 40
100.0%

행정사 성명
Text

UNIQUE 

Distinct40
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T09:10:17.979553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters120
Distinct characters73
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

Unique40 ?
Unique (%)100.0%

Sample

1st row장기생
2nd row정미영
3rd row장윤기
4th row주명순
5th row강동규
ValueCountFrequency (%)
장기생 1
 
2.5%
정미영 1
 
2.5%
김영락 1
 
2.5%
구형모 1
 
2.5%
김광남 1
 
2.5%
차만철 1
 
2.5%
송해경 1
 
2.5%
강선호 1
 
2.5%
김태명 1
 
2.5%
조길두 1
 
2.5%
Other values (30) 30
75.0%
2023-12-12T09:10:18.276365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 7
 
5.8%
이 5
 
4.2%
종 4
 
3.3%
박 4
 
3.3%
영 4
 
3.3%
호 4
 
3.3%
주 3
 
2.5%
순 3
 
2.5%
형 3
 
2.5%
기 3
 
2.5%
Other values (63) 80
66.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 120
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 7
 
5.8%
이 5
 
4.2%
종 4
 
3.3%
박 4
 
3.3%
영 4
 
3.3%
호 4
 
3.3%
주 3
 
2.5%
순 3
 
2.5%
형 3
 
2.5%
기 3
 
2.5%
Other values (63) 80
66.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 120
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 7
 
5.8%
이 5
 
4.2%
종 4
 
3.3%
박 4
 
3.3%
영 4
 
3.3%
호 4
 
3.3%
주 3
 
2.5%
순 3
 
2.5%
형 3
 
2.5%
기 3
 
2.5%
Other values (63) 80
66.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 120
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 7
 
5.8%
이 5
 
4.2%
종 4
 
3.3%
박 4
 
3.3%
영 4
 
3.3%
호 4
 
3.3%
주 3
 
2.5%
순 3
 
2.5%
형 3
 
2.5%
기 3
 
2.5%
Other values (63) 80
66.7%

사무소 주소
Text

Distinct38
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Memory size452.0 B
2023-12-12T09:10:18.525481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length36
Mean length24.375
Min length18

Characters and Unicode

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

Unique36 ?
Unique (%)90.0%

Sample

1st row전라남도 여수시 새터로 9(신기동)
2nd row전라남도 여수시 웅천로 292， 1108동 1501호(웅천동， 웅천 포레스트 부영 1단지)
3rd row전라남도 여수시 도원로 148-1， 1층(안산동)
4th row전라남도 여수시 흥국로 31， .(학동)
5th row전라남도 여수시 원학동길 7(학동)
ValueCountFrequency (%)
전라남도 40
 
18.3%
여수시 40
 
18.3%
학동 8
 
3.7%
동문로 8
 
3.7%
관문동 6
 
2.8%
2층 4
 
1.8%
고소동 3
 
1.4%
봉산동 3
 
1.4%
망마로 3
 
1.4%
35 2
 
0.9%
Other values (94) 101
46.3%
2023-12-12T09:10:18.907154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
178
18.3%
동 48
 
4.9%
남 43
 
4.4%
수 42
 
4.3%
도 42
 
4.3%
라 41
 
4.2%
여 40
 
4.1%
시 40
 
4.1%
전 40
 
4.1%
) 35
 
3.6%
Other values (93) 426
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 568
58.3%
Space Separator 178
 
18.3%
Decimal Number 133
 
13.6%
Close Punctuation 35
 
3.6%
Open Punctuation 35
 
3.6%
Other Punctuation 18
 
1.8%
Dash Punctuation 8
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 48
 
8.5%
남 43
 
7.6%
수 42
 
7.4%
도 42
 
7.4%
라 41
 
7.2%
여 40
 
7.0%
시 40
 
7.0%
전 40
 
7.0%
로 30
 
5.3%
문 16
 
2.8%
Other values (77) 186
32.7%
Decimal Number
ValueCountFrequency (%)
1 28
21.1%
3 25
18.8%
2 16
12.0%
4 14
10.5%
0 13
9.8%
5 12
9.0%
6 8
 
6.0%
8 7
 
5.3%
9 7
 
5.3%
7 3
 
2.3%
Other Punctuation
ValueCountFrequency (%)
， 17
94.4%
. 1
 
5.6%
Space Separator
ValueCountFrequency (%)
178
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 568
58.3%
Common 407
41.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 48
 
8.5%
남 43
 
7.6%
수 42
 
7.4%
도 42
 
7.4%
라 41
 
7.2%
여 40
 
7.0%
시 40
 
7.0%
전 40
 
7.0%
로 30
 
5.3%
문 16
 
2.8%
Other values (77) 186
32.7%
Common
ValueCountFrequency (%)
178
43.7%
) 35
 
8.6%
( 35
 
8.6%
1 28
 
6.9%
3 25
 
6.1%
， 17
 
4.2%
2 16
 
3.9%
4 14
 
3.4%
0 13
 
3.2%
5 12
 
2.9%
Other values (6) 34
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 568
58.3%
ASCII 390
40.0%
None 17
 
1.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
178
45.6%
) 35
 
9.0%
( 35
 
9.0%
1 28
 
7.2%
3 25
 
6.4%
2 16
 
4.1%
4 14
 
3.6%
0 13
 
3.3%
5 12
 
3.1%
6 8
 
2.1%
Other values (5) 26
 
6.7%
Hangul
ValueCountFrequency (%)
동 48
 
8.5%
남 43
 
7.6%
수 42
 
7.4%
도 42
 
7.4%
라 41
 
7.2%
여 40
 
7.0%
시 40
 
7.0%
전 40
 
7.0%
로 30
 
5.3%
문 16
 
2.8%
Other values (77) 186
32.7%
None
ValueCountFrequency (%)
， 17
100.0%

사무소 전화번호
Text

MISSING 

Distinct33
Distinct (%)97.1%
Missing6
Missing (%)15.0%
Memory size452.0 B
2023-12-12T09:10:19.092265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length11.588235
Min length1

Characters and Unicode

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

Unique32 ?
Unique (%)94.1%

Sample

1st row061-681-5323
2nd row061-682-1136
3rd row
4th row061-653-7548
5th row642-9858
ValueCountFrequency (%)
061-664-2626 2
 
6.1%
061-686-0023 1
 
3.0%
061-681-5323 1
 
3.0%
061-642-8095 1
 
3.0%
061-644-0009 1
 
3.0%
061-682-8199 1
 
3.0%
061-686-8838 1
 
3.0%
061-642-1247 1
 
3.0%
061-666-8842 1
 
3.0%
061-666-3161 1
 
3.0%
Other values (22) 22
66.7%
2023-12-12T09:10:19.401668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 94
23.9%
- 65
16.5%
0 48
12.2%
1 47
11.9%
2 26
 
6.6%
8 26
 
6.6%
4 21
 
5.3%
5 21
 
5.3%
9 18
 
4.6%
3 16
 
4.1%
Other values (2) 12
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 328
83.2%
Dash Punctuation 65
 
16.5%
Space Separator 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 94
28.7%
0 48
14.6%
1 47
14.3%
2 26
 
7.9%
8 26
 
7.9%
4 21
 
6.4%
5 21
 
6.4%
9 18
 
5.5%
3 16
 
4.9%
7 11
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 65
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 394
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 94
23.9%
- 65
16.5%
0 48
12.2%
1 47
11.9%
2 26
 
6.6%
8 26
 
6.6%
4 21
 
5.3%
5 21
 
5.3%
9 18
 
4.6%
3 16
 
4.1%
Other values (2) 12
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 394
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 94
23.9%
- 65
16.5%
0 48
12.2%
1 47
11.9%
2 26
 
6.6%
8 26
 
6.6%
4 21
 
5.3%
5 21
 
5.3%
9 18
 
4.6%
3 16
 
4.1%
Other values (2) 12
 
3.0%

Interactions

2023-12-12T09:10:15.797709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:10:19.788335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호신고일자사무소명칭행정사 성명사무소 주소사무소 전화번호
일련번호1.0000.9320.9321.0000.8570.904
신고일자0.9321.0001.0001.0001.0001.000
사무소명칭0.9321.0001.0001.0001.0001.000
행정사 성명1.0001.0001.0001.0001.0001.000
사무소 주소0.8571.0001.0001.0001.0001.000
사무소 전화번호0.9041.0001.0001.0001.0001.000

Missing values

2023-12-12T09:10:15.949177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:10:16.102865image/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-07-01알파고 행정사 사무소영업중일반행정사장기생전라남도 여수시 새터로 9(신기동)061-681-5323
122022-06-22공감행정사사무소영업중일반행정사정미영전라남도 여수시 웅천로 292， 1108동 1501호(웅천동， 웅천 포레스트 부영 1단지)<NA>
232022-03-28다올행정사영업중일반행정사장윤기전라남도 여수시 도원로 148-1， 1층(안산동)061-682-1136
342022-02-07한려공인행정사사무소영업중일반행정사주명순전라남도 여수시 흥국로 31， .(학동)<NA>
452021-12-29해빙 행정사 컨설팅영업중일반행정사강동규전라남도 여수시 원학동길 7(학동)
562021-11-26방철희 행정사사무소영업중일반행정사방철희전라남도 여수시 흥국로 70， 3층(신기동)061-653-7548
672021-06-02희망행정사영업중일반행정사양창승전라남도 여수시 박람회길 61， 104동1002호 (덕충동， 엑스포힐스테이트1단지)642-9858
782021-05-26무료상담 행정사사무소영업중일반행정사나종순전라남도 여수시 돌산읍 평사로 536-51<NA>
892020-06-01심 행정법률사무소영업중일반행정사박찬용전라남도 여수시 망마로 30， 화인빌딩 4층 (학동)061-691-0079
9102018-04-26이유형 행정사사무소영업중일반행정사이유형전라남도 여수시 동문로 34-4 (고소동)061-665-4972
일련번호신고일자사무소명칭운영상태행정사종류행정사 성명사무소 주소사무소 전화번호
30312003-06-17문학행정대서소영업중일반행정사전문현전라남도 여수시 동문로 39 (관문동)061-662-8585
31322012-08-09미주행정사사무소영업중일반행정사주수원전라남도 여수시 화산로 35 (화장동)061-683-2502
32332012-12-31행정사이만종사무소영업중일반행정사이만종전라남도 여수시 망마로 33 (학동)061-684-8558
33341999-09-08이관형행정사사무소영업중일반행정사이관형전라남도 여수시 어항로 49-1 (봉산동)<NA>
34351997-09-22행정사제일합동사무소영업중일반행정사이영대전라남도 여수시 동문로 42 (고소동)061-666-1149
35361998-10-12황금대서소영업중일반행정사김종운전라남도 여수시 동문로 43-1 (관문동)061-664-2626
36371998-10-12황금대서소영업중일반행정사황순주전라남도 여수시 동문로 43-1 (관문동)061-664-2626
37381999-03-15행정사신근호사무소영업중일반행정사신근호전라남도 여수시 동문로 35-1 (관문동)061-664-5238
38391999-07-19행정사류기현사무소영업중일반행정사류기현전라남도 여수시 동문로 39 (관문동)061-666-2923
39401999-12-29연합행정사사무소영업중일반행정사정우호전라남도 여수시 구봉1길 5 (국동)<NA>