Overview

Dataset statistics

Number of variables10
Number of observations96
Missing cells384
Missing cells (%)40.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.0 KiB
Average record size in memory85.4 B

Variable types

Categorical5
Text1
Unsupported4

Dataset

Description경상남도 김해시 통합도서관 내의 전자책도서관 홈페이지 개방 가능 DB 정보 입니다.
Author경상남도 김해시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15063870

Alerts

운영부서 has constant value ""Constant
정보시스템명 has constant value ""Constant
DB명 has constant value ""Constant
한글 테이블명 is highly overall correlated with 영문 테이블명High correlation
영문 테이블명 is highly overall correlated with 한글 테이블명High correlation
Unnamed: 6 has 96 (100.0%) missing valuesMissing
Unnamed: 7 has 96 (100.0%) missing valuesMissing
Unnamed: 8 has 96 (100.0%) missing valuesMissing
Unnamed: 9 has 96 (100.0%) missing valuesMissing
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

Reproduction

Analysis started2023-12-11 00:18:23.311526
Analysis finished2023-12-11 00:18:23.750495
Duration0.44 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

운영부서
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size900.0 B
인재육성지원과
96 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인재육성지원과
2nd row인재육성지원과
3rd row인재육성지원과
4th row인재육성지원과
5th row인재육성지원과

Common Values

ValueCountFrequency (%)
인재육성지원과 96
100.0%

Length

2023-12-11T09:18:23.815015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:18:23.901309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인재육성지원과 96
100.0%

정보시스템명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size900.0 B
김해통합도서관_전자책도서관시스템
96 

Length

Max length17
Median length17
Mean length17
Min length17

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row김해통합도서관_전자책도서관시스템
2nd row김해통합도서관_전자책도서관시스템
3rd row김해통합도서관_전자책도서관시스템
4th row김해통합도서관_전자책도서관시스템
5th row김해통합도서관_전자책도서관시스템

Common Values

ValueCountFrequency (%)
김해통합도서관_전자책도서관시스템 96
100.0%

Length

2023-12-11T09:18:24.013171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:18:24.111100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
김해통합도서관_전자책도서관시스템 96
100.0%

DB명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size900.0 B
김해통합도서관_전자책도서관시스템_DB
96 

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row김해통합도서관_전자책도서관시스템_DB
2nd row김해통합도서관_전자책도서관시스템_DB
3rd row김해통합도서관_전자책도서관시스템_DB
4th row김해통합도서관_전자책도서관시스템_DB
5th row김해통합도서관_전자책도서관시스템_DB

Common Values

ValueCountFrequency (%)
김해통합도서관_전자책도서관시스템_DB 96
100.0%

Length

2023-12-11T09:18:24.221261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:18:24.336565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
김해통합도서관_전자책도서관시스템_db 96
100.0%

영문 테이블명
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)13.5%
Missing0
Missing (%)0.0%
Memory size900.0 B
fx_product
23 
fx_product_meta
12 
fx_program
11 
fx_program_meta
9 
fx_product_class
7 
Other values (8)
34 

Length

Max length17
Median length16
Mean length12.1875
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowfx_supplier
2nd rowfx_supplier
3rd rowfx_supplier
4th rowfx_supplier
5th rowfx_sub_class

Common Values

ValueCountFrequency (%)
fx_product 23
24.0%
fx_product_meta 12
12.5%
fx_program 11
11.5%
fx_program_meta 9
 
9.4%
fx_product_class 7
 
7.3%
fx_class 6
 
6.2%
fx_sub_class 5
 
5.2%
fx_supplier 4
 
4.2%
fx_publisher 4
 
4.2%
fx_product_author 4
 
4.2%
Other values (3) 11
11.5%

Length

2023-12-11T09:18:24.464550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
fx_product 23
24.0%
fx_product_meta 12
12.5%
fx_program 11
11.5%
fx_program_meta 9
 
9.4%
fx_product_class 7
 
7.3%
fx_class 6
 
6.2%
fx_sub_class 5
 
5.2%
fx_supplier 4
 
4.2%
fx_publisher 4
 
4.2%
fx_product_author 4
 
4.2%
Other values (3) 11
11.5%

한글 테이블명
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)13.5%
Missing0
Missing (%)0.0%
Memory size900.0 B
도서테이블
23 
공급사별도서열람정보테이블
12 
도서 분철 테이블
11 
도서열람정보연동테이블
9 
도서카테고리분류테이블
7 
Other values (8)
34 

Length

Max length14
Median length13
Mean length9.4583333
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도서 공급사 정보테이블
2nd row도서 공급사 정보테이블
3rd row도서 공급사 정보테이블
4th row도서 공급사 정보테이블
5th row도서소분류카테고리테이블

Common Values

ValueCountFrequency (%)
도서테이블 23
24.0%
공급사별도서열람정보테이블 12
12.5%
도서 분철 테이블 11
11.5%
도서열람정보연동테이블 9
 
9.4%
도서카테고리분류테이블 7
 
7.3%
도서메뉴카테고리테이블 6
 
6.2%
도서소분류카테고리테이블 5
 
5.2%
도서 공급사 정보테이블 4
 
4.2%
출판사 테이블 4
 
4.2%
도서에대한저자정보참조테이블 4
 
4.2%
Other values (3) 11
11.5%

Length

2023-12-11T09:18:24.670565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
도서테이블 23
17.7%
도서 15
11.5%
테이블 15
11.5%
공급사별도서열람정보테이블 12
9.2%
분철 11
8.5%
도서열람정보연동테이블 9
 
6.9%
도서카테고리분류테이블 7
 
5.4%
도서메뉴카테고리테이블 6
 
4.6%
도서소분류카테고리테이블 5
 
3.8%
공급사 4
 
3.1%
Other values (6) 23
17.7%

한글 컬럼명
Text

Distinct56
Distinct (%)58.3%
Missing0
Missing (%)0.0%
Memory size900.0 B
2023-12-11T09:18:24.949751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length6.0520833
Min length2

Characters and Unicode

Total characters581
Distinct characters85
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

Unique33 ?
Unique (%)34.4%

Sample

1st row공급사번호
2nd row공급사명
3rd row공급사코드
4th row공급사설명
5th row카테고리타입코드
ValueCountFrequency (%)
전자도서번호 6
 
6.2%
카테고리타입코드 5
 
5.2%
대분류코드 5
 
5.2%
공급사코드 4
 
4.2%
중분류코드 4
 
4.2%
공급사전자도서번호 4
 
4.2%
소분류코드 3
 
3.1%
전자도서열람가능여부 2
 
2.1%
전자도서파일크기 2
 
2.1%
큰표지이미지 2
 
2.1%
Other values (46) 59
61.5%
2023-12-11T09:18:25.332879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
자 33
 
5.7%
서 30
 
5.2%
드 29
 
5.0%
도 28
 
4.8%
코 27
 
4.6%
전 23
 
4.0%
호 19
 
3.3%
번 18
 
3.1%
사 18
 
3.1%
분 16
 
2.8%
Other values (75) 340
58.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 581
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
자 33
 
5.7%
서 30
 
5.2%
드 29
 
5.0%
도 28
 
4.8%
코 27
 
4.6%
전 23
 
4.0%
호 19
 
3.3%
번 18
 
3.1%
사 18
 
3.1%
분 16
 
2.8%
Other values (75) 340
58.5%

Most occurring scripts

ValueCountFrequency (%)
Hangul 581
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
자 33
 
5.7%
서 30
 
5.2%
드 29
 
5.0%
도 28
 
4.8%
코 27
 
4.6%
전 23
 
4.0%
호 19
 
3.3%
번 18
 
3.1%
사 18
 
3.1%
분 16
 
2.8%
Other values (75) 340
58.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 581
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
자 33
 
5.7%
서 30
 
5.2%
드 29
 
5.0%
도 28
 
4.8%
코 27
 
4.6%
전 23
 
4.0%
호 19
 
3.3%
번 18
 
3.1%
사 18
 
3.1%
분 16
 
2.8%
Other values (75) 340
58.5%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing96
Missing (%)100.0%
Memory size996.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing96
Missing (%)100.0%
Memory size996.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing96
Missing (%)100.0%
Memory size996.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing96
Missing (%)100.0%
Memory size996.0 B

Correlations

2023-12-11T09:18:25.444831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영문 테이블명한글 테이블명한글 컬럼명
영문 테이블명1.0001.0000.000
한글 테이블명1.0001.0000.000
한글 컬럼명0.0000.0001.000
2023-12-11T09:18:25.525840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
한글 테이블명영문 테이블명
한글 테이블명1.0001.000
영문 테이블명1.0001.000
2023-12-11T09:18:25.628691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영문 테이블명한글 테이블명
영문 테이블명1.0001.000
한글 테이블명1.0001.000

Missing values

2023-12-11T09:18:23.525628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:18:23.693313image/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

운영부서정보시스템명DB명영문 테이블명한글 테이블명한글 컬럼명Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
0인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_supplier도서 공급사 정보테이블공급사번호<NA><NA><NA><NA>
1인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_supplier도서 공급사 정보테이블공급사명<NA><NA><NA><NA>
2인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_supplier도서 공급사 정보테이블공급사코드<NA><NA><NA><NA>
3인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_supplier도서 공급사 정보테이블공급사설명<NA><NA><NA><NA>
4인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_sub_class도서소분류카테고리테이블카테고리타입코드<NA><NA><NA><NA>
5인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_sub_class도서소분류카테고리테이블대분류코드<NA><NA><NA><NA>
6인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_sub_class도서소분류카테고리테이블중분류코드<NA><NA><NA><NA>
7인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_sub_class도서소분류카테고리테이블소분류코드<NA><NA><NA><NA>
8인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_sub_class도서소분류카테고리테이블소분류명<NA><NA><NA><NA>
9인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_publisher출판사 테이블출판사코드<NA><NA><NA><NA>
운영부서정보시스템명DB명영문 테이블명한글 테이블명한글 컬럼명Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
86인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블카테고리타입코드<NA><NA><NA><NA>
87인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블대분류코드<NA><NA><NA><NA>
88인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블중분류코드<NA><NA><NA><NA>
89인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블소분류코드<NA><NA><NA><NA>
90인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블도서이용여부<NA><NA><NA><NA>
91인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_class도서메뉴카테고리테이블소팅번호<NA><NA><NA><NA>
92인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_author저자테이블저자코드<NA><NA><NA><NA>
93인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_author저자테이블저자명<NA><NA><NA><NA>
94인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_author저자테이블공급사저자코드<NA><NA><NA><NA>
95인재육성지원과김해통합도서관_전자책도서관시스템김해통합도서관_전자책도서관시스템_DBfx_author저자테이블저자설명<NA><NA><NA><NA>