Overview

Dataset statistics

Number of variables7
Number of observations114
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.6 KiB
Average record size in memory59.2 B

Variable types

Numeric2
Text2
Categorical2
DateTime1

Dataset

Description충청남도 공주시 평생학습동아리에 대한 정보입니다. 동아리명, 설립일, 회원수, 모임주기, 분야 등 내용을 포함하고 있습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=311&beforeMenuCd=DOM_000000201001001000&publicdatapk=15093500

Alerts

데이터기준일자 has constant value ""Constant
순번 has unique valuesUnique

Reproduction

Analysis started2024-01-09 21:11:16.724839
Analysis finished2024-01-09 21:11:17.463175
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct114
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean57.5
Minimum1
Maximum114
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-01-10T06:11:17.532994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6.65
Q129.25
median57.5
Q385.75
95-th percentile108.35
Maximum114
Range113
Interquartile range (IQR)56.5

Descriptive statistics

Standard deviation33.052988
Coefficient of variation (CV)0.57483457
Kurtosis-1.2
Mean57.5
Median Absolute Deviation (MAD)28.5
Skewness0
Sum6555
Variance1092.5
MonotonicityStrictly increasing
2024-01-10T06:11:17.664382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.9%
87 1
 
0.9%
85 1
 
0.9%
84 1
 
0.9%
83 1
 
0.9%
82 1
 
0.9%
81 1
 
0.9%
80 1
 
0.9%
79 1
 
0.9%
78 1
 
0.9%
Other values (104) 104
91.2%
ValueCountFrequency (%)
1 1
0.9%
2 1
0.9%
3 1
0.9%
4 1
0.9%
5 1
0.9%
6 1
0.9%
7 1
0.9%
8 1
0.9%
9 1
0.9%
10 1
0.9%
ValueCountFrequency (%)
114 1
0.9%
113 1
0.9%
112 1
0.9%
111 1
0.9%
110 1
0.9%
109 1
0.9%
108 1
0.9%
107 1
0.9%
106 1
0.9%
105 1
0.9%

동아리명
Text

Distinct113
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-01-10T06:11:17.914058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length14
Mean length8.4210526
Min length2

Characters and Unicode

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

Unique

Unique112 ?
Unique (%)98.2%

Sample

1st row가야락 (공주 가야금 동아리)
2nd row갈묵회
3rd row건강 걷기
4th row고마나루 창극단
5th row고마나루서각회
ValueCountFrequency (%)
동아리 8
 
3.8%
공주 7
 
3.3%
사람들 3
 
1.4%
전통 2
 
0.9%
밤톨 2
 
0.9%
연구 2
 
0.9%
학습동아리 2
 
0.9%
학습 2
 
0.9%
공주시 2
 
0.9%
커피 2
 
0.9%
Other values (175) 181
85.0%
2024-01-10T06:11:18.320658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
99
 
10.3%
공 29
 
3.0%
리 28
 
2.9%
주 25
 
2.6%
아 23
 
2.4%
회 20
 
2.1%
사 19
 
2.0%
동 19
 
2.0%
연 14
 
1.5%
이 13
 
1.4%
Other values (253) 671
69.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 837
87.2%
Space Separator 99
 
10.3%
Close Punctuation 9
 
0.9%
Open Punctuation 9
 
0.9%
Other Punctuation 5
 
0.5%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
공 29
 
3.5%
리 28
 
3.3%
주 25
 
3.0%
아 23
 
2.7%
회 20
 
2.4%
사 19
 
2.3%
동 19
 
2.3%
연 14
 
1.7%
이 13
 
1.6%
전 11
 
1.3%
Other values (245) 636
76.0%
Other Punctuation
ValueCountFrequency (%)
, 2
40.0%
? 1
20.0%
! 1
20.0%
& 1
20.0%
Space Separator
ValueCountFrequency (%)
99
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 837
87.2%
Common 122
 
12.7%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
공 29
 
3.5%
리 28
 
3.3%
주 25
 
3.0%
아 23
 
2.7%
회 20
 
2.4%
사 19
 
2.3%
동 19
 
2.3%
연 14
 
1.7%
이 13
 
1.6%
전 11
 
1.3%
Other values (245) 636
76.0%
Common
ValueCountFrequency (%)
99
81.1%
) 9
 
7.4%
( 9
 
7.4%
, 2
 
1.6%
? 1
 
0.8%
! 1
 
0.8%
& 1
 
0.8%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 837
87.2%
ASCII 123
 
12.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
99
80.5%
) 9
 
7.3%
( 9
 
7.3%
, 2
 
1.6%
? 1
 
0.8%
! 1
 
0.8%
A 1
 
0.8%
& 1
 
0.8%
Hangul
ValueCountFrequency (%)
공 29
 
3.5%
리 28
 
3.3%
주 25
 
3.0%
아 23
 
2.7%
회 20
 
2.4%
사 19
 
2.3%
동 19
 
2.3%
연 14
 
1.7%
이 13
 
1.6%
전 11
 
1.3%
Other values (245) 636
76.0%

설립일
Text

Distinct104
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
2024-01-10T06:11:18.568203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.8333333
Min length4

Characters and Unicode

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

Unique

Unique97 ?
Unique (%)85.1%

Sample

1st row2018-05-01
2nd row2005-11-20
3rd row2020-03-23
4th row2019-12-03
5th row2016-03-01
ValueCountFrequency (%)
2021-03-01 4
 
3.5%
2021-09-02 3
 
2.6%
2018-05-01 2
 
1.8%
2015-03-02 2
 
1.8%
2018-10-20 2
 
1.8%
2019-01-02 2
 
1.8%
2016-03-01 2
 
1.8%
2015-05-10 1
 
0.9%
2016-05-07 1
 
0.9%
2019-08-23 1
 
0.9%
Other values (94) 94
82.5%
2024-01-10T06:11:18.952990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 284
25.3%
- 223
19.9%
1 217
19.4%
2 197
17.6%
8 37
 
3.3%
3 36
 
3.2%
9 36
 
3.2%
5 23
 
2.1%
6 22
 
2.0%
7 21
 
1.9%
Other values (6) 25
 
2.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 892
79.6%
Dash Punctuation 223
 
19.9%
Lowercase Letter 4
 
0.4%
Uppercase Letter 2
 
0.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 284
31.8%
1 217
24.3%
2 197
22.1%
8 37
 
4.1%
3 36
 
4.0%
9 36
 
4.0%
5 23
 
2.6%
6 22
 
2.5%
7 21
 
2.4%
4 19
 
2.1%
Lowercase Letter
ValueCountFrequency (%)
u 2
50.0%
g 1
25.0%
n 1
25.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
50.0%
J 1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 223
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1115
99.5%
Latin 6
 
0.5%

Most frequent character per script

Common
ValueCountFrequency (%)
0 284
25.5%
- 223
20.0%
1 217
19.5%
2 197
17.7%
8 37
 
3.3%
3 36
 
3.2%
9 36
 
3.2%
5 23
 
2.1%
6 22
 
2.0%
7 21
 
1.9%
Latin
ValueCountFrequency (%)
u 2
33.3%
A 1
16.7%
g 1
16.7%
J 1
16.7%
n 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1121
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 284
25.3%
- 223
19.9%
1 217
19.4%
2 197
17.6%
8 37
 
3.3%
3 36
 
3.2%
9 36
 
3.2%
5 23
 
2.1%
6 22
 
2.0%
7 21
 
1.9%
Other values (6) 25
 
2.2%

회원수
Real number (ℝ)

Distinct20
Distinct (%)17.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.868421
Minimum6
Maximum48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2024-01-10T06:11:19.076799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6
5-th percentile8
Q19
median11
Q315
95-th percentile23.05
Maximum48
Range42
Interquartile range (IQR)6

Descriptive statistics

Standard deviation6.2549282
Coefficient of variation (CV)0.48606804
Kurtosis11.111196
Mean12.868421
Median Absolute Deviation (MAD)3
Skewness2.7869641
Sum1467
Variance39.124127
MonotonicityNot monotonic
2024-01-10T06:11:19.180490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
8 18
15.8%
10 15
13.2%
9 12
10.5%
11 12
10.5%
12 9
7.9%
15 9
7.9%
13 6
 
5.3%
17 5
 
4.4%
20 5
 
4.4%
14 4
 
3.5%
Other values (10) 19
16.7%
ValueCountFrequency (%)
6 3
 
2.6%
7 2
 
1.8%
8 18
15.8%
9 12
10.5%
10 15
13.2%
11 12
10.5%
12 9
7.9%
13 6
 
5.3%
14 4
 
3.5%
15 9
7.9%
ValueCountFrequency (%)
48 1
 
0.9%
40 1
 
0.9%
32 1
 
0.9%
26 2
 
1.8%
25 1
 
0.9%
22 1
 
0.9%
20 5
4.4%
18 4
3.5%
17 5
4.4%
16 3
2.6%

모임주기
Categorical

Distinct36
Distinct (%)31.6%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
매주 1회
20 
매월 2회
14 
매주1회
13 
매주 2회
11 
매월 1회
11 
Other values (31)
45 

Length

Max length35
Median length5
Mean length5.8684211
Min length3

Unique

Unique24 ?
Unique (%)21.1%

Sample

1st row매주 1회
2nd row매주1회, 매월4회
3rd row매월4회
4th row매주1회
5th row매주2회

Common Values

ValueCountFrequency (%)
매주 1회 20
17.5%
매월 2회 14
12.3%
매주1회 13
11.4%
매주 2회 11
 
9.6%
매월 1회 11
 
9.6%
매월1회 7
 
6.1%
매주2회 3
 
2.6%
매월2회 3
 
2.6%
월1회 2
 
1.8%
매월 4회 2
 
1.8%
Other values (26) 28
24.6%

Length

2024-01-10T06:11:19.305609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
매주 40
18.0%
1회 37
16.7%
매월 33
14.9%
2회 26
11.7%
매주1회 14
 
6.3%
매월1회 7
 
3.2%
4회 4
 
1.8%
주 4
 
1.8%
화 3
 
1.4%
목요일 3
 
1.4%
Other values (37) 51
23.0%

구분
Categorical

Distinct10
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
문화/예술
69 
인문/교양
15 
교육
9 
건강/생활체육
7 
기타
 
4
Other values (5)
10 

Length

Max length7
Median length5
Mean length4.7982456
Min length2

Unique

Unique2 ?
Unique (%)1.8%

Sample

1st row문화/예술
2nd row문화/예술
3rd row건강/생활체육
4th row문화/예술
5th row문화/예술

Common Values

ValueCountFrequency (%)
문화/예술 69
60.5%
인문/교양 15
 
13.2%
교육 9
 
7.9%
건강/생활체육 7
 
6.1%
기타 4
 
3.5%
IT/정보화 3
 
2.6%
시민참여 3
 
2.6%
언어/외국어 2
 
1.8%
취업/자격증 1
 
0.9%
문해교육 1
 
0.9%

Length

2024-01-10T06:11:19.434374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:11:19.544062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화/예술 69
60.5%
인문/교양 15
 
13.2%
교육 9
 
7.9%
건강/생활체육 7
 
6.1%
기타 4
 
3.5%
it/정보화 3
 
2.6%
시민참여 3
 
2.6%
언어/외국어 2
 
1.8%
취업/자격증 1
 
0.9%
문해교육 1
 
0.9%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1.0 KiB
Minimum2022-11-16 00:00:00
Maximum2022-11-16 00:00:00
2024-01-10T06:11:19.649308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:11:19.746044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T06:11:17.150887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:11:17.009676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:11:17.225722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:11:17.081362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T06:11:20.093471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수모임주기구분
순번1.0000.0700.2240.000
회원수0.0701.0000.8140.000
모임주기0.2240.8141.0000.000
구분0.0000.0000.0001.000
2024-01-10T06:11:20.172071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
모임주기구분
모임주기1.0000.000
구분0.0001.000
2024-01-10T06:11:20.253487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수모임주기구분
순번1.000-0.1540.0420.000
회원수-0.1541.0000.4160.000
모임주기0.0420.4161.0000.000
구분0.0000.0000.0001.000

Missing values

2024-01-10T06:11:17.323585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:11:17.424376image/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가야락 (공주 가야금 동아리)2018-05-018매주 1회문화/예술2022-11-16
12갈묵회2005-11-2013매주1회, 매월4회문화/예술2022-11-16
23건강 걷기2020-03-2320매월4회건강/생활체육2022-11-16
34고마나루 창극단2019-12-038매주1회문화/예술2022-11-16
45고마나루서각회2016-03-0117매주2회문화/예술2022-11-16
56고마무지개2021-09-028매월 2,4째주 목요일 14:00시교육2022-11-16
67고마보드2020-11-048매월 1회교육2022-11-16
78고마캘리2018-11-2316매월 2회문화/예술2022-11-16
89고마풍선아트연구회2019-02-2813격월 1회문화/예술2022-11-16
910공공사 (공주에서 공부하는 사람들)2021-09-029매주 1회취업/자격증2022-11-16
순번동아리명설립일회원수모임주기구분데이터기준일자
104105피치공주(피아노 치는 공주 사람)2019-03-269매주 2-3회문화/예술2022-11-16
105106한국전통놀이연구보급회2011-07-1820매월1회문화/예술2022-11-16
106107한글사랑 서예동아리2016-03-0210매주1회인문/교양2022-11-16
107108해피드림2019-12-2615매월 (첫째 주, 셋째 주) 목요일교육2022-11-16
108109행복더하기2016-11-298매월1회시민참여2022-11-16
109110화목한 소리2008-04-2818매주 2회문화/예술2022-11-16
110111휘트니스 요가 댄스2018-10-208매월 1회건강/생활체육2022-11-16
111112흙을 사랑하는 사람들2019-11-2517매월 2회문화/예술2022-11-16
112113흥해라 공예2020-01-168매월 2회문화/예술2022-11-16
113114희희낙낙예술놀이터201110<NA>문화/예술2022-11-16