Overview

Dataset statistics

Number of variables14
Number of observations999
Missing cells0
Missing cells (%)0.0%
Duplicate rows187
Duplicate rows (%)18.7%
Total size in memory114.3 KiB
Average record size in memory117.1 B

Variable types

Categorical9
Numeric4
Boolean1

Dataset

Description가락시장 오이,참외,호박 품목의 경매결과 데이터 중 2017년 1월 3일자 일부 데이터를 샘플데이터로 제공하고 있습니다.해당 데이터는 공공데이터로 제공하고 있으며 아래의 URL에 접근하시거나 제공 신청을 통해 데이터를 얻으실 수 있습니다.https://www.garak.co.kr/publicdata/selectPageListPublicData.do?sch_public_data_realm_code=5
Author서울특별시농수산식품공사
URLhttps://www.data.go.kr/data/15106788/fileData.do

Alerts

날짜 has constant value ""Constant
단위 has constant value ""Constant
재경매여부 has constant value ""Constant
Dataset has 187 (18.7%) duplicate rowsDuplicates
응찰시간 is highly overall correlated with 경매번호 and 6 other fieldsHigh correlation
품종 is highly overall correlated with 경매번호 and 5 other fieldsHigh correlation
경매종료시간 is highly overall correlated with 경매번호 and 7 other fieldsHigh correlation
낙찰시간 is highly overall correlated with 경매번호 and 7 other fieldsHigh correlation
경매시작시간 is highly overall correlated with 경매번호 and 6 other fieldsHigh correlation
경매번호 is highly overall correlated with 낙찰가 and 5 other fieldsHigh correlation
수량 is highly overall correlated with 경매종료시간 and 1 other fieldsHigh correlation
낙찰가 is highly overall correlated with 경매번호 and 6 other fieldsHigh correlation
응찰가격 is highly overall correlated with 응찰여부High correlation
단량 is highly overall correlated with 낙찰가 and 4 other fieldsHigh correlation
응찰여부 is highly overall correlated with 응찰가격High correlation
단량 is highly imbalanced (67.6%)Imbalance
응찰가격 has 433 (43.3%) zerosZeros

Reproduction

Analysis started2023-12-12 21:35:07.407931
Analysis finished2023-12-12 21:35:10.253288
Duration2.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

날짜
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2017-01-03
999 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01-03
2nd row2017-01-03
3rd row2017-01-03
4th row2017-01-03
5th row2017-01-03

Common Values

ValueCountFrequency (%)
2017-01-03 999
100.0%

Length

2023-12-13T06:35:10.320384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:35:10.402470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017-01-03 999
100.0%

경매번호
Real number (ℝ)

HIGH CORRELATION 

Distinct83
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean227237.14
Minimum170100
Maximum376600
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T06:35:10.509484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum170100
5-th percentile170600
Q1172700
median220900
Q3260700
95-th percentile376100
Maximum376600
Range206500
Interquartile range (IQR)88000

Descriptive statistics

Standard deviation57866.243
Coefficient of variation (CV)0.25465134
Kurtosis1.0230301
Mean227237.14
Median Absolute Deviation (MAD)40600
Skewness1.1520946
Sum2.2700991 × 108
Variance3.3485021 × 109
MonotonicityNot monotonic
2023-12-13T06:35:10.663059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
376100 34
 
3.4%
261200 28
 
2.8%
260000 25
 
2.5%
261400 23
 
2.3%
171100 19
 
1.9%
260900 19
 
1.9%
260700 19
 
1.9%
260200 19
 
1.9%
261600 18
 
1.8%
220300 18
 
1.8%
Other values (73) 777
77.8%
ValueCountFrequency (%)
170100 8
0.8%
170200 8
0.8%
170300 11
1.1%
170400 8
0.8%
170500 13
1.3%
170600 10
1.0%
170700 11
1.1%
170800 5
 
0.5%
170900 15
1.5%
171000 9
0.9%
ValueCountFrequency (%)
376600 12
 
1.2%
376500 7
 
0.7%
376400 9
 
0.9%
376300 8
 
0.8%
376200 13
 
1.3%
376100 34
3.4%
261700 13
 
1.3%
261600 18
1.8%
261500 13
 
1.3%
261400 23
2.3%

품종
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
오이
538 
호박
378 
참외
83 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row참외
2nd row참외
3rd row참외
4th row참외
5th row참외

Common Values

ValueCountFrequency (%)
오이 538
53.9%
호박 378
37.8%
참외 83
 
8.3%

Length

2023-12-13T06:35:10.809075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:35:10.895604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오이 538
53.9%
호박 378
37.8%
참외 83
 
8.3%

단량
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
10
940 
18
 
59

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 940
94.1%
18 59
 
5.9%

Length

2023-12-13T06:35:10.995247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:35:11.097448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 940
94.1%
18 59
 
5.9%

단위
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
키로말
999 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row키로말
2nd row키로말
3rd row키로말
4th row키로말
5th row키로말

Common Values

ValueCountFrequency (%)
키로말 999
100.0%

Length

2023-12-13T06:35:11.206054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:35:11.323675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
키로말 999
100.0%

수량
Real number (ℝ)

HIGH CORRELATION 

Distinct32
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13.912913
Minimum1
Maximum115
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T06:35:11.439003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median8
Q314
95-th percentile47
Maximum115
Range114
Interquartile range (IQR)10

Descriptive statistics

Standard deviation18.705754
Coefficient of variation (CV)1.3444887
Kurtosis14.08812
Mean13.912913
Median Absolute Deviation (MAD)5
Skewness3.3406962
Sum13899
Variance349.90523
MonotonicityNot monotonic
2023-12-13T06:35:11.562854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
5 124
 
12.4%
3 93
 
9.3%
4 83
 
8.3%
2 78
 
7.8%
8 73
 
7.3%
1 67
 
6.7%
9 61
 
6.1%
14 42
 
4.2%
10 32
 
3.2%
13 27
 
2.7%
Other values (22) 319
31.9%
ValueCountFrequency (%)
1 67
6.7%
2 78
7.8%
3 93
9.3%
4 83
8.3%
5 124
12.4%
6 14
 
1.4%
7 18
 
1.8%
8 73
7.3%
9 61
6.1%
10 32
 
3.2%
ValueCountFrequency (%)
115 19
1.9%
52 18
1.8%
48 9
0.9%
47 6
 
0.6%
46 5
 
0.5%
45 9
0.9%
40 11
1.1%
36 18
1.8%
32 11
1.1%
31 21
2.1%

경매시작시간
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2017-01-02 22:42
117 
2017-01-02 22:43
107 
2017-01-02 23:25
102 
2017-01-02 23:24
89 
2017-01-02 22:09
85 
Other values (10)
499 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01-03 02:11
2nd row2017-01-03 02:11
3rd row2017-01-03 02:11
4th row2017-01-03 02:11
5th row2017-01-03 02:11

Common Values

ValueCountFrequency (%)
2017-01-02 22:42 117
11.7%
2017-01-02 22:43 107
10.7%
2017-01-02 23:25 102
10.2%
2017-01-02 23:24 89
8.9%
2017-01-02 22:09 85
8.5%
2017-01-03 02:11 83
8.3%
2017-01-02 23:20 82
8.2%
2017-01-02 22:41 74
7.4%
2017-01-02 22:10 67
6.7%
2017-01-02 22:11 63
6.3%
Other values (5) 130
13.0%

Length

2023-12-13T06:35:11.699385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-01-02 916
45.8%
22:42 117
 
5.9%
22:43 107
 
5.4%
23:25 102
 
5.1%
23:24 89
 
4.5%
22:09 85
 
4.3%
2017-01-03 83
 
4.2%
02:11 83
 
4.2%
23:20 82
 
4.1%
22:41 74
 
3.7%
Other values (7) 260
 
13.0%

경매종료시간
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2017-01-02 22:42
119 
2017-01-02 22:43
105 
2017-01-02 23:25
104 
2017-01-02 23:24
88 
2017-01-03 02:11
83 
Other values (12)
500 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01-03 02:11
2nd row2017-01-03 02:11
3rd row2017-01-03 02:11
4th row2017-01-03 02:11
5th row2017-01-03 02:11

Common Values

ValueCountFrequency (%)
2017-01-02 22:42 119
11.9%
2017-01-02 22:43 105
10.5%
2017-01-02 23:25 104
10.4%
2017-01-02 23:24 88
8.8%
2017-01-03 02:11 83
8.3%
2017-01-02 23:20 71
7.1%
2017-01-02 22:10 71
7.1%
2017-01-02 22:09 70
7.0%
2017-01-02 22:11 61
 
6.1%
2017-01-02 22:41 61
 
6.1%
Other values (7) 166
16.6%

Length

2023-12-13T06:35:11.863032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-01-02 916
45.8%
22:42 119
 
6.0%
22:43 105
 
5.3%
23:25 104
 
5.2%
23:24 88
 
4.4%
2017-01-03 83
 
4.2%
02:11 83
 
4.2%
23:20 71
 
3.6%
22:10 71
 
3.6%
22:09 70
 
3.5%
Other values (9) 288
 
14.4%

낙찰시간
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2017-01-02 22:42
119 
2017-01-02 22:43
105 
2017-01-02 23:25
104 
2017-01-02 23:24
88 
2017-01-03 02:11
83 
Other values (12)
500 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01-03 02:11
2nd row2017-01-03 02:11
3rd row2017-01-03 02:11
4th row2017-01-03 02:11
5th row2017-01-03 02:11

Common Values

ValueCountFrequency (%)
2017-01-02 22:42 119
11.9%
2017-01-02 22:43 105
10.5%
2017-01-02 23:25 104
10.4%
2017-01-02 23:24 88
8.8%
2017-01-03 02:11 83
8.3%
2017-01-02 23:20 71
7.1%
2017-01-02 22:10 71
7.1%
2017-01-02 22:09 70
7.0%
2017-01-02 22:11 61
 
6.1%
2017-01-02 22:41 61
 
6.1%
Other values (7) 166
16.6%

Length

2023-12-13T06:35:11.993622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-01-02 916
45.8%
22:42 119
 
6.0%
22:43 105
 
5.3%
23:25 104
 
5.2%
23:24 88
 
4.4%
2017-01-03 83
 
4.2%
02:11 83
 
4.2%
23:20 71
 
3.6%
22:10 71
 
3.6%
22:09 70
 
3.5%
Other values (9) 288
 
14.4%

낙찰가
Real number (ℝ)

HIGH CORRELATION 

Distinct44
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22020.521
Minimum4500
Maximum75000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T06:35:12.104957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4500
5-th percentile7500
Q113000
median23000
Q330000
95-th percentile37000
Maximum75000
Range70500
Interquartile range (IQR)17000

Descriptive statistics

Standard deviation11184.857
Coefficient of variation (CV)0.50792883
Kurtosis3.9764174
Mean22020.521
Median Absolute Deviation (MAD)8000
Skewness1.1969303
Sum21998500
Variance1.2510103 × 108
MonotonicityNot monotonic
2023-12-13T06:35:12.263699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
30000 115
 
11.5%
15000 77
 
7.7%
10000 64
 
6.4%
30500 47
 
4.7%
14000 42
 
4.2%
13000 39
 
3.9%
32000 35
 
3.5%
25000 33
 
3.3%
24000 33
 
3.3%
37000 32
 
3.2%
Other values (34) 482
48.2%
ValueCountFrequency (%)
4500 5
 
0.5%
5500 12
 
1.2%
6500 7
 
0.7%
7000 16
 
1.6%
7500 20
 
2.0%
8500 11
 
1.1%
9000 27
2.7%
10000 64
6.4%
10500 20
 
2.0%
11000 10
 
1.0%
ValueCountFrequency (%)
75000 12
 
1.2%
38500 13
 
1.3%
38000 18
1.8%
37000 32
3.2%
36000 9
 
0.9%
35500 13
 
1.3%
35000 13
 
1.3%
32500 14
 
1.4%
32000 35
3.5%
31000 13
 
1.3%

응찰여부
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
응찰
566 
취소
433 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row응찰
2nd row응찰
3rd row응찰
4th row응찰
5th row취소

Common Values

ValueCountFrequency (%)
응찰 566
56.7%
취소 433
43.3%

Length

2023-12-13T06:35:12.411660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:35:12.507074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
응찰 566
56.7%
취소 433
43.3%

응찰가격
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct82
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11269.469
Minimum0
Maximum188500
Zeros433
Zeros (%)43.3%
Negative0
Negative (%)0.0%
Memory size8.9 KiB
2023-12-13T06:35:12.644782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median9000
Q320500
95-th percentile31000
Maximum188500
Range188500
Interquartile range (IQR)20500

Descriptive statistics

Standard deviation13559.251
Coefficient of variation (CV)1.2031845
Kurtosis29.595813
Mean11269.469
Median Absolute Deviation (MAD)9000
Skewness3.0329355
Sum11258200
Variance1.8385329 × 108
MonotonicityNot monotonic
2023-12-13T06:35:12.805735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 433
43.3%
14000 35
 
3.5%
10000 29
 
2.9%
9000 23
 
2.3%
30000 22
 
2.2%
18500 20
 
2.0%
24000 19
 
1.9%
26000 17
 
1.7%
28500 15
 
1.5%
13500 14
 
1.4%
Other values (72) 372
37.2%
ValueCountFrequency (%)
0 433
43.3%
1500 1
 
0.1%
2000 1
 
0.1%
2100 1
 
0.1%
2500 1
 
0.1%
3000 1
 
0.1%
3100 1
 
0.1%
4500 1
 
0.1%
5500 4
 
0.4%
6000 2
 
0.2%
ValueCountFrequency (%)
188500 1
0.1%
75000 1
0.1%
73000 1
0.1%
72000 1
0.1%
64500 1
0.1%
63000 2
0.2%
62000 1
0.1%
48500 1
0.1%
38500 1
0.1%
38000 1
0.1%

응찰시간
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2017-01-02 22:42
115 
2017-01-02 22:43
104 
2017-01-02 23:25
101 
2017-01-02 23:24
89 
2017-01-03 02:11
83 
Other values (12)
507 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017-01-03 02:11
2nd row2017-01-03 02:11
3rd row2017-01-03 02:11
4th row2017-01-03 02:11
5th row2017-01-03 02:11

Common Values

ValueCountFrequency (%)
2017-01-02 22:42 115
11.5%
2017-01-02 22:43 104
10.4%
2017-01-02 23:25 101
10.1%
2017-01-02 23:24 89
8.9%
2017-01-03 02:11 83
8.3%
2017-01-02 23:20 80
8.0%
2017-01-02 22:09 78
7.8%
2017-01-02 22:41 74
7.4%
2017-01-02 22:10 70
7.0%
2017-01-02 22:11 67
6.7%
Other values (7) 138
13.8%

Length

2023-12-13T06:35:12.942736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-01-02 916
45.8%
22:42 115
 
5.8%
22:43 104
 
5.2%
23:25 101
 
5.1%
23:24 89
 
4.5%
2017-01-03 83
 
4.2%
02:11 83
 
4.2%
23:20 80
 
4.0%
22:09 78
 
3.9%
22:41 74
 
3.7%
Other values (9) 275
 
13.8%

재경매여부
Boolean

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
False
999 
ValueCountFrequency (%)
False 999
100.0%
2023-12-13T06:35:13.035472image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2023-12-13T06:35:09.465829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.136261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.537900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.027005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.588330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.235680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.659340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.149405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.692035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.339320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.789339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.248152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.809678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.439056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:08.914735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:35:09.349758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:35:13.430450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경매번호품종단량수량경매시작시간경매종료시간낙찰시간낙찰가응찰여부응찰가격응찰시간
경매번호1.0001.0000.6350.4021.0001.0001.0000.7970.0000.3451.000
품종1.0001.0000.1380.5541.0001.0001.0000.9320.0000.4081.000
단량0.6350.1381.0000.1990.7780.8060.8060.8540.0000.2900.794
수량0.4020.5540.1991.0000.7050.8140.8140.7370.0000.2350.719
경매시작시간1.0001.0000.7780.7051.0000.9800.9800.8630.0000.6690.996
경매종료시간1.0001.0000.8060.8140.9801.0001.0000.8700.0290.5950.996
낙찰시간1.0001.0000.8060.8140.9801.0001.0000.8700.0290.5950.996
낙찰가0.7970.9320.8540.7370.8630.8700.8701.0000.0810.6200.861
응찰여부0.0000.0000.0000.0000.0000.0290.0290.0811.0000.4430.000
응찰가격0.3450.4080.2900.2350.6690.5950.5950.6200.4431.0000.586
응찰시간1.0001.0000.7940.7190.9960.9960.9960.8610.0000.5861.000
2023-12-13T06:35:13.598377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
응찰시간응찰여부단량품종경매종료시간낙찰시간경매시작시간
응찰시간1.0000.0000.7340.9930.8450.8450.974
응찰여부0.0001.0000.0000.0000.0250.0250.000
단량0.7340.0001.0000.2280.7460.7460.728
품종0.9930.0000.2281.0000.9930.9930.994
경매종료시간0.8450.0250.7460.9931.0001.0000.866
낙찰시간0.8450.0250.7460.9931.0001.0000.866
경매시작시간0.9740.0000.7280.9940.8660.8661.000
2023-12-13T06:35:13.725551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경매번호수량낙찰가응찰가격품종단량경매시작시간경매종료시간낙찰시간응찰여부응찰시간
경매번호1.000-0.2170.6220.2210.9990.4420.9940.9930.9930.0000.993
수량-0.2171.0000.2610.1190.2720.1430.4210.5540.5540.0000.439
낙찰가0.6220.2611.0000.3710.6850.6600.6230.6440.6440.0600.627
응찰가격0.2210.1190.3711.0000.3380.3530.3490.3550.3550.5380.348
품종0.9990.2720.6850.3381.0000.2280.9940.9930.9930.0000.993
단량0.4420.1430.6600.3530.2281.0000.7280.7460.7460.0000.734
경매시작시간0.9940.4210.6230.3490.9940.7281.0000.8660.8660.0000.974
경매종료시간0.9930.5540.6440.3550.9930.7460.8661.0001.0000.0250.845
낙찰시간0.9930.5540.6440.3550.9930.7460.8661.0001.0000.0250.845
응찰여부0.0000.0000.0600.5380.0000.0000.0000.0250.0251.0000.000
응찰시간0.9930.4390.6270.3480.9930.7340.9740.8450.8450.0001.000

Missing values

2023-12-13T06:35:09.966041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:35:10.178976image/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

날짜경매번호품종단량단위수량경매시작시간경매종료시간낙찰시간낙찰가응찰여부응찰가격응찰시간재경매여부
02017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000응찰25002017-01-03 02:11N
12017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000응찰30002017-01-03 02:11N
22017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000응찰20002017-01-03 02:11N
32017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000응찰200002017-01-03 02:11N
42017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N
52017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000응찰200002017-01-03 02:11N
62017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N
72017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N
82017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N
92017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N
날짜경매번호품종단량단위수량경매시작시간경매종료시간낙찰시간낙찰가응찰여부응찰가격응찰시간재경매여부
9892017-01-03173604호박10키로말452017-01-02 23:252017-01-02 23:262017-01-02 23:2615000응찰135002017-01-02 23:25N
9902017-01-03173604호박10키로말452017-01-02 23:252017-01-02 23:262017-01-02 23:2615000취소02017-01-02 23:25N
9912017-01-03173604호박10키로말452017-01-02 23:252017-01-02 23:262017-01-02 23:2615000응찰150002017-01-02 23:25N
9922017-01-03173604호박10키로말452017-01-02 23:252017-01-02 23:262017-01-02 23:2615000취소02017-01-02 23:25N
9932017-01-03173604호박10키로말452017-01-02 23:252017-01-02 23:262017-01-02 23:2615000취소02017-01-02 23:26N
9942017-01-03173605호박10키로말32017-01-02 23:262017-01-02 23:262017-01-02 23:2610500응찰90002017-01-02 23:26N
9952017-01-03173605호박10키로말32017-01-02 23:262017-01-02 23:262017-01-02 23:2610500취소02017-01-02 23:26N
9962017-01-03173605호박10키로말32017-01-02 23:262017-01-02 23:262017-01-02 23:2610500응찰105002017-01-02 23:26N
9972017-01-03173605호박10키로말32017-01-02 23:262017-01-02 23:262017-01-02 23:2610500응찰95002017-01-02 23:26N
9982017-01-03173605호박10키로말32017-01-02 23:262017-01-02 23:262017-01-02 23:2610500응찰85002017-01-02 23:26N

Duplicate rows

Most frequently occurring

날짜경매번호품종단량단위수량경매시작시간경매종료시간낙찰시간낙찰가응찰여부응찰가격응찰시간재경매여부# duplicates
1742017-01-03376100참외10키로말52017-01-03 02:112017-01-03 02:112017-01-03 02:1130000취소02017-01-03 02:11N19
1222017-01-03260000오이10키로말142017-01-02 22:412017-01-02 22:412017-01-02 22:4125000취소02017-01-02 22:41N15
1362017-01-03260500오이10키로말12017-01-02 22:422017-01-02 22:422017-01-02 22:4218500취소02017-01-02 22:42N12
1302017-01-03260200오이10키로말52017-01-02 22:412017-01-02 22:412017-01-02 22:4123500취소02017-01-02 22:41N10
1462017-01-03260900오이10키로말92017-01-02 22:422017-01-02 22:422017-01-02 22:4226000취소02017-01-02 22:42N10
872017-01-03220300오이10키로말362017-01-02 22:092017-01-02 22:092017-01-02 22:0938000취소02017-01-02 22:09N9
1572017-01-03261300오이10키로말22017-01-02 22:432017-01-02 22:432017-01-02 22:4322000취소02017-01-02 22:43N9
672017-01-03173300호박10키로말12017-01-02 23:252017-01-02 23:252017-01-02 23:257500취소02017-01-02 23:25N8
882017-01-03220400오이10키로말312017-01-02 22:092017-01-02 22:092017-01-02 22:0937000취소02017-01-02 22:09N8
902017-01-03220500오이18키로말82017-01-02 22:092017-01-02 22:092017-01-02 22:0937000취소02017-01-02 22:09N8