Overview

Dataset statistics

Number of variables11
Number of observations27
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory96.9 B

Variable types

Numeric2
Text1
DateTime2
Categorical6

Dataset

Description부산광역시_기장군_정보화교육현황_12/31/2020
Author부산광역시 기장군
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3044324

Alerts

요일 has constant value ""Constant
인원 has constant value ""Constant
비고 has constant value ""Constant
시간(종료시간)) is highly overall correlated with 시간(시작시간) and 1 other fieldsHigh correlation
시간(시작시간) is highly overall correlated with 시간(종료시간)) and 1 other fieldsHigh correlation
연번 is highly overall correlated with 월High correlation
월 is highly overall correlated with 연번High correlation
일수 is highly overall correlated with 시간(시작시간) and 1 other fieldsHigh correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 16:58:05.060902
Analysis finished2023-12-10 16:58:06.169169
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-11T01:58:06.249795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2023-12-11T01:58:06.436684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

월
Real number (ℝ)

HIGH CORRELATION 

Distinct10
Distinct (%)37.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.0740741
Minimum2
Maximum11
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-11T01:58:06.586313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q13.5
median6
Q38
95-th percentile10.7
Maximum11
Range9
Interquartile range (IQR)4.5

Descriptive statistics

Standard deviation2.9342267
Coefficient of variation (CV)0.48307392
Kurtosis-1.1454984
Mean6.0740741
Median Absolute Deviation (MAD)2
Skewness0.1483845
Sum164
Variance8.6096866
MonotonicityIncreasing
2023-12-11T01:58:06.711190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
2 4
14.8%
3 3
11.1%
5 3
11.1%
6 3
11.1%
7 3
11.1%
8 3
11.1%
10 3
11.1%
4 2
7.4%
11 2
7.4%
9 1
 
3.7%
ValueCountFrequency (%)
2 4
14.8%
3 3
11.1%
4 2
7.4%
5 3
11.1%
6 3
11.1%
7 3
11.1%
8 3
11.1%
9 1
 
3.7%
10 3
11.1%
11 2
7.4%
ValueCountFrequency (%)
11 2
7.4%
10 3
11.1%
9 1
 
3.7%
8 3
11.1%
7 3
11.1%
6 3
11.1%
5 3
11.1%
4 2
7.4%
3 3
11.1%
2 4
14.8%

과정명
Text

Distinct16
Distinct (%)59.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-11T01:58:06.933622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length9
Mean length8.1851852
Min length5

Characters and Unicode

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

Unique

Unique9 ?
Unique (%)33.3%

Sample

1st row스마트폰 기초
2nd row컴퓨터 기초
3rd row엑셀 2010 기초
4th row한글 2010 기초
5th row한글 2010 기초
ValueCountFrequency (%)
기초 17
26.6%
2010 8
12.5%
엑셀 6
 
9.4%
파워포인트 5
 
7.8%
한글 5
 
7.8%
itq 4
 
6.2%
활용 3
 
4.7%
컴퓨터 2
 
3.1%
인터넷 2
 
3.1%
기초와 2
 
3.1%
Other values (6) 10
15.6%
2023-12-11T01:58:07.462544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
39
17.6%
기 21
 
9.5%
초 19
 
8.6%
0 16
 
7.2%
2 8
 
3.6%
1 8
 
3.6%
포 7
 
3.2%
인 7
 
3.2%
트 7
 
3.2%
엑 6
 
2.7%
Other values (29) 83
37.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 135
61.1%
Space Separator 39
 
17.6%
Decimal Number 32
 
14.5%
Uppercase Letter 15
 
6.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 21
15.6%
초 19
14.1%
포 7
 
5.2%
인 7
 
5.2%
트 7
 
5.2%
엑 6
 
4.4%
셀 6
 
4.4%
파 5
 
3.7%
워 5
 
3.7%
글 5
 
3.7%
Other values (21) 47
34.8%
Uppercase Letter
ValueCountFrequency (%)
Q 5
33.3%
T 5
33.3%
I 4
26.7%
G 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
0 16
50.0%
2 8
25.0%
1 8
25.0%
Space Separator
ValueCountFrequency (%)
39
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 135
61.1%
Common 71
32.1%
Latin 15
 
6.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 21
15.6%
초 19
14.1%
포 7
 
5.2%
인 7
 
5.2%
트 7
 
5.2%
엑 6
 
4.4%
셀 6
 
4.4%
파 5
 
3.7%
워 5
 
3.7%
글 5
 
3.7%
Other values (21) 47
34.8%
Common
ValueCountFrequency (%)
39
54.9%
0 16
22.5%
2 8
 
11.3%
1 8
 
11.3%
Latin
ValueCountFrequency (%)
Q 5
33.3%
T 5
33.3%
I 4
26.7%
G 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 135
61.1%
ASCII 86
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
39
45.3%
0 16
18.6%
2 8
 
9.3%
1 8
 
9.3%
Q 5
 
5.8%
T 5
 
5.8%
I 4
 
4.7%
G 1
 
1.2%
Hangul
ValueCountFrequency (%)
기 21
15.6%
초 19
14.1%
포 7
 
5.2%
인 7
 
5.2%
트 7
 
5.2%
엑 6
 
4.4%
셀 6
 
4.4%
파 5
 
3.7%
워 5
 
3.7%
글 5
 
3.7%
Other values (21) 47
34.8%

기간(시작일)
Date

Distinct21
Distinct (%)77.8%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2020-02-03 00:00:00
Maximum2020-11-02 00:00:00
2023-12-11T01:58:07.677387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:58:07.883164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

기간(종료일)
Date

Distinct21
Distinct (%)77.8%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2020-02-14 00:00:00
Maximum2020-11-13 00:00:00
2023-12-11T01:58:08.073917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:58:08.253865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

시간(시작시간)
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
10:00:00
17 
13:30:00
10 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row10:00:00
2nd row10:00:00
3rd row13:30:00
4th row13:30:00
5th row10:00:00

Common Values

ValueCountFrequency (%)
10:00:00 17
63.0%
13:30:00 10
37.0%

Length

2023-12-11T01:58:08.461352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:08.623537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10:00:00 17
63.0%
13:30:00 10
37.0%

시간(종료시간))
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
12:00:00
17 
15:30:00
10 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row12:00:00
2nd row12:00:00
3rd row15:30:00
4th row15:30:00
5th row12:00:00

Common Values

ValueCountFrequency (%)
12:00:00 17
63.0%
15:30:00 10
37.0%

Length

2023-12-11T01:58:08.781481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:08.937942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
12:00:00 17
63.0%
15:30:00 10
37.0%

요일
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
월~금
27 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row월~금
2nd row월~금
3rd row월~금
4th row월~금
5th row월~금

Common Values

ValueCountFrequency (%)
월~금 27
100.0%

Length

2023-12-11T01:58:09.101209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:09.303831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
월~금 27
100.0%

일수
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size348.0 B
10
18 
20
5 
9
4 

Length

Max length2
Median length2
Mean length1.8518519
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 18
66.7%
20 5
 
18.5%
9 4
 
14.8%

Length

2023-12-11T01:58:09.471853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:09.632844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 18
66.7%
20 5
 
18.5%
9 4
 
14.8%

인원
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
0
27 

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 27
100.0%

Length

2023-12-11T01:58:09.835558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:09.989553image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 27
100.0%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
코로나19로 인해 미실시
27 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row코로나19로 인해 미실시
2nd row코로나19로 인해 미실시
3rd row코로나19로 인해 미실시
4th row코로나19로 인해 미실시
5th row코로나19로 인해 미실시

Common Values

ValueCountFrequency (%)
코로나19로 인해 미실시 27
100.0%

Length

2023-12-11T01:58:10.158772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T01:58:10.340297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
코로나19로 27
33.3%
인해 27
33.3%
미실시 27
33.3%

Interactions

2023-12-11T01:58:05.645731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:58:05.447137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:58:05.740850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T01:58:05.545624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T01:58:10.429301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번월과정명기간(시작일)기간(종료일)시간(시작시간)시간(종료시간))일수
연번1.0000.9330.6230.8910.8750.0000.0000.000
월0.9331.0000.3741.0000.9730.0000.0000.643
과정명0.6230.3741.0000.0000.0000.6350.6350.866
기간(시작일)0.8911.0000.0001.0000.9910.0000.0000.253
기간(종료일)0.8750.9730.0000.9911.0000.0000.0000.253
시간(시작시간)0.0000.0000.6350.0000.0001.0000.9920.401
시간(종료시간))0.0000.0000.6350.0000.0000.9921.0000.401
일수0.0000.6430.8660.2530.2530.4010.4011.000
2023-12-11T01:58:10.570196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간(종료시간))시간(시작시간)일수
시간(종료시간))1.0000.9170.618
시간(시작시간)0.9171.0000.618
일수0.6180.6181.000
2023-12-11T01:58:10.730442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번월시간(시작시간)시간(종료시간))일수
연번1.0000.9940.0000.0000.000
월0.9941.0000.0000.0000.400
시간(시작시간)0.0000.0001.0000.9170.618
시간(종료시간))0.0000.0000.9171.0000.618
일수0.0000.4000.6180.6181.000

Missing values

2023-12-11T01:58:05.880917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T01:58:06.101628image/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

연번월과정명기간(시작일)기간(종료일)시간(시작시간)시간(종료시간))요일일수인원비고
012스마트폰 기초2020-02-032020-02-1410:00:0012:00:00월~금100코로나19로 인해 미실시
122컴퓨터 기초2020-02-172020-02-2810:00:0012:00:00월~금100코로나19로 인해 미실시
232엑셀 2010 기초2020-02-102020-02-2113:30:0015:30:00월~금100코로나19로 인해 미실시
342한글 2010 기초2020-02-242020-03-0613:30:0015:30:00월~금100코로나19로 인해 미실시
453한글 2010 기초2020-03-022020-03-1310:00:0012:00:00월~금100코로나19로 인해 미실시
563파워포인트 기초2020-03-302020-04-1010:00:0012:00:00월~금100코로나19로 인해 미실시
673ITQ 엑셀2020-03-092020-04-0313:30:0015:30:00월~금200코로나19로 인해 미실시
784엑셀 2010 기초2020-04-132020-04-2410:00:0012:00:00월~금90코로나19로 인해 미실시
894코딩 기초2020-04-132020-04-2413:30:0015:30:00월~금90코로나19로 인해 미실시
9105인터넷 기초와 활용2020-05-112020-05-2210:00:0012:00:00월~금100코로나19로 인해 미실시
연번월과정명기간(시작일)기간(종료일)시간(시작시간)시간(종료시간))요일일수인원비고
17187ITQ 파워포인트2020-07-062020-07-3113:30:0015:30:00월~금200코로나19로 인해 미실시
18198컴퓨터 기초2020-08-172020-08-2810:00:0012:00:00월~금100코로나19로 인해 미실시
19208인터넷 기초와 활용2020-08-312020-09-1110:00:0012:00:00월~금100코로나19로 인해 미실시
20218ITQ 엑셀2020-08-312020-09-2513:30:0015:30:00월~금200코로나19로 인해 미실시
21229블로그 만들기2020-09-142020-09-2510:00:0012:00:00월~금100코로나19로 인해 미실시
222310한글 2010 기초2020-10-052020-10-1610:00:0012:00:00월~금90코로나19로 인해 미실시
232410파워포인트 기초2020-10-192020-10-3010:00:0012:00:00월~금100코로나19로 인해 미실시
242510이지포토 기초2020-10-052020-10-1613:30:0015:30:00월~금90코로나19로 인해 미실시
252611엑셀 2010 기초2020-11-022020-11-1310:00:0012:00:00월~금100코로나19로 인해 미실시
262711GTQ 이지포토2020-11-022020-11-1313:30:0015:30:00월~금200코로나19로 인해 미실시