gimi9 Pandas Profiling

Dataset statistics

Number of variables	17
Number of observations	731
Missing cells	3762
Missing cells (%)	30.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	108.6 KiB
Average record size in memory	152.2 B

Variable types

DateTime	1
Numeric	16

Dataset

Description	한국남부발전(주)_사업소별트래픽에 대한 데이터로 날짜, 사업소별(본사, 하동, 남제주, 인천, 영월, 안동, 삼척, 부산) 평균 등의 항목을 제공합니다.
Author	한국남부발전(주)
URL	https://www.data.go.kr/data/15033833/fileData.do

Alerts

`하동 평균(Mbps)` is highly overall correlated with `하동 최대(Mbps)` and 6 other fields	High correlation
`하동 최대(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 5 other fields	High correlation
`남제주 평균(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 5 other fields	High correlation
`남제주 최대(Mbps)` is highly overall correlated with `남제주 평균(Mbps)`	High correlation
`인천 평균(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 1 other fields	High correlation
`인천 최대(Mbps)` is highly overall correlated with `인천 평균(Mbps)`	High correlation
`영월 평균(Mbps)` is highly overall correlated with `영월 최대(Mbps)` and 1 other fields	High correlation
`영월 최대(Mbps)` is highly overall correlated with `영월 평균(Mbps)`	High correlation
`안동 평균(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 5 other fields	High correlation
`안동 최대(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 4 other fields	High correlation
`삼척 평균(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 5 other fields	High correlation
`삼척 최대(Mbps)` is highly overall correlated with `하동 평균(Mbps)` and 6 other fields	High correlation
`본사 평균(Mbps)` has 306 (41.9%) missing values	Missing
`본사 최대(Mbps)` has 306 (41.9%) missing values	Missing
`하동 평균(Mbps)` has 209 (28.6%) missing values	Missing
`하동 최대(Mbps)` has 209 (28.6%) missing values	Missing
`남제주 평균(Mbps)` has 188 (25.7%) missing values	Missing
`남제주 최대(Mbps)` has 188 (25.7%) missing values	Missing
`인천 평균(Mbps)` has 306 (41.9%) missing values	Missing
`인천 최대(Mbps)` has 306 (41.9%) missing values	Missing
`영월 평균(Mbps)` has 166 (22.7%) missing values	Missing
`영월 최대(Mbps)` has 166 (22.7%) missing values	Missing
`안동 평균(Mbps)` has 263 (36.0%) missing values	Missing
`안동 최대(Mbps)` has 263 (36.0%) missing values	Missing
`삼척 평균(Mbps)` has 263 (36.0%) missing values	Missing
`삼척 최대(Mbps)` has 263 (36.0%) missing values	Missing
`부산 평균(Mbps)` has 180 (24.6%) missing values	Missing
`부산 최대(Mbps)` has 180 (24.6%) missing values	Missing
`구분` has unique values	Unique

Reproduction

Analysis started	2024-05-11 07:50:24.829845
Analysis finished	2024-05-11 07:51:29.258817
Duration	1 minute and 4.43 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

구분
Date

UNIQUE

Distinct	731
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	5.8 KiB

Minimum	2022-05-01 00:00:00
Maximum	2024-04-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

본사 평균(Mbps)
Real number (ℝ)

MISSING

Distinct	406
Distinct (%)	95.5%
Missing	306
Missing (%)	41.9%
Infinite	0
Infinite (%)	0.0%
Mean	121.32247

Minimum	58.95
Maximum	285.03
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	58.95
5-th percentile	78.552
Q1	109.17
median	120.85
Q3	132.02
95-th percentile	163.492
Maximum	285.03
Range	226.08
Interquartile range (IQR)	22.85

Descriptive statistics

Standard deviation	26.224761
Coefficient of variation (CV)	0.21615749
Kurtosis	6.2990114
Mean	121.32247
Median Absolute Deviation (MAD)	11.43
Skewness	1.3138425
Sum	51562.05
Variance	687.73807
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
114.45	3	0.4%
122.76	2	0.3%
134.0	2	0.3%
111.08	2	0.3%
114.83	2	0.3%
72.11	2	0.3%
112.04	2	0.3%
126.29	2	0.3%
137.47	2	0.3%
121.09	2	0.3%
Other values (396)	404	55.3%
(Missing)	306	41.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
58.95	1	0.1%
60.26	1	0.1%
61.34	1	0.1%
65.04	1	0.1%
65.25	1	0.1%
66.52	1	0.1%
68.85	1	0.1%
69.45	1	0.1%
70.36	1	0.1%
71.36	1	0.1%

Value	Count	Frequency (%)
285.03	1	0.1%
249.72	1	0.1%
239.28	1	0.1%
230.28	1	0.1%
207.02	1	0.1%
203.91	1	0.1%
199.82	1	0.1%
191.69	1	0.1%
185.17	1	0.1%
183.34	1	0.1%

본사 최대(Mbps)
Real number (ℝ)

MISSING

Distinct	418
Distinct (%)	98.4%
Missing	306
Missing (%)	41.9%
Infinite	0
Infinite (%)	0.0%
Mean	614.62616

Minimum	360.74
Maximum	894.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	360.74
5-th percentile	494.83
Q1	589.78
median	620.84
Q3	638.86
95-th percentile	706.388
Maximum	894.35
Range	533.61
Interquartile range (IQR)	49.08

Descriptive statistics

Standard deviation	63.296607
Coefficient of variation (CV)	0.10298391
Kurtosis	3.7639355
Mean	614.62616
Median Absolute Deviation (MAD)	21.44
Skewness	0.25754608
Sum	261216.12
Variance	4006.4604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
629.76	2	0.3%
644.61	2	0.3%
601.82	2	0.3%
615.18	2	0.3%
627.13	2	0.3%
629.77	2	0.3%
638.86	2	0.3%
628.02	1	0.1%
616.33	1	0.1%
619.95	1	0.1%
Other values (408)	408	55.8%
(Missing)	306	41.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
360.74	1	0.1%
425.26	1	0.1%
427.76	1	0.1%
428.63	1	0.1%
433.12	1	0.1%
445.23	1	0.1%
445.98	1	0.1%
453.82	1	0.1%
465.72	1	0.1%
468.16	1	0.1%

Value	Count	Frequency (%)
894.35	1	0.1%
890.36	1	0.1%
841.2	1	0.1%
834.0	1	0.1%
821.81	1	0.1%
802.88	1	0.1%
802.54	1	0.1%
798.84	1	0.1%
794.96	1	0.1%
780.82	1	0.1%

하동 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	505
Distinct (%)	96.7%
Missing	209
Missing (%)	28.6%
Infinite	0
Infinite (%)	0.0%
Mean	97.916437

Minimum	42.53
Maximum	296.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	42.53
5-th percentile	61.1925
Q1	77.7825
median	91.495
Q3	108.0325
95-th percentile	169.624
Maximum	296.05
Range	253.52
Interquartile range (IQR)	30.25

Descriptive statistics

Standard deviation	34.073799
Coefficient of variation (CV)	0.34798856
Kurtosis	7.6155557
Mean	97.916437
Median Absolute Deviation (MAD)	15.13
Skewness	2.2467219
Sum	51112.38
Variance	1161.0238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81.04	2	0.3%
80.82	2	0.3%
116.11	2	0.3%
72.14	2	0.3%
71.31	2	0.3%
93.81	2	0.3%
93.34	2	0.3%
102.27	2	0.3%
110.95	2	0.3%
98.81	2	0.3%
Other values (495)	502	68.7%
(Missing)	209	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42.53	1	0.1%
46.68	1	0.1%
47.32	1	0.1%
49.8	1	0.1%
49.85	1	0.1%
49.99	1	0.1%
50.41	1	0.1%
51.36	1	0.1%
51.76	1	0.1%
51.91	1	0.1%

Value	Count	Frequency (%)
296.05	1	0.1%
294.22	1	0.1%
263.85	1	0.1%
258.62	1	0.1%
237.47	1	0.1%
236.94	1	0.1%
236.43	1	0.1%
213.13	1	0.1%
208.58	1	0.1%
207.65	1	0.1%

하동 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	515
Distinct (%)	98.7%
Missing	209
Missing (%)	28.6%
Infinite	0
Infinite (%)	0.0%
Mean	227.45573

Minimum	104.64
Maximum	875.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	104.64
5-th percentile	135.2595
Q1	172.2975
median	207.82
Q3	257.06
95-th percentile	374.897
Maximum	875.37
Range	770.73
Interquartile range (IQR)	84.7625

Descriptive statistics

Standard deviation	88.593653
Coefficient of variation (CV)	0.38949845
Kurtosis	11.300369
Mean	227.45573
Median Absolute Deviation (MAD)	41.815
Skewness	2.5960557
Sum	118731.89
Variance	7848.8354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
168.57	2	0.3%
188.2	2	0.3%
203.01	2	0.3%
201.4	2	0.3%
199.31	2	0.3%
250.05	2	0.3%
128.71	2	0.3%
171.56	1	0.1%
156.95	1	0.1%
247.98	1	0.1%
Other values (505)	505	69.1%
(Missing)	209	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
104.64	1	0.1%
108.0	1	0.1%
108.35	1	0.1%
111.18	1	0.1%
112.06	1	0.1%
112.16	1	0.1%
113.77	1	0.1%
114.62	1	0.1%
120.33	1	0.1%
121.37	1	0.1%

Value	Count	Frequency (%)
875.37	1	0.1%
688.89	1	0.1%
683.06	1	0.1%
670.53	1	0.1%
664.83	1	0.1%
651.16	1	0.1%
625.17	1	0.1%
561.03	1	0.1%
529.13	1	0.1%
469.21	1	0.1%

남제주 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	502
Distinct (%)	92.4%
Missing	188
Missing (%)	25.7%
Infinite	0
Infinite (%)	0.0%
Mean	45.718103

Minimum	22.63
Maximum	90.76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	22.63
5-th percentile	31.808
Q1	39.26
median	44.37
Q3	49.975
95-th percentile	66.144
Maximum	90.76
Range	68.13
Interquartile range (IQR)	10.715

Descriptive statistics

Standard deviation	10.494069
Coefficient of variation (CV)	0.2295386
Kurtosis	2.3935716
Mean	45.718103
Median Absolute Deviation (MAD)	5.3
Skewness	1.1978152
Sum	24824.93
Variance	110.12549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48.27	3	0.4%
41.86	3	0.4%
43.38	3	0.4%
40.3	3	0.4%
42.67	2	0.3%
47.92	2	0.3%
44.77	2	0.3%
47.77	2	0.3%
38.33	2	0.3%
43.36	2	0.3%
Other values (492)	519	71.0%
(Missing)	188	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22.63	1	0.1%
23.55	1	0.1%
25.34	1	0.1%
26.82	1	0.1%
26.88	1	0.1%
26.97	1	0.1%
27.24	1	0.1%
28.13	1	0.1%
28.16	1	0.1%
28.19	1	0.1%

Value	Count	Frequency (%)
90.76	1	0.1%
84.46	1	0.1%
84.23	1	0.1%
82.88	1	0.1%
82.04	1	0.1%
81.54	1	0.1%
80.3	1	0.1%
78.53	1	0.1%
78.2	1	0.1%
77.87	1	0.1%

남제주 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	535
Distinct (%)	98.5%
Missing	188
Missing (%)	25.7%
Infinite	0
Infinite (%)	0.0%
Mean	118.75663

Minimum	61.06
Maximum	613.28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	61.06
5-th percentile	81.151
Q1	98.085
median	111.82
Q3	130.58
95-th percentile	174.382
Maximum	613.28
Range	552.22
Interquartile range (IQR)	32.495

Descriptive statistics

Standard deviation	39.122173
Coefficient of variation (CV)	0.32943149
Kurtosis	70.908064
Mean	118.75663
Median Absolute Deviation (MAD)	15.55
Skewness	6.3715269
Sum	64484.85
Variance	1530.5444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
101.0	2	0.3%
110.97	2	0.3%
114.51	2	0.3%
139.59	2	0.3%
98.37	2	0.3%
109.99	2	0.3%
134.16	2	0.3%
125.52	2	0.3%
145.5	1	0.1%
113.91	1	0.1%
Other values (525)	525	71.8%
(Missing)	188	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61.06	1	0.1%
70.1	1	0.1%
71.35	1	0.1%
73.67	1	0.1%
74.08	1	0.1%
74.76	1	0.1%
75.44	1	0.1%
76.3	1	0.1%
76.69	1	0.1%
76.87	1	0.1%

Value	Count	Frequency (%)
613.28	1	0.1%
540.95	1	0.1%
237.14	1	0.1%
217.13	1	0.1%
212.3	1	0.1%
206.59	1	0.1%
203.73	1	0.1%
201.83	1	0.1%
201.34	1	0.1%
199.88	1	0.1%

인천 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	413
Distinct (%)	97.2%
Missing	306
Missing (%)	41.9%
Infinite	0
Infinite (%)	0.0%
Mean	48.540494

Minimum	18.12
Maximum	285.03
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	18.12
5-th percentile	27.058
Q1	35.03
median	41.89
Q3	50.83
95-th percentile	98.52
Maximum	285.03
Range	266.91
Interquartile range (IQR)	15.8

Descriptive statistics

Standard deviation	27.690712
Coefficient of variation (CV)	0.57046621
Kurtosis	24.21614
Mean	48.540494
Median Absolute Deviation (MAD)	7.59
Skewness	4.0666082
Sum	20629.71
Variance	766.77553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44.77	3	0.4%
43.2	2	0.3%
39.35	2	0.3%
27.56	2	0.3%
50.83	2	0.3%
44.14	2	0.3%
31.52	2	0.3%
49.31	2	0.3%
72.11	2	0.3%
43.76	2	0.3%
Other values (403)	404	55.3%
(Missing)	306	41.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.12	1	0.1%
19.61	1	0.1%
19.88	1	0.1%
21.06	1	0.1%
21.74	1	0.1%
22.42	1	0.1%
22.44	1	0.1%
23.05	1	0.1%
23.36	1	0.1%
23.5	1	0.1%

Value	Count	Frequency (%)
285.03	1	0.1%
249.72	1	0.1%
230.28	1	0.1%
158.05	1	0.1%
157.9	1	0.1%
151.59	1	0.1%
136.1	1	0.1%
132.65	1	0.1%
130.42	1	0.1%
129.66	1	0.1%

인천 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	422
Distinct (%)	99.3%
Missing	306
Missing (%)	41.9%
Infinite	0
Infinite (%)	0.0%
Mean	190.68285

Minimum	60.65
Maximum	890.36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	60.65
5-th percentile	78.032
Q1	100.83
median	118.12
Q3	145.6
95-th percentile	674.982
Maximum	890.36
Range	829.71
Interquartile range (IQR)	44.77

Descriptive statistics

Standard deviation	192.19983
Coefficient of variation (CV)	1.0079555
Kurtosis	2.9824704
Mean	190.68285
Median Absolute Deviation (MAD)	20.23
Skewness	2.1515086
Sum	81040.21
Variance	36940.775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126.07	2	0.3%
134.85	2	0.3%
108.47	2	0.3%
108.62	1	0.1%
115.27	1	0.1%
141.84	1	0.1%
154.19	1	0.1%
72.98	1	0.1%
92.74	1	0.1%
105.54	1	0.1%
Other values (412)	412	56.4%
(Missing)	306	41.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60.65	1	0.1%
64.13	1	0.1%
65.45	1	0.1%
65.67	1	0.1%
66.69	1	0.1%
68.42	1	0.1%
68.82	1	0.1%
71.13	1	0.1%
72.35	1	0.1%
72.98	1	0.1%

Value	Count	Frequency (%)
890.36	1	0.1%
834.0	1	0.1%
821.81	1	0.1%
802.88	1	0.1%
798.84	1	0.1%
773.18	1	0.1%
751.95	1	0.1%
751.74	1	0.1%
744.9	1	0.1%
744.77	1	0.1%

영월 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	491
Distinct (%)	86.9%
Missing	166
Missing (%)	22.7%
Infinite	0
Infinite (%)	0.0%
Mean	13.825168

Minimum	3.12
Maximum	46.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	3.12
5-th percentile	5.734
Q1	9.85
median	12.96
Q3	16.7
95-th percentile	24.342
Maximum	46.92
Range	43.8
Interquartile range (IQR)	6.85

Descriptive statistics

Standard deviation	6.2050956
Coefficient of variation (CV)	0.44882605
Kurtosis	4.7248975
Mean	13.825168
Median Absolute Deviation (MAD)	3.52
Skewness	1.5784361
Sum	7811.22
Variance	38.503212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.32	4	0.5%
13.74	3	0.4%
10.21	3	0.4%
10.14	3	0.4%
15.71	3	0.4%
12.54	3	0.4%
12.61	3	0.4%
16.87	3	0.4%
10.42	3	0.4%
8.6	2	0.3%
Other values (481)	535	73.2%
(Missing)	166	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.12	1	0.1%
3.69	1	0.1%
4.05	1	0.1%
4.11	1	0.1%
4.18	1	0.1%
4.42	1	0.1%
4.55	1	0.1%
4.65	1	0.1%
4.67	1	0.1%
4.69	1	0.1%

Value	Count	Frequency (%)
46.92	1	0.1%
46.75	1	0.1%
43.73	1	0.1%
39.83	1	0.1%
36.65	1	0.1%
36.56	1	0.1%
36.1	1	0.1%
35.26	1	0.1%
34.12	1	0.1%
33.91	1	0.1%

영월 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	535
Distinct (%)	94.7%
Missing	166
Missing (%)	22.7%
Infinite	0
Infinite (%)	0.0%
Mean	58.638814

Minimum	20.89
Maximum	410.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	20.89
5-th percentile	29.06
Q1	40.11
median	52.94
Q3	65.17
95-th percentile	108.752
Maximum	410.15
Range	389.26
Interquartile range (IQR)	25.06

Descriptive statistics

Standard deviation	35.969946
Coefficient of variation (CV)	0.6134153
Kurtosis	37.370071
Mean	58.638814
Median Absolute Deviation (MAD)	12.63
Skewness	5.0460062
Sum	33130.93
Variance	1293.837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74.27	3	0.4%
48.79	3	0.4%
45.85	2	0.3%
54.52	2	0.3%
59.85	2	0.3%
37.37	2	0.3%
37.55	2	0.3%
42.92	2	0.3%
70.59	2	0.3%
44.8	2	0.3%
Other values (525)	543	74.3%
(Missing)	166	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.89	1	0.1%
20.98	1	0.1%
22.12	1	0.1%
22.78	1	0.1%
23.02	1	0.1%
23.14	1	0.1%
23.71	1	0.1%
24.36	1	0.1%
24.62	1	0.1%
24.8	1	0.1%

Value	Count	Frequency (%)
410.15	1	0.1%
376.29	1	0.1%
306.64	1	0.1%
303.01	1	0.1%
302.63	1	0.1%
187.71	1	0.1%
172.43	1	0.1%
170.46	1	0.1%
161.74	1	0.1%
157.94	1	0.1%

안동 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	440
Distinct (%)	94.0%
Missing	263
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.939188

Minimum	2.49
Maximum	42.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	2.49
5-th percentile	6.7045
Q1	11.9575
median	16.89
Q3	23.9475
95-th percentile	31.8555
Maximum	42.95
Range	40.46
Interquartile range (IQR)	11.99

Descriptive statistics

Standard deviation	7.7495192
Coefficient of variation (CV)	0.43198829
Kurtosis	-0.35658587
Mean	17.939188
Median Absolute Deviation (MAD)	5.84
Skewness	0.42538407
Sum	8395.54
Variance	60.055048
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.11	3	0.4%
8.8	2	0.3%
8.98	2	0.3%
26.94	2	0.3%
12.1	2	0.3%
9.1	2	0.3%
11.05	2	0.3%
16.62	2	0.3%
18.53	2	0.3%
16.33	2	0.3%
Other values (430)	447	61.1%
(Missing)	263	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.49	1	0.1%
3.42	1	0.1%
3.59	1	0.1%
3.72	1	0.1%
3.88	1	0.1%
4.03	1	0.1%
4.34	1	0.1%
4.47	2	0.3%
4.67	1	0.1%
4.74	1	0.1%

Value	Count	Frequency (%)
42.95	1	0.1%
40.66	1	0.1%
38.75	1	0.1%
37.63	1	0.1%
37.56	1	0.1%
36.95	1	0.1%
36.21	1	0.1%
35.91	1	0.1%
34.91	1	0.1%
34.9	1	0.1%

안동 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	454
Distinct (%)	97.0%
Missing	263
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.601496

Minimum	20.71
Maximum	136.66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	20.71
5-th percentile	34.5155
Q1	47.0875
median	60.37
Q3	80.0225
95-th percentile	105.785
Maximum	136.66
Range	115.95
Interquartile range (IQR)	32.935

Descriptive statistics

Standard deviation	22.116378
Coefficient of variation (CV)	0.34235087
Kurtosis	-0.1584077
Mean	64.601496
Median Absolute Deviation (MAD)	16.2
Skewness	0.58666765
Sum	30233.5
Variance	489.13419
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80.75	2	0.3%
53.42	2	0.3%
93.46	2	0.3%
44.95	2	0.3%
53.1	2	0.3%
60.76	2	0.3%
41.2	2	0.3%
51.99	2	0.3%
56.79	2	0.3%
49.59	2	0.3%
Other values (444)	448	61.3%
(Missing)	263	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.71	1	0.1%
21.74	1	0.1%
24.97	1	0.1%
25.5	1	0.1%
27.45	1	0.1%
27.89	1	0.1%
28.69	2	0.3%
28.94	1	0.1%
29.75	1	0.1%
29.95	1	0.1%

Value	Count	Frequency (%)
136.66	1	0.1%
136.35	1	0.1%
135.32	1	0.1%
134.6	1	0.1%
115.38	1	0.1%
115.22	1	0.1%
114.41	1	0.1%
113.02	1	0.1%
112.16	1	0.1%
110.67	1	0.1%

삼척 평균(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	445
Distinct (%)	95.1%
Missing	263
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.070064

Minimum	7.94
Maximum	88.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	7.94
5-th percentile	19.624
Q1	26.26
median	33.55
Q3	41.525
95-th percentile	60.556
Maximum	88.13
Range	80.19
Interquartile range (IQR)	15.265

Descriptive statistics

Standard deviation	12.125604
Coefficient of variation (CV)	0.3457537
Kurtosis	1.858174
Mean	35.070064
Median Absolute Deviation (MAD)	7.45
Skewness	1.0541728
Sum	16412.79
Variance	147.03028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.63	2	0.3%
43.69	2	0.3%
25.29	2	0.3%
23.8	2	0.3%
21.49	2	0.3%
39.59	2	0.3%
35.94	2	0.3%
24.88	2	0.3%
25.42	2	0.3%
39.76	2	0.3%
Other values (435)	448	61.3%
(Missing)	263	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.94	1	0.1%
12.44	1	0.1%
12.47	1	0.1%
14.12	1	0.1%
14.22	1	0.1%
14.9	1	0.1%
14.95	1	0.1%
15.01	1	0.1%
15.2	1	0.1%
15.35	1	0.1%

Value	Count	Frequency (%)
88.13	1	0.1%
85.68	1	0.1%
77.09	1	0.1%
75.36	1	0.1%
73.66	1	0.1%
73.19	1	0.1%
72.4	1	0.1%
69.94	1	0.1%
69.23	1	0.1%
66.84	1	0.1%

삼척 최대(Mbps)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	456
Distinct (%)	97.4%
Missing	263
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.009103

Minimum	32.93
Maximum	224.07
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	32.93
5-th percentile	51.574
Q1	65.6475
median	89.09
Q3	110.37
95-th percentile	173.116
Maximum	224.07
Range	191.14
Interquartile range (IQR)	44.7225

Descriptive statistics

Standard deviation	36.190736
Coefficient of variation (CV)	0.38497055
Kurtosis	1.5148962
Mean	94.009103
Median Absolute Deviation (MAD)	22.505
Skewness	1.1774544
Sum	43996.26
Variance	1309.7694
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
103.83	3	0.4%
67.98	2	0.3%
87.73	2	0.3%
110.37	2	0.3%
61.52	2	0.3%
91.6	2	0.3%
96.85	2	0.3%
112.41	2	0.3%
110.09	2	0.3%
51.95	2	0.3%
Other values (446)	447	61.1%
(Missing)	263	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
32.93	1	0.1%
39.31	1	0.1%
40.44	1	0.1%
41.53	1	0.1%
43.78	1	0.1%
44.52	1	0.1%
44.9	1	0.1%
45.56	1	0.1%
45.77	1	0.1%
45.81	1	0.1%

Value	Count	Frequency (%)
224.07	1	0.1%
223.28	1	0.1%
221.36	1	0.1%
215.28	1	0.1%
214.13	1	0.1%
213.24	1	0.1%
205.56	1	0.1%
203.35	1	0.1%
202.65	1	0.1%
196.64	1	0.1%

부산 평균(Mbps)
Real number (ℝ)

MISSING

Distinct	508
Distinct (%)	92.2%
Missing	180
Missing (%)	24.6%
Infinite	0
Infinite (%)	0.0%
Mean	39.108966

Minimum	18.14
Maximum	87.31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	18.14
5-th percentile	25.025
Q1	32.15
median	37.62
Q3	43.99
95-th percentile	60.08
Maximum	87.31
Range	69.17
Interquartile range (IQR)	11.84

Descriptive statistics

Standard deviation	10.732321
Coefficient of variation (CV)	0.27442099
Kurtosis	2.5374514
Mean	39.108966
Median Absolute Deviation (MAD)	5.77
Skewness	1.302199
Sum	21549.04
Variance	115.18271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.9	3	0.4%
32.9	3	0.4%
24.14	2	0.3%
32.64	2	0.3%
33.52	2	0.3%
27.9	2	0.3%
34.53	2	0.3%
33.56	2	0.3%
45.48	2	0.3%
28.53	2	0.3%
Other values (498)	529	72.4%
(Missing)	180	24.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.14	1	0.1%
20.17	1	0.1%
21.0	2	0.3%
21.27	1	0.1%
22.23	1	0.1%
22.65	2	0.3%
23.05	1	0.1%
23.08	1	0.1%
23.17	1	0.1%
23.21	1	0.1%

Value	Count	Frequency (%)
87.31	1	0.1%
80.29	1	0.1%
79.27	1	0.1%
78.7	1	0.1%
77.92	1	0.1%
77.27	1	0.1%
75.68	1	0.1%
73.92	1	0.1%
73.72	1	0.1%
72.79	1	0.1%

부산 최대(Mbps)
Real number (ℝ)

MISSING

Distinct	537
Distinct (%)	97.5%
Missing	180
Missing (%)	24.6%
Infinite	0
Infinite (%)	0.0%
Mean	127.84969

Minimum	61.66
Maximum	342.73
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.6 KiB

Quantile statistics

Minimum	61.66
5-th percentile	79.275
Q1	98.625
median	119.53
Q3	154.14
95-th percentile	191.625
Maximum	342.73
Range	281.07
Interquartile range (IQR)	55.515

Descriptive statistics

Standard deviation	38.550499
Coefficient of variation (CV)	0.30152985
Kurtosis	2.5459576
Mean	127.84969
Median Absolute Deviation (MAD)	25.96
Skewness	1.1031384
Sum	70445.18
Variance	1486.1409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99.43	3	0.4%
119.57	2	0.3%
149.5	2	0.3%
109.31	2	0.3%
108.95	2	0.3%
114.95	2	0.3%
119.53	2	0.3%
89.71	2	0.3%
159.85	2	0.3%
117.72	2	0.3%
Other values (527)	530	72.5%
(Missing)	180	24.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61.66	1	0.1%
63.02	1	0.1%
64.34	1	0.1%
64.57	1	0.1%
66.04	1	0.1%
68.08	1	0.1%
68.77	1	0.1%
71.04	1	0.1%
71.78	1	0.1%
73.21	1	0.1%

Value	Count	Frequency (%)
342.73	1	0.1%
331.09	1	0.1%
254.9	1	0.1%
251.9	1	0.1%
246.03	1	0.1%
239.61	1	0.1%
233.34	1	0.1%
228.98	1	0.1%
225.43	1	0.1%
222.0	1	0.1%

Phik (φk)
Auto

Heatmap
Table

	본사 평균(Mbps)	본사 최대(Mbps)	하동 평균(Mbps)	하동 최대(Mbps)	남제주 평균(Mbps)	남제주 최대(Mbps)	인천 평균(Mbps)	인천 최대(Mbps)	영월 평균(Mbps)	영월 최대(Mbps)	안동 평균(Mbps)	안동 최대(Mbps)	삼척 평균(Mbps)	삼척 최대(Mbps)	부산 평균(Mbps)	부산 최대(Mbps)
본사 평균(Mbps)	1.000	0.562	0.360	0.358	0.000	0.094	0.863	0.524	0.124	0.312	0.416	0.535	0.683	0.446	0.250	0.116
본사 최대(Mbps)	0.562	1.000	0.337	0.238	0.194	0.144	0.630	0.663	0.295	0.575	0.278	0.356	0.338	0.356	0.000	0.243
하동 평균(Mbps)	0.360	0.337	1.000	0.826	0.749	0.376	0.769	0.385	0.672	0.407	0.486	0.401	0.626	0.627	0.670	0.230
하동 최대(Mbps)	0.358	0.238	0.826	1.000	0.507	0.745	0.602	0.454	0.571	0.573	0.441	0.451	0.551	0.584	0.416	0.520
남제주 평균(Mbps)	0.000	0.194	0.749	0.507	1.000	0.574	0.427	0.326	0.715	0.327	0.602	0.613	0.753	0.735	0.689	0.337
남제주 최대(Mbps)	0.094	0.144	0.376	0.745	0.574	1.000	0.345	0.350	0.457	0.520	0.429	0.359	0.531	0.568	0.378	0.521
인천 평균(Mbps)	0.863	0.630	0.769	0.602	0.427	0.345	1.000	0.665	0.361	0.593	0.387	0.425	0.611	0.506	0.497	0.000
인천 최대(Mbps)	0.524	0.663	0.385	0.454	0.326	0.350	0.665	1.000	0.244	0.495	0.324	0.222	0.340	0.346	0.307	0.728
영월 평균(Mbps)	0.124	0.295	0.672	0.571	0.715	0.457	0.361	0.244	1.000	0.650	0.578	0.527	0.722	0.733	0.670	0.327
영월 최대(Mbps)	0.312	0.575	0.407	0.573	0.327	0.520	0.593	0.495	0.650	1.000	0.199	0.213	0.359	0.418	0.238	0.366
안동 평균(Mbps)	0.416	0.278	0.486	0.441	0.602	0.429	0.387	0.324	0.578	0.199	1.000	0.851	0.707	0.707	0.742	0.245
안동 최대(Mbps)	0.535	0.356	0.401	0.451	0.613	0.359	0.425	0.222	0.527	0.213	0.851	1.000	0.675	0.687	0.503	0.216
삼척 평균(Mbps)	0.683	0.338	0.626	0.551	0.753	0.531	0.611	0.340	0.722	0.359	0.707	0.675	1.000	0.861	0.713	0.283
삼척 최대(Mbps)	0.446	0.356	0.627	0.584	0.735	0.568	0.506	0.346	0.733	0.418	0.707	0.687	0.861	1.000	0.720	0.302
부산 평균(Mbps)	0.250	0.000	0.670	0.416	0.689	0.378	0.497	0.307	0.670	0.238	0.742	0.503	0.713	0.720	1.000	0.461
부산 최대(Mbps)	0.116	0.243	0.230	0.520	0.337	0.521	0.000	0.728	0.327	0.366	0.245	0.216	0.283	0.302	0.461	1.000

Heatmap
Table

	본사 평균(Mbps)	본사 최대(Mbps)	하동 평균(Mbps)	하동 최대(Mbps)	남제주 평균(Mbps)	남제주 최대(Mbps)	인천 평균(Mbps)	인천 최대(Mbps)	영월 평균(Mbps)	영월 최대(Mbps)	안동 평균(Mbps)	안동 최대(Mbps)	삼척 평균(Mbps)	삼척 최대(Mbps)	부산 평균(Mbps)	부산 최대(Mbps)
본사 평균(Mbps)	1.000	0.384	0.218	0.245	0.157	0.162	0.064	-0.104	0.149	0.143	0.317	0.312	0.343	0.306	0.078	-0.089
본사 최대(Mbps)	0.384	1.000	0.289	0.300	0.130	0.095	0.295	0.156	0.119	0.157	0.207	0.189	0.260	0.318	-0.015	-0.155
하동 평균(Mbps)	0.218	0.289	1.000	0.878	0.562	0.391	0.511	0.225	0.488	0.392	0.570	0.503	0.637	0.668	0.449	-0.002
하동 최대(Mbps)	0.245	0.300	0.878	1.000	0.527	0.439	0.467	0.194	0.499	0.424	0.591	0.538	0.623	0.698	0.430	0.003
남제주 평균(Mbps)	0.157	0.130	0.562	0.527	1.000	0.661	0.363	0.131	0.383	0.281	0.533	0.474	0.551	0.551	0.425	0.001
남제주 최대(Mbps)	0.162	0.095	0.391	0.439	0.661	1.000	0.287	0.056	0.298	0.254	0.401	0.390	0.439	0.495	0.292	0.113
인천 평균(Mbps)	0.064	0.295	0.511	0.467	0.363	0.287	1.000	0.704	0.453	0.425	0.340	0.291	0.348	0.400	0.310	0.069
인천 최대(Mbps)	-0.104	0.156	0.225	0.194	0.131	0.056	0.704	1.000	0.162	0.186	0.094	0.052	0.098	0.133	0.158	0.315
영월 평균(Mbps)	0.149	0.119	0.488	0.499	0.383	0.298	0.453	0.162	1.000	0.791	0.409	0.420	0.473	0.549	0.415	0.025
영월 최대(Mbps)	0.143	0.157	0.392	0.424	0.281	0.254	0.425	0.186	0.791	1.000	0.243	0.277	0.317	0.423	0.276	0.044
안동 평균(Mbps)	0.317	0.207	0.570	0.591	0.533	0.401	0.340	0.094	0.409	0.243	1.000	0.865	0.707	0.647	0.468	-0.089
안동 최대(Mbps)	0.312	0.189	0.503	0.538	0.474	0.390	0.291	0.052	0.420	0.277	0.865	1.000	0.633	0.601	0.386	-0.078
삼척 평균(Mbps)	0.343	0.260	0.637	0.623	0.551	0.439	0.348	0.098	0.473	0.317	0.707	0.633	1.000	0.831	0.407	-0.087
삼척 최대(Mbps)	0.306	0.318	0.668	0.698	0.551	0.495	0.400	0.133	0.549	0.423	0.647	0.601	0.831	1.000	0.438	-0.080
부산 평균(Mbps)	0.078	-0.015	0.449	0.430	0.425	0.292	0.310	0.158	0.415	0.276	0.468	0.386	0.407	0.438	1.000	0.386
부산 최대(Mbps)	-0.089	-0.155	-0.002	0.003	0.001	0.113	0.069	0.315	0.025	0.044	-0.089	-0.078	-0.087	-0.080	0.386	1.000

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	구분	본사 평균(Mbps)	본사 최대(Mbps)	하동 평균(Mbps)	하동 최대(Mbps)	남제주 평균(Mbps)	남제주 최대(Mbps)	인천 평균(Mbps)	인천 최대(Mbps)	영월 평균(Mbps)	영월 최대(Mbps)	안동 평균(Mbps)	안동 최대(Mbps)	삼척 평균(Mbps)	삼척 최대(Mbps)	부산 평균(Mbps)	부산 최대(Mbps)
0	2022-05-01	96.48	486.68	60.37	128.71	45.27	111.03	35.33	73.21	5.5	24.81	6.16	45.14	24.58	62.86	32.51	84.7
1	2022-05-02	118.2	659.43	95.6	274.2	61.27	128.85	41.89	96.08	15.51	61.67	22.02	67.59	32.4	87.73	38.89	201.11
2	2022-05-03	135.47	716.43	91.26	212.39	57.59	131.2	46.88	123.5	20.16	66.47	22.85	65.95	30.25	86.32	42.88	131.7
3	2022-05-04	127.36	643.55	89.48	267.58	51.26	126.0	48.19	114.13	16.65	57.24	24.97	98.42	30.43	85.62	51.56	117.79
4	2022-05-05	94.09	601.27	77.47	156.39	48.11	105.47	29.44	84.3	6.92	48.47	13.65	38.01	15.01	50.13	44.73	99.89
5	2022-05-06	115.54	587.26	88.06	222.03	48.2	120.34	39.61	103.16	8.19	35.77	26.59	76.4	37.49	90.09	40.95	118.23
6	2022-05-07	114.13	592.38	80.34	146.29	54.27	108.95	42.29	148.38	9.44	33.11	13.07	51.31	20.19	57.16	42.72	194.96
7	2022-05-08	101.66	433.12	70.63	136.56	47.7	102.12	37.99	106.92	17.69	67.8	17.0	57.95	14.95	44.9	48.85	116.23
8	2022-05-09	112.95	594.31	86.45	171.56	45.03	128.82	40.04	92.47	16.62	69.84	29.74	96.54	30.21	85.56	48.3	147.46
9	2022-05-10	170.36	671.47	91.79	266.16	55.19	141.27	43.76	99.63	15.77	54.02	27.42	81.53	32.34	102.14	54.87	141.81

	구분	본사 평균(Mbps)	본사 최대(Mbps)	하동 평균(Mbps)	하동 최대(Mbps)	남제주 평균(Mbps)	남제주 최대(Mbps)	인천 평균(Mbps)	인천 최대(Mbps)	영월 평균(Mbps)	영월 최대(Mbps)	안동 평균(Mbps)	안동 최대(Mbps)	삼척 평균(Mbps)	삼척 최대(Mbps)	부산 평균(Mbps)	부산 최대(Mbps)
721	2024-04-21	79.86	599.75	93.03	192.98	45.17	125.52	79.86	599.75	5.58	38.26	5.82	33.43	24.34	69.95	36.26	142.41
722	2024-04-22	106.7	673.13	156.83	451.48	59.21	147.69	106.7	673.13	23.44	84.46	30.38	103.45	49.08	146.91	55.58	154.13
723	2024-04-23	76.99	638.31	125.78	267.95	47.57	121.8	76.99	638.31	20.02	62.17	30.62	105.82	47.17	141.29	44.7	112.58
724	2024-04-24	114.45	666.56	131.28	350.21	41.89	107.63	114.45	666.56	14.35	64.05	20.07	79.59	39.51	117.12	42.28	117.72
725	2024-04-25	82.58	590.81	121.21	330.26	50.67	130.96	82.58	590.81	20.53	72.06	22.11	79.29	41.57	104.63	41.95	113.81
726	2024-04-26	95.39	693.05	104.29	244.11	63.3	143.76	95.39	693.05	9.79	57.59	24.2	93.46	32.1	93.16	30.54	92.48
727	2024-04-27	104.29	802.88	93.81	188.8	45.15	110.16	104.29	802.88	7.81	40.99	8.63	34.42	22.91	65.56	23.08	190.3
728	2024-04-28	61.34	751.95	81.5	177.29	34.85	96.7	61.34	751.95	6.08	32.81	8.09	52.79	19.47	57.35	31.28	145.49
729	2024-04-29	94.97	531.21	95.33	244.22	53.17	131.79	94.97	531.21	19.56	59.26	32.39	96.8	42.16	126.09	57.35	144.8
730	2024-04-30	95.56	672.74	92.37	172.66	44.82	105.34	95.56	672.74	14.6	62.11	20.99	69.35	42.29	134.39	53.36	158.16

Overview

Variables

Interactions

Correlations

Missing values

Sample