Overview

Dataset statistics

Number of variables4
Number of observations64
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory34.1 B

Variable types

Text2
DateTime1
Categorical1

Dataset

Description대전도시철도공사 전기팀 제안(창안) 제출 현황(접수번호, 제출일자, 제안명, 제안구분)에 관한 자료입니다. 관련자료 검색시 참고해 주시기 바랍니다.
Author대전교통공사
URLhttps://www.data.go.kr/data/15098477/fileData.do

Alerts

접수번호 has unique valuesUnique
제 안 명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:43:54.273367
Analysis finished2023-12-12 00:43:54.705012
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

접수번호
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-12T09:43:54.943621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length6
Mean length6.078125
Min length5

Characters and Unicode

Total characters389
Distinct characters13
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique64 ?
Unique (%)100.0%

Sample

1st row006-01
2nd row006-17
3rd row007-40
4th row008-13
5th row008-45
ValueCountFrequency (%)
006-01 1
 
1.6%
006-17 1
 
1.6%
016-47 1
 
1.6%
013-09 1
 
1.6%
013-15 1
 
1.6%
013-21 1
 
1.6%
014-03 1
 
1.6%
014-06 1
 
1.6%
015-14 1
 
1.6%
015-27 1
 
1.6%
Other values (54) 54
84.4%
2023-12-12T09:43:55.350258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 98
25.2%
- 64
16.5%
1 58
14.9%
2 47
12.1%
7 22
 
5.7%
6 20
 
5.1%
3 20
 
5.1%
8 17
 
4.4%
9 14
 
3.6%
4 13
 
3.3%
Other values (3) 16
 
4.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 320
82.3%
Dash Punctuation 64
 
16.5%
Uppercase Letter 4
 
1.0%
Space Separator 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 98
30.6%
1 58
18.1%
2 47
14.7%
7 22
 
6.9%
6 20
 
6.2%
3 20
 
6.2%
8 17
 
5.3%
9 14
 
4.4%
4 13
 
4.1%
5 11
 
3.4%
Dash Punctuation
ValueCountFrequency (%)
- 64
100.0%
Uppercase Letter
ValueCountFrequency (%)
P 4
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 385
99.0%
Latin 4
 
1.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 98
25.5%
- 64
16.6%
1 58
15.1%
2 47
12.2%
7 22
 
5.7%
6 20
 
5.2%
3 20
 
5.2%
8 17
 
4.4%
9 14
 
3.6%
4 13
 
3.4%
Other values (2) 12
 
3.1%
Latin
ValueCountFrequency (%)
P 4
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 389
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 98
25.2%
- 64
16.5%
1 58
14.9%
2 47
12.1%
7 22
 
5.7%
6 20
 
5.1%
3 20
 
5.1%
8 17
 
4.4%
9 14
 
3.6%
4 13
 
3.3%
Other values (3) 16
 
4.1%

제출일자
Date

Distinct61
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Memory size644.0 B
Minimum2006-08-31 00:00:00
Maximum2022-10-12 00:00:00
2023-12-12T09:43:55.546373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:43:55.677116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

제 안 명
Text

UNIQUE 

Distinct64
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size644.0 B
2023-12-12T09:43:56.007211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length33
Mean length23.375
Min length7

Characters and Unicode

Total characters1496
Distinct characters259
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique64 ?
Unique (%)100.0%

Sample

1st row본선구간 조명 제어방법 개선 방안
2nd row장력추 가동 표시장치
3rd row지상변전소(판암, 외삼) 실내온도 저감방법
4th row절전형 형광등 대체 사용으로 인한 전력비용 절감
5th row터널 내 형광등 시간별로 소등하여 예산비용 절감
ValueCountFrequency (%)
개선 18
 
4.9%
설치 15
 
4.1%
및 8
 
2.2%
변전소 8
 
2.2%
전기실 6
 
1.6%
위한 6
 
1.6%
역사 5
 
1.4%
모터카 5
 
1.4%
회로 5
 
1.4%
전차선 5
 
1.4%
Other values (235) 287
78.0%
2023-12-12T09:43:56.477418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
305
 
20.4%
전 61
 
4.1%
선 40
 
2.7%
기 37
 
2.5%
시 27
 
1.8%
치 27
 
1.8%
개 25
 
1.7%
방 24
 
1.6%
지 21
 
1.4%
로 20
 
1.3%
Other values (249) 909
60.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1064
71.1%
Space Separator 305
 
20.4%
Uppercase Letter 56
 
3.7%
Lowercase Letter 24
 
1.6%
Decimal Number 17
 
1.1%
Close Punctuation 10
 
0.7%
Open Punctuation 10
 
0.7%
Other Punctuation 4
 
0.3%
Dash Punctuation 3
 
0.2%
Initial Punctuation 1
 
0.1%
Other values (2) 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 61
 
5.7%
선 40
 
3.8%
기 37
 
3.5%
시 27
 
2.5%
치 27
 
2.5%
개 25
 
2.3%
방 24
 
2.3%
지 21
 
2.0%
로 20
 
1.9%
설 19
 
1.8%
Other values (205) 763
71.7%
Uppercase Letter
ValueCountFrequency (%)
P 8
14.3%
R 5
 
8.9%
C 5
 
8.9%
M 5
 
8.9%
G 4
 
7.1%
D 4
 
7.1%
S 3
 
5.4%
V 3
 
5.4%
T 3
 
5.4%
W 3
 
5.4%
Other values (8) 13
23.2%
Lowercase Letter
ValueCountFrequency (%)
e 4
16.7%
o 3
12.5%
r 3
12.5%
m 2
8.3%
a 2
8.3%
t 2
8.3%
l 2
8.3%
p 2
8.3%
i 1
 
4.2%
w 1
 
4.2%
Other values (2) 2
8.3%
Decimal Number
ValueCountFrequency (%)
2 5
29.4%
0 4
23.5%
5 4
23.5%
3 2
 
11.8%
6 1
 
5.9%
7 1
 
5.9%
Space Separator
ValueCountFrequency (%)
305
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 1
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%
Math Symbol
ValueCountFrequency (%)
> 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1064
71.1%
Common 352
 
23.5%
Latin 80
 
5.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 61
 
5.7%
선 40
 
3.8%
기 37
 
3.5%
시 27
 
2.5%
치 27
 
2.5%
개 25
 
2.3%
방 24
 
2.3%
지 21
 
2.0%
로 20
 
1.9%
설 19
 
1.8%
Other values (205) 763
71.7%
Latin
ValueCountFrequency (%)
P 8
 
10.0%
R 5
 
6.2%
C 5
 
6.2%
M 5
 
6.2%
G 4
 
5.0%
D 4
 
5.0%
e 4
 
5.0%
S 3
 
3.8%
V 3
 
3.8%
T 3
 
3.8%
Other values (20) 36
45.0%
Common
ValueCountFrequency (%)
305
86.6%
) 10
 
2.8%
( 10
 
2.8%
2 5
 
1.4%
0 4
 
1.1%
, 4
 
1.1%
5 4
 
1.1%
- 3
 
0.9%
3 2
 
0.6%
‘ 1
 
0.3%
Other values (4) 4
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1063
71.1%
ASCII 430
28.7%
Punctuation 2
 
0.1%
Compat Jamo 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
305
70.9%
) 10
 
2.3%
( 10
 
2.3%
P 8
 
1.9%
2 5
 
1.2%
R 5
 
1.2%
C 5
 
1.2%
M 5
 
1.2%
0 4
 
0.9%
, 4
 
0.9%
Other values (32) 69
 
16.0%
Hangul
ValueCountFrequency (%)
전 61
 
5.7%
선 40
 
3.8%
기 37
 
3.5%
시 27
 
2.5%
치 27
 
2.5%
개 25
 
2.4%
방 24
 
2.3%
지 21
 
2.0%
로 20
 
1.9%
설 19
 
1.8%
Other values (204) 762
71.7%
Punctuation
ValueCountFrequency (%)
‘ 1
50.0%
’ 1
50.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 1
100.0%

제안구분
Categorical

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
아이디어
30 
직무
24 
일반
8 
일반제안
 
2

Length

Max length4
Median length3
Mean length3
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row직무
2nd row직무
3rd row직무
4th row직무
5th row직무

Common Values

ValueCountFrequency (%)
아이디어 30
46.9%
직무 24
37.5%
일반 8
 
12.5%
일반제안 2
 
3.1%

Length

2023-12-12T09:43:56.650356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:43:56.777946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
아이디어 30
46.9%
직무 24
37.5%
일반 8
 
12.5%
일반제안 2
 
3.1%

Correlations

2023-12-12T09:43:56.860434image/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-12T09:43:54.545254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:43:54.656807image/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

접수번호제출일자제 안 명제안구분
0006-012006-08-31본선구간 조명 제어방법 개선 방안직무
1006-172006-10-31장력추 가동 표시장치직무
2007-402007-09-03지상변전소(판암, 외삼) 실내온도 저감방법직무
3008-132008-04-22절전형 형광등 대체 사용으로 인한 전력비용 절감직무
4008-452008-10-08터널 내 형광등 시간별로 소등하여 예산비용 절감직무
5009-282009-05-14알루미늄 풍선에 의한 전차선 사고방지직무
6009-772009-10-29변전소, 전기실 출입문 센서등 설치직무
7009-812009-11-10변전소 52R2, 52R3반 Power 표시 Lamp 설치직무
8009-822009-11-12전자식 보호계전장치(GIPAM 2000) 통신 감시 프로그램 구축직무
9006-232006-11-08지적재산권 취득시 인센티브 지급방안일반
접수번호제출일자제 안 명제안구분
54P2019-0362019-08-27DC전압변환장치(TD) 검수장치 제작일반제안
55P2020-0382020-06-28전차선로 누설전류 측정방법 개선(전기팀)아이디어
5621-212021-04-05역사 전력공급 안정화 방안아이디어
5721-242021-04-05배전반 자동소화장치 내 배터리 교체(점검) 방법 개선아이디어
5821-282021-04-05전기실 단전 작업시 52T 투입 인적오류 제거아이디어
5921-632021-10-07모터카 출고 시 터널 내 구조물과 충돌방지를 위한 모터카 출입구 충돌방지 바 및 센서 설치아이디어
6022-082022-04-14태양광 발전설비 가압 표시램프 설치아이디어
6122-282022-07-08철주 경사계 측정 방법 개선아이디어
6222-492022-10-12감전사고 예방을 위한 호계(그룹) 구분용 표시 설치아이디어
6322-502022-10-12기지 변전소 상시등 점등방법 개선아이디어