Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells112
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory810.5 KiB
Average record size in memory83.0 B

Variable types

Numeric3
Categorical3
DateTime1
Text2

Dataset

Description대구시설공단 가로등시스템 자재관리입니다.
Author대구시설공단
URLhttps://www.data.go.kr/data/15088105/fileData.do

Alerts

구분 is highly overall correlated with 수리방법High correlation
수리방법 is highly overall correlated with 구분High correlation
구분 is highly imbalanced (93.0%)Imbalance
규격 has 112 (1.1%) missing valuesMissing
출고량 is highly skewed (γ1 = 37.94333089)Skewed
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-13 00:43:42.666614
Analysis finished2023-12-13 00:43:44.282982
Duration1.62 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12768.591
Minimum2
Maximum25704
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T09:43:44.343012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile1248.95
Q16387.75
median12696.5
Q319163.5
95-th percentile24372.05
Maximum25704
Range25702
Interquartile range (IQR)12775.75

Descriptive statistics

Standard deviation7401.5104
Coefficient of variation (CV)0.57966538
Kurtosis-1.192606
Mean12768.591
Median Absolute Deviation (MAD)6401.5
Skewness0.013759111
Sum1.2768591 × 108
Variance54782357
MonotonicityNot monotonic
2023-12-13T09:43:44.445594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2397 1
 
< 0.1%
5575 1
 
< 0.1%
17314 1
 
< 0.1%
13581 1
 
< 0.1%
2042 1
 
< 0.1%
15698 1
 
< 0.1%
14098 1
 
< 0.1%
13637 1
 
< 0.1%
3945 1
 
< 0.1%
3810 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
13 1
< 0.1%
17 1
< 0.1%
ValueCountFrequency (%)
25704 1
< 0.1%
25702 1
< 0.1%
25701 1
< 0.1%
25699 1
< 0.1%
25696 1
< 0.1%
25694 1
< 0.1%
25692 1
< 0.1%
25686 1
< 0.1%
25685 1
< 0.1%
25684 1
< 0.1%

구분
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
작업
9859 
G0001
 
132
G0008
 
9

Length

Max length5
Median length2
Mean length2.0423
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row작업
2nd row작업
3rd row작업
4th row작업
5th row작업

Common Values

ValueCountFrequency (%)
작업 9859
98.6%
G0001 132
 
1.3%
G0008 9
 
0.1%

Length

2023-12-13T09:43:44.544168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:43:44.630582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
작업 9859
98.6%
g0001 132
 
1.3%
g0008 9
 
0.1%

일시
Date

Distinct258
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-01-02 00:00:00
Maximum2020-12-31 00:00:00
2023-12-13T09:43:44.708005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:44.838185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

자재명
Text

Distinct181
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T09:43:45.023090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length10.5784
Min length2

Characters and Unicode

Total characters105784
Distinct characters197
Distinct categories13 ?
Distinct scripts3 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique46 ?
Unique (%)0.5%

Sample

1st row가로등 다기능접속함(3N)
2nd rowCDM150W(핀) 램프
3rd rowIGR 누전차단기
4th row삼파장전구 75W
5th row누전차단기 2P 30A/H
ValueCountFrequency (%)
cdm램프 1540
 
7.8%
250w 1383
 
7.0%
cdm안정기 1238
 
6.3%
150w 1086
 
5.5%
전선 980
 
5.0%
누전차단기 856
 
4.3%
2p 782
 
4.0%
방수접속함 636
 
3.2%
dy-600 581
 
2.9%
30a/h 478
 
2.4%
Other values (196) 10165
51.5%
2023-12-13T09:43:45.332225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9725
 
9.2%
0 5447
 
5.1%
C 4695
 
4.4%
D 4292
 
4.1%
W 4256
 
4.0%
5 3596
 
3.4%
기 3528
 
3.3%
M 3224
 
3.0%
2 3005
 
2.8%
1 2975
 
2.8%
Other values (187) 61041
57.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 40157
38.0%
Uppercase Letter 25791
24.4%
Decimal Number 19724
18.6%
Space Separator 9725
 
9.2%
Lowercase Letter 4355
 
4.1%
Close Punctuation 1608
 
1.5%
Open Punctuation 1608
 
1.5%
Other Punctuation 1030
 
1.0%
Other Symbol 824
 
0.8%
Dash Punctuation 636
 
0.6%
Other values (3) 326
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 3528
 
8.8%
전 2443
 
6.1%
프 2301
 
5.7%
램 2221
 
5.5%
등 1993
 
5.0%
안 1503
 
3.7%
정 1485
 
3.7%
함 1441
 
3.6%
로 1238
 
3.1%
접 1163
 
2.9%
Other values (134) 20841
51.9%
Uppercase Letter
ValueCountFrequency (%)
C 4695
18.2%
D 4292
16.6%
W 4256
16.5%
M 3224
12.5%
P 1834
 
7.1%
A 1270
 
4.9%
L 1181
 
4.6%
E 1010
 
3.9%
V 958
 
3.7%
H 664
 
2.6%
Other values (13) 2407
9.3%
Decimal Number
ValueCountFrequency (%)
0 5447
27.6%
5 3596
18.2%
2 3005
15.2%
1 2975
15.1%
3 1320
 
6.7%
6 1117
 
5.7%
7 919
 
4.7%
4 586
 
3.0%
9 544
 
2.8%
8 215
 
1.1%
Lowercase Letter
ValueCountFrequency (%)
m 1304
29.9%
o 867
19.9%
e 452
 
10.4%
t 415
 
9.5%
s 415
 
9.5%
i 415
 
9.5%
h 415
 
9.5%
l 37
 
0.8%
p 35
 
0.8%
Other Punctuation
ValueCountFrequency (%)
/ 555
53.9%
. 475
46.1%
Math Symbol
ValueCountFrequency (%)
× 4
66.7%
+ 2
33.3%
Space Separator
ValueCountFrequency (%)
9725
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1608
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1608
100.0%
Other Symbol
ValueCountFrequency (%)
㎟ 824
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 636
100.0%
Modifier Symbol
ValueCountFrequency (%)
˝ 313
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 40157
38.0%
Common 35481
33.5%
Latin 30146
28.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 3528
 
8.8%
전 2443
 
6.1%
프 2301
 
5.7%
램 2221
 
5.5%
등 1993
 
5.0%
안 1503
 
3.7%
정 1485
 
3.7%
함 1441
 
3.6%
로 1238
 
3.1%
접 1163
 
2.9%
Other values (134) 20841
51.9%
Latin
ValueCountFrequency (%)
C 4695
15.6%
D 4292
14.2%
W 4256
14.1%
M 3224
10.7%
P 1834
 
6.1%
m 1304
 
4.3%
A 1270
 
4.2%
L 1181
 
3.9%
E 1010
 
3.4%
V 958
 
3.2%
Other values (22) 6122
20.3%
Common
ValueCountFrequency (%)
9725
27.4%
0 5447
15.4%
5 3596
 
10.1%
2 3005
 
8.5%
1 2975
 
8.4%
) 1608
 
4.5%
( 1608
 
4.5%
3 1320
 
3.7%
6 1117
 
3.1%
7 919
 
2.6%
Other values (11) 4161
11.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 64486
61.0%
Hangul 40157
38.0%
CJK Compat 824
 
0.8%
Modifier Letters 313
 
0.3%
None 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9725
15.1%
0 5447
 
8.4%
C 4695
 
7.3%
D 4292
 
6.7%
W 4256
 
6.6%
5 3596
 
5.6%
M 3224
 
5.0%
2 3005
 
4.7%
1 2975
 
4.6%
P 1834
 
2.8%
Other values (40) 21437
33.2%
Hangul
ValueCountFrequency (%)
기 3528
 
8.8%
전 2443
 
6.1%
프 2301
 
5.7%
램 2221
 
5.5%
등 1993
 
5.0%
안 1503
 
3.7%
정 1485
 
3.7%
함 1441
 
3.6%
로 1238
 
3.1%
접 1163
 
2.9%
Other values (134) 20841
51.9%
CJK Compat
ValueCountFrequency (%)
㎟ 824
100.0%
Modifier Letters
ValueCountFrequency (%)
˝ 313
100.0%
None
ValueCountFrequency (%)
× 4
100.0%

규격
Text

MISSING 

Distinct132
Distinct (%)1.3%
Missing112
Missing (%)1.1%
Memory size156.2 KiB
2023-12-13T09:43:45.558669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length11
Mean length5.0893002
Min length1

Characters and Unicode

Total characters50323
Distinct characters125
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique28 ?
Unique (%)0.3%

Sample

1st rowMTC-3N
2nd row150W
3rd row30A
4th row75W
5th row2P 30A/H
ValueCountFrequency (%)
250w 1383
 
11.6%
150w 1213
 
10.1%
2p 782
 
6.5%
dy-600 581
 
4.9%
70w 571
 
4.8%
9m 485
 
4.1%
30a/h 478
 
4.0%
mtc-3n 441
 
3.7%
140w 415
 
3.5%
cv1c16㎟ 404
 
3.4%
Other values (129) 5221
43.6%
2023-12-13T09:43:45.876396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 6577
 
13.1%
W 4414
 
8.8%
1 3892
 
7.7%
5 3886
 
7.7%
2 3226
 
6.4%
2086
 
4.1%
C 1736
 
3.4%
6 1347
 
2.7%
3 1293
 
2.6%
- 1214
 
2.4%
Other values (115) 20652
41.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 22866
45.4%
Uppercase Letter 15027
29.9%
Other Letter 5603
 
11.1%
Space Separator 2086
 
4.1%
Lowercase Letter 1372
 
2.7%
Dash Punctuation 1214
 
2.4%
Other Punctuation 1075
 
2.1%
Other Symbol 757
 
1.5%
Modifier Symbol 313
 
0.6%
Math Symbol 6
 
< 0.1%
Other values (2) 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
형 839
 
15.0%
원 341
 
6.1%
시 294
 
5.2%
선 241
 
4.3%
면 224
 
4.0%
등 222
 
4.0%
석 222
 
4.0%
자 184
 
3.3%
식 184
 
3.3%
립 177
 
3.2%
Other values (67) 2675
47.7%
Uppercase Letter
ValueCountFrequency (%)
W 4414
29.4%
C 1736
 
11.6%
A 1189
 
7.9%
P 1135
 
7.6%
D 1034
 
6.9%
V 914
 
6.1%
T 801
 
5.3%
Y 638
 
4.2%
H 595
 
4.0%
L 553
 
3.7%
Other values (13) 2018
13.4%
Decimal Number
ValueCountFrequency (%)
0 6577
28.8%
1 3892
17.0%
5 3886
17.0%
2 3226
14.1%
6 1347
 
5.9%
3 1293
 
5.7%
4 988
 
4.3%
7 906
 
4.0%
9 517
 
2.3%
8 234
 
1.0%
Other Punctuation
ValueCountFrequency (%)
/ 556
51.7%
. 407
37.9%
* 109
 
10.1%
, 3
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
m 1084
79.0%
c 222
 
16.2%
h 66
 
4.8%
Math Symbol
ValueCountFrequency (%)
× 4
66.7%
~ 2
33.3%
Space Separator
ValueCountFrequency (%)
2086
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1214
100.0%
Other Symbol
ValueCountFrequency (%)
㎟ 757
100.0%
Modifier Symbol
ValueCountFrequency (%)
˝ 313
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 28321
56.3%
Latin 16399
32.6%
Hangul 5602
 
11.1%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
형 839
 
15.0%
원 341
 
6.1%
시 294
 
5.2%
선 241
 
4.3%
면 224
 
4.0%
등 222
 
4.0%
석 222
 
4.0%
자 184
 
3.3%
식 184
 
3.3%
립 177
 
3.2%
Other values (66) 2674
47.7%
Latin
ValueCountFrequency (%)
W 4414
26.9%
C 1736
 
10.6%
A 1189
 
7.3%
P 1135
 
6.9%
m 1084
 
6.6%
D 1034
 
6.3%
V 914
 
5.6%
T 801
 
4.9%
Y 638
 
3.9%
H 595
 
3.6%
Other values (16) 2859
17.4%
Common
ValueCountFrequency (%)
0 6577
23.2%
1 3892
13.7%
5 3886
13.7%
2 3226
11.4%
2086
 
7.4%
6 1347
 
4.8%
3 1293
 
4.6%
- 1214
 
4.3%
4 988
 
3.5%
7 906
 
3.2%
Other values (12) 2906
10.3%
Han
ValueCountFrequency (%)
大 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 43646
86.7%
Hangul 5602
 
11.1%
CJK Compat 757
 
1.5%
Modifier Letters 313
 
0.6%
None 4
 
< 0.1%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 6577
15.1%
W 4414
 
10.1%
1 3892
 
8.9%
5 3886
 
8.9%
2 3226
 
7.4%
2086
 
4.8%
C 1736
 
4.0%
6 1347
 
3.1%
3 1293
 
3.0%
- 1214
 
2.8%
Other values (35) 13975
32.0%
Hangul
ValueCountFrequency (%)
형 839
 
15.0%
원 341
 
6.1%
시 294
 
5.2%
선 241
 
4.3%
면 224
 
4.0%
등 222
 
4.0%
석 222
 
4.0%
자 184
 
3.3%
식 184
 
3.3%
립 177
 
3.2%
Other values (66) 2674
47.7%
CJK Compat
ValueCountFrequency (%)
㎟ 757
100.0%
Modifier Letters
ValueCountFrequency (%)
˝ 313
100.0%
None
ValueCountFrequency (%)
× 4
100.0%
CJK
ValueCountFrequency (%)
大 1
100.0%

출고위치
Categorical

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1조
1807 
6조
1467 
2조
1423 
4조
1415 
3조
1395 
Other values (5)
2493 

Length

Max length4
Median length2
Mean length2.2137
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row2조
2nd row4조
3rd row2조
4th row6조
5th row5조

Common Values

ValueCountFrequency (%)
1조 1807
18.1%
6조 1467
14.7%
2조 1423
14.2%
4조 1415
14.1%
3조 1395
14.0%
5조 1297
13.0%
자재창고 939
9.4%
순찰차 254
 
2.5%
<NA> 2
 
< 0.1%
사무실 1
 
< 0.1%

Length

2023-12-13T09:43:45.983703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:43:46.298398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1조 1807
18.1%
6조 1467
14.7%
2조 1423
14.2%
4조 1415
14.1%
3조 1395
14.0%
5조 1297
13.0%
자재창고 939
9.4%
순찰차 254
 
2.5%
na 2
 
< 0.1%
사무실 1
 
< 0.1%

출고량
Real number (ℝ)

SKEWED 

Distinct51
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.4349
Minimum1
Maximum920
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T09:43:46.411677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile6
Maximum920
Range919
Interquartile range (IQR)0

Descriptive statistics

Standard deviation15.888411
Coefficient of variation (CV)6.5252828
Kurtosis1867.8309
Mean2.4349
Median Absolute Deviation (MAD)0
Skewness37.943331
Sum24349
Variance252.44161
MonotonicityNot monotonic
2023-12-13T09:43:46.509565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 8850
88.5%
2 281
 
2.8%
5 145
 
1.5%
6 119
 
1.2%
3 110
 
1.1%
10 101
 
1.0%
12 80
 
0.8%
4 69
 
0.7%
20 57
 
0.6%
8 21
 
0.2%
Other values (41) 167
 
1.7%
ValueCountFrequency (%)
1 8850
88.5%
2 281
 
2.8%
3 110
 
1.1%
4 69
 
0.7%
5 145
 
1.5%
6 119
 
1.2%
7 10
 
0.1%
8 21
 
0.2%
9 16
 
0.2%
10 101
 
1.0%
ValueCountFrequency (%)
920 1
 
< 0.1%
807 1
 
< 0.1%
355 1
 
< 0.1%
300 5
0.1%
240 1
 
< 0.1%
200 2
 
< 0.1%
196 1
 
< 0.1%
100 7
0.1%
95 2
 
< 0.1%
81 2
 
< 0.1%

수리방법
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
교체
5235 
수선
2722 
점검
990 
<NA>
938 
청소
 
89
Other values (2)
 
26

Length

Max length4
Median length2
Mean length2.1876
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수선
2nd row교체
3rd row교체
4th row교체
5th row수선

Common Values

ValueCountFrequency (%)
교체 5235
52.3%
수선 2722
27.2%
점검 990
 
9.9%
<NA> 938
 
9.4%
청소 89
 
0.9%
반납 18
 
0.2%
이첩 8
 
0.1%

Length

2023-12-13T09:43:46.606443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T09:43:46.698514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교체 5235
52.3%
수선 2722
27.2%
점검 990
 
9.9%
na 938
 
9.4%
청소 89
 
0.9%
반납 18
 
0.2%
이첩 8
 
0.1%

자재코드
Real number (ℝ)

Distinct181
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11558.827
Minimum1001
Maximum35210
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T09:43:46.816347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1001
5-th percentile10117
Q110195
median10501
Q310822
95-th percentile19032
Maximum35210
Range34209
Interquartile range (IQR)627

Descriptive statistics

Standard deviation3097.7132
Coefficient of variation (CV)0.26799546
Kurtosis6.361432
Mean11558.827
Median Absolute Deviation (MAD)321
Skewness2.3459792
Sum1.1558827 × 108
Variance9595827
MonotonicityNot monotonic
2023-12-13T09:43:46.923635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10122 795
 
8.0%
10218 588
 
5.9%
19032 581
 
5.8%
10117 512
 
5.1%
10726 478
 
4.8%
19023 441
 
4.4%
10612 404
 
4.0%
10213 377
 
3.8%
10404 310
 
3.1%
10116 308
 
3.1%
Other values (171) 5206
52.1%
ValueCountFrequency (%)
1001 8
0.1%
1002 1
 
< 0.1%
1003 1
 
< 0.1%
1011 1
 
< 0.1%
1018 2
 
< 0.1%
1019 2
 
< 0.1%
1044 1
 
< 0.1%
1045 1
 
< 0.1%
1046 1
 
< 0.1%
2002 1
 
< 0.1%
ValueCountFrequency (%)
35210 4
< 0.1%
30825 1
 
< 0.1%
30819 4
< 0.1%
30815 2
< 0.1%
30809 1
 
< 0.1%
30505 1
 
< 0.1%
30501 1
 
< 0.1%
30407 2
< 0.1%
30327 1
 
< 0.1%
30326 1
 
< 0.1%

Interactions

2023-12-13T09:43:43.847091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.389689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.643342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.918509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.455875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.708020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.987163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.546696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T09:43:43.772517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T09:43:46.999364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분출고위치출고량수리방법자재코드
순번1.0000.0670.1240.0060.1360.102
구분0.0671.0000.5100.740NaN0.172
출고위치0.1240.5101.0000.1020.3280.139
출고량0.0060.7400.1021.0000.0000.000
수리방법0.136NaN0.3280.0001.0000.239
자재코드0.1020.1720.1390.0000.2391.000
2023-12-13T09:43:47.077493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분수리방법출고위치
구분1.0001.0000.261
수리방법1.0001.0000.169
출고위치0.2610.1691.000
2023-12-13T09:43:47.155377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번출고량자재코드구분출고위치수리방법
순번1.0000.0020.0060.0390.0570.072
출고량0.0021.000-0.0440.4190.0510.000
자재코드0.006-0.0441.0000.1310.0860.164
구분0.0390.4190.1311.0000.2611.000
출고위치0.0570.0510.0860.2611.0000.169
수리방법0.0720.0000.1641.0000.1691.000

Missing values

2023-12-13T09:43:44.091629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T09:43:44.221138image/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

순번구분일시자재명규격출고위치출고량수리방법자재코드
23962397작업2020-02-05 00:00:00가로등 다기능접속함(3N)MTC-3N2조1수선19023
1694816949작업2020-08-07 00:00:00CDM150W(핀) 램프150W4조2교체10192
554555작업2020-01-09 00:00:00IGR 누전차단기30A2조1교체10744
49194920작업2020-03-05 00:00:00삼파장전구 75W75W6조1교체10116
1473314734작업2020-07-08 00:00:00누전차단기 2P 30A/H2P 30A/H5조1수선10726
2146021461작업2020-10-14 00:00:00원형가로등주(9m 외등)9m 외등순찰차1점검10857
1450214503작업2020-07-06 00:00:00전선 CV1P8㎟CV1P8㎟2조1점검10604
1500815009작업2020-07-13 00:00:00SMPS 병렬 3.2A125W2조2수선10233
1248712488작업2020-06-09 00:00:00CDM150W(핀) 램프150W4조1교체10192
33353336작업2020-02-18 00:00:00국기꽂이(철재2구)철재 2구2조1교체10924
순번구분일시자재명규격출고위치출고량수리방법자재코드
37323733작업2020-02-21 00:00:00전선 CV1C16㎟CV1C16㎟3조1수선10612
702703작업2020-01-13 00:00:00CDM안정기 150W150W1조1교체10213
1849518496작업2020-08-31 00:00:00안정기뚜껑STS 1.5T자재창고6<NA>10904
2336323364작업2020-11-17 00:00:00자동 점멸기실시간 감시형1조1수선10502
88138814작업2020-04-21 00:00:00배선용차단기 2P 50A2P 50A4조1교체10705
45654566작업2020-03-03 00:00:00팔각테파등주 10m POLE10m4조1점검10823
1007510076작업2020-05-13 00:00:00SMPS 병렬 4.2A150W자재창고5<NA>10234
60866087작업2020-03-18 00:00:00팔각테파등주 9m POLE9m5조1수선10822
79767977G00012020-04-09 00:00:00원형테파등주 10m pole10m자재창고1<NA>10829
1320913210작업2020-06-17 00:00:00LED가로등기구(LED125W)125W2조1점검10377