Overview

Dataset statistics

Number of variables4
Number of observations2254
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory75.0 KiB
Average record size in memory34.1 B

Variable types

Categorical1
DateTime1
Numeric2

Dataset

Description한국중부발전(주)의 사업소별 네트워크 트래픽 현황이며 항목명은 "사업소", "기준일시", "입력(IN)_Mbps", "출력(Out)_Mbps"로 구성되어 있음
URLhttps://www.data.go.kr/data/15114227/fileData.do

Alerts

입력(In)_Mbps is highly overall correlated with 출력(Out)_MbpsHigh correlation
출력(Out)_Mbps is highly overall correlated with 입력(In)_MbpsHigh correlation

Reproduction

Analysis started2023-12-12 17:10:14.652442
Analysis finished2023-12-12 17:10:15.525987
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사업소
Categorical

Distinct8
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
본사
364 
보령
364 
신서천
364 
서울
364 
인천
364 
Other values (3)
434 

Length

Max length3
Median length2
Mean length2.1770186
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row본사
2nd row본사
3rd row본사
4th row본사
5th row본사

Common Values

ValueCountFrequency (%)
본사 364
16.1%
보령 364
16.1%
신서천 364
16.1%
서울 364
16.1%
인천 364
16.1%
제주 364
16.1%
신보령 35
 
1.6%
세종 35
 
1.6%

Length

2023-12-13T02:10:15.969776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:10:16.094545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
본사 364
16.1%
보령 364
16.1%
신서천 364
16.1%
서울 364
16.1%
인천 364
16.1%
제주 364
16.1%
신보령 35
 
1.6%
세종 35
 
1.6%

기준일시
Date

Distinct364
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
Minimum2022-06-01 00:00:00
Maximum2023-05-30 00:00:00
2023-12-13T02:10:16.273932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:10:16.456079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

입력(In)_Mbps
Real number (ℝ)

HIGH CORRELATION 

Distinct1310
Distinct (%)58.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.871615
Minimum0.6897
Maximum272.33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T02:10:16.662264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.6897
5-th percentile3.47
Q15.87
median8.57
Q319.7875
95-th percentile40.1935
Maximum272.33
Range271.6403
Interquartile range (IQR)13.9175

Descriptive statistics

Standard deviation21.952625
Coefficient of variation (CV)1.3831375
Kurtosis53.353369
Mean15.871615
Median Absolute Deviation (MAD)4.58
Skewness6.2854263
Sum35774.62
Variance481.91776
MonotonicityNot monotonic
2023-12-13T02:10:16.845653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6.36 13
 
0.6%
6.42 12
 
0.5%
5.36 9
 
0.4%
6.44 9
 
0.4%
6.73 9
 
0.4%
5.32 8
 
0.4%
6.77 8
 
0.4%
6.34 8
 
0.4%
5.76 8
 
0.4%
6.41 8
 
0.4%
Other values (1300) 2162
95.9%
ValueCountFrequency (%)
0.6897 1
< 0.1%
0.70239 1
< 0.1%
0.73173 1
< 0.1%
0.74696 1
< 0.1%
0.75031 1
< 0.1%
0.76049 1
< 0.1%
0.80939 1
< 0.1%
0.82669 1
< 0.1%
0.82722 1
< 0.1%
0.84916 1
< 0.1%
ValueCountFrequency (%)
272.33 1
< 0.1%
247.86 1
< 0.1%
243.6 1
< 0.1%
238.85 1
< 0.1%
229.71 1
< 0.1%
226.55 1
< 0.1%
224.87 1
< 0.1%
220.96 1
< 0.1%
220.55 1
< 0.1%
216.58 1
< 0.1%

출력(Out)_Mbps
Real number (ℝ)

HIGH CORRELATION 

Distinct1521
Distinct (%)67.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49.511155
Minimum0.00113
Maximum999.88
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T02:10:17.062548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.00113
5-th percentile1.47
Q17.475
median17.16
Q323.2825
95-th percentile148.717
Maximum999.88
Range999.87887
Interquartile range (IQR)15.8075

Descriptive statistics

Standard deviation138.77185
Coefficient of variation (CV)2.8028401
Kurtosis28.231891
Mean49.511155
Median Absolute Deviation (MAD)9.25
Skewness5.2493719
Sum111598.14
Variance19257.627
MonotonicityNot monotonic
2023-12-13T02:10:17.273905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10.65 8
 
0.4%
7.65 7
 
0.3%
11.66 6
 
0.3%
7.15 6
 
0.3%
7.09 6
 
0.3%
19.42 6
 
0.3%
2.28 6
 
0.3%
6.89 5
 
0.2%
7.16 5
 
0.2%
7.0 5
 
0.2%
Other values (1511) 2194
97.3%
ValueCountFrequency (%)
0.00113 1
< 0.1%
0.00124 1
< 0.1%
0.00135 1
< 0.1%
0.00148 1
< 0.1%
0.00151 1
< 0.1%
0.00154 1
< 0.1%
0.00157 1
< 0.1%
0.00159 1
< 0.1%
0.0016 1
< 0.1%
0.00161 1
< 0.1%
ValueCountFrequency (%)
999.88 1
< 0.1%
993.46 1
< 0.1%
993.33 1
< 0.1%
988.29 1
< 0.1%
987.55 1
< 0.1%
980.33 1
< 0.1%
978.5 1
< 0.1%
974.1 1
< 0.1%
972.78 1
< 0.1%
962.69 1
< 0.1%

Interactions

2023-12-13T02:10:15.057293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:10:14.821183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:10:15.183883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:10:14.946794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:10:17.366869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업소입력(In)_Mbps출력(Out)_Mbps
사업소1.0000.5290.426
입력(In)_Mbps0.5291.0000.833
출력(Out)_Mbps0.4260.8331.000
2023-12-13T02:10:17.457826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
입력(In)_Mbps출력(Out)_Mbps사업소
입력(In)_Mbps1.0000.7730.286
출력(Out)_Mbps0.7731.0000.219
사업소0.2860.2191.000

Missing values

2023-12-13T02:10:15.339980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:10:15.464410image/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

사업소기준일시입력(In)_Mbps출력(Out)_Mbps
0본사2022-06-01 00:00:0041.67113.44
1본사2022-06-02 00:00:0037.0197.77
2본사2022-06-03 00:00:0043.53120.38
3본사2022-06-04 00:00:0093.92320.08
4본사2022-06-05 00:00:0030.9675.7
5본사2022-06-06 00:00:0030.5177.66
6본사2022-06-07 00:00:0031.1177.3
7본사2022-06-08 00:00:0042.22117.48
8본사2022-06-09 00:00:0038.34101.97
9본사2022-06-10 00:00:0087.95164.75
사업소기준일시입력(In)_Mbps출력(Out)_Mbps
2244제주2023-05-21 00:00:0013.8720.66
2245제주2023-05-22 00:00:0013.8620.64
2246제주2023-05-23 00:00:0013.7220.51
2247제주2023-05-24 00:00:0013.8620.72
2248제주2023-05-25 00:00:0013.6220.21
2249제주2023-05-26 00:00:0015.4223.9
2250제주2023-05-27 00:00:0013.7120.47
2251제주2023-05-28 00:00:0013.5220.1
2252제주2023-05-29 00:00:0013.6520.36
2253제주2023-05-30 00:00:0013.720.45