Overview

Dataset statistics

Number of variables8
Number of observations172
Missing cells174
Missing cells (%)12.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.4 KiB
Average record size in memory67.8 B

Variable types

Numeric2
Text2
Categorical2
DateTime1
Unsupported1

Dataset

Description보령시의 자원봉사 단체 및 인원 현황(단체명, 단체대표, 회원수, 상태, 단체구분, 등록일자)을 제공하는 파일 데이터 입니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=389&beforeMenuCd=DOM_000000201001001000&publicdatapk=3078590

Alerts

상태 has constant value ""Constant
순번 is highly overall correlated with 단체구분High correlation
단체구분 is highly overall correlated with 순번High correlation
단체대표 has 2 (1.2%) missing valuesMissing
비고 has 172 (100.0%) missing valuesMissing
순번 has unique valuesUnique
단체명 has unique valuesUnique
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 20:22:04.184105
Analysis finished2024-01-09 20:22:04.868121
Duration0.68 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct172
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean86.5
Minimum1
Maximum172
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-01-10T05:22:04.925094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.55
Q143.75
median86.5
Q3129.25
95-th percentile163.45
Maximum172
Range171
Interquartile range (IQR)85.5

Descriptive statistics

Standard deviation49.796252
Coefficient of variation (CV)0.57567921
Kurtosis-1.2
Mean86.5
Median Absolute Deviation (MAD)43
Skewness0
Sum14878
Variance2479.6667
MonotonicityStrictly increasing
2024-01-10T05:22:05.035508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
120 1
 
0.6%
112 1
 
0.6%
113 1
 
0.6%
114 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
117 1
 
0.6%
118 1
 
0.6%
119 1
 
0.6%
Other values (162) 162
94.2%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
172 1
0.6%
171 1
0.6%
170 1
0.6%
169 1
0.6%
168 1
0.6%
167 1
0.6%
166 1
0.6%
165 1
0.6%
164 1
0.6%
163 1
0.6%

단체명
Text

UNIQUE 

Distinct172
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2024-01-10T05:22:05.208850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length16
Mean length9.8662791
Min length3

Characters and Unicode

Total characters1697
Distinct characters264
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

Unique172 ?
Unique (%)100.0%

Sample

1st row성주면새마을부녀회
2nd row무궁화봉사단
3rd row프로보노
4th row보배유
5th row무창포한마음봉사단
ValueCountFrequency (%)
대한노인회 9
 
3.8%
봉사단 5
 
2.1%
봉사클럽 3
 
1.3%
보령시 3
 
1.3%
보령시지부 3
 
1.3%
이동빨래봉사단 2
 
0.8%
보령 2
 
0.8%
청소면 2
 
0.8%
만세보령 2
 
0.8%
부녀회 2
 
0.8%
Other values (201) 203
86.0%
2024-01-10T05:22:05.538322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
회 83
 
4.9%
사 79
 
4.7%
보 70
 
4.1%
령 66
 
3.9%
대 65
 
3.8%
64
 
3.8%
자 47
 
2.8%
봉 46
 
2.7%
시 41
 
2.4%
한 37
 
2.2%
Other values (254) 1099
64.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1564
92.2%
Space Separator 64
 
3.8%
Decimal Number 26
 
1.5%
Close Punctuation 22
 
1.3%
Open Punctuation 11
 
0.6%
Uppercase Letter 10
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
회 83
 
5.3%
사 79
 
5.1%
보 70
 
4.5%
령 66
 
4.2%
대 65
 
4.2%
자 47
 
3.0%
봉 46
 
2.9%
시 41
 
2.6%
한 37
 
2.4%
지 37
 
2.4%
Other values (236) 993
63.5%
Decimal Number
ValueCountFrequency (%)
1 6
23.1%
2 6
23.1%
0 5
19.2%
3 3
11.5%
5 3
11.5%
8 1
 
3.8%
7 1
 
3.8%
6 1
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
P 2
20.0%
S 2
20.0%
Y 2
20.0%
M 1
10.0%
G 1
10.0%
K 1
10.0%
B 1
10.0%
Space Separator
ValueCountFrequency (%)
64
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1564
92.2%
Common 123
 
7.2%
Latin 10
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
회 83
 
5.3%
사 79
 
5.1%
보 70
 
4.5%
령 66
 
4.2%
대 65
 
4.2%
자 47
 
3.0%
봉 46
 
2.9%
시 41
 
2.6%
한 37
 
2.4%
지 37
 
2.4%
Other values (236) 993
63.5%
Common
ValueCountFrequency (%)
64
52.0%
) 22
 
17.9%
( 11
 
8.9%
1 6
 
4.9%
2 6
 
4.9%
0 5
 
4.1%
3 3
 
2.4%
5 3
 
2.4%
8 1
 
0.8%
7 1
 
0.8%
Latin
ValueCountFrequency (%)
P 2
20.0%
S 2
20.0%
Y 2
20.0%
M 1
10.0%
G 1
10.0%
K 1
10.0%
B 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1564
92.2%
ASCII 133
 
7.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
회 83
 
5.3%
사 79
 
5.1%
보 70
 
4.5%
령 66
 
4.2%
대 65
 
4.2%
자 47
 
3.0%
봉 46
 
2.9%
시 41
 
2.6%
한 37
 
2.4%
지 37
 
2.4%
Other values (236) 993
63.5%
ASCII
ValueCountFrequency (%)
64
48.1%
) 22
 
16.5%
( 11
 
8.3%
1 6
 
4.5%
2 6
 
4.5%
0 5
 
3.8%
3 3
 
2.3%
5 3
 
2.3%
P 2
 
1.5%
S 2
 
1.5%
Other values (8) 9
 
6.8%

단체대표
Text

MISSING 

Distinct159
Distinct (%)93.5%
Missing2
Missing (%)1.2%
Memory size1.5 KiB
2024-01-10T05:22:05.830069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

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

Unique

Unique148 ?
Unique (%)87.1%

Sample

1st row이명숙
2nd row이근식
3rd row김건호
4th row김현우
5th row조순호
ValueCountFrequency (%)
김규열 2
 
1.2%
이종훈 2
 
1.2%
오치인 2
 
1.2%
전말숙 2
 
1.2%
김연주 2
 
1.2%
전윤수 2
 
1.2%
이순자 2
 
1.2%
이선우 2
 
1.2%
고명희 2
 
1.2%
임위열 2
 
1.2%
Other values (149) 150
88.2%
2024-01-10T05:22:06.224133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 38
 
7.5%
김 37
 
7.3%
영 14
 
2.7%
희 13
 
2.5%
정 13
 
2.5%
경 12
 
2.4%
숙 12
 
2.4%
미 11
 
2.2%
박 10
 
2.0%
수 10
 
2.0%
Other values (109) 340
66.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 510
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 38
 
7.5%
김 37
 
7.3%
영 14
 
2.7%
희 13
 
2.5%
정 13
 
2.5%
경 12
 
2.4%
숙 12
 
2.4%
미 11
 
2.2%
박 10
 
2.0%
수 10
 
2.0%
Other values (109) 340
66.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 510
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 38
 
7.5%
김 37
 
7.3%
영 14
 
2.7%
희 13
 
2.5%
정 13
 
2.5%
경 12
 
2.4%
숙 12
 
2.4%
미 11
 
2.2%
박 10
 
2.0%
수 10
 
2.0%
Other values (109) 340
66.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 510
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 38
 
7.5%
김 37
 
7.3%
영 14
 
2.7%
희 13
 
2.5%
정 13
 
2.5%
경 12
 
2.4%
숙 12
 
2.4%
미 11
 
2.2%
박 10
 
2.0%
수 10
 
2.0%
Other values (109) 340
66.7%

회원수
Real number (ℝ)

Distinct66
Distinct (%)38.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean64.883721
Minimum1
Maximum2876
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2024-01-10T05:22:06.346119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6
Q114
median21
Q338
95-th percentile123.2
Maximum2876
Range2875
Interquartile range (IQR)24

Descriptive statistics

Standard deviation248.22137
Coefficient of variation (CV)3.8256339
Kurtosis99.936613
Mean64.883721
Median Absolute Deviation (MAD)10
Skewness9.3855086
Sum11160
Variance61613.846
MonotonicityNot monotonic
2024-01-10T05:22:06.478301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20 16
 
9.3%
12 8
 
4.7%
24 6
 
3.5%
6 6
 
3.5%
11 6
 
3.5%
15 6
 
3.5%
7 5
 
2.9%
16 5
 
2.9%
19 5
 
2.9%
27 5
 
2.9%
Other values (56) 104
60.5%
ValueCountFrequency (%)
1 1
 
0.6%
2 2
 
1.2%
4 2
 
1.2%
6 6
3.5%
7 5
2.9%
8 4
2.3%
9 2
 
1.2%
10 4
2.3%
11 6
3.5%
12 8
4.7%
ValueCountFrequency (%)
2876 1
0.6%
1237 1
0.6%
570 1
0.6%
564 1
0.6%
530 1
0.6%
517 1
0.6%
196 1
0.6%
146 1
0.6%
132 1
0.6%
116 1
0.6%

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
활동
172 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row활동
2nd row활동
3rd row활동
4th row활동
5th row활동

Common Values

ValueCountFrequency (%)
활동 172
100.0%

Length

2024-01-10T05:22:06.610783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:22:06.703691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
활동 172
100.0%

단체구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
나눔단체
151 
법인
21 

Length

Max length4
Median length4
Mean length3.755814
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row나눔단체
2nd row나눔단체
3rd row나눔단체
4th row나눔단체
5th row나눔단체

Common Values

ValueCountFrequency (%)
나눔단체 151
87.8%
법인 21
 
12.2%

Length

2024-01-10T05:22:06.811471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:22:06.927976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
나눔단체 151
87.8%
법인 21
 
12.2%

등록일자
Date

Distinct133
Distinct (%)77.3%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
Minimum2011-12-10 00:00:00
Maximum2022-01-25 00:00:00
2024-01-10T05:22:07.026228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:07.137819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing172
Missing (%)100.0%
Memory size1.6 KiB

Interactions

2024-01-10T05:22:04.560212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:04.425166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:04.628927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:04.493999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:22:07.217916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수단체구분
순번1.0000.2110.955
회원수0.2111.0000.000
단체구분0.9550.0001.000
2024-01-10T05:22:07.293701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수단체구분
순번1.0000.3850.799
회원수0.3851.0000.000
단체구분0.7990.0001.000

Missing values

2024-01-10T05:22:04.719171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:22:04.825724image/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성주면새마을부녀회이명숙10활동나눔단체2022-01-25<NA>
12무궁화봉사단이근식21활동나눔단체2021-11-16<NA>
23프로보노김건호14활동나눔단체2021-11-04<NA>
34보배유김현우6활동나눔단체2021-11-04<NA>
45무창포한마음봉사단조순호2활동나눔단체2021-10-18<NA>
56청바지봉사단이해승13활동나눔단체2021-08-18<NA>
67보령YSP편경천11활동나눔단체2021-07-27<NA>
78사)한국 소비자 연합 보령지부고명희27활동나눔단체2021-05-25<NA>
89체중계이종훈6활동나눔단체2021-05-17<NA>
910대한노인회보령시지회 웅천봉사클럽윤태명20활동나눔단체2021-05-10<NA>
순번단체명단체대표회원수상태단체구분등록일자비고
162163한국걸스카우트충남연맹보령시지부서여아46활동법인2011-12-10<NA>
163164사)색동회보령시지회정태경46활동법인2011-12-10<NA>
164165희망풍선봉사단김민주41활동나눔단체2011-12-10<NA>
165166GM대우(주)해마봉사단임주진38활동법인2011-12-10<NA>
166167자원봉사대학 1기이기복31활동법인2011-12-10<NA>
167168한국수자원공사보령두레회한상현29활동법인2011-12-10<NA>
168169보령시굴삭기협의회최호규26활동법인2011-12-10<NA>
169170사)전통민속문화보존회보령시지부김현길26활동법인2011-12-10<NA>
170171녹색어머니회(한내초교)이재영16활동법인2011-12-10<NA>
171172보령교육지원청학생상담자원봉사자회전말숙15활동법인2011-12-10<NA>