Overview

Dataset statistics

Number of variables4
Number of observations45
Missing cells11
Missing cells (%)6.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory35.9 B

Variable types

Numeric1
Text3

Dataset

Description대전광역시 중구 행정사 사무소 현황 정보 (연번, 업체명, 소재지 주소, 전화번호 항목 등) 데이터 항목을 제공합니다.
Author대전광역시 중구
URLhttps://www.data.go.kr/data/15028747/fileData.do

Alerts

전화번호 has 11 (24.4%) missing valuesMissing
연번 has unique valuesUnique
업체명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:10:26.482048
Analysis finished2023-12-12 14:10:27.022114
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2023-12-12T23:10:27.120909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2023-12-12T23:10:27.295650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

업체명
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-12T23:10:27.603792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.6666667
Min length3

Characters and Unicode

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

Unique

Unique45 ?
Unique (%)100.0%

Sample

1st row행정사하태업사무소
2nd row제해권 행정사무소
3rd row대지행정사 합동사무소
4th row행정사 양진기사무소
5th row행정사 이종헌사무소
ValueCountFrequency (%)
행정사 7
 
11.5%
사무소 3
 
4.9%
행정사무소 2
 
3.3%
김진동행정사무소 1
 
1.6%
강제원행정사무소 1
 
1.6%
경산 1
 
1.6%
박은홍행정사사무소 1
 
1.6%
청목행정사무소 1
 
1.6%
행복행정사 1
 
1.6%
승합동사무소 1
 
1.6%
Other values (42) 42
68.9%
2023-12-12T23:10:28.043407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 70
17.9%
무 42
 
10.8%
정 42
 
10.8%
소 41
 
10.5%
행 40
 
10.3%
16
 
4.1%
대 7
 
1.8%
이 5
 
1.3%
영 5
 
1.3%
전 3
 
0.8%
Other values (87) 119
30.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 371
95.1%
Space Separator 16
 
4.1%
Uppercase Letter 3
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 70
18.9%
무 42
 
11.3%
정 42
 
11.3%
소 41
 
11.1%
행 40
 
10.8%
대 7
 
1.9%
이 5
 
1.3%
영 5
 
1.3%
전 3
 
0.8%
한 3
 
0.8%
Other values (83) 113
30.5%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
C 1
33.3%
E 1
33.3%
Space Separator
ValueCountFrequency (%)
16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 371
95.1%
Common 16
 
4.1%
Latin 3
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 70
18.9%
무 42
 
11.3%
정 42
 
11.3%
소 41
 
11.1%
행 40
 
10.8%
대 7
 
1.9%
이 5
 
1.3%
영 5
 
1.3%
전 3
 
0.8%
한 3
 
0.8%
Other values (83) 113
30.5%
Latin
ValueCountFrequency (%)
A 1
33.3%
C 1
33.3%
E 1
33.3%
Common
ValueCountFrequency (%)
16
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 371
95.1%
ASCII 19
 
4.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 70
18.9%
무 42
 
11.3%
정 42
 
11.3%
소 41
 
11.1%
행 40
 
10.8%
대 7
 
1.9%
이 5
 
1.3%
영 5
 
1.3%
전 3
 
0.8%
한 3
 
0.8%
Other values (83) 113
30.5%
ASCII
ValueCountFrequency (%)
16
84.2%
A 1
 
5.3%
C 1
 
5.3%
E 1
 
5.3%

소재지
Text

Distinct43
Distinct (%)95.6%
Missing0
Missing (%)0.0%
Memory size492.0 B
2023-12-12T23:10:28.436745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length41
Mean length29.688889
Min length21

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)91.1%

Sample

1st row대전광역시 중구 보문로 312, 101호 (선화동)
2nd row대전광역시 중구 보문로 318, 인산빌딩 401호 (선화동)
3rd row대전광역시 중구 목중로26번길 10, 2층 (중촌동)
4th row대전광역시 중구 대종로 362-1 (부사동)
5th row대전광역시 중구 대종로 350 (부사동)
ValueCountFrequency (%)
대전광역시 45
 
16.7%
중구 45
 
16.7%
선화동 10
 
3.7%
대종로 9
 
3.3%
2층 8
 
3.0%
부사동 8
 
3.0%
보문로 8
 
3.0%
목중로 3
 
1.1%
대흥동 3
 
1.1%
202호 3
 
1.1%
Other values (110) 127
47.2%
2023-12-12T23:10:28.961807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
224
 
16.8%
대 64
 
4.8%
1 57
 
4.3%
중 56
 
4.2%
동 55
 
4.1%
역 45
 
3.4%
광 45
 
3.4%
구 45
 
3.4%
전 45
 
3.4%
시 45
 
3.4%
Other values (87) 655
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 737
55.2%
Decimal Number 243
 
18.2%
Space Separator 224
 
16.8%
Close Punctuation 44
 
3.3%
Open Punctuation 44
 
3.3%
Other Punctuation 37
 
2.8%
Dash Punctuation 7
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 64
 
8.7%
중 56
 
7.6%
동 55
 
7.5%
역 45
 
6.1%
광 45
 
6.1%
구 45
 
6.1%
전 45
 
6.1%
시 45
 
6.1%
로 44
 
6.0%
화 20
 
2.7%
Other values (71) 273
37.0%
Decimal Number
ValueCountFrequency (%)
1 57
23.5%
2 40
16.5%
0 33
13.6%
3 28
11.5%
5 24
9.9%
6 18
 
7.4%
8 13
 
5.3%
4 13
 
5.3%
7 10
 
4.1%
9 7
 
2.9%
Other Punctuation
ValueCountFrequency (%)
, 26
70.3%
， 11
29.7%
Space Separator
ValueCountFrequency (%)
224
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 44
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 737
55.2%
Common 599
44.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 64
 
8.7%
중 56
 
7.6%
동 55
 
7.5%
역 45
 
6.1%
광 45
 
6.1%
구 45
 
6.1%
전 45
 
6.1%
시 45
 
6.1%
로 44
 
6.0%
화 20
 
2.7%
Other values (71) 273
37.0%
Common
ValueCountFrequency (%)
224
37.4%
1 57
 
9.5%
) 44
 
7.3%
( 44
 
7.3%
2 40
 
6.7%
0 33
 
5.5%
3 28
 
4.7%
, 26
 
4.3%
5 24
 
4.0%
6 18
 
3.0%
Other values (6) 61
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 737
55.2%
ASCII 588
44.0%
None 11
 
0.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
224
38.1%
1 57
 
9.7%
) 44
 
7.5%
( 44
 
7.5%
2 40
 
6.8%
0 33
 
5.6%
3 28
 
4.8%
, 26
 
4.4%
5 24
 
4.1%
6 18
 
3.1%
Other values (5) 50
 
8.5%
Hangul
ValueCountFrequency (%)
대 64
 
8.7%
중 56
 
7.6%
동 55
 
7.5%
역 45
 
6.1%
광 45
 
6.1%
구 45
 
6.1%
전 45
 
6.1%
시 45
 
6.1%
로 44
 
6.0%
화 20
 
2.7%
Other values (71) 273
37.0%
None
ValueCountFrequency (%)
， 11
100.0%

전화번호
Text

MISSING 

Distinct33
Distinct (%)97.1%
Missing11
Missing (%)24.4%
Memory size492.0 B
2023-12-12T23:10:29.218107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.911765
Min length9

Characters and Unicode

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

Unique32 ?
Unique (%)94.1%

Sample

1st row042-471-5590
2nd row042-224-3588
3rd row042-223-8506
4th row042-252-8828
5th row042-257-0248
ValueCountFrequency (%)
042-252-5555 2
 
5.9%
042-528-9734 1
 
2.9%
042-471-5590 1
 
2.9%
042-252-8818 1
 
2.9%
042-223-9682 1
 
2.9%
042-257-9416 1
 
2.9%
042-523-8001 1
 
2.9%
042-545-8847 1
 
2.9%
042-254-8986 1
 
2.9%
042-535-1311 1
 
2.9%
Other values (23) 23
67.6%
2023-12-12T23:10:29.669338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 88
21.7%
- 67
16.5%
4 50
12.3%
0 49
12.1%
5 40
9.9%
8 32
 
7.9%
1 20
 
4.9%
9 16
 
4.0%
6 15
 
3.7%
7 14
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 338
83.5%
Dash Punctuation 67
 
16.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 88
26.0%
4 50
14.8%
0 49
14.5%
5 40
11.8%
8 32
 
9.5%
1 20
 
5.9%
9 16
 
4.7%
6 15
 
4.4%
7 14
 
4.1%
3 14
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 67
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 405
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 88
21.7%
- 67
16.5%
4 50
12.3%
0 49
12.1%
5 40
9.9%
8 32
 
7.9%
1 20
 
4.9%
9 16
 
4.0%
6 15
 
3.7%
7 14
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 405
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 88
21.7%
- 67
16.5%
4 50
12.3%
0 49
12.1%
5 40
9.9%
8 32
 
7.9%
1 20
 
4.9%
9 16
 
4.0%
6 15
 
3.7%
7 14
 
3.5%

Interactions

2023-12-12T23:10:26.753735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:10:29.801847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업체명소재지전화번호
연번1.0001.0000.8950.904
업체명1.0001.0001.0001.000
소재지0.8951.0001.0000.992
전화번호0.9041.0000.9921.000

Missing values

2023-12-12T23:10:26.867723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:10:26.984230image/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행정사하태업사무소대전광역시 중구 보문로 312, 101호 (선화동)042-471-5590
12제해권 행정사무소대전광역시 중구 보문로 318, 인산빌딩 401호 (선화동)042-224-3588
23대지행정사 합동사무소대전광역시 중구 목중로26번길 10, 2층 (중촌동)042-223-8506
34행정사 양진기사무소대전광역시 중구 대종로 362-1 (부사동)<NA>
45행정사 이종헌사무소대전광역시 중구 대종로 350 (부사동)042-252-8828
56행정사 박연하사무소대전광역시 중구 보문로 311 (선화동)042-257-0248
67아리랑 행정사사무소대전광역시 중구 목중로 21-1, 2층 (목동)042-226-3780
78대전행정사무소대전광역시 중구 보문로 266, 1층 (대흥동)042-626-1566
89행정사 최경록 사무소대전광역시 중구 대종로550번길 5， 유원오피스텔 1005호 (선화동)042-522-3001
910오복사대전광역시 중구 대종로 356 (부사동)<NA>
연번업체명소재지전화번호
3536행정사 배정록사무소대전광역시 중구 대종로 350 (부사동)042-252-8818
3637리더스행정사사무소대전광역시 중구 계백로 1719, 센트리아오피스텔 1811호(오류동)042-535-1311
3738가교행정사김영희사무소대전광역시 중구 중앙로129번길 11， 2층(선화동)042-221-9931
3839대전문화행정사사무소대전광역시 중구 천근로 50-5, (문화동)042-585-4955
3940행정사 사무소 효원대전광역시 중구 목중로26번길 29， 상가동 2층 202호 (중촌동， 현대아파트)1661-7642
4041대흥스마트행정사무소대전광역시 중구 보문로260번길 48(대흥동)042-221-1252
4142진영철행정사사무소대전광역시 중구 보문로260번길 15， 2층(대흥동)042-222-1809
4243국가보훈행정사무소대전광역시 중구 계백로1716번길 40， 106동 1401호(문화동， 문화마을금호어울림아파트)<NA>
4344이규섭행정사사무소대전광역시 중구 평촌로 111， 107동 1406호(태평동， 태평아파트)042-528-9734
4445세종한밭행정사사무소대전광역시 중구 선화로 119， 웰빙오피스텔 607호(선화동)042-822-8545