Overview

Dataset statistics

Number of variables6
Number of observations29
Missing cells14
Missing cells (%)8.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory54.6 B

Variable types

Numeric2
Text3
Categorical1

Dataset

Description충청남도 계룡시에 등록된 행정사사무소 현황데이터를 공공데이터로 제공합니다.(상호명, 주소, 전화번호 등)(상호명, 주소, 전화번호 등)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=414&beforeMenuCd=DOM_000000201001001000&publicdatapk=15028847

Alerts

비고 has constant value ""Constant
사무소 전화번호 has 14 (48.3%) missing valuesMissing
일련 번호 has unique valuesUnique
사무소 명 칭 has unique valuesUnique
사무소 소재지 has unique valuesUnique

Reproduction

Analysis started2024-01-09 19:58:39.280688
Analysis finished2024-01-09 19:58:40.410666
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련 번호
Real number (ℝ)

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15
Minimum1
Maximum29
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2024-01-10T04:58:40.503959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.4
Q18
median15
Q322
95-th percentile27.6
Maximum29
Range28
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.5146932
Coefficient of variation (CV)0.56764621
Kurtosis-1.2
Mean15
Median Absolute Deviation (MAD)7
Skewness0
Sum435
Variance72.5
MonotonicityStrictly increasing
2024-01-10T04:58:40.670568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
1 1
 
3.4%
2 1
 
3.4%
29 1
 
3.4%
28 1
 
3.4%
27 1
 
3.4%
26 1
 
3.4%
25 1
 
3.4%
24 1
 
3.4%
23 1
 
3.4%
22 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
1 1
3.4%
2 1
3.4%
3 1
3.4%
4 1
3.4%
5 1
3.4%
6 1
3.4%
7 1
3.4%
8 1
3.4%
9 1
3.4%
10 1
3.4%
ValueCountFrequency (%)
29 1
3.4%
28 1
3.4%
27 1
3.4%
26 1
3.4%
25 1
3.4%
24 1
3.4%
23 1
3.4%
22 1
3.4%
21 1
3.4%
20 1
3.4%

사무소 명 칭
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2024-01-10T04:58:40.923337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length69
Median length17
Mean length10.275862
Min length3

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row김용희행정사사무소
2nd row정현철행정사사무소
3rd row에코 환경분야 전문 행정사사무소
4th row한양행정사사무소
5th row인터내셔널 행정사사무소(International Office of Authorized Public Administrator)
ValueCountFrequency (%)
행정사사무소 2
 
5.1%
김용희행정사사무소 1
 
2.6%
운경행정사사무소 1
 
2.6%
강병수행정사사무소 1
 
2.6%
이동준행정사사무소 1
 
2.6%
박무근행정사사무소 1
 
2.6%
민우행정사무소 1
 
2.6%
국사봉 1
 
2.6%
소담행정사사무소 1
 
2.6%
김정연행정사사무소 1
 
2.6%
Other values (28) 28
71.8%
2024-01-10T04:58:41.405978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
47
15.8%
28
 
9.4%
28
 
9.4%
25
 
8.4%
21
 
7.0%
10
 
3.4%
7
 
2.3%
i 6
 
2.0%
t 5
 
1.7%
n 4
 
1.3%
Other values (84) 117
39.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 236
79.2%
Lowercase Letter 45
 
15.1%
Space Separator 10
 
3.4%
Uppercase Letter 5
 
1.7%
Open Punctuation 1
 
0.3%
Close Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
47
19.9%
28
11.9%
28
11.9%
25
 
10.6%
21
 
8.9%
7
 
3.0%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (60) 68
28.8%
Lowercase Letter
ValueCountFrequency (%)
i 6
13.3%
t 5
11.1%
n 4
8.9%
o 4
8.9%
r 4
8.9%
f 3
 
6.7%
a 3
 
6.7%
e 3
 
6.7%
c 2
 
4.4%
d 2
 
4.4%
Other values (7) 9
20.0%
Uppercase Letter
ValueCountFrequency (%)
A 2
40.0%
I 1
20.0%
O 1
20.0%
P 1
20.0%
Space Separator
ValueCountFrequency (%)
10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 236
79.2%
Latin 50
 
16.8%
Common 12
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
47
19.9%
28
11.9%
28
11.9%
25
 
10.6%
21
 
8.9%
7
 
3.0%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (60) 68
28.8%
Latin
ValueCountFrequency (%)
i 6
12.0%
t 5
 
10.0%
n 4
 
8.0%
o 4
 
8.0%
r 4
 
8.0%
f 3
 
6.0%
a 3
 
6.0%
e 3
 
6.0%
c 2
 
4.0%
d 2
 
4.0%
Other values (11) 14
28.0%
Common
ValueCountFrequency (%)
10
83.3%
( 1
 
8.3%
) 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 236
79.2%
ASCII 62
 
20.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
47
19.9%
28
11.9%
28
11.9%
25
 
10.6%
21
 
8.9%
7
 
3.0%
3
 
1.3%
3
 
1.3%
3
 
1.3%
3
 
1.3%
Other values (60) 68
28.8%
ASCII
ValueCountFrequency (%)
10
16.1%
i 6
 
9.7%
t 5
 
8.1%
n 4
 
6.5%
o 4
 
6.5%
r 4
 
6.5%
f 3
 
4.8%
a 3
 
4.8%
e 3
 
4.8%
c 2
 
3.2%
Other values (14) 18
29.0%

사무소 소재지
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2024-01-10T04:58:41.783179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length44
Mean length36.413793
Min length19

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row충청남도 계룡시 장안로 43, 대승빌딩 105호 (금암동)
2nd row충청남도 계룡시 엄사면 계백로 3051, 106동 1401호 (블루힐스)
3rd row충청남도 계룡시 서금암로 51-9, 101동 1101호 (금암동, 주공아파트)
4th row충청남도 계룡시 엄사면 번영로 10
5th row충청남도 계룡시 두마면 사계로 101 (계룡 더 샵 아파트)
ValueCountFrequency (%)
충청남도 29
 
12.8%
계룡시 29
 
12.8%
금암동 12
 
5.3%
엄사면 11
 
4.8%
2호 6
 
2.6%
장안로 5
 
2.2%
4호 5
 
2.2%
사계로 5
 
2.2%
두마면 5
 
2.2%
101동 5
 
2.2%
Other values (80) 115
50.7%
2024-01-10T04:58:42.316569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
198
 
18.8%
1 62
 
5.9%
41
 
3.9%
35
 
3.3%
31
 
2.9%
31
 
2.9%
31
 
2.9%
, 30
 
2.8%
29
 
2.7%
29
 
2.7%
Other values (72) 539
51.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 590
55.9%
Space Separator 198
 
18.8%
Decimal Number 181
 
17.1%
Other Punctuation 30
 
2.8%
Open Punctuation 24
 
2.3%
Close Punctuation 24
 
2.3%
Dash Punctuation 6
 
0.6%
Lowercase Letter 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
41
 
6.9%
35
 
5.9%
31
 
5.3%
31
 
5.3%
31
 
5.3%
29
 
4.9%
29
 
4.9%
29
 
4.9%
22
 
3.7%
20
 
3.4%
Other values (56) 292
49.5%
Decimal Number
ValueCountFrequency (%)
1 62
34.3%
0 23
 
12.7%
3 19
 
10.5%
4 19
 
10.5%
5 15
 
8.3%
2 15
 
8.3%
9 10
 
5.5%
6 9
 
5.0%
7 6
 
3.3%
8 3
 
1.7%
Space Separator
ValueCountFrequency (%)
198
100.0%
Other Punctuation
ValueCountFrequency (%)
, 30
100.0%
Open Punctuation
ValueCountFrequency (%)
( 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 24
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 590
55.9%
Common 463
43.8%
Latin 3
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
41
 
6.9%
35
 
5.9%
31
 
5.3%
31
 
5.3%
31
 
5.3%
29
 
4.9%
29
 
4.9%
29
 
4.9%
22
 
3.7%
20
 
3.4%
Other values (56) 292
49.5%
Common
ValueCountFrequency (%)
198
42.8%
1 62
 
13.4%
, 30
 
6.5%
( 24
 
5.2%
) 24
 
5.2%
0 23
 
5.0%
3 19
 
4.1%
4 19
 
4.1%
5 15
 
3.2%
2 15
 
3.2%
Other values (5) 34
 
7.3%
Latin
ValueCountFrequency (%)
e 3
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 590
55.9%
ASCII 466
44.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
198
42.5%
1 62
 
13.3%
, 30
 
6.4%
( 24
 
5.2%
) 24
 
5.2%
0 23
 
4.9%
3 19
 
4.1%
4 19
 
4.1%
5 15
 
3.2%
2 15
 
3.2%
Other values (6) 37
 
7.9%
Hangul
ValueCountFrequency (%)
41
 
6.9%
35
 
5.9%
31
 
5.3%
31
 
5.3%
31
 
5.3%
29
 
4.9%
29
 
4.9%
29
 
4.9%
22
 
3.7%
20
 
3.4%
Other values (56) 292
49.5%

우편번호
Real number (ℝ)

Distinct14
Distinct (%)48.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32821.345
Minimum32801
Maximum32837
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2024-01-10T04:58:42.473676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum32801
5-th percentile32804
Q132812
median32824
Q332827
95-th percentile32836.2
Maximum32837
Range36
Interquartile range (IQR)15

Descriptive statistics

Standard deviation10.764611
Coefficient of variation (CV)0.00032797592
Kurtosis-0.89626459
Mean32821.345
Median Absolute Deviation (MAD)5
Skewness-0.42621878
Sum951819
Variance115.87685
MonotonicityNot monotonic
2024-01-10T04:58:42.639025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
32824 4
13.8%
32826 3
10.3%
32827 3
10.3%
32835 3
10.3%
32804 2
6.9%
32837 2
6.9%
32825 2
6.9%
32806 2
6.9%
32810 2
6.9%
32812 2
6.9%
Other values (4) 4
13.8%
ValueCountFrequency (%)
32801 1
 
3.4%
32804 2
6.9%
32806 2
6.9%
32810 2
6.9%
32812 2
6.9%
32820 1
 
3.4%
32821 1
 
3.4%
32824 4
13.8%
32825 2
6.9%
32826 3
10.3%
ValueCountFrequency (%)
32837 2
6.9%
32835 3
10.3%
32829 1
 
3.4%
32827 3
10.3%
32826 3
10.3%
32825 2
6.9%
32824 4
13.8%
32821 1
 
3.4%
32820 1
 
3.4%
32812 2
6.9%
Distinct15
Distinct (%)100.0%
Missing14
Missing (%)48.3%
Memory size364.0 B
2024-01-10T04:58:42.883656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.066667
Min length12

Characters and Unicode

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

Unique15 ?
Unique (%)100.0%

Sample

1st row042-551-5671
2nd row070-7608-3635
3rd row042-841-1122
4th row042-551-2162
5th row042-841-3006
ValueCountFrequency (%)
042-551-5671 1
 
6.7%
070-7608-3635 1
 
6.7%
042-841-1122 1
 
6.7%
042-551-2162 1
 
6.7%
042-841-3006 1
 
6.7%
042-840-5446 1
 
6.7%
042-840-7171 1
 
6.7%
042-543-2649 1
 
6.7%
042-841-3560 1
 
6.7%
042-551-2282 1
 
6.7%
Other values (5) 5
33.3%
2024-01-10T04:58:43.324307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 30
16.6%
4 27
14.9%
2 26
14.4%
0 24
13.3%
1 20
11.0%
5 17
9.4%
6 11
 
6.1%
8 9
 
5.0%
3 7
 
3.9%
7 6
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 151
83.4%
Dash Punctuation 30
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 27
17.9%
2 26
17.2%
0 24
15.9%
1 20
13.2%
5 17
11.3%
6 11
7.3%
8 9
 
6.0%
3 7
 
4.6%
7 6
 
4.0%
9 4
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 30
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 181
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 30
16.6%
4 27
14.9%
2 26
14.4%
0 24
13.3%
1 20
11.0%
5 17
9.4%
6 11
 
6.1%
8 9
 
5.0%
3 7
 
3.9%
7 6
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 181
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 30
16.6%
4 27
14.9%
2 26
14.4%
0 24
13.3%
1 20
11.0%
5 17
9.4%
6 11
 
6.1%
8 9
 
5.0%
3 7
 
3.9%
7 6
 
3.3%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size364.0 B
영업중
29 

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

Length

2024-01-10T04:58:43.505888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T04:58:43.642218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 29
100.0%

Interactions

2024-01-10T04:58:39.858574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:58:39.591737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:58:40.008922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:58:39.722146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T04:58:43.713059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련 번호사무소 명 칭사무소 소재지우편번호사무소 전화번호
일련\n번호1.0001.0001.0000.7261.000
사무소 명 칭1.0001.0001.0001.0001.000
사무소 소재지1.0001.0001.0001.0001.000
우편번호0.7261.0001.0001.0001.000
사무소 전화번호1.0001.0001.0001.0001.000
2024-01-10T04:58:43.871532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련 번호우편번호
일련\n번호1.000-0.369
우편번호-0.3691.000

Missing values

2024-01-10T04:58:40.189555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:58:40.344786image/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

일련 번호사무소 명 칭사무소 소재지우편번호사무소 전화번호비고
01김용희행정사사무소충청남도 계룡시 장안로 43, 대승빌딩 105호 (금암동)32826042-551-5671영업중
12정현철행정사사무소충청남도 계룡시 엄사면 계백로 3051, 106동 1401호 (블루힐스)32829070-7608-3635영업중
23에코 환경분야 전문 행정사사무소충청남도 계룡시 서금암로 51-9, 101동 1101호 (금암동, 주공아파트)32827<NA>영업중
34한양행정사사무소충청남도 계룡시 엄사면 번영로 1032804042-841-1122영업중
45인터내셔널 행정사사무소(International Office of Authorized Public Administrator)충청남도 계룡시 두마면 사계로 101 (계룡 더 샵 아파트)32837<NA>영업중
56청탄행정사충청남도 계룡시 장안로 75, 107동 14층 4호 (금암동, 우림루미아트아파트)32825042-551-2162영업중
67고광현사무소충청남도 계룡시 장안1길 9, 102동 4층 1호 (금암동, 신성미소지움1차아파트)32824042-841-3006영업중
78행정사변금섭사무소충청남도 계룡시 장안로 59-3, 1층 4호 (금암동, 천마빌딩)32826042-840-5446영업중
89행정사조동형사무소충청남도 계룡시 장안로 39, 2층 2호 (금암동, 호복빌딩)32826042-840-7171영업중
910박재춘일반행정사무소충청남도 계룡시 장안1길 20 (금암동)32824042-543-2649영업중
일련 번호사무소 명 칭사무소 소재지우편번호사무소 전화번호비고
1920김정연행정사사무소충청남도 계룡시 엄사면 번영로 43, 101동 7층 3호 (경남무궁화아파트)32810<NA>영업중
2021운경행정사사무소충청남도 계룡시 장안로 75, 101동 3층 2호 (금암동, 우림루미아트아파트)32825<NA>영업중
2122정종훈행정사사무소충청남도 계룡시 장안1길 9, 104동 13층 3호 (금암동, 신성미소지움1차아파트)32824<NA>영업중
2223행정사임장혁사무소충청남도 계룡시 장안1길 6 (금암동)32824<NA>영업중
2324대한행정사무소충청남도 계룡시 엄사면 번영로 1232804<NA>영업중
2425용성종사무소충청남도 계룡시 엄사면 번영로 43, 103동 8층 5호 (경남무궁화아파트)32810<NA>영업중
2526정해명사무소충청남도 계룡시 서금암4길 6-9, 103동 13층 3호 (금암동, 주공아파트)32827<NA>영업중
2627김광성사무소충청남도 계룡시 신도안면 신도안2길 41, 146동 2층 8호 (계룡대아파트)32801042-551-3402영업중
2728김주섭사무소충청남도 계룡시 엄사면 엄사중앙로 66, 9동 8층 6호 (성원아파트)32812042-841-9629영업중
2829김순섭사무소충청남도 계룡시 엄사면 엄사중앙로 66, 10동 14층 2호 (성원아파트)32812042-841-2461영업중