Overview

Dataset statistics

Number of variables4
Number of observations51
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory36.6 B

Variable types

Categorical2
Numeric2

Dataset

Description2022년 통신서비스 품질평가 결과 보고서 내 , 전국 85개시 430개 지역 대상의 권역별 5G전송속도(Mbps) 결과 데이터
URLhttps://www.data.go.kr/data/15105755/fileData.do

Alerts

다운로드(Mbps) is highly overall correlated with 업로드(Mbps) and 1 other fieldsHigh correlation
업로드(Mbps) is highly overall correlated with 다운로드(Mbps)High correlation
통신사 is highly overall correlated with 다운로드(Mbps)High correlation
다운로드(Mbps) has unique valuesUnique
업로드(Mbps) has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:50:10.553949
Analysis finished2023-12-12 10:50:12.382165
Duration1.83 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분(지역)
Categorical

Distinct17
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size540.0 B
서울특별시
 
3
부산광역시
 
3
대구광역시
 
3
인천광역시
 
3
광주광역시
 
3
Other values (12)
36 

Length

Max length5
Median length5
Mean length4.4117647
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row서울특별시
3rd row서울특별시
4th row부산광역시
5th row부산광역시

Common Values

ValueCountFrequency (%)
서울특별시 3
 
5.9%
부산광역시 3
 
5.9%
대구광역시 3
 
5.9%
인천광역시 3
 
5.9%
광주광역시 3
 
5.9%
대전광역시 3
 
5.9%
울산광역시 3
 
5.9%
세종자치시 3
 
5.9%
경기도 3
 
5.9%
강원도 3
 
5.9%
Other values (7) 21
41.2%

Length

2023-12-12T19:50:12.576361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울특별시 3
 
5.9%
강원도 3
 
5.9%
경상남도 3
 
5.9%
경상북도 3
 
5.9%
전라남도 3
 
5.9%
전라북도 3
 
5.9%
충청남도 3
 
5.9%
충청북도 3
 
5.9%
경기도 3
 
5.9%
부산광역시 3
 
5.9%
Other values (7) 21
41.2%

통신사
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size540.0 B
SKT
17 
KT
17 
LGU+
17 

Length

Max length4
Median length3
Mean length3
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSKT
2nd rowKT
3rd rowLGU+
4th rowSKT
5th rowKT

Common Values

ValueCountFrequency (%)
SKT 17
33.3%
KT 17
33.3%
LGU+ 17
33.3%

Length

2023-12-12T19:50:12.932817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:50:13.213120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
skt 17
33.3%
kt 17
33.3%
lgu 17
33.3%

다운로드(Mbps)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct51
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean916.77176
Minimum676.3
Maximum1194.22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size591.0 B
2023-12-12T19:50:13.499636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum676.3
5-th percentile708.545
Q1836.695
median935.86
Q31004.55
95-th percentile1093.305
Maximum1194.22
Range517.92
Interquartile range (IQR)167.855

Descriptive statistics

Standard deviation129.92674
Coefficient of variation (CV)0.14172201
Kurtosis-0.73754164
Mean916.77176
Median Absolute Deviation (MAD)83.37
Skewness-0.18467206
Sum46755.36
Variance16880.958
MonotonicityNot monotonic
2023-12-12T19:50:13.811256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
994.92 1
 
2.0%
935.86 1
 
2.0%
903.65 1
 
2.0%
913.45 1
 
2.0%
1083.39 1
 
2.0%
942.82 1
 
2.0%
771.53 1
 
2.0%
985.45 1
 
2.0%
860.29 1
 
2.0%
708.56 1
 
2.0%
Other values (41) 41
80.4%
ValueCountFrequency (%)
676.3 1
2.0%
683.81 1
2.0%
708.53 1
2.0%
708.56 1
2.0%
715.03 1
2.0%
723.63 1
2.0%
730.68 1
2.0%
741.56 1
2.0%
750.07 1
2.0%
758.87 1
2.0%
ValueCountFrequency (%)
1194.22 1
2.0%
1135.64 1
2.0%
1103.22 1
2.0%
1083.39 1
2.0%
1078.13 1
2.0%
1078.01 1
2.0%
1072.76 1
2.0%
1072.41 1
2.0%
1034.95 1
2.0%
1029.21 1
2.0%

업로드(Mbps)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct51
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean94.776863
Minimum58.25
Maximum122.74
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size591.0 B
2023-12-12T19:50:14.225988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum58.25
5-th percentile65.4
Q188.245
median96.33
Q3103.155
95-th percentile112.665
Maximum122.74
Range64.49
Interquartile range (IQR)14.91

Descriptive statistics

Standard deviation13.647241
Coefficient of variation (CV)0.14399339
Kurtosis0.80261479
Mean94.776863
Median Absolute Deviation (MAD)7.9
Skewness-0.75787234
Sum4833.62
Variance186.2472
MonotonicityNot monotonic
2023-12-12T19:50:14.787563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
113.25 1
 
2.0%
94.4 1
 
2.0%
95.66 1
 
2.0%
95.51 1
 
2.0%
112.26 1
 
2.0%
86.47 1
 
2.0%
96.71 1
 
2.0%
101.52 1
 
2.0%
86.3 1
 
2.0%
85.09 1
 
2.0%
Other values (41) 41
80.4%
ValueCountFrequency (%)
58.25 1
2.0%
62.42 1
2.0%
65.26 1
2.0%
65.54 1
2.0%
69.51 1
2.0%
81.3 1
2.0%
83.83 1
2.0%
85.09 1
2.0%
86.3 1
2.0%
86.47 1
2.0%
ValueCountFrequency (%)
122.74 1
2.0%
113.25 1
2.0%
112.9 1
2.0%
112.43 1
2.0%
112.26 1
2.0%
111.18 1
2.0%
109.51 1
2.0%
109.36 1
2.0%
107.94 1
2.0%
106.79 1
2.0%

Interactions

2023-12-12T19:50:11.336559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:50:10.871236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:50:11.653477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:50:11.069966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:50:15.222372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분(지역)통신사다운로드(Mbps)업로드(Mbps)
구분(지역)1.0000.0000.3800.000
통신사0.0001.0000.7390.820
다운로드(Mbps)0.3800.7391.0000.739
업로드(Mbps)0.0000.8200.7391.000
2023-12-12T19:50:15.638210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분(지역)통신사
구분(지역)1.0000.000
통신사0.0001.000
2023-12-12T19:50:15.930237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
다운로드(Mbps)업로드(Mbps)구분(지역)통신사
다운로드(Mbps)1.0000.7380.1190.566
업로드(Mbps)0.7381.0000.0000.493
구분(지역)0.1190.0001.0000.000
통신사0.5660.4930.0001.000

Missing values

2023-12-12T19:50:12.122054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:50:12.300693image/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

구분(지역)통신사다운로드(Mbps)업로드(Mbps)
0서울특별시SKT994.92113.25
1서울특별시KT935.8694.4
2서울특별시LGU+901.9698.96
3부산광역시SKT1103.22112.43
4부산광역시KT978.5899.81
5부산광역시LGU+723.6365.54
6대구광역시SKT983.93101.96
7대구광역시KT981.6689.38
8대구광역시LGU+683.8158.25
9인천광역시SKT970.99111.18
구분(지역)통신사다운로드(Mbps)업로드(Mbps)
41전라남도LGU+741.5687.61
42경상북도SKT1135.64107.94
43경상북도KT1016.0589.96
44경상북도LGU+715.0365.26
45경상남도SKT988.57100.72
46경상남도KT896.5583.83
47경상남도LGU+676.362.42
48제주자치도SKT1078.01109.51
49제주자치도KT1014.1888.43
50제주자치도LGU+797.0101.37