Overview

Dataset statistics

Number of variables6
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory52.1 B

Variable types

Numeric1
Text3
DateTime1
Categorical1

Dataset

Description대전광역시청사 견학 현황 데이터
Author대전광역시
URLhttps://www.data.go.kr/data/15077253/fileData.do

Alerts

연번 is highly overall correlated with 비고High correlation
비고 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:54:35.015937
Analysis finished2023-12-12 08:54:35.734626
Duration0.72 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.5
Minimum1
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2023-12-12T17:54:35.839036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.05
Q111.25
median21.5
Q331.75
95-th percentile39.95
Maximum42
Range41
Interquartile range (IQR)20.5

Descriptive statistics

Standard deviation12.267844
Coefficient of variation (CV)0.5705974
Kurtosis-1.2
Mean21.5
Median Absolute Deviation (MAD)10.5
Skewness0
Sum903
Variance150.5
MonotonicityStrictly increasing
2023-12-12T17:54:36.039301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
1 1
 
2.4%
33 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
32 1
 
2.4%
Other values (32) 32
76.2%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
42 1
2.4%
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%

단체명
Text

Distinct33
Distinct (%)78.6%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T17:54:36.332908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length14
Mean length8.3095238
Min length4

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)66.7%

Sample

1st row광주광역시 청사관리팀
2nd row충주시 청사관리팀
3rd row광주광역시 청사관리담당
4th row대전대성고등학교
5th row대전용전중학교
ValueCountFrequency (%)
대전중리초등학교 6
 
10.7%
대전문정초등학교 2
 
3.6%
대전유천초등학교 2
 
3.6%
대전용전중학교 2
 
3.6%
천사유치원 2
 
3.6%
청사관리팀 2
 
3.6%
청사관리담당 2
 
3.6%
광주광역시 2
 
3.6%
대전봉우중학교 1
 
1.8%
대전목상초등학교 1
 
1.8%
Other values (34) 34
60.7%
2023-12-12T17:54:36.805430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
학 33
 
9.5%
교 32
 
9.2%
대 30
 
8.6%
전 26
 
7.4%
중 18
 
5.2%
초 15
 
4.3%
등 15
 
4.3%
14
 
4.0%
리 11
 
3.2%
사 9
 
2.6%
Other values (86) 146
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 335
96.0%
Space Separator 14
 
4.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
학 33
 
9.9%
교 32
 
9.6%
대 30
 
9.0%
전 26
 
7.8%
중 18
 
5.4%
초 15
 
4.5%
등 15
 
4.5%
리 11
 
3.3%
사 9
 
2.7%
원 7
 
2.1%
Other values (85) 139
41.5%
Space Separator
ValueCountFrequency (%)
14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 335
96.0%
Common 14
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
학 33
 
9.9%
교 32
 
9.6%
대 30
 
9.0%
전 26
 
7.8%
중 18
 
5.4%
초 15
 
4.5%
등 15
 
4.5%
리 11
 
3.3%
사 9
 
2.7%
원 7
 
2.1%
Other values (85) 139
41.5%
Common
ValueCountFrequency (%)
14
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 335
96.0%
ASCII 14
 
4.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
학 33
 
9.9%
교 32
 
9.6%
대 30
 
9.0%
전 26
 
7.8%
중 18
 
5.4%
초 15
 
4.5%
등 15
 
4.5%
리 11
 
3.3%
사 9
 
2.7%
원 7
 
2.1%
Other values (85) 139
41.5%
ASCII
ValueCountFrequency (%)
14
100.0%

견학날짜
Date

Distinct41
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size468.0 B
Minimum2015-01-07 00:00:00
Maximum2020-09-24 00:00:00
2023-12-12T17:54:36.950209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:54:37.111576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)

견학시간
Text

Distinct26
Distinct (%)61.9%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T17:54:37.351367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length11
Mean length10.333333
Min length1

Characters and Unicode

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

Unique

Unique15 ?
Unique (%)35.7%

Sample

1st row13:00
2nd row13:00
3rd row10:00
4th row09:30~10:30
5th row10:40~11:40
ValueCountFrequency (%)
09:00~10:00 5
 
11.9%
14:30~15:30 4
 
9.5%
16:30~17:30 2
 
4.8%
13:00 2
 
4.8%
14:40~15:40 2
 
4.8%
13:30~14:30 2
 
4.8%
09:30~10:30 2
 
4.8%
14:00~15:00 2
 
4.8%
14:00~15:30 2
 
4.8%
10:00~11:30 2
 
4.8%
Other values (16) 17
40.5%
2023-12-12T17:54:37.709893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 137
31.6%
1 81
18.7%
: 79
18.2%
3 39
 
9.0%
~ 38
 
8.8%
4 21
 
4.8%
5 18
 
4.1%
9 8
 
1.8%
6 6
 
1.4%
2 3
 
0.7%
Other values (2) 4
 
0.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 316
72.8%
Other Punctuation 79
 
18.2%
Math Symbol 38
 
8.8%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 137
43.4%
1 81
25.6%
3 39
 
12.3%
4 21
 
6.6%
5 18
 
5.7%
9 8
 
2.5%
6 6
 
1.9%
2 3
 
0.9%
7 3
 
0.9%
Other Punctuation
ValueCountFrequency (%)
: 79
100.0%
Math Symbol
ValueCountFrequency (%)
~ 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 434
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 137
31.6%
1 81
18.7%
: 79
18.2%
3 39
 
9.0%
~ 38
 
8.8%
4 21
 
4.8%
5 18
 
4.1%
9 8
 
1.8%
6 6
 
1.4%
2 3
 
0.7%
Other values (2) 4
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 434
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 137
31.6%
1 81
18.7%
: 79
18.2%
3 39
 
9.0%
~ 38
 
8.8%
4 21
 
4.8%
5 18
 
4.1%
9 8
 
1.8%
6 6
 
1.4%
2 3
 
0.7%
Other values (2) 4
 
0.9%

견학인원
Text

Distinct27
Distinct (%)64.3%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-12T17:54:37.921247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.9047619
Min length2

Characters and Unicode

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

Unique

Unique19 ?
Unique (%)45.2%

Sample

1st row4명
2nd row4명
3rd row3명
4th row20명
5th row13명
ValueCountFrequency (%)
20명 4
 
9.5%
15명 4
 
9.5%
26명 4
 
9.5%
4명 3
 
7.1%
33명 2
 
4.8%
16명 2
 
4.8%
11명 2
 
4.8%
25명 2
 
4.8%
39명 1
 
2.4%
23명 1
 
2.4%
Other values (17) 17
40.5%
2023-12-12T17:54:38.286108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
명 42
34.4%
1 18
14.8%
2 17
13.9%
3 10
 
8.2%
6 8
 
6.6%
5 8
 
6.6%
0 6
 
4.9%
4 5
 
4.1%
7 4
 
3.3%
9 2
 
1.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 80
65.6%
Other Letter 42
34.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 18
22.5%
2 17
21.2%
3 10
12.5%
6 8
10.0%
5 8
10.0%
0 6
 
7.5%
4 5
 
6.2%
7 4
 
5.0%
9 2
 
2.5%
8 2
 
2.5%
Other Letter
ValueCountFrequency (%)
명 42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 80
65.6%
Hangul 42
34.4%

Most frequent character per script

Common
ValueCountFrequency (%)
1 18
22.5%
2 17
21.2%
3 10
12.5%
6 8
10.0%
5 8
10.0%
0 6
 
7.5%
4 5
 
6.2%
7 4
 
5.0%
9 2
 
2.5%
8 2
 
2.5%
Hangul
ValueCountFrequency (%)
명 42
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 80
65.6%
Hangul 42
34.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
명 42
100.0%
ASCII
ValueCountFrequency (%)
1 18
22.5%
2 17
21.2%
3 10
12.5%
6 8
10.0%
5 8
10.0%
0 6
 
7.5%
4 5
 
6.2%
7 4
 
5.0%
9 2
 
2.5%
8 2
 
2.5%

비고
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size468.0 B
시티홀 그린투어
25 
<NA>
17 

Length

Max length8
Median length8
Mean length6.3809524
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row시티홀 그린투어
5th row시티홀 그린투어

Common Values

ValueCountFrequency (%)
시티홀 그린투어 25
59.5%
<NA> 17
40.5%

Length

2023-12-12T17:54:38.464190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:54:38.576776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시티홀 25
37.3%
그린투어 25
37.3%
na 17
25.4%

Interactions

2023-12-12T17:54:35.375039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:54:38.649003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단체명견학날짜견학시간견학인원
연번1.0000.8801.0000.8030.619
단체명0.8801.0000.9670.9250.723
견학날짜1.0000.9671.0001.0000.980
견학시간0.8030.9251.0001.0000.933
견학인원0.6190.7230.9800.9331.000
2023-12-12T17:54:38.762304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번비고
연번1.0001.000
비고1.0001.000

Missing values

2023-12-12T17:54:35.514478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:54:35.668296image/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

연번단체명견학날짜견학시간견학인원비고
01광주광역시 청사관리팀2020-09-2413:004명<NA>
12충주시 청사관리팀2019-06-1113:004명<NA>
23광주광역시 청사관리담당2019-03-0610:003명<NA>
34대전대성고등학교2018-10-2309:30~10:3020명시티홀 그린투어
45대전용전중학교2017-10-2010:40~11:4013명시티홀 그린투어
56천사유치원2017-10-1110:30~11:3069명시티홀 그린투어
67대전구봉중학교2017-09-1513:30~14:3015명시티홀 그린투어
78대전월평초등학교2017-09-1410:30~12:0033명시티홀 그린투어
89대전중리초등학교2017-06-2810:30~12:30117명시티홀 그린투어
910대전어은중학교2017-06-1615:50~16:5016명시티홀 그린투어
연번단체명견학날짜견학시간견학인원비고
3233한밭초등학교2015-11-0614:40~15:4020명시티홀 그린투어
3334대전동산중학교2015-10-0214:40~15:4026명시티홀 그린투어
3435대전봉우중학교2015-09-2514:00~15:0016명시티홀 그린투어
3536구봉초등학교2015-09-1814:30~15:3012명시티홀 그린투어
3637대전삼육중학교2015-09-1814:30~15:3015명시티홀 그린투어
3738대전변동중학교2015-09-1114:30~15:3020명시티홀 그린투어
3839대전목상초등학교2015-04-3010:00~11:3056명<NA>
3940레바논 현지인 방한 연수단2015-04-1309:30~10:3011명<NA>
4041세종특별자치시 청사관리담당2015-02-1315:00~17:004명<NA>
4142합동군사대학교2015-01-0714:00~14:50120명<NA>