gimi9 Pandas Profiling

Dataset statistics

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

Variable types

Numeric	12
Unsupported	1
Categorical	1
DateTime	1

Dataset

Description	2020-12-21
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 641 (100.0%) missing values	Missing
`virus06` is highly skewed (γ1 = 21.90980324)	Skewed
`skey` has unique values	Unique
`virus10` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`virus01` has 87 (13.6%) zeros	Zeros
`virus02` has 304 (47.4%) zeros	Zeros
`virus03` has 407 (63.5%) zeros	Zeros
`virus04` has 159 (24.8%) zeros	Zeros
`virus05` has 388 (60.5%) zeros	Zeros
`virus06` has 470 (73.3%) zeros	Zeros
`virus07` has 445 (69.4%) zeros	Zeros
`virus08` has 197 (30.7%) zeros	Zeros
`virus09` has 474 (73.9%) zeros	Zeros

Reproduction

Analysis started	2024-04-17 00:57:47.086510
Analysis finished	2024-04-17 00:57:59.923817
Duration	12.84 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

skey
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	641
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	308432

Minimum	308112
Maximum	308752
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	308112
5-th percentile	308144
Q1	308272
median	308432
Q3	308592
95-th percentile	308720
Maximum	308752
Range	640
Interquartile range (IQR)	320

Descriptive statistics

Standard deviation	185.18504
Coefficient of variation (CV)	0.00060040801
Kurtosis	-1.2
Mean	308432
Median Absolute Deviation (MAD)	160
Skewness	0
Sum	1.9770491 × 10⁸
Variance	34293.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
308609	1	0.2%
308353	1	0.2%
308295	1	0.2%
308296	1	0.2%
308297	1	0.2%
308298	1	0.2%
308299	1	0.2%
308300	1	0.2%
308301	1	0.2%
308302	1	0.2%
Other values (631)	631	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
308112	1	0.2%
308113	1	0.2%
308114	1	0.2%
308115	1	0.2%
308116	1	0.2%
308117	1	0.2%
308118	1	0.2%
308119	1	0.2%
308120	1	0.2%
308121	1	0.2%

Value	Count	Frequency (%)
308752	1	0.2%
308751	1	0.2%
308750	1	0.2%
308749	1	0.2%
308748	1	0.2%
308747	1	0.2%
308746	1	0.2%
308745	1	0.2%
308744	1	0.2%
308743	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	201135.14

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
95-th percentile	202004
Maximum	202011
Range	1807
Interquartile range (IQR)	899

Descriptive statistics

Standard deviation	532.66362
Coefficient of variation (CV)	0.0026482872
Kurtosis	-1.1344944
Mean	201135.14
Median Absolute Deviation (MAD)	407
Skewness	-0.059252582
Sum	1.2812308 × 10⁸
Variance	283730.53
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
201405	8	1.2%
201404	7	1.1%
200209	5	0.8%
201407	5	0.8%
200208	5	0.8%
201409	5	0.8%
201504	5	0.8%
200610	5	0.8%
201005	5	0.8%
201509	5	0.8%
Other values (138)	582	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	3	0.5%
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.7566303

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.3393295
Coefficient of variation (CV)	0.48585752
Kurtosis	0.040735473
Mean	2.7566303
Median Absolute Deviation (MAD)	1
Skewness	0.41586027
Sum	1767
Variance	1.7938036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	148	23.1%
4	147	22.9%
1	144	22.5%
2	144	22.5%
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.5%
2	144	22.5%
3	148	23.1%
4	147	22.9%
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	147	22.9%
3	148	23.1%
2	144	22.5%
1	144	22.5%

virus01
Real number (ℝ)

ZEROS

Distinct	341
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	363.9766

Minimum	0
Maximum	7022
Zeros	87
Zeros (%)	13.6%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.5
median	44
Q3	255
95-th percentile	1960
Maximum	7022
Range	7022
Interquartile range (IQR)	252.5

Descriptive statistics

Standard deviation	866.55351
Coefficient of variation (CV)	2.3807946
Kurtosis	18.805574
Mean	363.9766
Median Absolute Deviation (MAD)	44
Skewness	4.0008449
Sum	233309
Variance	750914.99
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	87	13.6%
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.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	87	13.6%
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.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.581903

Minimum	0
Maximum	259.5
Zeros	304
Zeros (%)	47.4%
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.5
Maximum	259.5
Range	259.5
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	32.310093
Coefficient of variation (CV)	2.5679814
Kurtosis	21.734855
Mean	12.581903
Median Absolute Deviation (MAD)	0.5
Skewness	4.345254
Sum	8065
Variance	1043.9421
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	304	47.4%
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	304	47.4%
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.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	388.56552

Minimum	0
Maximum	9718
Zeros	407
Zeros (%)	63.5%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	1213.9102
Coefficient of variation (CV)	3.124081
Kurtosis	24.161037
Mean	388.56552
Median Absolute Deviation (MAD)	0
Skewness	4.526345
Sum	249070.5
Variance	1473577.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	407	63.5%
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.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	407	63.5%
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.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	187.64384

Minimum	0
Maximum	4765.5
Zeros	159
Zeros (%)	24.8%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.5
median	4
Q3	65.5
95-th percentile	1199.5
Maximum	4765.5
Range	4765.5
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	536.33851
Coefficient of variation (CV)	2.8582794
Kurtosis	27.021425
Mean	187.64384
Median Absolute Deviation (MAD)	4
Skewness	4.6787892
Sum	120279.7
Variance	287659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	159	24.8%
2.0	41	6.4%
1.0	35	5.5%
0.5	33	5.1%
4.0	18	2.8%
1.5	17	2.7%
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.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	159	24.8%
0.2	1	0.2%
0.5	33	5.1%
1.0	35	5.5%
1.5	17	2.7%
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.0460218

Minimum	0
Maximum	112
Zeros	388
Zeros (%)	60.5%
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.7012719
Coefficient of variation (CV)	3.184899
Kurtosis	41.006612
Mean	3.0460218
Median Absolute Deviation (MAD)	0
Skewness	5.6501578
Sum	1952.5
Variance	94.114676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
0.0	388	60.5%
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.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	388	60.5%
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.0616225

Minimum	0
Maximum	396
Zeros	470
Zeros (%)	73.3%
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.394493
Coefficient of variation (CV)	7.9522285
Kurtosis	523.1553
Mean	2.0616225
Median Absolute Deviation (MAD)	0
Skewness	21.909803
Sum	1321.5
Variance	268.7794
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
0.0	470	73.3%
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	470	73.3%
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.630265

Minimum	0
Maximum	1308
Zeros	445
Zeros (%)	69.4%
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	88
Maximum	1308
Range	1308
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	73.115506
Coefficient of variation (CV)	4.1471586
Kurtosis	162.51281
Mean	17.630265
Median Absolute Deviation (MAD)	0
Skewness	10.771123
Sum	11301
Variance	5345.8771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	445	69.4%
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.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	445	69.4%
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.575663

Minimum	0
Maximum	1214
Zeros	197
Zeros (%)	30.7%
Negative	0
Negative (%)	0.0%
Memory size	5.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	187.10549
Coefficient of variation (CV)	2.1611788
Kurtosis	13.961217
Mean	86.575663
Median Absolute Deviation (MAD)	14
Skewness	3.5871842
Sum	55495
Variance	35008.465
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	197	30.7%
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.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	197	30.7%
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.3291732

Minimum	0
Maximum	168
Zeros	474
Zeros (%)	73.9%
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.298147
Coefficient of variation (CV)	3.9920377
Kurtosis	169.54868
Mean	2.3291732
Median Absolute Deviation (MAD)	0
Skewness	10.949909
Sum	1493
Variance	86.455538
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0.0	474	73.9%
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.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	474	73.9%
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	641
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

부산지역축사	641

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 (%)
부산지역축사	641	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

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

last_load_dttm
Date

CONSTANT

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

Minimum	2020-12-21 17:38:45
Maximum	2020-12-21 17:38:45

Histogram

Histogram with fixed size bins (bins=1)

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.328	0.313	0.361	0.232	0.398	0.070	0.368	0.384	0.432
inspec_ym	0.995	1.000	0.000	0.362	0.304	0.384	0.232	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.328	0.362	0.000	1.000	0.590	0.694	0.569	0.339	0.429	0.262	0.348	0.602
virus02	0.313	0.304	0.000	0.590	1.000	0.000	0.718	0.000	0.613	0.000	0.623	0.745
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.232	0.000	0.569	0.718	0.000	1.000	0.000	0.602	0.000	0.500	0.767
virus05	0.398	0.420	0.000	0.339	0.000	0.503	0.000	1.000	0.096	0.372	0.238	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.348	0.623	0.000	0.500	0.238	0.259	0.000	1.000	0.522
virus09	0.432	0.473	0.000	0.602	0.745	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.007	-0.334	0.499	-0.750	0.333	-0.020	0.197	-0.545	0.359	0.202
inspec_ym	1.000	1.000	-0.007	-0.323	0.526	-0.766	0.358	-0.005	0.200	-0.558	0.373	0.231
inspec_wk	-0.007	-0.007	1.000	-0.002	0.005	-0.018	-0.022	-0.026	-0.024	-0.019	-0.021	-0.006
virus01	-0.334	-0.323	-0.002	1.000	0.208	0.410	0.489	0.438	0.235	0.372	0.386	0.156
virus02	0.499	0.526	0.005	0.208	1.000	-0.591	0.739	0.213	0.340	-0.468	0.683	0.559
virus03	-0.750	-0.766	-0.018	0.410	-0.591	1.000	-0.314	0.135	-0.048	0.822	-0.273	-0.382
virus04	0.333	0.358	-0.022	0.489	0.739	-0.314	1.000	0.342	0.417	-0.172	0.733	0.471
virus05	-0.020	-0.005	-0.026	0.438	0.213	0.135	0.342	1.000	0.191	0.234	0.298	0.074
virus06	0.197	0.200	-0.024	0.235	0.340	-0.048	0.417	0.191	1.000	-0.019	0.232	-0.013
virus07	-0.545	-0.558	-0.019	0.372	-0.468	0.822	-0.172	0.234	-0.019	1.000	-0.104	-0.307
virus08	0.359	0.373	-0.021	0.386	0.683	-0.273	0.733	0.298	0.232	-0.104	1.000	0.418
virus09	0.202	0.231	-0.006	0.156	0.559	-0.382	0.471	0.074	-0.013	-0.307	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	308609	201609	3	161.0	10.5	0.5	30.5	0.0	0.5	0.0	34.0	<NA>	부산지역축사	2020-12-21 17:38:45
1	308610	201609	4	139.5	1.5	0.0	21.5	2.5	0.5	1.0	136.0	<NA>	부산지역축사	2020-12-21 17:38:45
2	308611	201610	1	59.0	0.5	0.0	5.0	0.0	0.0	0.0	92.5	<NA>	부산지역축사	2020-12-21 17:38:45
3	308612	201610	2	7.5	1.5	0.0	9.0	1.0	0.0	0.0	93.0	<NA>	부산지역축사	2020-12-21 17:38:45
4	308613	201610	3	4.0	0.5	0.0	1.5	1.5	0.5	0.0	36.5	<NA>	부산지역축사	2020-12-21 17:38:45
5	308614	201610	4	3.5	1.5	0.0	1.0	0.0	0.0	0.0	22.5	<NA>	부산지역축사	2020-12-21 17:38:45
6	308615	201611	1	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2020-12-21 17:38:45
7	308616	201611	2	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2020-12-21 17:38:45
8	308617	201611	3	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2020-12-21 17:38:45
9	308618	201611	4	0.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2020-12-21 17:38:45

	skey	inspec_ym	inspec_wk	virus01	virus02	virus03	virus04	virus05	virus06	virus07	virus08	virus10	inspec_area	last_load_dttm
631	308229	200510	4	116.0	0.0	29.0	4.0	0.0	1.0	0.0	16.0	<NA>	부산지역축사	2020-12-21 17:38:45
632	308230	200604	1	11.5	1.0	3.5	0.0	0.0	0.0	0.0	0.0	<NA>	부산지역축사	2020-12-21 17:38:45
633	308231	200604	2	3.0	0.0	7.5	0.0	0.0	0.0	0.0	0.5	<NA>	부산지역축사	2020-12-21 17:38:45
634	308232	200604	3	6.5	0.5	4.5	0.0	0.5	0.0	0.0	0.5	<NA>	부산지역축사	2020-12-21 17:38:45
635	308233	200604	4	4.5	2.5	0.0	0.0	1.0	0.0	0.0	0.5	<NA>	부산지역축사	2020-12-21 17:38:45
636	308234	200605	1	2.5	4.0	1.5	0.0	0.0	0.0	0.0	1.0	<NA>	부산지역축사	2020-12-21 17:38:45
637	308235	200605	2	7.0	0.5	7.0	0.0	0.5	0.0	5.5	4.5	<NA>	부산지역축사	2020-12-21 17:38:45
638	308236	200605	3	7.5	7.0	14.5	0.5	0.0	0.0	4.0	8.0	<NA>	부산지역축사	2020-12-21 17:38:45
639	308237	200605	4	11.0	3.0	16.0	3.5	0.0	0.0	9.5	10.0	<NA>	부산지역축사	2020-12-21 17:38:45
640	308238	200605	5	25.0	3.0	16.5	1.5	1.5	0.0	8.5	17.5	<NA>	부산지역축사	2020-12-21 17:38:45

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample