Overview

Dataset statistics

Number of variables11
Number of observations31
Missing cells217
Missing cells (%)63.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory99.3 B

Variable types

Categorical2
Text2
Unsupported7

Dataset

Description의왕시 내 사립 작은 도서관 현황 데이터로 동별도서관현황, 도서관명, 주소 등을 제공하는 것으로 공공기관의 도서관 외에 어린이 들이 이용할수 있는 사립 작은 도서관입니다
Author경기도 의왕시
URLhttps://www.data.go.kr/data/15100256/fileData.do

Alerts

시군명 is highly imbalanced (79.4%)Imbalance
Unnamed: 4 has 31 (100.0%) missing valuesMissing
Unnamed: 5 has 31 (100.0%) missing valuesMissing
Unnamed: 6 has 31 (100.0%) missing valuesMissing
Unnamed: 7 has 31 (100.0%) missing valuesMissing
Unnamed: 8 has 31 (100.0%) missing valuesMissing
Unnamed: 9 has 31 (100.0%) missing valuesMissing
Unnamed: 10 has 31 (100.0%) missing valuesMissing
도서관명 has unique valuesUnique
도로명주소 has unique valuesUnique
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 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: 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
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 13:25:44.987240
Analysis finished2023-12-12 13:25:45.547280
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

IMBALANCE 

Distinct2
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size380.0 B
의왕시
30 
의왕시
 
1

Length

Max length4
Median length3
Mean length3.0322581
Min length3

Unique

Unique1 ?
Unique (%)3.2%

Sample

1st row의왕시
2nd row의왕시
3rd row의왕시
4th row의왕시
5th row의왕시

Common Values

ValueCountFrequency (%)
의왕시 30
96.8%
의왕시 1
 
3.2%

Length

2023-12-12T22:25:45.628573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:25:45.731817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의왕시 31
100.0%

동별
Categorical

Distinct6
Distinct (%)19.4%
Missing0
Missing (%)0.0%
Memory size380.0 B
청계동
10 
오전동
9 
고천동
4 
내손2동
4 
부곡동
2 

Length

Max length4
Median length3
Mean length3.1935484
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고천동
2nd row고천동
3rd row고천동
4th row고천동
5th row부곡동

Common Values

ValueCountFrequency (%)
청계동 10
32.3%
오전동 9
29.0%
고천동 4
 
12.9%
내손2동 4
 
12.9%
부곡동 2
 
6.5%
내손1동 2
 
6.5%

Length

2023-12-12T22:25:45.851947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:25:45.988792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청계동 10
32.3%
오전동 9
29.0%
고천동 4
 
12.9%
내손2동 4
 
12.9%
부곡동 2
 
6.5%
내손1동 2
 
6.5%

도서관명
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T22:25:46.184282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length12
Mean length8.3225806
Min length4

Characters and Unicode

Total characters258
Distinct characters96
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row포은작은도서관
2nd row솔거문고
3rd row글누리작은도서관
4th row행복작은도서관
5th row들고지작은도서관
ValueCountFrequency (%)
작은도서관 8
 
17.8%
도서관 3
 
6.7%
이음도서관 1
 
2.2%
동아에코빌 1
 
2.2%
에버하임도서관 1
 
2.2%
뒷동네 1
 
2.2%
로뎀나무 1
 
2.2%
포일숲속마을1단지도서관 1
 
2.2%
숲속옹달샘도서관 1
 
2.2%
포은작은도서관 1
 
2.2%
Other values (26) 26
57.8%
2023-12-12T22:25:46.896632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
도 31
 
12.0%
서 29
 
11.2%
관 29
 
11.2%
은 19
 
7.4%
작 18
 
7.0%
14
 
5.4%
숲 4
 
1.6%
이 4
 
1.6%
트 3
 
1.2%
로 3
 
1.2%
Other values (86) 104
40.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 243
94.2%
Space Separator 14
 
5.4%
Decimal Number 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 31
 
12.8%
서 29
 
11.9%
관 29
 
11.9%
은 19
 
7.8%
작 18
 
7.4%
숲 4
 
1.6%
이 4
 
1.6%
트 3
 
1.2%
로 3
 
1.2%
란 3
 
1.2%
Other values (84) 100
41.2%
Space Separator
ValueCountFrequency (%)
14
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 243
94.2%
Common 15
 
5.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 31
 
12.8%
서 29
 
11.9%
관 29
 
11.9%
은 19
 
7.8%
작 18
 
7.4%
숲 4
 
1.6%
이 4
 
1.6%
트 3
 
1.2%
로 3
 
1.2%
란 3
 
1.2%
Other values (84) 100
41.2%
Common
ValueCountFrequency (%)
14
93.3%
1 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 243
94.2%
ASCII 15
 
5.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
도 31
 
12.8%
서 29
 
11.9%
관 29
 
11.9%
은 19
 
7.8%
작 18
 
7.4%
숲 4
 
1.6%
이 4
 
1.6%
트 3
 
1.2%
로 3
 
1.2%
란 3
 
1.2%
Other values (84) 100
41.2%
ASCII
ValueCountFrequency (%)
14
93.3%
1 1
 
6.7%

도로명주소
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2023-12-12T22:25:47.261660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length41
Mean length36.064516
Min length14

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row경기도 의왕시 위인로 15, 관리소 지하1층 (왕곡동, 포은아파트)
2nd row경기도 의왕시 위인로 18, 경비실 (왕곡동, 솔거아파트)
3rd row경기도 의왕시 오전천로 16, 덕은빌딩 402호 (고천동 305-1)
4th row경기도 의왕시 행복마을3로18, 109동 1층 에듀센터
5th row경기도 의왕시 교동길 27
ValueCountFrequency (%)
의왕시 32
 
13.5%
경기도 31
 
13.1%
오전동 9
 
3.8%
지하1층 7
 
3.0%
1층 6
 
2.5%
관리소 6
 
2.5%
포일숲속마을 5
 
2.1%
2층 5
 
2.1%
포일동 5
 
2.1%
포일세거리로 4
 
1.7%
Other values (110) 127
53.6%
2023-12-12T22:25:47.743835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
207
 
18.5%
왕 36
 
3.2%
1 36
 
3.2%
의 34
 
3.0%
경 33
 
3.0%
시 33
 
3.0%
도 32
 
2.9%
기 31
 
2.8%
동 31
 
2.8%
로 28
 
2.5%
Other values (137) 617
55.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 681
60.9%
Space Separator 207
 
18.5%
Decimal Number 155
 
13.9%
Other Punctuation 28
 
2.5%
Open Punctuation 22
 
2.0%
Close Punctuation 22
 
2.0%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
왕 36
 
5.3%
의 34
 
5.0%
경 33
 
4.8%
시 33
 
4.8%
도 32
 
4.7%
기 31
 
4.6%
동 31
 
4.6%
로 28
 
4.1%
지 20
 
2.9%
층 20
 
2.9%
Other values (122) 383
56.2%
Decimal Number
ValueCountFrequency (%)
1 36
23.2%
2 22
14.2%
6 19
12.3%
5 15
9.7%
8 13
 
8.4%
3 13
 
8.4%
0 12
 
7.7%
4 12
 
7.7%
7 7
 
4.5%
9 6
 
3.9%
Space Separator
ValueCountFrequency (%)
207
100.0%
Other Punctuation
ValueCountFrequency (%)
, 28
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 681
60.9%
Common 437
39.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
왕 36
 
5.3%
의 34
 
5.0%
경 33
 
4.8%
시 33
 
4.8%
도 32
 
4.7%
기 31
 
4.6%
동 31
 
4.6%
로 28
 
4.1%
지 20
 
2.9%
층 20
 
2.9%
Other values (122) 383
56.2%
Common
ValueCountFrequency (%)
207
47.4%
1 36
 
8.2%
, 28
 
6.4%
( 22
 
5.0%
2 22
 
5.0%
) 22
 
5.0%
6 19
 
4.3%
5 15
 
3.4%
8 13
 
3.0%
3 13
 
3.0%
Other values (5) 40
 
9.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 681
60.9%
ASCII 437
39.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
207
47.4%
1 36
 
8.2%
, 28
 
6.4%
( 22
 
5.0%
2 22
 
5.0%
) 22
 
5.0%
6 19
 
4.3%
5 15
 
3.4%
8 13
 
3.0%
3 13
 
3.0%
Other values (5) 40
 
9.2%
Hangul
ValueCountFrequency (%)
왕 36
 
5.3%
의 34
 
5.0%
경 33
 
4.8%
시 33
 
4.8%
도 32
 
4.7%
기 31
 
4.6%
동 31
 
4.6%
로 28
 
4.1%
지 20
 
2.9%
층 20
 
2.9%
Other values (122) 383
56.2%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing31
Missing (%)100.0%
Memory size411.0 B

Correlations

2023-12-12T22:25:47.861916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명동별도서관명도로명주소
시군명1.0000.0001.0001.000
동별0.0001.0001.0001.000
도서관명1.0001.0001.0001.000
도로명주소1.0001.0001.0001.000
2023-12-12T22:25:47.968765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명동별
시군명1.0000.000
동별0.0001.000
2023-12-12T22:25:48.064888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명동별
시군명1.0000.000
동별0.0001.000

Missing values

2023-12-12T22:25:45.319395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:25:45.491770image/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: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10
0의왕시고천동포은작은도서관경기도 의왕시 위인로 15, 관리소 지하1층 (왕곡동, 포은아파트)<NA><NA><NA><NA><NA><NA><NA>
1의왕시고천동솔거문고경기도 의왕시 위인로 18, 경비실 (왕곡동, 솔거아파트)<NA><NA><NA><NA><NA><NA><NA>
2의왕시고천동글누리작은도서관경기도 의왕시 오전천로 16, 덕은빌딩 402호 (고천동 305-1)<NA><NA><NA><NA><NA><NA><NA>
3의왕시고천동행복작은도서관경기도 의왕시 행복마을3로18, 109동 1층 에듀센터<NA><NA><NA><NA><NA><NA><NA>
4의왕시부곡동들고지작은도서관경기도 의왕시 교동길 27<NA><NA><NA><NA><NA><NA><NA>
5의왕시부곡동성결 작은도서관경기도 의왕시 신장승길 7, 부곡제일교회<NA><NA><NA><NA><NA><NA><NA>
6의왕시오전동풍림목련 작은도서관경기도 의왕시 오전로 163, 관리소 지하1층 (오전동, 목련아파트)<NA><NA><NA><NA><NA><NA><NA>
7의왕시오전동백합작은도서관경기도 의왕시 오전로 179, 관리소 지하1층 (오전동, 백합아파트)<NA><NA><NA><NA><NA><NA><NA>
8의왕시오전동모란작은도서관경기도 의왕시 모란길 5, 관리소 1층 (오전동, 모란아파트)<NA><NA><NA><NA><NA><NA><NA>
9의왕시오전동이화작은도서관경기도 의왕시 보식골로 6, 관리소 1층 (오전동, 성원1차이화아파트)<NA><NA><NA><NA><NA><NA><NA>
시군명동별도서관명도로명주소Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10
21의왕시청계동포일숲속마을1단지도서관경기도 의왕시 포일세거리로 23 포일숲속마을 1단지 (포일동 658)<NA><NA><NA><NA><NA><NA><NA>
22의왕시청계동숲속옹달샘도서관경기도 의왕시 이미로 17 포일숲속마을 2단지 209동 주민복지관 (포일동 652)<NA><NA><NA><NA><NA><NA><NA>
23의왕시청계동이음도서관경기도 의왕시 포일세거리로 95 포일숲속마을 3단지 306동 지하1층 커뮤니티센터 (포일동 645)<NA><NA><NA><NA><NA><NA><NA>
24의왕시청계동숲도서관경기도 의왕시 포일세거리로 73 포일숲속마을 4단지 커뮤니티센터 (포일동 646)<NA><NA><NA><NA><NA><NA><NA>
25의왕시청계동글빛도서관경기도 의왕시 포일세거리로 96 포일숲속마을 5단지 복지동 2층<NA><NA><NA><NA><NA><NA><NA>
26의왕시청계동사통이네 작은도서관경기도 의왕시 청계로 156, 2층<NA><NA><NA><NA><NA><NA><NA>
27의왕시청계동백운늘숲도서관경기도 의왕시 백운중앙로 46 (의왕백운해링턴플레이스 1단지)<NA><NA><NA><NA><NA><NA><NA>
28의왕시청계동반딧불작은도서관경기도 의왕시 백운중앙로 88 (의왕백운해링턴플레이스 5단지)<NA><NA><NA><NA><NA><NA><NA>
29의왕시청계동엘센트로 푸른도서관경기도 의왕시 안양판교로100 관리동 2층<NA><NA><NA><NA><NA><NA><NA>
30의왕시청계동새싹작은도서관경기도 의왕시 한직골서길11 가원빌딩 2층<NA><NA><NA><NA><NA><NA><NA>