Overview

Dataset statistics

Number of variables4
Number of observations1463
Missing cells2
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory47.3 KiB
Average record size in memory33.1 B

Variable types

Numeric1
Text1
Categorical2

Dataset

Description대전광역시 서구에서 사용 중인 행정업무용 컴퓨터 보유 현황(부서명, 제조사, PC모델) 데이터로 대상은 본청 및 동, 사업소에서 직원이 업무용도로 사용중인 PC입니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/15116072/fileData.do

Alerts

PC모델 is highly overall correlated with 제조사High correlation
제조사 is highly overall correlated with PC모델High correlation
제조사 is highly imbalanced (51.9%)Imbalance

Reproduction

Analysis started2024-04-21 01:46:39.642219
Analysis finished2024-04-21 01:46:41.158361
Duration1.52 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

Distinct1462
Distinct (%)100.0%
Missing1
Missing (%)0.1%
Infinite0
Infinite (%)0.0%
Mean731.5
Minimum1
Maximum1462
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.0 KiB
2024-04-21T10:46:41.376452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile74.05
Q1366.25
median731.5
Q31096.75
95-th percentile1388.95
Maximum1462
Range1461
Interquartile range (IQR)730.5

Descriptive statistics

Standard deviation422.18736
Coefficient of variation (CV)0.57715292
Kurtosis-1.2
Mean731.5
Median Absolute Deviation (MAD)365.5
Skewness0
Sum1069453
Variance178242.17
MonotonicityStrictly increasing
2024-04-21T10:46:41.819797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
984 1
 
0.1%
982 1
 
0.1%
981 1
 
0.1%
980 1
 
0.1%
979 1
 
0.1%
978 1
 
0.1%
977 1
 
0.1%
976 1
 
0.1%
975 1
 
0.1%
Other values (1452) 1452
99.2%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1462 1
0.1%
1461 1
0.1%
1460 1
0.1%
1459 1
0.1%
1458 1
0.1%
1457 1
0.1%
1456 1
0.1%
1455 1
0.1%
1454 1
0.1%
1453 1
0.1%

부서명
Text

Distinct65
Distinct (%)4.4%
Missing1
Missing (%)0.1%
Memory size11.6 KiB
2024-04-21T10:46:42.762375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length7
Mean length4.6805746
Min length2

Characters and Unicode

Total characters6843
Distinct characters107
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

Unique4 ?
Unique (%)0.3%

Sample

1st row가수원동
2nd row가수원동
3rd row가수원동
4th row가수원동
5th row가수원동
ValueCountFrequency (%)
대전광역시 97
 
6.2%
서구청 97
 
6.2%
건강증진과 76
 
4.9%
도서관운영과 51
 
3.3%
보건행정과 44
 
2.8%
건설과 44
 
2.8%
복지정책과 40
 
2.6%
주차행정과 38
 
2.4%
회계과 37
 
2.4%
의회사무국 35
 
2.2%
Other values (56) 1000
64.1%
2024-04-21T10:46:44.086405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
과 874
 
12.8%
동 435
 
6.4%
정 275
 
4.0%
지 203
 
3.0%
건 191
 
2.8%
원 154
 
2.3%
서 148
 
2.2%
전 147
 
2.1%
도 137
 
2.0%
시 133
 
1.9%
Other values (97) 4146
60.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6540
95.6%
Decimal Number 206
 
3.0%
Space Separator 97
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 874
 
13.4%
동 435
 
6.7%
정 275
 
4.2%
지 203
 
3.1%
건 191
 
2.9%
원 154
 
2.4%
서 148
 
2.3%
전 147
 
2.2%
도 137
 
2.1%
시 133
 
2.0%
Other values (93) 3843
58.8%
Decimal Number
ValueCountFrequency (%)
2 99
48.1%
1 76
36.9%
3 31
 
15.0%
Space Separator
ValueCountFrequency (%)
97
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6540
95.6%
Common 303
 
4.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 874
 
13.4%
동 435
 
6.7%
정 275
 
4.2%
지 203
 
3.1%
건 191
 
2.9%
원 154
 
2.4%
서 148
 
2.3%
전 147
 
2.2%
도 137
 
2.1%
시 133
 
2.0%
Other values (93) 3843
58.8%
Common
ValueCountFrequency (%)
2 99
32.7%
97
32.0%
1 76
25.1%
3 31
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6540
95.6%
ASCII 303
 
4.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
과 874
 
13.4%
동 435
 
6.7%
정 275
 
4.2%
지 203
 
3.1%
건 191
 
2.9%
원 154
 
2.4%
서 148
 
2.3%
전 147
 
2.2%
도 137
 
2.1%
시 133
 
2.0%
Other values (93) 3843
58.8%
ASCII
ValueCountFrequency (%)
2 99
32.7%
97
32.0%
1 76
25.1%
3 31
 
10.2%

제조사
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct16
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
DAEWOOLUCOMS
687 
DANAWA COMPUTER Co., Ltd.
348 
ATEC
318 
JOOYONTECH
 
66
Jooyon Tech Co Ltd
 
15
Other values (11)
 
29

Length

Max length29
Median length27
Mean length13.449077
Min length2

Unique

Unique5 ?
Unique (%)0.3%

Sample

1st rowDANAWA COMPUTER Co., Ltd.
2nd rowDAEWOOLUCOMS
3rd rowDAEWOOLUCOMS
4th rowDAEWOOLUCOMS
5th rowATEC

Common Values

ValueCountFrequency (%)
DAEWOOLUCOMS 687
47.0%
DANAWA COMPUTER Co., Ltd. 348
23.8%
ATEC 318
21.7%
JOOYONTECH 66
 
4.5%
Jooyon Tech Co Ltd 15
 
1.0%
LG Electronics 8
 
0.5%
Gigabyte Technology Co., Ltd. 5
 
0.3%
Jooyontech Computer 4
 
0.3%
TRIGEM COMPUTER 3
 
0.2%
SAMSUNG ELECTRONICS CO.,LTD 2
 
0.1%
Other values (6) 7
 
0.5%

Length

2024-04-21T10:46:44.518430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
daewoolucoms 687
26.5%
co 370
14.3%
ltd 370
14.3%
computer 355
13.7%
danawa 348
13.4%
atec 318
12.3%
jooyontech 70
 
2.7%
jooyon 15
 
0.6%
tech 15
 
0.6%
electronics 12
 
0.5%
Other values (12) 33
 
1.3%

PC모델
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Q500SF
472 
Desktop
348 
A6SBCCP
210 
DS241
208 
A2SA5VCIB
95 
Other values (25)
130 

Length

Max length22
Median length20
Mean length6.6821599
Min length4

Unique

Unique15 ?
Unique (%)1.0%

Sample

1st rowDesktop
2nd rowQ500SF
3rd rowDS241
4th rowQ500SF
5th rowA6SBCCP

Common Values

ValueCountFrequency (%)
Q500SF 472
32.3%
Desktop 348
23.8%
A6SBCCP 210
14.4%
DS241 208
14.2%
A2SA5VCIB 95
 
6.5%
JYTC 66
 
4.5%
Jooyon JYTC Series 14
 
1.0%
IPMSB-H61 12
 
0.8%
Q400SF 6
 
0.4%
JY-NA97R1T25SD-016 4
 
0.3%
Other values (20) 28
 
1.9%

Length

2024-04-21T10:46:44.947893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
q500sf 472
31.0%
desktop 354
23.2%
a6sbccp 210
13.8%
ds241 208
13.6%
a2sa5vcib 95
 
6.2%
jytc 80
 
5.2%
jooyon 14
 
0.9%
series 14
 
0.9%
ipmsb-h61 12
 
0.8%
q400sf 6
 
0.4%
Other values (37) 59
 
3.9%

Interactions

2024-04-21T10:46:40.109142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:46:45.206304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번부서명제조사PC모델
연번1.0000.9520.4300.652
부서명0.9521.0000.7220.721
제조사0.4300.7221.0000.998
PC모델0.6520.7210.9981.000
2024-04-21T10:46:45.451406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
PC모델제조사
PC모델1.0000.977
제조사0.9771.000
2024-04-21T10:46:45.679505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번제조사PC모델
연번1.0000.1750.293
제조사0.1751.0000.977
PC모델0.2930.9771.000

Missing values

2024-04-21T10:46:40.456983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:46:40.727914image/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.
2024-04-21T10:46:41.007138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

연번부서명제조사PC모델
01가수원동DANAWA COMPUTER Co., Ltd.Desktop
12가수원동DAEWOOLUCOMSQ500SF
23가수원동DAEWOOLUCOMSDS241
34가수원동DAEWOOLUCOMSQ500SF
45가수원동ATECA6SBCCP
56가수원동ATECA6SBCCP
67가수원동DANAWA COMPUTER Co., Ltd.Desktop
78가수원동DANAWA COMPUTER Co., Ltd.Desktop
89가수원동ATECA6SBCCP
910가수원동ATECA6SBCCP
연번부서명제조사PC모델
14531454대전광역시 서구청ATECA6SBCCP
14541455대전광역시 서구청ATECA2SA5VCIB
14551456대전광역시 서구청Gigabyte Technology Co., Ltd.Z790 AORUS ELITE
14561457대전광역시 서구청ATECA2SA5VCIB
14571458대전광역시 서구청DANAWA COMPUTER Co., Ltd.Desktop
14581459대전광역시 서구청ATECA2SA5VCIB
14591460대전광역시 서구청Jooyon Tech Co LtdJooyon JYTC Series
14601461대전광역시 서구청DANAWA COMPUTER Co., Ltd.Desktop
14611462대전광역시 서구청ATECIPMSB-H61
1462<NA><NA><NA><NA>