Overview

Dataset statistics

Number of variables10
Number of observations22
Missing cells122
Missing cells (%)55.5%
Duplicate rows1
Duplicate rows (%)4.5%
Total size in memory1.8 KiB
Average record size in memory86.0 B

Variable types

Unsupported9
Text1

Dataset

Description2017년고혈압당뇨병등록관리사업현황
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=203019

Alerts

Unnamed: 9 has constant value ""Constant
Dataset has 1 (4.5%) duplicate rowsDuplicates
2017년 고혈압 당뇨병 등록관리사업 현황(진안군) has 9 (40.9%) missing valuesMissing
Unnamed: 1 has 7 (31.8%) missing valuesMissing
Unnamed: 2 has 8 (36.4%) missing valuesMissing
Unnamed: 3 has 6 (27.3%) missing valuesMissing
Unnamed: 4 has 15 (68.2%) missing valuesMissing
Unnamed: 5 has 10 (45.5%) missing valuesMissing
Unnamed: 6 has 13 (59.1%) missing valuesMissing
Unnamed: 7 has 16 (72.7%) missing valuesMissing
Unnamed: 8 has 17 (77.3%) missing valuesMissing
Unnamed: 9 has 21 (95.5%) missing valuesMissing
2017년 고혈압 당뇨병 등록관리사업 현황(진안군) is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
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

Reproduction

Analysis started2024-03-14 00:42:32.252769
Analysis finished2024-03-14 00:42:32.774333
Duration0.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2017년 고혈압 당뇨병 등록관리사업 현황(진안군)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing9
Missing (%)40.9%
Memory size308.0 B

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing7
Missing (%)31.8%
Memory size308.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)36.4%
Memory size308.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)27.3%
Memory size308.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing15
Missing (%)68.2%
Memory size308.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10
Missing (%)45.5%
Memory size308.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)59.1%
Memory size308.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing16
Missing (%)72.7%
Memory size308.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)77.3%
Memory size308.0 B

Unnamed: 9
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing21
Missing (%)95.5%
Memory size308.0 B
2024-03-14T09:42:32.835234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length5
Min length5

Characters and Unicode

Total characters5
Distinct characters5
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

Unique1 ?
Unique (%)100.0%

Sample

1st row만성콩팥병
ValueCountFrequency (%)
만성콩팥병 1
100.0%
2024-03-14T09:42:33.035527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
만 1
20.0%
성 1
20.0%
콩 1
20.0%
팥 1
20.0%
병 1
20.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
만 1
20.0%
성 1
20.0%
콩 1
20.0%
팥 1
20.0%
병 1
20.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
만 1
20.0%
성 1
20.0%
콩 1
20.0%
팥 1
20.0%
병 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
만 1
20.0%
성 1
20.0%
콩 1
20.0%
팥 1
20.0%
병 1
20.0%

Missing values

2024-03-14T09:42:32.342818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:42:32.479280image/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:42:32.625088image/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

2017년 고혈압 당뇨병 등록관리사업 현황(진안군)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
01. 참여의료기관(진안군)NaNNaN(단위 : 개소)NaNNaNNaNNaNNaN<NA>
1총계의원약국보건지소NaNNaNNaNNaNNaN<NA>
22911810NaNNaNNaNNaNNaN<NA>
3NaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>
42. 추진실적(진안군)NaNNaNNaNNaNNaNNaNNaNNaN<NA>
5구분등록비NaN본인부담금 지원(진료비,약제비)NaN중증 합병증 검사비 지원NaNNaNNaN<NA>
6NaN고혈압+당뇨병NaN고혈압+당뇨병NaN안질환NaN만성콩팥병NaN<NA>
7NaN명금액(원)명금액(원)명금액(원)명금액(원)<NA>
8계32483281000516727754527052652600003993990000<NA>
930~64세4241305000-0NaNNaNNaNNaN<NA>
2017년 고혈압 당뇨병 등록관리사업 현황(진안군)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
123. 환자본인부담금 및 병원 등록비 지원 개요NaNNaNNaNNaNNaNNaNNaNNaN<NA>
13기관보험구분30~64세NaNNaN65세 이상NaNNaN중증 합병등 검사비 지원(30세 이상)<NA>
14NaNNaN진료비약제비등록비진료비약제비등록비안질환만성콩팥병
15의원건강보험--인당\n5,000원\n/년인당 최대\n1,500원/월질병당 최대\n2,000원/월인당\n1,000원\n/년인당 10,000원/년<NA>
16NaN의료급여 2종--NaN인당 1,500원/월질병당 500원/월NaNNaN<NA>
17NaN의료급여 1종--NaN--NaNNaN<NA>
18보건기관\n(의약분업\n예외지역인\n경우)건강보험---인당 최대\n1,500원/월질병당 최대\n2,000원/월-NaN<NA>
19NaN의료급여 2종--NaN인당 1,500원/월질병당 500원/월NaNNaN<NA>
20NaN의료급여 1종--NaN--NaNNaN<NA>
21※ 환자 본인부담금이 진료비, 약제비 지원금보다 적은 경우, 실제 본인부담금만 지원NaNNaNNaNNaNNaNNaNNaNNaN<NA>

Duplicate rows

Most frequently occurring

Unnamed: 9# duplicates
0<NA>21