Data Analysis Report

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	8893
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.8 MiB
Average record size in memory	447.3 B

Variable types

Categorical	5
Numeric	8
Text	1
DateTime	1
Unsupported	1

Alerts

`Sales` is highly overall correlated with `price_per_kg` and 2 other fields	High correlation
`category` is highly overall correlated with `price_per_kg` and 3 other fields	High correlation
`demand_gap` is highly overall correlated with `sales_to_shipment_ratio` and 2 other fields	High correlation
`price_per_kg` is highly overall correlated with `Sales` and 3 other fields	High correlation
`product_id` is highly overall correlated with `category` and 2 other fields	High correlation
`product_name` is highly overall correlated with `category` and 2 other fields	High correlation
`sales_to_shipment_ratio` is highly overall correlated with `Sales` and 3 other fields	High correlation
`supplier` is highly overall correlated with `category`	High correlation
`units_on_hand_kg` is highly overall correlated with `demand_gap` and 2 other fields	High correlation
`units_shipped_kg` is highly overall correlated with `demand_gap` and 2 other fields	High correlation
`units_sold_kg` is highly overall correlated with `Sales` and 2 other fields	High correlation
`month` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2025-09-20 18:26:42.448604
Analysis finished	2025-09-20 18:26:51.678823
Duration	9.23 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

product_id
Categorical

High correlation

Distinct	28
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	807.8 KiB

57ad2178-9598-4981-b0f7-78a91162821e	464
6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	454
9bb2d8db-a7ac-4d40-9d3c-0c96cafe7153	447
7ba3ccef-363a-40c5-9bbd-a451068846c5	446
0985f295-bb82-484f-9cab-76637e8e8bdb	443
Other values (23)	6639

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	320148
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	b12c721e-8301-4b08-8ac3-d435be9b8b32
2nd row	4a0f8862-c851-4073-bc17-3a3d93834902
3rd row	be996df6-1780-4352-8b7d-1f927279aa49
4th row	6c8adfc3-2114-4b78-a3e2-2269a6a0dc02
5th row	0bd5bf2b-be0a-4ba0-aa92-059021b169e3

Common Values

Value	Count	Frequency (%)
57ad2178-9598-4981-b0f7-78a91162821e	464	5.2%
6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	454	5.1%
9bb2d8db-a7ac-4d40-9d3c-0c96cafe7153	447	5.0%
7ba3ccef-363a-40c5-9bbd-a451068846c5	446	5.0%
0985f295-bb82-484f-9cab-76637e8e8bdb	443	5.0%
b12c721e-8301-4b08-8ac3-d435be9b8b32	442	5.0%
4a0f8862-c851-4073-bc17-3a3d93834902	434	4.9%
3b87981b-375b-494a-9b11-00bf7144143a	426	4.8%
f0fa3446-1398-417a-bda7-de131121a15b	307	3.5%
28f45387-03b8-48f9-b67c-d921d29f60b6	296	3.3%
Other values (18)	4734	53.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
57ad2178-9598-4981-b0f7-78a91162821e	464	5.2%
6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	454	5.1%
9bb2d8db-a7ac-4d40-9d3c-0c96cafe7153	447	5.0%
7ba3ccef-363a-40c5-9bbd-a451068846c5	446	5.0%
0985f295-bb82-484f-9cab-76637e8e8bdb	443	5.0%
b12c721e-8301-4b08-8ac3-d435be9b8b32	442	5.0%
4a0f8862-c851-4073-bc17-3a3d93834902	434	4.9%
3b87981b-375b-494a-9b11-00bf7144143a	426	4.8%
f0fa3446-1398-417a-bda7-de131121a15b	307	3.5%
28f45387-03b8-48f9-b67c-d921d29f60b6	296	3.3%
Other values (18)	4734	53.2%

Most occurring characters

Value	Count	Frequency (%)
-	35572	11.1%
b	24196	7.6%
4	22186	6.9%
8	22175	6.9%
9	21058	6.6%
a	20580	6.4%
1	19901	6.2%
3	19757	6.2%
0	18039	5.6%
c	16677	5.2%
Other values (7)	100007	31.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	320148	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	35572	11.1%
b	24196	7.6%
4	22186	6.9%
8	22175	6.9%
9	21058	6.6%
a	20580	6.4%
1	19901	6.2%
3	19757	6.2%
0	18039	5.6%
c	16677	5.2%
Other values (7)	100007	31.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	320148	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	35572	11.1%
b	24196	7.6%
4	22186	6.9%
8	22175	6.9%
9	21058	6.6%
a	20580	6.4%
1	19901	6.2%
3	19757	6.2%
0	18039	5.6%
c	16677	5.2%
Other values (7)	100007	31.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	320148	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	35572	11.1%
b	24196	7.6%
4	22186	6.9%
8	22175	6.9%
9	21058	6.6%
a	20580	6.4%
1	19901	6.2%
3	19757	6.2%
0	18039	5.6%
c	16677	5.2%
Other values (7)	100007	31.2%

product_name
Categorical

High correlation

Distinct	28
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	547.2 KiB

Cheese	464
Milk	454
Butter	447
Yogurt	446
Chicken	443
Other values (23)	6639

Length

Max length	12
Median length	11
Mean length	5.991454
Min length	3

Characters and Unicode

Total characters	53282
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Lamb
2nd row	Beef
3rd row	Oranges
4th row	Milk
5th row	Bananas

Common Values

Value	Count	Frequency (%)
Cheese	464	5.2%
Milk	454	5.1%
Butter	447	5.0%
Yogurt	446	5.0%
Chicken	443	5.0%
Lamb	442	5.0%
Beef	434	4.9%
Pork	426	4.8%
Oats	307	3.5%
Corn	296	3.3%
Other values (18)	4734	53.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cheese	464	5.2%
milk	454	5.1%
butter	447	5.0%
yogurt	446	5.0%
chicken	443	5.0%
lamb	442	5.0%
beef	434	4.9%
pork	426	4.8%
oats	307	3.5%
corn	296	3.3%
Other values (18)	4734	53.2%

Most occurring characters

Value	Count	Frequency (%)
e	8836	16.6%
r	4490	8.4%
a	4340	8.1%
s	3857	7.2%
t	3743	7.0%
o	2672	5.0%
i	1973	3.7%
n	1939	3.6%
B	1696	3.2%
C	1674	3.1%
Other values (23)	18062	33.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	53282	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8836	16.6%
r	4490	8.4%
a	4340	8.1%
s	3857	7.2%
t	3743	7.0%
o	2672	5.0%
i	1973	3.7%
n	1939	3.6%
B	1696	3.2%
C	1674	3.1%
Other values (23)	18062	33.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	53282	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8836	16.6%
r	4490	8.4%
a	4340	8.1%
s	3857	7.2%
t	3743	7.0%
o	2672	5.0%
i	1973	3.7%
n	1939	3.6%
B	1696	3.2%
C	1674	3.1%
Other values (23)	18062	33.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	53282	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8836	16.6%
r	4490	8.4%
a	4340	8.1%
s	3857	7.2%
t	3743	7.0%
o	2672	5.0%
i	1973	3.7%
n	1939	3.6%
B	1696	3.2%
C	1674	3.1%
Other values (23)	18062	33.9%

category
Categorical

High correlation

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	557.5 KiB

Fruits	1846
Dairy	1811
Vegetables	1765
Livestock	1745
Grains	1726

Length

Max length	10
Median length	9
Mean length	7.1789048
Min length	5

Characters and Unicode

Total characters	63842
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Livestock
2nd row	Livestock
3rd row	Fruits
4th row	Dairy
5th row	Fruits

Common Values

Value	Count	Frequency (%)
Fruits	1846	20.8%
Dairy	1811	20.4%
Vegetables	1765	19.8%
Livestock	1745	19.6%
Grains	1726	19.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fruits	1846	20.8%
dairy	1811	20.4%
vegetables	1765	19.8%
livestock	1745	19.6%
grains	1726	19.4%

Most occurring characters

Value	Count	Frequency (%)
i	7128	11.2%
s	7082	11.1%
e	7040	11.0%
r	5383	8.4%
t	5356	8.4%
a	5302	8.3%
F	1846	2.9%
u	1846	2.9%
D	1811	2.8%
y	1811	2.8%
Other values (11)	19237	30.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	63842	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	7128	11.2%
s	7082	11.1%
e	7040	11.0%
r	5383	8.4%
t	5356	8.4%
a	5302	8.3%
F	1846	2.9%
u	1846	2.9%
D	1811	2.8%
y	1811	2.8%
Other values (11)	19237	30.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	63842	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	7128	11.2%
s	7082	11.1%
e	7040	11.0%
r	5383	8.4%
t	5356	8.4%
a	5302	8.3%
F	1846	2.9%
u	1846	2.9%
D	1811	2.8%
y	1811	2.8%
Other values (11)	19237	30.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	63842	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	7128	11.2%
s	7082	11.1%
e	7040	11.0%
r	5383	8.4%
t	5356	8.4%
a	5302	8.3%
F	1846	2.9%
u	1846	2.9%
D	1811	2.8%
y	1811	2.8%
Other values (11)	19237	30.1%

price_per_kg
Real number (ℝ)

High correlation

Distinct	1256
Distinct (%)	14.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6414776

Minimum	0.4
Maximum	14.39
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0.4
5-th percentile	0.59
Q1	0.97
median	2.68
Q3	5.3
95-th percentile	10.9
Maximum	14.39
Range	13.99
Interquartile range (IQR)	4.33

Descriptive statistics

Standard deviation	3.3063484
Coefficient of variation (CV)	0.90796891
Kurtosis	0.67029165
Mean	3.6414776
Median Absolute Deviation (MAD)	1.8
Skewness	1.229211
Sum	32383.66
Variance	10.93194
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.75	64	0.7%
0.84	64	0.7%
0.86	61	0.7%
0.82	61	0.7%
0.77	60	0.7%
0.83	58	0.7%
0.88	56	0.6%
0.69	55	0.6%
0.92	54	0.6%
0.8	53	0.6%
Other values (1246)	8307	93.4%

Value	Count	Frequency (%)
0.4	11	0.1%
0.41	10	0.1%
0.42	19	0.2%
0.43	11	0.1%
0.44	18	0.2%
0.45	23	0.3%
0.46	19	0.2%
0.47	14	0.2%
0.48	21	0.2%
0.49	25	0.3%

Value	Count	Frequency (%)
14.39	2	< 0.1%
14.38	3	< 0.1%
14.37	1	< 0.1%
14.36	3	< 0.1%
14.35	1	< 0.1%
14.34	1	< 0.1%
14.32	2	< 0.1%
14.3	1	< 0.1%
14.29	2	< 0.1%
14.26	1	< 0.1%

units_shipped_kg
Real number (ℝ)

High correlation

Distinct	8143
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25471.786

Minimum	1005
Maximum	50000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	1005
5-th percentile	3349.2
Q1	13228
median	25468
Q3	37964
95-th percentile	47457.4
Maximum	50000
Range	48995
Interquartile range (IQR)	24736

Descriptive statistics

Standard deviation	14177.334
Coefficient of variation (CV)	0.55658973
Kurtosis	-1.2120234
Mean	25471.786
Median Absolute Deviation (MAD)	12361
Skewness	0.0033572976
Sum	2.2652059 × 10⁸
Variance	2.0099681 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26667	4	< 0.1%
35708	4	< 0.1%
1551	4	< 0.1%
23719	3	< 0.1%
10942	3	< 0.1%
9828	3	< 0.1%
6983	3	< 0.1%
1523	3	< 0.1%
10828	3	< 0.1%
48130	3	< 0.1%
Other values (8133)	8860	99.6%

Value	Count	Frequency (%)
1005	1	< 0.1%
1008	1	< 0.1%
1009	1	< 0.1%
1013	1	< 0.1%
1015	1	< 0.1%
1017	1	< 0.1%
1028	1	< 0.1%
1050	1	< 0.1%
1052	1	< 0.1%
1061	1	< 0.1%

Value	Count	Frequency (%)
50000	1	< 0.1%
49987	1	< 0.1%
49979	1	< 0.1%
49976	1	< 0.1%
49959	1	< 0.1%
49957	1	< 0.1%
49953	1	< 0.1%
49952	2	< 0.1%
49950	1	< 0.1%
49936	1	< 0.1%

units_sold_kg
Real number (ℝ)

High correlation

Distinct	7630
Distinct (%)	85.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12545.278

Minimum	0
Maximum	49726
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0
5-th percentile	634.2
Q1	3642
median	9643
Q3	18832
95-th percentile	34673.4
Maximum	49726
Range	49726
Interquartile range (IQR)	15190

Descriptive statistics

Standard deviation	10772.529
Coefficient of variation (CV)	0.85869191
Kurtosis	0.24092725
Mean	12545.278
Median Absolute Deviation (MAD)	6872
Skewness	0.9846334
Sum	1.1156516 × 10⁸
Variance	1.1604738 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1232	6	0.1%
5248	5	0.1%
585	5	0.1%
1641	4	< 0.1%
979	4	< 0.1%
3525	4	< 0.1%
2990	4	< 0.1%
938	4	< 0.1%
438	4	< 0.1%
1196	4	< 0.1%
Other values (7620)	8849	99.5%

Value	Count	Frequency (%)
0	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
11	2	< 0.1%
13	1	< 0.1%
17	2	< 0.1%
18	1	< 0.1%
21	2	< 0.1%

Value	Count	Frequency (%)
49726	1	< 0.1%
48817	1	< 0.1%
48618	1	< 0.1%
48267	1	< 0.1%
48263	1	< 0.1%
48124	1	< 0.1%
47949	1	< 0.1%
47392	1	< 0.1%
47346	1	< 0.1%
47328	1	< 0.1%

units_on_hand_kg
Real number (ℝ)

High correlation

Distinct	7632
Distinct (%)	85.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12926.507

Minimum	0
Maximum	49818
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0
5-th percentile	649.6
Q1	3890
median	9805
Q3	19622
95-th percentile	35070
Maximum	49818
Range	49818
Interquartile range (IQR)	15732

Descriptive statistics

Standard deviation	10996.125
Coefficient of variation (CV)	0.85066482
Kurtosis	0.037624223
Mean	12926.507
Median Absolute Deviation (MAD)	7077
Skewness	0.92809867
Sum	1.1495543 × 10⁸
Variance	1.2091476 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
935	5	0.1%
661	5	0.1%
8589	4	< 0.1%
2290	4	< 0.1%
502	4	< 0.1%
1087	4	< 0.1%
9905	4	< 0.1%
2452	4	< 0.1%
1206	4	< 0.1%
3348	4	< 0.1%
Other values (7622)	8851	99.5%

Value	Count	Frequency (%)
0	2	< 0.1%
3	3	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	2	< 0.1%
15	1	< 0.1%

Value	Count	Frequency (%)
49818	1	< 0.1%
48668	1	< 0.1%
48401	1	< 0.1%
48351	1	< 0.1%
48339	1	< 0.1%
48169	1	< 0.1%
48101	1	< 0.1%
48035	1	< 0.1%
47929	1	< 0.1%
47896	1	< 0.1%

supplier
Categorical

High correlation

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	647.2 KiB

Citrus World Inc.	492
Dairyland Co-op	483
Orchard Lane Farms	464
Fresh Dairy Farms	462
Organic Meats Co.	454
Other values (15)	6538

Length

Max length	26
Median length	21
Mean length	17.510064
Min length	12

Characters and Unicode

Total characters	155717
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Organic Meats Co.
2nd row	Organic Meats Co.
3rd row	Berry Fields
4th row	Fresh Dairy Farms
5th row	Golden Orchards

Common Values

Value	Count	Frequency (%)
Citrus World Inc.	492	5.5%
Dairyland Co-op	483	5.4%
Orchard Lane Farms	464	5.2%
Fresh Dairy Farms	462	5.2%
Organic Meats Co.	454	5.1%
Midwest Grains Co.	453	5.1%
Fresh Harvest Co.	449	5.0%
Golden Orchards	446	5.0%
Nature's Best Produce	446	5.0%
Ranchers Pride	445	5.0%
Other values (10)	4299	48.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
co	1356	5.7%
farms	1355	5.6%
fresh	1335	5.6%
meats	1300	5.4%
organic	1299	5.4%
dairy	906	3.8%
harvest	875	3.6%
golden	872	3.6%
agriculture	867	3.6%
valley	851	3.5%
Other values (28)	12982	54.1%

Most occurring characters

Value	Count	Frequency (%)
r	17325	11.1%
	15105	9.7%
e	13124	8.4%
a	11985	7.7%
s	9799	6.3%
i	8399	5.4%
n	7497	4.8%
o	5847	3.8%
t	5726	3.7%
l	5706	3.7%
Other values (31)	55204	35.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	155717	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	17325	11.1%
	15105	9.7%
e	13124	8.4%
a	11985	7.7%
s	9799	6.3%
i	8399	5.4%
n	7497	4.8%
o	5847	3.8%
t	5726	3.7%
l	5706	3.7%
Other values (31)	55204	35.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	155717	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	17325	11.1%
	15105	9.7%
e	13124	8.4%
a	11985	7.7%
s	9799	6.3%
i	8399	5.4%
n	7497	4.8%
o	5847	3.8%
t	5726	3.7%
l	5706	3.7%
Other values (31)	55204	35.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	155717	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	17325	11.1%
	15105	9.7%
e	13124	8.4%
a	11985	7.7%
s	9799	6.3%
i	8399	5.4%
n	7497	4.8%
o	5847	3.8%
t	5726	3.7%
l	5706	3.7%
Other values (31)	55204	35.5%

farm_location
Text

Distinct	8862
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Memory size	630.5 KiB

Length

Max length	31
Median length	26
Mean length	15.580457
Min length	8

Characters and Unicode

Total characters	138557
Distinct characters	60
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	8831 ?
Unique (%)	99.3%

Sample

1st row	O'Reillyboro, OR
2nd row	Lake Nora, AR
3rd row	East Friedaside, NM
4th row	East Javon, FL
5th row	Lake D'angelo, MN

Value	Count	Frequency (%)
lake	506	2.3%
south	494	2.2%
fort	468	2.1%
east	460	2.1%
west	450	2.0%
new	439	2.0%
north	439	2.0%
port	409	1.9%
nh	206	0.9%
sc	203	0.9%
Other values (7259)	17882	81.4%

Most occurring characters

Value	Count	Frequency (%)
	13063	9.4%
e	10630	7.7%
,	8893	6.4%
a	8129	5.9%
r	8077	5.8%
t	7640	5.5%
o	7518	5.4%
n	5731	4.1%
i	5412	3.9%
l	4819	3.5%
Other values (50)	58645	42.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	138557	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	13063	9.4%
e	10630	7.7%
,	8893	6.4%
a	8129	5.9%
r	8077	5.8%
t	7640	5.5%
o	7518	5.4%
n	5731	4.1%
i	5412	3.9%
l	4819	3.5%
Other values (50)	58645	42.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	138557	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	13063	9.4%
e	10630	7.7%
,	8893	6.4%
a	8129	5.9%
r	8077	5.8%
t	7640	5.5%
o	7518	5.4%
n	5731	4.1%
i	5412	3.9%
l	4819	3.5%
Other values (50)	58645	42.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	138557	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	13063	9.4%
e	10630	7.7%
,	8893	6.4%
a	8129	5.9%
r	8077	5.8%
t	7640	5.5%
o	7518	5.4%
n	5731	4.1%
i	5412	3.9%
l	4819	3.5%
Other values (50)	58645	42.3%

sale_date
Date

Distinct	730
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Memory size	69.6 KiB

Minimum	2022-01-01 00:00:00
Maximum	2023-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Year
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	529.9 KiB

2022	4454
2023	4439

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	35572
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2022
2nd row	2023
3rd row	2023
4th row	2023
5th row	2023

Common Values

Value	Count	Frequency (%)
2022	4454	50.1%
2023	4439	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022	4454	50.1%
2023	4439	49.9%

Most occurring characters

Value	Count	Frequency (%)
2	22240	62.5%
0	8893	25.0%
3	4439	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	35572	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	22240	62.5%
0	8893	25.0%
3	4439	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	35572	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	22240	62.5%
0	8893	25.0%
3	4439	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	35572	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	22240	62.5%
0	8893	25.0%
3	4439	12.5%

month
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	69.6 KiB

day
Real number (ℝ)

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.643765

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	34.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29.4
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7531207
Coefficient of variation (CV)	0.55952776
Kurtosis	-1.1760833
Mean	15.643765
Median Absolute Deviation (MAD)	8
Skewness	0.020528964
Sum	139120
Variance	76.617122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
20	338	3.8%
17	322	3.6%
13	321	3.6%
6	315	3.5%
21	307	3.5%
7	307	3.5%
19	304	3.4%
15	303	3.4%
10	303	3.4%
5	299	3.4%
Other values (21)	5774	64.9%

Value	Count	Frequency (%)
1	292	3.3%
2	283	3.2%
3	287	3.2%
4	291	3.3%
5	299	3.4%
6	315	3.5%
7	307	3.5%
8	295	3.3%
9	280	3.1%
10	303	3.4%

Value	Count	Frequency (%)
31	178	2.0%
30	267	3.0%
29	273	3.1%
28	258	2.9%
27	261	2.9%
26	295	3.3%
25	286	3.2%
24	273	3.1%
23	296	3.3%
22	279	3.1%

Sales
Real number (ℝ)

High correlation

Distinct	8873
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46506.475

Minimum	0
Maximum	624033.78
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0
5-th percentile	956.032
Q1	6682.32
median	19691.14
Q3	54909.18
95-th percentile	186860.5
Maximum	624033.78
Range	624033.78
Interquartile range (IQR)	48226.86

Descriptive statistics

Standard deviation	69996.142
Coefficient of variation (CV)	1.5050838
Kurtosis	11.780069
Mean	46506.475
Median Absolute Deviation (MAD)	16212.4
Skewness	3.0409936
Sum	4.1358208 × 10⁸
Variance	4.8994599 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45360	2	< 0.1%
1929.84	2	< 0.1%
28.38	2	< 0.1%
2187.84	2	< 0.1%
2288.5	2	< 0.1%
1673.28	2	< 0.1%
2610.27	2	< 0.1%
2252.88	2	< 0.1%
2367.42	2	< 0.1%
1082.52	2	< 0.1%
Other values (8863)	8873	99.8%

Value	Count	Frequency (%)
0	1	< 0.1%
13.42	1	< 0.1%
15.48	1	< 0.1%
15.98	1	< 0.1%
18.56	1	< 0.1%
24.38	1	< 0.1%
26.28	1	< 0.1%
27.6	1	< 0.1%
28.38	2	< 0.1%
29.25	1	< 0.1%

Value	Count	Frequency (%)
624033.78	1	< 0.1%
617437.3	1	< 0.1%
609006.72	1	< 0.1%
575388	1	< 0.1%
548701.62	1	< 0.1%
525627.69	1	< 0.1%
521278.18	1	< 0.1%
513912	1	< 0.1%
512689.04	1	< 0.1%
505744.84	1	< 0.1%

sales_to_shipment_ratio
Real number (ℝ)

High correlation

Distinct	8891
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.49418005

Minimum	0
Maximum	1
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0.053968688
Q1	0.24922242
median	0.48809936
Q3	0.73995272
95-th percentile	0.94727438
Maximum	1
Range	1
Interquartile range (IQR)	0.4907303

Descriptive statistics

Standard deviation	0.28555068
Coefficient of variation (CV)	0.57782722
Kurtosis	-1.1884831
Mean	0.49418005
Median Absolute Deviation (MAD)	0.24560505
Skewness	0.03462041
Sum	4394.7432
Variance	0.081539193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2	< 0.1%
0.1839622642	2	< 0.1%
0.5254707132	1	< 0.1%
0.7419945879	1	< 0.1%
0.3850308642	1	< 0.1%
0.53329791	1	< 0.1%
0.7067765709	1	< 0.1%
0.4061856158	1	< 0.1%
0.03084688727	1	< 0.1%
0.9555860806	1	< 0.1%
Other values (8881)	8881	99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
0.0007499062617	1	< 0.1%
0.0009411272613	1	< 0.1%
0.001047394606	1	< 0.1%
0.001208702659	1	< 0.1%
0.001333218648	1	< 0.1%
0.001363255034	1	< 0.1%
0.001387390165	1	< 0.1%
0.001419686317	1	< 0.1%
0.001696065129	1	< 0.1%

Value	Count	Frequency (%)
1	2	< 0.1%
0.9999239968	1	< 0.1%
0.9998210664	1	< 0.1%
0.9997298132	1	< 0.1%
0.9995487365	1	< 0.1%
0.9994681558	1	< 0.1%
0.9991992932	1	< 0.1%
0.9990557377	1	< 0.1%
0.9990482234	1	< 0.1%
0.9990364099	1	< 0.1%

demand_gap
Real number (ℝ)

High correlation

Distinct	7632
Distinct (%)	85.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12926.507

Minimum	0
Maximum	49818
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	69.6 KiB

Quantile statistics

Minimum	0
5-th percentile	649.6
Q1	3890
median	9805
Q3	19622
95-th percentile	35070
Maximum	49818
Range	49818
Interquartile range (IQR)	15732

Descriptive statistics

Standard deviation	10996.125
Coefficient of variation (CV)	0.85066482
Kurtosis	0.037624223
Mean	12926.507
Median Absolute Deviation (MAD)	7077
Skewness	0.92809867
Sum	1.1495543 × 10⁸
Variance	1.2091476 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
935	5	0.1%
661	5	0.1%
8589	4	< 0.1%
2290	4	< 0.1%
502	4	< 0.1%
1087	4	< 0.1%
9905	4	< 0.1%
2452	4	< 0.1%
1206	4	< 0.1%
3348	4	< 0.1%
Other values (7622)	8851	99.5%

Value	Count	Frequency (%)
0	2	< 0.1%
3	3	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
14	2	< 0.1%
15	1	< 0.1%

Value	Count	Frequency (%)
49818	1	< 0.1%
48668	1	< 0.1%
48401	1	< 0.1%
48351	1	< 0.1%
48339	1	< 0.1%
48169	1	< 0.1%
48101	1	< 0.1%
48035	1	< 0.1%
47929	1	< 0.1%
47896	1	< 0.1%

	Sales	Year	category	day	demand_gap	price_per_kg	product_id	product_name	sales_to_shipment_ratio	supplier	units_on_hand_kg	units_shipped_kg	units_sold_kg
Sales	1.000	0.000	0.247	0.004	0.006	0.644	0.224	0.224	0.514	0.164	0.006	0.475	0.743
Year	0.000	1.000	0.010	0.008	0.012	0.025	0.056	0.056	0.005	0.005	0.012	0.017	0.000
category	0.247	0.010	1.000	0.021	0.012	0.517	0.999	0.999	0.000	0.999	0.012	0.000	0.022
day	0.004	0.008	0.021	1.000	-0.001	0.013	0.016	0.016	-0.006	0.015	-0.001	-0.001	-0.004
demand_gap	0.006	0.012	0.012	-0.001	1.000	-0.005	0.006	0.006	-0.677	0.000	1.000	0.668	-0.015
price_per_kg	0.644	0.025	0.517	0.013	-0.005	1.000	0.647	0.647	0.020	0.344	-0.005	0.012	0.019
product_id	0.224	0.056	0.999	0.016	0.006	0.647	1.000	1.000	0.000	0.457	0.006	0.000	0.022
product_name	0.224	0.056	0.999	0.016	0.006	0.647	1.000	1.000	0.000	0.457	0.006	0.000	0.022
sales_to_shipment_ratio	0.514	0.005	0.000	-0.006	-0.677	0.020	0.000	0.000	1.000	0.012	-0.677	-0.010	0.682
supplier	0.164	0.005	0.999	0.015	0.000	0.344	0.457	0.457	0.012	1.000	0.000	0.015	0.000
units_on_hand_kg	0.006	0.012	0.012	-0.001	1.000	-0.005	0.006	0.006	-0.677	0.000	1.000	0.668	-0.015
units_shipped_kg	0.475	0.017	0.000	-0.001	0.668	0.012	0.000	0.000	-0.010	0.015	0.668	1.000	0.649
units_sold_kg	0.743	0.000	0.022	-0.004	-0.015	0.019	0.022	0.022	0.682	0.000	-0.015	0.649	1.000

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.

	product_id	product_name	category	price_per_kg	units_shipped_kg	units_sold_kg	units_on_hand_kg	supplier	farm_location	sale_date	Year	month	day	Sales	sales_to_shipment_ratio	demand_gap
0	b12c721e-8301-4b08-8ac3-d435be9b8b32	Lamb	Livestock	14.10	19224.0	14905.0	4319.0	Organic Meats Co.	O'Reillyboro, OR	2022-07-04	2022	2022-07	4	210160.50	0.775333	4319
1	4a0f8862-c851-4073-bc17-3a3d93834902	Beef	Livestock	11.37	29504.0	4550.0	24954.0	Organic Meats Co.	Lake Nora, AR	2023-10-21	2023	2023-10	21	51733.50	0.154216	24954
2	be996df6-1780-4352-8b7d-1f927279aa49	Oranges	Fruits	2.59	1838.0	1722.0	116.0	Berry Fields	East Friedaside, NM	2023-12-24	2023	2023-12	24	4459.98	0.936888	116
3	6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	Milk	Dairy	1.34	6750.0	1232.0	5518.0	Fresh Dairy Farms	East Javon, FL	2023-12-25	2023	2023-12	25	1650.88	0.182519	5518
4	0bd5bf2b-be0a-4ba0-aa92-059021b169e3	Bananas	Fruits	1.78	48729.0	47020.0	1709.0	Golden Orchards	Lake D'angelo, MN	2023-06-20	2023	2023-06	20	83695.60	0.964928	1709
5	1c48eb53-85bc-4b76-92ef-97d240a8a227	Potatoes	Vegetables	0.92	22600.0	11477.0	11123.0	Nature's Best Produce	Danielville, FL	2023-01-22	2023	2023-01	22	10558.84	0.507832	11123
6	1c48eb53-85bc-4b76-92ef-97d240a8a227	Potatoes	Vegetables	0.86	14543.0	5208.0	9335.0	Fresh Harvest Co.	Bridgettown, IA	2023-09-06	2023	2023-09	6	4478.88	0.358110	9335
7	3b87981b-375b-494a-9b11-00bf7144143a	Pork	Livestock	7.08	8442.0	7570.0	872.0	Ranchers Pride	Shainafurt, PA	2022-11-14	2022	2022-11	14	53595.60	0.896707	872
8	921530a1-c4d1-4e94-b8ad-11f6fbcc4fca	Rice	Grains	0.99	23374.0	7546.0	15828.0	Midwest Grains Co.	New Bruceton, AL	2023-12-12	2023	2023-12	12	7470.54	0.322837	15828
9	6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	Milk	Dairy	1.09	41999.0	36611.0	5388.0	Happy Cows Dairy	Effertzchester, CO	2022-01-02	2022	2022-01	2	39905.99	0.871711	5388

	product_id	product_name	category	price_per_kg	units_shipped_kg	units_sold_kg	units_on_hand_kg	supplier	farm_location	sale_date	Year	month	day	Sales	sales_to_shipment_ratio	demand_gap
8883	9bb2d8db-a7ac-4d40-9d3c-0c96cafe7153	Butter	Dairy	4.76	39681.0	31413.0	8268.0	Organic Valley	New Kailynville, WY	2023-05-02	2023	2023-05	2	149525.88	0.791638	8268
8884	c0e9f888-f1d2-4b5b-a6e9-3c349f68aed0	Barley	Grains	0.80	11179.0	7739.0	3440.0	Farmers Grain Union	Borerworth, WA	2022-08-23	2022	2022-08	23	6191.20	0.692280	3440
8885	403d5331-41ba-4a1a-86d2-e1599b965c1b	Strawberries	Fruits	5.95	37915.0	2729.0	35186.0	Golden Orchards	Predovicstad, AZ	2022-08-17	2022	2022-08	17	16237.55	0.071977	35186
8886	1c48eb53-85bc-4b76-92ef-97d240a8a227	Potatoes	Vegetables	0.72	49145.0	2636.0	46509.0	Nature's Best Produce	Reillyboro, OR	2022-06-02	2022	2022-06	2	1897.92	0.053637	46509
8887	9bb2d8db-a7ac-4d40-9d3c-0c96cafe7153	Butter	Dairy	5.07	20572.0	2561.0	18011.0	Organic Valley	Guaynabo, DE	2022-01-04	2022	2022-01	4	12984.27	0.124490	18011
8888	c81f400e-c19f-417f-99fb-039a19506e85	Onions	Vegetables	0.85	10543.0	1330.0	9213.0	Fresh Harvest Co.	Elyria, MS	2022-12-30	2022	2022-12	30	1130.50	0.126150	9213
8889	6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	Milk	Dairy	1.36	28336.0	18644.0	9692.0	Organic Valley	Santa Cruz, ND	2023-07-20	2023	2023-07	20	25355.84	0.657962	9692
8890	6c8adfc3-2114-4b78-a3e2-2269a6a0dc02	Milk	Dairy	1.20	34945.0	6793.0	28152.0	Organic Valley	Cleveland, MN	2022-05-23	2022	2022-05	23	8151.60	0.194391	28152
8891	857e56ee-a962-479e-99f0-983999e858bd	Cabbage	Vegetables	0.75	26470.0	12316.0	14154.0	Nature's Best Produce	Waelchiberg, MN	2023-01-06	2023	2023-01	6	9237.00	0.465281	14154
8892	0985f295-bb82-484f-9cab-76637e8e8bdb	Chicken	Livestock	3.42	27434.0	10750.0	16684.0	Country Fresh Meats	Southfield, CT	2022-06-26	2022	2022-06	26	36765.00	0.391850	16684

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample