Overview

Dataset statistics

Number of variables8
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory74.5 B

Variable types

Numeric3
Categorical5

Dataset

Description광주광역시 북구 코로나19 확진자 및 사망자 현황으로 시도명, 시군구명, 기준년도, 기준월, 확진자수, 사망자수 항목을 공공데이터 포털을 통해 제공합니다.
Author광주광역시 북구
URLhttps://www.data.go.kr/data/15098703/fileData.do

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 확진자수High correlation
확진자수 is highly overall correlated with 연번 and 2 other fieldsHigh correlation
기준년도 is highly overall correlated with 연번High correlation
사망자수 is highly overall correlated with 확진자수High correlation
연번 has unique valuesUnique
확진자수 has 3 (12.5%) zerosZeros

Reproduction

Analysis started2023-12-12 14:37:12.338546
Analysis finished2023-12-12 14:37:13.577277
Duration1.24 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.5
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T23:37:13.647435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.15
Q16.75
median12.5
Q318.25
95-th percentile22.85
Maximum24
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation7.0710678
Coefficient of variation (CV)0.56568542
Kurtosis-1.2
Mean12.5
Median Absolute Deviation (MAD)6
Skewness0
Sum300
Variance50
MonotonicityStrictly increasing
2023-12-12T23:37:14.122948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 1
 
4.2%
14 1
 
4.2%
24 1
 
4.2%
23 1
 
4.2%
22 1
 
4.2%
21 1
 
4.2%
20 1
 
4.2%
19 1
 
4.2%
18 1
 
4.2%
17 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
1 1
4.2%
2 1
4.2%
3 1
4.2%
4 1
4.2%
5 1
4.2%
6 1
4.2%
7 1
4.2%
8 1
4.2%
9 1
4.2%
10 1
4.2%
ValueCountFrequency (%)
24 1
4.2%
23 1
4.2%
22 1
4.2%
21 1
4.2%
20 1
4.2%
19 1
4.2%
18 1
4.2%
17 1
4.2%
16 1
4.2%
15 1
4.2%

시도명
Categorical

CONSTANT 

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

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시
2nd row광주광역시
3rd row광주광역시
4th row광주광역시
5th row광주광역시

Common Values

ValueCountFrequency (%)
광주광역시 24
100.0%

Length

2023-12-12T23:37:14.246475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:14.355025image/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 length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북구
2nd row북구
3rd row북구
4th row북구
5th row북구

Common Values

ValueCountFrequency (%)
북구 24
100.0%

Length

2023-12-12T23:37:14.477037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:14.600118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북구 24
100.0%

기준년도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size324.0 B
2020
12 
2021
12 

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 (%)
2020 12
50.0%
2021 12
50.0%

Length

2023-12-12T23:37:14.704947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:14.819484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 12
50.0%
2021 12
50.0%

기준월
Real number (ℝ)

HIGH CORRELATION 

Distinct12
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.5
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T23:37:14.925290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1.15
Q13.75
median6.5
Q39.25
95-th percentile11.85
Maximum12
Range11
Interquartile range (IQR)5.5

Descriptive statistics

Standard deviation3.5262987
Coefficient of variation (CV)0.54250749
Kurtosis-1.2156934
Mean6.5
Median Absolute Deviation (MAD)3
Skewness0
Sum156
Variance12.434783
MonotonicityNot monotonic
2023-12-12T23:37:15.029205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 2
8.3%
2 2
8.3%
3 2
8.3%
4 2
8.3%
5 2
8.3%
6 2
8.3%
7 2
8.3%
8 2
8.3%
9 2
8.3%
10 2
8.3%
Other values (2) 4
16.7%
ValueCountFrequency (%)
1 2
8.3%
2 2
8.3%
3 2
8.3%
4 2
8.3%
5 2
8.3%
6 2
8.3%
7 2
8.3%
8 2
8.3%
9 2
8.3%
10 2
8.3%
ValueCountFrequency (%)
12 2
8.3%
11 2
8.3%
10 2
8.3%
9 2
8.3%
8 2
8.3%
7 2
8.3%
6 2
8.3%
5 2
8.3%
4 2
8.3%
3 2
8.3%

확진자수
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct21
Distinct (%)87.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83.875
Minimum0
Maximum479
Zeros3
Zeros (%)12.5%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T23:37:15.148050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q111.75
median64.5
Q397.25
95-th percentile236.5
Maximum479
Range479
Interquartile range (IQR)85.5

Descriptive statistics

Standard deviation106.80226
Coefficient of variation (CV)1.2733503
Kurtosis7.6803949
Mean83.875
Median Absolute Deviation (MAD)50.5
Skewness2.4836835
Sum2013
Variance11406.723
MonotonicityNot monotonic
2023-12-12T23:37:15.265908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 3
 
12.5%
2 2
 
8.3%
38 1
 
4.2%
479 1
 
4.2%
241 1
 
4.2%
62 1
 
4.2%
211 1
 
4.2%
157 1
 
4.2%
91 1
 
4.2%
39 1
 
4.2%
Other values (11) 11
45.8%
ValueCountFrequency (%)
0 3
12.5%
1 1
 
4.2%
2 2
8.3%
15 1
 
4.2%
25 1
 
4.2%
32 1
 
4.2%
38 1
 
4.2%
39 1
 
4.2%
62 1
 
4.2%
67 1
 
4.2%
ValueCountFrequency (%)
479 1
4.2%
241 1
4.2%
211 1
4.2%
157 1
4.2%
123 1
4.2%
116 1
4.2%
91 1
4.2%
84 1
4.2%
82 1
4.2%
76 1
4.2%

사망자수
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size324.0 B
0
18 
1
3 
2
2 
6
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)4.2%

Sample

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

Common Values

ValueCountFrequency (%)
0 18
75.0%
1 3
 
12.5%
2 2
 
8.3%
6 1
 
4.2%

Length

2023-12-12T23:37:15.422894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.525847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 18
75.0%
1 3
 
12.5%
2 2
 
8.3%
6 1
 
4.2%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
2022-02-03
24 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-02-03
2nd row2022-02-03
3rd row2022-02-03
4th row2022-02-03
5th row2022-02-03

Common Values

ValueCountFrequency (%)
2022-02-03 24
100.0%

Length

2023-12-12T23:37:15.631166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.715152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-02-03 24
100.0%

Interactions

2023-12-12T23:37:13.080861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.542379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.825768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:13.167734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.639912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.908373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:13.265279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.744566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:12.989754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:37:15.786700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번기준년도기준월확진자수사망자수
연번1.0001.0000.7660.3850.000
기준년도1.0001.0000.0000.1420.190
기준월0.7660.0001.0000.0000.412
확진자수0.3850.1420.0001.0000.787
사망자수0.0000.1900.4120.7871.000
2023-12-12T23:37:15.905048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년도사망자수
기준년도1.0000.094
사망자수0.0941.000
2023-12-12T23:37:15.998355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번기준월확진자수기준년도사망자수
연번1.0000.4990.7660.7980.000
기준월0.4991.0000.5310.0000.171
확진자수0.7660.5311.0000.0820.621
기준년도0.7980.0000.0821.0000.094
사망자수0.0000.1710.6210.0941.000

Missing values

2023-12-12T23:37:13.393538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:37:13.525956image/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광주광역시북구20201002022-02-03
12광주광역시북구20202002022-02-03
23광주광역시북구20203102022-02-03
34광주광역시북구20204202022-02-03
45광주광역시북구20205002022-02-03
56광주광역시북구202061502022-02-03
67광주광역시북구202077622022-02-03
78광주광역시북구202088402022-02-03
89광주광역시북구202096712022-02-03
910광주광역시북구202010202022-02-03
연번시도명시군구명기준년도기준월확진자수사망자수데이터기준일
1415광주광역시북구202132502022-02-03
1516광주광역시북구202143802022-02-03
1617광주광역시북구202158202022-02-03
1718광주광역시북구202163902022-02-03
1819광주광역시북구202179102022-02-03
1920광주광역시북구2021815702022-02-03
2021광주광역시북구2021921112022-02-03
2122광주광역시북구2021106202022-02-03
2223광주광역시북구20211124102022-02-03
2324광주광역시북구20211247962022-02-03