Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows1719
Duplicate rows (%)17.2%
Total size in memory722.7 KiB
Average record size in memory74.0 B

Variable types

DateTime1
Categorical2
Text3
Numeric2

Dataset

Description삼산농산물도매시장의 실시간 농산물 경락가격을 제공함으로써 시장 투명성 확보에 기여삼산농산물도매시장 실시간 경락정보(경매일자,법인명,품목,품종,거래물량(kg),경락단가(원), 산지,비고)등의 데이터 입니다.
Author인천광역시
URLhttps://www.data.go.kr/data/3044829/fileData.do

Alerts

Dataset has 1719 (17.2%) duplicate rowsDuplicates
거래물량(kg) is highly overall correlated with 경락단가(원)High correlation
경락단가(원) is highly overall correlated with 거래물량(kg)High correlation

Reproduction

Analysis started2024-03-15 00:23:15.741602
Analysis finished2024-03-15 00:23:18.367550
Duration2.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

경매일자
Date

Distinct8
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-11-01 00:00:00
Maximum2023-11-09 00:00:00
2024-03-15T09:23:18.503744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:23:18.740140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)

법인명
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
(주)부평농산
5967 
인천원예농협
2285 
(주)경인농산
1748 

Length

Max length7
Median length7
Mean length6.7715
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row(주)경인농산
2nd row(주)부평농산
3rd row(주)부평농산
4th row(주)경인농산
5th row(주)경인농산

Common Values

ValueCountFrequency (%)
(주)부평농산 5967
59.7%
인천원예농협 2285
 
22.9%
(주)경인농산 1748
 
17.5%

Length

2024-03-15T09:23:19.150967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:23:19.469300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주)부평농산 5967
59.7%
인천원예농협 2285
 
22.9%
주)경인농산 1748
 
17.5%

품목
Text

Distinct150
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T09:23:20.688905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length2.8006
Min length1

Characters and Unicode

Total characters28006
Distinct characters194
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11 ?
Unique (%)0.1%

Sample

1st row사과
2nd row조미가공
3rd row참당귀
4th row단감
5th row새송이버섯
ValueCountFrequency (%)
단감 583
 
5.8%
감귤 501
 
5.0%
깻잎 388
 
3.8%
사과 348
 
3.4%
무 345
 
3.4%
표고버섯 323
 
3.2%
풋고추 323
 
3.2%
떫은감 308
 
3.1%
호박 305
 
3.0%
바나나 301
 
3.0%
Other values (142) 6367
63.1%
2024-03-15T09:23:22.347366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
추 1649
 
5.9%
감 1478
 
5.3%
고 1179
 
4.2%
섯 964
 
3.4%
버 964
 
3.4%
나 906
 
3.2%
리 899
 
3.2%
이 848
 
3.0%
파 710
 
2.5%
무 674
 
2.4%
Other values (184) 17735
63.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 27460
98.1%
Open Punctuation 214
 
0.8%
Close Punctuation 214
 
0.8%
Space Separator 92
 
0.3%
Other Punctuation 26
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
추 1649
 
6.0%
감 1478
 
5.4%
고 1179
 
4.3%
섯 964
 
3.5%
버 964
 
3.5%
나 906
 
3.3%
리 899
 
3.3%
이 848
 
3.1%
파 710
 
2.6%
무 674
 
2.5%
Other values (180) 17189
62.6%
Open Punctuation
ValueCountFrequency (%)
( 214
100.0%
Close Punctuation
ValueCountFrequency (%)
) 214
100.0%
Space Separator
ValueCountFrequency (%)
92
100.0%
Other Punctuation
ValueCountFrequency (%)
, 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 27460
98.1%
Common 546
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
추 1649
 
6.0%
감 1478
 
5.4%
고 1179
 
4.3%
섯 964
 
3.5%
버 964
 
3.5%
나 906
 
3.3%
리 899
 
3.3%
이 848
 
3.1%
파 710
 
2.6%
무 674
 
2.5%
Other values (180) 17189
62.6%
Common
ValueCountFrequency (%)
( 214
39.2%
) 214
39.2%
92
16.8%
, 26
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 27460
98.1%
ASCII 546
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
추 1649
 
6.0%
감 1478
 
5.4%
고 1179
 
4.3%
섯 964
 
3.5%
버 964
 
3.5%
나 906
 
3.3%
리 899
 
3.3%
이 848
 
3.1%
파 710
 
2.6%
무 674
 
2.5%
Other values (180) 17189
62.6%
ASCII
ValueCountFrequency (%)
( 214
39.2%
) 214
39.2%
92
16.8%
, 26
 
4.8%

품종
Text

Distinct260
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T09:23:23.320243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10
Mean length4.8109
Min length1

Characters and Unicode

Total characters48109
Distinct characters252
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)0.4%

Sample

1st row미얀마
2nd row미역줄기
3rd row기타
4th row오각기
5th row새송이버섯(일반)
ValueCountFrequency (%)
기타 746
 
7.4%
부유 518
 
5.2%
조생귤 450
 
4.5%
바나나(수입 301
 
3.0%
깻잎(일반 264
 
2.6%
다발무 256
 
2.5%
새송이버섯(일반 249
 
2.5%
표고버섯(일반 232
 
2.3%
백다다기 229
 
2.3%
대봉시 199
 
2.0%
Other values (250) 6597
65.7%
2024-03-15T09:23:24.614172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 4345
 
9.0%
( 4345
 
9.0%
반 3642
 
7.6%
일 3566
 
7.4%
기 1189
 
2.5%
타 1153
 
2.4%
추 1034
 
2.1%
수 964
 
2.0%
고 882
 
1.8%
입 870
 
1.8%
Other values (242) 26119
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 39222
81.5%
Close Punctuation 4345
 
9.0%
Open Punctuation 4345
 
9.0%
Decimal Number 153
 
0.3%
Space Separator 41
 
0.1%
Other Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
반 3642
 
9.3%
일 3566
 
9.1%
기 1189
 
3.0%
타 1153
 
2.9%
추 1034
 
2.6%
수 964
 
2.5%
고 882
 
2.2%
입 870
 
2.2%
리 862
 
2.2%
나 850
 
2.2%
Other values (236) 24210
61.7%
Decimal Number
ValueCountFrequency (%)
1 151
98.7%
3 2
 
1.3%
Close Punctuation
ValueCountFrequency (%)
) 4345
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4345
100.0%
Space Separator
ValueCountFrequency (%)
41
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 39222
81.5%
Common 8887
 
18.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
반 3642
 
9.3%
일 3566
 
9.1%
기 1189
 
3.0%
타 1153
 
2.9%
추 1034
 
2.6%
수 964
 
2.5%
고 882
 
2.2%
입 870
 
2.2%
리 862
 
2.2%
나 850
 
2.2%
Other values (236) 24210
61.7%
Common
ValueCountFrequency (%)
) 4345
48.9%
( 4345
48.9%
1 151
 
1.7%
41
 
0.5%
, 3
 
< 0.1%
3 2
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 39222
81.5%
ASCII 8887
 
18.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 4345
48.9%
( 4345
48.9%
1 151
 
1.7%
41
 
0.5%
, 3
 
< 0.1%
3 2
 
< 0.1%
Hangul
ValueCountFrequency (%)
반 3642
 
9.3%
일 3566
 
9.1%
기 1189
 
3.0%
타 1153
 
2.9%
추 1034
 
2.6%
수 964
 
2.5%
고 882
 
2.2%
입 870
 
2.2%
리 862
 
2.2%
나 850
 
2.2%
Other values (236) 24210
61.7%

거래물량(kg)
Real number (ℝ)

HIGH CORRELATION 

Distinct196
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.4798
Minimum1
Maximum912
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T09:23:24.968724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median10
Q329
95-th percentile190.15
Maximum912
Range911
Interquartile range (IQR)25

Descriptive statistics

Standard deviation69.705629
Coefficient of variation (CV)2.0216367
Kurtosis20.082994
Mean34.4798
Median Absolute Deviation (MAD)8
Skewness4.011409
Sum344798
Variance4858.8747
MonotonicityNot monotonic
2024-03-15T09:23:25.230223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 987
 
9.9%
10 915
 
9.2%
5 915
 
9.2%
2 739
 
7.4%
3 515
 
5.1%
4 417
 
4.2%
20 341
 
3.4%
6 338
 
3.4%
8 301
 
3.0%
100 266
 
2.7%
Other values (186) 4266
42.7%
ValueCountFrequency (%)
1 987
9.9%
2 739
7.4%
3 515
5.1%
4 417
4.2%
5 915
9.2%
6 338
 
3.4%
7 262
 
2.6%
8 301
 
3.0%
9 221
 
2.2%
10 915
9.2%
ValueCountFrequency (%)
912 1
 
< 0.1%
720 1
 
< 0.1%
600 1
 
< 0.1%
580 1
 
< 0.1%
540 1
 
< 0.1%
530 1
 
< 0.1%
520 1
 
< 0.1%
502 3
 
< 0.1%
500 35
0.4%
480 1
 
< 0.1%

경락단가(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct1041
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean233089.64
Minimum800
Maximum5200000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T09:23:25.493463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum800
5-th percentile12000
Q145000
median114000
Q3280000
95-th percentile825000
Maximum5200000
Range5199200
Interquartile range (IQR)235000

Descriptive statistics

Standard deviation343658.67
Coefficient of variation (CV)1.4743627
Kurtosis37.785279
Mean233089.64
Median Absolute Deviation (MAD)84000
Skewness4.6041033
Sum2.3308964 × 109
Variance1.1810128 × 1011
MonotonicityNot monotonic
2024-03-15T09:23:25.886548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
90000 183
 
1.8%
40000 173
 
1.7%
60000 170
 
1.7%
30000 130
 
1.3%
120000 129
 
1.3%
80000 112
 
1.1%
20000 101
 
1.0%
45000 100
 
1.0%
150000 96
 
1.0%
50000 94
 
0.9%
Other values (1031) 8712
87.1%
ValueCountFrequency (%)
800 1
 
< 0.1%
1000 2
 
< 0.1%
1200 1
 
< 0.1%
1500 4
 
< 0.1%
1800 2
 
< 0.1%
2000 6
 
0.1%
2500 2
 
< 0.1%
3000 15
0.1%
3100 1
 
< 0.1%
3500 1
 
< 0.1%
ValueCountFrequency (%)
5200000 2
< 0.1%
5040000 1
 
< 0.1%
4730000 3
< 0.1%
4104000 1
 
< 0.1%
3950000 2
< 0.1%
3937500 1
 
< 0.1%
3765000 1
 
< 0.1%
3600000 1
 
< 0.1%
3514000 2
< 0.1%
3000000 2
< 0.1%

산지
Text

Distinct143
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T09:23:27.199261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length6
Mean length5.5473
Min length2

Characters and Unicode

Total characters55473
Distinct characters108
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11 ?
Unique (%)0.1%

Sample

1st row경남 의령군
2nd row경기 광명시
3rd row경기 이천시
4th row경남 의령군
5th row전남 함평군
ValueCountFrequency (%)
충남 2243
 
12.0%
경기 1432
 
7.6%
경남 1098
 
5.9%
전남 1030
 
5.5%
국외 960
 
5.1%
경북 793
 
4.2%
논산시 738
 
3.9%
제주 632
 
3.4%
창원시 602
 
3.2%
인천 521
 
2.8%
Other values (136) 8711
46.4%
2024-03-15T09:23:29.574378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8760
15.8%
시 4646
 
8.4%
남 4616
 
8.3%
경 3410
 
6.1%
군 3330
 
6.0%
충 2664
 
4.8%
주 2031
 
3.7%
기 1500
 
2.7%
천 1332
 
2.4%
산 1319
 
2.4%
Other values (98) 21865
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 46713
84.2%
Space Separator 8760
 
15.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 4646
 
9.9%
남 4616
 
9.9%
경 3410
 
7.3%
군 3330
 
7.1%
충 2664
 
5.7%
주 2031
 
4.3%
기 1500
 
3.2%
천 1332
 
2.9%
산 1319
 
2.8%
북 1289
 
2.8%
Other values (97) 20576
44.0%
Space Separator
ValueCountFrequency (%)
8760
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 46713
84.2%
Common 8760
 
15.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 4646
 
9.9%
남 4616
 
9.9%
경 3410
 
7.3%
군 3330
 
7.1%
충 2664
 
5.7%
주 2031
 
4.3%
기 1500
 
3.2%
천 1332
 
2.9%
산 1319
 
2.8%
북 1289
 
2.8%
Other values (97) 20576
44.0%
Common
ValueCountFrequency (%)
8760
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 46713
84.2%
ASCII 8760
 
15.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8760
100.0%
Hangul
ValueCountFrequency (%)
시 4646
 
9.9%
남 4616
 
9.9%
경 3410
 
7.3%
군 3330
 
7.1%
충 2664
 
5.7%
주 2031
 
4.3%
기 1500
 
3.2%
천 1332
 
2.9%
산 1319
 
2.8%
북 1289
 
2.8%
Other values (97) 20576
44.0%

비고
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경매
8771 
정가수의
1229 

Length

Max length4
Median length2
Mean length2.2458
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경매
2nd row정가수의
3rd row경매
4th row경매
5th row경매

Common Values

ValueCountFrequency (%)
경매 8771
87.7%
정가수의 1229
 
12.3%

Length

2024-03-15T09:23:30.044151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:23:30.405083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경매 8771
87.7%
정가수의 1229
 
12.3%

Interactions

2024-03-15T09:23:17.244803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:23:16.796983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:23:17.414428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:23:17.033905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T09:23:30.617111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경매일자법인명거래물량(kg)경락단가(원)비고
경매일자1.0000.1630.0720.0460.036
법인명0.1631.0000.1560.1110.163
거래물량(kg)0.0720.1561.0000.7690.090
경락단가(원)0.0460.1110.7691.0000.049
비고0.0360.1630.0900.0491.000
2024-03-15T09:23:30.911343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
비고법인명
비고1.0000.269
법인명0.2691.000
2024-03-15T09:23:31.167530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래물량(kg)경락단가(원)법인명비고
거래물량(kg)1.0000.7200.0690.090
경락단가(원)0.7201.0000.0490.049
법인명0.0690.0491.0000.269
비고0.0900.0490.2691.000

Missing values

2024-03-15T09:23:17.758322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T09:23:18.176841image/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

경매일자법인명품목품종거래물량(kg)경락단가(원)산지비고
103712023-11-01(주)경인농산사과미얀마4140000경남 의령군경매
439252023-11-04(주)부평농산조미가공미역줄기444000경기 광명시정가수의
735472023-11-07(주)부평농산참당귀기타565000경기 이천시경매
937382023-11-08(주)경인농산단감오각기15345000경남 의령군경매
785322023-11-07(주)경인농산새송이버섯새송이버섯(일반)537500전남 함평군경매
522822023-11-04인천원예농협양송이기타420000충남 부여군경매
216522023-11-02(주)부평농산단감부유115000경남 창원시경매
663282023-11-06(주)경인농산감귤조생귤26117000제주 서귀포시경매
655802023-11-06(주)경인농산쪽파깐쪽파30135000충남 서천군경매
78922023-11-01(주)부평농산사과미얀마4144000경북 의성군경매
경매일자법인명품목품종거래물량(kg)경락단가(원)산지비고
778012023-11-07(주)경인농산브로코리(녹색꽃양배추)브로코리(일반)11165000제주 북제주군경매
149592023-11-02(주)부평농산갓홍갓6030000경기 고양시 일산서구경매
532662023-11-04인천원예농협단감부유254000경남 창원시경매
271602023-11-02인천원예농협떫은감반시6114000경북 청도군경매
367822023-11-03(주)부평농산파인애플파인애플(수입)4152000국외정가수의
466232023-11-04(주)부평농산참다래(키위)키위(수입)5270000국외정가수의
654112023-11-06(주)경인농산새송이버섯새송이버섯(일반)327000충북 음성군경매
685612023-11-06인천원예농협양배추양배추(일반)60750000충남 서산시정가수의
132252023-11-01인천원예농협감귤조생귤75787500제주 제주시경매
637192023-11-06(주)부평농산아보카도아보카도(수입)11176000국외정가수의

Duplicate rows

Most frequently occurring

경매일자법인명품목품종거래물량(kg)경락단가(원)산지비고# duplicates
10922023-11-06(주)부평농산양상추양상추(일반)5150000경남 하동군경매19
10872023-11-06(주)부평농산알타리무알타리무(일반)200540000경기 화성시경매14
12732023-11-07(주)부평농산느타리버섯느타리버섯(일반)535000경기 양평군경매13
6092023-11-03(주)부평농산새송이버섯새송이버섯(일반)1093000경북 청도군경매11
15872023-11-08(주)부평농산양상추양상추(일반)580000경남 하동군경매11
16272023-11-08(주)부평농산팽이버섯팽이1호562500경북 청도군경매11
4082023-11-02(주)부평농산표고버섯표고버섯(수입)218000국외경매10
12832023-11-07(주)부평농산대파대파(일반)250750000전남 신안군경매10
13442023-11-07(주)부평농산양상추양상추(일반)5110000경남 하동군경매10
15642023-11-08(주)부평농산새송이버섯새송이버섯(일반)1070000전남 나주시경매10