Overview

Dataset statistics

Number of variables7
Number of observations36
Missing cells12
Missing cells (%)4.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory59.7 B

Variable types

Text3
DateTime2
Categorical2

Dataset

Description경기도 이천시 행정사사무소현황에 대한 사무소명, 신고일자, 운영상태, 행정사종류, 소재지주소, 전화번호, 데이터 기준일자 정보를 확인할 수 있습니다.
Author경기도 이천시
URLhttps://www.data.go.kr/data/15038029/fileData.do

Alerts

운영상태 has constant value ""Constant
행정사종류 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 12 (33.3%) missing valuesMissing
사무소명 has unique valuesUnique

Reproduction

Analysis started2024-04-29 22:27:59.326757
Analysis finished2024-04-29 22:28:01.136114
Duration1.81 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사무소명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-04-30T07:28:01.285425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length17
Mean length10.472222
Min length3

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st rowDK행정사사무소
2nd row신성현 행정사사무소
3rd row최판규 행정사사무소
4th row올인원(All In One) 행정사 사무소
5th row오복행정사사무소
ValueCountFrequency (%)
행정사 10
 
14.3%
행정사사무소 6
 
8.6%
사무소 6
 
8.6%
일반행정사 4
 
5.7%
한울 2
 
2.9%
dk행정사사무소 1
 
1.4%
임소희행정사사무소 1
 
1.4%
개발컨설팅 1
 
1.4%
국제탐정행정사사무소 1
 
1.4%
임 1
 
1.4%
Other values (37) 37
52.9%
2024-04-30T07:28:01.596928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 70
18.6%
행 38
 
10.1%
정 38
 
10.1%
34
 
9.0%
소 32
 
8.5%
무 31
 
8.2%
반 4
 
1.1%
일 4
 
1.1%
P 3
 
0.8%
이 3
 
0.8%
Other values (92) 120
31.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 309
82.0%
Space Separator 34
 
9.0%
Uppercase Letter 24
 
6.4%
Lowercase Letter 5
 
1.3%
Close Punctuation 2
 
0.5%
Open Punctuation 2
 
0.5%
Other Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 70
22.7%
행 38
12.3%
정 38
12.3%
소 32
 
10.4%
무 31
 
10.0%
반 4
 
1.3%
일 4
 
1.3%
이 3
 
1.0%
김 3
 
1.0%
기 2
 
0.6%
Other values (70) 84
27.2%
Uppercase Letter
ValueCountFrequency (%)
P 3
12.5%
M 2
 
8.3%
R 2
 
8.3%
E 2
 
8.3%
S 2
 
8.3%
K 2
 
8.3%
O 2
 
8.3%
A 2
 
8.3%
D 1
 
4.2%
I 1
 
4.2%
Other values (5) 5
20.8%
Lowercase Letter
ValueCountFrequency (%)
l 2
40.0%
n 2
40.0%
e 1
20.0%
Space Separator
ValueCountFrequency (%)
34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
· 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 309
82.0%
Common 39
 
10.3%
Latin 29
 
7.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 70
22.7%
행 38
12.3%
정 38
12.3%
소 32
 
10.4%
무 31
 
10.0%
반 4
 
1.3%
일 4
 
1.3%
이 3
 
1.0%
김 3
 
1.0%
기 2
 
0.6%
Other values (70) 84
27.2%
Latin
ValueCountFrequency (%)
P 3
 
10.3%
M 2
 
6.9%
R 2
 
6.9%
E 2
 
6.9%
S 2
 
6.9%
K 2
 
6.9%
O 2
 
6.9%
l 2
 
6.9%
A 2
 
6.9%
n 2
 
6.9%
Other values (8) 8
27.6%
Common
ValueCountFrequency (%)
34
87.2%
) 2
 
5.1%
( 2
 
5.1%
· 1
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 309
82.0%
ASCII 67
 
17.8%
None 1
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 70
22.7%
행 38
12.3%
정 38
12.3%
소 32
 
10.4%
무 31
 
10.0%
반 4
 
1.3%
일 4
 
1.3%
이 3
 
1.0%
김 3
 
1.0%
기 2
 
0.6%
Other values (70) 84
27.2%
ASCII
ValueCountFrequency (%)
34
50.7%
P 3
 
4.5%
M 2
 
3.0%
R 2
 
3.0%
E 2
 
3.0%
S 2
 
3.0%
K 2
 
3.0%
) 2
 
3.0%
O 2
 
3.0%
l 2
 
3.0%
Other values (11) 14
20.9%
None
ValueCountFrequency (%)
· 1
100.0%

신고일자
Date

Distinct34
Distinct (%)94.4%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum1993-05-11 00:00:00
Maximum2024-02-23 00:00:00
2024-04-30T07:28:01.717754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:28:01.825315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)

운영상태
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
영업중
36 

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

Length

2024-04-30T07:28:01.936610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T07:28:02.025590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 36
100.0%

행정사종류
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
일반행정사
36 

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

Length

2024-04-30T07:28:02.117812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T07:28:02.216161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반행정사 36
100.0%

소재지주소
Text

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-04-30T07:28:02.431356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length25
Mean length21.638889
Min length14

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)94.4%

Sample

1st row경기도 이천시 서희로48번길 24
2nd row경기도 이천시 진상미로 2224
3rd row경기도 이천시 모가면 진상미로1537번길 22
4th row경기도 이천시 어재연로8번길 2, 2층
5th row경기도 이천시 부악로 30-44
ValueCountFrequency (%)
경기도 36
19.7%
이천시 36
19.7%
부악로 5
 
2.7%
16 4
 
2.2%
평산빌딩 3
 
1.6%
구만리로 3
 
1.6%
중리동 2
 
1.1%
407호 2
 
1.1%
모가면 2
 
1.1%
101호 2
 
1.1%
Other values (75) 88
48.1%
2024-04-30T07:28:02.783377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
147
18.9%
경 37
 
4.7%
도 37
 
4.7%
천 37
 
4.7%
이 36
 
4.6%
시 36
 
4.6%
기 36
 
4.6%
1 34
 
4.4%
로 31
 
4.0%
2 28
 
3.6%
Other values (69) 320
41.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 445
57.1%
Decimal Number 168
 
21.6%
Space Separator 147
 
18.9%
Other Punctuation 12
 
1.5%
Dash Punctuation 6
 
0.8%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
경 37
 
8.3%
도 37
 
8.3%
천 37
 
8.3%
이 36
 
8.1%
시 36
 
8.1%
기 36
 
8.1%
로 31
 
7.0%
호 19
 
4.3%
번 16
 
3.6%
길 11
 
2.5%
Other values (54) 149
33.5%
Decimal Number
ValueCountFrequency (%)
1 34
20.2%
2 28
16.7%
4 22
13.1%
0 19
11.3%
8 17
10.1%
7 16
9.5%
3 15
8.9%
6 9
 
5.4%
9 5
 
3.0%
5 3
 
1.8%
Other Punctuation
ValueCountFrequency (%)
, 11
91.7%
， 1
 
8.3%
Space Separator
ValueCountFrequency (%)
147
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 445
57.1%
Common 333
42.7%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
경 37
 
8.3%
도 37
 
8.3%
천 37
 
8.3%
이 36
 
8.1%
시 36
 
8.1%
기 36
 
8.1%
로 31
 
7.0%
호 19
 
4.3%
번 16
 
3.6%
길 11
 
2.5%
Other values (54) 149
33.5%
Common
ValueCountFrequency (%)
147
44.1%
1 34
 
10.2%
2 28
 
8.4%
4 22
 
6.6%
0 19
 
5.7%
8 17
 
5.1%
7 16
 
4.8%
3 15
 
4.5%
, 11
 
3.3%
6 9
 
2.7%
Other values (4) 15
 
4.5%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 445
57.1%
ASCII 333
42.7%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
147
44.1%
1 34
 
10.2%
2 28
 
8.4%
4 22
 
6.6%
0 19
 
5.7%
8 17
 
5.1%
7 16
 
4.8%
3 15
 
4.5%
, 11
 
3.3%
6 9
 
2.7%
Other values (4) 15
 
4.5%
Hangul
ValueCountFrequency (%)
경 37
 
8.3%
도 37
 
8.3%
천 37
 
8.3%
이 36
 
8.1%
시 36
 
8.1%
기 36
 
8.1%
로 31
 
7.0%
호 19
 
4.3%
번 16
 
3.6%
길 11
 
2.5%
Other values (54) 149
33.5%
None
ValueCountFrequency (%)
， 1
100.0%

전화번호
Text

MISSING 

Distinct23
Distinct (%)95.8%
Missing12
Missing (%)33.3%
Memory size420.0 B
2024-04-30T07:28:02.969452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique22 ?
Unique (%)91.7%

Sample

1st row031-635-9898
2nd row031-631-9231
3rd row031-637-1212
4th row031-632-2462
5th row031-636-0408
ValueCountFrequency (%)
031-632-2462 2
 
8.3%
031-633-7090 1
 
4.2%
031-635-9898 1
 
4.2%
031-632-3210 1
 
4.2%
031-634-6004 1
 
4.2%
031-633-3932 1
 
4.2%
031-338-5105 1
 
4.2%
031-633-4194 1
 
4.2%
031-637-0070 1
 
4.2%
031-633-6398 1
 
4.2%
Other values (13) 13
54.2%
2024-04-30T07:28:03.257059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 61
21.2%
- 48
16.7%
0 39
13.5%
1 36
12.5%
6 35
12.2%
2 14
 
4.9%
9 14
 
4.9%
4 13
 
4.5%
7 12
 
4.2%
8 10
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 240
83.3%
Dash Punctuation 48
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 61
25.4%
0 39
16.2%
1 36
15.0%
6 35
14.6%
2 14
 
5.8%
9 14
 
5.8%
4 13
 
5.4%
7 12
 
5.0%
8 10
 
4.2%
5 6
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 288
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
3 61
21.2%
- 48
16.7%
0 39
13.5%
1 36
12.5%
6 35
12.2%
2 14
 
4.9%
9 14
 
4.9%
4 13
 
4.5%
7 12
 
4.2%
8 10
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 288
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 61
21.2%
- 48
16.7%
0 39
13.5%
1 36
12.5%
6 35
12.2%
2 14
 
4.9%
9 14
 
4.9%
4 13
 
4.5%
7 12
 
4.2%
8 10
 
3.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum2024-03-22 00:00:00
Maximum2024-03-22 00:00:00
2024-04-30T07:28:03.366666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:28:03.459548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2024-04-30T07:28:03.531473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사무소명신고일자소재지주소전화번호
사무소명1.0001.0001.0001.000
신고일자1.0001.0000.9791.000
소재지주소1.0000.9791.0001.000
전화번호1.0001.0001.0001.000

Missing values

2024-04-30T07:28:00.920421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T07:28:01.083325image/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

사무소명신고일자운영상태행정사종류소재지주소전화번호데이터기준일자
0DK행정사사무소2024-02-23영업중일반행정사경기도 이천시 서희로48번길 24031-635-98982024-03-22
1신성현 행정사사무소2024-01-11영업중일반행정사경기도 이천시 진상미로 2224031-631-92312024-03-22
2최판규 행정사사무소2023-12-01영업중일반행정사경기도 이천시 모가면 진상미로1537번길 22<NA>2024-03-22
3올인원(All In One) 행정사 사무소2023-11-21영업중일반행정사경기도 이천시 어재연로8번길 2, 2층<NA>2024-03-22
4오복행정사사무소2023-07-05영업중일반행정사경기도 이천시 부악로 30-44031-637-12122024-03-22
5한울 노현호 행정사 사무소(MVP PARTNERS)2023-04-24영업중일반행정사경기도 이천시 부악로 16, 평산빌딩 304호031-632-24622024-03-22
6일반행정사 최용환 행정사사무소2022-07-04영업중일반행정사경기도 이천시 영창로124번길 94031-636-04082024-03-22
7이음 행정사사무소2022-07-01영업중일반행정사경기도 이천시 마장면 억만리로 84, A동 103호031-636-81332024-03-22
8희망행정사사무소2022-06-21영업중일반행정사경기도 이천시 장호원읍 서동대로8880번길 47-37, 407호<NA>2024-03-22
9대광행정사사무소2022-06-21영업중일반행정사경기도 이천시 구만리로 32<NA>2024-03-22
사무소명신고일자운영상태행정사종류소재지주소전화번호데이터기준일자
26개발컨설팅 행정사2017-08-24영업중일반행정사경기도 이천시 부악로 16 평산빌딩 407호031-634-64612024-03-22
27김재홍행정사사무소2018-01-16영업중일반행정사경기도 이천시 부악로 16 204호<NA>2024-03-22
28청담 김범기 행정사 사무소2022-09-26영업중일반행정사경기도 이천시 구만리로 229<NA>2024-03-22
29이천행정사사무소2014-08-28영업중일반행정사경기도 이천시 서희로 75031-633-63982024-03-22
30일반행정사 조원행사무소2013-01-03영업중일반행정사경기도 이천시 중리동 188번지 10호031-637-00702024-03-22
31일반행정사 백동기사무소2012-12-31영업중일반행정사경기도 이천시 증신로 273， 2동 101호031-633-41942024-03-22
32일반행정사 전병준사무소2013-01-04영업중일반행정사경기도 이천시 중리동 487번지031-338-51052024-03-22
33김영우행정사1993-05-11영업중일반행정사경기도 이천시 갈산로87번길 10-3031-633-39322024-03-22
34송정행정사2004-11-30영업중일반행정사경기도 이천시 송정동 428번지 1호 수림상가 102호031-634-60042024-03-22
35화신사2003-07-18영업중일반행정사경기도 이천시 관고동 8번지 17호031-638-97652024-03-22