Overview

Dataset statistics

Number of variables5
Number of observations37
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory43.6 B

Variable types

Categorical2
Text3

Dataset

Description대전시 경관위원회 명단 입니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15068534/fileData.do

Alerts

임기 has constant value ""Constant
성명 has unique valuesUnique
소속 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:04:46.692942
Analysis finished2023-12-12 12:04:47.134166
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

분야
Categorical

Distinct13
Distinct (%)35.1%
Missing0
Missing (%)0.0%
Memory size428.0 B
디자인
8 
건축
7 
경관
7 
토목
3 
도시
2 
Other values (8)
10 

Length

Max length4
Median length2
Mean length2.3243243
Min length2

Unique

Unique6 ?
Unique (%)16.2%

Sample

1st row행정
2nd row의원
3rd row건축
4th row건축
5th row건축

Common Values

ValueCountFrequency (%)
디자인 8
21.6%
건축 7
18.9%
경관 7
18.9%
토목 3
 
8.1%
도시 2
 
5.4%
옥외광고 2
 
5.4%
색채 2
 
5.4%
행정 1
 
2.7%
의원 1
 
2.7%
조경 1
 
2.7%
Other values (3) 3
 
8.1%

Length

2023-12-12T21:04:47.239735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
디자인 8
21.6%
건축 7
18.9%
경관 7
18.9%
토목 3
 
8.1%
도시 2
 
5.4%
옥외광고 2
 
5.4%
색채 2
 
5.4%
행정 1
 
2.7%
의원 1
 
2.7%
조경 1
 
2.7%
Other values (3) 3
 
8.1%

성명
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-12T21:04:47.570686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

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

Unique

Unique37 ?
Unique (%)100.0%

Sample

1st row류택열
2nd row조성칠
3rd row권명원
4th row권세미
5th row도경환
ValueCountFrequency (%)
류택열 1
 
2.7%
유재호 1
 
2.7%
이용환 1
 
2.7%
김현선 1
 
2.7%
박유선 1
 
2.7%
배도명 1
 
2.7%
서계숙 1
 
2.7%
안세윤 1
 
2.7%
이현이 1
 
2.7%
하은경 1
 
2.7%
Other values (27) 27
73.0%
2023-12-12T21:04:48.031910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 5
 
4.5%
미 4
 
3.6%
은 4
 
3.6%
박 4
 
3.6%
정 4
 
3.6%
영 4
 
3.6%
유 3
 
2.7%
진 3
 
2.7%
송 3
 
2.7%
도 3
 
2.7%
Other values (52) 74
66.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 111
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 5
 
4.5%
미 4
 
3.6%
은 4
 
3.6%
박 4
 
3.6%
정 4
 
3.6%
영 4
 
3.6%
유 3
 
2.7%
진 3
 
2.7%
송 3
 
2.7%
도 3
 
2.7%
Other values (52) 74
66.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 111
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 5
 
4.5%
미 4
 
3.6%
은 4
 
3.6%
박 4
 
3.6%
정 4
 
3.6%
영 4
 
3.6%
유 3
 
2.7%
진 3
 
2.7%
송 3
 
2.7%
도 3
 
2.7%
Other values (52) 74
66.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 111
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 5
 
4.5%
미 4
 
3.6%
은 4
 
3.6%
박 4
 
3.6%
정 4
 
3.6%
영 4
 
3.6%
유 3
 
2.7%
진 3
 
2.7%
송 3
 
2.7%
도 3
 
2.7%
Other values (52) 74
66.7%

소속
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-12T21:04:48.295928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length19
Mean length14.459459
Min length5

Characters and Unicode

Total characters535
Distinct characters128
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique37 ?
Unique (%)100.0%

Sample

1st row대전광역시 도시재생주택본부장
2nd row대전광역시의회
3rd row플러스건축사(사)
4th row세광건축사(사)
5th row㈜건축사(사)이오공감
ValueCountFrequency (%)
교수 15
 
17.0%
충남대학교 3
 
3.4%
주식회사 2
 
2.3%
한밭대학교 2
 
2.3%
외래교수 2
 
2.3%
건축사사무소 2
 
2.3%
대전과학기술대학교 2
 
2.3%
한남대학교 2
 
2.3%
대전대학교 2
 
2.3%
건축사(사 2
 
2.3%
Other values (54) 54
61.4%
2023-12-12T21:04:48.745385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
52
 
9.7%
교 40
 
7.5%
학 37
 
6.9%
대 30
 
5.6%
사 23
 
4.3%
건 18
 
3.4%
수 17
 
3.2%
과 16
 
3.0%
축 16
 
3.0%
디 14
 
2.6%
Other values (118) 272
50.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 456
85.2%
Space Separator 52
 
9.7%
Open Punctuation 9
 
1.7%
Close Punctuation 9
 
1.7%
Uppercase Letter 6
 
1.1%
Other Symbol 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
교 40
 
8.8%
학 37
 
8.1%
대 30
 
6.6%
사 23
 
5.0%
건 18
 
3.9%
수 17
 
3.7%
과 16
 
3.5%
축 16
 
3.5%
디 14
 
3.1%
자 13
 
2.9%
Other values (108) 232
50.9%
Uppercase Letter
ValueCountFrequency (%)
E 1
16.7%
N 1
16.7%
G 1
16.7%
U 1
16.7%
L 1
16.7%
P 1
16.7%
Space Separator
ValueCountFrequency (%)
52
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 459
85.8%
Common 70
 
13.1%
Latin 6
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
교 40
 
8.7%
학 37
 
8.1%
대 30
 
6.5%
사 23
 
5.0%
건 18
 
3.9%
수 17
 
3.7%
과 16
 
3.5%
축 16
 
3.5%
디 14
 
3.1%
자 13
 
2.8%
Other values (109) 235
51.2%
Latin
ValueCountFrequency (%)
E 1
16.7%
N 1
16.7%
G 1
16.7%
U 1
16.7%
L 1
16.7%
P 1
16.7%
Common
ValueCountFrequency (%)
52
74.3%
( 9
 
12.9%
) 9
 
12.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 456
85.2%
ASCII 76
 
14.2%
None 3
 
0.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
52
68.4%
( 9
 
11.8%
) 9
 
11.8%
E 1
 
1.3%
N 1
 
1.3%
G 1
 
1.3%
U 1
 
1.3%
L 1
 
1.3%
P 1
 
1.3%
Hangul
ValueCountFrequency (%)
교 40
 
8.8%
학 37
 
8.1%
대 30
 
6.6%
사 23
 
5.0%
건 18
 
3.9%
수 17
 
3.7%
과 16
 
3.5%
축 16
 
3.5%
디 14
 
3.1%
자 13
 
2.9%
Other values (108) 232
50.9%
None
ValueCountFrequency (%)
㈜ 3
100.0%

전공
Text

Distinct28
Distinct (%)75.7%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-12T21:04:49.006413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length4
Mean length6.972973
Min length3

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)64.9%

Sample

1st row도시행정
2nd row의회행정
3rd row건축설계
4th row건축설계
5th row건축설계
ValueCountFrequency (%)
건축계획 5
 
9.1%
건축설계 5
 
9.1%
및 4
 
7.3%
시각디자인 3
 
5.5%
공공디자인 2
 
3.6%
범죄예방디자인 2
 
3.6%
색채디자인 2
 
3.6%
공간디자인 2
 
3.6%
토목공학 2
 
3.6%
도시계획 2
 
3.6%
Other values (26) 26
47.3%
2023-12-12T21:04:49.381917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
디 19
 
7.4%
19
 
7.4%
인 19
 
7.4%
자 19
 
7.4%
건 14
 
5.4%
축 14
 
5.4%
계 13
 
5.0%
공 12
 
4.7%
경 9
 
3.5%
, 9
 
3.5%
Other values (43) 111
43.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 227
88.0%
Space Separator 19
 
7.4%
Other Punctuation 12
 
4.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
디 19
 
8.4%
인 19
 
8.4%
자 19
 
8.4%
건 14
 
6.2%
축 14
 
6.2%
계 13
 
5.7%
공 12
 
5.3%
경 9
 
4.0%
획 8
 
3.5%
학 7
 
3.1%
Other values (40) 93
41.0%
Other Punctuation
ValueCountFrequency (%)
, 9
75.0%
/ 3
 
25.0%
Space Separator
ValueCountFrequency (%)
19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 227
88.0%
Common 31
 
12.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
디 19
 
8.4%
인 19
 
8.4%
자 19
 
8.4%
건 14
 
6.2%
축 14
 
6.2%
계 13
 
5.7%
공 12
 
5.3%
경 9
 
4.0%
획 8
 
3.5%
학 7
 
3.1%
Other values (40) 93
41.0%
Common
ValueCountFrequency (%)
19
61.3%
, 9
29.0%
/ 3
 
9.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 227
88.0%
ASCII 31
 
12.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
디 19
 
8.4%
인 19
 
8.4%
자 19
 
8.4%
건 14
 
6.2%
축 14
 
6.2%
계 13
 
5.7%
공 12
 
5.3%
경 9
 
4.0%
획 8
 
3.5%
학 7
 
3.1%
Other values (40) 93
41.0%
ASCII
ValueCountFrequency (%)
19
61.3%
, 9
29.0%
/ 3
 
9.7%

임기
Categorical

CONSTANT 

Distinct1
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size428.0 B
2020-07-29~2022-07-28
37 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-07-29~2022-07-28
2nd row2020-07-29~2022-07-28
3rd row2020-07-29~2022-07-28
4th row2020-07-29~2022-07-28
5th row2020-07-29~2022-07-28

Common Values

ValueCountFrequency (%)
2020-07-29~2022-07-28 37
100.0%

Length

2023-12-12T21:04:49.534813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:04:49.647790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-07-29~2022-07-28 37
100.0%

Correlations

2023-12-12T21:04:49.736007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분야성명소속전공
분야1.0001.0001.0000.994
성명1.0001.0001.0001.000
소속1.0001.0001.0001.000
전공0.9941.0001.0001.000

Missing values

2023-12-12T21:04:46.978181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:04:47.094711image/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행정류택열대전광역시 도시재생주택본부장도시행정2020-07-29~2022-07-28
1의원조성칠대전광역시의회의회행정2020-07-29~2022-07-28
2건축권명원플러스건축사(사)건축설계2020-07-29~2022-07-28
3건축권세미세광건축사(사)건축설계2020-07-29~2022-07-28
4건축도경환㈜건축사(사)이오공감건축설계2020-07-29~2022-07-28
5건축도용호중부대학교 건축학과 교수건축계획2020-07-29~2022-07-28
6건축송영규쿠파이엔지건축사(사)건축계획2020-07-29~2022-07-28
7건축양완숙신화ENG 종합건축사(사)건축계획2020-07-29~2022-07-28
8건축정미숙㈜이레건축사(사)건축설계2020-07-29~2022-07-28
9도시박순란포유엔지니어링종합건축사도시계획2020-07-29~2022-07-28
분야성명소속전공임기
27디자인이현이대전과학기술대학교 광고홍보디자인과 교수산업디자인2020-07-29~2022-07-28
28디자인하은경한남대학교 디자인학과 교수공간디자인, 실내디자인2020-07-29~2022-07-28
29디자인한은수한밭대학교 공업디자인학과 교수환경디자인, 공공디자인2020-07-29~2022-07-28
30교통이권진도로교통공단 대전충남지부 차장도시공학2020-07-29~2022-07-28
31환경서동일충남대학교토목환경 및 수질환경2020-07-29~2022-07-28
32옥외광고박종빈우송대학교 미디어디자인시각디자인 및 옥외광고2020-07-29~2022-07-28
33옥외광고유정미대전대학교 커뮤니케이션디자인학과 교수디자인학2020-07-29~2022-07-28
34조명임오연건양대학교 의료공간디자인학과 교수조명/색채2020-07-29~2022-07-28
35색채진은미㈜에스지이엔지 건축사(사)건축환경 및 색채2020-07-29~2022-07-28
36색채최영신충남대학교 공공정책대학원 외래교수환경색채, 건축/공공디자인2020-07-29~2022-07-28