Overview

Dataset statistics

Number of variables7
Number of observations61
Missing cells1
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.7 KiB
Average record size in memory62.2 B

Variable types

Numeric3
Text2
Categorical2

Dataset

Description충청북도 음성군 농기계 임대 사업소에서 보유 중인 농기계 장비 현황에 대한 데이터로, 농기계 종류와 형식, 전체 수량 중 신품 수량과 중고 수량에 대하여 기재한 데이터입니다.
Author충청북도 음성군
URLhttps://www.data.go.kr/data/15089875/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전체수량 is highly overall correlated with 중고수량High correlation
중고수량 is highly overall correlated with 전체수량High correlation
중고수량 has 1 (1.6%) missing valuesMissing
번호 has unique valuesUnique
농기계종류 has unique valuesUnique
형식(규격) has unique valuesUnique

Reproduction

Analysis started2023-12-16 16:06:01.253944
Analysis finished2023-12-16 16:06:05.204155
Duration3.95 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31
Minimum1
Maximum61
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2023-12-16T16:06:05.353119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4
Q116
median31
Q346
95-th percentile58
Maximum61
Range60
Interquartile range (IQR)30

Descriptive statistics

Standard deviation17.752934
Coefficient of variation (CV)0.57267529
Kurtosis-1.2
Mean31
Median Absolute Deviation (MAD)15
Skewness0
Sum1891
Variance315.16667
MonotonicityStrictly increasing
2023-12-16T16:06:05.774760image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.6%
47 1
 
1.6%
34 1
 
1.6%
35 1
 
1.6%
36 1
 
1.6%
37 1
 
1.6%
38 1
 
1.6%
39 1
 
1.6%
40 1
 
1.6%
41 1
 
1.6%
Other values (51) 51
83.6%
ValueCountFrequency (%)
1 1
1.6%
2 1
1.6%
3 1
1.6%
4 1
1.6%
5 1
1.6%
6 1
1.6%
7 1
1.6%
8 1
1.6%
9 1
1.6%
10 1
1.6%
ValueCountFrequency (%)
61 1
1.6%
60 1
1.6%
59 1
1.6%
58 1
1.6%
57 1
1.6%
56 1
1.6%
55 1
1.6%
54 1
1.6%
53 1
1.6%
52 1
1.6%

농기계종류
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T16:06:06.240189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length9.6393443
Min length2

Characters and Unicode

Total characters588
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

Unique61 ?
Unique (%)100.0%

Sample

1st row농업용트랙터
2nd row결속기(농업용트랙터)
3rd row논두렁조성기(농업용트랙터)
4th row돌수집기(농업용트랙터)
5th row랩피복기(농업용트랙터)
ValueCountFrequency (%)
농업용트랙터 1
 
1.6%
로타리(승용관리기 1
 
1.6%
휴립피복기(승용관리기 1
 
1.6%
농업용고소작업차 1
 
1.6%
굴착기(농업용굴삭기 1
 
1.6%
농업용동력운반차 1
 
1.6%
농업용로우더 1
 
1.6%
농업용지주설치기 1
 
1.6%
작물수확기 1
 
1.6%
인삼정식기 1
 
1.6%
Other values (51) 51
83.6%
2023-12-16T16:06:07.152506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 67
 
11.4%
) 40
 
6.8%
( 40
 
6.8%
용 31
 
5.3%
업 25
 
4.3%
농 25
 
4.3%
터 24
 
4.1%
랙 23
 
3.9%
트 23
 
3.9%
리 14
 
2.4%
Other values (97) 276
46.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 508
86.4%
Close Punctuation 40
 
6.8%
Open Punctuation 40
 
6.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 67
 
13.2%
용 31
 
6.1%
업 25
 
4.9%
농 25
 
4.9%
터 24
 
4.7%
랙 23
 
4.5%
트 23
 
4.5%
리 14
 
2.8%
관 10
 
2.0%
보 9
 
1.8%
Other values (95) 257
50.6%
Close Punctuation
ValueCountFrequency (%)
) 40
100.0%
Open Punctuation
ValueCountFrequency (%)
( 40
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 508
86.4%
Common 80
 
13.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 67
 
13.2%
용 31
 
6.1%
업 25
 
4.9%
농 25
 
4.9%
터 24
 
4.7%
랙 23
 
4.5%
트 23
 
4.5%
리 14
 
2.8%
관 10
 
2.0%
보 9
 
1.8%
Other values (95) 257
50.6%
Common
ValueCountFrequency (%)
) 40
50.0%
( 40
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 508
86.4%
ASCII 80
 
13.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 67
 
13.2%
용 31
 
6.1%
업 25
 
4.9%
농 25
 
4.9%
터 24
 
4.7%
랙 23
 
4.5%
트 23
 
4.5%
리 14
 
2.8%
관 10
 
2.0%
보 9
 
1.8%
Other values (95) 257
50.6%
ASCII
ValueCountFrequency (%)
) 40
50.0%
( 40
50.0%

형식(규격)
Text

UNIQUE 

Distinct61
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-12-16T16:06:07.614274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length27
Mean length19.196721
Min length9

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)100.0%

Sample

1st rowLK400 / 40마력(29.5kw)미만 등
2nd rowCR10C / 중형 등
3rd rowAZ-700CH / 대형 등
4th rowSH-1400JS / 140cm 등
5th rowLW550-2AR / 전규격 등
ValueCountFrequency (%)
61
27.9%
전규격 9
 
4.1%
등 7
 
3.2%
bhd-2000 2
 
0.9%
bhdt-2000 2
 
0.9%
19마력 2
 
0.9%
파종기 2
 
0.9%
땅콩(소형)탈피기 1
 
0.5%
승용자주형 1
 
0.5%
22마력 1
 
0.5%
Other values (131) 131
59.8%
2023-12-16T16:06:08.478400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
212
 
18.1%
0 105
 
9.0%
/ 62
 
5.3%
- 47
 
4.0%
1 42
 
3.6%
2 32
 
2.7%
S 27
 
2.3%
5 23
 
2.0%
H 18
 
1.5%
B 17
 
1.5%
Other values (145) 586
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 284
24.3%
Decimal Number 273
23.3%
Space Separator 214
18.3%
Uppercase Letter 213
18.2%
Other Punctuation 77
 
6.6%
Dash Punctuation 47
 
4.0%
Lowercase Letter 32
 
2.7%
Open Punctuation 13
 
1.1%
Close Punctuation 13
 
1.1%
Math Symbol 4
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
력 12
 
4.2%
형 10
 
3.5%
전 10
 
3.5%
마 10
 
3.5%
격 9
 
3.2%
규 9
 
3.2%
기 9
 
3.2%
터 8
 
2.8%
용 8
 
2.8%
등 7
 
2.5%
Other values (91) 192
67.6%
Uppercase Letter
ValueCountFrequency (%)
S 27
12.7%
H 18
 
8.5%
B 17
 
8.0%
T 17
 
8.0%
A 16
 
7.5%
D 16
 
7.5%
R 15
 
7.0%
M 11
 
5.2%
C 11
 
5.2%
P 8
 
3.8%
Other values (15) 57
26.8%
Decimal Number
ValueCountFrequency (%)
0 105
38.5%
1 42
 
15.4%
2 32
 
11.7%
5 23
 
8.4%
6 16
 
5.9%
8 15
 
5.5%
3 13
 
4.8%
7 11
 
4.0%
4 11
 
4.0%
9 5
 
1.8%
Lowercase Letter
ValueCountFrequency (%)
m 9
28.1%
c 7
21.9%
k 6
18.8%
g 4
12.5%
w 2
 
6.2%
ℓ 2
 
6.2%
h 1
 
3.1%
t 1
 
3.1%
Other Punctuation
ValueCountFrequency (%)
/ 62
80.5%
, 11
 
14.3%
. 4
 
5.2%
Space Separator
ValueCountFrequency (%)
212
99.1%
　 2
 
0.9%
Math Symbol
ValueCountFrequency (%)
+ 2
50.0%
~ 2
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 47
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 643
54.9%
Hangul 284
24.3%
Latin 244
 
20.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
력 12
 
4.2%
형 10
 
3.5%
전 10
 
3.5%
마 10
 
3.5%
격 9
 
3.2%
규 9
 
3.2%
기 9
 
3.2%
터 8
 
2.8%
용 8
 
2.8%
등 7
 
2.5%
Other values (91) 192
67.6%
Latin
ValueCountFrequency (%)
S 27
 
11.1%
H 18
 
7.4%
B 17
 
7.0%
T 17
 
7.0%
A 16
 
6.6%
D 16
 
6.6%
R 15
 
6.1%
M 11
 
4.5%
C 11
 
4.5%
m 9
 
3.7%
Other values (23) 87
35.7%
Common
ValueCountFrequency (%)
212
33.0%
0 105
16.3%
/ 62
 
9.6%
- 47
 
7.3%
1 42
 
6.5%
2 32
 
5.0%
5 23
 
3.6%
6 16
 
2.5%
8 15
 
2.3%
( 13
 
2.0%
Other values (11) 76
 
11.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 882
75.3%
Hangul 284
 
24.3%
Letterlike Symbols 2
 
0.2%
None 2
 
0.2%
Number Forms 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
212
24.0%
0 105
 
11.9%
/ 62
 
7.0%
- 47
 
5.3%
1 42
 
4.8%
2 32
 
3.6%
S 27
 
3.1%
5 23
 
2.6%
H 18
 
2.0%
B 17
 
1.9%
Other values (41) 297
33.7%
Hangul
ValueCountFrequency (%)
력 12
 
4.2%
형 10
 
3.5%
전 10
 
3.5%
마 10
 
3.5%
격 9
 
3.2%
규 9
 
3.2%
기 9
 
3.2%
터 8
 
2.8%
용 8
 
2.8%
등 7
 
2.5%
Other values (91) 192
67.6%
Letterlike Symbols
ValueCountFrequency (%)
ℓ 2
100.0%
None
ValueCountFrequency (%)
　 2
100.0%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
100.0%

전체수량
Real number (ℝ)

HIGH CORRELATION 

Distinct20
Distinct (%)32.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.4918033
Minimum1
Maximum48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2023-12-16T16:06:08.860809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q13
median7
Q313
95-th percentile24
Maximum48
Range47
Interquartile range (IQR)10

Descriptive statistics

Standard deviation8.1006645
Coefficient of variation (CV)0.85343788
Kurtosis7.3524222
Mean9.4918033
Median Absolute Deviation (MAD)5
Skewness2.0901988
Sum579
Variance65.620765
MonotonicityNot monotonic
2023-12-16T16:06:09.231230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
2 7
11.5%
5 7
11.5%
3 6
 
9.8%
15 5
 
8.2%
6 4
 
6.6%
13 4
 
6.6%
12 4
 
6.6%
4 3
 
4.9%
1 3
 
4.9%
11 2
 
3.3%
Other values (10) 16
26.2%
ValueCountFrequency (%)
1 3
4.9%
2 7
11.5%
3 6
9.8%
4 3
4.9%
5 7
11.5%
6 4
6.6%
7 2
 
3.3%
9 2
 
3.3%
10 2
 
3.3%
11 2
 
3.3%
ValueCountFrequency (%)
48 1
 
1.6%
26 1
 
1.6%
24 2
 
3.3%
22 1
 
1.6%
17 2
 
3.3%
16 2
 
3.3%
15 5
8.2%
14 1
 
1.6%
13 4
6.6%
12 4
6.6%

신품수량
Categorical

Distinct6
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size620.0 B
<NA>
40 
1
11 
4
 
3
3
 
3
5
 
2

Length

Max length4
Median length4
Mean length2.9672131
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 40
65.6%
1 11
 
18.0%
4 3
 
4.9%
3 3
 
4.9%
5 2
 
3.3%
2 2
 
3.3%

Length

2023-12-16T16:06:09.698417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T16:06:10.033465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 40
65.6%
1 11
 
18.0%
4 3
 
4.9%
3 3
 
4.9%
5 2
 
3.3%
2 2
 
3.3%

중고수량
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct19
Distinct (%)31.7%
Missing1
Missing (%)1.6%
Infinite0
Infinite (%)0.0%
Mean8.8833333
Minimum1
Maximum43
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size681.0 B
2023-12-16T16:06:10.366691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median6.5
Q312
95-th percentile24
Maximum43
Range42
Interquartile range (IQR)9

Descriptive statistics

Standard deviation7.5016194
Coefficient of variation (CV)0.84445997
Kurtosis6.3248925
Mean8.8833333
Median Absolute Deviation (MAD)4.5
Skewness2.0064837
Sum533
Variance56.274294
MonotonicityNot monotonic
2023-12-16T16:06:10.657141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
3 7
11.5%
11 6
9.8%
2 6
9.8%
12 6
9.8%
6 5
8.2%
5 5
8.2%
1 4
 
6.6%
10 3
 
4.9%
9 3
 
4.9%
4 3
 
4.9%
Other values (9) 12
19.7%
ValueCountFrequency (%)
1 4
6.6%
2 6
9.8%
3 7
11.5%
4 3
4.9%
5 5
8.2%
6 5
8.2%
7 1
 
1.6%
9 3
4.9%
10 3
4.9%
11 6
9.8%
ValueCountFrequency (%)
43 1
 
1.6%
25 1
 
1.6%
24 2
 
3.3%
21 1
 
1.6%
17 1
 
1.6%
16 2
 
3.3%
14 2
 
3.3%
13 1
 
1.6%
12 6
9.8%
11 6
9.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size620.0 B
2023-11-30
61 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-30
2nd row2023-11-30
3rd row2023-11-30
4th row2023-11-30
5th row2023-11-30

Common Values

ValueCountFrequency (%)
2023-11-30 61
100.0%

Length

2023-12-16T16:06:11.014472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T16:06:11.374850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-30 61
100.0%

Interactions

2023-12-16T16:06:04.032800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:02.209908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:03.037872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:04.364151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:02.547925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:03.528577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:04.656808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:02.788882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T16:06:03.828251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T16:06:11.576481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호농기계종류형식(규격)전체수량신품수량중고수량
번호1.0001.0001.0000.2900.0000.000
농기계종류1.0001.0001.0001.0001.0001.000
형식(규격)1.0001.0001.0001.0001.0001.000
전체수량0.2901.0001.0001.0000.3630.990
신품수량0.0001.0001.0000.3631.0000.000
중고수량0.0001.0001.0000.9900.0001.000
2023-12-16T16:06:11.881894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호전체수량중고수량신품수량
번호1.000-0.044-0.0540.000
전체수량-0.0441.0000.9750.186
중고수량-0.0540.9751.0000.000
신품수량0.0000.1860.0001.000

Missing values

2023-12-16T16:06:04.901187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T16:06:05.112418image/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농업용트랙터LK400 / 40마력(29.5kw)미만 등261252023-11-30
12결속기(농업용트랙터)CR10C / 중형 등3<NA>32023-11-30
23논두렁조성기(농업용트랙터)AZ-700CH / 대형 등154112023-11-30
34돌수집기(농업용트랙터)SH-1400JS / 140cm 등6<NA>62023-11-30
45랩피복기(농업용트랙터)LW550-2AR / 전규격 등3<NA>32023-11-30
56로타베이터(농업용트랙터)WJ175A / 180cm미만 등485432023-11-30
67모우어(농업용트랙터)LDM5 / 디스크형3<NA>32023-11-30
78반전집초기(농업용트랙터)LRT320 / 캠트랙식4132023-11-30
89배토기(농업용트랙터)YJ165HG(로터베이터 형식명) / 2골배토기6<NA>62023-11-30
910비료살포기(농업용트랙터)STH-500A / 800kg미만10<NA>102023-11-30
번호농기계종류형식(규격)전체수량신품수량중고수량데이터기준일자
5152스피드스프레이어ASS-555TLDⅢ / 500ℓ이상~1000ℓ미만, 19마력3<NA>32023-11-30
5253콩예취기BH-710A / 30 cm / 3.73kw5<NA>52023-11-30
5354콩정선기YBS500G / 600kg/h121112023-11-30
5455풍구BH-25 / 모터용7<NA>72023-11-30
5556농기계용사다리BA0815 / 사다리24<NA>242023-11-30
5657들깨탈곡기(트랙터부착형)BHDT-2000 / 들깨(중형)트랙터부착용13<NA>132023-11-30
5758콩탈곡기(트랙터부착형)BHDT-2000 / 콩탈곡기(트랙터부착)151142023-11-30
5859인력파종기HG10A / 1조12<NA>122023-11-30
5960인삼종자파종기인력 인삼종자 파종기 / 인삼씨앗파종1<NA>12023-11-30
6061콩파종기HG-600A / 로터리 195mm + 파종기 4조 +적용마력 70마력~80마력2112023-11-30