gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	642
Missing cells	646
Missing cells (%)	6.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	83.5 KiB
Average record size in memory	133.2 B

Variable types

Numeric	12
Unsupported	1
Categorical	2

Dataset

Description	2021-02-01
Author	부산시공공데이터포털
URL	https://bigdata.busan.go.kr/data/bigDataDetailView.do?menuCode=M00000000007&hdfs_file_sn=20230901060901157000

Alerts

`inspec_area` has constant value ""	Constant
`last_load_dttm` has constant value ""	Constant
`skey` is highly overall correlated with `inspec_ym` and 2 other fields	High correlation
`inspec_ym` is highly overall correlated with `skey` and 3 other fields	High correlation
`virus02` is highly overall correlated with `inspec_ym` and 4 other fields	High correlation
`virus03` is highly overall correlated with `skey` and 3 other fields	High correlation
`virus04` is highly overall correlated with `virus02` and 1 other fields	High correlation
`virus07` is highly overall correlated with `skey` and 2 other fields	High correlation
`virus08` is highly overall correlated with `virus02` and 1 other fields	High correlation
`virus09` is highly overall correlated with `virus02`	High correlation
`virus10` has 642 (100.0%) missing values	Missing
`virus06` is highly skewed (γ1 = 21.92658212)	Skewed
`skey` has unique values	Unique
`virus10` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`virus01` has 88 (13.7%) zeros	Zeros
`virus02` has 305 (47.5%) zeros	Zeros
`virus03` has 408 (63.6%) zeros	Zeros
`virus04` has 160 (24.9%) zeros	Zeros
`virus05` has 389 (60.6%) zeros	Zeros
`virus06` has 471 (73.4%) zeros	Zeros
`virus07` has 446 (69.5%) zeros	Zeros
`virus08` has 198 (30.8%) zeros	Zeros
`virus09` has 475 (74.0%) zeros	Zeros

Reproduction

Analysis started	2024-04-17 00:57:27.184263
Analysis finished	2024-04-17 00:57:40.299020
Duration	13.11 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

skey
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	642
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	329600.5

Minimum	329280
Maximum	329921
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	329280
5-th percentile	329312.05
Q1	329440.25
median	329600.5
Q3	329760.75
95-th percentile	329888.95
Maximum	329921
Range	641
Interquartile range (IQR)	320.5

Descriptive statistics

Standard deviation	185.47372
Coefficient of variation (CV)	0.0005627228
Kurtosis	-1.2
Mean	329600.5
Median Absolute Deviation (MAD)	160.5
Skewness	0
Sum	2.1160352 × 10⁸
Variance	34400.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
329777	1	0.2%
329522	1	0.2%
329464	1	0.2%
329465	1	0.2%
329466	1	0.2%
329467	1	0.2%
329468	1	0.2%
329469	1	0.2%
329470	1	0.2%
329471	1	0.2%
Other values (632)	632	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
329280	1	0.2%
329281	1	0.2%
329282	1	0.2%
329283	1	0.2%
329284	1	0.2%
329285	1	0.2%
329286	1	0.2%
329287	1	0.2%
329288	1	0.2%
329289	1	0.2%

Value	Count	Frequency (%)
329921	1	0.2%
329920	1	0.2%
329919	1	0.2%
329918	1	0.2%
329917	1	0.2%
329916	1	0.2%
329915	1	0.2%
329914	1	0.2%
329913	1	0.2%
329912	1	0.2%

inspec_ym
Real number (ℝ)

HIGH CORRELATION

Distinct	148
Distinct (%)	23.2%
Missing	4
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	201136.51

Minimum	200204
Maximum	202011
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	200204
5-th percentile	200305
Q1	200706
median	201111
Q3	201605.75
95-th percentile	202004
Maximum	202011
Range	1807
Interquartile range (IQR)	899.75

Descriptive statistics

Standard deviation	533.37371
Coefficient of variation (CV)	0.0026517995
Kurtosis	-1.1353235
Mean	201136.51
Median Absolute Deviation (MAD)	450
Skewness	-0.059695916
Sum	1.283251 × 10⁸
Variance	284487.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201405	8	1.2%
201404	7	1.1%
200908	5	0.8%
200209	5	0.8%
201407	5	0.8%
200208	5	0.8%
201409	5	0.8%
201504	5	0.8%
201507	5	0.8%
201509	5	0.8%
Other values (138)	583	90.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200204	2	0.3%
200205	5	0.8%
200206	4	0.6%
200207	4	0.6%
200208	5	0.8%
200209	5	0.8%
200210	4	0.6%
200304	2	0.3%
200305	4	0.6%
200306	4	0.6%

Value	Count	Frequency (%)
202011	4	0.6%
202010	4	0.6%
202009	4	0.6%
202008	5	0.8%
202007	4	0.6%
202006	5	0.8%
202005	4	0.6%
202004	4	0.6%
201911	4	0.6%
201910	5	0.8%

inspec_wk
Real number (ℝ)

Distinct	9
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.758567

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	5
Maximum	9
Range	8
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.3391838
Coefficient of variation (CV)	0.48546358
Kurtosis	0.036033066
Mean	2.758567
Median Absolute Deviation (MAD)	1
Skewness	0.41224543
Sum	1771
Variance	1.7934132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	148	23.1%
4	148	23.1%
1	144	22.4%
2	144	22.4%
5	52	8.1%
6	2	0.3%
7	2	0.3%
8	1	0.2%
9	1	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	144	22.4%
2	144	22.4%
3	148	23.1%
4	148	23.1%
5	52	8.1%
6	2	0.3%
7	2	0.3%
8	1	0.2%
9	1	0.2%

Value	Count	Frequency (%)
9	1	0.2%
8	1	0.2%
7	2	0.3%
6	2	0.3%
5	52	8.1%
4	148	23.1%
3	148	23.1%
2	144	22.4%
1	144	22.4%

virus01
Real number (ℝ)

ZEROS

Distinct	341
Distinct (%)	53.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	363.40966

Minimum	0
Maximum	7022
Zeros	88
Zeros (%)	13.7%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.5
median	44
Q3	254.75
95-th percentile	1959.95
Maximum	7022
Range	7022
Interquartile range (IQR)	252.25

Descriptive statistics

Standard deviation	865.99646
Coefficient of variation (CV)	2.3829759
Kurtosis	18.837943
Mean	363.40966
Median Absolute Deviation (MAD)	44
Skewness	4.0041514
Sum	233309
Variance	749949.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	88	13.7%
1.0	25	3.9%
0.5	18	2.8%
2.0	14	2.2%
2.5	11	1.7%
4.5	10	1.6%
3.0	9	1.4%
4.0	8	1.2%
1.5	8	1.2%
7.5	7	1.1%
Other values (331)	444	69.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	88	13.7%
0.5	18	2.8%
1.0	25	3.9%
1.5	8	1.2%
2.0	14	2.2%
2.5	11	1.7%
3.0	9	1.4%
3.5	4	0.6%
4.0	8	1.2%
4.5	10	1.6%

Value	Count	Frequency (%)
7022.0	1	0.2%
6613.0	1	0.2%
5708.0	1	0.2%
5351.0	1	0.2%
4696.0	1	0.2%
4563.0	1	0.2%
4338.0	1	0.2%
4271.0	2	0.3%
4193.0	1	0.2%
4056.0	1	0.2%

virus02
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	112
Distinct (%)	17.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.562305

Minimum	0
Maximum	259.5
Zeros	305
Zeros (%)	47.5%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.5
Q3	9
95-th percentile	68.35
Maximum	259.5
Range	259.5
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	32.288699
Coefficient of variation (CV)	2.5702845
Kurtosis	21.77212
Mean	12.562305
Median Absolute Deviation (MAD)	0.5
Skewness	4.3488175
Sum	8065
Variance	1042.5601
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	305	47.5%
1.0	33	5.1%
0.5	23	3.6%
2.0	19	3.0%
3.0	16	2.5%
1.5	11	1.7%
3.5	10	1.6%
4.5	8	1.2%
2.5	8	1.2%
6.0	7	1.1%
Other values (102)	202	31.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	305	47.5%
0.5	23	3.6%
1.0	33	5.1%
1.5	11	1.7%
2.0	19	3.0%
2.5	8	1.2%
3.0	16	2.5%
3.5	10	1.6%
4.0	7	1.1%
4.5	8	1.2%

Value	Count	Frequency (%)
259.5	1	0.2%
227.0	1	0.2%
224.0	2	0.3%
206.0	1	0.2%
180.0	1	0.2%
178.0	1	0.2%
175.0	1	0.2%
172.0	1	0.2%
168.0	1	0.2%
160.0	1	0.2%

virus03
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	176
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	387.96028

Minimum	0
Maximum	9718
Zeros	408
Zeros (%)	63.6%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	18.375
95-th percentile	2672.55
Maximum	9718
Range	9718
Interquartile range (IQR)	18.375

Descriptive statistics

Standard deviation	1213.0599
Coefficient of variation (CV)	3.126763
Kurtosis	24.203536
Mean	387.96028
Median Absolute Deviation (MAD)	0
Skewness	4.5302219
Sum	249070.5
Variance	1471514.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	408	63.6%
0.5	14	2.2%
1.0	8	1.2%
5.0	7	1.1%
2.0	5	0.8%
7.0	4	0.6%
3.0	4	0.6%
12.0	4	0.6%
17.0	3	0.5%
4.0	3	0.5%
Other values (166)	182	28.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	408	63.6%
0.5	14	2.2%
1.0	8	1.2%
1.5	1	0.2%
2.0	5	0.8%
3.0	4	0.6%
3.5	2	0.3%
4.0	3	0.5%
4.5	2	0.3%
5.0	7	1.1%

Value	Count	Frequency (%)
9718.0	1	0.2%
9207.0	1	0.2%
9036.0	1	0.2%
8808.0	1	0.2%
8541.0	1	0.2%
7024.0	1	0.2%
7003.0	1	0.2%
5282.0	1	0.2%
5075.0	1	0.2%
5064.0	1	0.2%

virus04
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	225
Distinct (%)	35.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	187.35156

Minimum	0
Maximum	4765.5
Zeros	160
Zeros (%)	24.9%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.275
median	3.75
Q3	65
95-th percentile	1199.225
Maximum	4765.5
Range	4765.5
Interquartile range (IQR)	64.725

Descriptive statistics

Standard deviation	535.97115
Coefficient of variation (CV)	2.8607777
Kurtosis	27.066752
Mean	187.35156
Median Absolute Deviation (MAD)	3.75
Skewness	4.6826533
Sum	120279.7
Variance	287265.08
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	160	24.9%
2.0	41	6.4%
1.0	35	5.5%
0.5	33	5.1%
4.0	18	2.8%
1.5	17	2.6%
2.5	16	2.5%
5.0	11	1.7%
9.0	11	1.7%
3.0	11	1.7%
Other values (215)	289	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	160	24.9%
0.2	1	0.2%
0.5	33	5.1%
1.0	35	5.5%
1.5	17	2.6%
2.0	41	6.4%
2.5	16	2.5%
3.0	11	1.7%
3.5	7	1.1%
4.0	18	2.8%

Value	Count	Frequency (%)
4765.5	2	0.3%
3833.5	1	0.2%
3747.0	1	0.2%
2839.0	1	0.2%
2646.0	1	0.2%
2621.0	2	0.3%
2604.0	1	0.2%
2538.0	1	0.2%
2429.5	1	0.2%
2154.0	1	0.2%

virus05
Real number (ℝ)

ZEROS

Distinct	48
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0412773

Minimum	0
Maximum	112
Zeros	389
Zeros (%)	60.6%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.5
95-th percentile	18
Maximum	112
Range	112
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	9.694447
Coefficient of variation (CV)	3.1876236
Kurtosis	41.072366
Mean	3.0412773
Median Absolute Deviation (MAD)	0
Skewness	5.6546627
Sum	1952.5
Variance	93.982303
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0.0	389	60.6%
1.0	44	6.9%
0.5	41	6.4%
2.0	28	4.4%
1.5	19	3.0%
3.0	15	2.3%
4.0	14	2.2%
2.5	9	1.4%
8.0	9	1.4%
6.0	7	1.1%
Other values (38)	67	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	389	60.6%
0.5	41	6.4%
1.0	44	6.9%
1.5	19	3.0%
2.0	28	4.4%
2.5	9	1.4%
3.0	15	2.3%
3.5	6	0.9%
4.0	14	2.2%
4.5	3	0.5%

Value	Count	Frequency (%)
112.0	1	0.2%
77.0	1	0.2%
68.0	1	0.2%
64.0	1	0.2%
55.0	1	0.2%
50.0	1	0.2%
49.0	2	0.3%
48.0	2	0.3%
47.0	1	0.2%
45.0	1	0.2%

virus06
Real number (ℝ)

SKEWED ZEROS

Distinct	35
Distinct (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0584112

Minimum	0
Maximum	396
Zeros	471
Zeros (%)	73.4%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.5
95-th percentile	9
Maximum	396
Range	396
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	16.381902
Coefficient of variation (CV)	7.9585176
Kurtosis	523.96105
Mean	2.0584112
Median Absolute Deviation (MAD)	0
Skewness	21.926582
Sum	1321.5
Variance	268.36671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0.0	471	73.4%
0.5	32	5.0%
1.0	31	4.8%
2.0	19	3.0%
1.5	12	1.9%
2.5	10	1.6%
3.0	9	1.4%
4.0	8	1.2%
5.0	6	0.9%
10.0	4	0.6%
Other values (25)	40	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	471	73.4%
0.5	32	5.0%
1.0	31	4.8%
1.5	12	1.9%
2.0	19	3.0%
2.5	10	1.6%
3.0	9	1.4%
4.0	8	1.2%
4.5	3	0.5%
5.0	6	0.9%

Value	Count	Frequency (%)
396.0	1	0.2%
48.5	1	0.2%
47.0	1	0.2%
44.0	1	0.2%
41.0	1	0.2%
32.0	1	0.2%
31.0	1	0.2%
28.0	1	0.2%
25.0	1	0.2%
22.0	2	0.3%

virus07
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	100
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.602804

Minimum	0
Maximum	1308
Zeros	446
Zeros (%)	69.5%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	87.95
Maximum	1308
Range	1308
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	73.061764
Coefficient of variation (CV)	4.1505754
Kurtosis	162.75528
Mean	17.602804
Median Absolute Deviation (MAD)	0
Skewness	10.779124
Sum	11301
Variance	5338.0214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	446	69.5%
1.0	16	2.5%
0.5	9	1.4%
4.0	9	1.4%
2.0	7	1.1%
8.0	6	0.9%
9.0	5	0.8%
13.0	5	0.8%
33.0	5	0.8%
7.0	4	0.6%
Other values (90)	130	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	446	69.5%
0.5	9	1.4%
1.0	16	2.5%
1.5	1	0.2%
2.0	7	1.1%
2.5	1	0.2%
3.0	3	0.5%
3.5	2	0.3%
4.0	9	1.4%
5.0	4	0.6%

Value	Count	Frequency (%)
1308.0	1	0.2%
566.0	1	0.2%
537.5	1	0.2%
364.5	1	0.2%
344.0	1	0.2%
342.0	1	0.2%
294.0	1	0.2%
291.0	1	0.2%
282.0	1	0.2%
258.0	1	0.2%

virus08
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	249
Distinct (%)	38.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86.44081

Minimum	0
Maximum	1214
Zeros	198
Zeros (%)	30.8%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	14
Q3	74.75
95-th percentile	439.7
Maximum	1214
Range	1214
Interquartile range (IQR)	74.75

Descriptive statistics

Standard deviation	186.99071
Coefficient of variation (CV)	2.1632225
Kurtosis	13.986653
Mean	86.44081
Median Absolute Deviation (MAD)	14
Skewness	3.5901852
Sum	55495
Variance	34965.525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	198	30.8%
1.0	15	2.3%
0.5	13	2.0%
7.5	10	1.6%
2.0	10	1.6%
6.0	8	1.2%
7.0	6	0.9%
2.5	6	0.9%
5.5	5	0.8%
11.0	5	0.8%
Other values (239)	366	57.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	198	30.8%
0.5	13	2.0%
1.0	15	2.3%
1.5	5	0.8%
2.0	10	1.6%
2.5	6	0.9%
3.0	3	0.5%
3.5	2	0.3%
4.0	4	0.6%
4.5	2	0.3%

Value	Count	Frequency (%)
1214.0	1	0.2%
1196.0	1	0.2%
1114.0	1	0.2%
1076.0	1	0.2%
1069.0	1	0.2%
1054.0	1	0.2%
1004.0	1	0.2%
1000.0	1	0.2%
969.0	1	0.2%
959.0	1	0.2%

virus09
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	43
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.3255452

Minimum	0
Maximum	168
Zeros	475
Zeros (%)	74.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.5
95-th percentile	14
Maximum	168
Range	168
Interquartile range (IQR)	0.5

Descriptive statistics

Standard deviation	9.2913461
Coefficient of variation (CV)	3.9953411
Kurtosis	169.7992
Mean	2.3255452
Median Absolute Deviation (MAD)	0
Skewness	10.957948
Sum	1493
Variance	86.329112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0.0	475	74.0%
0.5	23	3.6%
1.0	18	2.8%
6.0	10	1.6%
1.5	9	1.4%
2.5	9	1.4%
4.5	9	1.4%
2.0	9	1.4%
3.0	8	1.2%
14.5	5	0.8%
Other values (33)	67	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	475	74.0%
0.5	23	3.6%
1.0	18	2.8%
1.5	9	1.4%
2.0	9	1.4%
2.5	9	1.4%
3.0	8	1.2%
3.5	4	0.6%
4.0	5	0.8%
4.5	9	1.4%

Value	Count	Frequency (%)
168.0	1	0.2%
86.0	1	0.2%
47.0	1	0.2%
38.0	2	0.3%
37.5	2	0.3%
36.0	1	0.2%
33.0	1	0.2%
28.0	1	0.2%
27.5	2	0.3%
24.5	1	0.2%

virus10
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	642
Missing (%)	100.0%
Memory size	5.8 KiB

inspec_area
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

부산지역축사	642

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	부산지역축사
2nd row	부산지역축사
3rd row	부산지역축사
4th row	부산지역축사
5th row	부산지역축사

Common Values

Value	Count	Frequency (%)
부산지역축사	642	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
부산지역축사	642	100.0%

last_load_dttm
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	5.1 KiB

2021-02-01 06:09:03	642

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-02-01 06:09:03
2nd row	2021-02-01 06:09:03
3rd row	2021-02-01 06:09:03
4th row	2021-02-01 06:09:03
5th row	2021-02-01 06:09:03

Common Values

Value	Count	Frequency (%)
2021-02-01 06:09:03	642	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2021-02-01	642	50.0%
06:09:03	642	50.0%

Phik (φk)
Auto

Heatmap
Table

	skey	inspec_ym	inspec_wk	virus01	virus02	virus03	virus04	virus05	virus06	virus07	virus08	virus09
skey	1.000	0.995	0.000	0.329	0.312	0.361	0.232	0.399	0.070	0.368	0.384	0.432
inspec_ym	0.995	1.000	0.000	0.362	0.303	0.384	0.233	0.420	0.000	0.354	0.370	0.473
inspec_wk	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
virus01	0.329	0.362	0.000	1.000	0.590	0.694	0.569	0.340	0.429	0.262	0.349	0.602
virus02	0.312	0.303	0.000	0.590	1.000	0.000	0.718	0.000	0.613	0.000	0.623	0.746
virus03	0.361	0.384	0.000	0.694	0.000	1.000	0.000	0.503	0.326	0.601	0.000	0.000
virus04	0.232	0.233	0.000	0.569	0.718	0.000	1.000	0.000	0.602	0.000	0.500	0.767
virus05	0.399	0.420	0.000	0.340	0.000	0.503	0.000	1.000	0.096	0.372	0.239	0.000
virus06	0.070	0.000	0.000	0.429	0.613	0.326	0.602	0.096	1.000	0.154	0.259	0.000
virus07	0.368	0.354	0.000	0.262	0.000	0.601	0.000	0.372	0.154	1.000	0.000	0.000
virus08	0.384	0.370	0.000	0.349	0.623	0.000	0.500	0.239	0.259	0.000	1.000	0.522
virus09	0.432	0.473	0.000	0.602	0.746	0.000	0.767	0.000	0.000	0.000	0.522	1.000

Heatmap
Table

	skey	inspec_ym	inspec_wk	virus01	virus02	virus03	virus04	virus05	virus06	virus07	virus08	virus09
skey	1.000	1.000	-0.004	-0.337	0.495	-0.750	0.329	-0.022	0.195	-0.545	0.355	0.200
inspec_ym	1.000	1.000	-0.005	-0.326	0.522	-0.766	0.353	-0.007	0.198	-0.558	0.368	0.229
inspec_wk	-0.004	-0.005	1.000	-0.005	0.003	-0.020	-0.024	-0.027	-0.025	-0.020	-0.023	-0.007
virus01	-0.337	-0.326	-0.005	1.000	0.210	0.411	0.491	0.438	0.236	0.373	0.388	0.157
virus02	0.495	0.522	0.003	0.210	1.000	-0.589	0.740	0.214	0.340	-0.467	0.683	0.559
virus03	-0.750	-0.766	-0.020	0.411	-0.589	1.000	-0.312	0.135	-0.048	0.822	-0.271	-0.381
virus04	0.329	0.353	-0.024	0.491	0.740	-0.312	1.000	0.343	0.418	-0.170	0.734	0.471
virus05	-0.022	-0.007	-0.027	0.438	0.214	0.135	0.343	1.000	0.192	0.234	0.299	0.075
virus06	0.195	0.198	-0.025	0.236	0.340	-0.048	0.418	0.192	1.000	-0.018	0.233	-0.012
virus07	-0.545	-0.558	-0.020	0.373	-0.467	0.822	-0.170	0.234	-0.018	1.000	-0.103	-0.306
virus08	0.355	0.368	-0.023	0.388	0.683	-0.271	0.734	0.299	0.233	-0.103	1.000	0.418
virus09	0.200	0.229	-0.007	0.157	0.559	-0.381	0.471	0.075	-0.012	-0.306	0.418	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

	skey	inspec_ym	inspec_wk	virus01	virus02	virus03	virus04	virus05	virus06	virus07	virus08	virus10	inspec_area	last_load_dttm
0	329777	201609	3	161.0	10.5	0.5	30.5	0.0	0.5	0.0	34.0	<NA>	부산지역축사	2021-02-01 06:09:03
1	329778	201609	4	139.5	1.5	0.0	21.5	2.5	0.5	1.0	136.0	<NA>	부산지역축사	2021-02-01 06:09:03
2	329779	201610	1	59.0	0.5	0.0	5.0	0.0	0.0	0.0	92.5	<NA>	부산지역축사	2021-02-01 06:09:03
3	329780	201610	2	7.5	1.5	0.0	9.0	1.0	0.0	0.0	93.0	<NA>	부산지역축사	2021-02-01 06:09:03
4	329781	201610	3	4.0	0.5	0.0	1.5	1.5	0.5	0.0	36.5	<NA>	부산지역축사	2021-02-01 06:09:03
5	329782	201610	4	3.5	1.5	0.0	1.0	0.0	0.0	0.0	22.5	<NA>	부산지역축사	2021-02-01 06:09:03
6	329783	201611	1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2021-02-01 06:09:03
7	329784	201611	2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2021-02-01 06:09:03
8	329785	201611	3	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2021-02-01 06:09:03
9	329786	201611	4	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2021-02-01 06:09:03

	skey	inspec_ym	inspec_wk	virus01	virus02	virus03	virus04	virus05	virus06	virus07	virus08	virus10	inspec_area	last_load_dttm
632	329397	200510	4	116.0	0.0	29.0	4.0	0.0	1.0	0.0	16.0	<NA>	부산지역축사	2021-02-01 06:09:03
633	329398	200604	1	11.5	1.0	3.5	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2021-02-01 06:09:03
634	329399	200604	2	3.0	0.0	7.5	0.0	0.0	0.0	0.0	0.5	<NA>	부산지역축사	2021-02-01 06:09:03
635	329400	200604	3	6.5	0.5	4.5	0.0	0.5	0.0	0.0	0.5	<NA>	부산지역축사	2021-02-01 06:09:03
636	329401	200604	4	4.5	2.5	0.0	0.0	1.0	0.0	0.0	0.5	<NA>	부산지역축사	2021-02-01 06:09:03
637	329402	200605	1	2.5	4.0	1.5	0.0	0.0	0.0	0.0	1.0	<NA>	부산지역축사	2021-02-01 06:09:03
638	329403	200605	2	7.0	0.5	7.0	0.0	0.5	0.0	5.5	4.5	<NA>	부산지역축사	2021-02-01 06:09:03
639	329404	200605	3	7.5	7.0	14.5	0.5	0.0	0.0	4.0	8.0	<NA>	부산지역축사	2021-02-01 06:09:03
640	329405	200605	4	11.0	3.0	16.0	3.5	0.0	0.0	9.5	10.0	<NA>	부산지역축사	2021-02-01 06:09:03
641	329406	200605	5	25.0	3.0	16.5	1.5	1.5	0.0	8.5	17.5	<NA>	부산지역축사	2021-02-01 06:09:03

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample