Overview

Dataset statistics

Number of variables4
Number of observations449
Missing cells125
Missing cells (%)7.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.2 KiB
Average record size in memory32.3 B

Variable types

Text4

Dataset

Description전라남도청에 개설신고 신청후 등록된 건축사사무소 개설신고 현황임* 전라남도 건축사사무소명, 건축사명, 건축사사무소 주소 및 전화번호를 기재된 현황
Author전라남도
URLhttps://www.data.go.kr/data/15034740/fileData.do

Alerts

전화번호 has 125 (27.8%) missing valuesMissing

Reproduction

Analysis started2023-12-12 22:15:24.059826
Analysis finished2023-12-12 22:15:24.660430
Duration0.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct439
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-13T07:15:24.989037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length9.701559
Min length7

Characters and Unicode

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

Unique

Unique429 ?
Unique (%)95.5%

Sample

1st row호남 건축사사무소
2nd row진남 건축사사무소
3rd row최상채 건축사사무소
4th row전일건축사사무소
5th row대윤 건축사사무소
ValueCountFrequency (%)
건축사사무소 175
 
26.0%
주식회사 24
 
3.6%
사무소 5
 
0.7%
건축사 4
 
0.6%
종합건축사사무소 3
 
0.4%
가람건축사사무소 2
 
0.3%
가원 2
 
0.3%
2
 
0.3%
2
 
0.3%
2
 
0.3%
Other values (432) 453
67.2%
2023-12-13T07:15:25.580151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
932
21.4%
465
10.7%
458
10.5%
451
 
10.4%
450
 
10.3%
234
 
5.4%
74
 
1.7%
56
 
1.3%
) 53
 
1.2%
( 53
 
1.2%
Other values (241) 1130
25.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3994
91.7%
Space Separator 234
 
5.4%
Close Punctuation 53
 
1.2%
Open Punctuation 53
 
1.2%
Uppercase Letter 19
 
0.4%
Decimal Number 2
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
932
23.3%
465
11.6%
458
11.5%
451
11.3%
450
11.3%
74
 
1.9%
56
 
1.4%
34
 
0.9%
32
 
0.8%
28
 
0.7%
Other values (226) 1014
25.4%
Uppercase Letter
ValueCountFrequency (%)
A 6
31.6%
N 2
 
10.5%
S 2
 
10.5%
M 2
 
10.5%
U 2
 
10.5%
D 2
 
10.5%
O 1
 
5.3%
I 1
 
5.3%
G 1
 
5.3%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
234
100.0%
Close Punctuation
ValueCountFrequency (%)
) 53
100.0%
Open Punctuation
ValueCountFrequency (%)
( 53
100.0%
Other Punctuation
ValueCountFrequency (%)
# 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3994
91.7%
Common 343
 
7.9%
Latin 19
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
932
23.3%
465
11.6%
458
11.5%
451
11.3%
450
11.3%
74
 
1.9%
56
 
1.4%
34
 
0.9%
32
 
0.8%
28
 
0.7%
Other values (226) 1014
25.4%
Latin
ValueCountFrequency (%)
A 6
31.6%
N 2
 
10.5%
S 2
 
10.5%
M 2
 
10.5%
U 2
 
10.5%
D 2
 
10.5%
O 1
 
5.3%
I 1
 
5.3%
G 1
 
5.3%
Common
ValueCountFrequency (%)
234
68.2%
) 53
 
15.5%
( 53
 
15.5%
# 1
 
0.3%
1 1
 
0.3%
2 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3994
91.7%
ASCII 362
 
8.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
932
23.3%
465
11.6%
458
11.5%
451
11.3%
450
11.3%
74
 
1.9%
56
 
1.4%
34
 
0.9%
32
 
0.8%
28
 
0.7%
Other values (226) 1014
25.4%
ASCII
ValueCountFrequency (%)
234
64.6%
) 53
 
14.6%
( 53
 
14.6%
A 6
 
1.7%
N 2
 
0.6%
S 2
 
0.6%
M 2
 
0.6%
U 2
 
0.6%
D 2
 
0.6%
# 1
 
0.3%
Other values (5) 5
 
1.4%
Distinct420
Distinct (%)93.5%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-13T07:15:25.960436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length38
Mean length23.650334
Min length1

Characters and Unicode

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

Unique

Unique395 ?
Unique (%)88.0%

Sample

1st row전라남도 순천시 장명로 27
2nd row전라남도 여수시 문수로 141, 3층
3rd row전라남도 순천시 장천동 대지 49-20
4th row전라남도 목포시 양을로 178
5th row전라남도 여수시 시청서1길 6
ValueCountFrequency (%)
전라남도 447
 
18.0%
2층 108
 
4.4%
순천시 79
 
3.2%
여수시 59
 
2.4%
나주시 46
 
1.9%
1층 44
 
1.8%
목포시 42
 
1.7%
3층 33
 
1.3%
광양시 32
 
1.3%
화순군 26
 
1.0%
Other values (675) 1563
63.0%
2023-12-13T07:15:26.458665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2044
19.2%
524
 
4.9%
502
 
4.7%
458
 
4.3%
453
 
4.3%
1 451
 
4.2%
2 386
 
3.6%
, 295
 
2.8%
293
 
2.8%
260
 
2.4%
Other values (236) 4953
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6251
58.9%
Space Separator 2044
 
19.2%
Decimal Number 1864
 
17.6%
Other Punctuation 295
 
2.8%
Dash Punctuation 144
 
1.4%
Uppercase Letter 12
 
0.1%
Close Punctuation 4
 
< 0.1%
Open Punctuation 4
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
524
 
8.4%
502
 
8.0%
458
 
7.3%
453
 
7.2%
293
 
4.7%
260
 
4.2%
215
 
3.4%
215
 
3.4%
210
 
3.4%
210
 
3.4%
Other values (210) 2911
46.6%
Decimal Number
ValueCountFrequency (%)
1 451
24.2%
2 386
20.7%
3 219
11.7%
0 154
 
8.3%
4 141
 
7.6%
5 132
 
7.1%
6 110
 
5.9%
7 92
 
4.9%
8 90
 
4.8%
9 89
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
B 2
16.7%
A 2
16.7%
U 1
8.3%
F 1
8.3%
K 1
8.3%
T 1
8.3%
D 1
8.3%
S 1
8.3%
H 1
8.3%
E 1
8.3%
Space Separator
ValueCountFrequency (%)
2044
100.0%
Other Punctuation
ValueCountFrequency (%)
, 295
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 144
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Lowercase Letter
ValueCountFrequency (%)
d 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6251
58.9%
Common 4355
41.0%
Latin 13
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
524
 
8.4%
502
 
8.0%
458
 
7.3%
453
 
7.2%
293
 
4.7%
260
 
4.2%
215
 
3.4%
215
 
3.4%
210
 
3.4%
210
 
3.4%
Other values (210) 2911
46.6%
Common
ValueCountFrequency (%)
2044
46.9%
1 451
 
10.4%
2 386
 
8.9%
, 295
 
6.8%
3 219
 
5.0%
0 154
 
3.5%
- 144
 
3.3%
4 141
 
3.2%
5 132
 
3.0%
6 110
 
2.5%
Other values (5) 279
 
6.4%
Latin
ValueCountFrequency (%)
B 2
15.4%
A 2
15.4%
d 1
7.7%
U 1
7.7%
F 1
7.7%
K 1
7.7%
T 1
7.7%
D 1
7.7%
S 1
7.7%
H 1
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6251
58.9%
ASCII 4368
41.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2044
46.8%
1 451
 
10.3%
2 386
 
8.8%
, 295
 
6.8%
3 219
 
5.0%
0 154
 
3.5%
- 144
 
3.3%
4 141
 
3.2%
5 132
 
3.0%
6 110
 
2.5%
Other values (16) 292
 
6.7%
Hangul
ValueCountFrequency (%)
524
 
8.4%
502
 
8.0%
458
 
7.3%
453
 
7.2%
293
 
4.7%
260
 
4.2%
215
 
3.4%
215
 
3.4%
210
 
3.4%
210
 
3.4%
Other values (210) 2911
46.6%

전화번호
Text

MISSING 

Distinct317
Distinct (%)97.8%
Missing125
Missing (%)27.8%
Memory size3.6 KiB
2023-12-13T07:15:26.734344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.024691
Min length12

Characters and Unicode

Total characters3896
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique310 ?
Unique (%)95.7%

Sample

1st row061-744-7892
2nd row061-653-2350
3rd row061-744-7921
4th row061-276-2662
5th row061-651-1171
ValueCountFrequency (%)
061-334-5202 2
 
0.6%
061-281-7848 2
 
0.6%
061-685-2417 2
 
0.6%
061-352-1254 2
 
0.6%
061-724-3900 2
 
0.6%
061-394-5508 2
 
0.6%
061-683-4292 2
 
0.6%
061-744-7892 1
 
0.3%
061-381-5544 1
 
0.3%
061-555-0445 1
 
0.3%
Other values (307) 307
94.8%
2023-12-13T07:15:27.174845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 648
16.6%
6 536
13.8%
0 534
13.7%
1 497
12.8%
3 310
8.0%
2 305
7.8%
7 271
7.0%
5 241
 
6.2%
8 220
 
5.6%
4 200
 
5.1%
Other values (2) 134
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3247
83.3%
Dash Punctuation 648
 
16.6%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 536
16.5%
0 534
16.4%
1 497
15.3%
3 310
9.5%
2 305
9.4%
7 271
8.3%
5 241
7.4%
8 220
6.8%
4 200
 
6.2%
9 133
 
4.1%
Dash Punctuation
ValueCountFrequency (%)
- 648
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 3896
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 648
16.6%
6 536
13.8%
0 534
13.7%
1 497
12.8%
3 310
8.0%
2 305
7.8%
7 271
7.0%
5 241
 
6.2%
8 220
 
5.6%
4 200
 
5.1%
Other values (2) 134
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3896
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 648
16.6%
6 536
13.8%
0 534
13.7%
1 497
12.8%
3 310
8.0%
2 305
7.8%
7 271
7.0%
5 241
 
6.2%
8 220
 
5.6%
4 200
 
5.1%
Other values (2) 134
 
3.4%
Distinct443
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size3.6 KiB
2023-12-13T07:15:27.551227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9821826
Min length2

Characters and Unicode

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

Unique

Unique437 ?
Unique (%)97.3%

Sample

1st row정남조
2nd row조도인
3rd row최상채
4th row노상익
5th row윤문곤
ValueCountFrequency (%)
김영진 2
 
0.4%
박미진 2
 
0.4%
이선경 2
 
0.4%
심우석 2
 
0.4%
서지훈 2
 
0.4%
박종성 2
 
0.4%
박상석 1
 
0.2%
박병수 1
 
0.2%
조용조 1
 
0.2%
오금열 1
 
0.2%
Other values (435) 435
96.5%
2023-12-13T07:15:28.074989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
86
 
6.4%
60
 
4.5%
50
 
3.7%
46
 
3.4%
41
 
3.1%
33
 
2.5%
30
 
2.2%
29
 
2.2%
29
 
2.2%
26
 
1.9%
Other values (164) 909
67.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1337
99.9%
Space Separator 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
 
6.4%
60
 
4.5%
50
 
3.7%
46
 
3.4%
41
 
3.1%
33
 
2.5%
30
 
2.2%
29
 
2.2%
29
 
2.2%
26
 
1.9%
Other values (163) 907
67.8%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1337
99.9%
Common 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
 
6.4%
60
 
4.5%
50
 
3.7%
46
 
3.4%
41
 
3.1%
33
 
2.5%
30
 
2.2%
29
 
2.2%
29
 
2.2%
26
 
1.9%
Other values (163) 907
67.8%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1337
99.9%
ASCII 2
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
86
 
6.4%
60
 
4.5%
50
 
3.7%
46
 
3.4%
41
 
3.1%
33
 
2.5%
30
 
2.2%
29
 
2.2%
29
 
2.2%
26
 
1.9%
Other values (163) 907
67.8%
ASCII
ValueCountFrequency (%)
2
100.0%

Missing values

2023-12-13T07:15:24.472739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:15:24.611233image/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호남 건축사사무소전라남도 순천시 장명로 27061-744-7892정남조
1진남 건축사사무소전라남도 여수시 문수로 141, 3층061-653-2350조도인
2최상채 건축사사무소전라남도 순천시 장천동 대지 49-20061-744-7921최상채
3전일건축사사무소전라남도 목포시 양을로 178061-276-2662노상익
4대윤 건축사사무소전라남도 여수시 시청서1길 6061-651-1171윤문곤
5홍익 건축사사무소전라남도 담양군 담양읍 추성로 1379061-383-5321현수호
6해동 건축사사무소전라남도 고흥군 고흥읍 흥양길 35, 1층061-833-1998남윤홍
7(그룹)에스앤에이건축사사무소 유일전라남도 광양시 광양읍 호북길 4-15, 주2동061-763-5042탁기봉
8(주)건축사사무소 피아이에이전라남도 여수시 소호로 638, 4층061-685-2417김용휘
9기흥건축사사무소전라남도 순천시 이수로 276, 나동061-722-3067김기호
사무소명사무소주소전화번호대표자
439주식회사 신화이엔씨건축사사무소전라남도 해남군 해남읍 군청길 1, 6층, 602호070-4944-0512최환석
440예림건축사사무소전라남도 화순군 화순읍 동헌길 30, 1층<NA>손미애
441이룸건축사사무소전라남도 해남군 해남읍 군청길 19 이룸건축사사무소061-532-3335이종돈
442한일건축사사무소전라남도 완도군 완도읍 청해진남로 39061-554-3618최재철
443건축사사무소 대상전라남도 나주시 금천면 촌곡신가길 141<NA>차인호
444건축사사무소 터전라남도 장성군 장성읍 영천로 189061-394-5508정윤주
445로우 건축사사무소전라남도 나주시 교육길 13, d-3동 405호<NA>김새롬
446산하종합기술건축사사무소 주식회사전라남도 여수시 시청서2길 39-1, 산하종합기술 건축사사무소061-691-2515윤상구
447선담해건축사사무소전라남도 신안군 압해읍 압해로 879, 1층<NA>노광수
448건축사사무소 이상전라남도 나주시 금영로 17, 건축사사무소 이상061-333-3486이상귀