gimi9 Pandas Profiling

Dataset statistics

Number of variables	16
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	145.0 B

Variable types

DateTime	1
Categorical	4
Text	2
Numeric	9

Dataset

Description	거래일,시장,품목명,품목코드,등급,거래수량,거래단위수량,평균가격,전일평균가격,전년가격,전일대비등락율,검색일전년대비등락율,등급,거래단위,등급단위,중량단위
Author	서울시농수산식품공사
URL	https://data.seoul.go.kr/dataList/OA-20949/S/1/datasetView.do

Alerts

`등급.1` is highly overall correlated with `등급단위` and 1 other fields	High correlation
`등급` is highly overall correlated with `등급단위` and 1 other fields	High correlation
`거래수량` is highly overall correlated with `거래단위`	High correlation
`평균가격` is highly overall correlated with `전일평균가격` and 2 other fields	High correlation
`전일평균가격` is highly overall correlated with `평균가격` and 2 other fields	High correlation
`전일대비등락율` is highly overall correlated with `평균가격` and 2 other fields	High correlation
`검색일전년대비등락율` is highly overall correlated with `평균가격` and 2 other fields	High correlation
`등급단위` is highly overall correlated with `등급` and 1 other fields	High correlation
`중량단위` is highly overall correlated with `거래단위`	High correlation
`거래단위` is highly overall correlated with `거래수량` and 1 other fields	High correlation
`거래단위` is highly imbalanced (62.6%)	Imbalance
`평균가격` has 3251 (32.5%) zeros	Zeros
`전일평균가격` has 3162 (31.6%) zeros	Zeros
`전년가격` has 2141 (21.4%) zeros	Zeros
`전일대비등락율` has 4473 (44.7%) zeros	Zeros
`검색일전년대비등락율` has 5017 (50.2%) zeros	Zeros
`등급단위` has 1614 (16.1%) zeros	Zeros
`중량단위` has 1184 (11.8%) zeros	Zeros

Reproduction

Analysis started	2024-05-11 06:24:50.227829
Analysis finished	2024-05-11 06:25:15.827254
Duration	25.6 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

거래일
Date

Distinct	50
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	2024-03-22 00:00:00
Maximum	2024-05-10 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

시장
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

가락시장	5246
강서시장(경매)	2540
강서시장(시장도메인)	2214

Length

Max length	11
Median length	4
Mean length	6.5658
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	가락시장
2nd row	가락시장
3rd row	가락시장
4th row	강서시장(경매)
5th row	강서시장(시장도메인)

Common Values

Value	Count	Frequency (%)
가락시장	5246	52.5%
강서시장(경매)	2540	25.4%
강서시장(시장도메인)	2214	22.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
가락시장	5246	52.5%
강서시장(경매	2540	25.4%
강서시장(시장도메인	2214	22.1%

품목명
Text

Distinct	265
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	10
Median length	8
Mean length	4.6706
Min length	1

Characters and Unicode

Total characters	46706
Distinct characters	273
Distinct categories	5 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	0.1%

Sample

1st row	수박(일반)
2nd row	딸기 금실
3rd row	열무
4th row	사과 시나노레드
5th row	토마토

Value	Count	Frequency (%)
수입	741	5.2%
사과	629	4.4%
딸기	400	2.8%
감귤	387	2.7%
시금치	267	1.9%
양파	247	1.7%
감자	241	1.7%
고구마	218	1.5%
배	214	1.5%
국산	200	1.4%
Other values (264)	10611	75.0%

Most occurring characters

Value	Count	Frequency (%)
	4155	8.9%
추	1448	3.1%
수	1154	2.5%
)	1114	2.4%
(	1114	2.4%
고	1027	2.2%
양	1009	2.2%
감	986	2.1%
파	874	1.9%
마	840	1.8%
Other values (263)	32985	70.6%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	40320	86.3%
Space Separator	4155	8.9%
Close Punctuation	1114	2.4%
Open Punctuation	1114	2.4%
Uppercase Letter	3	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
추	1448	3.6%
수	1154	2.9%
고	1027	2.5%
양	1009	2.5%
감	986	2.4%
파	874	2.2%
마	840	2.1%
배	824	2.0%
사	803	2.0%
일	759	1.9%
Other values (257)	30596	75.9%

Uppercase Letter

Value	Count	Frequency (%)
M	1	33.3%
B	1	33.3%
A	1	33.3%

Space Separator

Value	Count	Frequency (%)
	4155	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1114	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1114	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	40320	86.3%
Common	6383	13.7%
Latin	3	< 0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
추	1448	3.6%
수	1154	2.9%
고	1027	2.5%
양	1009	2.5%
감	986	2.4%
파	874	2.2%
마	840	2.1%
배	824	2.0%
사	803	2.0%
일	759	1.9%
Other values (257)	30596	75.9%

Common

Value	Count	Frequency (%)
	4155	65.1%
)	1114	17.5%
(	1114	17.5%

Latin

Value	Count	Frequency (%)
M	1	33.3%
B	1	33.3%
A	1	33.3%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	40320	86.3%
ASCII	6386	13.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4155	65.1%
)	1114	17.4%
(	1114	17.4%
M	1	< 0.1%
B	1	< 0.1%
A	1	< 0.1%

Hangul

Value	Count	Frequency (%)
추	1448	3.6%
수	1154	2.9%
고	1027	2.5%
양	1009	2.5%
감	986	2.4%
파	874	2.2%
마	840	2.1%
배	824	2.0%
사	803	2.0%
일	759	1.9%
Other values (257)	30596	75.9%

품목코드
Real number (ℝ)

Distinct	265
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31523.17

Minimum	15100
Maximum	81802
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	15100
5-th percentile	21100
Q1	22402
median	25101
Q3	41131
95-th percentile	67134
Maximum	81802
Range	66702
Interquartile range (IQR)	18729

Descriptive statistics

Standard deviation	14327.904
Coefficient of variation (CV)	0.45451976
Kurtosis	2.6459117
Mean	31523.17
Median Absolute Deviation (MAD)	3697
Skewness	1.7116525
Sum	3.152317 × 10⁸
Variance	2.0528883 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24400	170	1.7%
41507	157	1.6%
21300	145	1.5%
22500	144	1.4%
22101	138	1.4%
32103	134	1.3%
41500	133	1.3%
22302	125	1.2%
32104	122	1.2%
22100	122	1.2%
Other values (255)	8610	86.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15100	75	0.8%
15102	22	0.2%
15103	50	0.5%
15111	52	0.5%
15115	19	0.2%
15200	59	0.6%
15202	6	0.1%
15203	39	0.4%
15205	75	0.8%
15207	26	0.3%

Value	Count	Frequency (%)
81802	26	0.3%
81207	23	0.2%
81204	26	0.3%
81203	20	0.2%
81202	22	0.2%
81201	21	0.2%
81101	19	0.2%
77202	17	0.2%
77201	13	0.1%
77101	5	0.1%

등급
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

상	2960
중	2720
하	2587
특	1614
대	75

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	중
2nd row	하
3rd row	상
4th row	특
5th row	중

Common Values

Value	Count	Frequency (%)
상	2960	29.6%
중	2720	27.2%
하	2587	25.9%
특	1614	16.1%
대	75	0.8%
소	44	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
상	2960	29.6%
중	2720	27.2%
하	2587	25.9%
특	1614	16.1%
대	75	0.8%
소	44	0.4%

거래수량
Real number (ℝ)

HIGH CORRELATION

Distinct	29
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.578855

Minimum	0.05
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.05
5-th percentile	1
Q1	4
median	8
Q3	10
95-th percentile	20
Maximum	500
Range	499.95
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	58.613977
Coefficient of variation (CV)	3.762406
Kurtosis	59.244133
Mean	15.578855
Median Absolute Deviation (MAD)	4
Skewness	7.6897135
Sum	155788.55
Variance	3435.5983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
10.0	2694	26.9%
4.0	1302	13.0%
5.0	921	9.2%
1.0	899	9.0%
2.0	886	8.9%
8.0	810	8.1%
20.0	553	5.5%
3.0	341	3.4%
15.0	298	3.0%
12.0	216	2.2%
Other values (19)	1080	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05	25	0.2%
0.2	22	0.2%
0.5	13	0.1%
1.0	899	9.0%
1.5	179	1.8%
2.0	886	8.9%
2.5	18	0.2%
3.0	341	3.4%
3.6	24	0.2%
4.0	1302	13.0%

Value	Count	Frequency (%)
500.0	125	1.2%
400.0	20	0.2%
200.0	15	0.1%
100.0	81	0.8%
50.0	60	0.6%
20.0	553	5.5%
18.0	98	1.0%
17.0	16	0.2%
16.0	59	0.6%
15.0	298	3.0%

거래단위수량
Text

Distinct	59
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	7
Median length	6
Mean length	5.1683
Min length	2

Characters and Unicode

Total characters	51683
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	9키로개
2nd row	1키로상자
3rd row	1.5키로단
4th row	10키로상자
5th row	5키로상자

Value	Count	Frequency (%)
10키로상자	2434	24.3%
4키로상자	1181	11.8%
5키로상자	917	9.2%
2키로상자	860	8.6%
1키로	608	6.1%
8키로상자	587	5.9%
20키로상자	388	3.9%
3키로상자	338	3.4%
10키로망대	237	2.4%
15키로상자	194	1.9%
Other values (47)	2256	22.6%

Most occurring characters

Value	Count	Frequency (%)
키	9602	18.6%
로	9602	18.6%
상	7707	14.9%
자	7707	14.9%
1	4608	8.9%
0	3814	7.4%
5	1740	3.4%
2	1710	3.3%
4	1322	2.6%
8	908	1.8%
Other values (15)	2963	5.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	36410	70.4%
Decimal Number	14891	28.8%
Other Punctuation	382	0.7%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
키	9602	26.4%
로	9602	26.4%
상	7707	21.2%
자	7707	21.2%
대	363	1.0%
개	360	1.0%
망	349	1.0%
단	314	0.9%
그	160	0.4%
람	160	0.4%
Other values (4)	86	0.2%

Decimal Number

Value	Count	Frequency (%)
1	4608	30.9%
0	3814	25.6%
5	1740	11.7%
2	1710	11.5%
4	1322	8.9%
8	908	6.1%
3	433	2.9%
6	163	1.1%
7	146	1.0%
9	47	0.3%

Other Punctuation

Value	Count	Frequency (%)
.	382	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	36410	70.4%
Common	15273	29.6%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
키	9602	26.4%
로	9602	26.4%
상	7707	21.2%
자	7707	21.2%
대	363	1.0%
개	360	1.0%
망	349	1.0%
단	314	0.9%
그	160	0.4%
람	160	0.4%
Other values (4)	86	0.2%

Common

Value	Count	Frequency (%)
1	4608	30.2%
0	3814	25.0%
5	1740	11.4%
2	1710	11.2%
4	1322	8.7%
8	908	5.9%
3	433	2.8%
.	382	2.5%
6	163	1.1%
7	146	1.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	36410	70.4%
ASCII	15273	29.6%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
키	9602	26.4%
로	9602	26.4%
상	7707	21.2%
자	7707	21.2%
대	363	1.0%
개	360	1.0%
망	349	1.0%
단	314	0.9%
그	160	0.4%
람	160	0.4%
Other values (4)	86	0.2%

ASCII

Value	Count	Frequency (%)
1	4608	30.2%
0	3814	25.0%
5	1740	11.4%
2	1710	11.2%
4	1322	8.7%
8	908	5.9%
3	433	2.8%
.	382	2.5%
6	163	1.1%
7	146	1.0%

평균가격
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	5538
Distinct (%)	55.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19388.847

Minimum	0
Maximum	380000
Zeros	3251
Zeros (%)	32.5%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	9915.5
Q3	24937.25
95-th percentile	72363
Maximum	380000
Range	380000
Interquartile range (IQR)	24937.25

Descriptive statistics

Standard deviation	30029.7
Coefficient of variation (CV)	1.5488131
Kurtosis	17.092109
Mean	19388.847
Median Absolute Deviation (MAD)	9915.5
Skewness	3.394724
Sum	1.9388848 × 10⁸
Variance	9.017829 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3251	32.5%
20000	33	0.3%
18000	30	0.3%
16000	19	0.2%
19000	18	0.2%
14000	17	0.2%
30000	17	0.2%
15000	17	0.2%
10000	15	0.1%
38000	15	0.1%
Other values (5528)	6568	65.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3251	32.5%
100	1	< 0.1%
250	3	< 0.1%
252	2	< 0.1%
254	1	< 0.1%
261	1	< 0.1%
309	1	< 0.1%
316	1	< 0.1%
317	1	< 0.1%
322	1	< 0.1%

Value	Count	Frequency (%)
380000	1	< 0.1%
323243	1	< 0.1%
288000	1	< 0.1%
272381	1	< 0.1%
267750	1	< 0.1%
260000	1	< 0.1%
256860	1	< 0.1%
247800	2	< 0.1%
245700	1	< 0.1%
245647	1	< 0.1%

전일평균가격
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	5638
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19766.786

Minimum	0
Maximum	441667
Zeros	3162
Zeros (%)	31.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	10400
Q3	25533.75
95-th percentile	74932
Maximum	441667
Range	441667
Interquartile range (IQR)	25533.75

Descriptive statistics

Standard deviation	30106.251
Coefficient of variation (CV)	1.5230726
Kurtosis	20.050862
Mean	19766.786
Median Absolute Deviation (MAD)	10400
Skewness	3.4776671
Sum	1.9766786 × 10⁸
Variance	9.0638637 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3162	31.6%
18000	33	0.3%
20000	26	0.3%
10000	21	0.2%
15000	17	0.2%
16000	17	0.2%
33000	17	0.2%
11000	17	0.2%
19000	16	0.2%
13143	13	0.1%
Other values (5628)	6661	66.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3162	31.6%
100	1	< 0.1%
250	5	0.1%
259	1	< 0.1%
261	1	< 0.1%
262	1	< 0.1%
267	1	< 0.1%
268	1	< 0.1%
269	1	< 0.1%
297	1	< 0.1%

Value	Count	Frequency (%)
441667	1	< 0.1%
382000	1	< 0.1%
380000	1	< 0.1%
286667	1	< 0.1%
281440	1	< 0.1%
258571	1	< 0.1%
254100	1	< 0.1%
249370	1	< 0.1%
248554	1	< 0.1%
245700	1	< 0.1%

전년가격
Real number (ℝ)

ZEROS

Distinct	5741
Distinct (%)	57.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18885.406

Minimum	0
Maximum	369793
Zeros	2141
Zeros (%)	21.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2076.5
median	12500
Q3	25250
95-th percentile	58015.55
Maximum	369793
Range	369793
Interquartile range (IQR)	23173.5

Descriptive statistics

Standard deviation	25473.687
Coefficient of variation (CV)	1.3488557
Kurtosis	24.9783
Mean	18885.406
Median Absolute Deviation (MAD)	11296.5
Skewness	3.9359753
Sum	1.8885406 × 10⁸
Variance	6.4890873 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2141	21.4%
20000	57	0.6%
16000	44	0.4%
15000	43	0.4%
8500	43	0.4%
10000	41	0.4%
40000	36	0.4%
35000	34	0.3%
22000	34	0.3%
25000	29	0.3%
Other values (5731)	7498	75.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2141	21.4%
350	13	0.1%
376	1	< 0.1%
460	1	< 0.1%
484	1	< 0.1%
551	1	< 0.1%
616	1	< 0.1%
631	1	< 0.1%
653	1	< 0.1%
664	1	< 0.1%

Value	Count	Frequency (%)
369793	1	< 0.1%
276667	1	< 0.1%
273334	2	< 0.1%
264600	1	< 0.1%
260000	1	< 0.1%
251224	1	< 0.1%
243850	1	< 0.1%
243750	1	< 0.1%
243636	1	< 0.1%
241500	1	< 0.1%

전일대비등락율
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4675
Distinct (%)	46.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.080502

Minimum	0
Maximum	1900
Zeros	4473
Zeros (%)	44.7%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	81.408784
Q3	100
95-th percentile	119.6846
Maximum	1900
Range	1900
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	58.037444
Coefficient of variation (CV)	1.0348952
Kurtosis	127.67674
Mean	56.080502
Median Absolute Deviation (MAD)	38.06495
Skewness	4.7820522
Sum	560805.02
Variance	3368.3449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	4473	44.7%
100.0	816	8.2%
105.555555555555	4	< 0.1%
94.4444444444444	4	< 0.1%
75.0	3	< 0.1%
83.3333333333333	3	< 0.1%
95.2380952380952	3	< 0.1%
111.111111111111	3	< 0.1%
95.4545454545454	3	< 0.1%
104.0	2	< 0.1%
Other values (4665)	4686	46.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	4473	44.7%
1.05831304899989	1	< 0.1%
10.0396551724137	1	< 0.1%
21.1819595645412	1	< 0.1%
23.8395560040363	1	< 0.1%
24.6904588492352	1	< 0.1%
26.7642127724432	1	< 0.1%
29.1666666666666	1	< 0.1%
29.5794461720716	1	< 0.1%
31.811371342954	1	< 0.1%

Value	Count	Frequency (%)
1900.0	1	< 0.1%
1303.75093773443	1	< 0.1%
830.578379249234	1	< 0.1%
719.6	1	< 0.1%
637.546468401486	1	< 0.1%
412.080244221543	1	< 0.1%
392.295454545454	1	< 0.1%
373.415045515456	1	< 0.1%
368.170173833485	1	< 0.1%
303.186022610483	1	< 0.1%

검색일전년대비등락율
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4835
Distinct (%)	48.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.033119

Minimum	0
Maximum	1091.6194
Zeros	5017
Zeros (%)	50.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	112.96765
95-th percentile	200.50059
Maximum	1091.6194
Range	1091.6194
Interquartile range (IQR)	112.96765

Descriptive statistics

Standard deviation	79.71992
Coefficient of variation (CV)	1.2449795
Kurtosis	6.2152446
Mean	64.033119
Median Absolute Deviation (MAD)	0
Skewness	1.660733
Sum	640331.19
Variance	6355.2657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	5017	50.2%
100.0	19	0.2%
211.764705882352	8	0.1%
165.466448445171	6	0.1%
195.741176470588	6	0.1%
169.682352941176	6	0.1%
51.0340370529943	5	0.1%
133.333333333333	5	0.1%
105.882352941176	5	0.1%
312.021085111853	5	0.1%
Other values (4825)	4918	49.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	5017	50.2%
2.27634873662645	1	< 0.1%
12.1731289449954	1	< 0.1%
14.0113229828765	1	< 0.1%
17.1844868223698	1	< 0.1%
17.2296015180265	1	< 0.1%
19.1451917033312	1	< 0.1%
19.1711100339311	1	< 0.1%
21.0318489121113	1	< 0.1%
21.4145116405348	1	< 0.1%

Value	Count	Frequency (%)
1091.61942699555	1	< 0.1%
639.82496633968	1	< 0.1%
638.265351461832	1	< 0.1%
625.173726009265	1	< 0.1%
616.964285714285	1	< 0.1%
600.0	1	< 0.1%
557.617817947062	1	< 0.1%
535.172	1	< 0.1%
534.293186355839	1	< 0.1%
532.666666666666	1	< 0.1%

등급.1
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

상	2960
중	2720
하	2587
특	1614
대	75

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	중
2nd row	하
3rd row	상
4th row	특
5th row	중

Common Values

Value	Count	Frequency (%)
상	2960	29.6%
중	2720	27.2%
하	2587	25.9%
특	1614	16.1%
대	75	0.8%
소	44	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
상	2960	29.6%
중	2720	27.2%
하	2587	25.9%
특	1614	16.1%
대	75	0.8%
소	44	0.4%

거래단위
Categorical

HIGH CORRELATION IMBALANCE

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

키로상자	7707
키로	1184
키로망대	349
개	196
키로개	164
Other values (6)	400

Length

Max length	4
Median length	4
Mean length	3.641
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	키로개
2nd row	키로상자
3rd row	키로단
4th row	키로상자
5th row	키로상자

Common Values

Value	Count	Frequency (%)
키로상자	7707	77.1%
키로	1184	11.8%
키로망대	349	3.5%
개	196	2.0%
키로개	164	1.6%
그람단	160	1.6%
키로단	154	1.5%
속	42	0.4%
키로펜	17	0.2%
키로포대	14	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
키로상자	7707	77.1%
키로	1184	11.8%
키로망대	349	3.5%
개	196	2.0%
키로개	164	1.6%
그람단	160	1.6%
키로단	154	1.5%
속	42	0.4%
키로펜	17	0.2%
키로포대	14	0.1%

등급단위
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6905

Minimum	0
Maximum	6
Zeros	1614
Zeros (%)	16.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.1220676
Coefficient of variation (CV)	0.66374894
Kurtosis	-0.097383637
Mean	1.6905
Median Absolute Deviation (MAD)	1
Skewness	0.26456487
Sum	16905
Variance	1.2590357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	2960	29.6%
2	2660	26.6%
3	2587	25.9%
0	1614	16.1%
4	75	0.8%
5	60	0.6%
6	44	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1614	16.1%
1	2960	29.6%
2	2660	26.6%
3	2587	25.9%
4	75	0.8%
5	60	0.6%
6	44	0.4%

Value	Count	Frequency (%)
6	44	0.4%
5	60	0.6%
4	75	0.8%
3	2587	25.9%
2	2660	26.6%
1	2960	29.6%
0	1614	16.1%

중량단위
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0482

Minimum	0
Maximum	88
Zeros	1184
Zeros (%)	11.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	29
Maximum	88
Range	88
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.709698
Coefficient of variation (CV)	3.1395925
Kurtosis	20.144642
Mean	4.0482
Median Absolute Deviation (MAD)	0
Skewness	4.4968411
Sum	40482
Variance	161.53643
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	7707	77.1%
0	1184	11.8%
4	349	3.5%
68	196	2.0%
8	164	1.6%
48	160	1.6%
29	154	1.5%
88	42	0.4%
32	17	0.2%
2	14	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1184	11.8%
1	7707	77.1%
2	14	0.1%
4	349	3.5%
8	164	1.6%
25	13	0.1%
29	154	1.5%
32	17	0.2%
48	160	1.6%
68	196	2.0%

Value	Count	Frequency (%)
88	42	0.4%
68	196	2.0%
48	160	1.6%
32	17	0.2%
29	154	1.5%
25	13	0.1%
8	164	1.6%
4	349	3.5%
2	14	0.1%
1	7707	77.1%

Heatmap
Table

	거래일	시장	품목코드	등급	거래수량	거래단위수량	평균가격	전일평균가격	전년가격	전일대비등락율	검색일전년대비등락율	등급.1	거래단위	등급단위	중량단위
거래일	1.000	0.130	0.076	0.000	0.000	0.000	0.193	0.135	0.147	0.021	0.360	0.000	0.000	0.000	0.000
시장	0.130	1.000	0.529	0.203	0.071	0.572	0.042	0.041	0.138	0.000	0.089	0.203	0.345	0.146	0.184
품목코드	0.076	0.529	1.000	0.495	0.239	0.882	0.212	0.266	0.317	0.093	0.192	0.495	0.543	0.508	0.367
등급	0.000	0.203	0.495	1.000	0.000	0.473	0.150	0.150	0.199	0.089	0.040	1.000	0.316	1.000	0.088
거래수량	0.000	0.071	0.239	0.000	1.000	1.000	0.112	0.082	0.044	0.000	0.000	0.000	0.785	0.000	0.716
거래단위수량	0.000	0.572	0.882	0.473	1.000	1.000	0.548	0.532	0.586	0.000	0.318	0.473	1.000	0.530	1.000
평균가격	0.193	0.042	0.212	0.150	0.112	0.548	1.000	0.776	0.568	0.663	0.316	0.150	0.165	0.143	0.069
전일평균가격	0.135	0.041	0.266	0.150	0.082	0.532	0.776	1.000	0.784	0.000	0.235	0.150	0.144	0.130	0.058
전년가격	0.147	0.138	0.317	0.199	0.044	0.586	0.568	0.784	1.000	0.000	0.002	0.199	0.220	0.172	0.035
전일대비등락율	0.021	0.000	0.093	0.089	0.000	0.000	0.663	0.000	0.000	1.000	0.257	0.089	0.000	0.134	0.000
검색일전년대비등락율	0.360	0.089	0.192	0.040	0.000	0.318	0.316	0.235	0.002	0.257	1.000	0.040	0.135	0.058	0.060
등급.1	0.000	0.203	0.495	1.000	0.000	0.473	0.150	0.150	0.199	0.089	0.040	1.000	0.316	1.000	0.088
거래단위	0.000	0.345	0.543	0.316	0.785	1.000	0.165	0.144	0.220	0.000	0.135	0.316	1.000	0.362	1.000
등급단위	0.000	0.146	0.508	1.000	0.000	0.530	0.143	0.130	0.172	0.134	0.058	1.000	0.362	1.000	0.065
중량단위	0.000	0.184	0.367	0.088	0.716	1.000	0.069	0.058	0.035	0.000	0.060	0.088	1.000	0.065	1.000

Heatmap
Table

	거래단위	등급.1	등급	시장
거래단위	1.000	0.168	0.168	0.215
등급.1	0.168	1.000	1.000	0.086
등급	0.168	1.000	1.000	0.086
시장	0.215	0.086	0.086	1.000

Heatmap
Table

	품목코드	거래수량	평균가격	전일평균가격	전년가격	전일대비등락율	검색일전년대비등락율	등급단위	중량단위	시장	등급	등급.1	거래단위
품목코드	1.000	-0.203	-0.134	-0.121	0.116	-0.131	-0.148	0.020	-0.266	0.273	0.272	0.272	0.281
거래수량	-0.203	1.000	0.163	0.163	0.326	-0.077	-0.026	-0.063	0.265	0.053	0.000	0.000	0.583
평균가격	-0.134	0.163	1.000	0.531	0.119	0.591	0.583	-0.115	-0.016	0.025	0.079	0.079	0.071
전일평균가격	-0.121	0.163	0.531	1.000	0.465	0.541	0.535	-0.113	-0.017	0.018	0.075	0.075	0.065
전년가격	0.116	0.326	0.119	0.465	1.000	0.157	0.289	-0.185	-0.019	0.061	0.100	0.100	0.101
전일대비등락율	-0.131	-0.077	0.591	0.541	0.157	1.000	0.749	0.010	-0.012	0.000	0.053	0.053	0.000
검색일전년대비등락율	-0.148	-0.026	0.583	0.535	0.289	0.749	1.000	0.011	0.022	0.059	0.023	0.023	0.067
등급단위	0.020	-0.063	-0.115	-0.113	-0.185	0.010	0.011	1.000	-0.046	0.098	1.000	1.000	0.188
중량단위	-0.266	0.265	-0.016	-0.017	-0.019	-0.012	0.022	-0.046	1.000	0.077	0.032	0.032	1.000
시장	0.273	0.053	0.025	0.018	0.061	0.000	0.059	0.098	0.077	1.000	0.086	0.086	0.215
등급	0.272	0.000	0.079	0.075	0.100	0.053	0.023	1.000	0.032	0.086	1.000	1.000	0.168
등급.1	0.272	0.000	0.079	0.075	0.100	0.053	0.023	1.000	0.032	0.086	1.000	1.000	0.168
거래단위	0.281	0.583	0.071	0.065	0.101	0.000	0.067	0.188	1.000	0.215	0.168	0.168	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	거래일	시장	품목명	품목코드	등급	거래수량	거래단위수량	평균가격	전일평균가격	전년가격	전일대비등락율	검색일전년대비등락율	등급.1	거래단위	등급단위	중량단위
32824	2024-04-18	가락시장	수박(일반)	22101	중	9.0	9키로개	42050	42050	0	100.0	0.0	중	키로개	2	8
16640	2024-04-29	가락시장	딸기 금실	22612	하	1.0	1키로상자	3048	0	0	0.0	0.0	하	키로상자	3	1
63106	2024-03-29	가락시장	열무	23106	상	1.5	1.5키로단	2534	2522	2523	100.475813	100.435989	상	키로단	1	29
1066	2024-05-10	강서시장(경매)	사과 시나노레드	41134	특	10.0	10키로상자	0	0	20000	0.0	0.0	특	키로상자	0	1
55029	2024-04-04	강서시장(시장도메인)	토마토	22500	중	5.0	5키로상자	28714	28000	16000	102.55	179.4625	중	키로상자	2	1
50390	2024-04-07	강서시장(시장도메인)	열무	23106	하	4.0	4키로상자	0	8500	2539	0.0	0.0	하	키로상자	3	1
58821	2024-04-01	가락시장	브로콜리 국산	25801	하	8.0	8키로상자	19458	0	0	0.0	0.0	하	키로상자	3	1
50195	2024-04-07	강서시장(경매)	치커리(일반)	26820	중	2.0	2키로상자	0	3535	0	0.0	0.0	중	키로상자	2	1
57734	2024-04-02	강서시장(경매)	상추 적포기	21405	상	4.0	4키로상자	9390	8548	18507	109.850257	50.737559	상	키로상자	1	1
58526	2024-04-01	가락시장	부추(일반)	21601	상	500.0	500그람단	2918	0	0	0.0	0.0	상	그람단	1	48

	거래일	시장	품목명	품목코드	등급	거래수량	거래단위수량	평균가격	전일평균가격	전년가격	전일대비등락율	검색일전년대비등락율	등급.1	거래단위	등급단위	중량단위
14018	2024-05-01	가락시장	(선)명태 수입	61251	중	10.0	10키로상자	48778	24519	41667	198.939598	117.066263	중	키로상자	2	1
2685	2024-05-09	강서시장(시장도메인)	양배추	21200	중	8.0	8키로망대	11756	7550	7303	155.708609	160.974942	중	키로망대	2	4
72299	2024-03-23	강서시장(경매)	알배기배추	21111	상	8.0	8키로상자	40000	33703	25692	118.683797	155.690487	상	키로상자	1	1
44239	2024-04-11	강서시장(경매)	양상추 수입	25250	하	8.0	8키로상자	14500	14500	0	100.0	0.0	하	키로상자	3	1
7572	2024-05-05	가락시장	롱그린고추	24209	하	10.0	10키로상자	0	20753	13522	0.0	0.0	하	키로상자	3	1
41306	2024-04-13	강서시장(경매)	감 대봉시	41612	하	15.0	15키로상자	0	0	4150	0.0	0.0	하	키로상자	3	1
23105	2024-04-25	강서시장(경매)	청양고추	24203	특	10.0	10키로상자	52391	58700	137587	89.252129	38.078452	특	키로상자	0	1
73037	2024-03-23	강서시장(시장도메인)	골드파인애플 수입	42751	중	12.0	12키로상자	21500	20253	28000	106.157113	76.785714	중	키로상자	2	1
2666	2024-05-09	강서시장(시장도메인)	감자	15200	하	20.0	20키로상자	51554	6207	46690	830.578379	110.417648	하	키로상자	3	1
45737	2024-04-10	강서시장(경매)	가지	22800	중	8.0	8키로상자	0	0	24788	0.0	0.0	중	키로상자	2	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Uppercase Letter

Space Separator

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample