gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	42
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.3 KiB
Average record size in memory	56.1 B

Variable types

Categorical	2
Numeric	4

Dataset

Description	천안시에서 2020년 코로나19 확진자 첫 발생이후 2023년 7월까지 확진자 발생 현황 및 코로나로 인한 사망자 현황
Author	충청남도
URL	https://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=109&beforeMenuCd=DOM_000000201001001000&publicdatapk=15098710

Alerts

`데이터기준일자` has constant value ""	Constant
`지역확진자수` is highly overall correlated with `사망자수`	High correlation
`사망자수` is highly overall correlated with `지역확진자수`	High correlation
`지역확진자수` has 1 (2.4%) zeros	Zeros
`해외입국확진자수` has 9 (21.4%) zeros	Zeros
`사망자수` has 14 (33.3%) zeros	Zeros

Reproduction

Analysis started	2024-01-09 19:47:11.684253
Analysis finished	2024-01-09 19:47:12.982539
Duration	1.3 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준연도
Categorical

Distinct	4
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Memory size	468.0 B

2021	12
2022	12
2020	11
2023	7

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020
2nd row	2020
3rd row	2020
4th row	2020
5th row	2020

Common Values

Value	Count	Frequency (%)
2021	12	28.6%
2022	12	28.6%
2020	11	26.2%
2023	7	16.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2021	12	28.6%
2022	12	28.6%
2020	11	26.2%
2023	7	16.7%

기준월
Real number (ℝ)

Distinct	12
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2142857

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	510.0 B

Quantile statistics

Minimum	1
5-th percentile	1.05
Q1	3.25
median	6
Q3	9
95-th percentile	11.95
Maximum	12
Range	11
Interquartile range (IQR)	5.75

Descriptive statistics

Standard deviation	3.3752016
Coefficient of variation (CV)	0.54313589
Kurtosis	-1.1058077
Mean	6.2142857
Median Absolute Deviation (MAD)	3
Skewness	0.16539767
Sum	261
Variance	11.391986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	4	9.5%
3	4	9.5%
4	4	9.5%
5	4	9.5%
6	4	9.5%
7	4	9.5%
8	3	7.1%
9	3	7.1%
10	3	7.1%
11	3	7.1%
Other values (2)	6	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	7.1%
2	4	9.5%
3	4	9.5%
4	4	9.5%
5	4	9.5%
6	4	9.5%
7	4	9.5%
8	3	7.1%
9	3	7.1%
10	3	7.1%

Value	Count	Frequency (%)
12	3	7.1%
11	3	7.1%
10	3	7.1%
9	3	7.1%
8	3	7.1%
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

Distinct	41
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10770.19

Minimum	0
Maximum	132126
Zeros	1
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	510.0 B

Quantile statistics

Minimum	0
5-th percentile	1.1
Q1	93.25
median	840
Q3	11348.25
95-th percentile	48352.7
Maximum	132126
Range	132126
Interquartile range (IQR)	11255

Descriptive statistics

Standard deviation	23422.441
Coefficient of variation (CV)	2.1747472
Kurtosis	17.961745
Mean	10770.19
Median Absolute Deviation (MAD)	839.5
Skewness	3.8996029
Sum	452348
Variance	5.4861076 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1	2	4.8%
56	1	2.4%
22254	1	2.4%
132126	1	2.4%
60802	1	2.4%
12617	1	2.4%
3493	1	2.4%
18269	1	2.4%
49334	1	2.4%
21323	1	2.4%
Other values (31)	31	73.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	2.4%
1	2	4.8%
3	1	2.4%
34	1	2.4%
38	1	2.4%
43	1	2.4%
44	1	2.4%
56	1	2.4%
77	1	2.4%
92	1	2.4%

Value	Count	Frequency (%)
132126	1	2.4%
60802	1	2.4%
49334	1	2.4%
29708	1	2.4%
28063	1	2.4%
22254	1	2.4%
21323	1	2.4%
18269	1	2.4%
15359	1	2.4%
12617	1	2.4%

해외입국확진자수
Real number (ℝ)

ZEROS

Distinct	22
Distinct (%)	52.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.047619

Minimum	0
Maximum	407
Zeros	9
Zeros (%)	21.4%
Negative	0
Negative (%)	0.0%
Memory size	510.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	14.25
95-th percentile	94.35
Maximum	407
Range	407
Interquartile range (IQR)	12.25

Descriptive statistics

Standard deviation	72.693125
Coefficient of variation (CV)	2.6875979
Kurtosis	20.082244
Mean	27.047619
Median Absolute Deviation (MAD)	4
Skewness	4.3321692
Sum	1136
Variance	5284.2904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	9	21.4%
3	6	14.3%
2	4	9.5%
8	3	7.1%
4	2	4.8%
10	2	4.8%
15	1	2.4%
38	1	2.4%
36	1	2.4%
243	1	2.4%
Other values (12)	12	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	21.4%
1	1	2.4%
2	4	9.5%
3	6	14.3%
4	2	4.8%
6	1	2.4%
7	1	2.4%
8	3	7.1%
10	2	4.8%
11	1	2.4%

Value	Count	Frequency (%)
407	1	2.4%
243	1	2.4%
95	1	2.4%
82	1	2.4%
39	1	2.4%
38	1	2.4%
36	1	2.4%
32	1	2.4%
18	1	2.4%
16	1	2.4%

사망자수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17
Distinct (%)	40.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.214286

Minimum	0
Maximum	106
Zeros	14
Zeros (%)	33.3%
Negative	0
Negative (%)	0.0%
Memory size	510.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2.5
Q3	14.75
95-th percentile	37.9
Maximum	106
Range	106
Interquartile range (IQR)	14.75

Descriptive statistics

Standard deviation	23.856825
Coefficient of variation (CV)	1.9531903
Kurtosis	10.38466
Mean	12.214286
Median Absolute Deviation (MAD)	2.5
Skewness	3.1282934
Sum	513
Variance	569.14808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	14	33.3%
1	5	11.9%
5	3	7.1%
4	3	7.1%
26	2	4.8%
2	2	4.8%
106	2	4.8%
8	2	4.8%
3	1	2.4%
23	1	2.4%
Other values (7)	7	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	33.3%
1	5	11.9%
2	2	4.8%
3	1	2.4%
4	3	7.1%
5	3	7.1%
7	1	2.4%
8	2	4.8%
17	1	2.4%
18	1	2.4%

Value	Count	Frequency (%)
106	2	4.8%
38	1	2.4%
36	1	2.4%
33	1	2.4%
26	2	4.8%
23	1	2.4%
22	1	2.4%
18	1	2.4%
17	1	2.4%
8	2	4.8%

데이터기준일자
Categorical

CONSTANT

Distinct	1
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	468.0 B

2023-08-21	42

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023-08-21
2nd row	2023-08-21
3rd row	2023-08-21
4th row	2023-08-21
5th row	2023-08-21

Common Values

Value	Count	Frequency (%)
2023-08-21	42	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023-08-21	42	100.0%

Phik (φk)
Auto

Heatmap
Table

	기준연도	기준월	지역확진자수	해외입국확진자수	사망자수
기준연도	1.000	0.000	0.386	0.327	0.383
기준월	0.000	1.000	0.000	0.493	0.000
지역확진자수	0.386	0.000	1.000	0.797	0.801
해외입국확진자수	0.327	0.493	0.797	1.000	0.521
사망자수	0.383	0.000	0.801	0.521	1.000

Heatmap
Table

	기준월	지역확진자수	해외입국확진자수	사망자수	기준연도
기준월	1.000	0.038	0.177	0.057	0.000
지역확진자수	0.038	1.000	0.292	0.848	0.245
해외입국확진자수	0.177	0.292	1.000	0.256	0.125
사망자수	0.057	0.848	0.256	1.000	0.313
기준연도	0.000	0.245	0.125	0.313	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	기준연도	기준월	지역확진자수	해외입국확진자수	사망자수	데이터기준일자
0	2020	2	56	0	0	2023-08-21
1	2020	3	43	4	0	2023-08-21
2	2020	4	1	3	0	2023-08-21
3	2020	5	1	0	0	2023-08-21
4	2020	6	3	0	0	2023-08-21
5	2020	7	0	2	0	2023-08-21
6	2020	8	77	4	0	2023-08-21
7	2020	9	34	1	4	2023-08-21
8	2020	10	38	2	1	2023-08-21
9	2020	11	186	7	1	2023-08-21

	기준연도	기준월	지역확진자수	해외입국확진자수	사망자수	데이터기준일자
32	2022	10	10242	36	8	2023-08-21
33	2022	11	22254	10	17	2023-08-21
34	2022	12	28063	8	26	2023-08-21
35	2023	1	15359	38	23	2023-08-21
36	2023	2	4576	8	8	2023-08-21
37	2023	3	4456	2	3	2023-08-21
38	2023	4	5307	3	5	2023-08-21
39	2023	5	7286	2	4	2023-08-21
40	2023	6	6015	0	4	2023-08-21
41	2023	7	11717	0	2	2023-08-21

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample