Overview

Dataset statistics

Number of variables6
Number of observations65
Missing cells24
Missing cells (%)6.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.2 KiB
Average record size in memory50.0 B

Variable types

DateTime1
Categorical2
Text3

Dataset

Description강원도 원주시 행정사사무소 정보(신고연월일, 행정사종류, 사무소명칭, 주소, 전화번호, 데이터기준일자)를 제공합니다.
Author강원특별자치도 원주시
URLhttps://www.data.go.kr/data/15028788/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
행정사종류 is highly imbalanced (88.5%)Imbalance
사무소 전화번호 has 24 (36.9%) missing valuesMissing
사무소명칭 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:27:51.786829
Analysis finished2023-12-12 05:27:52.380024
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신고연월일
Date

Distinct61
Distinct (%)93.8%
Missing0
Missing (%)0.0%
Memory size652.0 B
Minimum1995-10-25 00:00:00
Maximum2023-07-13 00:00:00
2023-12-12T14:27:52.449415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:27:52.887498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

행정사종류
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size652.0 B
일반행정사
64 
외국어번역행정사(영어)
 
1

Length

Max length12
Median length5
Mean length5.1076923
Min length5

Unique

Unique1 ?
Unique (%)1.5%

Sample

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

Common Values

ValueCountFrequency (%)
일반행정사 64
98.5%
외국어번역행정사(영어) 1
 
1.5%

Length

2023-12-12T14:27:53.032019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:27:53.280822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반행정사 64
98.5%
외국어번역행정사(영어 1
 
1.5%

사무소명칭
Text

UNIQUE 

Distinct65
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size652.0 B
2023-12-12T14:27:53.685086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length9.3846154
Min length2

Characters and Unicode

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

Unique

Unique65 ?
Unique (%)100.0%

Sample

1st rowD&C 행정사 사무소
2nd row뉴 만종 행정사 사무소
3rd row유명림행정사사무소
4th row솔라 명탐정 행정사
5th row더 플러스 노마드행정사
ValueCountFrequency (%)
행정사 20
 
17.5%
사무소 17
 
14.9%
행정사사무소 4
 
3.5%
박장호행정사사무소 1
 
0.9%
정재일행정사사무소 1
 
0.9%
모범행정사 1
 
0.9%
김동규 1
 
0.9%
신승표행정사사무소 1
 
0.9%
행정사김동준사무소 1
 
0.9%
행정사김태형사무소 1
 
0.9%
Other values (66) 66
57.9%
2023-12-12T14:27:54.180468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 116
19.0%
정 65
 
10.7%
행 63
 
10.3%
무 57
 
9.3%
소 57
 
9.3%
49
 
8.0%
김 9
 
1.5%
이 8
 
1.3%
재 5
 
0.8%
원 5
 
0.8%
Other values (118) 176
28.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 553
90.7%
Space Separator 49
 
8.0%
Uppercase Letter 5
 
0.8%
Other Punctuation 3
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 116
21.0%
정 65
 
11.8%
행 63
 
11.4%
무 57
 
10.3%
소 57
 
10.3%
김 9
 
1.6%
이 8
 
1.4%
재 5
 
0.9%
원 5
 
0.9%
성 5
 
0.9%
Other values (109) 163
29.5%
Uppercase Letter
ValueCountFrequency (%)
D 1
20.0%
P 1
20.0%
M 1
20.0%
J 1
20.0%
C 1
20.0%
Other Punctuation
ValueCountFrequency (%)
. 1
33.3%
& 1
33.3%
· 1
33.3%
Space Separator
ValueCountFrequency (%)
49
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 553
90.7%
Common 52
 
8.5%
Latin 5
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 116
21.0%
정 65
 
11.8%
행 63
 
11.4%
무 57
 
10.3%
소 57
 
10.3%
김 9
 
1.6%
이 8
 
1.4%
재 5
 
0.9%
원 5
 
0.9%
성 5
 
0.9%
Other values (109) 163
29.5%
Latin
ValueCountFrequency (%)
D 1
20.0%
P 1
20.0%
M 1
20.0%
J 1
20.0%
C 1
20.0%
Common
ValueCountFrequency (%)
49
94.2%
. 1
 
1.9%
& 1
 
1.9%
· 1
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 553
90.7%
ASCII 56
 
9.2%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 116
21.0%
정 65
 
11.8%
행 63
 
11.4%
무 57
 
10.3%
소 57
 
10.3%
김 9
 
1.6%
이 8
 
1.4%
재 5
 
0.9%
원 5
 
0.9%
성 5
 
0.9%
Other values (109) 163
29.5%
ASCII
ValueCountFrequency (%)
49
87.5%
D 1
 
1.8%
P 1
 
1.8%
M 1
 
1.8%
J 1
 
1.8%
C 1
 
1.8%
. 1
 
1.8%
& 1
 
1.8%
None
ValueCountFrequency (%)
· 1
100.0%

사무소 도로명전체주소
Text

Distinct62
Distinct (%)95.4%
Missing0
Missing (%)0.0%
Memory size652.0 B
2023-12-12T14:27:54.642737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length48
Mean length31.169231
Min length22

Characters and Unicode

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

Unique

Unique59 ?
Unique (%)90.8%

Sample

1st row강원특별자치도 원주시 서원대로 500， 4층 402-G6호(단구동)
2nd row강원특별자치도 원주시 호저면 운동들2길 21-4
3rd row강원특별자치도 원주시 서원대로 500， 402-22(단구동)
4th row강원특별자치도 원주시 북원로 2684， 2층 201호(태장동)
5th row강원특별자치도 원주시 지정면 신지정로 300， 607동 1404호(원주 롯데캐슬 골드파크 2차)
ValueCountFrequency (%)
강원특별자치도 65
 
17.2%
원주시 65
 
17.2%
학성동 10
 
2.6%
무실동 9
 
2.4%
남산로 7
 
1.8%
북원로 6
 
1.6%
단계동 4
 
1.1%
만대로 4
 
1.1%
태장동， 3
 
0.8%
치악로 3
 
0.8%
Other values (165) 203
53.6%
2023-12-12T14:27:55.323057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
314
 
15.5%
원 151
 
7.5%
동 71
 
3.5%
2 71
 
3.5%
주 70
 
3.5%
시 68
 
3.4%
치 68
 
3.4%
도 66
 
3.3%
1 65
 
3.2%
강 65
 
3.2%
Other values (135) 1017
50.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1225
60.5%
Decimal Number 319
 
15.7%
Space Separator 314
 
15.5%
Close Punctuation 56
 
2.8%
Open Punctuation 56
 
2.8%
Other Punctuation 37
 
1.8%
Dash Punctuation 17
 
0.8%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 151
 
12.3%
동 71
 
5.8%
주 70
 
5.7%
시 68
 
5.6%
치 68
 
5.6%
도 66
 
5.4%
강 65
 
5.3%
특 65
 
5.3%
자 65
 
5.3%
별 65
 
5.3%
Other values (118) 471
38.4%
Decimal Number
ValueCountFrequency (%)
2 71
22.3%
1 65
20.4%
0 51
16.0%
4 30
9.4%
5 25
 
7.8%
8 24
 
7.5%
3 18
 
5.6%
6 17
 
5.3%
7 12
 
3.8%
9 6
 
1.9%
Uppercase Letter
ValueCountFrequency (%)
G 1
50.0%
F 1
50.0%
Space Separator
ValueCountFrequency (%)
314
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%
Other Punctuation
ValueCountFrequency (%)
， 37
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1225
60.5%
Common 799
39.4%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 151
 
12.3%
동 71
 
5.8%
주 70
 
5.7%
시 68
 
5.6%
치 68
 
5.6%
도 66
 
5.4%
강 65
 
5.3%
특 65
 
5.3%
자 65
 
5.3%
별 65
 
5.3%
Other values (118) 471
38.4%
Common
ValueCountFrequency (%)
314
39.3%
2 71
 
8.9%
1 65
 
8.1%
) 56
 
7.0%
( 56
 
7.0%
0 51
 
6.4%
， 37
 
4.6%
4 30
 
3.8%
5 25
 
3.1%
8 24
 
3.0%
Other values (5) 70
 
8.8%
Latin
ValueCountFrequency (%)
G 1
50.0%
F 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1225
60.5%
ASCII 764
37.7%
None 37
 
1.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
314
41.1%
2 71
 
9.3%
1 65
 
8.5%
) 56
 
7.3%
( 56
 
7.3%
0 51
 
6.7%
4 30
 
3.9%
5 25
 
3.3%
8 24
 
3.1%
3 18
 
2.4%
Other values (6) 54
 
7.1%
Hangul
ValueCountFrequency (%)
원 151
 
12.3%
동 71
 
5.8%
주 70
 
5.7%
시 68
 
5.6%
치 68
 
5.6%
도 66
 
5.4%
강 65
 
5.3%
특 65
 
5.3%
자 65
 
5.3%
별 65
 
5.3%
Other values (118) 471
38.4%
None
ValueCountFrequency (%)
， 37
100.0%

사무소 전화번호
Text

MISSING 

Distinct40
Distinct (%)97.6%
Missing24
Missing (%)36.9%
Memory size652.0 B
2023-12-12T14:27:55.579850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.463415
Min length1

Characters and Unicode

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

Unique39 ?
Unique (%)95.1%

Sample

1st row033-747-1288
2nd row033-733-4073
3rd row033-734-2410
4th row
5th row033-765-7715
ValueCountFrequency (%)
033-735-3403 1
 
2.4%
033-743-4402 1
 
2.4%
033-745-9357 1
 
2.4%
033-761-7566 1
 
2.4%
033-749-8487 1
 
2.4%
033-743-4259 1
 
2.4%
033-730-0919 1
 
2.4%
033-746-3222 1
 
2.4%
033-746-5119 1
 
2.4%
033-766-4140 1
 
2.4%
Other values (31) 31
75.6%
2023-12-12T14:27:56.016516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 106
22.6%
- 76
16.2%
0 71
15.1%
7 54
11.5%
4 34
 
7.2%
5 24
 
5.1%
6 22
 
4.7%
2 21
 
4.5%
1 20
 
4.3%
9 20
 
4.3%
Other values (2) 22
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 390
83.0%
Dash Punctuation 76
 
16.2%
Space Separator 4
 
0.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 106
27.2%
0 71
18.2%
7 54
13.8%
4 34
 
8.7%
5 24
 
6.2%
6 22
 
5.6%
2 21
 
5.4%
1 20
 
5.1%
9 20
 
5.1%
8 18
 
4.6%
Dash Punctuation
ValueCountFrequency (%)
- 76
100.0%
Space Separator
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 470
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 106
22.6%
- 76
16.2%
0 71
15.1%
7 54
11.5%
4 34
 
7.2%
5 24
 
5.1%
6 22
 
4.7%
2 21
 
4.5%
1 20
 
4.3%
9 20
 
4.3%
Other values (2) 22
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 470
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 106
22.6%
- 76
16.2%
0 71
15.1%
7 54
11.5%
4 34
 
7.2%
5 24
 
5.1%
6 22
 
4.7%
2 21
 
4.5%
1 20
 
4.3%
9 20
 
4.3%
Other values (2) 22
 
4.7%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size652.0 B
2023-08-31
65 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-31
2nd row2023-08-31
3rd row2023-08-31
4th row2023-08-31
5th row2023-08-31

Common Values

ValueCountFrequency (%)
2023-08-31 65
100.0%

Length

2023-12-12T14:27:56.245369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:27:56.364617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-31 65
100.0%

Correlations

2023-12-12T14:27:56.448077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신고연월일행정사종류사무소명칭사무소 도로명전체주소사무소 전화번호
신고연월일1.0001.0001.0000.9840.982
행정사종류1.0001.0001.0001.0001.000
사무소명칭1.0001.0001.0001.0001.000
사무소 도로명전체주소0.9841.0001.0001.0000.995
사무소 전화번호0.9821.0001.0000.9951.000

Missing values

2023-12-12T14:27:52.224193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:27:52.343541image/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

신고연월일행정사종류사무소명칭사무소 도로명전체주소사무소 전화번호데이터기준일자
02023-02-16일반행정사D&C 행정사 사무소강원특별자치도 원주시 서원대로 500， 4층 402-G6호(단구동)<NA>2023-08-31
12023-02-15일반행정사뉴 만종 행정사 사무소강원특별자치도 원주시 호저면 운동들2길 21-4033-747-12882023-08-31
22023-02-13일반행정사유명림행정사사무소강원특별자치도 원주시 서원대로 500， 402-22(단구동)<NA>2023-08-31
32022-12-29일반행정사솔라 명탐정 행정사강원특별자치도 원주시 북원로 2684， 2층 201호(태장동)033-733-40732023-08-31
42022-11-16일반행정사더 플러스 노마드행정사강원특별자치도 원주시 지정면 신지정로 300， 607동 1404호(원주 롯데캐슬 골드파크 2차)<NA>2023-08-31
52023-07-13일반행정사여준성 원주와함께 행정사 사무소강원특별자치도 원주시 만대로 200-22， 402호(무실동)033-734-24102023-08-31
62022-04-01일반행정사바른길 행정사사무소강원특별자치도 원주시 로아노크로 15， 101동 204호(단계동， 코오롱아파트)2023-08-31
72023-06-05일반행정사JMP행정사사무소강원특별자치도 원주시 혁신로 92， 413동 1702호 (반곡동， 푸른숨 휴브레스)<NA>2023-08-31
82022-01-11외국어번역행정사(영어)이주연공인번역행정사강원특별자치도 원주시 서원대로 500， F304(단구동)033-765-77152023-08-31
92021-12-27일반행정사삼우행정사강원특별자치도 원주시 만대로 16-7， 제2동 202호(무실동)033-733-39772023-08-31
신고연월일행정사종류사무소명칭사무소 도로명전체주소사무소 전화번호데이터기준일자
552013-01-02일반행정사행정사맹재성사무소강원특별자치도 원주시 남산로 206 (학성동)033-742-53002023-08-31
562013-01-02일반행정사행정사김재성사무소강원특별자치도 원주시 무실새골길 12 (무실동)033-747-87002023-08-31
572012-12-26일반행정사행정사차상길사무소강원특별자치도 원주시 남산로 184 (학성동)033-732-77002023-08-31
582004-10-18일반행정사행정사안흥청사무소강원특별자치도 원주시 치악로 1339 (관설동)033-761-49832023-08-31
592004-12-24일반행정사행정사진기창사무소강원특별자치도 원주시 치악로 1754-2 (개운동)033-761-90552023-08-31
602004-12-24일반행정사치악행정사사무소강원특별자치도 원주시 원일로 182-1 (학성동)033-731-57792023-08-31
612012-12-10일반행정사행정사김도형사무소강원특별자치도 원주시 무실로 195 (명륜동)033-766-41402023-08-31
622011-06-29일반행정사송재성 행정사 사무소강원특별자치도 원주시 단구로 66 (단계동)<NA>2023-08-31
632008-09-18일반행정사박용선행정사사무소강원특별자치도 원주시 문막읍 원문로 1802033-734-89992023-08-31
641995-10-25일반행정사이강식사무소강원특별자치도 원주시 원일로 24 (인동)033-762-06102023-08-31