Overview

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	9994
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.2 MiB
Average record size in memory	969.2 B

Variable types

Numeric	6
Text	6
DateTime	2
Categorical	7

Alerts

`Country` has constant value "United States"	Constant
`Category` is highly overall correlated with `Sub-Category`	High correlation
`Discount` is highly overall correlated with `Profit`	High correlation
`Postal Code` is highly overall correlated with `Region` and 1 other fields	High correlation
`Profit` is highly overall correlated with `Discount` and 1 other fields	High correlation
`Region` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sales` is highly overall correlated with `Profit`	High correlation
`State` is highly overall correlated with `Postal Code` and 1 other fields	High correlation
`Sub-Category` is highly overall correlated with `Category`	High correlation
`Row ID` is uniformly distributed	Uniform
`Row ID` has unique values	Unique
`Discount` has 4798 (48.0%) zeros	Zeros

Reproduction

Analysis started	2025-09-16 16:38:18.546513
Analysis finished	2025-09-16 16:38:24.472905
Duration	5.93 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Row ID
Real number (ℝ)

Uniform Unique

Distinct	9994
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4997.5

Minimum	1
Maximum	9994
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	500.65
Q1	2499.25
median	4997.5
Q3	7495.75
95-th percentile	9494.35
Maximum	9994
Range	9993
Interquartile range (IQR)	4996.5

Descriptive statistics

Standard deviation	2885.1636
Coefficient of variation (CV)	0.57732139
Kurtosis	-1.2
Mean	4997.5
Median Absolute Deviation (MAD)	2498.5
Skewness	0
Sum	49945015
Variance	8324169.2
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9994	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
Other values (9984)	9984	99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
9994	1	< 0.1%
9993	1	< 0.1%
9992	1	< 0.1%
9991	1	< 0.1%
9990	1	< 0.1%
9989	1	< 0.1%
9988	1	< 0.1%
9987	1	< 0.1%
9986	1	< 0.1%
9985	1	< 0.1%

Order ID
Text

Distinct	5009
Distinct (%)	50.1%
Missing	0
Missing (%)	0.0%
Memory size	615.0 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	139916
Distinct characters	15
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	2538 ?
Unique (%)	25.4%

Sample

1st row	CA-2013-152156
2nd row	CA-2013-152156
3rd row	CA-2013-138688
4th row	US-2012-108966
5th row	US-2012-108966

Value	Count	Frequency (%)
ca-2014-100111	14	0.1%
ca-2014-157987	12	0.1%
us-2013-108504	11	0.1%
ca-2013-165330	11	0.1%
us-2012-126977	10	0.1%
ca-2013-105732	10	0.1%
ca-2012-131338	10	0.1%
ca-2012-158421	9	0.1%
ca-2013-145177	9	0.1%
ca-2012-132626	9	0.1%
Other values (4999)	9889	98.9%

Most occurring characters

Value	Count	Frequency (%)
1	27506	19.7%
-	19988	14.3%
2	17485	12.5%
0	15492	11.1%
4	8726	6.2%
A	8308	5.9%
C	8308	5.9%
3	8034	5.7%
6	5319	3.8%
5	5234	3.7%
Other values (5)	15516	11.1%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	27506	19.7%
-	19988	14.3%
2	17485	12.5%
0	15492	11.1%
4	8726	6.2%
A	8308	5.9%
C	8308	5.9%
3	8034	5.7%
6	5319	3.8%
5	5234	3.7%
Other values (5)	15516	11.1%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	27506	19.7%
-	19988	14.3%
2	17485	12.5%
0	15492	11.1%
4	8726	6.2%
A	8308	5.9%
C	8308	5.9%
3	8034	5.7%
6	5319	3.8%
5	5234	3.7%
Other values (5)	15516	11.1%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	27506	19.7%
-	19988	14.3%
2	17485	12.5%
0	15492	11.1%
4	8726	6.2%
A	8308	5.9%
C	8308	5.9%
3	8034	5.7%
6	5319	3.8%
5	5234	3.7%
Other values (5)	15516	11.1%

Order Date
Date

Distinct	1238
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2011-01-02 00:00:00
Maximum	2014-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Date
Date

Distinct	1334
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Minimum	2011-01-02 00:00:00
Maximum	2015-06-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	603.5 KiB

Standard Class	5968
Second Class	1945
First Class	1538
Same Day	543

Length

Max length	14
Median length	14
Mean length	12.823094
Min length	8

Characters and Unicode

Total characters	128154
Distinct characters	18
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	Second Class
2nd row	Second Class
3rd row	Second Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	5968	59.7%
Second Class	1945	19.5%
First Class	1538	15.4%
Same Day	543	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	9451	47.3%
standard	5968	29.9%
second	1945	9.7%
first	1538	7.7%
same	543	2.7%
day	543	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
C	9451	7.4%
l	9451	7.4%
S	8456	6.6%
n	7913	6.2%
t	7506	5.9%
r	7506	5.9%
Other values (8)	11083	8.6%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
C	9451	7.4%
l	9451	7.4%
S	8456	6.6%
n	7913	6.2%
t	7506	5.9%
r	7506	5.9%
Other values (8)	11083	8.6%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
C	9451	7.4%
l	9451	7.4%
S	8456	6.6%
n	7913	6.2%
t	7506	5.9%
r	7506	5.9%
Other values (8)	11083	8.6%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	22473	17.5%
s	20440	15.9%
d	13881	10.8%
	9994	7.8%
C	9451	7.4%
l	9451	7.4%
S	8456	6.6%
n	7913	6.2%
t	7506	5.9%
r	7506	5.9%
Other values (8)	11083	8.6%

Customer ID
Text

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	556.4 KiB

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	79952
Distinct characters	40
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	5 ?
Unique (%)	0.1%

Sample

1st row	CG-12520
2nd row	CG-12520
3rd row	DV-13045
4th row	SO-20335
5th row	SO-20335

Value	Count	Frequency (%)
wb-21850	37	0.4%
jl-15835	34	0.3%
ma-17560	34	0.3%
pp-18955	34	0.3%
eh-13765	32	0.3%
jd-15895	32	0.3%
ck-12205	32	0.3%
sv-20365	32	0.3%
ep-13915	31	0.3%
ap-10915	31	0.3%
Other values (783)	9665	96.7%

Most occurring characters

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	11915	14.9%
-	9994	12.5%
0	8532	10.7%
5	7865	9.8%
2	4682	5.9%
7	2931	3.7%
6	2909	3.6%
9	2904	3.6%
8	2818	3.5%
3	2779	3.5%
Other values (30)	22623	28.3%

Customer Name
Text

Distinct	793
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	607.6 KiB

Length

Max length	22
Median length	18
Mean length	12.960676
Min length	7

Characters and Unicode

Total characters	129529
Distinct characters	57
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	5 ?
Unique (%)	0.1%

Sample

1st row	Claire Gute
2nd row	Claire Gute
3rd row	Darrin Van Huff
4th row	Sean O'Donnell
5th row	Sean O'Donnell

Value	Count	Frequency (%)
michael	120	0.6%
frank	112	0.6%
john	107	0.5%
patrick	96	0.5%
brian	93	0.5%
stewart	93	0.5%
paul	92	0.5%
rick	91	0.5%
ken	91	0.5%
matt	86	0.4%
Other values (901)	19072	95.1%

Most occurring characters

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	12011	9.3%
e	11836	9.1%
n	10241	7.9%
	10059	7.8%
r	9530	7.4%
i	7919	6.1%
l	6494	5.0%
o	5850	4.5%
t	5435	4.2%
s	4546	3.5%
Other values (47)	45608	35.2%

Segment
Categorical

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

Consumer	5191
Corporate	3020
Home Office	1783

Length

Max length	11
Median length	8
Mean length	8.8374024
Min length	8

Characters and Unicode

Total characters	88321
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	Consumer
2nd row	Consumer
3rd row	Corporate
4th row	Consumer
5th row	Consumer

Common Values

Value	Count	Frequency (%)
Consumer	5191	51.9%
Corporate	3020	30.2%
Home Office	1783	17.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	5191	44.1%
corporate	3020	25.6%
home	1783	15.1%
office	1783	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	13014	14.7%
e	11777	13.3%
r	11231	12.7%
C	8211	9.3%
m	6974	7.9%
u	5191	5.9%
s	5191	5.9%
n	5191	5.9%
f	3566	4.0%
p	3020	3.4%
Other values (7)	14955	16.9%

Country
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	605.2 KiB

United States	9994

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	129922
Distinct characters	10
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	United States
2nd row	United States
3rd row	United States
4th row	United States
5th row	United States

Common Values

Value	Count	Frequency (%)
United States	9994	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
united	9994	50.0%
states	9994	50.0%

Most occurring characters

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	29982	23.1%
e	19988	15.4%
n	9994	7.7%
U	9994	7.7%
i	9994	7.7%
d	9994	7.7%
	9994	7.7%
S	9994	7.7%
a	9994	7.7%
s	9994	7.7%

City
Text

Distinct	531
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	569.4 KiB

Length

Max length	17
Median length	14
Mean length	9.3306984
Min length	4

Characters and Unicode

Total characters	93251
Distinct characters	51
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	70 ?
Unique (%)	0.7%

Sample

1st row	Henderson
2nd row	Henderson
3rd row	Los Angeles
4th row	Fort Lauderdale
5th row	Fort Lauderdale

Value	Count	Frequency (%)
city	994	7.0%
new	937	6.6%
york	920	6.5%
san	805	5.7%
los	747	5.2%
angeles	747	5.2%
philadelphia	537	3.8%
francisco	510	3.6%
seattle	428	3.0%
houston	377	2.6%
Other values (555)	7234	50.8%

Most occurring characters

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	8719	9.4%
a	7591	8.1%
o	7499	8.0%
i	6229	6.7%
n	6199	6.6%
l	5986	6.4%
s	4699	5.0%
r	4468	4.8%
t	4438	4.8%
	4242	4.5%
Other values (41)	33181	35.6%

State
Categorical

High correlation

Distinct	49
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	561.2 KiB

California	2001
New York	1128
Texas	985
Pennsylvania	587
Washington	506
Other values (44)	4787

Length

Max length	20
Median length	14
Mean length	8.4871923
Min length	4

Characters and Unicode

Total characters	84821
Distinct characters	46
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	1 ?
Unique (%)	< 0.1%

Sample

1st row	Kentucky
2nd row	Kentucky
3rd row	California
4th row	Florida
5th row	Florida

Common Values

Value	Count	Frequency (%)
California	2001	20.0%
New York	1128	11.3%
Texas	985	9.9%
Pennsylvania	587	5.9%
Washington	506	5.1%
Illinois	492	4.9%
Ohio	469	4.7%
Florida	383	3.8%
Michigan	255	2.6%
North Carolina	249	2.5%
Other values (39)	2939	29.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
california	2001	17.1%
new	1322	11.3%
york	1128	9.6%
texas	985	8.4%
pennsylvania	587	5.0%
washington	506	4.3%
illinois	492	4.2%
ohio	469	4.0%
florida	383	3.3%
carolina	291	2.5%
Other values (43)	3542	30.3%

Most occurring characters

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	10758	12.7%
i	9895	11.7%
n	8090	9.5%
o	7323	8.6%
r	5544	6.5%
e	5051	6.0%
l	4822	5.7%
s	4604	5.4%
C	2566	3.0%
f	2011	2.4%
Other values (36)	24157	28.5%

Postal Code
Real number (ℝ)

High correlation

Distinct	631
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55190.379

Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23223
median	56430.5
Q3	90008
95-th percentile	98006
Maximum	99301
Range	98261
Interquartile range (IQR)	66785

Descriptive statistics

Standard deviation	32063.693
Coefficient of variation (CV)	0.58096526
Kurtosis	-1.4930202
Mean	55190.379
Median Absolute Deviation (MAD)	33573.5
Skewness	-0.12852552
Sum	5.5157265 × 10⁸
Variance	1.0280804 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10035	263	2.6%
10024	230	2.3%
10009	229	2.3%
94122	203	2.0%
10011	193	1.9%
94110	166	1.7%
98105	165	1.7%
19134	160	1.6%
90049	151	1.5%
98103	151	1.5%
Other values (621)	8083	80.9%

Value	Count	Frequency (%)
1040	1	< 0.1%
1453	6	0.1%
1752	2	< 0.1%
1810	4	< 0.1%
1841	33	0.3%
1852	16	0.2%
1915	3	< 0.1%
2038	17	0.2%
2138	6	0.1%
2148	3	< 0.1%

Value	Count	Frequency (%)
99301	6	0.1%
99207	7	0.1%
98661	5	0.1%
98632	3	< 0.1%
98502	5	0.1%
98270	2	< 0.1%
98226	3	< 0.1%
98208	1	< 0.1%
98198	7	0.1%
98115	112	1.1%

Region
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	525.8 KiB

West	3203
East	2848
Central	2323
South	1620

Length

Max length	7
Median length	4
Mean length	4.8594156
Min length	4

Characters and Unicode

Total characters	48565
Distinct characters	14
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	South
2nd row	South
3rd row	West
4th row	South
5th row	South

Common Values

Value	Count	Frequency (%)
West	3203	32.0%
East	2848	28.5%
Central	2323	23.2%
South	1620	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
west	3203	32.0%
east	2848	28.5%
central	2323	23.2%
south	1620	16.2%

Most occurring characters

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	9994	20.6%
s	6051	12.5%
e	5526	11.4%
a	5171	10.6%
W	3203	6.6%
E	2848	5.9%
C	2323	4.8%
n	2323	4.8%
r	2323	4.8%
l	2323	4.8%
Other values (4)	6480	13.3%

Product ID
Text

Distinct	1862
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Memory size	624.8 KiB

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	149910
Distinct characters	27
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	91 ?
Unique (%)	0.9%

Sample

1st row	FUR-BO-10001798
2nd row	FUR-CH-10000454
3rd row	OFF-LA-10000240
4th row	FUR-TA-10000577
5th row	OFF-ST-10000760

Value	Count	Frequency (%)
off-pa-10001970	19	0.2%
tec-ac-10003832	18	0.2%
fur-fu-10004270	16	0.2%
fur-ch-10001146	15	0.2%
tec-ac-10002049	15	0.2%
tec-ac-10003628	15	0.2%
fur-ch-10002647	15	0.2%
fur-fu-10001473	14	0.1%
off-bi-10001524	14	0.1%
fur-ch-10002880	14	0.1%
Other values (1852)	9839	98.4%

Most occurring characters

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	35052	23.4%
-	19988	13.3%
F	15347	10.2%
1	14995	10.0%
O	6322	4.2%
2	4862	3.2%
4	4831	3.2%
3	4805	3.2%
A	4422	2.9%
5	3401	2.3%
Other values (17)	35885	23.9%

Category
Categorical

High correlation

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

Office Supplies	6026
Furniture	2121
Technology	1847

Length

Max length	15
Median length	15
Mean length	12.802582
Min length	9

Characters and Unicode

Total characters	127949
Distinct characters	20
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	Furniture
2nd row	Furniture
3rd row	Office Supplies
4th row	Furniture
5th row	Office Supplies

Common Values

Value	Count	Frequency (%)
Office Supplies	6026	60.3%
Furniture	2121	21.2%
Technology	1847	18.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
office	6026	37.6%
supplies	6026	37.6%
furniture	2121	13.2%
technology	1847	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	16020	12.5%
i	14173	11.1%
p	12052	9.4%
f	12052	9.4%
u	10268	8.0%
c	7873	6.2%
l	7873	6.2%
O	6026	4.7%
S	6026	4.7%
	6026	4.7%
Other values (10)	29560	23.1%

Sub-Category
Categorical

High correlation

Distinct	17
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	548.5 KiB

Binders	1523
Paper	1370
Furnishings	957
Phones	889
Storage	846
Other values (12)	4409

Length

Max length	11
Median length	9
Mean length	7.191715
Min length	3

Characters and Unicode

Total characters	71874
Distinct characters	28
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	Bookcases
2nd row	Chairs
3rd row	Labels
4th row	Tables
5th row	Storage

Common Values

Value	Count	Frequency (%)
Binders	1523	15.2%
Paper	1370	13.7%
Furnishings	957	9.6%
Phones	889	8.9%
Storage	846	8.5%
Art	796	8.0%
Accessories	775	7.8%
Chairs	617	6.2%
Appliances	466	4.7%
Labels	364	3.6%
Other values (7)	1391	13.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
binders	1523	15.2%
paper	1370	13.7%
furnishings	957	9.6%
phones	889	8.9%
storage	846	8.5%
art	796	8.0%
accessories	775	7.8%
chairs	617	6.2%
appliances	466	4.7%
labels	364	3.6%
Other values (7)	1391	13.9%

Most occurring characters

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	9934	13.8%
e	8870	12.3%
r	7169	10.0%
i	5668	7.9%
n	5378	7.5%
a	4542	6.3%
o	3288	4.6%
p	3004	4.2%
h	2578	3.6%
c	2359	3.3%
Other values (18)	19084	26.6%

Product Name
Text

Distinct	1841
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Memory size	854.9 KiB

Length

Max length	127
Median length	78
Mean length	36.73324
Min length	5

Characters and Unicode

Total characters	367112
Distinct characters	85
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	91 ?
Unique (%)	0.9%

Sample

1st row	Bush Somerset Collection Bookcase
2nd row	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd row	Self-Adhesive Address Labels for Typewriters by Universal
4th row	Bretford CR4500 Series Slim Rectangular Table
5th row	Eldon Fold 'N Roll Cart System

Value	Count	Frequency (%)
xerox	865	1.6%
x	701	1.3%
with	599	1.1%
	599	1.1%
avery	557	1.0%
for	539	1.0%
binders	524	0.9%
chair	479	0.9%
black	426	0.8%
phone	374	0.7%
Other values (2790)	50130	89.8%

Most occurring characters

Value	Count	Frequency (%)
	45429	12.4%
e	33268	9.1%
r	20671	5.6%
o	19780	5.4%
a	18903	5.1%
i	18588	5.1%
l	16243	4.4%
n	15502	4.2%
s	14672	4.0%
t	14540	4.0%
Other values (75)	149516	40.7%

Most occurring categories

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

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	45429	12.4%
e	33268	9.1%
r	20671	5.6%
o	19780	5.4%
a	18903	5.1%
i	18588	5.1%
l	16243	4.4%
n	15502	4.2%
s	14672	4.0%
t	14540	4.0%
Other values (75)	149516	40.7%

Most occurring scripts

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

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	45429	12.4%
e	33268	9.1%
r	20671	5.6%
o	19780	5.4%
a	18903	5.1%
i	18588	5.1%
l	16243	4.4%
n	15502	4.2%
s	14672	4.0%
t	14540	4.0%
Other values (75)	149516	40.7%

Most occurring blocks

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

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	45429	12.4%
e	33268	9.1%
r	20671	5.6%
o	19780	5.4%
a	18903	5.1%
i	18588	5.1%
l	16243	4.4%
n	15502	4.2%
s	14672	4.0%
t	14540	4.0%
Other values (75)	149516	40.7%

Sales
Real number (ℝ)

High correlation

Distinct	5825
Distinct (%)	58.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	229.858

Minimum	0.444
Maximum	22638.48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.444
5-th percentile	4.98
Q1	17.28
median	54.49
Q3	209.94
95-th percentile	956.98425
Maximum	22638.48
Range	22638.036
Interquartile range (IQR)	192.66

Descriptive statistics

Standard deviation	623.2451
Coefficient of variation (CV)	2.7114353
Kurtosis	305.31175
Mean	229.858
Median Absolute Deviation (MAD)	45.406
Skewness	12.972752
Sum	2297200.9
Variance	388434.46
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.96	56	0.6%
19.44	39	0.4%
15.552	39	0.4%
10.368	36	0.4%
25.92	36	0.4%
32.4	28	0.3%
6.48	21	0.2%
17.94	21	0.2%
20.736	19	0.2%
14.94	17	0.2%
Other values (5815)	9682	96.9%

Value	Count	Frequency (%)
0.444	1	< 0.1%
0.556	1	< 0.1%
0.836	1	< 0.1%
0.852	1	< 0.1%
0.876	1	< 0.1%
0.898	1	< 0.1%
0.984	1	< 0.1%
0.99	1	< 0.1%
1.044	1	< 0.1%
1.08	3	< 0.1%

Value	Count	Frequency (%)
22638.48	1	< 0.1%
17499.95	1	< 0.1%
13999.96	1	< 0.1%
11199.968	1	< 0.1%
10499.97	1	< 0.1%
9892.74	1	< 0.1%
9449.95	1	< 0.1%
9099.93	1	< 0.1%
8749.95	1	< 0.1%
8399.976	1	< 0.1%

Quantity
Real number (ℝ)

Distinct	14
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7895737

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	8
Maximum	14
Range	13
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2251097
Coefficient of variation (CV)	0.58716622
Kurtosis	1.9918894
Mean	3.7895737
Median Absolute Deviation (MAD)	1
Skewness	1.2785448
Sum	37873
Variance	4.9511131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	2409	24.1%
2	2402	24.0%
5	1230	12.3%
4	1191	11.9%
1	899	9.0%
7	606	6.1%
6	572	5.7%
9	258	2.6%
8	257	2.6%
10	57	0.6%
Other values (4)	113	1.1%

Value	Count	Frequency (%)
1	899	9.0%
2	2402	24.0%
3	2409	24.1%
4	1191	11.9%
5	1230	12.3%
6	572	5.7%
7	606	6.1%
8	257	2.6%
9	258	2.6%
10	57	0.6%

Value	Count	Frequency (%)
14	29	0.3%
13	27	0.3%
12	23	0.2%
11	34	0.3%
10	57	0.6%
9	258	2.6%
8	257	2.6%
7	606	6.1%
6	572	5.7%
5	1230	12.3%

Discount
Real number (ℝ)

High correlation Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15620272

Minimum	0
Maximum	0.8
Zeros	4798
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.2
Q3	0.2
95-th percentile	0.7
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.20645197
Coefficient of variation (CV)	1.3216925
Kurtosis	2.4095461
Mean	0.15620272
Median Absolute Deviation (MAD)	0.2
Skewness	1.6842947
Sum	1561.09
Variance	0.042622415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	4798	48.0%
0.2	3657	36.6%
0.7	418	4.2%
0.8	300	3.0%
0.3	227	2.3%
0.4	206	2.1%
0.6	138	1.4%
0.1	94	0.9%
0.5	66	0.7%
0.15	52	0.5%
Other values (2)	38	0.4%

Value	Count	Frequency (%)
0	4798	48.0%
0.1	94	0.9%
0.15	52	0.5%
0.2	3657	36.6%
0.3	227	2.3%
0.32	27	0.3%
0.4	206	2.1%
0.45	11	0.1%
0.5	66	0.7%
0.6	138	1.4%

Value	Count	Frequency (%)
0.8	300	3.0%
0.7	418	4.2%
0.6	138	1.4%
0.5	66	0.7%
0.45	11	0.1%
0.4	206	2.1%
0.32	27	0.3%
0.3	227	2.3%
0.2	3657	36.6%
0.15	52	0.5%

Profit
Real number (ℝ)

High correlation

Distinct	7287
Distinct (%)	72.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.656896

Minimum	-6599.978
Maximum	8399.976
Zeros	65
Zeros (%)	0.7%
Negative	1871
Negative (%)	18.7%
Memory size	78.2 KiB

Quantile statistics

Minimum	-6599.978
5-th percentile	-53.03092
Q1	1.72875
median	8.6665
Q3	29.364
95-th percentile	168.4704
Maximum	8399.976
Range	14999.954
Interquartile range (IQR)	27.63525

Descriptive statistics

Standard deviation	234.26011
Coefficient of variation (CV)	8.1746504
Kurtosis	397.18851
Mean	28.656896
Median Absolute Deviation (MAD)	10.77855
Skewness	7.5614316
Sum	286397.02
Variance	54877.798
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65	0.7%
6.2208	43	0.4%
9.3312	38	0.4%
3.6288	32	0.3%
5.4432	32	0.3%
15.552	26	0.3%
12.4416	21	0.2%
7.2576	19	0.2%
3.1104	18	0.2%
9.072	11	0.1%
Other values (7277)	9689	96.9%

Value	Count	Frequency (%)
-6599.978	1	< 0.1%
-3839.9904	1	< 0.1%
-3701.8928	1	< 0.1%
-3399.98	1	< 0.1%
-2929.4845	1	< 0.1%
-2639.9912	1	< 0.1%
-2287.782	1	< 0.1%
-1862.3124	1	< 0.1%
-1850.9464	1	< 0.1%
-1811.0784	1	< 0.1%

Value	Count	Frequency (%)
8399.976	1	< 0.1%
6719.9808	1	< 0.1%
5039.9856	1	< 0.1%
4946.37	1	< 0.1%
4630.4755	1	< 0.1%
3919.9888	1	< 0.1%
3177.475	1	< 0.1%
2799.984	1	< 0.1%
2591.9568	1	< 0.1%
2504.2216	1	< 0.1%

Interactions

Correlations

	Category	Discount	Postal Code	Profit	Quantity	Region	Row ID	Sales	Segment	Ship Mode	State	Sub-Category
Category	1.000	0.377	0.000	0.056	0.000	0.000	0.008	0.072	0.000	0.000	0.019	0.999
Discount	0.377	1.000	0.053	-0.543	-0.001	0.294	0.013	-0.057	0.005	0.027	0.354	0.353
Postal Code	0.000	0.053	1.000	-0.005	0.014	0.921	0.011	-0.002	0.035	0.038	0.968	0.000
Profit	0.056	-0.543	-0.005	1.000	0.234	0.021	-0.011	0.518	0.000	0.005	0.017	0.130
Quantity	0.000	-0.001	0.014	0.234	1.000	0.000	-0.002	0.327	0.012	0.000	0.004	0.000
Region	0.000	0.294	0.921	0.021	0.000	1.000	0.038	0.000	0.000	0.022	0.998	0.000
Row ID	0.008	0.013	0.011	-0.011	-0.002	0.038	1.000	-0.001	0.030	0.050	0.102	0.000
Sales	0.072	-0.057	-0.002	0.518	0.327	0.000	-0.001	1.000	0.002	0.000	0.000	0.142
Segment	0.000	0.005	0.035	0.000	0.012	0.000	0.030	0.002	1.000	0.033	0.090	0.000
Ship Mode	0.000	0.027	0.038	0.005	0.000	0.022	0.050	0.000	0.033	1.000	0.096	0.007
State	0.019	0.354	0.968	0.017	0.004	0.998	0.102	0.000	0.090	0.096	1.000	0.000
Sub-Category	0.999	0.353	0.000	0.130	0.000	0.000	0.000	0.142	0.000	0.007	0.000	1.000

Missing values

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.

Sample

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
0	1	CA-2013-152156	09-11-2013	12-11-2013	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	261.9600	2	0.00	41.9136
1	2	CA-2013-152156	09-11-2013	12-11-2013	Second Class	CG-12520	Claire Gute	Consumer	United States	Henderson	Kentucky	42420	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	731.9400	3	0.00	219.5820
2	3	CA-2013-138688	13-06-2013	17-06-2013	Second Class	DV-13045	Darrin Van Huff	Corporate	United States	Los Angeles	California	90036	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	14.6200	2	0.00	6.8714
3	4	US-2012-108966	11-10-2012	18-10-2012	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	957.5775	5	0.45	-383.0310
4	5	US-2012-108966	11-10-2012	18-10-2012	Standard Class	SO-20335	Sean O'Donnell	Consumer	United States	Fort Lauderdale	Florida	33311	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	22.3680	2	0.20	2.5164
5	6	CA-2011-115812	09-06-2011	14-06-2011	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	48.8600	7	0.00	14.1694
6	7	CA-2011-115812	09-06-2011	14-06-2011	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	7.2800	4	0.00	1.9656
7	8	CA-2011-115812	09-06-2011	14-06-2011	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	907.1520	6	0.20	90.7152
8	9	CA-2011-115812	09-06-2011	14-06-2011	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	18.5040	3	0.20	5.7825
9	10	CA-2011-115812	09-06-2011	14-06-2011	Standard Class	BH-11710	Brosina Hoffman	Consumer	United States	Los Angeles	California	90032	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	114.9000	5	0.00	34.4700

	Row ID	Order ID	Order Date	Ship Date	Ship Mode	Customer ID	Customer Name	Segment	Country	City	State	Postal Code	Region	Product ID	Category	Sub-Category	Product Name	Sales	Quantity	Discount	Profit
9984	9985	CA-2012-100251	17-05-2012	23-05-2012	Standard Class	DV-13465	Dianna Vittorini	Consumer	United States	Long Beach	New York	11561	East	OFF-LA-10003766	Office Supplies	Labels	Self-Adhesive Removable Labels	31.500	10	0.0	15.1200
9985	9986	CA-2012-100251	17-05-2012	23-05-2012	Standard Class	DV-13465	Dianna Vittorini	Consumer	United States	Long Beach	New York	11561	East	OFF-SU-10000898	Office Supplies	Supplies	Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L	55.600	4	0.0	16.1240
9986	9987	CA-2013-125794	30-09-2013	04-10-2013	Standard Class	ML-17410	Maris LaWare	Consumer	United States	Los Angeles	California	90008	West	TEC-AC-10003399	Technology	Accessories	Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive	36.240	1	0.0	15.2208
9987	9988	CA-2014-163629	18-11-2014	22-11-2014	Standard Class	RA-19885	Ruben Ausman	Corporate	United States	Athens	Georgia	30605	South	TEC-AC-10001539	Technology	Accessories	Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology	79.990	1	0.0	28.7964
9988	9989	CA-2014-163629	18-11-2014	22-11-2014	Standard Class	RA-19885	Ruben Ausman	Corporate	United States	Athens	Georgia	30605	South	TEC-PH-10004006	Technology	Phones	Panasonic KX - TS880B Telephone	206.100	5	0.0	55.6470
9989	9990	CA-2011-110422	22-01-2011	24-01-2011	Second Class	TB-21400	Tom Boeckenhauer	Consumer	United States	Miami	Florida	33180	South	FUR-FU-10001889	Furniture	Furnishings	Ultra Door Pull Handle	25.248	3	0.2	4.1028
9990	9991	CA-2014-121258	27-02-2014	04-03-2014	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	FUR-FU-10000747	Furniture	Furnishings	Tenex B1-RE Series Chair Mats for Low Pile Carpets	91.960	2	0.0	15.6332
9991	9992	CA-2014-121258	27-02-2014	04-03-2014	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	TEC-PH-10003645	Technology	Phones	Aastra 57i VoIP phone	258.576	2	0.2	19.3932
9992	9993	CA-2014-121258	27-02-2014	04-03-2014	Standard Class	DB-13060	Dave Brooks	Consumer	United States	Costa Mesa	California	92627	West	OFF-PA-10004041	Office Supplies	Paper	It's Hot Message Books with Stickers, 2 3/4" x 5"	29.600	4	0.0	13.3200
9993	9994	CA-2014-119914	05-05-2014	10-05-2014	Second Class	CC-12220	Chris Cortes	Consumer	United States	Westminster	California	92683	West	OFF-AP-10002684	Office Supplies	Appliances	Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection	243.160	2	0.0	72.9480

Overview

Variables

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)

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)

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)

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