Overview

Dataset statistics

Number of variables6
Number of observations21
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory58.3 B

Variable types

Categorical4
Numeric2

Dataset

Description충청남도 공주시 월별 코로나19 확진자 및 사망자 수에 대한 데이터로 시도, 시군구, 연도, 월, 확진자 수, 사망자 수의 데이터를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=108&beforeMenuCd=DOM_000000201001001000&publicdatapk=15098783

Alerts

시도 has constant value ""Constant
시군구 has constant value ""Constant
확진자수 is highly overall correlated with 연도High correlation
연도 is highly overall correlated with 확진자수High correlation

Reproduction

Analysis started2024-01-09 22:34:56.117929
Analysis finished2024-01-09 22:34:56.684135
Duration0.57 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
충청남도
21 

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

Length

2024-01-10T07:34:56.740045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:34:56.842652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 21
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
공주시
21 

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 (%)
공주시 21
100.0%

Length

2024-01-10T07:34:56.943144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:34:57.043528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공주시 21
100.0%

연도
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size300.0 B
2021
12 
2020
8 
2022
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)4.8%

Sample

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

Common Values

ValueCountFrequency (%)
2021 12
57.1%
2020 8
38.1%
2022 1
 
4.8%

Length

2024-01-10T07:34:57.148069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:34:57.240801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 12
57.1%
2020 8
38.1%
2022 1
 
4.8%

월
Real number (ℝ)

Distinct12
Distinct (%)57.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2024-01-10T07:34:57.320068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q15
median7
Q310
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.4785054
Coefficient of variation (CV)0.49692935
Kurtosis-0.95021551
Mean7
Median Absolute Deviation (MAD)3
Skewness-0.28360337
Sum147
Variance12.1
MonotonicityNot monotonic
2024-01-10T07:34:57.405827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
5 2
9.5%
6 2
9.5%
7 2
9.5%
8 2
9.5%
9 2
9.5%
10 2
9.5%
11 2
9.5%
12 2
9.5%
1 2
9.5%
2 1
4.8%
Other values (2) 2
9.5%
ValueCountFrequency (%)
1 2
9.5%
2 1
4.8%
3 1
4.8%
4 1
4.8%
5 2
9.5%
6 2
9.5%
7 2
9.5%
8 2
9.5%
9 2
9.5%
10 2
9.5%
ValueCountFrequency (%)
12 2
9.5%
11 2
9.5%
10 2
9.5%
9 2
9.5%
8 2
9.5%
7 2
9.5%
6 2
9.5%
5 2
9.5%
4 1
4.8%
3 1
4.8%

확진자수
Real number (ℝ)

HIGH CORRELATION 

Distinct17
Distinct (%)81.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33.47619
Minimum1
Maximum197
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2024-01-10T07:34:57.506992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median15
Q334
95-th percentile141
Maximum197
Range196
Interquartile range (IQR)31

Descriptive statistics

Standard deviation49.78114
Coefficient of variation (CV)1.4870611
Kurtosis5.9319416
Mean33.47619
Median Absolute Deviation (MAD)13
Skewness2.4315374
Sum703
Variance2478.1619
MonotonicityNot monotonic
2024-01-10T07:34:57.599375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
1 3
14.3%
15 2
 
9.5%
2 2
 
9.5%
13 1
 
4.8%
197 1
 
4.8%
141 1
 
4.8%
69 1
 
4.8%
22 1
 
4.8%
34 1
 
4.8%
61 1
 
4.8%
Other values (7) 7
33.3%
ValueCountFrequency (%)
1 3
14.3%
2 2
9.5%
3 1
 
4.8%
8 1
 
4.8%
11 1
 
4.8%
12 1
 
4.8%
13 1
 
4.8%
15 2
9.5%
22 1
 
4.8%
24 1
 
4.8%
ValueCountFrequency (%)
197 1
4.8%
141 1
4.8%
69 1
4.8%
61 1
4.8%
46 1
4.8%
34 1
4.8%
25 1
4.8%
24 1
4.8%
22 1
4.8%
15 2
9.5%

사망자수
Categorical

Distinct4
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
0
15 
1
4 
11
 
1
2
 
1

Length

Max length2
Median length1
Mean length1.047619
Min length1

Unique

Unique2 ?
Unique (%)9.5%

Sample

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

Common Values

ValueCountFrequency (%)
0 15
71.4%
1 4
 
19.0%
11 1
 
4.8%
2 1
 
4.8%

Length

2024-01-10T07:34:57.707089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:34:57.790416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 15
71.4%
1 4
 
19.0%
11 1
 
4.8%
2 1
 
4.8%

Interactions

2024-01-10T07:34:56.377918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:34:56.245986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:34:56.447144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:34:56.308153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:34:57.855045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도월확진자수사망자수
연도1.0000.0000.9660.000
월0.0001.0000.0000.000
확진자수0.9660.0001.0000.663
사망자수0.0000.0000.6631.000
2024-01-10T07:34:57.935043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도사망자수
연도1.0000.000
사망자수0.0001.000
2024-01-10T07:34:58.009103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
월확진자수연도사망자수
월1.0000.1340.0000.000
확진자수0.1341.0000.7040.451
연도0.0000.7041.0000.000
사망자수0.0000.4510.0001.000

Missing values

2024-01-10T07:34:56.550676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:34:56.645863image/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충청남도공주시2020510
1충청남도공주시2020620
2충청남도공주시2020710
3충청남도공주시2020830
4충청남도공주시2020910
5충청남도공주시20201021
6충청남도공주시202011460
7충청남도공주시2020121211
8충청남도공주시20211150
9충청남도공주시20212240
시도시군구연도월확진자수사망자수
11충청남도공주시2021480
12충청남도공주시20215251
13충청남도공주시20216130
14충청남도공주시20217150
15충청남도공주시20218611
16충청남도공주시20219341
17충청남도공주시202110220
18충청남도공주시202111690
19충청남도공주시2021121412
20충청남도공주시202211970