Overview

Dataset statistics

Number of variables7
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory62.4 B

Variable types

DateTime1
Categorical4
Text1
Numeric1

Dataset

Description한국표준과학연구원 대표홈페이지를 통해 견학 신청을 완료한 현황 데이터 입니다. 데이터의 항목은 신청일, 신청시간, 신청자분류, 신청단체명, 신청예비인원, 신청총원, 승인현황으로 구성되어 있습니다.
URLhttps://www.data.go.kr/data/15117093/fileData.do

Alerts

신청예비인원 has constant value ""Constant

Reproduction

Analysis started2023-12-12 13:57:33.160831
Analysis finished2023-12-12 13:57:33.827904
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct26
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-03-30 00:00:00
Maximum2023-10-12 00:00:00
2023-12-12T22:57:33.891999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:57:34.017674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

신청시간
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2시간
17 
1시간
13 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2시간
2nd row1시간
3rd row2시간
4th row2시간
5th row1시간

Common Values

ValueCountFrequency (%)
2시간 17
56.7%
1시간 13
43.3%

Length

2023-12-12T22:57:34.166735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:57:34.267628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2시간 17
56.7%
1시간 13
43.3%

신청자분류
Categorical

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
초등
21 
중등
일반
 
2
대학
 
2
고등
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row중등
2nd row초등
3rd row중등
4th row초등
5th row초등

Common Values

ValueCountFrequency (%)
초등 21
70.0%
중등 4
 
13.3%
일반 2
 
6.7%
대학 2
 
6.7%
고등 1
 
3.3%

Length

2023-12-12T22:57:34.376071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:57:34.506474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
초등 21
70.0%
중등 4
 
13.3%
일반 2
 
6.7%
대학 2
 
6.7%
고등 1
 
3.3%
Distinct24
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-12T22:57:34.737243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18.5
Mean length10.6
Min length4

Characters and Unicode

Total characters318
Distinct characters89
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

Unique18 ?
Unique (%)60.0%

Sample

1st row경운XX교 임상병리학과
2nd row이리XX학교
3rd row세종XX고등학교(서울소재)
4th row세종XX고
5th row세종XX고등학교
ValueCountFrequency (%)
대전xx중학교 4
 
8.2%
수리xx미수리 2
 
4.1%
1학년 2
 
4.1%
동구xx원 2
 
4.1%
동구이야기 2
 
4.1%
인문학강좌 2
 
4.1%
그룹 2
 
4.1%
부흥xx학교 2
 
4.1%
점촌xx학교 2
 
4.1%
노벨과학동아리(바이오스 2
 
4.1%
Other values (27) 27
55.1%
2023-12-12T22:57:35.139032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
X 60
 
18.9%
25
 
7.9%
21
 
6.6%
20
 
6.3%
10
 
3.1%
7
 
2.2%
6
 
1.9%
6
 
1.9%
6
 
1.9%
6
 
1.9%
Other values (79) 151
47.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 226
71.1%
Uppercase Letter 60
 
18.9%
Space Separator 20
 
6.3%
Close Punctuation 4
 
1.3%
Open Punctuation 4
 
1.3%
Decimal Number 2
 
0.6%
Connector Punctuation 1
 
0.3%
Dash Punctuation 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
25
 
11.1%
21
 
9.3%
10
 
4.4%
7
 
3.1%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
4
 
1.8%
Other values (72) 129
57.1%
Uppercase Letter
ValueCountFrequency (%)
X 60
100.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Decimal Number
ValueCountFrequency (%)
1 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 226
71.1%
Latin 60
 
18.9%
Common 32
 
10.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
25
 
11.1%
21
 
9.3%
10
 
4.4%
7
 
3.1%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
4
 
1.8%
Other values (72) 129
57.1%
Common
ValueCountFrequency (%)
20
62.5%
) 4
 
12.5%
( 4
 
12.5%
1 2
 
6.2%
_ 1
 
3.1%
- 1
 
3.1%
Latin
ValueCountFrequency (%)
X 60
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 226
71.1%
ASCII 92
28.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
X 60
65.2%
20
 
21.7%
) 4
 
4.3%
( 4
 
4.3%
1 2
 
2.2%
_ 1
 
1.1%
- 1
 
1.1%
Hangul
ValueCountFrequency (%)
25
 
11.1%
21
 
9.3%
10
 
4.4%
7
 
3.1%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
6
 
2.7%
4
 
1.8%
Other values (72) 129
57.1%

신청예비인원
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
0
30 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 30
100.0%

Length

2023-12-12T22:57:35.299739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:57:35.392377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 30
100.0%

신청총원
Real number (ℝ)

Distinct15
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.1
Minimum4
Maximum40
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T22:57:35.474022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile10
Q112.75
median24.5
Q332.25
95-th percentile37.75
Maximum40
Range36
Interquartile range (IQR)19.5

Descriptive statistics

Standard deviation10.316876
Coefficient of variation (CV)0.44661801
Kurtosis-1.1973286
Mean23.1
Median Absolute Deviation (MAD)9
Skewness-0.074255871
Sum693
Variance106.43793
MonotonicityNot monotonic
2023-12-12T22:57:35.606938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
35 4
13.3%
24 3
10.0%
25 3
10.0%
10 3
10.0%
40 2
 
6.7%
17 2
 
6.7%
28 2
 
6.7%
12 2
 
6.7%
33 2
 
6.7%
11 2
 
6.7%
Other values (5) 5
16.7%
ValueCountFrequency (%)
4 1
 
3.3%
10 3
10.0%
11 2
6.7%
12 2
6.7%
15 1
 
3.3%
16 1
 
3.3%
17 2
6.7%
24 3
10.0%
25 3
10.0%
28 2
6.7%
ValueCountFrequency (%)
40 2
6.7%
35 4
13.3%
33 2
6.7%
30 1
 
3.3%
29 1
 
3.3%
28 2
6.7%
25 3
10.0%
24 3
10.0%
17 2
6.7%
16 1
 
3.3%

승인현황
Categorical

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
승인
17 
미승인
13 

Length

Max length3
Median length2
Mean length2.4333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row승인
2nd row승인
3rd row미승인
4th row미승인
5th row승인

Common Values

ValueCountFrequency (%)
승인 17
56.7%
미승인 13
43.3%

Length

2023-12-12T22:57:35.770799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:57:35.910349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
승인 17
56.7%
미승인 13
43.3%

Interactions

2023-12-12T22:57:33.450624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:57:35.982066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청일신청시간신청자분류신청단체명신청총원승인현황
신청일1.0000.2810.9590.9260.9900.281
신청시간0.2811.0000.2600.4490.0000.351
신청자분류0.9590.2601.0001.0000.4920.000
신청단체명0.9260.4491.0001.0001.0000.000
신청총원0.9900.0000.4921.0001.0000.000
승인현황0.2810.3510.0000.0000.0001.000
2023-12-12T22:57:36.099162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청시간신청자분류승인현황
신청시간1.0000.2930.226
신청자분류0.2931.0000.000
승인현황0.2260.0001.000
2023-12-12T22:57:36.203083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청총원신청시간신청자분류승인현황
신청총원1.0000.0000.2680.000
신청시간0.0001.0000.2930.226
신청자분류0.2680.2931.0000.000
승인현황0.0000.2260.0001.000

Missing values

2023-12-12T22:57:33.597478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:57:33.767426image/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

신청일신청시간신청자분류신청단체명신청예비인원신청총원승인현황
02023-03-302시간중등경운XX교 임상병리학과040승인
12023-05-041시간초등이리XX학교030승인
22023-05-092시간중등세종XX고등학교(서울소재)024미승인
32023-05-092시간초등세종XX고024미승인
42023-05-091시간초등세종XX고등학교024승인
52023-05-111시간초등수성XX학교(경기도 수원소재)025승인
62023-05-162시간초등대전XX중학교 노벨과학동아리(바이오스)017승인
72023-05-182시간초등대전XX중학교 1학년028승인
82023-05-252시간초등대전XX중학교 1학년028승인
92023-05-301시간일반동구XX원 동구이야기 인문학강좌 그룹010미승인
신청일신청시간신청자분류신청단체명신청예비인원신청총원승인현황
202023-08-101시간초등엘림XX교육원010미승인
212023-08-101시간초등점촌XX학교033미승인
222023-08-152시간초등산곡XX학교 표준 동아리 - 체인지 메이커025미승인
232023-08-221시간초등역사XX035승인
242023-08-242시간중등한국XX재단 사회리더멘토링011승인
252023-08-312시간중등사회XX멘토링011미승인
262023-09-052시간대학현대XX차04승인
272023-09-261시간대학대전XX현장탐방_전국교육감 직원035승인
282023-10-032시간초등선주XX학교016미승인
292023-10-121시간초등인천XX코고등학교029승인