Overview

Dataset statistics

Number of variables8
Number of observations161
Missing cells163
Missing cells (%)12.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.7 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 161 (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:11.643118
Analysis finished2024-01-09 20:22:12.402441
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

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

Quantile statistics

Minimum1
5-th percentile9
Q141
median81
Q3121
95-th percentile153
Maximum161
Range160
Interquartile range (IQR)80

Descriptive statistics

Standard deviation46.620811
Coefficient of variation (CV)0.57556557
Kurtosis-1.2
Mean81
Median Absolute Deviation (MAD)40
Skewness0
Sum13041
Variance2173.5
MonotonicityStrictly increasing
2024-01-10T05:22:12.598586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
122 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
110 1
 
0.6%
111 1
 
0.6%
Other values (151) 151
93.8%
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 (%)
161 1
0.6%
160 1
0.6%
159 1
0.6%
158 1
0.6%
157 1
0.6%
156 1
0.6%
155 1
0.6%
154 1
0.6%
153 1
0.6%
152 1
0.6%

단체명
Text

UNIQUE 

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

Length

Max length21
Median length16
Mean length9.931677
Min length3

Characters and Unicode

Total characters1599
Distinct characters259
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

Unique161 ?
Unique (%)100.0%

Sample

1st row한국전기안전공사 충남서부지사
2nd row사)신흑청년회
3rd row충남 어린이집연합회 보령지회
4th row천사집수리봉사단
5th row한울타리 봉사단
ValueCountFrequency (%)
대한노인회 7
 
3.2%
봉사단 5
 
2.3%
보령시 3
 
1.4%
보령시지부 3
 
1.4%
만세보령 2
 
0.9%
새마을 2
 
0.9%
청소면 2
 
0.9%
보령 2
 
0.9%
부녀회 2
 
0.9%
이동빨래봉사단 2
 
0.9%
Other values (187) 189
86.3%
2024-01-10T05:22:13.108167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
회 78
 
4.9%
사 71
 
4.4%
보 65
 
4.1%
령 63
 
3.9%
대 62
 
3.9%
58
 
3.6%
자 46
 
2.9%
시 40
 
2.5%
봉 39
 
2.4%
지 34
 
2.1%
Other values (249) 1043
65.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1476
92.3%
Space Separator 58
 
3.6%
Decimal Number 26
 
1.6%
Close Punctuation 21
 
1.3%
Open Punctuation 11
 
0.7%
Uppercase Letter 7
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
회 78
 
5.3%
사 71
 
4.8%
보 65
 
4.4%
령 63
 
4.3%
대 62
 
4.2%
자 46
 
3.1%
시 40
 
2.7%
봉 39
 
2.6%
지 34
 
2.3%
한 32
 
2.2%
Other values (231) 946
64.1%
Decimal Number
ValueCountFrequency (%)
2 6
23.1%
1 6
23.1%
0 5
19.2%
5 3
11.5%
3 3
11.5%
6 1
 
3.8%
8 1
 
3.8%
7 1
 
3.8%
Uppercase Letter
ValueCountFrequency (%)
G 1
14.3%
M 1
14.3%
K 1
14.3%
P 1
14.3%
S 1
14.3%
B 1
14.3%
Y 1
14.3%
Space Separator
ValueCountFrequency (%)
58
100.0%
Close Punctuation
ValueCountFrequency (%)
) 21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1476
92.3%
Common 116
 
7.3%
Latin 7
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
회 78
 
5.3%
사 71
 
4.8%
보 65
 
4.4%
령 63
 
4.3%
대 62
 
4.2%
자 46
 
3.1%
시 40
 
2.7%
봉 39
 
2.6%
지 34
 
2.3%
한 32
 
2.2%
Other values (231) 946
64.1%
Common
ValueCountFrequency (%)
58
50.0%
) 21
 
18.1%
( 11
 
9.5%
2 6
 
5.2%
1 6
 
5.2%
0 5
 
4.3%
5 3
 
2.6%
3 3
 
2.6%
6 1
 
0.9%
8 1
 
0.9%
Latin
ValueCountFrequency (%)
G 1
14.3%
M 1
14.3%
K 1
14.3%
P 1
14.3%
S 1
14.3%
B 1
14.3%
Y 1
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1476
92.3%
ASCII 123
 
7.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
회 78
 
5.3%
사 71
 
4.8%
보 65
 
4.4%
령 63
 
4.3%
대 62
 
4.2%
자 46
 
3.1%
시 40
 
2.7%
봉 39
 
2.6%
지 34
 
2.3%
한 32
 
2.2%
Other values (231) 946
64.1%
ASCII
ValueCountFrequency (%)
58
47.2%
) 21
 
17.1%
( 11
 
8.9%
2 6
 
4.9%
1 6
 
4.9%
0 5
 
4.1%
5 3
 
2.4%
3 3
 
2.4%
6 1
 
0.8%
G 1
 
0.8%
Other values (8) 8
 
6.5%

단체대표
Text

MISSING 

Distinct150
Distinct (%)94.3%
Missing2
Missing (%)1.2%
Memory size1.4 KiB
2024-01-10T05:22:13.404718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters477
Distinct characters114
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

Unique141 ?
Unique (%)88.7%

Sample

1st row김윤기
2nd row김병창
3rd row박상미
4th row임위열
5th row김범준
ValueCountFrequency (%)
전윤수 2
 
1.3%
김효자 2
 
1.3%
이선우 2
 
1.3%
오치인 2
 
1.3%
김정진 2
 
1.3%
정영주 2
 
1.3%
임위열 2
 
1.3%
김규열 2
 
1.3%
김연주 2
 
1.3%
이선희 1
 
0.6%
Other values (140) 140
88.1%
2024-01-10T05:22:13.840048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 40
 
8.4%
이 33
 
6.9%
영 16
 
3.4%
정 14
 
2.9%
희 11
 
2.3%
미 10
 
2.1%
숙 10
 
2.1%
박 10
 
2.1%
수 9
 
1.9%
주 9
 
1.9%
Other values (104) 315
66.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 477
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 40
 
8.4%
이 33
 
6.9%
영 16
 
3.4%
정 14
 
2.9%
희 11
 
2.3%
미 10
 
2.1%
숙 10
 
2.1%
박 10
 
2.1%
수 9
 
1.9%
주 9
 
1.9%
Other values (104) 315
66.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 477
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 40
 
8.4%
이 33
 
6.9%
영 16
 
3.4%
정 14
 
2.9%
희 11
 
2.3%
미 10
 
2.1%
숙 10
 
2.1%
박 10
 
2.1%
수 9
 
1.9%
주 9
 
1.9%
Other values (104) 315
66.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 477
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 40
 
8.4%
이 33
 
6.9%
영 16
 
3.4%
정 14
 
2.9%
희 11
 
2.3%
미 10
 
2.1%
숙 10
 
2.1%
박 10
 
2.1%
수 9
 
1.9%
주 9
 
1.9%
Other values (104) 315
66.0%

회원수
Real number (ℝ)

Distinct71
Distinct (%)44.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean70.335404
Minimum1
Maximum2877
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-01-10T05:22:13.979280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7
Q115
median24
Q339
95-th percentile131
Maximum2877
Range2876
Interquartile range (IQR)24

Descriptive statistics

Standard deviation261.73094
Coefficient of variation (CV)3.7211835
Kurtosis86.238069
Mean70.335404
Median Absolute Deviation (MAD)12
Skewness8.6801551
Sum11324
Variance68503.087
MonotonicityNot monotonic
2024-01-10T05:22:14.100504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20 11
 
6.8%
12 8
 
5.0%
7 7
 
4.3%
15 6
 
3.7%
31 6
 
3.7%
11 6
 
3.7%
16 6
 
3.7%
27 5
 
3.1%
8 5
 
3.1%
24 5
 
3.1%
Other values (61) 96
59.6%
ValueCountFrequency (%)
1 1
 
0.6%
2 1
 
0.6%
4 2
 
1.2%
5 1
 
0.6%
6 2
 
1.2%
7 7
4.3%
8 5
3.1%
9 1
 
0.6%
10 2
 
1.2%
11 6
3.7%
ValueCountFrequency (%)
2877 1
0.6%
1242 1
0.6%
914 1
0.6%
537 1
0.6%
525 1
0.6%
523 1
0.6%
196 1
0.6%
147 1
0.6%
131 1
0.6%
117 1
0.6%

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
활동
161 

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 (%)
활동 161
100.0%

Length

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

Common Values (Plot)

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

단체구분
Categorical

HIGH CORRELATION 

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

Length

Max length4
Median length4
Mean length3.7391304
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
나눔단체 140
87.0%
법인 21
 
13.0%

Length

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

Common Values (Plot)

2024-01-10T05:22:14.535754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
나눔단체 140
87.0%
법인 21
 
13.0%

등록일자
Date

Distinct124
Distinct (%)77.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2011-12-10 00:00:00
Maximum2021-02-03 00:00:00
2024-01-10T05:22:14.627602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:14.753373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing161
Missing (%)100.0%
Memory size1.5 KiB

Interactions

2024-01-10T05:22:12.045442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:11.885060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:12.124307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:22:11.967476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:22:14.837971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수단체구분
순번1.0000.0000.939
회원수0.0001.0000.000
단체구분0.9390.0001.000
2024-01-10T05:22:14.920438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회원수단체구분
순번1.0000.3740.771
회원수0.3741.0000.000
단체구분0.7710.0001.000

Missing values

2024-01-10T05:22:12.233108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:22:12.359995image/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한국전기안전공사 충남서부지사김윤기15활동나눔단체2021-02-03<NA>
12사)신흑청년회김병창47활동나눔단체2021-01-08<NA>
23충남 어린이집연합회 보령지회박상미39활동나눔단체2020-11-13<NA>
34천사집수리봉사단임위열8활동나눔단체2020-11-11<NA>
45한울타리 봉사단김범준12활동나눔단체2020-07-31<NA>
56국제로타리620지구 대천로타리클럽이수미7활동나눔단체2020-07-30<NA>
67현대집수리봉사단정대준1활동나눔단체2020-07-29<NA>
78사) 전국이통장중앙회 보령시지회박종환33활동나눔단체2020-07-28<NA>
89농협 중앙회 보령시지부조용철10활동나눔단체2020-07-23<NA>
910사)보령시발전협의회양석우24활동나눔단체2020-07-20<NA>
순번단체명단체대표회원수상태단체구분등록일자비고
151152사)색동회보령시지회박금옥45활동법인2011-12-10<NA>
152153한국걸스카우트충남연맹보령시지부서여아45활동법인2011-12-10<NA>
153154희망풍선봉사단김민주40활동나눔단체2011-12-10<NA>
154155GM대우(주)해마봉사단임주진38활동법인2011-12-10<NA>
155156자원봉사대학 1기이기복31활동법인2011-12-10<NA>
156157한국수자원공사보령두레회한상현29활동법인2011-12-10<NA>
157158보령시굴삭기협의회최호규26활동법인2011-12-10<NA>
158159사)전통민속문화보존회보령시지부김현길26활동법인2011-12-10<NA>
159160녹색어머니회(한내초교)이재영16활동법인2011-12-10<NA>
160161보령교육지원청학생상담자원봉사자회정영주15활동법인2011-12-10<NA>