Overview

Dataset statistics

Number of variables11
Number of observations466
Missing cells12
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory42.0 KiB
Average record size in memory92.3 B

Variable types

Numeric3
Text3
Categorical5

Dataset

Description충청남도 청양군의 농기계임대사업관리시스템의 양식정보에 관한 데이터로 테이블관리번호, 양식종류번호, 양식명, 테이블 등에 관한 정보를 나타냅니다
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=331&beforeMenuCd=DOM_000000201001001000&publicdatapk=15089552

Alerts

양식(FR_Hint) is highly overall correlated with 양식종류번호 and 2 other fieldsHigh correlation
양식(FR_Select) is highly overall correlated with 테이블관리번호 and 3 other fieldsHigh correlation
양식(FR_Input) is highly overall correlated with 테이블 and 2 other fieldsHigh correlation
테이블 is highly overall correlated with 양식종류번호 and 2 other fieldsHigh correlation
순번 is highly overall correlated with 테이블관리번호 and 1 other fieldsHigh correlation
테이블관리번호 is highly overall correlated with 순번 and 2 other fieldsHigh correlation
양식종류번호 is highly overall correlated with 순번 and 3 other fieldsHigh correlation
양식(FR_Send) is highly overall correlated with 테이블 and 1 other fieldsHigh correlation
테이블 is highly imbalanced (62.6%)Imbalance
양식(FR_Select) is highly imbalanced (79.6%)Imbalance
양식(FR_Input) is highly imbalanced (87.3%)Imbalance
양식(FR_Hint) is highly imbalanced (66.7%)Imbalance
양식파일명 has 12 (2.6%) missing valuesMissing
순번 has unique valuesUnique
테이블관리번호 has unique valuesUnique
양식종류번호 has 17 (3.6%) zerosZeros

Reproduction

Analysis started2024-01-09 20:36:56.641781
Analysis finished2024-01-09 20:36:58.350143
Duration1.71 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct466
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean233.5
Minimum1
Maximum466
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.2 KiB
2024-01-10T05:36:58.412283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile24.25
Q1117.25
median233.5
Q3349.75
95-th percentile442.75
Maximum466
Range465
Interquartile range (IQR)232.5

Descriptive statistics

Standard deviation134.66687
Coefficient of variation (CV)0.57673179
Kurtosis-1.2
Mean233.5
Median Absolute Deviation (MAD)116.5
Skewness0
Sum108811
Variance18135.167
MonotonicityStrictly increasing
2024-01-10T05:36:58.783199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
308 1
 
0.2%
320 1
 
0.2%
319 1
 
0.2%
318 1
 
0.2%
317 1
 
0.2%
316 1
 
0.2%
315 1
 
0.2%
314 1
 
0.2%
313 1
 
0.2%
Other values (456) 456
97.9%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
466 1
0.2%
465 1
0.2%
464 1
0.2%
463 1
0.2%
462 1
0.2%
461 1
0.2%
460 1
0.2%
459 1
0.2%
458 1
0.2%
457 1
0.2%

테이블관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct466
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36458.5
Minimum36226
Maximum36691
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.2 KiB
2024-01-10T05:36:58.901208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36226
5-th percentile36249.25
Q136342.25
median36458.5
Q336574.75
95-th percentile36667.75
Maximum36691
Range465
Interquartile range (IQR)232.5

Descriptive statistics

Standard deviation134.66687
Coefficient of variation (CV)0.0036937031
Kurtosis-1.2
Mean36458.5
Median Absolute Deviation (MAD)116.5
Skewness0
Sum16989661
Variance18135.167
MonotonicityNot monotonic
2024-01-10T05:36:59.025725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
36691 1
 
0.2%
36376 1
 
0.2%
36373 1
 
0.2%
36372 1
 
0.2%
36371 1
 
0.2%
36385 1
 
0.2%
36384 1
 
0.2%
36383 1
 
0.2%
36382 1
 
0.2%
36381 1
 
0.2%
Other values (456) 456
97.9%
ValueCountFrequency (%)
36226 1
0.2%
36227 1
0.2%
36228 1
0.2%
36229 1
0.2%
36230 1
0.2%
36231 1
0.2%
36232 1
0.2%
36233 1
0.2%
36234 1
0.2%
36235 1
0.2%
ValueCountFrequency (%)
36691 1
0.2%
36690 1
0.2%
36689 1
0.2%
36688 1
0.2%
36687 1
0.2%
36686 1
0.2%
36685 1
0.2%
36684 1
0.2%
36683 1
0.2%
36682 1
0.2%

양식종류번호
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct42
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.053648
Minimum0
Maximum391
Zeros17
Zeros (%)3.6%
Negative0
Negative (%)0.0%
Memory size4.2 KiB
2024-01-10T05:36:59.143704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q111
median20
Q320
95-th percentile36
Maximum391
Range391
Interquartile range (IQR)9

Descriptive statistics

Standard deviation19.71123
Coefficient of variation (CV)1.0918143
Kurtosis276.3137
Mean18.053648
Median Absolute Deviation (MAD)6
Skewness14.624762
Sum8413
Variance388.5326
MonotonicityNot monotonic
2024-01-10T05:36:59.270389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
20 204
43.8%
10 23
 
4.9%
1 20
 
4.3%
0 17
 
3.6%
11 17
 
3.6%
13 15
 
3.2%
14 15
 
3.2%
2 14
 
3.0%
12 14
 
3.0%
35 13
 
2.8%
Other values (32) 114
24.5%
ValueCountFrequency (%)
0 17
3.6%
1 20
4.3%
2 14
3.0%
3 1
 
0.2%
4 1
 
0.2%
5 1
 
0.2%
6 1
 
0.2%
7 11
2.4%
8 13
2.8%
9 13
2.8%
ValueCountFrequency (%)
391 1
 
0.2%
40 1
 
0.2%
39 2
 
0.4%
38 8
1.7%
37 5
 
1.1%
36 13
2.8%
35 13
2.8%
34 4
 
0.9%
33 4
 
0.9%
32 1
 
0.2%
Distinct66
Distinct (%)14.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2024-01-10T05:36:59.505315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length15
Mean length9.527897
Min length2

Characters and Unicode

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

Unique

Unique14 ?
Unique (%)3.0%

Sample

1st row보고서 날짜 자료 전송
2nd row보고서 자료 전송
3rd row보고서 날짜 자료 전송
4th row보고서 자료 전송
5th row보고서 자료 전송
ValueCountFrequency (%)
보고서 72
 
10.1%
보고자료 57
 
8.0%
농림수산식품부 42
 
5.9%
자료 30
 
4.2%
임대장비 28
 
3.9%
사용자보고서 26
 
3.7%
회원 25
 
3.5%
전송 21
 
3.0%
기종 20
 
2.8%
추진실적 20
 
2.8%
Other values (66) 369
52.0%
2024-01-10T05:36:59.871225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
244
 
5.5%
241
 
5.4%
191
 
4.3%
188
 
4.2%
187
 
4.2%
] 172
 
3.9%
[ 172
 
3.9%
167
 
3.8%
167
 
3.8%
167
 
3.8%
Other values (116) 2544
57.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3653
82.3%
Space Separator 244
 
5.5%
Close Punctuation 176
 
4.0%
Open Punctuation 176
 
4.0%
Dash Punctuation 159
 
3.6%
Lowercase Letter 15
 
0.3%
Uppercase Letter 15
 
0.3%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
241
 
6.6%
191
 
5.2%
188
 
5.1%
187
 
5.1%
167
 
4.6%
167
 
4.6%
167
 
4.6%
165
 
4.5%
119
 
3.3%
114
 
3.1%
Other values (103) 1947
53.3%
Lowercase Letter
ValueCountFrequency (%)
e 5
33.3%
d 5
33.3%
o 5
33.3%
Uppercase Letter
ValueCountFrequency (%)
C 5
33.3%
Q 5
33.3%
R 5
33.3%
Close Punctuation
ValueCountFrequency (%)
] 172
97.7%
) 4
 
2.3%
Open Punctuation
ValueCountFrequency (%)
[ 172
97.7%
( 4
 
2.3%
Space Separator
ValueCountFrequency (%)
244
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 159
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3653
82.3%
Common 757
 
17.0%
Latin 30
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
241
 
6.6%
191
 
5.2%
188
 
5.1%
187
 
5.1%
167
 
4.6%
167
 
4.6%
167
 
4.6%
165
 
4.5%
119
 
3.3%
114
 
3.1%
Other values (103) 1947
53.3%
Common
ValueCountFrequency (%)
244
32.2%
] 172
22.7%
[ 172
22.7%
- 159
21.0%
) 4
 
0.5%
( 4
 
0.5%
/ 2
 
0.3%
Latin
ValueCountFrequency (%)
e 5
16.7%
d 5
16.7%
o 5
16.7%
C 5
16.7%
Q 5
16.7%
R 5
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3647
82.1%
ASCII 787
 
17.7%
Compat Jamo 6
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
244
31.0%
] 172
21.9%
[ 172
21.9%
- 159
20.2%
e 5
 
0.6%
d 5
 
0.6%
o 5
 
0.6%
C 5
 
0.6%
Q 5
 
0.6%
R 5
 
0.6%
Other values (3) 10
 
1.3%
Hangul
ValueCountFrequency (%)
241
 
6.6%
191
 
5.2%
188
 
5.2%
187
 
5.1%
167
 
4.6%
167
 
4.6%
167
 
4.6%
165
 
4.5%
119
 
3.3%
114
 
3.1%
Other values (102) 1941
53.2%
Compat Jamo
ValueCountFrequency (%)
6
100.0%
Distinct338
Distinct (%)72.5%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2024-01-10T05:37:00.084623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length41
Median length28
Mean length12.800429
Min length2

Characters and Unicode

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

Unique

Unique313 ?
Unique (%)67.2%

Sample

1st row완료임대내역전송
2nd row실적자료전송
3rd row주산지일관기계화임대현황
4th row직원소개자료전송
5th row회원내역전송
ValueCountFrequency (%)
48
 
5.2%
농기계 26
 
2.8%
임대사업 21
 
2.3%
임대농기계 19
 
2.1%
추진실적 16
 
1.7%
현황 14
 
1.5%
임대장비 13
 
1.4%
임대실적 13
 
1.4%
기종별 12
 
1.3%
농기계임차인목록 12
 
1.3%
Other values (431) 725
78.9%
2024-01-10T05:37:00.449968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
454
 
7.6%
453
 
7.6%
314
 
5.3%
222
 
3.7%
) 199
 
3.3%
( 199
 
3.3%
171
 
2.9%
143
 
2.4%
133
 
2.2%
131
 
2.2%
Other values (211) 3546
59.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4676
78.4%
Space Separator 453
 
7.6%
Close Punctuation 254
 
4.3%
Open Punctuation 254
 
4.3%
Decimal Number 137
 
2.3%
Dash Punctuation 90
 
1.5%
Other Punctuation 44
 
0.7%
Uppercase Letter 30
 
0.5%
Lowercase Letter 25
 
0.4%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
454
 
9.7%
314
 
6.7%
222
 
4.7%
171
 
3.7%
143
 
3.1%
133
 
2.8%
131
 
2.8%
127
 
2.7%
119
 
2.5%
119
 
2.5%
Other values (178) 2743
58.7%
Decimal Number
ValueCountFrequency (%)
1 33
24.1%
2 31
22.6%
0 19
13.9%
9 15
10.9%
3 13
 
9.5%
8 6
 
4.4%
7 6
 
4.4%
5 5
 
3.6%
4 5
 
3.6%
6 4
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
D 5
16.7%
Q 5
16.7%
C 5
16.7%
R 5
16.7%
N 3
10.0%
M 3
10.0%
L 3
10.0%
A 1
 
3.3%
Lowercase Letter
ValueCountFrequency (%)
x 10
40.0%
e 5
20.0%
d 5
20.0%
o 5
20.0%
Other Punctuation
ValueCountFrequency (%)
, 17
38.6%
. 16
36.4%
# 11
25.0%
Close Punctuation
ValueCountFrequency (%)
) 199
78.3%
] 55
 
21.7%
Open Punctuation
ValueCountFrequency (%)
( 199
78.3%
[ 55
 
21.7%
Space Separator
ValueCountFrequency (%)
453
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4676
78.4%
Common 1234
 
20.7%
Latin 55
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
454
 
9.7%
314
 
6.7%
222
 
4.7%
171
 
3.7%
143
 
3.1%
133
 
2.8%
131
 
2.8%
127
 
2.7%
119
 
2.5%
119
 
2.5%
Other values (178) 2743
58.7%
Common
ValueCountFrequency (%)
453
36.7%
) 199
16.1%
( 199
16.1%
- 90
 
7.3%
[ 55
 
4.5%
] 55
 
4.5%
1 33
 
2.7%
2 31
 
2.5%
0 19
 
1.5%
, 17
 
1.4%
Other values (11) 83
 
6.7%
Latin
ValueCountFrequency (%)
x 10
18.2%
D 5
9.1%
Q 5
9.1%
e 5
9.1%
d 5
9.1%
o 5
9.1%
C 5
9.1%
R 5
9.1%
N 3
 
5.5%
M 3
 
5.5%
Other values (2) 4
 
7.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4669
78.3%
ASCII 1289
 
21.6%
Compat Jamo 7
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
454
 
9.7%
314
 
6.7%
222
 
4.8%
171
 
3.7%
143
 
3.1%
133
 
2.8%
131
 
2.8%
127
 
2.7%
119
 
2.5%
119
 
2.5%
Other values (177) 2736
58.6%
ASCII
ValueCountFrequency (%)
453
35.1%
) 199
15.4%
( 199
15.4%
- 90
 
7.0%
[ 55
 
4.3%
] 55
 
4.3%
1 33
 
2.6%
2 31
 
2.4%
0 19
 
1.5%
, 17
 
1.3%
Other values (23) 138
 
10.7%
Compat Jamo
ValueCountFrequency (%)
7
100.0%

양식파일명
Text

MISSING 

Distinct316
Distinct (%)69.6%
Missing12
Missing (%)2.6%
Memory size3.8 KiB
2024-01-10T05:37:00.664387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length19
Mean length12.742291
Min length7

Characters and Unicode

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

Unique

Unique284 ?
Unique (%)62.6%

Sample

1st row교육자리스트2.fr3
2nd row교육수료증.fr3
3rd row교육수료증라벨.fr3
4th row고객리스트4.fr3
5th row작업기록.fr3
ValueCountFrequency (%)
농기계임차인목록.fr3 12
 
2.6%
임대농기계구입및활용.fr3 12
 
2.6%
임대차관리대장.fr3 12
 
2.6%
임대차관리대장9.fr3 11
 
2.4%
임대차관리대장6.fr3 10
 
2.2%
임대료수납현황.fr3 10
 
2.2%
임대차관리대장#3.fr3 10
 
2.2%
임대차관리대장#2.fr3 10
 
2.2%
임대차관리대장#4.fr3 10
 
2.2%
임대차관리대장5.fr3 10
 
2.2%
Other values (307) 348
76.5%
2024-01-10T05:37:01.000068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 472
 
8.2%
r 457
 
7.9%
. 445
 
7.7%
f 444
 
7.7%
423
 
7.3%
286
 
4.9%
193
 
3.3%
149
 
2.6%
129
 
2.2%
124
 
2.1%
Other values (204) 2663
46.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3535
61.1%
Lowercase Letter 1018
 
17.6%
Decimal Number 684
 
11.8%
Other Punctuation 475
 
8.2%
Connector Punctuation 21
 
0.4%
Open Punctuation 17
 
0.3%
Close Punctuation 17
 
0.3%
Uppercase Letter 12
 
0.2%
Dash Punctuation 5
 
0.1%
Space Separator 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
423
 
12.0%
286
 
8.1%
193
 
5.5%
149
 
4.2%
129
 
3.6%
124
 
3.5%
122
 
3.5%
113
 
3.2%
100
 
2.8%
82
 
2.3%
Other values (158) 1814
51.3%
Lowercase Letter
ValueCountFrequency (%)
r 457
44.9%
f 444
43.6%
d 18
 
1.8%
e 17
 
1.7%
x 10
 
1.0%
o 9
 
0.9%
n 8
 
0.8%
m 7
 
0.7%
l 7
 
0.7%
c 6
 
0.6%
Other values (10) 35
 
3.4%
Decimal Number
ValueCountFrequency (%)
3 472
69.0%
2 69
 
10.1%
1 44
 
6.4%
0 25
 
3.7%
4 19
 
2.8%
5 16
 
2.3%
6 15
 
2.2%
9 12
 
1.8%
8 6
 
0.9%
7 6
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
L 3
25.0%
D 3
25.0%
R 2
16.7%
F 1
 
8.3%
M 1
 
8.3%
Q 1
 
8.3%
A 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
. 445
93.7%
# 30
 
6.3%
Open Punctuation
ValueCountFrequency (%)
( 16
94.1%
[ 1
 
5.9%
Close Punctuation
ValueCountFrequency (%)
) 16
94.1%
] 1
 
5.9%
Connector Punctuation
ValueCountFrequency (%)
_ 21
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3535
61.1%
Common 1220
 
21.1%
Latin 1030
 
17.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
423
 
12.0%
286
 
8.1%
193
 
5.5%
149
 
4.2%
129
 
3.6%
124
 
3.5%
122
 
3.5%
113
 
3.2%
100
 
2.8%
82
 
2.3%
Other values (158) 1814
51.3%
Latin
ValueCountFrequency (%)
r 457
44.4%
f 444
43.1%
d 18
 
1.7%
e 17
 
1.7%
x 10
 
1.0%
o 9
 
0.9%
n 8
 
0.8%
m 7
 
0.7%
l 7
 
0.7%
c 6
 
0.6%
Other values (17) 47
 
4.6%
Common
ValueCountFrequency (%)
3 472
38.7%
. 445
36.5%
2 69
 
5.7%
1 44
 
3.6%
# 30
 
2.5%
0 25
 
2.0%
_ 21
 
1.7%
4 19
 
1.6%
5 16
 
1.3%
( 16
 
1.3%
Other values (9) 63
 
5.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3535
61.1%
ASCII 2250
38.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 472
21.0%
r 457
20.3%
. 445
19.8%
f 444
19.7%
2 69
 
3.1%
1 44
 
2.0%
# 30
 
1.3%
0 25
 
1.1%
_ 21
 
0.9%
4 19
 
0.8%
Other values (36) 224
10.0%
Hangul
ValueCountFrequency (%)
423
 
12.0%
286
 
8.1%
193
 
5.5%
149
 
4.2%
129
 
3.6%
124
 
3.5%
122
 
3.5%
113
 
3.2%
100
 
2.8%
82
 
2.3%
Other values (158) 1814
51.3%

테이블
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct15
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
<NA>
300 
zetyx_member_table
113 
members
39 
lend_shop
 
3
완료임대내역전송
 
1
Other values (10)
 
10

Length

Max length18
Median length4
Mean length7.8240343
Min length4

Unique

Unique11 ?
Unique (%)2.4%

Sample

1st row완료임대내역전송
2nd rowprodu_board
3rd row주산지일관기계화임대현황
4th rowlend_member
5th rowmembers

Common Values

ValueCountFrequency (%)
<NA> 300
64.4%
zetyx_member_table 113
 
24.2%
members 39
 
8.4%
lend_shop 3
 
0.6%
완료임대내역전송 1
 
0.2%
produ_board 1
 
0.2%
주산지일관기계화임대현황 1
 
0.2%
lend_member 1
 
0.2%
lend_machine 1
 
0.2%
농기계보유현황 1
 
0.2%
Other values (5) 5
 
1.1%

Length

2024-01-10T05:37:01.131649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 300
64.4%
zetyx_member_table 113
 
24.2%
members 39
 
8.4%
lend_shop 3
 
0.6%
완료임대내역전송 1
 
0.2%
produ_board 1
 
0.2%
주산지일관기계화임대현황 1
 
0.2%
lend_member 1
 
0.2%
lend_machine 1
 
0.2%
농기계보유현황 1
 
0.2%
Other values (5) 5
 
1.1%

양식(FR_Select)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
<NA>
441 
r
 
23
lend_position,m_code,subject,gu,gu2
 
2

Length

Max length35
Median length4
Mean length3.9849785
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowr
2nd rowr
3rd rowr
4th rowr
5th rowr

Common Values

ValueCountFrequency (%)
<NA> 441
94.6%
r 23
 
4.9%
lend_position,m_code,subject,gu,gu2 2
 
0.4%

Length

2024-01-10T05:37:01.246191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:37:01.330707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 441
94.6%
r 23
 
4.9%
lend_position,m_code,subject,gu,gu2 2
 
0.4%

양식(FR_Input)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct12
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
<NA>
443 
https://amrbeadm.krei.re.kr/bigdata/lendOrder.do
 
3
https://amrbeadm.krei.re.kr/bigdata/produBoard.do
 
2
https://amrbeadm.krei.re.kr/bigdata/processingRent.do
 
2
https://amrbeadm.krei.re.kr/bigdata/lendMember.do
 
2
Other values (7)
 
14

Length

Max length59
Median length4
Mean length6.2703863
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowhttps://amrbeadm.krei.re.kr/bigdata/lendOrder.do
2nd rowhttps://amrbeadm.krei.re.kr/bigdata/produBoard.do
3rd rowhttps://amrbeadm.krei.re.kr/bigdata/processingRent.do
4th rowhttps://amrbeadm.krei.re.kr/bigdata/lendMember.do
5th rowhttps://amrbeadm.krei.re.kr/bigdata/members.do

Common Values

ValueCountFrequency (%)
<NA> 443
95.1%
https://amrbeadm.krei.re.kr/bigdata/lendOrder.do 3
 
0.6%
https://amrbeadm.krei.re.kr/bigdata/produBoard.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/processingRent.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendMember.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/members.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendMachine.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/processingPossession.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/repairBoard.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendStudy.do 2
 
0.4%
Other values (2) 4
 
0.9%

Length

2024-01-10T05:37:01.424699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 443
95.1%
https://amrbeadm.krei.re.kr/bigdata/lendorder.do 3
 
0.6%
https://amrbeadm.krei.re.kr/bigdata/produboard.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/processingrent.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendmember.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/members.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendmachine.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/processingpossession.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/repairboard.do 2
 
0.4%
https://amrbeadm.krei.re.kr/bigdata/lendstudy.do 2
 
0.4%
Other values (2) 4
 
0.9%

양식(FR_Hint)
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct31
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
<NA>
337 
임대내역검색 조건)
47 
임대장비검색 조건)
45 
관리내역 검색 조건)
 
6
조회기간 : 예약일자
 
2
Other values (26)
 
29

Length

Max length24
Median length4
Mean length5.8390558
Min length4

Unique

Unique23 ?
Unique (%)4.9%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 337
72.3%
임대내역검색 조건) 47
 
10.1%
임대장비검색 조건) 45
 
9.7%
관리내역 검색 조건) 6
 
1.3%
조회기간 : 예약일자 2
 
0.4%
임대장비 : 장기임대 2
 
0.4%
임대장비 검색 조건) 2
 
0.4%
회원 검색 조건) 2
 
0.4%
조회일자 : 입금일자 1
 
0.2%
조회기간 : 허가일자 1
 
0.2%
Other values (21) 21
 
4.5%

Length

2024-01-10T05:37:01.545732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 337
52.7%
조건 103
 
16.1%
임대내역검색 47
 
7.3%
임대장비검색 45
 
7.0%
21
 
3.3%
검색 10
 
1.6%
관리내역 6
 
0.9%
조회기간 6
 
0.9%
임대장비 5
 
0.8%
제외 4
 
0.6%
Other values (39) 56
 
8.8%

양식(FR_Send)
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
0
329 
<NA>
116 
1
 
21

Length

Max length4
Median length1
Mean length1.7467811
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row0
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
0 329
70.6%
<NA> 116
 
24.9%
1 21
 
4.5%

Length

2024-01-10T05:37:01.670453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:37:01.763603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 329
70.6%
na 116
 
24.9%
1 21
 
4.5%

Interactions

2024-01-10T05:36:57.763278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.307165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.528499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.842363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.369001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.597741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.933295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.441979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:36:57.675514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:37:01.830827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번테이블관리번호양식종류번호양식종류테이블양식(FR_Select)양식(FR_Input)양식(FR_Hint)양식(FR_Send)
순번1.0000.9920.0000.9720.7050.1400.0000.6550.332
테이블관리번호0.9921.0000.0000.9800.6370.9140.0000.7190.416
양식종류번호0.0000.0001.0000.5491.0000.0000.000NaN0.120
양식종류0.9720.9800.5491.0000.6201.0000.0000.8990.996
테이블0.7050.6371.0000.6201.0000.0001.000NaN0.989
양식(FR_Select)0.1400.9140.0001.0000.0001.000NaNNaN0.754
양식(FR_Input)0.0000.0000.0000.0001.000NaN1.0000.0000.208
양식(FR_Hint)0.6550.719NaN0.899NaNNaN0.0001.0001.000
양식(FR_Send)0.3320.4160.1200.9960.9890.7540.2081.0001.000
2024-01-10T05:37:01.946108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
양식(FR_Send)양식(FR_Hint)양식(FR_Select)양식(FR_Input)테이블
양식(FR_Send)1.0000.4260.5420.0000.875
양식(FR_Hint)0.4261.0001.0001.000NaN
양식(FR_Select)0.5421.0001.0001.0000.000
양식(FR_Input)0.0001.0001.0001.0001.000
테이블0.875NaN0.0001.0001.000
2024-01-10T05:37:02.042616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번테이블관리번호양식종류번호테이블양식(FR_Select)양식(FR_Input)양식(FR_Hint)양식(FR_Send)
순번1.000-0.992-0.9450.3980.1370.0000.2970.251
테이블관리번호-0.9921.0000.9570.3390.6690.0000.3570.316
양식종류번호-0.9450.9571.0000.9660.0000.0001.0000.199
테이블0.3980.3390.9661.0000.0001.0000.0000.875
양식(FR_Select)0.1370.6690.0000.0001.0001.0001.0000.542
양식(FR_Input)0.0000.0000.0001.0001.0001.0001.0000.000
양식(FR_Hint)0.2970.3571.0000.0001.0001.0001.0000.426
양식(FR_Send)0.2510.3160.1990.8750.5420.0000.4261.000

Missing values

2024-01-10T05:36:58.131290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:36:58.293143image/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

순번테이블관리번호양식종류번호양식종류양식명양식파일명테이블양식(FR_Select)양식(FR_Input)양식(FR_Hint)양식(FR_Send)
0136691391보고서 날짜 자료 전송완료임대내역전송<NA>완료임대내역전송rhttps://amrbeadm.krei.re.kr/bigdata/lendOrder.do<NA>1
123669040보고서 자료 전송실적자료전송<NA>produ_boardrhttps://amrbeadm.krei.re.kr/bigdata/produBoard.do<NA>0
233668939보고서 날짜 자료 전송주산지일관기계화임대현황<NA>주산지일관기계화임대현황rhttps://amrbeadm.krei.re.kr/bigdata/processingRent.do<NA>1
343668538보고서 자료 전송직원소개자료전송<NA>lend_memberrhttps://amrbeadm.krei.re.kr/bigdata/lendMember.do<NA>1
453668638보고서 자료 전송회원내역전송<NA>membersrhttps://amrbeadm.krei.re.kr/bigdata/members.do<NA>1
563668738보고서 자료 전송회원보유기종전송<NA>lend_machinerhttps://amrbeadm.krei.re.kr/bigdata/lendMachine.do<NA>1
673668839보고서 날짜 자료 전송농기계보유현황<NA>농기계보유현황rhttps://amrbeadm.krei.re.kr/bigdata/processingPossession.do<NA>1
783663630농기계교육관리[이수]교육자리스트교육자리스트2.fr3members<NA><NA><NA>0
893663730농기계교육관리[이수]수료증교육수료증.fr3zetyx_member_table<NA><NA><NA>0
9103663830농기계교육관리[이수]수료증-라벨교육수료증라벨.fr3<NA><NA><NA><NA>0
순번테이블관리번호양식종류번호양식종류양식명양식파일명테이블양식(FR_Select)양식(FR_Input)양식(FR_Hint)양식(FR_Send)
456457362270회원DL봉투(사용자)DL봉투(사용자).fr3zetyx_member_table<NA><NA><NA>0
457458362280회원DL봉투(사용자-세로)DL봉투(사용자-세로).fr3zetyx_member_table<NA><NA><NA>0
458459362290회원DM발송#1dm발송1.fr3zetyx_member_table<NA><NA><NA>0
459460362300회원DM발송#2dm발송2.fr3zetyx_member_table<NA><NA><NA>0
460461362310회원고객리스트고객리스트.fr3zetyx_member_table<NA><NA><NA>0
461462362320회원고객리스트#2고객리스트2.fr3members<NA><NA><NA>0
462463362330회원고객리스트#3고객리스트5.fr3members<NA><NA><NA>0
463464362340회원고객보험내역고객보험내역.fr3<NA><NA><NA><NA>0
464465362350회원대봉투(15x11)(15x11)inch봉투.fr3zetyx_member_table<NA><NA><NA>0
465466362360회원이용제한내역이용제한대장.fr3<NA><NA><NA><NA>0