Overview

Dataset statistics

Number of variables6
Number of observations61
Missing cells78
Missing cells (%)21.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory51.2 B

Variable types

Text3
Unsupported1
DateTime2

Dataset

Description광주광역시 서구에 위치한 행정사무소의 주소 및 연락처 등에 대한 정보입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15028853/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 17 (27.9%) missing valuesMissing
팩스번호 has 61 (100.0%) missing valuesMissing
업체명 has unique valuesUnique
주소 has unique valuesUnique
팩스번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 14:31:22.241181
Analysis finished2023-12-12 14:31:23.121939
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업체명
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-12T23:31:23.327364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length15
Mean length9.7213115
Min length5

Characters and Unicode

Total characters593
Distinct characters123
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st row탑+행정사 사무소
2nd row치평 행정사 합동 사무소
3rd row올포유행정사합동사무소
4th rowJN 행정사 사무소
5th row이영현 행정사무소
ValueCountFrequency (%)
사무소 24
 
20.2%
행정사 24
 
20.2%
문희주 1
 
0.8%
김대후 1
 
0.8%
드림 1
 
0.8%
외국어 1
 
0.8%
굿모닝 1
 
0.8%
행정사이선동사무소 1
 
0.8%
최성철행정사사무소 1
 
0.8%
행운 1
 
0.8%
Other values (63) 63
52.9%
2023-12-12T23:31:23.763842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 108
18.2%
행 63
 
10.6%
정 63
 
10.6%
58
 
9.8%
무 55
 
9.3%
소 52
 
8.8%
동 7
 
1.2%
이 7
 
1.2%
일 6
 
1.0%
경 5
 
0.8%
Other values (113) 169
28.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 520
87.7%
Space Separator 58
 
9.8%
Uppercase Letter 6
 
1.0%
Other Punctuation 3
 
0.5%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%
Decimal Number 1
 
0.2%
Math Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 108
20.8%
행 63
12.1%
정 63
12.1%
무 55
 
10.6%
소 52
 
10.0%
동 7
 
1.3%
이 7
 
1.3%
일 6
 
1.2%
경 5
 
1.0%
주 4
 
0.8%
Other values (101) 150
28.8%
Uppercase Letter
ValueCountFrequency (%)
S 2
33.3%
G 1
16.7%
N 1
16.7%
J 1
16.7%
C 1
16.7%
Other Punctuation
ValueCountFrequency (%)
' 2
66.7%
/ 1
33.3%
Space Separator
ValueCountFrequency (%)
58
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 519
87.5%
Common 67
 
11.3%
Latin 6
 
1.0%
Han 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 108
20.8%
행 63
12.1%
정 63
12.1%
무 55
 
10.6%
소 52
 
10.0%
동 7
 
1.3%
이 7
 
1.3%
일 6
 
1.2%
경 5
 
1.0%
주 4
 
0.8%
Other values (100) 149
28.7%
Common
ValueCountFrequency (%)
58
86.6%
' 2
 
3.0%
) 2
 
3.0%
( 2
 
3.0%
/ 1
 
1.5%
1 1
 
1.5%
+ 1
 
1.5%
Latin
ValueCountFrequency (%)
S 2
33.3%
G 1
16.7%
N 1
16.7%
J 1
16.7%
C 1
16.7%
Han
ValueCountFrequency (%)
元 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 519
87.5%
ASCII 73
 
12.3%
CJK 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 108
20.8%
행 63
12.1%
정 63
12.1%
무 55
 
10.6%
소 52
 
10.0%
동 7
 
1.3%
이 7
 
1.3%
일 6
 
1.2%
경 5
 
1.0%
주 4
 
0.8%
Other values (100) 149
28.7%
ASCII
ValueCountFrequency (%)
58
79.5%
S 2
 
2.7%
' 2
 
2.7%
) 2
 
2.7%
( 2
 
2.7%
G 1
 
1.4%
/ 1
 
1.4%
N 1
 
1.4%
J 1
 
1.4%
1 1
 
1.4%
Other values (2) 2
 
2.7%
CJK
ValueCountFrequency (%)
元 1
100.0%

주소
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-12T23:31:24.149681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length37
Mean length32.065574
Min length21

Characters and Unicode

Total characters1956
Distinct characters128
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

Unique61 ?
Unique (%)100.0%

Sample

1st row광주광역시 서구 화운로304번길 7 (광천동)
2nd row광주광역시 서구 화정로 313, 의당빌딩 2층 (농성동)
3rd row광주광역시 서구 월드컵4강로 32 (화정동)
4th row광주광역시 서구 동천로10번길 24, 2층 1호 (동천동)
5th row광주광역시 서구 시청로60번길 22, 송호빌딩 6층 (치평동)
ValueCountFrequency (%)
광주광역시 61
 
15.4%
서구 61
 
15.4%
쌍촌동 16
 
4.0%
치평동 14
 
3.5%
2층 10
 
2.5%
상무대로911번길 7
 
1.8%
상무중앙로 7
 
1.8%
화정동 7
 
1.8%
3층 5
 
1.3%
농성동 5
 
1.3%
Other values (146) 204
51.4%
2023-12-12T23:31:24.601908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
336
 
17.2%
광 126
 
6.4%
1 91
 
4.7%
동 75
 
3.8%
시 65
 
3.3%
( 62
 
3.2%
) 62
 
3.2%
주 62
 
3.2%
구 62
 
3.2%
서 62
 
3.2%
Other values (118) 953
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1107
56.6%
Space Separator 336
 
17.2%
Decimal Number 325
 
16.6%
Open Punctuation 62
 
3.2%
Close Punctuation 62
 
3.2%
Other Punctuation 50
 
2.6%
Dash Punctuation 7
 
0.4%
Uppercase Letter 7
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 126
 
11.4%
동 75
 
6.8%
시 65
 
5.9%
주 62
 
5.6%
구 62
 
5.6%
서 62
 
5.6%
역 61
 
5.5%
로 61
 
5.5%
상 34
 
3.1%
층 32
 
2.9%
Other values (99) 467
42.2%
Decimal Number
ValueCountFrequency (%)
1 91
28.0%
2 52
16.0%
3 34
 
10.5%
4 31
 
9.5%
0 28
 
8.6%
6 23
 
7.1%
5 19
 
5.8%
9 18
 
5.5%
7 16
 
4.9%
8 13
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
C 2
28.6%
Y 2
28.6%
B 2
28.6%
A 1
14.3%
Space Separator
ValueCountFrequency (%)
336
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%
Other Punctuation
ValueCountFrequency (%)
, 50
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1107
56.6%
Common 842
43.0%
Latin 7
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 126
 
11.4%
동 75
 
6.8%
시 65
 
5.9%
주 62
 
5.6%
구 62
 
5.6%
서 62
 
5.6%
역 61
 
5.5%
로 61
 
5.5%
상 34
 
3.1%
층 32
 
2.9%
Other values (99) 467
42.2%
Common
ValueCountFrequency (%)
336
39.9%
1 91
 
10.8%
( 62
 
7.4%
) 62
 
7.4%
2 52
 
6.2%
, 50
 
5.9%
3 34
 
4.0%
4 31
 
3.7%
0 28
 
3.3%
6 23
 
2.7%
Other values (5) 73
 
8.7%
Latin
ValueCountFrequency (%)
C 2
28.6%
Y 2
28.6%
B 2
28.6%
A 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1107
56.6%
ASCII 849
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
336
39.6%
1 91
 
10.7%
( 62
 
7.3%
) 62
 
7.3%
2 52
 
6.1%
, 50
 
5.9%
3 34
 
4.0%
4 31
 
3.7%
0 28
 
3.3%
6 23
 
2.7%
Other values (9) 80
 
9.4%
Hangul
ValueCountFrequency (%)
광 126
 
11.4%
동 75
 
6.8%
시 65
 
5.9%
주 62
 
5.6%
구 62
 
5.6%
서 62
 
5.6%
역 61
 
5.5%
로 61
 
5.5%
상 34
 
3.1%
층 32
 
2.9%
Other values (99) 467
42.2%

전화번호
Text

MISSING 

Distinct44
Distinct (%)100.0%
Missing17
Missing (%)27.9%
Memory size620.0 B
2023-12-12T23:31:24.851424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.068182
Min length12

Characters and Unicode

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

Unique44 ?
Unique (%)100.0%

Sample

1st row062-524-3300
2nd row062-374-4000
3rd row062-971-0550
4th row062-514-5254
5th row062-714-1456
ValueCountFrequency (%)
062-524-3300 1
 
2.3%
062-374-4000 1
 
2.3%
062-945-2310 1
 
2.3%
062-365-0088 1
 
2.3%
062-374-1345 1
 
2.3%
062-226-0071 1
 
2.3%
062-368-0789 1
 
2.3%
062-371-9350 1
 
2.3%
062-236-3310 1
 
2.3%
062-961-4945 1
 
2.3%
Other values (34) 34
77.3%
2023-12-12T23:31:25.290474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 95
17.9%
- 88
16.6%
6 64
12.1%
2 63
11.9%
3 52
9.8%
5 36
 
6.8%
7 32
 
6.0%
4 30
 
5.6%
8 28
 
5.3%
1 25
 
4.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 443
83.4%
Dash Punctuation 88
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 95
21.4%
6 64
14.4%
2 63
14.2%
3 52
11.7%
5 36
 
8.1%
7 32
 
7.2%
4 30
 
6.8%
8 28
 
6.3%
1 25
 
5.6%
9 18
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 88
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 531
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 95
17.9%
- 88
16.6%
6 64
12.1%
2 63
11.9%
3 52
9.8%
5 36
 
6.8%
7 32
 
6.0%
4 30
 
5.6%
8 28
 
5.3%
1 25
 
4.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 531
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 95
17.9%
- 88
16.6%
6 64
12.1%
2 63
11.9%
3 52
9.8%
5 36
 
6.8%
7 32
 
6.0%
4 30
 
5.6%
8 28
 
5.3%
1 25
 
4.7%

팩스번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing61
Missing (%)100.0%
Memory size681.0 B

개업신고일
Date

Distinct57
Distinct (%)93.4%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum2000-04-11 00:00:00
Maximum2021-02-02 00:00:00
2023-12-12T23:31:25.453502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:31:25.595692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
Minimum2021-09-24 00:00:00
Maximum2021-09-24 00:00:00
2023-12-12T23:31:25.730348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:31:25.843476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T23:31:25.929403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업체명주소전화번호개업신고일
업체명1.0001.0001.0001.000
주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
개업신고일1.0001.0001.0001.000

Missing values

2023-12-12T23:31:22.576602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:31:23.063563image/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

업체명주소전화번호팩스번호개업신고일데이터기준일자
0탑+행정사 사무소광주광역시 서구 화운로304번길 7 (광천동)<NA><NA>2021-02-022021-09-24
1치평 행정사 합동 사무소광주광역시 서구 화정로 313, 의당빌딩 2층 (농성동)062-524-3300<NA>2019-01-152021-09-24
2올포유행정사합동사무소광주광역시 서구 월드컵4강로 32 (화정동)062-374-4000<NA>2019-04-192021-09-24
3JN 행정사 사무소광주광역시 서구 동천로10번길 24, 2층 1호 (동천동)062-971-0550<NA>2015-11-242021-09-24
4이영현 행정사무소광주광역시 서구 시청로60번길 22, 송호빌딩 6층 (치평동)062-514-5254<NA>2003-05-152021-09-24
5훼미리행정사사무소광주광역시 서구 천변좌하로626번길 21 (광천동)062-714-1456<NA>2020-10-122021-09-24
6화운로행정사사무소광주광역시 서구 화운로175번길 3-2 (화정동)<NA><NA>2020-10-122021-09-24
7일공 번역/일반 행정사 사무소광주광역시 서구 상무대로 773, 세정아울렛 3층 (치평동)<NA><NA>2020-09-282021-09-24
8(元)탐정행정사무소광주광역시 서구 상무평화로 89, 상무구영드림빌 7층 713호 (치평동)062-384-4500<NA>2020-09-142021-09-24
9해결행정사합동사무소광주광역시 서구 하남대로680번길 1, 3층 (동천동)062-521-5900<NA>2020-09-112021-09-24
업체명주소전화번호팩스번호개업신고일데이터기준일자
51행정사장필준사무소광주광역시 서구 상무중앙로 114 (치평동)<NA><NA>2005-10-142021-09-24
52행정사송현사무소광주광역시 서구 경열로 28 (농성동)<NA><NA>2003-04-092021-09-24
53행정사강재일사무소광주광역시 서구 매월2로 53 (매월동)070-7552-8595<NA>2003-04-022021-09-24
54행정사이선규사무소광주광역시 서구 운천로 168-1 (쌍촌동)062-371-0009<NA>2000-04-112021-09-24
55행정사김근표사무소광주광역시 서구 상무중앙로 103, 206호 (치평동)062-373-6800<NA>2012-12-102021-09-24
56륜산행정사사무소광주광역시 서구 매월2로15번길 16, 202동 114호 (매월동, 매월종합상가)062-610-5001<NA>2012-11-302021-09-24
57현대행정사광주광역시 서구 풍암1로21번길 3-16 (풍암동)062-673-5200<NA>2012-06-252021-09-24
58온누리행정사광주광역시 서구 독립로 196 (양동)<NA><NA>2012-03-262021-09-24
59애플행정사무소광주광역시 서구 풍금로38번길 33 (풍암동)062-653-4080<NA>2011-09-162021-09-24
60박경철행정사무소광주광역시 서구 월산로 162 (농성동)<NA><NA>2000-08-312021-09-24