Overview

Dataset statistics

Number of variables4
Number of observations113
Missing cells17
Missing cells (%)3.8%
Duplicate rows1
Duplicate rows (%)0.9%
Total size in memory3.7 KiB
Average record size in memory33.1 B

Variable types

Text3
Categorical1

Dataset

Description전북특별자치도 익산시 행정사사무소 현황 데이터를 제공합니다.(상호명, 주소, 연락처 등을 현황을 제공합니다.) 민원서류 작성에 어려운 것을 작성하여 줍니다.
Author전북특별자치도 익산시
URLhttps://www.data.go.kr/data/15028777/fileData.do

Alerts

Dataset has 1 (0.9%) duplicate rowsDuplicates
비고 is highly imbalanced (59.9%)Imbalance
전화번호 has 17 (15.0%) missing valuesMissing

Reproduction

Analysis started2024-03-14 11:19:23.475528
Analysis finished2024-03-14 11:19:24.244816
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

명 칭
Text

Distinct110
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-14T20:19:25.015297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length15
Mean length9.7610619
Min length2

Characters and Unicode

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

Unique

Unique107 ?
Unique (%)94.7%

Sample

1st row농바시공인행정사
2nd row법무사 최홍규 사무소
3rd row이용배행정사
4th row이길남행정사
5th row최정호 행정사
ValueCountFrequency (%)
일반행정사 40
 
19.2%
행정사 32
 
15.4%
사무소 10
 
4.8%
행정사무소 4
 
1.9%
이리번역행정사사무소 2
 
1.0%
ok행정사 2
 
1.0%
신우 2
 
1.0%
한국가정행복연구원 2
 
1.0%
박저규행정사사무소 1
 
0.5%
문병두사무소 1
 
0.5%
Other values (112) 112
53.8%
2024-03-14T20:19:26.413519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 180
16.3%
정 116
 
10.5%
행 107
 
9.7%
95
 
8.6%
소 87
 
7.9%
무 85
 
7.7%
일 42
 
3.8%
반 41
 
3.7%
김 17
 
1.5%
이 16
 
1.5%
Other values (123) 317
28.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1000
90.7%
Space Separator 95
 
8.6%
Uppercase Letter 6
 
0.5%
Decimal Number 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 180
18.0%
정 116
 
11.6%
행 107
 
10.7%
소 87
 
8.7%
무 85
 
8.5%
일 42
 
4.2%
반 41
 
4.1%
김 17
 
1.7%
이 16
 
1.6%
영 14
 
1.4%
Other values (116) 295
29.5%
Uppercase Letter
ValueCountFrequency (%)
K 2
33.3%
O 2
33.3%
S 1
16.7%
H 1
16.7%
Decimal Number
ValueCountFrequency (%)
2 1
50.0%
1 1
50.0%
Space Separator
ValueCountFrequency (%)
95
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1000
90.7%
Common 97
 
8.8%
Latin 6
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 180
18.0%
정 116
 
11.6%
행 107
 
10.7%
소 87
 
8.7%
무 85
 
8.5%
일 42
 
4.2%
반 41
 
4.1%
김 17
 
1.7%
이 16
 
1.6%
영 14
 
1.4%
Other values (116) 295
29.5%
Latin
ValueCountFrequency (%)
K 2
33.3%
O 2
33.3%
S 1
16.7%
H 1
16.7%
Common
ValueCountFrequency (%)
95
97.9%
2 1
 
1.0%
1 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1000
90.7%
ASCII 103
 
9.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 180
18.0%
정 116
 
11.6%
행 107
 
10.7%
소 87
 
8.7%
무 85
 
8.5%
일 42
 
4.2%
반 41
 
4.1%
김 17
 
1.7%
이 16
 
1.6%
영 14
 
1.4%
Other values (116) 295
29.5%
ASCII
ValueCountFrequency (%)
95
92.2%
K 2
 
1.9%
O 2
 
1.9%
S 1
 
1.0%
H 1
 
1.0%
2 1
 
1.0%
1 1
 
1.0%

소재지
Text

Distinct111
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-03-14T20:19:27.939587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length40
Mean length27.150442
Min length19

Characters and Unicode

Total characters3068
Distinct characters121
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique109 ?
Unique (%)96.5%

Sample

1st row전북특별자치도 익산시 황등면 황등7길 25-12
2nd row전북특별자치도 익산시 주현로 29-1(주현동)
3rd row전북특별자치도 익산시 석암로 227, 2층(석암동)
4th row전북특별자치도 익산시 주현로 42, 상가동 1층 102호(주현동)
5th row전북특별자치도 익산시 무왕로 1031(영등동)
ValueCountFrequency (%)
전북특별자치도 113
 
18.8%
익산시 113
 
18.8%
영등동 14
 
2.3%
1호 13
 
2.2%
모현동1가 10
 
1.7%
부송동 9
 
1.5%
금마면 8
 
1.3%
주현동 8
 
1.3%
남중동 8
 
1.3%
3호 7
 
1.2%
Other values (220) 299
49.7%
2024-03-14T20:19:29.896552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
492
 
16.0%
산 137
 
4.5%
도 120
 
3.9%
북 116
 
3.8%
익 115
 
3.7%
시 114
 
3.7%
1 114
 
3.7%
전 113
 
3.7%
치 113
 
3.7%
자 113
 
3.7%
Other values (111) 1521
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1980
64.5%
Space Separator 492
 
16.0%
Decimal Number 486
 
15.8%
Open Punctuation 40
 
1.3%
Close Punctuation 40
 
1.3%
Other Punctuation 15
 
0.5%
Dash Punctuation 13
 
0.4%
Lowercase Letter 1
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 137
 
6.9%
도 120
 
6.1%
북 116
 
5.9%
익 115
 
5.8%
시 114
 
5.8%
전 113
 
5.7%
치 113
 
5.7%
자 113
 
5.7%
별 113
 
5.7%
특 113
 
5.7%
Other values (94) 813
41.1%
Decimal Number
ValueCountFrequency (%)
1 114
23.5%
2 73
15.0%
3 63
13.0%
5 44
 
9.1%
4 40
 
8.2%
0 37
 
7.6%
6 36
 
7.4%
7 30
 
6.2%
8 26
 
5.3%
9 23
 
4.7%
Space Separator
ValueCountFrequency (%)
492
100.0%
Open Punctuation
ValueCountFrequency (%)
( 40
100.0%
Close Punctuation
ValueCountFrequency (%)
) 40
100.0%
Other Punctuation
ValueCountFrequency (%)
, 15
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1981
64.6%
Common 1086
35.4%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 137
 
6.9%
도 120
 
6.1%
북 116
 
5.9%
익 115
 
5.8%
시 114
 
5.8%
전 113
 
5.7%
치 113
 
5.7%
자 113
 
5.7%
별 113
 
5.7%
특 113
 
5.7%
Other values (95) 814
41.1%
Common
ValueCountFrequency (%)
492
45.3%
1 114
 
10.5%
2 73
 
6.7%
3 63
 
5.8%
5 44
 
4.1%
4 40
 
3.7%
( 40
 
3.7%
) 40
 
3.7%
0 37
 
3.4%
6 36
 
3.3%
Other values (5) 107
 
9.9%
Latin
ValueCountFrequency (%)
e 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1980
64.5%
ASCII 1087
35.4%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
492
45.3%
1 114
 
10.5%
2 73
 
6.7%
3 63
 
5.8%
5 44
 
4.0%
4 40
 
3.7%
( 40
 
3.7%
) 40
 
3.7%
0 37
 
3.4%
6 36
 
3.3%
Other values (6) 108
 
9.9%
Hangul
ValueCountFrequency (%)
산 137
 
6.9%
도 120
 
6.1%
북 116
 
5.9%
익 115
 
5.8%
시 114
 
5.8%
전 113
 
5.7%
치 113
 
5.7%
자 113
 
5.7%
별 113
 
5.7%
특 113
 
5.7%
Other values (94) 813
41.1%
None
ValueCountFrequency (%)
㈜ 1
100.0%

전화번호
Text

MISSING 

Distinct95
Distinct (%)99.0%
Missing17
Missing (%)15.0%
Memory size1.0 KiB
2024-03-14T20:19:30.856256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique94 ?
Unique (%)97.9%

Sample

1st row063-851-5809
2nd row063-835-2525
3rd row063-838-7001
4th row063-854-5812
5th row063-835-9955
ValueCountFrequency (%)
063-835-5881 2
 
2.1%
063-858-1566 1
 
1.0%
063-851-3500 1
 
1.0%
063-856-4074 1
 
1.0%
063-855-5537 1
 
1.0%
063-858-2770 1
 
1.0%
063-852-5444 1
 
1.0%
063-853-7653 1
 
1.0%
063-855-9714 1
 
1.0%
063-861-0776 1
 
1.0%
Other values (85) 85
88.5%
2024-03-14T20:19:32.192831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 192
16.7%
3 177
15.4%
6 155
13.5%
8 144
12.5%
0 135
11.7%
5 119
10.3%
1 57
 
4.9%
2 51
 
4.4%
4 49
 
4.3%
7 39
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 960
83.3%
Dash Punctuation 192
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 177
18.4%
6 155
16.1%
8 144
15.0%
0 135
14.1%
5 119
12.4%
1 57
 
5.9%
2 51
 
5.3%
4 49
 
5.1%
7 39
 
4.1%
9 34
 
3.5%
Dash Punctuation
ValueCountFrequency (%)
- 192
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1152
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 192
16.7%
3 177
15.4%
6 155
13.5%
8 144
12.5%
0 135
11.7%
5 119
10.3%
1 57
 
4.9%
2 51
 
4.4%
4 49
 
4.3%
7 39
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1152
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 192
16.7%
3 177
15.4%
6 155
13.5%
8 144
12.5%
0 135
11.7%
5 119
10.3%
1 57
 
4.9%
2 51
 
4.4%
4 49
 
4.3%
7 39
 
3.4%

비고
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
영업중
97 
폐업
15 
휴업
 
1

Length

Max length3
Median length3
Mean length2.8584071
Min length2

Unique

Unique1 ?
Unique (%)0.9%

Sample

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

Common Values

ValueCountFrequency (%)
영업중 97
85.8%
폐업 15
 
13.3%
휴업 1
 
0.9%

Length

2024-03-14T20:19:32.621305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:19:32.896465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 97
85.8%
폐업 15
 
13.3%
휴업 1
 
0.9%

Correlations

2024-03-14T20:19:33.047982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전화번호비고
전화번호1.0001.000
비고1.0001.000

Missing values

2024-03-14T20:19:23.852982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:19:24.131409image/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농바시공인행정사전북특별자치도 익산시 황등면 황등7길 25-12<NA>영업중
1법무사 최홍규 사무소전북특별자치도 익산시 주현로 29-1(주현동)063-851-5809영업중
2이용배행정사전북특별자치도 익산시 석암로 227, 2층(석암동)063-835-2525영업중
3이길남행정사전북특별자치도 익산시 주현로 42, 상가동 1층 102호(주현동)063-838-7001영업중
4최정호 행정사전북특별자치도 익산시 무왕로 1031(영등동)<NA>영업중
5공인 행정사 사무소전북특별자치도 익산시 선화로3길 40 (모현동1가)063-854-5812영업중
6신우행정사전북특별자치도 익산시 동서로 187, 1층 (남중동)<NA>영업중
7조용식 행정사사무소전북특별자치도 익산시 하나로 426, 3층 (어양동)063-835-9955영업중
8행정사 공인중개사사무소 선우전북특별자치도 익산시 서동로8길 52(동산동)063-832-8432영업중
9드림 행정사전북특별자치도 익산시 익산대로64길 33 (신동)063-857-4859영업중
명 칭소재지전화번호비고
103일반공인행정사 손대봉사무소전북특별자치도 익산시 모현동1가 227번지 3호<NA>폐업
104일반행정사 문옥현사무소전북특별자치도 익산시 황등면 황등로 123063-856-5449영업중
105일반행정사 권이선사무소전북특별자치도 익산시 주현로 36 (주현동)063-841-3461영업중
106일반행정사 이용환사무소전북특별자치도 익산시 금마면 동고도리 785번지063-853-6278영업중
107일반행정사 김태환사무소전북특별자치도 익산시 인북로 115 (갈산동)063-837-7624영업중
108일반행정사 김위철사무소전북특별자치도 익산시 선화로29길 33 (남중동)063-855-2581폐업
109일반행정사 소신섭사무소전북특별자치도 익산시 금마면 동고도리 885번지 7호063-853-8585영업중
110박저규행정사사무소전북특별자치도 익산시 무왕로6길 27 (신동)<NA>폐업
111김규철 행정사무소전북특별자치도 익산시 영등동 254번지 25호063-841-6055영업중
112일반행정사 권대경사무소전북특별자치도 익산시 함열읍 함열로 18063-861-0679폐업

Duplicate rows

Most frequently occurring

명 칭소재지전화번호비고# duplicates
0신우전북특별자치도 익산시 무왕로 1213 (부송동)063-835-5881영업중2