Overview

Dataset statistics

Number of variables4
Number of observations48
Missing cells16
Missing cells (%)8.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory34.7 B

Variable types

Text3
DateTime1

Dataset

Description전북특별자치도 군산시 관내 행정사 현황에 대한 데이터로 행정사 사무소명, 사무소 주소, 사무소 전화번호, 사무소 신고일자 등의 항목을 제공합니다.
Author전북특별자치도 군산시
URLhttps://www.data.go.kr/data/15028694/fileData.do

Alerts

사무소 주소 has 1 (2.1%) missing valuesMissing
전화번호 has 15 (31.2%) missing valuesMissing
사무소명칭 has unique valuesUnique

Reproduction

Analysis started2024-03-14 21:16:33.510616
Analysis finished2024-03-14 21:16:34.640296
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사무소명칭
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-15T06:16:35.263607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length9.3333333
Min length5

Characters and Unicode

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

Unique

Unique48 ?
Unique (%)100.0%

Sample

1st row행정사사무소 E-사람
2nd row바다드림행정사사무소
3rd row행정사사무소 다행
4th row수석행정사사무소
5th row중부 행정사사무소
ValueCountFrequency (%)
행정사 25
27.2%
행정사사무소 9
 
9.8%
사무소 7
 
7.6%
채훈석사무소 1
 
1.1%
임명호사무소 1
 
1.1%
신민식사무소 1
 
1.1%
김병규 1
 
1.1%
이일선사무소 1
 
1.1%
심중구사무소 1
 
1.1%
최병배 1
 
1.1%
Other values (44) 44
47.8%
2024-03-15T06:16:36.398192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 88
19.6%
정 52
11.6%
행 50
11.2%
44
 
9.8%
무 42
 
9.4%
소 41
 
9.2%
김 7
 
1.6%
우 4
 
0.9%
이 4
 
0.9%
배 3
 
0.7%
Other values (85) 113
25.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 399
89.1%
Space Separator 44
 
9.8%
Uppercase Letter 3
 
0.7%
Dash Punctuation 1
 
0.2%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 88
22.1%
정 52
13.0%
행 50
12.5%
무 42
 
10.5%
소 41
 
10.3%
김 7
 
1.8%
우 4
 
1.0%
이 4
 
1.0%
배 3
 
0.8%
수 3
 
0.8%
Other values (79) 105
26.3%
Uppercase Letter
ValueCountFrequency (%)
E 1
33.3%
J 1
33.3%
S 1
33.3%
Space Separator
ValueCountFrequency (%)
44
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 399
89.1%
Common 46
 
10.3%
Latin 3
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 88
22.1%
정 52
13.0%
행 50
12.5%
무 42
 
10.5%
소 41
 
10.3%
김 7
 
1.8%
우 4
 
1.0%
이 4
 
1.0%
배 3
 
0.8%
수 3
 
0.8%
Other values (79) 105
26.3%
Common
ValueCountFrequency (%)
44
95.7%
- 1
 
2.2%
& 1
 
2.2%
Latin
ValueCountFrequency (%)
E 1
33.3%
J 1
33.3%
S 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 399
89.1%
ASCII 49
 
10.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 88
22.1%
정 52
13.0%
행 50
12.5%
무 42
 
10.5%
소 41
 
10.3%
김 7
 
1.8%
우 4
 
1.0%
이 4
 
1.0%
배 3
 
0.8%
수 3
 
0.8%
Other values (79) 105
26.3%
ASCII
ValueCountFrequency (%)
44
89.8%
- 1
 
2.0%
E 1
 
2.0%
J 1
 
2.0%
& 1
 
2.0%
S 1
 
2.0%

사무소 주소
Text

MISSING 

Distinct46
Distinct (%)97.9%
Missing1
Missing (%)2.1%
Memory size512.0 B
2024-03-15T06:16:37.576276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length33
Mean length25.12766
Min length18

Characters and Unicode

Total characters1181
Distinct characters117
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

Unique45 ?
Unique (%)95.7%

Sample

1st row전북특별자치도 군산시 조촌로 36， 2층 (조촌동)
2nd row전북특별자치도 군산시 축동안길 37
3rd row전북특별자치도 군산시 대학로 342(나운동)
4th row전북특별자치도 군산시 공항로 383(산북동)
5th row전북특별자치도 군산시 조촌로 112
ValueCountFrequency (%)
전북특별자치도 47
20.2%
군산시 47
20.2%
조촌동 7
 
3.0%
검다메1길 4
 
1.7%
경암동 4
 
1.7%
월명로 3
 
1.3%
경장동 3
 
1.3%
경포1길 3
 
1.3%
조촌로 3
 
1.3%
성산면 2
 
0.9%
Other values (100) 110
47.2%
2024-03-15T06:16:39.032178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
186
 
15.7%
산 54
 
4.6%
북 49
 
4.1%
군 48
 
4.1%
전 47
 
4.0%
특 47
 
4.0%
별 47
 
4.0%
자 47
 
4.0%
치 47
 
4.0%
도 47
 
4.0%
Other values (107) 562
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 779
66.0%
Space Separator 186
 
15.7%
Decimal Number 136
 
11.5%
Close Punctuation 33
 
2.8%
Open Punctuation 33
 
2.8%
Dash Punctuation 9
 
0.8%
Other Punctuation 5
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 54
 
6.9%
북 49
 
6.3%
군 48
 
6.2%
전 47
 
6.0%
특 47
 
6.0%
별 47
 
6.0%
자 47
 
6.0%
치 47
 
6.0%
도 47
 
6.0%
시 47
 
6.0%
Other values (92) 299
38.4%
Decimal Number
ValueCountFrequency (%)
1 34
25.0%
2 27
19.9%
3 20
14.7%
6 13
 
9.6%
4 11
 
8.1%
8 9
 
6.6%
5 7
 
5.1%
9 6
 
4.4%
7 5
 
3.7%
0 4
 
2.9%
Space Separator
ValueCountFrequency (%)
186
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Punctuation
ValueCountFrequency (%)
， 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 779
66.0%
Common 402
34.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 54
 
6.9%
북 49
 
6.3%
군 48
 
6.2%
전 47
 
6.0%
특 47
 
6.0%
별 47
 
6.0%
자 47
 
6.0%
치 47
 
6.0%
도 47
 
6.0%
시 47
 
6.0%
Other values (92) 299
38.4%
Common
ValueCountFrequency (%)
186
46.3%
1 34
 
8.5%
) 33
 
8.2%
( 33
 
8.2%
2 27
 
6.7%
3 20
 
5.0%
6 13
 
3.2%
4 11
 
2.7%
8 9
 
2.2%
- 9
 
2.2%
Other values (5) 27
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 779
66.0%
ASCII 397
33.6%
None 5
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
186
46.9%
1 34
 
8.6%
) 33
 
8.3%
( 33
 
8.3%
2 27
 
6.8%
3 20
 
5.0%
6 13
 
3.3%
4 11
 
2.8%
8 9
 
2.3%
- 9
 
2.3%
Other values (4) 22
 
5.5%
Hangul
ValueCountFrequency (%)
산 54
 
6.9%
북 49
 
6.3%
군 48
 
6.2%
전 47
 
6.0%
특 47
 
6.0%
별 47
 
6.0%
자 47
 
6.0%
치 47
 
6.0%
도 47
 
6.0%
시 47
 
6.0%
Other values (92) 299
38.4%
None
ValueCountFrequency (%)
， 5
100.0%

전화번호
Text

MISSING 

Distinct32
Distinct (%)97.0%
Missing15
Missing (%)31.2%
Memory size512.0 B
2024-03-15T06:16:39.881668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique31 ?
Unique (%)93.9%

Sample

1st row063-732-1122
2nd row063-453-0606
3rd row063-463-4972
4th row063-468-6262
5th row063-453-5840
ValueCountFrequency (%)
063-446-9009 2
 
6.1%
063-453-0606 1
 
3.0%
063-453-0041 1
 
3.0%
063-461-5918 1
 
3.0%
063-471-7768 1
 
3.0%
063-443-6400 1
 
3.0%
063-451-5745 1
 
3.0%
063-453-0051 1
 
3.0%
063-451-2168 1
 
3.0%
063-445-8430 1
 
3.0%
Other values (22) 22
66.7%
2024-03-15T06:16:41.279468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 66
16.7%
0 61
15.4%
6 60
15.2%
4 58
14.6%
3 46
11.6%
5 28
7.1%
2 22
 
5.6%
1 21
 
5.3%
7 12
 
3.0%
9 11
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 330
83.3%
Dash Punctuation 66
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 61
18.5%
6 60
18.2%
4 58
17.6%
3 46
13.9%
5 28
8.5%
2 22
 
6.7%
1 21
 
6.4%
7 12
 
3.6%
9 11
 
3.3%
8 11
 
3.3%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 396
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 66
16.7%
0 61
15.4%
6 60
15.2%
4 58
14.6%
3 46
11.6%
5 28
7.1%
2 22
 
5.6%
1 21
 
5.3%
7 12
 
3.0%
9 11
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 396
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 66
16.7%
0 61
15.4%
6 60
15.2%
4 58
14.6%
3 46
11.6%
5 28
7.1%
2 22
 
5.6%
1 21
 
5.3%
7 12
 
3.0%
9 11
 
2.8%

신고일자
Date

Distinct44
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Memory size512.0 B
Minimum1996-03-16 00:00:00
Maximum2024-01-11 00:00:00
2024-03-15T06:16:41.738091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T06:16:41.980522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)

Correlations

2024-03-15T06:16:42.136988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사무소명칭사무소 주소전화번호신고일자
사무소명칭1.0001.0001.0001.000
사무소 주소1.0001.0001.0000.993
전화번호1.0001.0001.0000.985
신고일자1.0000.9930.9851.000

Missing values

2024-03-15T06:16:33.998297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T06:16:34.283778image/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.
2024-03-15T06:16:34.558097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

사무소명칭사무소 주소전화번호신고일자
0행정사사무소 E-사람전북특별자치도 군산시 조촌로 36， 2층 (조촌동)063-732-11222024-01-11
1바다드림행정사사무소전북특별자치도 군산시 축동안길 37<NA>2023-10-16
2행정사사무소 다행전북특별자치도 군산시 대학로 342(나운동)<NA>2023-09-25
3수석행정사사무소전북특별자치도 군산시 공항로 383(산북동)<NA>2022-04-29
4중부 행정사사무소전북특별자치도 군산시 조촌로 112<NA>2022-04-07
5행정사 박정관사무소전북특별자치도 군산시 미제길 23 (미룡동)<NA>2022-01-12
6우주 행정사 사무소전북특별자치도 군산시 나운우회로 69<NA>2021-11-23
7조은 행정사 사무소전북특별자치도 군산시 내정로 27<NA>2021-07-26
8여여노무행정사무소전북특별자치도 군산시 조촌4길 32(조촌동)063-453-06062021-01-27
9리 행정사사무소전북특별자치도 군산시 경암1길 112-3<NA>2020-01-31
사무소명칭사무소 주소전화번호신고일자
38행정사 하영태사무소전북특별자치도 군산시 나포면 옥곤문화2길 15063-464-11341999-10-08
39오성 행정사사무소전북특별자치도 군산시 성산면 식천2길 3063-453-00511999-10-08
40김종철 행정사사무소전북특별자치도 군산시 대야면 번영로 903063-451-57451999-04-12
41문성곤 행정사사무소<NA><NA>1999-04-12
42행정사 강진우사무소전북특별자치도 군산시 월명로 462 (명산동)063-446-90091999-01-25
43군산 럭키행정사전북특별자치도 군산시 미장길 29 (경장동)063-443-64001998-09-21
44행정사 김송남사무소전북특별자치도 군산시 서흥2길 56 (서흥남동)063-471-77681997-09-08
45열린행정 행정사무소전북특별자치도 군산시 팔마로 212 (경장동)063-461-59181996-12-16
46행정사 채훈석사무소전북특별자치도 군산시 성산면 동군산로 28-1063-453-00411996-06-24
47행정사 전호진 사무소전북특별자치도 군산시 옥구읍 옥구남로 5-1063-464-85251996-03-16