Overview

Dataset statistics

Number of variables6
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory53.9 B

Variable types

Numeric1
DateTime1
Text2
Categorical2

Dataset

Description경상남도 거제시 행정업무를 위한 행정사사무소 현황자료로써 신고일, 명칭, 운영상태, 주소, 기준일자에 대한 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15029822/fileData.do

Alerts

기준일자 has constant value ""Constant
운영상태 is highly imbalanced (77.1%)Imbalance
일련번호 has unique valuesUnique
신고일 has unique valuesUnique
사무소명칭 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:26:34.878610
Analysis finished2023-12-12 05:26:35.457223
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-12T14:26:35.544479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2023-12-12T14:26:35.764645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

신고일
Date

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum1997-01-13 00:00:00
Maximum2023-05-01 00:00:00
2023-12-12T14:26:35.903834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:26:36.035748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)

사무소명칭
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T14:26:36.240113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10
Mean length9.3333333
Min length5

Characters and Unicode

Total characters252
Distinct characters62
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

Unique27 ?
Unique (%)100.0%

Sample

1st row이성회 행정사
2nd row강승남 행정사
3rd row콜롬보행정사민원사무소
4th row박행정사 사무소
5th row명문행정사사무소
ValueCountFrequency (%)
행정사 10
18.9%
사무소 9
17.0%
행정사사무소 6
 
11.3%
이성회 1
 
1.9%
강도현 1
 
1.9%
거제 1
 
1.9%
김종도 1
 
1.9%
희망 1
 
1.9%
거제행정사사무소 1
 
1.9%
아주행정사사무소 1
 
1.9%
Other values (21) 21
39.6%
2023-12-12T14:26:36.561623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
50
19.8%
28
11.1%
27
10.7%
26
10.3%
23
 
9.1%
23
 
9.1%
4
 
1.6%
3
 
1.2%
3
 
1.2%
3
 
1.2%
Other values (52) 62
24.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 223
88.5%
Space Separator 26
 
10.3%
Uppercase Letter 2
 
0.8%
Lowercase Letter 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
50
22.4%
28
12.6%
27
12.1%
23
10.3%
23
10.3%
4
 
1.8%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (48) 56
25.1%
Uppercase Letter
ValueCountFrequency (%)
S 1
50.0%
E 1
50.0%
Space Separator
ValueCountFrequency (%)
26
100.0%
Lowercase Letter
ValueCountFrequency (%)
n 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 223
88.5%
Common 26
 
10.3%
Latin 3
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
50
22.4%
28
12.6%
27
12.1%
23
10.3%
23
10.3%
4
 
1.8%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (48) 56
25.1%
Latin
ValueCountFrequency (%)
S 1
33.3%
n 1
33.3%
E 1
33.3%
Common
ValueCountFrequency (%)
26
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 223
88.5%
ASCII 29
 
11.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
50
22.4%
28
12.6%
27
12.1%
23
10.3%
23
10.3%
4
 
1.8%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (48) 56
25.1%
ASCII
ValueCountFrequency (%)
26
89.7%
S 1
 
3.4%
n 1
 
3.4%
E 1
 
3.4%

운영상태
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
영업중
26 
휴업
 
1

Length

Max length3
Median length3
Mean length2.962963
Min length2

Unique

Unique1 ?
Unique (%)3.7%

Sample

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

Common Values

ValueCountFrequency (%)
영업중 26
96.3%
휴업 1
 
3.7%

Length

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

Common Values (Plot)

2023-12-12T14:26:36.802901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 26
96.3%
휴업 1
 
3.7%

소재지
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-12T14:26:37.027456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length38
Mean length30.777778
Min length20

Characters and Unicode

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

Unique27 ?
Unique (%)100.0%

Sample

1st row경상남도 거제시 고현로4길 47 (고현동)
2nd row경상남도 거제시 진목로 19,201호 (옥포동)
3rd row경상남도 거제시 거제중앙로13길 7-0 (고현동)
4th row경상남도 거제시 진목로 19,B동 201호 (옥포동,진영에이스타운)
5th row경상남도 거제시 거제중앙로 1871-1,3층 (고현동)
ValueCountFrequency (%)
경상남도 27
20.0%
거제시 27
20.0%
고현동 5
 
3.7%
계룡로 4
 
3.0%
옥포동 4
 
3.0%
거제중앙로 3
 
2.2%
거제중앙로13길 3
 
2.2%
1001호 2
 
1.5%
옥포대첩로 2
 
1.5%
201호 2
 
1.5%
Other values (55) 56
41.5%
2023-12-12T14:26:37.480536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
 
13.0%
1 50
 
6.0%
37
 
4.5%
37
 
4.5%
32
 
3.9%
31
 
3.7%
28
 
3.4%
27
 
3.2%
27
 
3.2%
27
 
3.2%
Other values (77) 427
51.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 485
58.4%
Decimal Number 149
 
17.9%
Space Separator 108
 
13.0%
Close Punctuation 26
 
3.1%
Other Punctuation 26
 
3.1%
Open Punctuation 26
 
3.1%
Dash Punctuation 7
 
0.8%
Uppercase Letter 4
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
37
 
7.6%
37
 
7.6%
32
 
6.6%
31
 
6.4%
28
 
5.8%
27
 
5.6%
27
 
5.6%
27
 
5.6%
23
 
4.7%
17
 
3.5%
Other values (59) 199
41.0%
Decimal Number
ValueCountFrequency (%)
1 50
33.6%
0 25
16.8%
2 18
 
12.1%
3 17
 
11.4%
7 10
 
6.7%
9 7
 
4.7%
8 6
 
4.0%
6 6
 
4.0%
4 6
 
4.0%
5 4
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
C 2
50.0%
K 1
25.0%
B 1
25.0%
Space Separator
ValueCountFrequency (%)
108
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Other Punctuation
ValueCountFrequency (%)
26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 485
58.4%
Common 342
41.2%
Latin 4
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
37
 
7.6%
37
 
7.6%
32
 
6.6%
31
 
6.4%
28
 
5.8%
27
 
5.6%
27
 
5.6%
27
 
5.6%
23
 
4.7%
17
 
3.5%
Other values (59) 199
41.0%
Common
ValueCountFrequency (%)
108
31.6%
1 50
14.6%
) 26
 
7.6%
26
 
7.6%
( 26
 
7.6%
0 25
 
7.3%
2 18
 
5.3%
3 17
 
5.0%
7 10
 
2.9%
9 7
 
2.0%
Other values (5) 29
 
8.5%
Latin
ValueCountFrequency (%)
C 2
50.0%
K 1
25.0%
B 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 485
58.4%
ASCII 320
38.5%
None 26
 
3.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
33.8%
1 50
15.6%
) 26
 
8.1%
( 26
 
8.1%
0 25
 
7.8%
2 18
 
5.6%
3 17
 
5.3%
7 10
 
3.1%
9 7
 
2.2%
- 7
 
2.2%
Other values (7) 26
 
8.1%
Hangul
ValueCountFrequency (%)
37
 
7.6%
37
 
7.6%
32
 
6.6%
31
 
6.4%
28
 
5.8%
27
 
5.6%
27
 
5.6%
27
 
5.6%
23
 
4.7%
17
 
3.5%
Other values (59) 199
41.0%
None
ValueCountFrequency (%)
26
100.0%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-06-19
27 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-19
2nd row2023-06-19
3rd row2023-06-19
4th row2023-06-19
5th row2023-06-19

Common Values

ValueCountFrequency (%)
2023-06-19 27
100.0%

Length

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

Common Values (Plot)

2023-12-12T14:26:37.743045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-19 27
100.0%

Interactions

2023-12-12T14:26:35.114853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:26:37.812271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호신고일사무소명칭운영상태소재지
일련번호1.0001.0001.0000.6081.000
신고일1.0001.0001.0001.0001.000
사무소명칭1.0001.0001.0001.0001.000
운영상태0.6081.0001.0001.0001.000
소재지1.0001.0001.0001.0001.000
2023-12-12T14:26:37.921695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호운영상태
일련번호1.0000.000
운영상태0.0001.000

Missing values

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

일련번호신고일사무소명칭운영상태소재지기준일자
011997-01-13이성회 행정사영업중경상남도 거제시 고현로4길 47 (고현동)2023-06-19
122001-02-16강승남 행정사영업중경상남도 거제시 진목로 19,201호 (옥포동)2023-06-19
232014-04-08콜롬보행정사민원사무소영업중경상남도 거제시 거제중앙로13길 7-0 (고현동)2023-06-19
342016-04-18박행정사 사무소영업중경상남도 거제시 진목로 19,B동 201호 (옥포동,진영에이스타운)2023-06-19
452016-12-09명문행정사사무소영업중경상남도 거제시 거제중앙로 1871-1,3층 (고현동)2023-06-19
562018-02-19위더스 행정사 사무소영업중경상남도 거제시 옥포로4길 1 (옥포동)2023-06-19
672018-07-31거제이민행정사영업중경상남도 거제시 옥포대첩로 25,에이원오피스텔 10층 1001호 (옥포동)2023-06-19
782019-05-23한마음 행정사 사무소영업중경상남도 거제시 옥포대첩로 39,에버그린모텔 9층 (옥포동)2023-06-19
892020-07-21센스행정사사무소영업중경상남도 거제시 계룡로 110,세야오피스텔 201호 (고현동)2023-06-19
9102021-07-09정창엽행정사사무소영업중경상남도 거제시 거제대로 3541,아주빌딩 3층 (아주동)2023-06-19
일련번호신고일사무소명칭운영상태소재지기준일자
17182022-08-11행정사 강성준 사무소영업중경상남도 거제시 거제중앙로13길 27-1(고현동)2023-06-19
18192022-10-27글로벌 파트너스 행정사사무소영업중경상남도 거제시 거제중앙로 1930-10,1105호(고현동,고현동주상복합아파트)2023-06-19
19202022-11-08명성 행정사 사무소영업중경상남도 거제시 연초면 오비3길 142023-06-19
20212022-11-28아주행정사사무소영업중경상남도 거제시 아주1로2길 102,1층(아주동)2023-06-19
21222022-11-30거제행정사사무소영업중경상남도 거제시 상동3길 15,108동 702호(상동동,힐스테이트 거제)2023-06-19
22232022-12-28희망 행정사사무소영업중경상남도 거제시 고현로9길 29(고현동)2023-06-19
23242023-03-06김종도 행정사사무소영업중경상남도 거제시 계룡로 180,1층(고현동)2023-06-19
24252023-03-16거제 행정사사무소영업중경상남도 거제시 계룡로 168,상가2호(고현동,송림아파트)2023-06-19
25262023-04-07강도현 행정사사무소영업중경상남도 거제시 용소1길 17-10,106동 1001호 (아주동,거제아주 KCC스위첸)2023-06-19
26272023-05-01행정사 반민규 사무소영업중경상남도 거제시 거제중앙로16길 17,영진오피스텔 610호 (고현동)2023-06-19