Overview

Dataset statistics

Number of variables6
Number of observations90
Missing cells1
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.4 KiB
Average record size in memory50.5 B

Variable types

Text2
Numeric1
DateTime1
Categorical2

Dataset

Description경기도 구리시 지역내에서 운영중인 시청관할 학습동아리에 관련된 현황정보(동아리명, 활동내역, 인원, 등록일 등)을 제공합니다.
URLhttps://www.data.go.kr/data/3038671/fileData.do

Alerts

관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
인원 has 1 (1.1%) missing valuesMissing
동아리명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:42:05.389011
Analysis finished2023-12-12 00:42:06.512748
Duration1.12 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

동아리명
Text

UNIQUE 

Distinct90
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size852.0 B
2023-12-12T09:42:06.789824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length14
Mean length8.2333333
Min length2

Characters and Unicode

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

Unique

Unique90 ?
Unique (%)100.0%

Sample

1st row미래 환경을 생각하는 모임
2nd row정인춤터
3rd row구리 민속 예술단
4th row예다미합창단
5th row꿈꾸는 세상
ValueCountFrequency (%)
수택3동 2
 
1.4%
구리 2
 
1.4%
사랑하는 2
 
1.4%
세상 2
 
1.4%
사람들 2
 
1.4%
구리시 2
 
1.4%
모임 2
 
1.4%
여인의 1
 
0.7%
동화따먹기 1
 
0.7%
동화나라 1
 
0.7%
Other values (128) 128
88.3%
2023-12-12T09:42:07.395961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
55
 
7.4%
리 34
 
4.6%
동 21
 
2.8%
구 21
 
2.8%
아 15
 
2.0%
회 14
 
1.9%
사 11
 
1.5%
) 11
 
1.5%
이 11
 
1.5%
연 11
 
1.5%
Other values (233) 537
72.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 635
85.7%
Space Separator 55
 
7.4%
Decimal Number 13
 
1.8%
Close Punctuation 11
 
1.5%
Open Punctuation 11
 
1.5%
Lowercase Letter 6
 
0.8%
Uppercase Letter 5
 
0.7%
Other Punctuation 4
 
0.5%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 34
 
5.4%
동 21
 
3.3%
구 21
 
3.3%
아 15
 
2.4%
회 14
 
2.2%
사 11
 
1.7%
이 11
 
1.7%
연 11
 
1.7%
수 10
 
1.6%
단 9
 
1.4%
Other values (210) 478
75.3%
Decimal Number
ValueCountFrequency (%)
2 4
30.8%
4 2
15.4%
0 2
15.4%
1 2
15.4%
3 2
15.4%
9 1
 
7.7%
Lowercase Letter
ValueCountFrequency (%)
i 1
16.7%
n 1
16.7%
o 1
16.7%
r 1
16.7%
u 1
16.7%
g 1
16.7%
Uppercase Letter
ValueCountFrequency (%)
H 2
40.0%
V 1
20.0%
D 1
20.0%
W 1
20.0%
Other Punctuation
ValueCountFrequency (%)
" 2
50.0%
! 1
25.0%
, 1
25.0%
Space Separator
ValueCountFrequency (%)
55
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 635
85.7%
Common 95
 
12.8%
Latin 11
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 34
 
5.4%
동 21
 
3.3%
구 21
 
3.3%
아 15
 
2.4%
회 14
 
2.2%
사 11
 
1.7%
이 11
 
1.7%
연 11
 
1.7%
수 10
 
1.6%
단 9
 
1.4%
Other values (210) 478
75.3%
Common
ValueCountFrequency (%)
55
57.9%
) 11
 
11.6%
( 11
 
11.6%
2 4
 
4.2%
4 2
 
2.1%
0 2
 
2.1%
1 2
 
2.1%
" 2
 
2.1%
3 2
 
2.1%
! 1
 
1.1%
Other values (3) 3
 
3.2%
Latin
ValueCountFrequency (%)
H 2
18.2%
V 1
9.1%
D 1
9.1%
W 1
9.1%
i 1
9.1%
n 1
9.1%
o 1
9.1%
r 1
9.1%
u 1
9.1%
g 1
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 635
85.7%
ASCII 106
 
14.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
55
51.9%
) 11
 
10.4%
( 11
 
10.4%
2 4
 
3.8%
H 2
 
1.9%
4 2
 
1.9%
0 2
 
1.9%
1 2
 
1.9%
" 2
 
1.9%
3 2
 
1.9%
Other values (13) 13
 
12.3%
Hangul
ValueCountFrequency (%)
리 34
 
5.4%
동 21
 
3.3%
구 21
 
3.3%
아 15
 
2.4%
회 14
 
2.2%
사 11
 
1.7%
이 11
 
1.7%
연 11
 
1.7%
수 10
 
1.6%
단 9
 
1.4%
Other values (210) 478
75.3%

활동내용
Text

Distinct65
Distinct (%)72.2%
Missing0
Missing (%)0.0%
Memory size852.0 B
2023-12-12T09:42:07.727114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length5
Mean length3.0666667
Min length1

Characters and Unicode

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

Unique

Unique48 ?
Unique (%)53.3%

Sample

1st row환경
2nd row민요
3rd row풍물
4th row합창
5th row논술
ValueCountFrequency (%)
민요 4
 
4.4%
서예 4
 
4.4%
기타 3
 
3.3%
독서 3
 
3.3%
문학 3
 
3.3%
동화 3
 
3.3%
에니어그램 2
 
2.2%
한국무용 2
 
2.2%
보드게임 2
 
2.2%
댄스 2
 
2.2%
Other values (55) 62
68.9%
2023-12-12T09:42:08.238077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
서 11
 
4.0%
화 9
 
3.3%
기 8
 
2.9%
타 7
 
2.5%
문 7
 
2.5%
이 7
 
2.5%
니 7
 
2.5%
예 5
 
1.8%
국 5
 
1.8%
사 5
 
1.8%
Other values (110) 205
74.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 274
99.3%
Decimal Number 1
 
0.4%
Uppercase Letter 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 11
 
4.0%
화 9
 
3.3%
기 8
 
2.9%
타 7
 
2.6%
문 7
 
2.6%
이 7
 
2.6%
니 7
 
2.6%
예 5
 
1.8%
국 5
 
1.8%
사 5
 
1.8%
Other values (108) 203
74.1%
Decimal Number
ValueCountFrequency (%)
4 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 274
99.3%
Common 1
 
0.4%
Latin 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 11
 
4.0%
화 9
 
3.3%
기 8
 
2.9%
타 7
 
2.6%
문 7
 
2.6%
이 7
 
2.6%
니 7
 
2.6%
예 5
 
1.8%
국 5
 
1.8%
사 5
 
1.8%
Other values (108) 203
74.1%
Common
ValueCountFrequency (%)
4 1
100.0%
Latin
ValueCountFrequency (%)
D 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 274
99.3%
ASCII 2
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
서 11
 
4.0%
화 9
 
3.3%
기 8
 
2.9%
타 7
 
2.6%
문 7
 
2.6%
이 7
 
2.6%
니 7
 
2.6%
예 5
 
1.8%
국 5
 
1.8%
사 5
 
1.8%
Other values (108) 203
74.1%
ASCII
ValueCountFrequency (%)
4 1
50.0%
D 1
50.0%

인원
Real number (ℝ)

MISSING 

Distinct20
Distinct (%)22.5%
Missing1
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean13.348315
Minimum7
Maximum32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size942.0 B
2023-12-12T09:42:08.393510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile7
Q19
median12
Q315
95-th percentile28
Maximum32
Range25
Interquartile range (IQR)6

Descriptive statistics

Standard deviation5.9907146
Coefficient of variation (CV)0.44879933
Kurtosis1.7543462
Mean13.348315
Median Absolute Deviation (MAD)3
Skewness1.4191667
Sum1188
Variance35.888662
MonotonicityNot monotonic
2023-12-12T09:42:08.566740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
10 15
16.7%
7 11
12.2%
8 8
8.9%
15 8
8.9%
12 8
8.9%
13 6
 
6.7%
16 5
 
5.6%
14 4
 
4.4%
9 4
 
4.4%
30 4
 
4.4%
Other values (10) 16
17.8%
ValueCountFrequency (%)
7 11
12.2%
8 8
8.9%
9 4
 
4.4%
10 15
16.7%
11 3
 
3.3%
12 8
8.9%
13 6
 
6.7%
14 4
 
4.4%
15 8
8.9%
16 5
 
5.6%
ValueCountFrequency (%)
32 1
 
1.1%
30 4
4.4%
25 1
 
1.1%
23 3
3.3%
22 1
 
1.1%
21 1
 
1.1%
20 1
 
1.1%
19 1
 
1.1%
18 2
2.2%
17 2
2.2%

등록일
Date

Distinct83
Distinct (%)92.2%
Missing0
Missing (%)0.0%
Memory size852.0 B
Minimum2007-03-08 00:00:00
Maximum2022-03-13 00:00:00
2023-12-12T09:42:08.745237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:42:08.941281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size852.0 B
경기도 구리시청
90 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 구리시청
2nd row경기도 구리시청
3rd row경기도 구리시청
4th row경기도 구리시청
5th row경기도 구리시청

Common Values

ValueCountFrequency (%)
경기도 구리시청 90
100.0%

Length

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

Common Values (Plot)

2023-12-12T09:42:09.179284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 90
50.0%
구리시청 90
50.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size852.0 B
2023-06-05
90 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-05
2nd row2023-06-05
3rd row2023-06-05
4th row2023-06-05
5th row2023-06-05

Common Values

ValueCountFrequency (%)
2023-06-05 90
100.0%

Length

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

Common Values (Plot)

2023-12-12T09:42:09.451840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-05 90
100.0%

Interactions

2023-12-12T09:42:05.804534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:42:09.515373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동아리명활동내용인원등록일
동아리명1.0001.0001.0001.000
활동내용1.0001.0000.0000.254
인원1.0000.0001.0000.941
등록일1.0000.2540.9411.000

Missing values

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

동아리명활동내용인원등록일관리기관명데이터기준일자
0미래 환경을 생각하는 모임환경162007-03-08경기도 구리시청2023-06-05
1정인춤터민요102007-04-01경기도 구리시청2023-06-05
2구리 민속 예술단풍물232007-04-27경기도 구리시청2023-06-05
3예다미합창단합창182007-07-06경기도 구리시청2023-06-05
4꿈꾸는 세상논술152007-07-06경기도 구리시청2023-06-05
5고려수지침 구리지회수지침302007-10-22경기도 구리시청2023-06-05
6구아바에니어그램에니어그램162007-11-23경기도 구리시청2023-06-05
7전래놀이연구회검정고무신전래놀이152008-01-22경기도 구리시청2023-06-05
8구리아마레플룻앙상블음악132008-06-01경기도 구리시청2023-06-05
9동도묵연회서예152009-05-27경기도 구리시청2023-06-05
동아리명활동내용인원등록일관리기관명데이터기준일자
80극단 아홉마을연극102020-03-16경기도 구리시청2023-06-05
81멜로스 주니어기타82020-06-23경기도 구리시청2023-06-05
82구리메이커스메이커스72020-07-28경기도 구리시청2023-06-05
83구리예절연구회전래놀이122021-04-08경기도 구리시청2023-06-05
84갈매동 엄마 인문학인문학92021-04-27경기도 구리시청2023-06-05
85융합메이커연구회코딩메이터162021-05-13경기도 구리시청2023-06-05
86헤어 동아리미용152022-02-21경기도 구리시청2023-06-05
87한강수야!국악122022-02-21경기도 구리시청2023-06-05
88구리아리랑아리랑102022-02-21경기도 구리시청2023-06-05
89비채(비움과 채움)댄스192022-03-13경기도 구리시청2023-06-05