Overview

Dataset statistics

Number of variables5
Number of observations770
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory31.0 KiB
Average record size in memory41.2 B

Variable types

Text1
Categorical1
DateTime2
Numeric1

Dataset

Description방송통신기자재등의 시험기관이 시험할 수 있는 시험분야 시험항목 상세 내역입니다, 국내 지정시험기관과 MRA 시험기관 포함입니다.
URLhttps://www.data.go.kr/data/15118057/fileData.do

Reproduction

Analysis started2023-12-12 11:22:06.058568
Analysis finished2023-12-12 11:22:06.779137
Duration0.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct534
Distinct (%)69.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
2023-12-12T20:22:07.331683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0012987
Min length6

Characters and Unicode

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

Unique

Unique447 ?
Unique (%)58.1%

Sample

1st rowCA9543
2nd rowCA9543
3rd rowCA6844
4th rowKR0032
5th rowKR0032
ValueCountFrequency (%)
kr0041 6
 
0.8%
kr0157 6
 
0.8%
kr0049 6
 
0.8%
kr0013 6
 
0.8%
kr0026 6
 
0.8%
kr0019 6
 
0.8%
kr0034 6
 
0.8%
kr0100 6
 
0.8%
kr0166 6
 
0.8%
kr0032 6
 
0.8%
Other values (524) 710
92.2%
2023-12-12T20:22:08.277501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1185
25.6%
U 531
11.5%
1 457
 
9.9%
E 329
 
7.1%
4 268
 
5.8%
K 244
 
5.3%
2 240
 
5.2%
R 212
 
4.6%
6 186
 
4.0%
5 172
 
3.7%
Other values (7) 797
17.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3081
66.7%
Uppercase Letter 1540
33.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1185
38.5%
1 457
 
14.8%
4 268
 
8.7%
2 240
 
7.8%
6 186
 
6.0%
5 172
 
5.6%
3 157
 
5.1%
7 153
 
5.0%
9 139
 
4.5%
8 124
 
4.0%
Uppercase Letter
ValueCountFrequency (%)
U 531
34.5%
E 329
21.4%
K 244
15.8%
R 212
 
13.8%
S 170
 
11.0%
C 27
 
1.8%
A 27
 
1.8%

Most occurring scripts

ValueCountFrequency (%)
Common 3081
66.7%
Latin 1540
33.3%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1185
38.5%
1 457
 
14.8%
4 268
 
8.7%
2 240
 
7.8%
6 186
 
6.0%
5 172
 
5.6%
3 157
 
5.1%
7 153
 
5.0%
9 139
 
4.5%
8 124
 
4.0%
Latin
ValueCountFrequency (%)
U 531
34.5%
E 329
21.4%
K 244
15.8%
R 212
 
13.8%
S 170
 
11.0%
C 27
 
1.8%
A 27
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4621
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1185
25.6%
U 531
11.5%
1 457
 
9.9%
E 329
 
7.1%
4 268
 
5.8%
K 244
 
5.3%
2 240
 
5.2%
R 212
 
4.6%
6 186
 
4.0%
5 172
 
3.7%
Other values (7) 797
17.2%
Distinct6
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
E
520 
R
86 
EW
 
52
FR
 
39
T
 
37

Length

Max length2
Median length1
Mean length1.1649351
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowR
2nd rowE
3rd rowE
4th rowE
5th rowEW

Common Values

ValueCountFrequency (%)
E 520
67.5%
R 86
 
11.2%
EW 52
 
6.8%
FR 39
 
5.1%
T 37
 
4.8%
SR 36
 
4.7%

Length

2023-12-12T20:22:08.552026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:22:08.765083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
e 520
67.5%
r 86
 
11.2%
ew 52
 
6.8%
fr 39
 
5.1%
t 37
 
4.8%
sr 36
 
4.7%
Distinct111
Distinct (%)14.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
Minimum2012-05-25 00:00:00
Maximum2023-07-07 00:00:00
2023-12-12T20:22:09.000586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:22:09.281024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

민원접수번호
Real number (ℝ)

Distinct21
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0217968 × 1017
Minimum2.012157 × 1017
Maximum2.0231721 × 1017
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.9 KiB
2023-12-12T20:22:09.546334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.012157 × 1017
5-th percentile2.02 × 1017
Q12.021 × 1017
median2.022 × 1017
Q32.023 × 1017
95-th percentile2.023 × 1017
Maximum2.0231721 × 1017
Range1.101509 × 1015
Interquartile range (IQR)2 × 1014

Descriptive statistics

Standard deviation1.2062428 × 1014
Coefficient of variation (CV)0.00059661921
Kurtosis9.0340623
Mean2.0217968 × 1017
Median Absolute Deviation (MAD)1 × 1014
Skewness-1.9941844
Sum8.1044038 × 1018
Variance1.4550218 × 1028
MonotonicityNot monotonic
2023-12-12T20:22:09.805549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
202200000000001000 311
40.4%
202300000000001000 225
29.2%
202100000000001000 126
16.4%
202000000000001000 68
 
8.8%
201900000000001000 16
 
2.1%
201800000000000000 9
 
1.2%
202017210000274000 1
 
0.1%
201215701000165000 1
 
0.1%
201317100000196000 1
 
0.1%
201617100000227000 1
 
0.1%
Other values (11) 11
 
1.4%
ValueCountFrequency (%)
201215701000165000 1
 
0.1%
201317100000196000 1
 
0.1%
201617100000227000 1
 
0.1%
201800000000000000 9
 
1.2%
201817210000278000 1
 
0.1%
201900000000001000 16
 
2.1%
202000000000001000 68
8.8%
202017210000049000 1
 
0.1%
202017210000191000 1
 
0.1%
202017210000267000 1
 
0.1%
ValueCountFrequency (%)
202317210000032000 1
 
0.1%
202300000000001000 225
29.2%
202217210000212000 1
 
0.1%
202217210000193000 1
 
0.1%
202217210000104000 1
 
0.1%
202217210000053000 1
 
0.1%
202200000000001000 311
40.4%
202117210000427000 1
 
0.1%
202117210000426000 1
 
0.1%
202100000000001000 126
16.4%
Distinct465
Distinct (%)60.4%
Missing0
Missing (%)0.0%
Memory size6.1 KiB
Minimum2012-05-25 16:24:00
Maximum2023-07-07 10:15:00
2023-12-12T20:22:10.051627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:22:10.354516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T20:22:06.263696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:22:10.544740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시험분야코드민원접수번호
시험분야코드1.0000.266
민원접수번호0.2661.000
2023-12-12T20:22:10.702132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
민원접수번호시험분야코드
민원접수번호1.0000.167
시험분야코드0.1671.000

Missing values

2023-12-12T20:22:06.511782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:22:06.704548image/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

지정시험기관코드시험분야코드지정일자민원접수번호최종수정일자
0CA9543R2023-07-072023000000000010002023-07-07 10:15
1CA9543E2023-07-072023000000000010002023-07-07 10:15
2CA6844E2023-07-072023000000000010002023-07-07 9:29
3KR0032E2023-06-302023000000000010002023-06-30 17:16
4KR0032EW2023-06-302023000000000010002023-06-30 17:16
5KR0032FR2023-06-302023000000000010002023-06-30 17:16
6KR0032R2023-06-302023000000000010002023-06-30 17:16
7KR0032SR2023-06-302023000000000010002023-06-30 17:16
8KR0032T2023-06-302023000000000010002023-06-30 17:16
9KR0150SR2023-06-302023000000000010002023-06-30 17:15
지정시험기관코드시험분야코드지정일자민원접수번호최종수정일자
760US0111E2018-07-312018000000000000002018-07-31 11:18
761US0111R2018-07-312018000000000000002018-07-31 11:18
762US0099E2018-07-312018000000000000002018-07-31 11:18
763US0023E2018-07-312018000000000000002018-07-31 11:18
764KR0146EW2018-02-012019000000000010002018-02-01 19:59
765KR0009EW2017-09-222020000000000010002017-09-22 15:58
766KR0162R2017-04-042016171000002270002017-04-04 17:11
767KR0154R2014-02-142013171000001960002014-02-14 18:03
768US0113R2012-09-272012157010001650002012-09-27 16:59
769KR0146E2012-05-252019000000000010002012-05-25 16:24