Overview

Dataset statistics

Number of variables11
Number of observations2929
Missing cells15559
Missing cells (%)48.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory266.1 KiB
Average record size in memory93.0 B

Variable types

Numeric3
DateTime3
Boolean1
Text2
Unsupported2

Dataset

Description충북농업기술원 농가 경영기록장 "바로바로"의 농업회계분석 정보제공 관련 자산, 부채, 감가상각비 등 계정과목 관리시스템으로 대농기구일련번호, 등록일시, 수정일시, 상태, 규격, 구입일시, 감가상각액, 계정과목코드, 차변전표일련번호, 대변전표일련번호, 비고등의 정보를 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/15050284/fileData.do

Alerts

상태 has constant value ""Constant
대농기구일련번호 is highly overall correlated with 차변전표일련번호High correlation
감가상각액 is highly overall correlated with 차변전표일련번호High correlation
차변전표일련번호 is highly overall correlated with 대농기구일련번호 and 1 other fieldsHigh correlation
규격 has 2553 (87.2%) missing valuesMissing
구입일시 has 177 (6.0%) missing valuesMissing
감가상각액 has 2907 (99.2%) missing valuesMissing
계정과목코드 has 2929 (100.0%) missing valuesMissing
차변전표일련번호 has 2321 (79.2%) missing valuesMissing
대변전표일련번호 has 2929 (100.0%) missing valuesMissing
비고 has 1743 (59.5%) missing valuesMissing
대농기구일련번호 has unique valuesUnique
계정과목코드 is an unsupported type, check if it needs cleaning or further analysisUnsupported
대변전표일련번호 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 15:58:46.528454
Analysis finished2023-12-12 15:58:48.432187
Duration1.9 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대농기구일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2929
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2211.1683
Minimum14
Maximum4245
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size25.9 KiB
2023-12-13T00:58:48.500437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14
5-th percentile242.4
Q11081
median2225
Q33386
95-th percentile4089.6
Maximum4245
Range4231
Interquartile range (IQR)2305

Descriptive statistics

Standard deviation1268.5332
Coefficient of variation (CV)0.57369364
Kurtosis-1.2856875
Mean2211.1683
Median Absolute Deviation (MAD)1152
Skewness-0.038417828
Sum6476512
Variance1609176.5
MonotonicityStrictly increasing
2023-12-13T00:58:48.630912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
14 1
 
< 0.1%
2989 1
 
< 0.1%
2991 1
 
< 0.1%
2992 1
 
< 0.1%
2993 1
 
< 0.1%
2994 1
 
< 0.1%
2995 1
 
< 0.1%
2999 1
 
< 0.1%
3000 1
 
< 0.1%
3001 1
 
< 0.1%
Other values (2919) 2919
99.7%
ValueCountFrequency (%)
14 1
< 0.1%
15 1
< 0.1%
16 1
< 0.1%
17 1
< 0.1%
19 1
< 0.1%
20 1
< 0.1%
21 1
< 0.1%
22 1
< 0.1%
23 1
< 0.1%
26 1
< 0.1%
ValueCountFrequency (%)
4245 1
< 0.1%
4244 1
< 0.1%
4243 1
< 0.1%
4242 1
< 0.1%
4241 1
< 0.1%
4240 1
< 0.1%
4239 1
< 0.1%
4238 1
< 0.1%
4237 1
< 0.1%
4236 1
< 0.1%

등록일시
Date

Distinct473
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size23.0 KiB
Minimum1900-01-01 00:00:00
Maximum2019-11-06 18:21:00
2023-12-13T00:58:48.772788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:48.915616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일시
Date

Distinct498
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Memory size23.0 KiB
Minimum1900-01-01 00:00:00
Maximum2019-11-08 20:55:00
2023-12-13T00:58:49.105882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:49.247917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
False
2929 
ValueCountFrequency (%)
False 2929
100.0%
2023-12-13T00:58:49.384371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

규격
Text

MISSING 

Distinct289
Distinct (%)76.9%
Missing2553
Missing (%)87.2%
Memory size23.0 KiB
2023-12-13T00:58:49.726418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length17
Mean length4.6356383
Min length1

Characters and Unicode

Total characters1743
Distinct characters279
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique247 ?
Unique (%)65.7%

Sample

1st row대
2nd row1톤(초장축)
3rd rowd470
4th row1톤봉고
5th row10마력
ValueCountFrequency (%)
1톤 18
 
4.1%
아세아 7
 
1.6%
10 6
 
1.4%
0 6
 
1.4%
5 5
 
1.1%
10마력 4
 
0.9%
8마력 4
 
0.9%
45마력 4
 
0.9%
관리기 4
 
0.9%
20 4
 
0.9%
Other values (307) 379
85.9%
2023-12-13T00:58:50.249900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 132
 
7.6%
1 89
 
5.1%
77
 
4.4%
5 73
 
4.2%
기 66
 
3.8%
마 61
 
3.5%
력 59
 
3.4%
2 58
 
3.3%
8 41
 
2.4%
4 41
 
2.4%
Other values (269) 1046
60.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 959
55.0%
Decimal Number 518
29.7%
Space Separator 77
 
4.4%
Uppercase Letter 69
 
4.0%
Lowercase Letter 66
 
3.8%
Other Punctuation 26
 
1.5%
Close Punctuation 11
 
0.6%
Open Punctuation 11
 
0.6%
Dash Punctuation 5
 
0.3%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 66
 
6.9%
마 61
 
6.4%
력 59
 
6.2%
톤 33
 
3.4%
대 28
 
2.9%
아 28
 
2.9%
터 23
 
2.4%
포 23
 
2.4%
동 21
 
2.2%
리 16
 
1.7%
Other values (213) 601
62.7%
Lowercase Letter
ValueCountFrequency (%)
m 9
13.6%
c 8
12.1%
a 6
9.1%
l 6
9.1%
k 6
9.1%
s 5
 
7.6%
p 4
 
6.1%
x 3
 
4.5%
t 3
 
4.5%
g 3
 
4.5%
Other values (9) 13
19.7%
Uppercase Letter
ValueCountFrequency (%)
L 8
11.6%
A 7
10.1%
M 6
8.7%
C 6
8.7%
S 6
8.7%
T 6
8.7%
K 5
7.2%
D 5
7.2%
P 4
 
5.8%
B 4
 
5.8%
Other values (8) 12
17.4%
Decimal Number
ValueCountFrequency (%)
0 132
25.5%
1 89
17.2%
5 73
14.1%
2 58
11.2%
8 41
 
7.9%
4 41
 
7.9%
6 36
 
6.9%
3 30
 
5.8%
7 12
 
2.3%
9 6
 
1.2%
Other Punctuation
ValueCountFrequency (%)
. 14
53.8%
, 10
38.5%
/ 1
 
3.8%
# 1
 
3.8%
Space Separator
ValueCountFrequency (%)
77
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Math Symbol
ValueCountFrequency (%)
× 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 959
55.0%
Common 649
37.2%
Latin 135
 
7.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 66
 
6.9%
마 61
 
6.4%
력 59
 
6.2%
톤 33
 
3.4%
대 28
 
2.9%
아 28
 
2.9%
터 23
 
2.4%
포 23
 
2.4%
동 21
 
2.2%
리 16
 
1.7%
Other values (213) 601
62.7%
Latin
ValueCountFrequency (%)
m 9
 
6.7%
c 8
 
5.9%
L 8
 
5.9%
A 7
 
5.2%
M 6
 
4.4%
C 6
 
4.4%
S 6
 
4.4%
T 6
 
4.4%
a 6
 
4.4%
l 6
 
4.4%
Other values (27) 67
49.6%
Common
ValueCountFrequency (%)
0 132
20.3%
1 89
13.7%
77
11.9%
5 73
11.2%
2 58
8.9%
8 41
 
6.3%
4 41
 
6.3%
6 36
 
5.5%
3 30
 
4.6%
. 14
 
2.2%
Other values (9) 58
8.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 957
54.9%
ASCII 783
44.9%
Compat Jamo 2
 
0.1%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 132
16.9%
1 89
11.4%
77
9.8%
5 73
 
9.3%
2 58
 
7.4%
8 41
 
5.2%
4 41
 
5.2%
6 36
 
4.6%
3 30
 
3.8%
. 14
 
1.8%
Other values (45) 192
24.5%
Hangul
ValueCountFrequency (%)
기 66
 
6.9%
마 61
 
6.4%
력 59
 
6.2%
톤 33
 
3.4%
대 28
 
2.9%
아 28
 
2.9%
터 23
 
2.4%
포 23
 
2.4%
동 21
 
2.2%
리 16
 
1.7%
Other values (212) 599
62.6%
Compat Jamo
ValueCountFrequency (%)
ㅣ 2
100.0%
None
ValueCountFrequency (%)
× 1
100.0%

구입일시
Date

MISSING 

Distinct1632
Distinct (%)59.3%
Missing177
Missing (%)6.0%
Memory size23.0 KiB
Minimum1900-01-01 00:00:00
Maximum2019-10-30 00:00:00
2023-12-13T00:58:50.445844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:50.602914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

감가상각액
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct21
Distinct (%)95.5%
Missing2907
Missing (%)99.2%
Infinite0
Infinite (%)0.0%
Mean708406
Minimum0
Maximum4360000
Zeros2
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size25.9 KiB
2023-12-13T00:58:50.737618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3
Q1134562
median308000
Q3580499.75
95-th percentile3870000
Maximum4360000
Range4360000
Interquartile range (IQR)445937.75

Descriptive statistics

Standard deviation1180294.2
Coefficient of variation (CV)1.6661268
Kurtosis6.226663
Mean708406
Median Absolute Deviation (MAD)254000
Skewness2.6148236
Sum15584932
Variance1.3930944 × 1012
MonotonicityNot monotonic
2023-12-13T00:58:50.870440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 2
 
0.1%
572000 1
 
< 0.1%
1125000 1
 
< 0.1%
4000000 1
 
< 0.1%
583333 1
 
< 0.1%
500000 1
 
< 0.1%
600000 1
 
< 0.1%
4360000 1
 
< 0.1%
625 1
 
< 0.1%
128166 1
 
< 0.1%
Other values (11) 11
 
0.4%
(Missing) 2907
99.2%
ValueCountFrequency (%)
0 2
0.1%
60 1
< 0.1%
625 1
< 0.1%
64000 1
< 0.1%
128166 1
< 0.1%
153750 1
< 0.1%
154000 1
< 0.1%
200000 1
< 0.1%
208000 1
< 0.1%
220000 1
< 0.1%
ValueCountFrequency (%)
4360000 1
< 0.1%
4000000 1
< 0.1%
1400000 1
< 0.1%
1125000 1
< 0.1%
600000 1
< 0.1%
583333 1
< 0.1%
572000 1
< 0.1%
500000 1
< 0.1%
499998 1
< 0.1%
420000 1
< 0.1%

계정과목코드
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2929
Missing (%)100.0%
Memory size25.9 KiB

차변전표일련번호
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct608
Distinct (%)100.0%
Missing2321
Missing (%)79.2%
Infinite0
Infinite (%)0.0%
Mean796213.97
Minimum712953
Maximum877574
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size25.9 KiB
2023-12-13T00:58:51.029485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum712953
5-th percentile715434.7
Q1750462.25
median811207
Q3854413.5
95-th percentile873947.5
Maximum877574
Range164621
Interquartile range (IQR)103951.25

Descriptive statistics

Standard deviation54836.905
Coefficient of variation (CV)0.068872071
Kurtosis-1.4297403
Mean796213.97
Median Absolute Deviation (MAD)47961
Skewness-0.11094485
Sum4.8409809 × 108
Variance3.0070862 × 109
MonotonicityNot monotonic
2023-12-13T00:58:51.203871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
823170 1
 
< 0.1%
823156 1
 
< 0.1%
823176 1
 
< 0.1%
823160 1
 
< 0.1%
823162 1
 
< 0.1%
823164 1
 
< 0.1%
823166 1
 
< 0.1%
823168 1
 
< 0.1%
823172 1
 
< 0.1%
786292 1
 
< 0.1%
Other values (598) 598
 
20.4%
(Missing) 2321
79.2%
ValueCountFrequency (%)
712953 1
< 0.1%
713402 1
< 0.1%
713406 1
< 0.1%
713410 1
< 0.1%
713414 1
< 0.1%
713416 1
< 0.1%
713418 1
< 0.1%
713420 1
< 0.1%
713442 1
< 0.1%
715144 1
< 0.1%
ValueCountFrequency (%)
877574 1
< 0.1%
877570 1
< 0.1%
876998 1
< 0.1%
876995 1
< 0.1%
876873 1
< 0.1%
876733 1
< 0.1%
876659 1
< 0.1%
875366 1
< 0.1%
875364 1
< 0.1%
875362 1
< 0.1%

대변전표일련번호
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2929
Missing (%)100.0%
Memory size25.9 KiB

비고
Text

MISSING 

Distinct1003
Distinct (%)84.6%
Missing1743
Missing (%)59.5%
Memory size23.0 KiB
2023-12-13T00:58:51.600917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length95
Median length53
Mean length8.0354132
Min length1

Characters and Unicode

Total characters9530
Distinct characters604
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique927 ?
Unique (%)78.2%

Sample

1st row비료살포기
2nd row48마력
3rd row아세아5.5마력
4th row고소차
5th row47마력
ValueCountFrequency (%)
중고 58
 
2.9%
구입 39
 
2.0%
중고구입 28
 
1.4%
예초기 19
 
1.0%
아세아 18
 
0.9%
분무기 13
 
0.7%
대동 12
 
0.6%
건조기 11
 
0.6%
2대 10
 
0.5%
경운기 10
 
0.5%
Other values (1337) 1756
89.0%
2023-12-13T00:58:52.164499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
853
 
9.0%
기 517
 
5.4%
0 439
 
4.6%
고 210
 
2.2%
구 191
 
2.0%
1 159
 
1.7%
중 154
 
1.6%
동 146
 
1.5%
입 141
 
1.5%
2 133
 
1.4%
Other values (594) 6587
69.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6984
73.3%
Decimal Number 1134
 
11.9%
Space Separator 853
 
9.0%
Other Punctuation 216
 
2.3%
Uppercase Letter 134
 
1.4%
Lowercase Letter 85
 
0.9%
Close Punctuation 44
 
0.5%
Open Punctuation 43
 
0.5%
Dash Punctuation 23
 
0.2%
Math Symbol 11
 
0.1%
Other values (2) 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 517
 
7.4%
고 210
 
3.0%
구 191
 
2.7%
중 154
 
2.2%
동 146
 
2.1%
입 141
 
2.0%
대 132
 
1.9%
아 115
 
1.6%
리 99
 
1.4%
력 98
 
1.4%
Other values (521) 5181
74.2%
Uppercase Letter
ValueCountFrequency (%)
S 15
11.2%
D 12
 
9.0%
L 12
 
9.0%
G 11
 
8.2%
A 10
 
7.5%
T 8
 
6.0%
M 8
 
6.0%
C 8
 
6.0%
K 7
 
5.2%
P 6
 
4.5%
Other values (15) 37
27.6%
Lowercase Letter
ValueCountFrequency (%)
s 21
24.7%
a 9
10.6%
e 6
 
7.1%
n 6
 
7.1%
o 5
 
5.9%
g 5
 
5.9%
m 5
 
5.9%
l 5
 
5.9%
h 3
 
3.5%
k 3
 
3.5%
Other values (11) 17
20.0%
Decimal Number
ValueCountFrequency (%)
0 439
38.7%
1 159
 
14.0%
2 133
 
11.7%
5 101
 
8.9%
3 77
 
6.8%
4 76
 
6.7%
8 62
 
5.5%
7 38
 
3.4%
6 37
 
3.3%
9 12
 
1.1%
Other Punctuation
ValueCountFrequency (%)
, 99
45.8%
. 85
39.4%
% 13
 
6.0%
/ 10
 
4.6%
: 3
 
1.4%
; 2
 
0.9%
* 2
 
0.9%
! 1
 
0.5%
' 1
 
0.5%
Math Symbol
ValueCountFrequency (%)
~ 8
72.7%
+ 3
 
27.3%
Space Separator
ValueCountFrequency (%)
853
100.0%
Close Punctuation
ValueCountFrequency (%)
) 44
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%
Modifier Symbol
ValueCountFrequency (%)
^ 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6984
73.3%
Common 2327
 
24.4%
Latin 219
 
2.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 517
 
7.4%
고 210
 
3.0%
구 191
 
2.7%
중 154
 
2.2%
동 146
 
2.1%
입 141
 
2.0%
대 132
 
1.9%
아 115
 
1.6%
리 99
 
1.4%
력 98
 
1.4%
Other values (521) 5181
74.2%
Latin
ValueCountFrequency (%)
s 21
 
9.6%
S 15
 
6.8%
D 12
 
5.5%
L 12
 
5.5%
G 11
 
5.0%
A 10
 
4.6%
a 9
 
4.1%
T 8
 
3.7%
M 8
 
3.7%
C 8
 
3.7%
Other values (36) 105
47.9%
Common
ValueCountFrequency (%)
853
36.7%
0 439
18.9%
1 159
 
6.8%
2 133
 
5.7%
5 101
 
4.3%
, 99
 
4.3%
. 85
 
3.7%
3 77
 
3.3%
4 76
 
3.3%
8 62
 
2.7%
Other values (17) 243
 
10.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6977
73.2%
ASCII 2546
 
26.7%
Compat Jamo 7
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
853
33.5%
0 439
17.2%
1 159
 
6.2%
2 133
 
5.2%
5 101
 
4.0%
, 99
 
3.9%
. 85
 
3.3%
3 77
 
3.0%
4 76
 
3.0%
8 62
 
2.4%
Other values (63) 462
18.1%
Hangul
ValueCountFrequency (%)
기 517
 
7.4%
고 210
 
3.0%
구 191
 
2.7%
중 154
 
2.2%
동 146
 
2.1%
입 141
 
2.0%
대 132
 
1.9%
아 115
 
1.6%
리 99
 
1.4%
력 98
 
1.4%
Other values (517) 5174
74.2%
Compat Jamo
ValueCountFrequency (%)
ㅡ 3
42.9%
ㅣ 2
28.6%
ㅅ 1
 
14.3%
ㄴ 1
 
14.3%

Interactions

2023-12-13T00:58:47.546536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.077972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.326170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.624434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.161545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.402128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.701373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.234332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:47.471631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:58:52.267907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대농기구일련번호감가상각액차변전표일련번호
대농기구일련번호1.0000.3110.588
감가상각액0.3111.0000.433
차변전표일련번호0.5880.4331.000
2023-12-13T00:58:52.361195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대농기구일련번호감가상각액차변전표일련번호
대농기구일련번호1.0000.3810.873
감가상각액0.3811.0000.702
차변전표일련번호0.8730.7021.000

Missing values

2023-12-13T00:58:47.826601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:58:48.256112image/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.
2023-12-13T00:58:48.371145image/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

대농기구일련번호등록일시수정일시상태규격구입일시감가상각액계정과목코드차변전표일련번호대변전표일련번호비고
0141900-01-01 00:001900-01-01 00:00N<NA>2012-01-24<NA><NA><NA><NA><NA>
1151900-01-01 00:001900-01-01 00:00N<NA>2012-04-29<NA><NA><NA><NA><NA>
2161900-01-01 00:001900-01-01 00:00N<NA>2011-12-27<NA><NA><NA><NA><NA>
3171900-01-01 00:001900-01-01 00:00N<NA>2013-03-28<NA><NA><NA><NA><NA>
4191900-01-01 00:001900-01-01 00:00N<NA>2012-07-29<NA><NA><NA><NA>비료살포기
5201900-01-01 00:001900-01-01 00:00N<NA>2011-01-01<NA><NA><NA><NA>48마력
6211900-01-01 00:001900-01-01 00:00N<NA>2012-01-01<NA><NA><NA><NA>아세아5.5마력
7221900-01-01 00:001900-01-01 00:00N<NA>2009-07-30<NA><NA><NA><NA><NA>
8231900-01-01 00:002017-06-02 14:52N대2017-04-19<NA><NA>728764<NA>고소차
9261900-01-01 00:002019-03-30 07:26N<NA>2012-07-30<NA><NA>825718<NA><NA>
대농기구일련번호등록일시수정일시상태규격구입일시감가상각액계정과목코드차변전표일련번호대변전표일련번호비고
291942362019-10-30 14:382019-10-30 14:38N40kw2019-10-15<NA><NA>874487<NA><NA>
292042372019-10-30 15:552019-10-30 15:55Ncctv2019-10-30<NA><NA>874590<NA><NA>
292142382019-10-30 15:572019-10-30 19:33N스마트팜시설2019-09-10<NA><NA>874799<NA><NA>
292242392019-10-30 19:282019-10-30 19:28N난방기2018-09-15<NA><NA>874748<NA><NA>
292342402019-10-30 19:392019-10-30 19:39N냉동고2017-10-30<NA><NA>874813<NA><NA>
292442412019-10-30 19:442019-10-30 19:44N수막시설2017-10-30<NA><NA>874820<NA><NA>
292542422019-10-30 23:252019-10-31 20:54N<NA>2019-10-30<NA><NA>875351<NA><NA>
292642432019-10-30 23:292019-10-31 20:54N진공포장기2019-10-01<NA><NA>875353<NA><NA>
292742442019-11-05 18:582019-11-05 18:58N<NA>2019-10-30<NA><NA>876733<NA><NA>
292842452019-11-06 18:212019-11-06 18:21N<NA>2012-06-19<NA><NA>876873<NA>전기 농산물건조기