Overview

Dataset statistics

Number of variables5
Number of observations157
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.4 KiB
Average record size in memory41.8 B

Variable types

Numeric1
Categorical3
Text1

Dataset

Description광주광역시 남부소방서 무선통신장비 현황 알림- 상세내용: 무선통신장비 구분, 관리번호, 모델명, 제조사 등 정보 데이터 제공
Author광주광역시
URLhttps://www.data.go.kr/data/15040506/fileData.do

Alerts

제조사 is highly overall correlated with 모델명High correlation
모델명 is highly overall correlated with 구분 and 1 other fieldsHigh correlation
연번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
제조사 is highly imbalanced (82.9%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:30:27.097008
Analysis finished2023-12-12 08:30:27.637018
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct157
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79
Minimum1
Maximum157
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-12T17:30:27.713355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8.8
Q140
median79
Q3118
95-th percentile149.2
Maximum157
Range156
Interquartile range (IQR)78

Descriptive statistics

Standard deviation45.466105
Coefficient of variation (CV)0.57552031
Kurtosis-1.2
Mean79
Median Absolute Deviation (MAD)39
Skewness0
Sum12403
Variance2067.1667
MonotonicityStrictly increasing
2023-12-12T17:30:27.871902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
109 1
 
0.6%
102 1
 
0.6%
103 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
110 1
 
0.6%
Other values (147) 147
93.6%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
157 1
0.6%
156 1
0.6%
155 1
0.6%
154 1
0.6%
153 1
0.6%
152 1
0.6%
151 1
0.6%
150 1
0.6%
149 1
0.6%
148 1
0.6%

구분
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
휴대국
121 
차량국
31 
기지국
 
5

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기지국
2nd row기지국
3rd row기지국
4th row기지국
5th row기지국

Common Values

ValueCountFrequency (%)
휴대국 121
77.1%
차량국 31
 
19.7%
기지국 5
 
3.2%

Length

2023-12-12T17:30:28.050389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:30:28.192119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
휴대국 121
77.1%
차량국 31
 
19.7%
기지국 5
 
3.2%

관리번호
Text

Distinct148
Distinct (%)94.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-12T17:30:28.523780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.955414
Min length5

Characters and Unicode

Total characters935
Distinct characters20
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique139 ?
Unique (%)88.5%

Sample

1st row남부기지01
2nd row남부기지02
3rd row남부기지03
4th row남부기지04
5th row남부기지05
ValueCountFrequency (%)
남부014 2
 
1.3%
남부028 2
 
1.3%
남부029 2
 
1.3%
남부012 2
 
1.3%
남부013 2
 
1.3%
남부030 2
 
1.3%
남부015 2
 
1.3%
남부016 2
 
1.3%
남부027 2
 
1.3%
남부070 1
 
0.6%
Other values (138) 138
87.9%
2023-12-12T17:30:29.090528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
남 157
16.8%
부 157
16.8%
0 151
16.1%
114
12.2%
1 49
 
5.2%
2 41
 
4.4%
량 31
 
3.3%
차 31
 
3.3%
3 30
 
3.2%
5 27
 
2.9%
Other values (10) 147
15.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 421
45.0%
Other Letter 400
42.8%
Space Separator 114
 
12.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 151
35.9%
1 49
 
11.6%
2 41
 
9.7%
3 30
 
7.1%
5 27
 
6.4%
4 27
 
6.4%
9 24
 
5.7%
8 24
 
5.7%
6 24
 
5.7%
7 24
 
5.7%
Other Letter
ValueCountFrequency (%)
남 157
39.2%
부 157
39.2%
량 31
 
7.8%
차 31
 
7.8%
지 10
 
2.5%
기 5
 
1.2%
휘 5
 
1.2%
예 2
 
0.5%
비 2
 
0.5%
Space Separator
ValueCountFrequency (%)
114
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 535
57.2%
Hangul 400
42.8%

Most frequent character per script

Common
ValueCountFrequency (%)
0 151
28.2%
114
21.3%
1 49
 
9.2%
2 41
 
7.7%
3 30
 
5.6%
5 27
 
5.0%
4 27
 
5.0%
9 24
 
4.5%
8 24
 
4.5%
6 24
 
4.5%
Hangul
ValueCountFrequency (%)
남 157
39.2%
부 157
39.2%
량 31
 
7.8%
차 31
 
7.8%
지 10
 
2.5%
기 5
 
1.2%
휘 5
 
1.2%
예 2
 
0.5%
비 2
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 535
57.2%
Hangul 400
42.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
남 157
39.2%
부 157
39.2%
량 31
 
7.8%
차 31
 
7.8%
지 10
 
2.5%
기 5
 
1.2%
휘 5
 
1.2%
예 2
 
0.5%
비 2
 
0.5%
ASCII
ValueCountFrequency (%)
0 151
28.2%
114
21.3%
1 49
 
9.2%
2 41
 
7.7%
3 30
 
5.6%
5 27
 
5.0%
4 27
 
5.0%
9 24
 
4.5%
8 24
 
4.5%
6 24
 
4.5%

모델명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
PD-568
104 
MD-788G
32 
CN/X1p
13 
XIR-M8668
 
3
CN/X1P
 
2
Other values (2)
 
3

Length

Max length9
Median length6
Mean length6.2866242
Min length6

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st rowMD-788G
2nd rowMD-788G
3rd rowMD-788G
4th rowMD-788G
5th rowMD-788G

Common Values

ValueCountFrequency (%)
PD-568 104
66.2%
MD-788G 32
 
20.4%
CN/X1p 13
 
8.3%
XIR-M8668 3
 
1.9%
CN/X1P 2
 
1.3%
PD-668G 2
 
1.3%
XIRM8668 1
 
0.6%

Length

2023-12-12T17:30:29.291013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:30:29.419372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pd-568 104
66.2%
md-788g 32
 
20.4%
cn/x1p 15
 
9.6%
xir-m8668 3
 
1.9%
pd-668g 2
 
1.3%
xirm8668 1
 
0.6%

제조사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
하이테라
153 
모토로라
 
4

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row하이테라
2nd row하이테라
3rd row하이테라
4th row하이테라
5th row하이테라

Common Values

ValueCountFrequency (%)
하이테라 153
97.5%
모토로라 4
 
2.5%

Length

2023-12-12T17:30:29.550049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:30:29.667830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
하이테라 153
97.5%
모토로라 4
 
2.5%

Interactions

2023-12-12T17:30:27.297427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:30:30.093729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분모델명제조사
연번1.0000.8170.7190.555
구분0.8171.0000.7640.187
모델명0.7190.7641.0001.000
제조사0.5550.1871.0001.000
2023-12-12T17:30:30.230445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제조사구분모델명
제조사1.0000.3070.984
구분0.3071.0000.691
모델명0.9840.6911.000
2023-12-12T17:30:30.353998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분모델명제조사
연번1.0000.7000.4680.417
구분0.7001.0000.6910.307
모델명0.4680.6911.0000.984
제조사0.4170.3070.9841.000

Missing values

2023-12-12T17:30:27.490313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:30:27.598094image/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

연번구분관리번호모델명제조사
01기지국남부기지01MD-788G하이테라
12기지국남부기지02MD-788G하이테라
23기지국남부기지03MD-788G하이테라
34기지국남부기지04MD-788G하이테라
45기지국남부기지05MD-788G하이테라
56차량국남부차량01MD-788G하이테라
67차량국남부차량02MD-788G하이테라
78차량국남부차량03MD-788G하이테라
89차량국남부차량04MD-788G하이테라
910차량국남부차량05MD-788G하이테라
연번구분관리번호모델명제조사
147148휴대국남부103PD-568하이테라
148149휴대국남부104PD-568하이테라
149150휴대국남부105PD-568하이테라
150151휴대국남부지휘1CN/X1p하이테라
151152휴대국남부지휘2CN/X1p하이테라
152153휴대국남부지휘3CN/X1p하이테라
153154휴대국남부지휘4CN/X1p하이테라
154155휴대국남부지휘5CN/X1p하이테라
155156휴대국남부예비1PD-668G하이테라
156157휴대국남부예비2PD-668G하이테라