Overview

Dataset statistics

Number of variables10
Number of observations418
Missing cells1254
Missing cells (%)30.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory34.4 KiB
Average record size in memory84.3 B

Variable types

Numeric1
Text1
Categorical3
DateTime2
Unsupported3

Dataset

Description충청남도 내에 운영 중인 작은도서관에 대한 데이터로, 도서관명, 지역, 개관일, 운영유형 등에 대한 내용을 담고 있습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=301&beforeMenuCd=DOM_000000201001001000&publicdatapk=15095054

Alerts

작성기준일 has constant value ""Constant
운영현황 is highly imbalanced (57.0%)Imbalance
Unnamed: 7 has 418 (100.0%) missing valuesMissing
Unnamed: 8 has 418 (100.0%) missing valuesMissing
Unnamed: 9 has 418 (100.0%) missing valuesMissing
연번 has unique valuesUnique
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-09 20:41:10.447989
Analysis finished2024-01-09 20:41:11.024861
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct418
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean209.5
Minimum1
Maximum418
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.8 KiB
2024-01-10T05:41:11.094237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile21.85
Q1105.25
median209.5
Q3313.75
95-th percentile397.15
Maximum418
Range417
Interquartile range (IQR)208.5

Descriptive statistics

Standard deviation120.81046
Coefficient of variation (CV)0.5766609
Kurtosis-1.2
Mean209.5
Median Absolute Deviation (MAD)104.5
Skewness0
Sum87571
Variance14595.167
MonotonicityStrictly increasing
2024-01-10T05:41:11.243264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
315 1
 
0.2%
287 1
 
0.2%
286 1
 
0.2%
285 1
 
0.2%
284 1
 
0.2%
283 1
 
0.2%
282 1
 
0.2%
281 1
 
0.2%
280 1
 
0.2%
Other values (408) 408
97.6%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
418 1
0.2%
417 1
0.2%
416 1
0.2%
415 1
0.2%
414 1
0.2%
413 1
0.2%
412 1
0.2%
411 1
0.2%
410 1
0.2%
409 1
0.2%

도서관명
Text

Distinct410
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
2024-01-10T05:41:11.502926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length9.6674641
Min length4

Characters and Unicode

Total characters4041
Distinct characters365
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique403 ?
Unique (%)96.4%

Sample

1st row갯마을 작은도서관
2nd row경남아너스빌 작은도서관
3rd row계룡책향기작은도서관
4th row고대웃음꽃 작은도서관
5th row고덕작은도서관
ValueCountFrequency (%)
작은도서관 174
 
26.6%
도서관 10
 
1.5%
공립 6
 
0.9%
열린작은도서관 3
 
0.5%
북카페 3
 
0.5%
상록수 3
 
0.5%
문고 3
 
0.5%
꿈꾸는 2
 
0.3%
숲 2
 
0.3%
e편한세상 2
 
0.3%
Other values (440) 446
68.2%
2024-01-10T05:41:11.895823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
서 409
 
10.1%
도 397
 
9.8%
관 393
 
9.7%
은 329
 
8.1%
작 322
 
8.0%
237
 
5.9%
아 56
 
1.4%
이 45
 
1.1%
문 45
 
1.1%
산 36
 
0.9%
Other values (355) 1772
43.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3726
92.2%
Space Separator 237
 
5.9%
Decimal Number 41
 
1.0%
Uppercase Letter 21
 
0.5%
Open Punctuation 5
 
0.1%
Close Punctuation 5
 
0.1%
Lowercase Letter 4
 
0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 409
 
11.0%
도 397
 
10.7%
관 393
 
10.5%
은 329
 
8.8%
작 322
 
8.6%
아 56
 
1.5%
이 45
 
1.2%
문 45
 
1.2%
산 36
 
1.0%
성 35
 
0.9%
Other values (333) 1659
44.5%
Decimal Number
ValueCountFrequency (%)
3 9
22.0%
1 9
22.0%
2 8
19.5%
4 5
12.2%
5 5
12.2%
6 2
 
4.9%
8 2
 
4.9%
7 1
 
2.4%
Uppercase Letter
ValueCountFrequency (%)
L 6
28.6%
H 4
19.0%
A 3
14.3%
S 2
 
9.5%
D 2
 
9.5%
C 2
 
9.5%
Y 1
 
4.8%
K 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
@ 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
237
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3724
92.2%
Common 290
 
7.2%
Latin 25
 
0.6%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 409
 
11.0%
도 397
 
10.7%
관 393
 
10.6%
은 329
 
8.8%
작 322
 
8.6%
아 56
 
1.5%
이 45
 
1.2%
문 45
 
1.2%
산 36
 
1.0%
성 35
 
0.9%
Other values (331) 1657
44.5%
Common
ValueCountFrequency (%)
237
81.7%
3 9
 
3.1%
1 9
 
3.1%
2 8
 
2.8%
4 5
 
1.7%
5 5
 
1.7%
( 5
 
1.7%
) 5
 
1.7%
6 2
 
0.7%
8 2
 
0.7%
Other values (3) 3
 
1.0%
Latin
ValueCountFrequency (%)
L 6
24.0%
e 4
16.0%
H 4
16.0%
A 3
12.0%
S 2
 
8.0%
D 2
 
8.0%
C 2
 
8.0%
Y 1
 
4.0%
K 1
 
4.0%
Han
ValueCountFrequency (%)
大 1
50.0%
光 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3724
92.2%
ASCII 315
 
7.8%
CJK 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
서 409
 
11.0%
도 397
 
10.7%
관 393
 
10.6%
은 329
 
8.8%
작 322
 
8.6%
아 56
 
1.5%
이 45
 
1.2%
문 45
 
1.2%
산 36
 
1.0%
성 35
 
0.9%
Other values (331) 1657
44.5%
ASCII
ValueCountFrequency (%)
237
75.2%
3 9
 
2.9%
1 9
 
2.9%
2 8
 
2.5%
L 6
 
1.9%
4 5
 
1.6%
5 5
 
1.6%
( 5
 
1.6%
) 5
 
1.6%
e 4
 
1.3%
Other values (12) 22
 
7.0%
CJK
ValueCountFrequency (%)
大 1
50.0%
光 1
50.0%

지역
Categorical

Distinct15
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
아산시
96 
천안시
80 
서산시
37 
보령시
34 
당진시
32 
Other values (10)
139 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서산시
2nd row홍성군
3rd row공주시
4th row당진시
5th row예산군

Common Values

ValueCountFrequency (%)
아산시 96
23.0%
천안시 80
19.1%
서산시 37
 
8.9%
보령시 34
 
8.1%
당진시 32
 
7.7%
논산시 25
 
6.0%
공주시 24
 
5.7%
예산군 15
 
3.6%
부여군 15
 
3.6%
서천군 15
 
3.6%
Other values (5) 45
10.8%

Length

2024-01-10T05:41:12.015674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
아산시 96
23.0%
천안시 80
19.1%
서산시 37
 
8.9%
보령시 34
 
8.1%
당진시 32
 
7.7%
논산시 25
 
6.0%
공주시 24
 
5.7%
예산군 15
 
3.6%
부여군 15
 
3.6%
서천군 15
 
3.6%
Other values (5) 45
10.8%

개관일
Date

Distinct376
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
Minimum1992-05-10 00:00:00
Maximum2020-12-31 00:00:00
2024-01-10T05:41:12.122095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:41:12.234353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

운영유형
Categorical

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
사립
344 
공립
74 

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 (%)
사립 344
82.3%
공립 74
 
17.7%

Length

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

Common Values (Plot)

2024-01-10T05:41:12.428267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사립 344
82.3%
공립 74
 
17.7%

운영현황
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
운영
358 
휴관
51 
폐관
 
9

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 (%)
운영 358
85.6%
휴관 51
 
12.2%
폐관 9
 
2.2%

Length

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

Common Values (Plot)

2024-01-10T05:41:12.607697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
운영 358
85.6%
휴관 51
 
12.2%
폐관 9
 
2.2%

작성기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.4 KiB
Minimum2021-01-01 00:00:00
Maximum2021-01-01 00:00:00
2024-01-10T05:41:12.682928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:41:12.773143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing418
Missing (%)100.0%
Memory size3.8 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing418
Missing (%)100.0%
Memory size3.8 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing418
Missing (%)100.0%
Memory size3.8 KiB

Interactions

2024-01-10T05:41:10.748960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:41:12.841424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번지역운영유형운영현황
연번1.0000.1760.4080.177
지역0.1761.0000.2160.313
운영유형0.4080.2161.0000.073
운영현황0.1770.3130.0731.000
2024-01-10T05:41:12.928310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운영유형운영현황지역
운영유형1.0000.1200.194
운영현황0.1201.0000.148
지역0.1940.1481.000
2024-01-10T05:41:13.004781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번지역운영유형운영현황
연번1.0000.0650.3100.105
지역0.0651.0000.1940.148
운영유형0.3100.1941.0000.120
운영현황0.1050.1480.1201.000

Missing values

2024-01-10T05:41:10.852843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:41:10.977843image/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

연번도서관명지역개관일운영유형운영현황작성기준일Unnamed: 7Unnamed: 8Unnamed: 9
01갯마을 작은도서관서산시2019-04-30사립운영2021-01-01<NA><NA><NA>
12경남아너스빌 작은도서관홍성군2017-11-16사립운영2021-01-01<NA><NA><NA>
23계룡책향기작은도서관공주시2015-07-01공립운영2021-01-01<NA><NA><NA>
34고대웃음꽃 작은도서관당진시2007-01-25공립운영2021-01-01<NA><NA><NA>
45고덕작은도서관예산군2016-10-31공립운영2021-01-01<NA><NA><NA>
56고맙습니다성정1동 작은도서관천안시2012-12-24공립운영2021-01-01<NA><NA><NA>
67고북 작은도서관서산시2010-12-23공립운영2021-01-01<NA><NA><NA>
78고운라피네 작은도서관서산시2019-02-01사립운영2021-01-01<NA><NA><NA>
89골드클래스 작은도서관서산시2019-04-23사립휴관2021-01-01<NA><NA><NA>
910곰돌이작은도서관천안시2014-01-06사립운영2021-01-01<NA><NA><NA>
연번도서관명지역개관일운영유형운영현황작성기준일Unnamed: 7Unnamed: 8Unnamed: 9
408409CACS작은도서관천안시2018-04-18사립운영2021-01-01<NA><NA><NA>
409410e편한세상 서산예천 작은도서관서산시2018-02-09사립운영2021-01-01<NA><NA><NA>
410411e편한세상 작은도서관보령시2019-10-15사립휴관2021-01-01<NA><NA><NA>
411412e편한세상두정3차작은도서관천안시2018-01-26사립운영2021-01-01<NA><NA><NA>
412413KLA교육 작은도서관아산시2016-11-11사립운영2021-01-01<NA><NA><NA>
413414LH 꿈둥지도서관부여군2020-10-06사립운영2021-01-01<NA><NA><NA>
414415YAD 도서관천안시2020-07-24사립운영2021-01-01<NA><NA><NA>
4154163585부대 1대대 북까페천안시2019-03-18사립휴관2021-01-01<NA><NA><NA>
416417414 SDL 작은도서관보령시2020-06-03사립운영2021-01-01<NA><NA><NA>
417418大光작은도서관천안시2014-08-29사립운영2021-01-01<NA><NA><NA>