Overview

Dataset statistics

Number of variables4
Number of observations48
Missing cells18
Missing cells (%)9.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory35.8 B

Variable types

Numeric1
Text3

Dataset

Description대전광역시 중구 행정사 현황에 대한 데이터입니다. 이 데이터는 대전광역시 중구 행정사의 상호명, 소재지, 전화번호를 제공합니다.
URLhttps://www.data.go.kr/data/15119523/fileData.do

Alerts

전화번호 has 18 (37.5%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 23:59:26.597007
Analysis finished2023-12-12 23:59:26.962086
Duration0.37 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.5
Minimum1
Maximum48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2023-12-13T08:59:27.035047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.35
Q112.75
median24.5
Q336.25
95-th percentile45.65
Maximum48
Range47
Interquartile range (IQR)23.5

Descriptive statistics

Standard deviation14
Coefficient of variation (CV)0.57142857
Kurtosis-1.2
Mean24.5
Median Absolute Deviation (MAD)12
Skewness0
Sum1176
Variance196
MonotonicityStrictly increasing
2023-12-13T08:59:27.159271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
1 1
 
2.1%
26 1
 
2.1%
28 1
 
2.1%
29 1
 
2.1%
30 1
 
2.1%
31 1
 
2.1%
32 1
 
2.1%
33 1
 
2.1%
34 1
 
2.1%
35 1
 
2.1%
Other values (38) 38
79.2%
ValueCountFrequency (%)
1 1
2.1%
2 1
2.1%
3 1
2.1%
4 1
2.1%
5 1
2.1%
6 1
2.1%
7 1
2.1%
8 1
2.1%
9 1
2.1%
10 1
2.1%
ValueCountFrequency (%)
48 1
2.1%
47 1
2.1%
46 1
2.1%
45 1
2.1%
44 1
2.1%
43 1
2.1%
42 1
2.1%
41 1
2.1%
40 1
2.1%
39 1
2.1%

상호명
Text

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-13T08:59:27.381362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.625
Min length3

Characters and Unicode

Total characters414
Distinct characters106
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

Unique46 ?
Unique (%)95.8%

Sample

1st row행정사사무소파트너
2nd row행정사무소 해올
3rd row송재우행정사
4th row이음행정사사무소
5th row대길행정사사무소
ValueCountFrequency (%)
행정사 7
 
10.8%
행정사무소 3
 
4.6%
사무소 3
 
4.6%
아리랑 2
 
3.1%
행정사사무소 2
 
3.1%
대성국제행정사무소 1
 
1.5%
행정사정계영사무소 1
 
1.5%
행정사국민사무소 1
 
1.5%
미래행정사사무소 1
 
1.5%
장수익사무소 1
 
1.5%
Other values (43) 43
66.2%
2023-12-13T08:59:27.686671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 76
18.4%
정 47
 
11.4%
행 44
 
10.6%
무 42
 
10.1%
소 41
 
9.9%
17
 
4.1%
대 7
 
1.7%
이 5
 
1.2%
아 4
 
1.0%
김 3
 
0.7%
Other values (96) 128
30.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 388
93.7%
Space Separator 17
 
4.1%
Lowercase Letter 5
 
1.2%
Uppercase Letter 4
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 76
19.6%
정 47
12.1%
행 44
 
11.3%
무 42
 
10.8%
소 41
 
10.6%
대 7
 
1.8%
이 5
 
1.3%
아 4
 
1.0%
김 3
 
0.8%
원 3
 
0.8%
Other values (87) 116
29.9%
Lowercase Letter
ValueCountFrequency (%)
t 1
20.0%
i 1
20.0%
o 1
20.0%
n 1
20.0%
c 1
20.0%
Uppercase Letter
ValueCountFrequency (%)
A 2
50.0%
E 1
25.0%
C 1
25.0%
Space Separator
ValueCountFrequency (%)
17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 388
93.7%
Common 17
 
4.1%
Latin 9
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 76
19.6%
정 47
12.1%
행 44
 
11.3%
무 42
 
10.8%
소 41
 
10.6%
대 7
 
1.8%
이 5
 
1.3%
아 4
 
1.0%
김 3
 
0.8%
원 3
 
0.8%
Other values (87) 116
29.9%
Latin
ValueCountFrequency (%)
A 2
22.2%
t 1
11.1%
i 1
11.1%
o 1
11.1%
n 1
11.1%
c 1
11.1%
E 1
11.1%
C 1
11.1%
Common
ValueCountFrequency (%)
17
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 388
93.7%
ASCII 26
 
6.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 76
19.6%
정 47
12.1%
행 44
 
11.3%
무 42
 
10.8%
소 41
 
10.6%
대 7
 
1.8%
이 5
 
1.3%
아 4
 
1.0%
김 3
 
0.8%
원 3
 
0.8%
Other values (87) 116
29.9%
ASCII
ValueCountFrequency (%)
17
65.4%
A 2
 
7.7%
t 1
 
3.8%
i 1
 
3.8%
o 1
 
3.8%
n 1
 
3.8%
c 1
 
3.8%
E 1
 
3.8%
C 1
 
3.8%

소재지
Text

Distinct43
Distinct (%)89.6%
Missing0
Missing (%)0.0%
Memory size516.0 B
2023-12-13T08:59:28.166361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length59
Median length45.5
Mean length36.4375
Min length28

Characters and Unicode

Total characters1749
Distinct characters92
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)79.2%

Sample

1st row[34909]대전광역시 중구 계백로 1719, 920호 (오류동)
2nd row[34964]대전광역시 중구 계룡로 922, 201동 2305호 (문화동, 하우스토리2차)
3rd row[34960]대전광역시 중구 문화로163번길 26, 402호(문화동, 평화아파트)
4th row[34836]대전광역시 중구 보문로 310, 208호(선화동)
5th row[34909]대전광역시 중구 계백로 1719, 센트리아 오피스텔 13층 1316호(오류동)
ValueCountFrequency (%)
중구 48
 
17.3%
부사동 8
 
2.9%
35027]대전광역시 8
 
2.9%
보문로 8
 
2.9%
대종로 8
 
2.9%
선화동 7
 
2.5%
34814]대전광역시 5
 
1.8%
계백로 4
 
1.4%
계룡로 4
 
1.4%
34909]대전광역시 4
 
1.4%
Other values (139) 173
62.5%
2023-12-13T08:59:28.521435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
229
 
13.1%
3 93
 
5.3%
1 73
 
4.2%
대 65
 
3.7%
중 63
 
3.6%
4 60
 
3.4%
동 57
 
3.3%
2 55
 
3.1%
0 54
 
3.1%
광 48
 
2.7%
Other values (82) 952
54.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 782
44.7%
Decimal Number 501
28.6%
Space Separator 229
 
13.1%
Close Punctuation 95
 
5.4%
Open Punctuation 95
 
5.4%
Other Punctuation 40
 
2.3%
Dash Punctuation 7
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 65
 
8.3%
중 63
 
8.1%
동 57
 
7.3%
광 48
 
6.1%
역 48
 
6.1%
시 48
 
6.1%
전 48
 
6.1%
구 48
 
6.1%
로 47
 
6.0%
화 22
 
2.8%
Other values (65) 288
36.8%
Decimal Number
ValueCountFrequency (%)
3 93
18.6%
1 73
14.6%
4 60
12.0%
2 55
11.0%
0 54
10.8%
8 46
9.2%
5 41
8.2%
9 27
 
5.4%
6 27
 
5.4%
7 25
 
5.0%
Close Punctuation
ValueCountFrequency (%)
] 48
50.5%
) 47
49.5%
Open Punctuation
ValueCountFrequency (%)
[ 48
50.5%
( 47
49.5%
Space Separator
ValueCountFrequency (%)
229
100.0%
Other Punctuation
ValueCountFrequency (%)
, 40
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 967
55.3%
Hangul 782
44.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 65
 
8.3%
중 63
 
8.1%
동 57
 
7.3%
광 48
 
6.1%
역 48
 
6.1%
시 48
 
6.1%
전 48
 
6.1%
구 48
 
6.1%
로 47
 
6.0%
화 22
 
2.8%
Other values (65) 288
36.8%
Common
ValueCountFrequency (%)
229
23.7%
3 93
9.6%
1 73
 
7.5%
4 60
 
6.2%
2 55
 
5.7%
0 54
 
5.6%
] 48
 
5.0%
[ 48
 
5.0%
( 47
 
4.9%
) 47
 
4.9%
Other values (7) 213
22.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 967
55.3%
Hangul 782
44.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
229
23.7%
3 93
9.6%
1 73
 
7.5%
4 60
 
6.2%
2 55
 
5.7%
0 54
 
5.6%
] 48
 
5.0%
[ 48
 
5.0%
( 47
 
4.9%
) 47
 
4.9%
Other values (7) 213
22.0%
Hangul
ValueCountFrequency (%)
대 65
 
8.3%
중 63
 
8.1%
동 57
 
7.3%
광 48
 
6.1%
역 48
 
6.1%
시 48
 
6.1%
전 48
 
6.1%
구 48
 
6.1%
로 47
 
6.0%
화 22
 
2.8%
Other values (65) 288
36.8%

전화번호
Text

MISSING 

Distinct28
Distinct (%)93.3%
Missing18
Missing (%)37.5%
Memory size516.0 B
2023-12-13T08:59:28.723010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique26 ?
Unique (%)86.7%

Sample

1st row042-524-7600
2nd row042-535-5207
3rd row042-223-8506
4th row042-226-2525
5th row042-226-3780
ValueCountFrequency (%)
042-252-5555 2
 
6.7%
042-226-3780 2
 
6.7%
042-254-8986 1
 
3.3%
042-252-8828 1
 
3.3%
042-626-1566 1
 
3.3%
042-242-8080 1
 
3.3%
042-471-5590 1
 
3.3%
042-252-8818 1
 
3.3%
042-257-0248 1
 
3.3%
042-223-7900 1
 
3.3%
Other values (18) 18
60.0%
2023-12-13T08:59:29.008878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 78
21.7%
- 60
16.7%
0 51
14.2%
4 41
11.4%
5 37
10.3%
8 28
 
7.8%
6 14
 
3.9%
9 14
 
3.9%
1 13
 
3.6%
3 12
 
3.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 300
83.3%
Dash Punctuation 60
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 78
26.0%
0 51
17.0%
4 41
13.7%
5 37
12.3%
8 28
 
9.3%
6 14
 
4.7%
9 14
 
4.7%
1 13
 
4.3%
3 12
 
4.0%
7 12
 
4.0%
Dash Punctuation
ValueCountFrequency (%)
- 60
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 360
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 78
21.7%
- 60
16.7%
0 51
14.2%
4 41
11.4%
5 37
10.3%
8 28
 
7.8%
6 14
 
3.9%
9 14
 
3.9%
1 13
 
3.6%
3 12
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 360
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 78
21.7%
- 60
16.7%
0 51
14.2%
4 41
11.4%
5 37
10.3%
8 28
 
7.8%
6 14
 
3.9%
9 14
 
3.9%
1 13
 
3.6%
3 12
 
3.3%

Interactions

2023-12-13T08:59:26.778009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T08:59:29.090654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명소재지전화번호
연번1.0001.0000.8340.976
상호명1.0001.0001.0001.000
소재지0.8341.0001.0000.983
전화번호0.9761.0000.9831.000

Missing values

2023-12-13T08:59:26.862796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T08:59:26.933408image/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행정사사무소파트너[34909]대전광역시 중구 계백로 1719, 920호 (오류동)<NA>
12행정사무소 해올[34964]대전광역시 중구 계룡로 922, 201동 2305호 (문화동, 하우스토리2차)<NA>
23송재우행정사[34960]대전광역시 중구 문화로163번길 26, 402호(문화동, 평화아파트)<NA>
34이음행정사사무소[34836]대전광역시 중구 보문로 310, 208호(선화동)<NA>
45대길행정사사무소[34909]대전광역시 중구 계백로 1719, 센트리아 오피스텔 13층 1316호(오류동)042-524-7600
56바로탐정행정사[34909]대전광역시 중구 계백로 1719, 1723호, 센트리아오피스텔(오류동)042-535-5207
67행정사사무소Action[34907]대전광역시 중구 계룡로 852, 3동 1403호(오류동, 삼성아파트)<NA>
78대전글로벌행정사사무소[34803]대전광역시 중구 대종로704번길 8(중촌동)<NA>
89행정사김현주사무소[34844]대전광역시 중구 보문로 337, 현대빌딩, 402-2호(선화동)<NA>
910대지행정사무소[34814]대전광역시 중구 목중로26번길 10, 2층(중촌동)042-223-8506
연번상호명소재지전화번호
3839행정사하태업사무소[34852]대전광역시 중구 보문로 317 (선화동)042-471-5590
3940베델행정사사무소[34806]대전광역시 중구 대종로 713, 5동 10층 1004호 (중촌동, 금호아파트)042-252-5555
4041강제원행정사무소[34893]대전광역시 중구 동서대로1250번길 30, 2층 (태평동)042-242-8080
4142이앤아이[34846]대전광역시 중구 보문로337번길 21, 2층 203호 (선화동, 영우빌딩)<NA>
4243대전행정사무소[34911]대전광역시 중구 보문로 266, 1층 (대흥동)042-626-1566
4344경산 박은홍행정사사무소[34833]대전광역시 중구 보문로346번길 36, 4층 (선화동)<NA>
4445행정사 양진기사무소[35027]대전광역시 중구 대종로 362-1 (부사동)<NA>
4546행정사 이종헌사무소[35027]대전광역시 중구 대종로 350 (부사동)042-252-8828
4647오복사[35027]대전광역시 중구 대종로 356 (부사동)<NA>
4748금솔행정사사무소[34852]대전광역시 중구 보문로 317 (선화동)042-222-7978