Overview

Dataset statistics

Number of variables8
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory75.0 B

Variable types

Numeric3
Categorical4
DateTime1

Dataset

Description충청남도 홍성군 코로나19 확진자 및 사망자 현황으로 시군,년,월, 확진자, 사망자 데이터 등의 항목을 제공합니다. 2023년 9월 이후 코로나19 감염병 등급 하향으로 현황을 집계하지 않습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=108&beforeMenuCd=DOM_000000201001001000&publicdatapk=15098899

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 확진자 and 1 other fieldsHigh correlation
확진자 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
년 is highly overall correlated with 연번High correlation
사망자 is highly overall correlated with 확진자High correlation
사망자 is highly imbalanced (55.8%)Imbalance
연번 has unique valuesUnique
확진자 has 3 (13.6%) zerosZeros

Reproduction

Analysis started2024-01-09 20:47:43.267388
Analysis finished2024-01-09 20:47:44.250789
Duration0.98 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.5
Minimum1
Maximum22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2024-01-10T05:47:44.300351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.05
Q16.25
median11.5
Q316.75
95-th percentile20.95
Maximum22
Range21
Interquartile range (IQR)10.5

Descriptive statistics

Standard deviation6.4935866
Coefficient of variation (CV)0.5646597
Kurtosis-1.2
Mean11.5
Median Absolute Deviation (MAD)5.5
Skewness0
Sum253
Variance42.166667
MonotonicityStrictly increasing
2024-01-10T05:47:44.405619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
1 1
 
4.5%
13 1
 
4.5%
22 1
 
4.5%
21 1
 
4.5%
20 1
 
4.5%
19 1
 
4.5%
18 1
 
4.5%
17 1
 
4.5%
16 1
 
4.5%
15 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
1 1
4.5%
2 1
4.5%
3 1
4.5%
4 1
4.5%
5 1
4.5%
6 1
4.5%
7 1
4.5%
8 1
4.5%
9 1
4.5%
10 1
4.5%
ValueCountFrequency (%)
22 1
4.5%
21 1
4.5%
20 1
4.5%
19 1
4.5%
18 1
4.5%
17 1
4.5%
16 1
4.5%
15 1
4.5%
14 1
4.5%
13 1
4.5%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
충청남도
22 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청남도
2nd row충청남도
3rd row충청남도
4th row충청남도
5th row충청남도

Common Values

ValueCountFrequency (%)
충청남도 22
100.0%

Length

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

Common Values (Plot)

2024-01-10T05:47:44.586792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 22
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
홍성군
22 

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 (%)
홍성군 22
100.0%

Length

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

Common Values (Plot)

2024-01-10T05:47:44.747086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
홍성군 22
100.0%

년
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size308.0 B
2021
12 
2020
10 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2021 12
54.5%
2020 10
45.5%

Length

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

Common Values (Plot)

2024-01-10T05:47:44.914477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 12
54.5%
2020 10
45.5%

월
Real number (ℝ)

Distinct12
Distinct (%)54.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.9545455
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2024-01-10T05:47:45.005760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.05
Q14.25
median7
Q39.75
95-th percentile11.95
Maximum12
Range11
Interquartile range (IQR)5.5

Descriptive statistics

Standard deviation3.3162985
Coefficient of variation (CV)0.47685337
Kurtosis-1.084046
Mean6.9545455
Median Absolute Deviation (MAD)3
Skewness-0.08545937
Sum153
Variance10.997835
MonotonicityNot monotonic
2024-01-10T05:47:45.095840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
3 2
9.1%
4 2
9.1%
5 2
9.1%
6 2
9.1%
7 2
9.1%
8 2
9.1%
9 2
9.1%
10 2
9.1%
11 2
9.1%
12 2
9.1%
Other values (2) 2
9.1%
ValueCountFrequency (%)
1 1
4.5%
2 1
4.5%
3 2
9.1%
4 2
9.1%
5 2
9.1%
6 2
9.1%
7 2
9.1%
8 2
9.1%
9 2
9.1%
10 2
9.1%
ValueCountFrequency (%)
12 2
9.1%
11 2
9.1%
10 2
9.1%
9 2
9.1%
8 2
9.1%
7 2
9.1%
6 2
9.1%
5 2
9.1%
4 2
9.1%
3 2
9.1%

확진자
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct17
Distinct (%)77.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.636364
Minimum0
Maximum403
Zeros3
Zeros (%)13.6%
Negative0
Negative (%)0.0%
Memory size330.0 B
2024-01-10T05:47:45.189837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12
median7
Q325
95-th percentile91.75
Maximum403
Range403
Interquartile range (IQR)23

Descriptive statistics

Standard deviation86.144146
Coefficient of variation (CV)2.351329
Kurtosis17.300734
Mean36.636364
Median Absolute Deviation (MAD)7
Skewness4.0131532
Sum806
Variance7420.8139
MonotonicityNot monotonic
2024-01-10T05:47:45.297440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
0 3
13.6%
2 2
 
9.1%
1 2
 
9.1%
25 2
 
9.1%
6 1
 
4.5%
403 1
 
4.5%
87 1
 
4.5%
92 1
 
4.5%
60 1
 
4.5%
33 1
 
4.5%
Other values (7) 7
31.8%
ValueCountFrequency (%)
0 3
13.6%
1 2
9.1%
2 2
9.1%
3 1
 
4.5%
4 1
 
4.5%
5 1
 
4.5%
6 1
 
4.5%
8 1
 
4.5%
13 1
 
4.5%
16 1
 
4.5%
ValueCountFrequency (%)
403 1
4.5%
92 1
4.5%
87 1
4.5%
60 1
4.5%
33 1
4.5%
25 2
9.1%
20 1
4.5%
16 1
4.5%
13 1
4.5%
8 1
4.5%

사망자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)13.6%
Missing0
Missing (%)0.0%
Memory size308.0 B
0
19 
1
2 
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.5%

Sample

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

Common Values

ValueCountFrequency (%)
0 19
86.4%
1 2
 
9.1%
3 1
 
4.5%

Length

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

Common Values (Plot)

2024-01-10T05:47:45.505160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 19
86.4%
1 2
 
9.1%
3 1
 
4.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size308.0 B
Minimum2022-02-09 00:00:00
Maximum2022-02-09 00:00:00
2024-01-10T05:47:45.579354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:45.654510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T05:47:43.849563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.431810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.640498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.919863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.491354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.703936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.990515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.564602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:43.772781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:47:45.710617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번년월확진자사망자
연번1.0000.9920.3480.5620.000
년0.9921.0000.0000.3560.128
월0.3480.0001.0000.0000.000
확진자0.5620.3560.0001.0000.635
사망자0.0000.1280.0000.6351.000
2024-01-10T05:47:45.790442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사망자년
사망자1.0000.195
년0.1951.000
2024-01-10T05:47:45.859382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번월확진자년사망자
연번1.0000.3740.8550.7100.000
월0.3741.0000.4230.0000.000
확진자0.8550.4231.0000.2110.636
년0.7100.0000.2111.0000.195
사망자0.0000.0000.6360.1951.000

Missing values

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

연번시도시군구년월확진자사망자데이터기준일자
01충청남도홍성군20203202022-02-09
12충청남도홍성군20204002022-02-09
23충청남도홍성군20205002022-02-09
34충청남도홍성군20206202022-02-09
45충청남도홍성군20207002022-02-09
56충청남도홍성군20208402022-02-09
67충청남도홍성군202091602022-02-09
78충청남도홍성군202010102022-02-09
89충청남도홍성군202011102022-02-09
910충청남도홍성군2020122502022-02-09
연번시도시군구년월확진자사망자데이터기준일자
1213충청남도홍성군202132002022-02-09
1314충청남도홍성군20214502022-02-09
1415충청남도홍성군20215802022-02-09
1516충청남도홍성군20216602022-02-09
1617충청남도홍성군202172502022-02-09
1718충청남도홍성군202183312022-02-09
1819충청남도홍성군202196002022-02-09
1920충청남도홍성군2021109202022-02-09
2021충청남도홍성군2021118702022-02-09
2122충청남도홍성군20211240332022-02-09