Overview

Dataset statistics

Number of variables19
Number of observations91
Missing cells35
Missing cells (%)2.0%
Duplicate rows1
Duplicate rows (%)1.1%
Total size in memory13.6 KiB
Average record size in memory153.5 B

Variable types

Unsupported3
Categorical14
Text2

Dataset

Description각 시설에서 운영하는 교육프로그램 운영현황이며 프로그램 운영기관, 프로그램 운영장소, 프로그램명, 프로그램내용 등을 제공합니다.
Author전라북도
URLhttps://www.bigdatahub.go.kr/index.jeonbuk?startPage=10&menuCd=DOM_000000103007001000&pListTypeStr=&pId=3079823

Alerts

Dataset has 1 (1.1%) duplicate rowsDuplicates
Unnamed: 13 is highly overall correlated with Unnamed: 2 and 10 other fieldsHigh correlation
Unnamed: 8 is highly overall correlated with Unnamed: 1 and 4 other fieldsHigh correlation
Unnamed: 14 is highly overall correlated with Unnamed: 1 and 10 other fieldsHigh correlation
Unnamed: 2 is highly overall correlated with Unnamed: 1 and 10 other fieldsHigh correlation
Unnamed: 17 is highly overall correlated with Unnamed: 1 and 8 other fieldsHigh correlation
Unnamed: 18 is highly overall correlated with Unnamed: 1 and 5 other fieldsHigh correlation
Unnamed: 6 is highly overall correlated with Unnamed: 1 and 2 other fieldsHigh correlation
Unnamed: 1 is highly overall correlated with Unnamed: 2 and 10 other fieldsHigh correlation
Unnamed: 3 is highly overall correlated with Unnamed: 1 and 6 other fieldsHigh correlation
Unnamed: 9 is highly overall correlated with Unnamed: 1 and 3 other fieldsHigh correlation
Unnamed: 10 is highly overall correlated with Unnamed: 1 and 5 other fieldsHigh correlation
Unnamed: 11 is highly overall correlated with Unnamed: 1 and 2 other fieldsHigh correlation
Unnamed: 15 is highly overall correlated with Unnamed: 3 and 3 other fieldsHigh correlation
Unnamed: 16 is highly overall correlated with Unnamed: 1 and 6 other fieldsHigh correlation
Unnamed: 1 is highly imbalanced (67.5%)Imbalance
Unnamed: 8 is highly imbalanced (57.5%)Imbalance
Unnamed: 13 is highly imbalanced (67.5%)Imbalance
Unnamed: 14 is highly imbalanced (59.5%)Imbalance
2021년 토요프로그램 개설(운영) 현황(청소년수련관, 청소년문화의집) has 3 (3.3%) missing valuesMissing
Unnamed: 4 has 8 (8.8%) missing valuesMissing
Unnamed: 5 has 8 (8.8%) missing valuesMissing
Unnamed: 7 has 8 (8.8%) missing valuesMissing
Unnamed: 12 has 8 (8.8%) missing valuesMissing
2021년 토요프로그램 개설(운영) 현황(청소년수련관, 청소년문화의집) is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 00:58:49.822956
Analysis finished2024-03-14 00:58:52.237658
Duration2.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2021년 토요프로그램 개설(운영) 현황(청소년수련관, 청소년문화의집)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)3.3%
Memory size860.0 B

Unnamed: 1
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size860.0 B
전주
82 
<NA>
 
8
지역
 
1

Length

Max length4
Median length2
Mean length2.1758242
Min length2

Unique

Unique1 ?
Unique (%)1.1%

Sample

1st row<NA>
2nd row지역
3rd row<NA>
4th row전주
5th row전주

Common Values

ValueCountFrequency (%)
전주 82
90.1%
<NA> 8
 
8.8%
지역 1
 
1.1%

Length

2024-03-14T09:58:52.296282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:52.375249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전주 82
90.1%
na 8
 
8.8%
지역 1
 
1.1%

Unnamed: 2
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size860.0 B
완산청소년문화의집
23 
덕진 청소년문화의집
19 
솔내청소년수련관
16 
효자청소년문화의집
16 
<NA>
8 
Other values (3)
9 

Length

Max length18
Median length9
Mean length8.6923077
Min length4

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row<NA>
2nd row프로그램 운영기관
3rd row<NA>
4th row솔내청소년수련관
5th row솔내청소년수련관

Common Values

ValueCountFrequency (%)
완산청소년문화의집 23
25.3%
덕진 청소년문화의집 19
20.9%
솔내청소년수련관 16
17.6%
효자청소년문화의집 16
17.6%
<NA> 8
 
8.8%
전주청소년문화의집 7
 
7.7%
프로그램 운영기관 1
 
1.1%
완산청소년문화의집 전주시평생학습관 1
 
1.1%

Length

2024-03-14T09:58:52.465179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:52.559245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완산청소년문화의집 24
21.4%
덕진 19
17.0%
청소년문화의집 19
17.0%
솔내청소년수련관 16
14.3%
효자청소년문화의집 16
14.3%
na 8
 
7.1%
전주청소년문화의집 7
 
6.2%
프로그램 1
 
0.9%
운영기관 1
 
0.9%
전주시평생학습관 1
 
0.9%

Unnamed: 3
Categorical

HIGH CORRELATION 

Distinct40
Distinct (%)44.0%
Missing0
Missing (%)0.0%
Memory size860.0 B
솔내청소년수련관
9 
덕진 청소년문화의집 다목적실
9 
<NA>
8 
청아나루작은도서관
7 
전주청소년문화의집
6 
Other values (35)
52 

Length

Max length28
Median length18
Mean length10.472527
Min length3

Unique

Unique26 ?
Unique (%)28.6%

Sample

1st row<NA>
2nd row프로그램 운영장소
3rd row<NA>
4th row솔내청소년수련관 내
5th row솔내청소년수련관 내

Common Values

ValueCountFrequency (%)
솔내청소년수련관 9
 
9.9%
덕진 청소년문화의집 다목적실 9
 
9.9%
<NA> 8
 
8.8%
청아나루작은도서관 7
 
7.7%
전주청소년문화의집 6
 
6.6%
완산청소년문화의집 6
 
6.6%
솔내청소년수련관 내 4
 
4.4%
덕진 청소년문화의집 작은도서관(1층) 3
 
3.3%
효자청소년문화의집 외 1곳 3
 
3.3%
온라인 2
 
2.2%
Other values (30) 34
37.4%

Length

2024-03-14T09:58:52.682273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
덕진 15
 
9.7%
청소년문화의집 15
 
9.7%
솔내청소년수련관 14
 
9.1%
완산청소년문화의집 10
 
6.5%
다목적실 9
 
5.8%
효자청소년문화의집 9
 
5.8%
na 8
 
5.2%
청아나루작은도서관 7
 
4.5%
외 6
 
3.9%
전주청소년문화의집 6
 
3.9%
Other values (37) 55
35.7%

Unnamed: 4
Text

MISSING 

Distinct83
Distinct (%)100.0%
Missing8
Missing (%)8.8%
Memory size860.0 B
2024-03-14T09:58:52.982406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length25
Mean length12.361446
Min length2

Characters and Unicode

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

Unique

Unique83 ?
Unique (%)100.0%

Sample

1st row프로그램명
2nd row솔내 토요예체능
3rd rowCHEER UP
4th row청소년 드론축구
5th row기후환경 프로그램
ValueCountFrequency (%)
청소년 7
 
3.3%
프로그램 6
 
2.8%
up 3
 
1.4%
만들기 3
 
1.4%
연합행사 3
 
1.4%
아카데미 2
 
0.9%
운영위원회 2
 
0.9%
함께 2
 
0.9%
하는 2
 
0.9%
봉사활동 2
 
0.9%
Other values (173) 182
85.0%
2024-03-14T09:58:53.433909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
109
 
10.6%
41
 
4.0%
소 23
 
2.2%
청 22
 
2.1%
년 22
 
2.1%
시 15
 
1.5%
사 13
 
1.3%
로 13
 
1.3%
이 12
 
1.2%
드 12
 
1.2%
Other values (279) 744
72.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 788
76.8%
Space Separator 109
 
10.6%
Control 41
 
4.0%
Uppercase Letter 31
 
3.0%
Other Punctuation 21
 
2.0%
Lowercase Letter 18
 
1.8%
Dash Punctuation 5
 
0.5%
Decimal Number 5
 
0.5%
Open Punctuation 3
 
0.3%
Close Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
소 23
 
2.9%
청 22
 
2.8%
년 22
 
2.8%
시 15
 
1.9%
사 13
 
1.6%
로 13
 
1.6%
이 12
 
1.5%
드 12
 
1.5%
기 11
 
1.4%
회 11
 
1.4%
Other values (240) 634
80.5%
Uppercase Letter
ValueCountFrequency (%)
E 4
12.9%
U 3
9.7%
P 3
9.7%
J 2
 
6.5%
O 2
 
6.5%
H 2
 
6.5%
R 2
 
6.5%
T 2
 
6.5%
G 2
 
6.5%
W 2
 
6.5%
Other values (5) 7
22.6%
Lowercase Letter
ValueCountFrequency (%)
o 6
33.3%
g 3
16.7%
b 2
 
11.1%
e 2
 
11.1%
p 2
 
11.1%
n 1
 
5.6%
r 1
 
5.6%
k 1
 
5.6%
Other Punctuation
ValueCountFrequency (%)
, 8
38.1%
' 6
28.6%
" 4
19.0%
! 2
 
9.5%
? 1
 
4.8%
Decimal Number
ValueCountFrequency (%)
2 2
40.0%
8 1
20.0%
1 1
20.0%
3 1
20.0%
Math Symbol
ValueCountFrequency (%)
< 1
50.0%
> 1
50.0%
Space Separator
ValueCountFrequency (%)
109
100.0%
Control
ValueCountFrequency (%)
41
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 788
76.8%
Common 189
 
18.4%
Latin 49
 
4.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
소 23
 
2.9%
청 22
 
2.8%
년 22
 
2.8%
시 15
 
1.9%
사 13
 
1.6%
로 13
 
1.6%
이 12
 
1.5%
드 12
 
1.5%
기 11
 
1.4%
회 11
 
1.4%
Other values (240) 634
80.5%
Latin
ValueCountFrequency (%)
o 6
 
12.2%
E 4
 
8.2%
g 3
 
6.1%
U 3
 
6.1%
P 3
 
6.1%
J 2
 
4.1%
b 2
 
4.1%
e 2
 
4.1%
O 2
 
4.1%
H 2
 
4.1%
Other values (13) 20
40.8%
Common
ValueCountFrequency (%)
109
57.7%
41
 
21.7%
, 8
 
4.2%
' 6
 
3.2%
- 5
 
2.6%
" 4
 
2.1%
( 3
 
1.6%
) 3
 
1.6%
2 2
 
1.1%
! 2
 
1.1%
Other values (6) 6
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 788
76.8%
ASCII 238
 
23.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
109
45.8%
41
 
17.2%
, 8
 
3.4%
' 6
 
2.5%
o 6
 
2.5%
- 5
 
2.1%
E 4
 
1.7%
" 4
 
1.7%
g 3
 
1.3%
U 3
 
1.3%
Other values (29) 49
20.6%
Hangul
ValueCountFrequency (%)
소 23
 
2.9%
청 22
 
2.8%
년 22
 
2.8%
시 15
 
1.9%
사 13
 
1.6%
로 13
 
1.6%
이 12
 
1.5%
드 12
 
1.5%
기 11
 
1.4%
회 11
 
1.4%
Other values (240) 634
80.5%

Unnamed: 5
Text

MISSING 

Distinct78
Distinct (%)94.0%
Missing8
Missing (%)8.8%
Memory size860.0 B
2024-03-14T09:58:53.627782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length22
Mean length13.590361
Min length2

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)90.4%

Sample

1st row프로그램내용
2nd row뉴스포츠 및 음악줄넘기 활동을 통한 체력증진
3rd row치어댄스를 배워보는 시간
4th row드론축구를 배워보는 시간
5th row기후환경 보호와 실천을 위한 프로그램
ValueCountFrequency (%)
및 24
 
8.7%
프로그램 9
 
3.2%
청소년 9
 
3.2%
만들기 7
 
2.5%
공연 6
 
2.2%
체험활동 4
 
1.4%
지역사회 4
 
1.4%
체험 4
 
1.4%
동아리 3
 
1.1%
토요프로그램 3
 
1.1%
Other values (172) 204
73.6%
2024-03-14T09:58:53.941135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
181
 
16.0%
34
 
3.0%
사 29
 
2.6%
동 28
 
2.5%
및 24
 
2.1%
소 22
 
2.0%
활 22
 
2.0%
기 22
 
2.0%
청 16
 
1.4%
지 15
 
1.3%
Other values (217) 735
65.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 885
78.5%
Space Separator 181
 
16.0%
Control 34
 
3.0%
Other Punctuation 14
 
1.2%
Decimal Number 7
 
0.6%
Uppercase Letter 5
 
0.4%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 29
 
3.3%
동 28
 
3.2%
및 24
 
2.7%
소 22
 
2.5%
활 22
 
2.5%
기 22
 
2.5%
청 16
 
1.8%
지 15
 
1.7%
체 15
 
1.7%
화 15
 
1.7%
Other values (205) 677
76.5%
Decimal Number
ValueCountFrequency (%)
3 3
42.9%
2 2
28.6%
6 1
 
14.3%
5 1
 
14.3%
Uppercase Letter
ValueCountFrequency (%)
D 2
40.0%
P 2
40.0%
O 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 13
92.9%
& 1
 
7.1%
Space Separator
ValueCountFrequency (%)
181
100.0%
Control
ValueCountFrequency (%)
34
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 885
78.5%
Common 238
 
21.1%
Latin 5
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 29
 
3.3%
동 28
 
3.2%
및 24
 
2.7%
소 22
 
2.5%
활 22
 
2.5%
기 22
 
2.5%
청 16
 
1.8%
지 15
 
1.7%
체 15
 
1.7%
화 15
 
1.7%
Other values (205) 677
76.5%
Common
ValueCountFrequency (%)
181
76.1%
34
 
14.3%
, 13
 
5.5%
3 3
 
1.3%
2 2
 
0.8%
- 2
 
0.8%
& 1
 
0.4%
6 1
 
0.4%
5 1
 
0.4%
Latin
ValueCountFrequency (%)
D 2
40.0%
P 2
40.0%
O 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 885
78.5%
ASCII 243
 
21.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
181
74.5%
34
 
14.0%
, 13
 
5.3%
3 3
 
1.2%
D 2
 
0.8%
2 2
 
0.8%
P 2
 
0.8%
- 2
 
0.8%
& 1
 
0.4%
6 1
 
0.4%
Other values (2) 2
 
0.8%
Hangul
ValueCountFrequency (%)
사 29
 
3.3%
동 28
 
3.2%
및 24
 
2.7%
소 22
 
2.5%
활 22
 
2.5%
기 22
 
2.5%
청 16
 
1.8%
지 15
 
1.7%
체 15
 
1.7%
화 15
 
1.7%
Other values (205) 677
76.5%

Unnamed: 6
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.9%
Missing0
Missing (%)0.0%
Memory size860.0 B
기타
26 
체험활동
18 
예체능
17 
특기적성
12 
<NA>
8 
Other values (4)
10 

Length

Max length5
Median length4
Mean length3.0989011
Min length2

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row<NA>
2nd row분야
3rd row<NA>
4th row예체능
5th row예체능

Common Values

ValueCountFrequency (%)
기타 26
28.6%
체험활동 18
19.8%
예체능 17
18.7%
특기적성 12
13.2%
<NA> 8
 
8.8%
체험 6
 
6.6%
교과학습 2
 
2.2%
분야 1
 
1.1%
예체능활동 1
 
1.1%

Length

2024-03-14T09:58:54.056183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:54.164737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 26
28.6%
체험활동 18
19.8%
예체능 17
18.7%
특기적성 12
13.2%
na 8
 
8.8%
체험 6
 
6.6%
교과학습 2
 
2.2%
분야 1
 
1.1%
예체능활동 1
 
1.1%

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)8.8%
Memory size860.0 B

Unnamed: 8
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct10
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size860.0 B
토
70 
<NA>
8 
상시
 
3
토
 
2
수
 
2
Other values (5)
 
6

Length

Max length5
Median length1
Mean length1.4505495
Min length1

Unique

Unique4 ?
Unique (%)4.4%

Sample

1st row<NA>
2nd row운영 요일
3rd row<NA>
4th row 토
5th row토

Common Values

ValueCountFrequency (%)
토 70
76.9%
<NA> 8
 
8.8%
상시 3
 
3.3%
토 2
 
2.2%
수 2
 
2.2%
일 2
 
2.2%
운영 요일 1
 
1.1%
수, 토 1
 
1.1%
화~토 1
 
1.1%
토, 일 1
 
1.1%

Length

2024-03-14T09:58:54.273319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:54.379472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
토 74
78.7%
na 8
 
8.5%
상시 3
 
3.2%
수 3
 
3.2%
일 3
 
3.2%
운영 1
 
1.1%
요일 1
 
1.1%
화~토 1
 
1.1%

Unnamed: 9
Categorical

HIGH CORRELATION 

Distinct35
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Memory size860.0 B
1회
18 
<NA>
8 
상시
6 
2회
5 
1회기
5 
Other values (30)
49 

Length

Max length7
Median length6
Mean length3.2197802
Min length2

Unique

Unique19 ?
Unique (%)20.9%

Sample

1st row<NA>
2nd row운영 형태
3rd row<NA>
4th row매월 2회
5th row매월 2회

Common Values

ValueCountFrequency (%)
1회 18
19.8%
<NA> 8
 
8.8%
상시 6
 
6.6%
2회 5
 
5.5%
1회기 5
 
5.5%
기타 5
 
5.5%
월1회 4
 
4.4%
정기형 10회 3
 
3.3%
정기형 12회 3
 
3.3%
매월 2회 3
 
3.3%
Other values (25) 31
34.1%

Length

2024-03-14T09:58:54.479351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1회 24
22.0%
2회 8
 
7.3%
na 8
 
7.3%
상시 6
 
5.5%
정기형 6
 
5.5%
1회기 5
 
4.6%
기타 5
 
4.6%
12회 5
 
4.6%
매월 5
 
4.6%
월1회 4
 
3.7%
Other values (23) 33
30.3%

Unnamed: 10
Categorical

HIGH CORRELATION 

Distinct39
Distinct (%)42.9%
Missing0
Missing (%)0.0%
Memory size860.0 B
<NA>
12 
14:00~16:00
12 
10:00~12:00
10 
10:00-12:00
5 
09:00~13:00
 
3
Other values (34)
49 

Length

Max length25
Median length11
Mean length10.076923
Min length2

Unique

Unique23 ?
Unique (%)25.3%

Sample

1st row<NA>
2nd row운영시간
3rd row<NA>
4th row09:30-11:00
5th row10:00-12:00

Common Values

ValueCountFrequency (%)
<NA> 12
 
13.2%
14:00~16:00 12
 
13.2%
10:00~12:00 10
 
11.0%
10:00-12:00 5
 
5.5%
09:00~13:00 3
 
3.3%
10:00~18:00 3
 
3.3%
13:00~15:00 3
 
3.3%
15:00~17:00 3
 
3.3%
14:00~15:30 3
 
3.3%
14:00-16:00 2
 
2.2%
Other values (29) 35
38.5%

Length

2024-03-14T09:58:54.570924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 12
 
13.0%
14:00~16:00 12
 
13.0%
10:00~12:00 11
 
12.0%
10:00-12:00 5
 
5.4%
09:00~13:00 3
 
3.3%
10:00~18:00 3
 
3.3%
13:00~15:00 3
 
3.3%
15:00~17:00 3
 
3.3%
14:00~15:30 3
 
3.3%
14:00~18:00 2
 
2.2%
Other values (28) 35
38.0%

Unnamed: 11
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)22.0%
Missing0
Missing (%)0.0%
Memory size860.0 B
청소년
27 
중고
11 
지역주민
10 
<NA>
8 
초
7 
Other values (15)
28 

Length

Max length9
Median length8
Mean length3.5274725
Min length1

Unique

Unique10 ?
Unique (%)11.0%

Sample

1st row<NA>
2nd row참여 대상
3rd row<NA>
4th row초
5th row초

Common Values

ValueCountFrequency (%)
청소년 27
29.7%
중고 11
12.1%
지역주민 10
 
11.0%
<NA> 8
 
8.8%
초 7
 
7.7%
중,고 5
 
5.5%
청소년 및 성인 5
 
5.5%
초중고 4
 
4.4%
고 2
 
2.2%
초,중,고,대학생 2
 
2.2%
Other values (10) 10
 
11.0%

Length

2024-03-14T09:58:54.670364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청소년 35
33.3%
지역주민 11
 
10.5%
중고 11
 
10.5%
na 8
 
7.6%
초 7
 
6.7%
성인 7
 
6.7%
중,고 5
 
4.8%
및 5
 
4.8%
초중고 4
 
3.8%
초,중,고,대학생 2
 
1.9%
Other values (9) 10
 
9.5%

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)8.8%
Memory size860.0 B

Unnamed: 13
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size860.0 B
무료
82 
<NA>
 
8
수강료 (참가비)
 
1

Length

Max length9
Median length2
Mean length2.2527473
Min length2

Unique

Unique1 ?
Unique (%)1.1%

Sample

1st row<NA>
2nd row수강료 (참가비)
3rd row<NA>
4th row무료
5th row무료

Common Values

ValueCountFrequency (%)
무료 82
90.1%
<NA> 8
 
8.8%
수강료 (참가비) 1
 
1.1%

Length

2024-03-14T09:58:54.789644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:54.866050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무료 82
89.1%
na 8
 
8.7%
수강료 1
 
1.1%
참가비 1
 
1.1%

Unnamed: 14
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)5.5%
Missing0
Missing (%)0.0%
Memory size860.0 B
자유
75 
<NA>
8 
버스
 
6
이동 수단
 
1
자유 및 버스
 
1

Length

Max length7
Median length2
Mean length2.2637363
Min length2

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row<NA>
2nd row이동 수단
3rd row<NA>
4th row자유
5th row자유

Common Values

ValueCountFrequency (%)
자유 75
82.4%
<NA> 8
 
8.8%
버스 6
 
6.6%
이동 수단 1
 
1.1%
자유 및 버스 1
 
1.1%

Length

2024-03-14T09:58:54.944878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:58:55.020956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자유 76
80.9%
na 8
 
8.5%
버스 7
 
7.4%
이동 1
 
1.1%
수단 1
 
1.1%
및 1
 
1.1%

Unnamed: 15
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size860.0 B
없음
19 
간식
19 
간식 미제공
16 
간식제공
12 
<NA>
8 
Other values (7)
17 

Length

Max length10
Median length9
Mean length4.0879121
Min length2

Unique

Unique4 ?
Unique (%)4.4%

Sample

1st row<NA>
2nd row식사 (간식) 제공
3rd row<NA>
4th row없음
5th row없음

Common Values

ValueCountFrequency (%)
없음 19
20.9%
간식 19
20.9%
간식 미제공 16
17.6%
간식제공 12
13.2%
<NA> 8
8.8%
식사 (간식) 제공 8
8.8%
미제공 3
 
3.3%
간식 제공 2
 
2.2%
도시락 1
 
1.1%
식사제공 1
 
1.1%
Other values (2) 2
 
2.2%

Length

2024-03-14T09:58:55.178264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
간식 46
36.2%
없음 19
15.0%
미제공 19
15.0%
간식제공 12
 
9.4%
제공 10
 
7.9%
na 8
 
6.3%
식사 8
 
6.3%
식사제공 2
 
1.6%
도시락 1
 
0.8%
및 1
 
0.8%

Unnamed: 16
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)35.2%
Missing0
Missing (%)0.0%
Memory size860.0 B
장소희
8 
최은영
7 
<NA>
7 
이하은
6 
김솔아
6 
Other values (27)
57 

Length

Max length8
Median length3
Mean length3.2087912
Min length2

Unique

Unique13 ?
Unique (%)14.3%

Sample

1st row<NA>
2nd row운영 담당자
3rd row이름
4th row기민주
5th row기민주

Common Values

ValueCountFrequency (%)
장소희 8
 
8.8%
최은영 7
 
7.7%
<NA> 7
 
7.7%
이하은 6
 
6.6%
김솔아 6
 
6.6%
이형준 6
 
6.6%
추진력 5
 
5.5%
기민주 5
 
5.5%
강진옥 4
 
4.4%
김소라 4
 
4.4%
Other values (22) 33
36.3%

Length

2024-03-14T09:58:55.344091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
장소희 8
 
8.5%
이하은 8
 
8.5%
na 7
 
7.4%
최은영 7
 
7.4%
김솔아 6
 
6.4%
이형준 6
 
6.4%
추진력 5
 
5.3%
기민주 5
 
5.3%
강진옥 4
 
4.3%
김소라 4
 
4.3%
Other values (21) 34
36.2%

Unnamed: 17
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)16.5%
Missing0
Missing (%)0.0%
Memory size860.0 B
278-8588
15 
273-7997
15 
226-5193
15 
236-7142
10 
<NA>
8 
Other values (10)
28 

Length

Max length8
Median length8
Mean length7.6483516
Min length4

Unique

Unique5 ?
Unique (%)5.5%

Sample

1st row<NA>
2nd row<NA>
3rd row연락처 (전화)
4th row278-8588
5th row278-8588

Common Values

ValueCountFrequency (%)
278-8588 15
16.5%
273-7997 15
16.5%
226-5193 15
16.5%
236-7142 10
11.0%
<NA> 8
8.8%
905-7720 8
8.8%
273-5501 7
7.7%
273-7660 3
 
3.3%
236-7144 3
 
3.3%
236-7143 2
 
2.2%
Other values (5) 5
 
5.5%

Length

2024-03-14T09:58:55.460792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
278-8588 15
16.3%
273-7997 15
16.3%
226-5193 15
16.3%
236-7142 10
10.9%
na 8
8.7%
905-7720 8
8.7%
273-5501 7
7.6%
273-7660 3
 
3.3%
236-7144 3
 
3.3%
236-7143 2
 
2.2%
Other values (6) 6
 
6.5%

Unnamed: 18
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)17.6%
Missing0
Missing (%)0.0%
Memory size860.0 B
전주시 완산구 선너머 2길 37
22 
전주시 덕진구 기린대로 541-11
18 
전주시 덕진구 동부대로 1079
16 
전주시 완산구 우전2길 20
9 
<NA>
8 
Other values (11)
18 

Length

Max length20
Median length18
Mean length16.56044
Min length4

Unique

Unique6 ?
Unique (%)6.6%

Sample

1st row<NA>
2nd row운영기관주소 (새주소 기입)
3rd row<NA>
4th row전주시 덕진구 동부대로 1079
5th row전주시 덕진구 동부대로 1079

Common Values

ValueCountFrequency (%)
전주시 완산구 선너머 2길 37 22
24.2%
전주시 덕진구 기린대로 541-11 18
19.8%
전주시 덕진구 동부대로 1079 16
17.6%
전주시 완산구 우전2길 20 9
9.9%
<NA> 8
 
8.8%
전주시 완산구 태진로 15-21 3
 
3.3%
전주시 완산구 우전2길 22 3
 
3.3%
전주시 완산구 선너머2길 37 2
 
2.2%
전주시 완산구 태진로 15-14 2
 
2.2%
전주시 완산구 우전2길 21 2
 
2.2%
Other values (6) 6
 
6.6%

Length

2024-03-14T09:58:55.586287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전주시 82
22.7%
완산구 47
13.0%
덕진구 35
9.7%
37 24
 
6.6%
선너머 22
 
6.1%
2길 22
 
6.1%
기린대로 19
 
5.3%
541-11 18
 
5.0%
동부대로 16
 
4.4%
1079 16
 
4.4%
Other values (16) 60
16.6%

Correlations

2024-03-14T09:58:55.660621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
Unnamed: 11.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.6901.0000.0001.000NaN1.000
Unnamed: 21.0001.0000.9871.0000.9930.6500.7860.9180.9280.8941.0000.7130.7341.0000.9610.973
Unnamed: 31.0000.9871.0001.0000.0000.1910.9080.9070.9540.9251.0000.9840.9360.9470.9920.961
Unnamed: 41.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
Unnamed: 51.0000.9930.0001.0001.0001.0000.9220.9930.8280.9971.0000.0000.0000.0000.0000.000
Unnamed: 61.0000.6500.1911.0001.0001.0000.6620.7190.5940.6461.0000.8820.1790.7600.3950.632
Unnamed: 81.0000.7860.9081.0000.9220.6621.0000.0000.9590.8041.0000.6850.3440.6910.6650.708
Unnamed: 91.0000.9180.9071.0000.9930.7190.0001.0000.8670.9141.0000.9120.9130.9310.8600.845
Unnamed: 101.0000.9280.9541.0000.8280.5940.9590.8671.0000.8611.0000.8990.8510.9210.9340.901
Unnamed: 111.0000.8940.9251.0000.9970.6460.8040.9140.8611.0001.0000.7370.7540.8770.6650.762
Unnamed: 130.6901.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.0001.000NaN1.000
Unnamed: 141.0000.7130.9841.0000.0000.8820.6850.9120.8990.7371.0001.0000.8250.9620.8670.743
Unnamed: 150.0000.7340.9361.0000.0000.1790.3440.9130.8510.7540.0000.8251.0000.9510.8870.789
Unnamed: 161.0001.0000.9471.0000.0000.7600.6910.9310.9210.8771.0000.9620.9511.0000.9810.962
Unnamed: 17NaN0.9610.9921.0000.0000.3950.6650.8600.9340.665NaN0.8670.8870.9811.0000.948
Unnamed: 181.0000.9730.9611.0000.0000.6320.7080.8450.9010.7621.0000.7430.7890.9620.9481.000
2024-03-14T09:58:55.831740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 13Unnamed: 8Unnamed: 14Unnamed: 16Unnamed: 2Unnamed: 17Unnamed: 10Unnamed: 9Unnamed: 11Unnamed: 18Unnamed: 3Unnamed: 6Unnamed: 15Unnamed: 1
Unnamed: 131.0000.9560.9880.8090.9691.0000.7300.7780.8890.9160.7370.9620.0000.484
Unnamed: 80.9561.0000.5000.2780.5660.3620.6020.0000.4400.3640.4760.3970.1560.956
Unnamed: 140.9880.5001.0000.6970.5710.7100.5130.5710.4530.4890.6850.5550.6390.988
Unnamed: 160.8090.2780.6971.0000.8350.7340.4040.4630.4040.5590.4710.3500.6270.809
Unnamed: 20.9690.5660.5710.8351.0000.8370.5340.5490.6190.8460.6970.4170.4650.969
Unnamed: 171.0000.3620.7100.7340.8371.0000.5020.3960.2830.7390.7290.1830.6181.000
Unnamed: 100.7300.6020.5130.4040.5340.5021.0000.3140.2900.4110.4040.1940.3690.730
Unnamed: 90.7780.0000.5710.4630.5490.3960.3141.0000.4470.3580.3730.2970.4980.778
Unnamed: 110.8890.4400.4530.4040.6190.2830.2900.4471.0000.3480.4360.3080.3690.889
Unnamed: 180.9160.3640.4890.5590.8460.7390.4110.3580.3481.0000.5660.3130.4380.916
Unnamed: 30.7370.4760.6850.4710.6970.7290.4040.3730.4360.5661.0000.0000.5200.737
Unnamed: 60.9620.3970.5550.3500.4170.1830.1940.2970.3080.3130.0001.0000.0730.962
Unnamed: 150.0000.1560.6390.6270.4650.6180.3690.4980.3690.4380.5200.0731.0000.000
Unnamed: 10.4840.9560.9880.8090.9691.0000.7300.7780.8890.9160.7370.9620.0001.000
2024-03-14T09:58:55.954657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 6Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
Unnamed: 11.0000.9690.7370.9620.9560.7780.7300.8890.4840.9880.0000.8091.0000.916
Unnamed: 20.9691.0000.6970.4170.5660.5490.5340.6190.9690.5710.4650.8350.8370.846
Unnamed: 30.7370.6971.0000.0000.4760.3730.4040.4360.7370.6850.5200.4710.7290.566
Unnamed: 60.9620.4170.0001.0000.3970.2970.1940.3080.9620.5550.0730.3500.1830.313
Unnamed: 80.9560.5660.4760.3971.0000.0000.6020.4400.9560.5000.1560.2780.3620.364
Unnamed: 90.7780.5490.3730.2970.0001.0000.3140.4470.7780.5710.4980.4630.3960.358
Unnamed: 100.7300.5340.4040.1940.6020.3141.0000.2900.7300.5130.3690.4040.5020.411
Unnamed: 110.8890.6190.4360.3080.4400.4470.2901.0000.8890.4530.3690.4040.2830.348
Unnamed: 130.4840.9690.7370.9620.9560.7780.7300.8891.0000.9880.0000.8091.0000.916
Unnamed: 140.9880.5710.6850.5550.5000.5710.5130.4530.9881.0000.6390.6970.7100.489
Unnamed: 150.0000.4650.5200.0730.1560.4980.3690.3690.0000.6391.0000.6270.6180.438
Unnamed: 160.8090.8350.4710.3500.2780.4630.4040.4040.8090.6970.6271.0000.7340.559
Unnamed: 171.0000.8370.7290.1830.3620.3960.5020.2831.0000.7100.6180.7341.0000.739
Unnamed: 180.9160.8460.5660.3130.3640.3580.4110.3480.9160.4890.4380.5590.7391.000

Missing values

2024-03-14T09:58:51.370049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:58:51.549076image/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.
2024-03-14T09:58:51.796693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

2021년 토요프로그램 개설(운영) 현황(청소년수련관, 청소년문화의집)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
0NaN<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
1순지역프로그램 운영기관프로그램 운영장소프로그램명프로그램내용분야운영기간운영 요일운영 형태운영시간참여 대상참여\n인원수강료 (참가비)이동 수단식사 (간식) 제공운영 담당자<NA>운영기관주소 (새주소 기입)
2NaN<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA>이름연락처 (전화)<NA>
31전주솔내청소년수련관솔내청소년수련관 내솔내 토요예체능뉴스포츠 및 음악줄넘기 활동을 통한 체력증진예체능3월~11월토매월 2회09:30-11:00초15명무료자유없음기민주278-8588전주시 덕진구 동부대로 1079
42전주솔내청소년수련관솔내청소년수련관 내CHEER UP치어댄스를 배워보는 시간예체능3월~11월토매월 2회10:00-12:00초15명무료자유없음기민주278-8588전주시 덕진구 동부대로 1079
53전주솔내청소년수련관솔내청소년수련관 내청소년 드론축구드론축구를 배워보는 시간특기적성3월~11월토매월 2회10:00-12:00초15명무료자유없음기민주278-8588전주시 덕진구 동부대로 1079
64전주솔내청소년수련관솔내청소년수련관기후환경 프로그램기후환경 보호와 실천을 위한 프로그램체험활동6월~10월토기타10:00~12:00초.중.고15명무료자유없음기민주278-8588전주시 덕진구 동부대로 1079
75전주솔내청소년수련관솔내청소년수련관전주시 청소년시설 연합행사청소년축제 체험 및 문화행사 프로그램기타10월 23일토기타12:00~17:00초중고300명무료자유간식기민주278-8588전주시 덕진구 동부대로 1079
86전주솔내청소년수련관솔내청소년수련관, 덕일중, 전주 관내등공기정화프로젝트 맑게줍깅지역사회 변화에 참여하여 지역 환경 및 의식개선 활동체험활동4월~10월토기타13:00~15:00중,고40명무료자유간식임은종278-8588전주시 덕진구 동부대로 1079
97전주솔내청소년수련관솔내청소년수련관청소년 운영위원회청소년수련시설전반에 대한 모니터링 및 청소년 활동 활성화 유도기타1월~12월토기타11:00~14:00중,고16명무료자유간식임은종278-8588전주시 덕진구 동부대로 1079
2021년 토요프로그램 개설(운영) 현황(청소년수련관, 청소년문화의집)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18
8179전주효자청소년문화의집효자청소년문화의집 외 1곳조금불편해도괜찮아환경교육 및 실태조사체험활동2021년 7월~2022년 5월토10회기10:00-12:00중고10명무료버스간식최은영236-7144전주시 완산구 우전2길 22
8280전주효자청소년문화의집중앙살림광장청소년의달기념행사기념행사기타10월토1회기13:00-17:00초중고500명무료자유간식추진력236-7145전주시 완산구 우전2길 23
8381전주효자청소년문화의집효자청소년문화의집 외전주시동아리지원사업동아리활동지원예체능6~11월토상시14:00-16:00중고40명무료자유간식최은영236-7144전주시 완산구 우전2길 22
8482전주효자청소년문화의집효자청소년문화의집 외전라북도동아리지원사업어울림마당 공연 및 정기활동예체능6~11월토상시14:00-16:00중고20명무료자유간식최은영236-7144전주시 완산구 우전2길 22
85NaN<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
861) 교과학습 프로그램 : 국어, 영어, 수학, 사회, 과학, 한자, 역사(한국사), 논술, 공부방 등 학습중심 프로그램<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
872) 특기적성 프로그램 : 독서, 컴퓨터, 문학읽기토론, 토론, 기자체험, 리포터체험, 브레인게임, 상담, 심리검사, 과학실험, 성교육, 인성교육, 창의력향상, 놀이마당, 대학생멘토링, 바둑, 보드게임, 리더쉽, \n 웅변, 교양강좌, NIE, 로봇교실, 레고, 청소년기자단, 마술 등<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
883) 예체능 프로그램 : 미술, 손글씨, 찰흙, 기타, 댄스, 페이스페인팅, 리본, 비즈, 비누, 동화, 서예, 종이접기, 동화구연, 사진동아리, 사물놀이, 줄넘기, 축구, 수영, 사격, 요트 등<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
894) 체험활동 프로그램 : 농사체험, 생태체험, 환경지킴이봉사, 환경테마체험, 봉사활동, 전통나전칠기, 예절교육, 보물찾기, 향토역사관탐방, 박물관견학 등<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>
905) 기타 프로그램 : 학교폭력예방, 인터넷중독예방, 웃음치료, 비전형성, 문제행동개입, 인증제프로그램, 이동수련관, 사랑의 산타원정대, 신난DAY, 지역아동센터, 돌봄프로그램 등<NA><NA><NA><NA><NA><NA>NaN<NA><NA><NA><NA>NaN<NA><NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18# duplicates
0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>7