Overview

Dataset statistics

Number of variables6
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory55.5 B

Variable types

Categorical3
DateTime2
Numeric1

Dataset

Description전북특별자치도 전주시의 월별 코로나 19 확진자 및 사망자수 현황입니다. 발생연월, 확진자수, 사망자수를 제공합니다.항목 : 시도명, 시군구명, 발생연월, 확진자수, 사망자수, 데이터기준일자담당부서 : 보건소 감염병관리과
Author전북특별자치도 전주시
URLhttps://www.data.go.kr/data/15098847/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
확진자 수(명) is highly overall correlated with 사망자 수(명)High correlation
사망자 수(명) is highly overall correlated with 확진자 수(명)High correlation
발생연월 has unique valuesUnique
확진자 수(명) has 2 (8.3%) zerosZeros

Reproduction

Analysis started2024-04-17 15:00:15.908851
Analysis finished2024-04-17 15:00:16.236439
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
전북특별자치도
24 

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 (%)
전북특별자치도 24
100.0%

Length

2024-04-18T00:00:16.283298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:00:16.350098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전북특별자치도 24
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
전주시
24 

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 (%)
전주시 24
100.0%

Length

2024-04-18T00:00:16.423313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:00:16.494043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전주시 24
100.0%

발생연월
Date

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2020-02-01 00:00:00
Maximum2022-01-01 00:00:00
2024-04-18T00:00:16.554650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T00:00:16.638785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)

확진자 수(명)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct22
Distinct (%)91.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean245.45833
Minimum0
Maximum2393
Zeros2
Zeros (%)8.3%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-18T00:00:16.741965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.15
Q18.75
median51.5
Q3178
95-th percentile1109.95
Maximum2393
Range2393
Interquartile range (IQR)169.25

Descriptive statistics

Standard deviation527.78561
Coefficient of variation (CV)2.1502045
Kurtosis12.742333
Mean245.45833
Median Absolute Deviation (MAD)51
Skewness3.4489713
Sum5891
Variance278557.65
MonotonicityNot monotonic
2024-04-18T00:00:16.857048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
2 2
 
8.3%
0 2
 
8.3%
1 1
 
4.2%
54 1
 
4.2%
2393 1
 
4.2%
1225 1
 
4.2%
374 1
 
4.2%
229 1
 
4.2%
458 1
 
4.2%
369 1
 
4.2%
Other values (12) 12
50.0%
ValueCountFrequency (%)
0 2
8.3%
1 1
4.2%
2 2
8.3%
5 1
4.2%
10 1
4.2%
13 1
4.2%
26 1
4.2%
34 1
4.2%
37 1
4.2%
49 1
4.2%
ValueCountFrequency (%)
2393 1
4.2%
1225 1
4.2%
458 1
4.2%
374 1
4.2%
369 1
4.2%
229 1
4.2%
161 1
4.2%
151 1
4.2%
109 1
4.2%
105 1
4.2%

사망자 수(명)
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
0
14 
1
6 
6
2 
2
 
1
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)8.3%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 14
58.3%
1 6
25.0%
6 2
 
8.3%
2 1
 
4.2%
4 1
 
4.2%

Length

2024-04-18T00:00:16.947960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T00:00:17.024368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 14
58.3%
1 6
25.0%
6 2
 
8.3%
2 1
 
4.2%
4 1
 
4.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2023-11-09 00:00:00
Maximum2023-11-09 00:00:00
2024-04-18T00:00:17.093072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T00:00:17.162348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-18T00:00:16.005393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-18T00:00:17.212133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발생연월확진자 수(명)사망자 수(명)
발생연월1.0001.0001.000
확진자 수(명)1.0001.0000.643
사망자 수(명)1.0000.6431.000
2024-04-18T00:00:17.278219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
확진자 수(명)사망자 수(명)
확진자 수(명)1.0000.553
사망자 수(명)0.5531.000

Missing values

2024-04-18T00:00:16.107245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-18T00:00:16.192116image/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

시도명시군구명발생연월확진자 수(명)사망자 수(명)데이터기준일자
0전북특별자치도전주시2020-02-01102023-11-09
1전북특별자치도전주시2020-03-01502023-11-09
2전북특별자치도전주시2020-04-01202023-11-09
3전북특별자치도전주시2020-05-01002023-11-09
4전북특별자치도전주시2020-06-01202023-11-09
5전북특별자치도전주시2020-07-01002023-11-09
6전북특별자치도전주시2020-08-012602023-11-09
7전북특별자치도전주시2020-09-011302023-11-09
8전북특별자치도전주시2020-10-011002023-11-09
9전북특별자치도전주시2020-11-013412023-11-09
시도명시군구명발생연월확진자 수(명)사망자 수(명)데이터기준일자
14전북특별자치도전주시2021-04-0115102023-11-09
15전북특별자치도전주시2021-05-015402023-11-09
16전북특별자치도전주시2021-06-014912023-11-09
17전북특별자치도전주시2021-07-0110512023-11-09
18전북특별자치도전주시2021-08-0136902023-11-09
19전북특별자치도전주시2021-09-0145812023-11-09
20전북특별자치도전주시2021-10-0122922023-11-09
21전북특별자치도전주시2021-11-0137442023-11-09
22전북특별자치도전주시2021-12-01122562023-11-09
23전북특별자치도전주시2022-01-01239362023-11-09