Overview

Dataset statistics

Number of variables8
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory72.1 B

Variable types

Numeric4
Categorical4

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
연번 has unique valuesUnique
확진자 has 3 (7.1%) zerosZeros
사망자 has 26 (61.9%) zerosZeros

Reproduction

Analysis started2024-01-09 20:47:35.729115
Analysis finished2024-01-09 20:47:37.402266
Duration1.67 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.5
Minimum1
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-01-10T05:47:37.461070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.05
Q111.25
median21.5
Q331.75
95-th percentile39.95
Maximum42
Range41
Interquartile range (IQR)20.5

Descriptive statistics

Standard deviation12.267844
Coefficient of variation (CV)0.5705974
Kurtosis-1.2
Mean21.5
Median Absolute Deviation (MAD)10.5
Skewness0
Sum903
Variance150.5
MonotonicityStrictly increasing
2024-01-10T05:47:37.572955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
1 1
 
2.4%
33 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
32 1
 
2.4%
Other values (32) 32
76.2%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
42 1
2.4%
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size468.0 B
충청남도
42 

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 (%)
충청남도 42
100.0%

Length

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

Common Values (Plot)

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

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size468.0 B
홍성군
42 

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

Length

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

Common Values (Plot)

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

년
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Memory size468.0 B
2021
12 
2022
12 
2020
10 
2023
8 

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
28.6%
2022 12
28.6%
2020 10
23.8%
2023 8
19.0%

Length

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

Common Values (Plot)

2024-01-10T05:47:38.091698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 12
28.6%
2022 12
28.6%
2020 10
23.8%
2023 8
19.0%

월
Real number (ℝ)

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

Quantile statistics

Minimum1
5-th percentile1.05
Q14
median6
Q39
95-th percentile11.95
Maximum12
Range11
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.3189877
Coefficient of variation (CV)0.52208795
Kurtosis-1.0598923
Mean6.3571429
Median Absolute Deviation (MAD)3
Skewness0.094691883
Sum267
Variance11.015679
MonotonicityNot monotonic
2024-01-10T05:47:38.276688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
3 4
9.5%
4 4
9.5%
5 4
9.5%
6 4
9.5%
7 4
9.5%
8 4
9.5%
9 3
7.1%
10 3
7.1%
11 3
7.1%
12 3
7.1%
Other values (2) 6
14.3%
ValueCountFrequency (%)
1 3
7.1%
2 3
7.1%
3 4
9.5%
4 4
9.5%
5 4
9.5%
6 4
9.5%
7 4
9.5%
8 4
9.5%
9 3
7.1%
10 3
7.1%
ValueCountFrequency (%)
12 3
7.1%
11 3
7.1%
10 3
7.1%
9 3
7.1%
8 4
9.5%
7 4
9.5%
6 4
9.5%
5 4
9.5%
4 4
9.5%
3 4
9.5%

확진자
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct37
Distinct (%)88.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1552.8095
Minimum0
Maximum18467
Zeros3
Zeros (%)7.1%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-01-10T05:47:38.376088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.05
Q16.5
median123.5
Q31677.5
95-th percentile7828.2
Maximum18467
Range18467
Interquartile range (IQR)1671

Descriptive statistics

Standard deviation3310.8342
Coefficient of variation (CV)2.1321573
Kurtosis16.946888
Mean1552.8095
Median Absolute Deviation (MAD)123.5
Skewness3.7850422
Sum65218
Variance10961623
MonotonicityNot monotonic
2024-01-10T05:47:38.495506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
0 3
 
7.1%
1 2
 
4.8%
25 2
 
4.8%
2 2
 
4.8%
1543 1
 
2.4%
2519 1
 
2.4%
568 1
 
2.4%
907 1
 
2.4%
479 1
 
2.4%
540 1
 
2.4%
Other values (27) 27
64.3%
ValueCountFrequency (%)
0 3
7.1%
1 2
4.8%
2 2
4.8%
3 1
 
2.4%
4 1
 
2.4%
5 1
 
2.4%
6 1
 
2.4%
8 1
 
2.4%
13 1
 
2.4%
16 1
 
2.4%
ValueCountFrequency (%)
18467 1
2.4%
8291 1
2.4%
8042 1
2.4%
3766 1
2.4%
3581 1
2.4%
3478 1
2.4%
3083 1
2.4%
2519 1
2.4%
2384 1
2.4%
2307 1
2.4%

사망자
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct10
Distinct (%)23.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.5714286
Minimum0
Maximum29
Zeros26
Zeros (%)61.9%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-01-10T05:47:38.592500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32.75
95-th percentile8.95
Maximum29
Range29
Interquartile range (IQR)2.75

Descriptive statistics

Standard deviation5.9187295
Coefficient of variation (CV)2.3017281
Kurtosis12.936186
Mean2.5714286
Median Absolute Deviation (MAD)0
Skewness3.5033765
Sum108
Variance35.031359
MonotonicityNot monotonic
2024-01-10T05:47:38.681476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 26
61.9%
4 3
 
7.1%
2 3
 
7.1%
1 2
 
4.8%
3 2
 
4.8%
6 2
 
4.8%
8 1
 
2.4%
29 1
 
2.4%
24 1
 
2.4%
9 1
 
2.4%
ValueCountFrequency (%)
0 26
61.9%
1 2
 
4.8%
2 3
 
7.1%
3 2
 
4.8%
4 3
 
7.1%
6 2
 
4.8%
8 1
 
2.4%
9 1
 
2.4%
24 1
 
2.4%
29 1
 
2.4%
ValueCountFrequency (%)
29 1
 
2.4%
24 1
 
2.4%
9 1
 
2.4%
8 1
 
2.4%
6 2
 
4.8%
4 3
 
7.1%
3 2
 
4.8%
2 3
 
7.1%
1 2
 
4.8%
0 26
61.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-12-27
42 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-27
2nd row2023-12-27
3rd row2023-12-27
4th row2023-12-27
5th row2023-12-27

Common Values

ValueCountFrequency (%)
2023-12-27 42
100.0%

Length

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

Common Values (Plot)

2024-01-10T05:47:38.868052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-27 42
100.0%

Interactions

2024-01-10T05:47:36.702710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:35.888730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.152605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.418491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.769533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:35.946375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.224212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.482471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.839854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.013336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.285821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.549419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.914211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.086318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.354413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:47:36.624722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:47:38.923205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번년월확진자사망자
연번1.0000.9670.0000.3550.493
년0.9671.0000.0000.3440.413
월0.0000.0001.0000.3560.000
확진자0.3550.3440.3561.0000.810
사망자0.4930.4130.0000.8101.000
2024-01-10T05:47:39.008080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번월확진자사망자년
연번1.000-0.0110.8380.4220.832
월-0.0111.0000.031-0.0910.000
확진자0.8380.0311.0000.7040.279
사망자0.422-0.0910.7041.0000.265
년0.8320.0000.2790.2651.000

Missing values

2024-01-10T05:47:37.256979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:47:37.362826image/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충청남도홍성군20203202023-12-27
12충청남도홍성군20204002023-12-27
23충청남도홍성군20205002023-12-27
34충청남도홍성군20206202023-12-27
45충청남도홍성군20207002023-12-27
56충청남도홍성군20208402023-12-27
67충청남도홍성군202091602023-12-27
78충청남도홍성군202010102023-12-27
89충청남도홍성군202011102023-12-27
910충청남도홍성군2020122502023-12-27
연번시도시군구년월확진자사망자데이터기준일자
3233충청남도홍성군202211308392023-12-27
3334충청남도홍성군202212358162023-12-27
3435충청남도홍성군20231230742023-12-27
3536충청남도홍성군2023266022023-12-27
3637충청남도홍성군2023354002023-12-27
3738충청남도홍성군2023447902023-12-27
3839충청남도홍성군2023590702023-12-27
3940충청남도홍성군2023656822023-12-27
4041충청남도홍성군20237154302023-12-27
4142충청남도홍성군20238251902023-12-27