Overview
Brought to you by YData
Dataset statistics
Number of variables | 29 |
---|---|
Number of observations | 294266 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 3 |
Duplicate rows (%) | < 0.1% |
Total size in memory | 345.5 MiB |
Average record size in memory | 1.2 KiB |
Variable types
Numeric | 7 |
---|---|
Text | 6 |
Categorical | 14 |
DateTime | 2 |
Dataset has 3 (< 0.1%) duplicate rows | Duplicates |
Amount is highly overall correlated with
Total_Amount |
High correlation |
Feedback is highly overall correlated
with Ratings |
High correlation |
Month is highly overall correlated with
Year |
High correlation |
Product_Brand is highly overall
correlated with Product_Category and 1 other fields
|
High correlation |
Product_Category is highly overall
correlated with Product_Brand and 1 other fields |
High correlation |
Product_Type is highly overall
correlated with Product_Brand and 1 other fields
|
High correlation |
Ratings is highly overall correlated with
Feedback |
High correlation |
Total_Amount is highly overall
correlated with Amount and 1 other fields |
High correlation |
Total_Purchases is highly overall
correlated with Total_Amount |
High correlation |
Year is highly overall correlated with
Month |
High correlation |
Reproduction
Analysis started | 2025-09-11 12:42:35.338396 |
---|---|
Analysis finished | 2025-09-11 12:43:50.837846 |
Duration | 1 minute and 15.5 seconds |
Software version | ydata-profiling vv4.16.1 |
Download configuration | config.json |
Variables
Transaction_ID
Real
number (ℝ)
Distinct | 287345 |
---|---|
Distinct (%) | 97.6% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5493785.1 |
Minimum | 1000007 |
---|---|
Maximum | 9999995 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 1000007 |
---|---|
5-th percentile | 1446260 |
Q1 | 3245886.8 |
median | 5495935 |
Q3 | 7738152.8 |
95-th percentile | 9547991 |
Maximum | 9999995 |
Range | 8999988 |
Interquartile range (IQR) | 4492266 |
Descriptive statistics
Standard deviation | 2596084.5 |
---|---|
Coefficient of variation (CV) | 0.47254934 |
Kurtosis | -1.1966785 |
Mean | 5493785.1 |
Median Absolute Deviation (MAD) | 2246218.5 |
Skewness | 0.0025118782 |
Sum | 1.6166342 × 1012 |
Variance | 6.7396548 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
6145934 | 4 | < 0.1% |
3725822 | 3 | < 0.1% |
6565862 | 3 | < 0.1% |
9466196 | 3 | < 0.1% |
5840674 | 3 | < 0.1% |
3137725 | 3 | < 0.1% |
5459500 | 3 | < 0.1% |
9685446 | 3 | < 0.1% |
9703579 | 3 | < 0.1% |
9184711 | 3 | < 0.1% |
Other values (287335) | 294235 |
Value | Count | Frequency (%) |
1000007 | 1 | |
1000043 | 1 | |
1000073 | 1 | |
1000088 | 1 | |
1000154 | 1 | |
1000183 | 1 | |
1000195 | 1 | |
1000219 | 1 | |
1000294 | 1 | |
1000307 | 1 |
Value | Count | Frequency (%) |
9999995 | 1 | |
9999945 | 1 | |
9999922 | 1 | |
9999909 | 1 | |
9999823 | 1 | |
9999786 | 1 | |
9999785 | 1 | |
9999782 | 1 | |
9999775 | 1 | |
9999647 | 1 |
Customer_ID
Real number (ℝ)
Distinct | 86501 |
---|---|
Distinct (%) | 29.4% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 55015.611 |
Minimum | 10000 |
---|---|
Maximum | 99999 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 10000 |
---|---|
5-th percentile | 14443 |
Q1 | 32470.25 |
median | 55029 |
Q3 | 77518 |
95-th percentile | 95587.75 |
Maximum | 99999 |
Range | 89999 |
Interquartile range (IQR) | 45047.75 |
Descriptive statistics
Standard deviation | 26010.244 |
---|---|
Coefficient of variation (CV) | 0.47277932 |
Kurtosis | -1.2002798 |
Mean | 55015.611 |
Median Absolute Deviation (MAD) | 22524 |
Skewness | 0.00017360816 |
Sum | 1.6189224 × 1010 |
Variance | 6.7653277 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
99355 | 13 | < 0.1% |
60341 | 13 | < 0.1% |
47382 | 13 | < 0.1% |
49274 | 13 | < 0.1% |
43157 | 12 | < 0.1% |
56081 | 12 | < 0.1% |
49587 | 12 | < 0.1% |
48453 | 12 | < 0.1% |
36179 | 12 | < 0.1% |
80994 | 12 | < 0.1% |
Other values (86491) | 294142 |
Value | Count | Frequency (%) |
10000 | 4 | |
10001 | 5 | |
10002 | 5 | |
10003 | 2 | < 0.1% |
10004 | 2 | < 0.1% |
10005 | 1 | < 0.1% |
10006 | 4 | |
10007 | 5 | |
10008 | 5 | |
10009 | 3 |
Value | Count | Frequency (%) |
99999 | 2 | < 0.1% |
99998 | 5 | |
99997 | 4 | |
99996 | 4 | |
99995 | 8 | |
99994 | 7 | |
99993 | 3 | < 0.1% |
99992 | 1 | < 0.1% |
99991 | 2 | < 0.1% |
99990 | 5 |
Length
Max length | 29 |
---|---|
Median length | 27 |
Mean length | 13.273817 |
Min length | 6 |
Unique
Unique | 105419 ? |
---|---|
Unique (%) | 35.8% |
Sample
1st row | Michelle Harrington |
---|---|
2nd row | Kelsey Hill |
3rd row | Scott Jensen |
4th row | Joseph Miller |
5th row | Debra Coleman |
Value | Count | Frequency (%) |
michael | 6736 | 1.1% |
smith | 6332 | 1.1% |
johnson | 5029 | 0.8% |
james | 5013 | 0.8% |
david | 4674 | 0.8% |
jennifer | 4296 | 0.7% |
christopher | 4146 | 0.7% |
john | 4088 | 0.7% |
williams | 4046 | 0.7% |
thomas | 3982 | 0.7% |
Other values (1588) | 553445 |
Most occurring characters
Value | Count | Frequency (%) |
e | 362487 | 9.3% |
a | 360722 | 9.2% |
307521 | 7.9% | |
n | 293525 | 7.5% |
r | 281732 | 7.2% |
i | 236593 | 6.1% |
o | 210195 | 5.4% |
l | 198439 | 5.1% |
s | 175202 | 4.5% |
t | 135801 | 3.5% |
Other values (44) | 1343816 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 2980898 | |
Uppercase Letter | 611316 | 15.7% |
Space Separator | 307521 | 7.9% |
Other Punctuation | 6298 | 0.2% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 362487 | |
a | 360722 | |
n | 293525 | |
r | 281732 | |
i | 236593 | 7.9% |
o | 210195 | 7.1% |
l | 198439 | 6.7% |
s | 175202 | 5.9% |
t | 135801 | 4.6% |
h | 131447 | 4.4% |
Other values (16) | 594755 |
Uppercase Letter
Value | Count | Frequency (%) |
M | 68721 | 11.2% |
J | 60124 | 9.8% |
S | 50042 | 8.2% |
C | 45410 | 7.4% |
D | 40904 | 6.7% |
B | 37965 | 6.2% |
R | 37855 | 6.2% |
A | 37406 | 6.1% |
W | 28920 | 4.7% |
H | 28444 | 4.7% |
Other values (16) | 175525 |
Space Separator
Value | Count | Frequency (%) |
307521 |
Other Punctuation
Value | Count | Frequency (%) |
. | 6298 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 3592214 | |
Common | 313819 | 8.0% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 362487 | 10.1% |
a | 360722 | 10.0% |
n | 293525 | 8.2% |
r | 281732 | 7.8% |
i | 236593 | 6.6% |
o | 210195 | 5.9% |
l | 198439 | 5.5% |
s | 175202 | 4.9% |
t | 135801 | 3.8% |
h | 131447 | 3.7% |
Other values (42) | 1206071 |
Common
Value | Count | Frequency (%) |
307521 | ||
. | 6298 | 2.0% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3906033 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 362487 | 9.3% |
a | 360722 | 9.2% |
307521 | 7.9% | |
n | 293525 | 7.5% |
r | 281732 | 7.2% |
i | 236593 | 6.1% |
o | 210195 | 5.4% |
l | 198439 | 5.1% |
s | 175202 | 4.5% |
t | 135801 | 3.5% |
Other values (44) | 1343816 |
Length
Max length | 24 |
---|---|
Median length | 22 |
Mean length | 17.950949 |
Min length | 13 |
Unique
Unique | 14485 ? |
---|---|
Unique (%) | 4.9% |
Sample
1st row | Ebony39@gmail.com |
---|---|
2nd row | Mark36@gmail.com |
3rd row | Shane85@gmail.com |
4th row | Mary34@gmail.com |
5th row | Charles30@gmail.com |
Value | Count | Frequency (%) |
michael59@gmail.com | 92 | < 0.1% |
michael95@gmail.com | 91 | < 0.1% |
michael17@gmail.com | 88 | < 0.1% |
michael39@gmail.com | 85 | < 0.1% |
michael50@gmail.com | 84 | < 0.1% |
michael58@gmail.com | 83 | < 0.1% |
michael55@gmail.com | 83 | < 0.1% |
michael40@gmail.com | 82 | < 0.1% |
michael30@gmail.com | 81 | < 0.1% |
michael93@gmail.com | 81 | < 0.1% |
Other values (52539) | 293416 |
Most occurring characters
Value | Count | Frequency (%) |
m | 622301 | |
a | 510140 | 9.7% |
i | 432917 | 8.2% |
l | 386809 | 7.3% |
o | 364935 | 6.9% |
c | 338618 | 6.4% |
g | 304708 | 5.8% |
@ | 294266 | 5.6% |
. | 294266 | 5.6% |
e | 187769 | 3.6% |
Other values (52) | 1545625 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 3834516 | |
Other Punctuation | 588532 | 11.1% |
Decimal Number | 565040 | 10.7% |
Uppercase Letter | 294266 | 5.6% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
m | 622301 | |
a | 510140 | |
i | 432917 | |
l | 386809 | |
o | 364935 | |
c | 338618 | |
g | 304708 | |
e | 187769 | 4.9% |
n | 142704 | 3.7% |
r | 123763 | 3.2% |
Other values (16) | 419852 |
Uppercase Letter
Value | Count | Frequency (%) |
J | 44240 | |
M | 29901 | |
A | 27433 | |
C | 23466 | |
S | 22952 | 7.8% |
D | 20972 | 7.1% |
K | 19287 | 6.6% |
R | 17626 | 6.0% |
T | 15801 | 5.4% |
B | 14440 | 4.9% |
Other values (14) | 58148 |
Decimal Number
Value | Count | Frequency (%) |
1 | 61613 | |
2 | 59154 | |
5 | 59121 | |
4 | 58919 | |
7 | 58874 | |
6 | 58798 | |
3 | 58774 | |
9 | 58570 | |
8 | 58502 | |
0 | 32715 |
Other Punctuation
Value | Count | Frequency (%) |
@ | 294266 | |
. | 294266 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 4128782 | |
Common | 1153572 | 21.8% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
m | 622301 | |
a | 510140 | |
i | 432917 | |
l | 386809 | |
o | 364935 | |
c | 338618 | |
g | 304708 | |
e | 187769 | 4.5% |
n | 142704 | 3.5% |
r | 123763 | 3.0% |
Other values (40) | 714118 |
Common
Value | Count | Frequency (%) |
@ | 294266 | |
. | 294266 | |
1 | 61613 | 5.3% |
2 | 59154 | 5.1% |
5 | 59121 | 5.1% |
4 | 58919 | 5.1% |
7 | 58874 | 5.1% |
6 | 58798 | 5.1% |
3 | 58774 | 5.1% |
9 | 58570 | 5.1% |
Other values (2) | 91217 | 7.9% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 5282354 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
m | 622301 | |
a | 510140 | 9.7% |
i | 432917 | 8.2% |
l | 386809 | 7.3% |
o | 364935 | 6.9% |
c | 338618 | 6.4% |
g | 304708 | 5.8% |
@ | 294266 | 5.6% |
. | 294266 | 5.6% |
e | 187769 | 3.6% |
Other values (52) | 1545625 |
Length
Max length | 38 |
---|---|
Median length | 32 |
Mean length | 22.475393 |
Min length | 10 |
Unique
Unique | 289660 ? |
---|---|
Unique (%) | 98.4% |
Sample
1st row | 3959 Amanda Burgs |
---|---|
2nd row | 82072 Dawn Centers |
3rd row | 4133 Young Canyon |
4th row | 8148 Thomas Creek Suite 100 |
5th row | 5813 Lori Ports Suite 269 |
Value | Count | Frequency (%) |
apt | 73909 | 6.3% |
suite | 73624 | 6.3% |
michael | 3360 | 0.3% |
smith | 3247 | 0.3% |
stravenue | 2667 | 0.2% |
mission | 2664 | 0.2% |
drive | 2661 | 0.2% |
islands | 2657 | 0.2% |
summit | 2655 | 0.2% |
plains | 2654 | 0.2% |
Other values (75130) | 1007766 |
Most occurring characters
Value | Count | Frequency (%) |
883598 | 13.4% | |
e | 409955 | 6.2% |
a | 331008 | 5.0% |
i | 291629 | 4.4% |
t | 291290 | 4.4% |
r | 263693 | 4.0% |
n | 248008 | 3.7% |
s | 223736 | 3.4% |
o | 208890 | 3.2% |
l | 198545 | 3.0% |
Other values (54) | 3263392 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 3299628 | |
Decimal Number | 1620544 | |
Space Separator | 883598 | 13.4% |
Uppercase Letter | 736065 | 11.1% |
Other Punctuation | 73909 | 1.1% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 409955 | |
a | 331008 | |
i | 291629 | |
t | 291290 | |
r | 263693 | 8.0% |
n | 248008 | 7.5% |
s | 223736 | 6.8% |
o | 208890 | 6.3% |
l | 198545 | 6.0% |
u | 145414 | 4.4% |
Other values (16) | 687460 |
Uppercase Letter
Value | Count | Frequency (%) |
S | 130476 | |
A | 95116 | |
C | 55708 | 7.6% |
M | 51083 | 6.9% |
P | 42135 | 5.7% |
R | 41220 | 5.6% |
J | 31701 | 4.3% |
L | 30658 | 4.2% |
B | 28368 | 3.9% |
T | 27417 | 3.7% |
Other values (16) | 202183 |
Decimal Number
Value | Count | Frequency (%) |
9 | 162478 | |
2 | 162464 | |
5 | 162457 | |
8 | 162372 | |
3 | 162342 | |
1 | 161977 | |
6 | 161963 | |
4 | 161940 | |
7 | 161520 | |
0 | 161031 |
Space Separator
Value | Count | Frequency (%) |
883598 |
Other Punctuation
Value | Count | Frequency (%) |
. | 73909 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 4035693 | |
Common | 2578051 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 409955 | 10.2% |
a | 331008 | 8.2% |
i | 291629 | 7.2% |
t | 291290 | 7.2% |
r | 263693 | 6.5% |
n | 248008 | 6.1% |
s | 223736 | 5.5% |
o | 208890 | 5.2% |
l | 198545 | 4.9% |
u | 145414 | 3.6% |
Other values (42) | 1423525 |
Common
Value | Count | Frequency (%) |
883598 | ||
9 | 162478 | 6.3% |
2 | 162464 | 6.3% |
5 | 162457 | 6.3% |
8 | 162372 | 6.3% |
3 | 162342 | 6.3% |
1 | 161977 | 6.3% |
6 | 161963 | 6.3% |
4 | 161940 | 6.3% |
7 | 161520 | 6.3% |
Other values (2) | 234940 | 9.1% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 6613744 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
883598 | 13.4% | |
e | 409955 | 6.2% |
a | 331008 | 5.0% |
i | 291629 | 4.4% |
t | 291290 | 4.4% |
r | 263693 | 4.0% |
n | 248008 | 3.7% |
s | 223736 | 3.4% |
o | 208890 | 3.2% |
l | 198545 | 3.0% |
Other values (54) | 3263392 |
Length
Max length | 19 |
---|---|
Median length | 14 |
Mean length | 8.2868527 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Dortmund |
---|---|
2nd row | Nottingham |
3rd row | Geelong |
4th row | Edmonton |
5th row | Bristol |
Value | Count | Frequency (%) |
chicago | 21143 | 6.3% |
portsmouth | 19679 | 5.8% |
san | 14561 | 4.3% |
francisco | 11954 | 3.5% |
frankfurt | 9963 | 2.9% |
boston | 9197 | 2.7% |
new | 6212 | 1.8% |
york | 5325 | 1.6% |
fort | 5096 | 1.5% |
worth | 5096 | 1.5% |
Other values (132) | 229886 |
Most occurring characters
Value | Count | Frequency (%) |
o | 247597 | 10.2% |
a | 194752 | 8.0% |
n | 182786 | 7.5% |
r | 168599 | 6.9% |
t | 162326 | 6.7% |
e | 157200 | 6.4% |
i | 133476 | 5.5% |
s | 115451 | 4.7% |
l | 97072 | 4.0% |
h | 88199 | 3.6% |
Other values (43) | 891081 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 2049940 | |
Uppercase Letter | 338136 | 13.9% |
Space Separator | 43846 | 1.8% |
Other Punctuation | 4400 | 0.2% |
Dash Punctuation | 2217 | 0.1% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
o | 247597 | |
a | 194752 | 9.5% |
n | 182786 | 8.9% |
r | 168599 | 8.2% |
t | 162326 | 7.9% |
e | 157200 | 7.7% |
i | 133476 | 6.5% |
s | 115451 | 5.6% |
l | 97072 | 4.7% |
h | 88199 | 4.3% |
Other values (16) | 502482 |
Uppercase Letter
Value | Count | Frequency (%) |
C | 41660 | |
B | 40558 | |
S | 30471 | 9.0% |
F | 27897 | 8.3% |
P | 27598 | 8.2% |
L | 18985 | 5.6% |
W | 17913 | 5.3% |
M | 17536 | 5.2% |
N | 15838 | 4.7% |
D | 14320 | 4.2% |
Other values (13) | 85360 |
Other Punctuation
Value | Count | Frequency (%) |
. | 2200 | |
' | 2200 |
Space Separator
Value | Count | Frequency (%) |
43846 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 2217 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2388076 | |
Common | 50463 | 2.1% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
o | 247597 | 10.4% |
a | 194752 | 8.2% |
n | 182786 | 7.7% |
r | 168599 | 7.1% |
t | 162326 | 6.8% |
e | 157200 | 6.6% |
i | 133476 | 5.6% |
s | 115451 | 4.8% |
l | 97072 | 4.1% |
h | 88199 | 3.7% |
Other values (39) | 840618 |
Common
Value | Count | Frequency (%) |
43846 | ||
- | 2217 | 4.4% |
. | 2200 | 4.4% |
' | 2200 | 4.4% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2434148 | |
None | 4391 | 0.2% |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
o | 247597 | 10.2% |
a | 194752 | 8.0% |
n | 182786 | 7.5% |
r | 168599 | 6.9% |
t | 162326 | 6.7% |
e | 157200 | 6.5% |
i | 133476 | 5.5% |
s | 115451 | 4.7% |
l | 97072 | 4.0% |
h | 88199 | 3.6% |
Other values (42) | 886690 |
None
Value | Count | Frequency (%) |
ü | 4391 |
Length
Max length | 15 |
---|---|
Median length | 14 |
Mean length | 8.4720151 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Berlin |
---|---|
2nd row | England |
3rd row | New South Wales |
4th row | Ontario |
5th row | England |
Value | Count | Frequency (%) |
england | 61470 | |
new | 52050 | |
berlin | 51492 | |
south | 46026 | |
wales | 44231 | |
ontario | 44155 | |
connecticut | 21154 | 5.3% |
maine | 11966 | 3.0% |
georgia | 9289 | 2.3% |
kansas | 5378 | 1.4% |
Other values (46) | 48657 |
Most occurring characters
Value | Count | Frequency (%) |
n | 305892 | 12.3% |
a | 228960 | 9.2% |
e | 213012 | 8.5% |
i | 174559 | 7.0% |
l | 169734 | 6.8% |
o | 150446 | 6.0% |
t | 143854 | 5.8% |
r | 122719 | 4.9% |
101602 | 4.1% | |
s | 79767 | 3.2% |
Other values (38) | 802481 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1995556 | |
Uppercase Letter | 395868 | 15.9% |
Space Separator | 101602 | 4.1% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
n | 305892 | |
a | 228960 | |
e | 213012 | |
i | 174559 | |
l | 169734 | |
o | 150446 | |
t | 143854 | |
r | 122719 | 6.1% |
s | 79767 | 4.0% |
g | 76065 | 3.8% |
Other values (14) | 330548 |
Uppercase Letter
Value | Count | Frequency (%) |
E | 61470 | |
N | 55594 | |
B | 51492 | |
W | 47741 | |
O | 46786 | |
S | 46026 | |
C | 24740 | |
M | 23341 | 5.9% |
G | 9289 | 2.3% |
K | 6252 | 1.6% |
Other values (13) | 23137 | 5.8% |
Space Separator
Value | Count | Frequency (%) |
101602 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2391424 | |
Common | 101602 | 4.1% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
n | 305892 | |
a | 228960 | 9.6% |
e | 213012 | 8.9% |
i | 174559 | 7.3% |
l | 169734 | 7.1% |
o | 150446 | 6.3% |
t | 143854 | 6.0% |
r | 122719 | 5.1% |
s | 79767 | 3.3% |
g | 76065 | 3.2% |
Other values (37) | 726416 |
Common
Value | Count | Frequency (%) |
101602 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2493026 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
n | 305892 | 12.3% |
a | 228960 | 9.2% |
e | 213012 | 8.5% |
i | 174559 | 7.0% |
l | 169734 | 6.8% |
o | 150446 | 6.0% |
t | 143854 | 5.8% |
r | 122719 | 4.9% |
101602 | 4.1% | |
s | 79767 | 3.2% |
Other values (38) | 802481 |
Zipcode
Real number (ℝ)
Distinct | 93601 |
---|---|
Distinct (%) | 31.8% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 50286.171 |
Minimum | 501 |
---|---|
Maximum | 99949 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 501 |
---|---|
5-th percentile | 4794 |
Q1 | 25403 |
median | 50585 |
Q3 | 75249 |
95-th percentile | 95730.75 |
Maximum | 99949 |
Range | 99448 |
Interquartile range (IQR) | 49846 |
Descriptive statistics
Standard deviation | 28976.865 |
---|---|
Coefficient of variation (CV) | 0.57623923 |
Kurtosis | -1.1955242 |
Mean | 50286.171 |
Median Absolute Deviation (MAD) | 24949 |
Skewness | -0.010316388 |
Sum | 1.4797511 × 1010 |
Variance | 8.3965869 × 108 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
68029 | 22 | < 0.1% |
2891 | 20 | < 0.1% |
2826 | 20 | < 0.1% |
68005 | 19 | < 0.1% |
68023 | 19 | < 0.1% |
2899 | 19 | < 0.1% |
68069 | 19 | < 0.1% |
68062 | 18 | < 0.1% |
68048 | 18 | < 0.1% |
68113 | 18 | < 0.1% |
Other values (93591) | 294074 |
Value | Count | Frequency (%) |
501 | 2 | |
502 | 1 | < 0.1% |
503 | 1 | < 0.1% |
504 | 1 | < 0.1% |
505 | 2 | |
507 | 2 | |
509 | 3 | |
510 | 2 | |
511 | 2 | |
512 | 2 |
Value | Count | Frequency (%) |
99949 | 3 | |
99948 | 5 | |
99947 | 4 | |
99946 | 2 | < 0.1% |
99945 | 5 | |
99944 | 6 | |
99943 | 5 | |
99942 | 5 | |
99941 | 5 | |
99940 | 6 |
Country
Categorical
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.1 MiB |
USA | |
---|---|
UK | |
Germany | |
Australia | |
Canada |
Length
Max length | 9 |
---|---|
Median length | 7 |
Mean length | 4.843057 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Germany |
---|---|
2nd row | UK |
3rd row | Australia |
4th row | Canada |
5th row | UK |
Common Values
Value | Count | Frequency (%) |
USA | 92918 | |
UK | 61470 | |
Germany | 51492 | |
Australia | 44231 | |
Canada | 44155 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
usa | 92918 | |
uk | 61470 | |
germany | 51492 | |
australia | 44231 | |
canada | 44155 |
Most occurring characters
Value | Count | Frequency (%) |
a | 272419 | |
U | 154388 | |
A | 137149 | 9.6% |
r | 95723 | 6.7% |
n | 95647 | 6.7% |
S | 92918 | 6.5% |
K | 61470 | 4.3% |
G | 51492 | 3.6% |
e | 51492 | 3.6% |
m | 51492 | 3.6% |
Other values (8) | 360957 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 883575 | |
Uppercase Letter | 541572 |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
a | 272419 | |
r | 95723 | 10.8% |
n | 95647 | 10.8% |
e | 51492 | 5.8% |
m | 51492 | 5.8% |
y | 51492 | 5.8% |
u | 44231 | 5.0% |
s | 44231 | 5.0% |
t | 44231 | 5.0% |
l | 44231 | 5.0% |
Other values (2) | 88386 | 10.0% |
Uppercase Letter
Value | Count | Frequency (%) |
U | 154388 | |
A | 137149 | |
S | 92918 | |
K | 61470 | 11.4% |
G | 51492 | 9.5% |
C | 44155 | 8.2% |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1425147 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
a | 272419 | |
U | 154388 | |
A | 137149 | 9.6% |
r | 95723 | 6.7% |
n | 95647 | 6.7% |
S | 92918 | 6.5% |
K | 61470 | 4.3% |
G | 51492 | 3.6% |
e | 51492 | 3.6% |
m | 51492 | 3.6% |
Other values (8) | 360957 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1425147 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
a | 272419 | |
U | 154388 | |
A | 137149 | 9.6% |
r | 95723 | 6.7% |
n | 95647 | 6.7% |
S | 92918 | 6.5% |
K | 61470 | 4.3% |
G | 51492 | 3.6% |
e | 51492 | 3.6% |
m | 51492 | 3.6% |
Other values (8) | 360957 |
Age
Real number (ℝ)
Distinct | 53 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 35.464906 |
Minimum | 18 |
---|---|
Maximum | 70 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 18 |
---|---|
5-th percentile | 19 |
Q1 | 22 |
median | 32 |
Q3 | 46 |
95-th percentile | 65 |
Maximum | 70 |
Range | 52 |
Interquartile range (IQR) | 24 |
Descriptive statistics
Standard deviation | 15.017996 |
---|---|
Coefficient of variation (CV) | 0.42346077 |
Kurtosis | -0.80549695 |
Mean | 35.464906 |
Median Absolute Deviation (MAD) | 12 |
Skewness | 0.6543886 |
Sum | 10436116 |
Variance | 225.54022 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20 | 33765 | 11.5% |
46 | 29874 | 10.2% |
26 | 24139 | 8.2% |
22 | 22450 | 7.6% |
34 | 20188 | 6.9% |
23 | 17631 | 6.0% |
19 | 16474 | 5.6% |
21 | 7871 | 2.7% |
24 | 6032 | 2.0% |
55 | 5324 | 1.8% |
Other values (43) | 110518 |
Value | Count | Frequency (%) |
18 | 2427 | 0.8% |
19 | 16474 | |
20 | 33765 | |
21 | 7871 | 2.7% |
22 | 22450 | |
23 | 17631 | |
24 | 6032 | 2.0% |
25 | 2510 | 0.9% |
26 | 24139 | |
27 | 2509 | 0.9% |
Value | Count | Frequency (%) |
70 | 2662 | |
69 | 2508 | |
68 | 2582 | |
67 | 2478 | |
66 | 2426 | |
65 | 2556 | |
64 | 2576 | |
63 | 2499 | |
62 | 2547 | |
61 | 2520 |
Gender
Categorical
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.1 MiB |
Male | |
---|---|
Female |
Length
Max length | 6 |
---|---|
Median length | 4 |
Mean length | 4.7563021 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Male |
---|---|
2nd row | Female |
3rd row | Male |
4th row | Male |
5th row | Male |
Common Values
Value | Count | Frequency (%) |
Male | 182989 | |
Female | 111277 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
male | 182989 | |
female | 111277 |
Most occurring characters
Value | Count | Frequency (%) |
e | 405543 | |
a | 294266 | |
l | 294266 | |
M | 182989 | |
F | 111277 | 8.0% |
m | 111277 | 8.0% |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1105352 | |
Uppercase Letter | 294266 | 21.0% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 405543 | |
a | 294266 | |
l | 294266 | |
m | 111277 | 10.1% |
Uppercase Letter
Value | Count | Frequency (%) |
M | 182989 | |
F | 111277 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1399618 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 405543 | |
a | 294266 | |
l | 294266 | |
M | 182989 | |
F | 111277 | 8.0% |
m | 111277 | 8.0% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1399618 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 405543 | |
a | 294266 | |
l | 294266 | |
M | 182989 | |
F | 111277 | 8.0% |
m | 111277 | 8.0% |
Income
Categorical
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.0 MiB |
Medium | |
---|---|
Low | |
High |
Length
Max length | 6 |
---|---|
Median length | 4 |
Mean length | 4.544735 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Low |
---|---|
2nd row | Low |
3rd row | Low |
4th row | High |
5th row | Low |
Common Values
Value | Count | Frequency (%) |
Medium | 127046 | |
Low | 93795 | |
High | 73425 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
medium | 127046 | |
low | 93795 | |
high | 73425 |
Most occurring characters
Value | Count | Frequency (%) |
i | 200471 | |
M | 127046 | |
e | 127046 | |
d | 127046 | |
u | 127046 | |
m | 127046 | |
L | 93795 | |
o | 93795 | |
w | 93795 | |
H | 73425 | 5.5% |
Other values (2) | 146850 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1043095 | |
Uppercase Letter | 294266 | 22.0% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
i | 200471 | |
e | 127046 | |
d | 127046 | |
u | 127046 | |
m | 127046 | |
o | 93795 | |
w | 93795 | |
g | 73425 | 7.0% |
h | 73425 | 7.0% |
Uppercase Letter
Value | Count | Frequency (%) |
M | 127046 | |
L | 93795 | |
H | 73425 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1337361 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
i | 200471 | |
M | 127046 | |
e | 127046 | |
d | 127046 | |
u | 127046 | |
m | 127046 | |
L | 93795 | |
o | 93795 | |
w | 93795 | |
H | 73425 | 5.5% |
Other values (2) | 146850 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1337361 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
i | 200471 | |
M | 127046 | |
e | 127046 | |
d | 127046 | |
u | 127046 | |
m | 127046 | |
L | 93795 | |
o | 93795 | |
w | 93795 | |
H | 73425 | 5.5% |
Other values (2) | 146850 |
Customer_Segment
Categorical
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.4 MiB |
Regular | |
---|---|
New | |
Premium |
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 5.7920181 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Regular |
---|---|
2nd row | Premium |
3rd row | Regular |
4th row | Premium |
5th row | Premium |
Common Values
Value | Count | Frequency (%) |
Regular | 142721 | |
New | 88867 | |
Premium | 62678 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
regular | 142721 | |
new | 88867 | |
premium | 62678 |
Most occurring characters
Value | Count | Frequency (%) |
e | 294266 | |
u | 205399 | |
r | 205399 | |
R | 142721 | |
g | 142721 | |
l | 142721 | |
a | 142721 | |
m | 125356 | |
N | 88867 | 5.2% |
w | 88867 | 5.2% |
Other values (2) | 125356 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1410128 | |
Uppercase Letter | 294266 | 17.3% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 294266 | |
u | 205399 | |
r | 205399 | |
g | 142721 | |
l | 142721 | |
a | 142721 | |
m | 125356 | |
w | 88867 | 6.3% |
i | 62678 | 4.4% |
Uppercase Letter
Value | Count | Frequency (%) |
R | 142721 | |
N | 88867 | |
P | 62678 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1704394 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 294266 | |
u | 205399 | |
r | 205399 | |
R | 142721 | |
g | 142721 | |
l | 142721 | |
a | 142721 | |
m | 125356 | |
N | 88867 | 5.2% |
w | 88867 | 5.2% |
Other values (2) | 125356 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1704394 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 294266 | |
u | 205399 | |
r | 205399 | |
R | 142721 | |
g | 142721 | |
l | 142721 | |
a | 142721 | |
m | 125356 | |
N | 88867 | 5.2% |
w | 88867 | 5.2% |
Other values (2) | 125356 |
Date
Date
Distinct | 366 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.2 MiB |
Minimum | 2023-03-01 00:00:00 |
---|---|
Maximum | 2024-02-29 00:00:00 |
Invalid dates | 0 |
Invalid dates (%) | 0.0% |
Year
Categorical
High correlation 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.4 MiB |
2023.0 | |
---|---|
2024.0 |
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2023.0 |
---|---|
2nd row | 2023.0 |
3rd row | 2023.0 |
4th row | 2023.0 |
5th row | 2024.0 |
Common Values
Value | Count | Frequency (%) |
2023.0 | 245676 | |
2024.0 | 48590 | 16.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2023.0 | 245676 | |
2024.0 | 48590 | 16.5% |
Most occurring characters
Value | Count | Frequency (%) |
2 | 588532 | |
0 | 588532 | |
. | 294266 | |
3 | 245676 | |
4 | 48590 | 2.8% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 1471330 | |
Other Punctuation | 294266 | 16.7% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
2 | 588532 | |
0 | 588532 | |
3 | 245676 | |
4 | 48590 | 3.3% |
Other Punctuation
Value | Count | Frequency (%) |
. | 294266 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 1765596 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
2 | 588532 | |
0 | 588532 | |
. | 294266 | |
3 | 245676 | |
4 | 48590 | 2.8% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1765596 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
2 | 588532 | |
0 | 588532 | |
. | 294266 | |
3 | 245676 | |
4 | 48590 | 2.8% |
Month
Categorical
High correlation 
Distinct | 12 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.4 MiB |
April | |
---|---|
January | |
August | |
July | |
May | |
Other values (7) |
Length
Max length | 9 |
---|---|
Median length | 7 |
Mean length | 5.9327989 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | September |
---|---|
2nd row | December |
3rd row | April |
4th row | May |
5th row | January |
Common Values
Value | Count | Frequency (%) |
April | 40263 | |
January | 36460 | |
August | 32149 | |
July | 30101 | |
May | 27624 | |
March | 18678 | |
October | 18655 | |
December | 18477 | |
September | 18189 | |
November | 17943 | |
Other values (2) | 35727 |
Length
Value | Count | Frequency (%) |
april | 40263 | |
january | 36460 | |
august | 32149 | |
july | 30101 | |
may | 27624 | |
march | 18678 | |
october | 18655 | |
december | 18477 | |
september | 18189 | |
november | 17943 | |
Other values (2) | 35727 |
Most occurring characters
Value | Count | Frequency (%) |
r | 204251 | 11.7% |
e | 200266 | 11.5% |
u | 166586 | 9.5% |
a | 137015 | 7.8% |
y | 111978 | 6.4% |
b | 91057 | 5.2% |
J | 84495 | 4.8% |
A | 72412 | 4.1% |
l | 70364 | 4.0% |
t | 68993 | 4.0% |
Other values (16) | 538404 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1451555 | |
Uppercase Letter | 294266 | 16.9% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
r | 204251 | |
e | 200266 | |
u | 166586 | |
a | 137015 | |
y | 111978 | 7.7% |
b | 91057 | 6.3% |
l | 70364 | 4.8% |
t | 68993 | 4.8% |
p | 58452 | 4.0% |
c | 55810 | 3.8% |
Other values (8) | 286783 |
Uppercase Letter
Value | Count | Frequency (%) |
J | 84495 | |
A | 72412 | |
M | 46302 | |
O | 18655 | 6.3% |
D | 18477 | 6.3% |
S | 18189 | 6.2% |
N | 17943 | 6.1% |
F | 17793 | 6.0% |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1745821 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
r | 204251 | 11.7% |
e | 200266 | 11.5% |
u | 166586 | 9.5% |
a | 137015 | 7.8% |
y | 111978 | 6.4% |
b | 91057 | 5.2% |
J | 84495 | 4.8% |
A | 72412 | 4.1% |
l | 70364 | 4.0% |
t | 68993 | 4.0% |
Other values (16) | 538404 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1745821 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
r | 204251 | 11.7% |
e | 200266 | 11.5% |
u | 166586 | 9.5% |
a | 137015 | 7.8% |
y | 111978 | 6.4% |
b | 91057 | 5.2% |
J | 84495 | 4.8% |
A | 72412 | 4.1% |
l | 70364 | 4.0% |
t | 68993 | 4.0% |
Other values (16) | 538404 |
Time
Date
Distinct | 83446 |
---|---|
Distinct (%) | 28.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 2.2 MiB |
Minimum | 2025-09-11 00:00:00 |
---|---|
Maximum | 2025-09-11 23:59:59 |
Invalid dates | 0 |
Invalid dates (%) | 0.0% |
Total_Purchases
Real
number (ℝ)
High correlation 
Distinct | 10 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 5.3597493 |
Minimum | 1 |
---|---|
Maximum | 10 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 1 |
Q1 | 3 |
median | 5 |
Q3 | 8 |
95-th percentile | 10 |
Maximum | 10 |
Range | 9 |
Interquartile range (IQR) | 5 |
Descriptive statistics
Standard deviation | 2.8684169 |
---|---|
Coefficient of variation (CV) | 0.53517744 |
Kurtosis | -1.2164131 |
Mean | 5.3597493 |
Median Absolute Deviation (MAD) | 2 |
Skewness | 0.072392289 |
Sum | 1577192 |
Variance | 8.2278158 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
5 | 31152 | |
3 | 31119 | |
2 | 31116 | |
1 | 31094 | |
4 | 30813 | |
8 | 28000 | |
6 | 27811 | |
9 | 27789 | |
7 | 27730 | |
10 | 27642 |
Value | Count | Frequency (%) |
1 | 31094 | |
2 | 31116 | |
3 | 31119 | |
4 | 30813 | |
5 | 31152 | |
6 | 27811 | |
7 | 27730 | |
8 | 28000 | |
9 | 27789 | |
10 | 27642 |
Value | Count | Frequency (%) |
10 | 27642 | |
9 | 27789 | |
8 | 28000 | |
7 | 27730 | |
6 | 27811 | |
5 | 31152 | |
4 | 30813 | |
3 | 31119 | |
2 | 31116 | |
1 | 31094 |
Amount
Real number (ℝ)
High correlation 
Distinct | 291968 |
---|---|
Distinct (%) | 99.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 255.15457 |
Minimum | 10.000219 |
---|---|
Maximum | 499.99791 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 10.000219 |
---|---|
5-th percentile | 34.372815 |
Q1 | 132.84523 |
median | 255.45992 |
Q3 | 377.63719 |
95-th percentile | 475.59507 |
Maximum | 499.99791 |
Range | 489.99769 |
Interquartile range (IQR) | 244.79195 |
Descriptive statistics
Standard deviation | 141.39032 |
---|---|
Coefficient of variation (CV) | 0.55413596 |
Kurtosis | -1.1985938 |
Mean | 255.15457 |
Median Absolute Deviation (MAD) | 122.4145 |
Skewness | -0.0021230239 |
Sum | 75083316 |
Variance | 19991.224 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
429.1301809 | 2 | < 0.1% |
132.0189587 | 2 | < 0.1% |
211.2883556 | 2 | < 0.1% |
121.1225448 | 2 | < 0.1% |
130.459304 | 2 | < 0.1% |
186.1022091 | 2 | < 0.1% |
254.3104478 | 2 | < 0.1% |
157.2364982 | 2 | < 0.1% |
255.2514394 | 2 | < 0.1% |
457.7330586 | 2 | < 0.1% |
Other values (291958) | 294246 |
Value | Count | Frequency (%) |
10.00021923 | 1 | |
10.00075279 | 1 | |
10.00374959 | 1 | |
10.00610943 | 1 | |
10.00676942 | 1 | |
10.00693081 | 1 | |
10.0089709 | 1 | |
10.01000385 | 1 | |
10.01133597 | 1 | |
10.01160326 | 1 |
Value | Count | Frequency (%) |
499.997911 | 1 | |
499.9970238 | 1 | |
499.9966805 | 1 | |
499.995511 | 1 | |
499.9938845 | 1 | |
499.9893306 | 1 | |
499.9890825 | 1 | |
499.9883822 | 1 | |
499.9763531 | 1 | |
499.9756795 | 1 |
Total_Amount
Real
number (ℝ)
High correlation 
Distinct | 291971 |
---|---|
Distinct (%) | 99.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1367.6375 |
Minimum | 10.00375 |
---|---|
Maximum | 4999.6258 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 2.2 MiB |
Quantile statistics
Minimum | 10.00375 |
---|---|
5-th percentile | 114.80922 |
Q1 | 438.79323 |
median | 1041.1694 |
Q3 | 2028.9568 |
95-th percentile | 3689.8732 |
Maximum | 4999.6258 |
Range | 4989.622 |
Interquartile range (IQR) | 1590.1636 |
Descriptive statistics
Standard deviation | 1128.8728 |
---|---|
Coefficient of variation (CV) | 0.82541808 |
Kurtosis | 0.17504498 |
Mean | 1367.6375 |
Median Absolute Deviation (MAD) | 701.6355 |
Skewness | 0.97290504 |
Sum | 4.0244923 × 108 |
Variance | 1274353.7 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
812.8175565 | 2 | < 0.1% |
3893.424561 | 2 | < 0.1% |
4180.46868 | 2 | < 0.1% |
2115.765127 | 2 | < 0.1% |
264.798718 | 2 | < 0.1% |
1318.898194 | 2 | < 0.1% |
989.9091955 | 2 | < 0.1% |
292.5440492 | 2 | < 0.1% |
41.31672915 | 2 | < 0.1% |
1094.293599 | 2 | < 0.1% |
Other values (291961) | 294246 |
Value | Count | Frequency (%) |
10.00374959 | 1 | |
10.01133597 | 1 | |
10.05635304 | 1 | |
10.06326938 | 1 | |
10.06815366 | 1 | |
10.09296593 | 1 | |
10.13350038 | 1 | |
10.13641713 | 1 | |
10.17207819 | 1 | |
10.19883003 | 1 |
Value | Count | Frequency (%) |
4999.625796 | 1 | |
4999.340097 | 1 | |
4999.171428 | 1 | |
4998.723479 | 1 | |
4998.603558 | 1 | |
4998.473906 | 1 | |
4998.306569 | 1 | |
4998.204389 | 1 | |
4997.986042 | 1 | |
4997.933548 | 1 |
Product_Category
Categorical
High correlation 
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 16.1 MiB |
Electronics | |
---|---|
Grocery | |
Clothing | |
Books | |
Home Decor |
Length
Max length | 11 |
---|---|
Median length | 8 |
Mean length | 8.3035553 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Clothing |
---|---|
2nd row | Electronics |
3rd row | Books |
4th row | Home Decor |
5th row | Grocery |
Common Values
Value | Count | Frequency (%) |
Electronics | 69425 | |
Grocery | 65208 | |
Clothing | 53361 | |
Books | 53257 | |
Home Decor | 53015 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
electronics | 69425 | |
grocery | 65208 | |
clothing | 53361 | |
books | 53257 | |
home | 53015 | |
decor | 53015 |
Most occurring characters
Value | Count | Frequency (%) |
o | 400538 | |
c | 257073 | |
r | 252856 | |
e | 240663 | 9.8% |
l | 122786 | 5.0% |
n | 122786 | 5.0% |
t | 122786 | 5.0% |
i | 122786 | 5.0% |
s | 122682 | 5.0% |
E | 69425 | 2.8% |
Other values (11) | 609073 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 2043158 | |
Uppercase Letter | 347281 | 14.2% |
Space Separator | 53015 | 2.2% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
o | 400538 | |
c | 257073 | |
r | 252856 | |
e | 240663 | |
l | 122786 | 6.0% |
n | 122786 | 6.0% |
t | 122786 | 6.0% |
i | 122786 | 6.0% |
s | 122682 | 6.0% |
y | 65208 | 3.2% |
Other values (4) | 212994 |
Uppercase Letter
Value | Count | Frequency (%) |
E | 69425 | |
G | 65208 | |
C | 53361 | |
B | 53257 | |
H | 53015 | |
D | 53015 |
Space Separator
Value | Count | Frequency (%) |
53015 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2390439 | |
Common | 53015 | 2.2% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
o | 400538 | |
c | 257073 | |
r | 252856 | |
e | 240663 | |
l | 122786 | 5.1% |
n | 122786 | 5.1% |
t | 122786 | 5.1% |
i | 122786 | 5.1% |
s | 122682 | 5.1% |
E | 69425 | 2.9% |
Other values (10) | 556058 |
Common
Value | Count | Frequency (%) |
53015 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2443454 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
o | 400538 | |
c | 257073 | |
r | 252856 | |
e | 240663 | 9.8% |
l | 122786 | 5.0% |
n | 122786 | 5.0% |
t | 122786 | 5.0% |
i | 122786 | 5.0% |
s | 122682 | 5.0% |
E | 69425 | 2.8% |
Other values (11) | 609073 |
Product_Brand
Categorical
High correlation 
Distinct | 18 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 16.0 MiB |
Pepsi | |
---|---|
Coca-Cola | 17965 |
HarperCollins | 17918 |
Zara | 17901 |
Samsung | 17879 |
Other values (13) |
Length
Max length | 17 |
---|---|
Median length | 12 |
Mean length | 7.8918462 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Nike |
---|---|
2nd row | Samsung |
3rd row | Penguin Books |
4th row | Home Depot |
5th row | Nestle |
Common Values
Value | Count | Frequency (%) |
Pepsi | 29577 | 10.1% |
Coca-Cola | 17965 | 6.1% |
HarperCollins | 17918 | 6.1% |
Zara | 17901 | 6.1% |
Samsung | 17879 | 6.1% |
Sony | 17864 | 6.1% |
Adidas | 17791 | 6.0% |
Bed Bath & Beyond | 17775 | 6.0% |
Home Depot | 17698 | 6.0% |
Random House | 17696 | 6.0% |
Other values (8) | 104202 |
Length
Value | Count | Frequency (%) |
pepsi | 29577 | 7.4% |
coca-cola | 17965 | 4.5% |
harpercollins | 17918 | 4.5% |
zara | 17901 | 4.5% |
samsung | 17879 | 4.5% |
sony | 17864 | 4.5% |
adidas | 17791 | 4.4% |
bed | 17775 | 4.4% |
bath | 17775 | 4.4% |
17775 | 4.4% | |
Other values (14) | 210408 |
Most occurring characters
Value | Count | Frequency (%) |
e | 233878 | 10.1% |
o | 210145 | 9.0% |
a | 163001 | 7.0% |
s | 149340 | 6.4% |
i | 127645 | 5.5% |
n | 124418 | 5.4% |
p | 107675 | 4.6% |
106362 | 4.6% | |
l | 98564 | 4.2% |
d | 88828 | 3.8% |
Other values (27) | 912446 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1706628 | |
Uppercase Letter | 473572 | 20.4% |
Space Separator | 106362 | 4.6% |
Dash Punctuation | 17965 | 0.8% |
Other Punctuation | 17775 | 0.8% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 233878 | |
o | 210145 | |
a | 163001 | |
s | 149340 | |
i | 127645 | 7.5% |
n | 124418 | 7.3% |
p | 107675 | 6.3% |
l | 98564 | 5.8% |
d | 88828 | 5.2% |
r | 63239 | 3.7% |
Other values (9) | 339895 |
Uppercase Letter
Value | Count | Frequency (%) |
B | 73178 | |
C | 53848 | |
H | 53312 | |
A | 52928 | |
P | 47220 | |
S | 37953 | |
N | 35335 | |
Z | 17901 | 3.8% |
D | 17698 | 3.7% |
R | 17696 | 3.7% |
Other values (5) | 66503 |
Space Separator
Value | Count | Frequency (%) |
106362 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 17965 |
Other Punctuation
Value | Count | Frequency (%) |
& | 17775 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2180200 | |
Common | 142102 | 6.1% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 233878 | 10.7% |
o | 210145 | 9.6% |
a | 163001 | 7.5% |
s | 149340 | 6.8% |
i | 127645 | 5.9% |
n | 124418 | 5.7% |
p | 107675 | 4.9% |
l | 98564 | 4.5% |
d | 88828 | 4.1% |
B | 73178 | 3.4% |
Other values (24) | 803528 |
Common
Value | Count | Frequency (%) |
106362 | ||
- | 17965 | 12.6% |
& | 17775 | 12.5% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2322302 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 233878 | 10.1% |
o | 210145 | 9.0% |
a | 163001 | 7.0% |
s | 149340 | 6.4% |
i | 127645 | 5.5% |
n | 124418 | 5.4% |
p | 107675 | 4.6% |
106362 | 4.6% | |
l | 98564 | 4.2% |
d | 88828 | 3.8% |
Other values (27) | 912446 |
Product_Type
Categorical
High correlation 
Distinct | 33 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 16.0 MiB |
Water | |
---|---|
Smartphone | 17951 |
Non-Fiction | 17697 |
Fiction | 17561 |
Juice | 11932 |
Other values (28) |
Length
Max length | 34 |
---|---|
Median length | 10 |
Mean length | 8.1726125 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Shorts |
---|---|
2nd row | Tablet |
3rd row | Children's |
4th row | Tools |
5th row | Chocolate |
Common Values
Value | Count | Frequency (%) |
Water | 23872 | 8.1% |
Smartphone | 17951 | 6.1% |
Non-Fiction | 17697 | 6.0% |
Fiction | 17561 | 6.0% |
Juice | 11932 | 4.1% |
T-shirt | 11887 | 4.0% |
Television | 11880 | 4.0% |
Decorations | 11855 | 4.0% |
Shoes | 11829 | 4.0% |
Tablet | 11764 | 4.0% |
Other values (23) | 146038 |
Length
Value | Count | Frequency (%) |
water | 23872 | 6.9% |
smartphone | 17951 | 5.2% |
non-fiction | 17697 | 5.1% |
fiction | 17561 | 5.1% |
juice | 11932 | 3.4% |
t-shirt | 11887 | 3.4% |
television | 11880 | 3.4% |
decorations | 11855 | 3.4% |
shoes | 11829 | 3.4% |
tablet | 11764 | 3.4% |
Other values (30) | 199496 |
Most occurring characters
Value | Count | Frequency (%) |
i | 234709 | 9.8% |
e | 217540 | 9.0% |
t | 217067 | 9.0% |
o | 195453 | 8.1% |
r | 170473 | 7.1% |
n | 166078 | 6.9% |
a | 121211 | 5.0% |
s | 107844 | 4.5% |
h | 101878 | 4.2% |
c | 82585 | 3.4% |
Other values (31) | 790084 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1926310 | |
Uppercase Letter | 363256 | 15.1% |
Space Separator | 53458 | 2.2% |
Dash Punctuation | 29584 | 1.2% |
Decimal Number | 19755 | 0.8% |
Other Punctuation | 12559 | 0.5% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
i | 234709 | |
e | 217540 | |
t | 217067 | |
o | 195453 | |
r | 170473 | |
n | 166078 | |
a | 121211 | 6.3% |
s | 107844 | 5.6% |
h | 101878 | 5.3% |
c | 82585 | 4.3% |
Other values (10) | 311472 |
Uppercase Letter
Value | Count | Frequency (%) |
S | 74499 | |
F | 54234 | |
T | 54020 | |
D | 29556 | 8.1% |
C | 26706 | 7.4% |
W | 23872 | 6.6% |
J | 23742 | 6.5% |
N | 17697 | 4.9% |
L | 17644 | 4.9% |
B | 13935 | 3.8% |
Other values (4) | 27351 | 7.5% |
Decimal Number
Value | Count | Frequency (%) |
5 | 6585 | |
1 | 6585 | |
3 | 6585 |
Other Punctuation
Value | Count | Frequency (%) |
. | 6585 | |
' | 5974 |
Space Separator
Value | Count | Frequency (%) |
53458 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 29584 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2289566 | |
Common | 115356 | 4.8% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
i | 234709 | 10.3% |
e | 217540 | 9.5% |
t | 217067 | 9.5% |
o | 195453 | 8.5% |
r | 170473 | 7.4% |
n | 166078 | 7.3% |
a | 121211 | 5.3% |
s | 107844 | 4.7% |
h | 101878 | 4.4% |
c | 82585 | 3.6% |
Other values (24) | 674728 |
Common
Value | Count | Frequency (%) |
53458 | ||
- | 29584 | |
5 | 6585 | 5.7% |
. | 6585 | 5.7% |
1 | 6585 | 5.7% |
3 | 6585 | 5.7% |
' | 5974 | 5.2% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2404922 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
i | 234709 | 9.8% |
e | 217540 | 9.0% |
t | 217067 | 9.0% |
o | 195453 | 8.1% |
r | 170473 | 7.1% |
n | 166078 | 6.9% |
a | 121211 | 5.0% |
s | 107844 | 4.5% |
h | 101878 | 4.2% |
c | 82585 | 3.4% |
Other values (31) | 790084 |
Feedback
Categorical
High correlation 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.5 MiB |
Excellent | |
---|---|
Good | |
Average | |
Bad |
Length
Max length | 9 |
---|---|
Median length | 7 |
Mean length | 6.1470574 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Excellent |
---|---|
2nd row | Excellent |
3rd row | Average |
4th row | Excellent |
5th row | Bad |
Common Values
Value | Count | Frequency (%) |
Excellent | 98150 | |
Good | 92796 | |
Average | 61094 | |
Bad | 42226 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
excellent | 98150 | |
good | 92796 | |
average | 61094 | |
bad | 42226 |
Most occurring characters
Value | Count | Frequency (%) |
e | 318488 | |
l | 196300 | |
o | 185592 | |
d | 135022 | 7.5% |
a | 103320 | 5.7% |
c | 98150 | 5.4% |
x | 98150 | 5.4% |
E | 98150 | 5.4% |
n | 98150 | 5.4% |
t | 98150 | 5.4% |
Other values (6) | 379398 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1514604 | |
Uppercase Letter | 294266 | 16.3% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 318488 | |
l | 196300 | |
o | 185592 | |
d | 135022 | |
a | 103320 | 6.8% |
c | 98150 | 6.5% |
x | 98150 | 6.5% |
n | 98150 | 6.5% |
t | 98150 | 6.5% |
v | 61094 | 4.0% |
Other values (2) | 122188 | 8.1% |
Uppercase Letter
Value | Count | Frequency (%) |
E | 98150 | |
G | 92796 | |
A | 61094 | |
B | 42226 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 1808870 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 318488 | |
l | 196300 | |
o | 185592 | |
d | 135022 | 7.5% |
a | 103320 | 5.7% |
c | 98150 | 5.4% |
x | 98150 | 5.4% |
E | 98150 | 5.4% |
n | 98150 | 5.4% |
t | 98150 | 5.4% |
Other values (6) | 379398 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 1808870 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 318488 | |
l | 196300 | |
o | 185592 | |
d | 135022 | 7.5% |
a | 103320 | 5.7% |
c | 98150 | 5.4% |
x | 98150 | 5.4% |
E | 98150 | 5.4% |
n | 98150 | 5.4% |
t | 98150 | 5.4% |
Other values (6) | 379398 |
Shipping_Method
Categorical
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 15.9 MiB |
Same-Day | |
---|---|
Express | |
Standard |
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 7.6611161 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Same-Day |
---|---|
2nd row | Standard |
3rd row | Same-Day |
4th row | Standard |
5th row | Standard |
Common Values
Value | Count | Frequency (%) |
Same-Day | 101653 | |
Express | 99722 | |
Standard | 92891 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
same-day | 101653 | |
express | 99722 | |
standard | 92891 |
Most occurring characters
Value | Count | Frequency (%) |
a | 389088 | |
e | 201375 | |
s | 199444 | |
S | 194544 | |
r | 192613 | 8.5% |
d | 185782 | 8.2% |
m | 101653 | 4.5% |
y | 101653 | 4.5% |
D | 101653 | 4.5% |
- | 101653 | 4.5% |
Other values (5) | 484948 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1756834 | |
Uppercase Letter | 395919 | 17.6% |
Dash Punctuation | 101653 | 4.5% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
a | 389088 | |
e | 201375 | |
s | 199444 | |
r | 192613 | |
d | 185782 | |
m | 101653 | 5.8% |
y | 101653 | 5.8% |
p | 99722 | 5.7% |
x | 99722 | 5.7% |
t | 92891 | 5.3% |
Uppercase Letter
Value | Count | Frequency (%) |
S | 194544 | |
D | 101653 | |
E | 99722 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 101653 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2152753 | |
Common | 101653 | 4.5% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
a | 389088 | |
e | 201375 | |
s | 199444 | |
S | 194544 | |
r | 192613 | |
d | 185782 | |
m | 101653 | 4.7% |
y | 101653 | 4.7% |
D | 101653 | 4.7% |
E | 99722 | 4.6% |
Other values (4) | 385226 |
Common
Value | Count | Frequency (%) |
- | 101653 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2254406 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
a | 389088 | |
e | 201375 | |
s | 199444 | |
S | 194544 | |
r | 192613 | 8.5% |
d | 185782 | 8.2% |
m | 101653 | 4.5% |
y | 101653 | 4.5% |
D | 101653 | 4.5% |
- | 101653 | 4.5% |
Other values (5) | 484948 |
Payment_Method
Categorical
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 16.0 MiB |
Credit Card | |
---|---|
Debit Card | |
Cash | |
PayPal |
Length
Max length | 11 |
---|---|
Median length | 10 |
Mean length | 8.0214126 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Debit Card |
---|---|
2nd row | Credit Card |
3rd row | Credit Card |
4th row | PayPal |
5th row | Cash |
Common Values
Value | Count | Frequency (%) |
Credit Card | 87889 | |
Debit Card | 74847 | |
Cash | 72000 | |
PayPal | 59530 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
card | 162736 | |
credit | 87889 | |
debit | 74847 | |
cash | 72000 | |
paypal | 59530 | 13.0% |
Most occurring characters
Value | Count | Frequency (%) |
a | 353796 | |
C | 322625 | |
r | 250625 | |
d | 250625 | |
e | 162736 | |
t | 162736 | |
i | 162736 | |
162736 | ||
P | 119060 | 5.0% |
b | 74847 | 3.2% |
Other values (5) | 337907 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 1681161 | |
Uppercase Letter | 516532 | 21.9% |
Space Separator | 162736 | 6.9% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
a | 353796 | |
r | 250625 | |
d | 250625 | |
e | 162736 | |
t | 162736 | |
i | 162736 | |
b | 74847 | 4.5% |
s | 72000 | 4.3% |
h | 72000 | 4.3% |
y | 59530 | 3.5% |
Uppercase Letter
Value | Count | Frequency (%) |
C | 322625 | |
P | 119060 | 23.0% |
D | 74847 | 14.5% |
Space Separator
Value | Count | Frequency (%) |
162736 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2197693 | |
Common | 162736 | 6.9% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
a | 353796 | |
C | 322625 | |
r | 250625 | |
d | 250625 | |
e | 162736 | |
t | 162736 | |
i | 162736 | |
P | 119060 | 5.4% |
b | 74847 | 3.4% |
D | 74847 | 3.4% |
Other values (4) | 263060 |
Common
Value | Count | Frequency (%) |
162736 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2360429 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
a | 353796 | |
C | 322625 | |
r | 250625 | |
d | 250625 | |
e | 162736 | |
t | 162736 | |
i | 162736 | |
162736 | ||
P | 119060 | 5.0% |
b | 74847 | 3.2% |
Other values (5) | 337907 |
Order_Status
Categorical
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 16.1 MiB |
Delivered | |
---|---|
Shipped | |
Processing | |
Pending |
Length
Max length | 10 |
---|---|
Median length | 9 |
Mean length | 8.4338931 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Shipped |
---|---|
2nd row | Processing |
3rd row | Processing |
4th row | Processing |
5th row | Shipped |
Common Values
Value | Count | Frequency (%) |
Delivered | 127393 | |
Shipped | 63348 | |
Processing | 55720 | |
Pending | 47805 | 16.2% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
delivered | 127393 | |
shipped | 63348 | |
processing | 55720 | |
pending | 47805 | 16.2% |
Most occurring characters
Value | Count | Frequency (%) |
e | 549052 | |
i | 294266 | |
d | 238546 | |
r | 183113 | 7.4% |
n | 151330 | 6.1% |
l | 127393 | 5.1% |
v | 127393 | 5.1% |
D | 127393 | 5.1% |
p | 126696 | 5.1% |
s | 111440 | 4.5% |
Other values (6) | 445186 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 2187542 | |
Uppercase Letter | 294266 | 11.9% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 549052 | |
i | 294266 | |
d | 238546 | |
r | 183113 | 8.4% |
n | 151330 | 6.9% |
l | 127393 | 5.8% |
v | 127393 | 5.8% |
p | 126696 | 5.8% |
s | 111440 | 5.1% |
g | 103525 | 4.7% |
Other values (3) | 174788 | 8.0% |
Uppercase Letter
Value | Count | Frequency (%) |
D | 127393 | |
P | 103525 | |
S | 63348 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 2481808 |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 549052 | |
i | 294266 | |
d | 238546 | |
r | 183113 | 7.4% |
n | 151330 | 6.1% |
l | 127393 | 5.1% |
v | 127393 | 5.1% |
D | 127393 | 5.1% |
p | 126696 | 5.1% |
s | 111440 | 4.5% |
Other values (6) | 445186 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 2481808 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 549052 | |
i | 294266 | |
d | 238546 | |
r | 183113 | 7.4% |
n | 151330 | 6.1% |
l | 127393 | 5.1% |
v | 127393 | 5.1% |
D | 127393 | 5.1% |
p | 126696 | 5.1% |
s | 111440 | 4.5% |
Other values (6) | 445186 |
Ratings
Categorical
High correlation 
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 14.6 MiB |
4.0 | |
---|---|
2.0 | |
5.0 | |
3.0 | |
1.0 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5.0 |
---|---|
2nd row | 4.0 |
3rd row | 2.0 |
4th row | 4.0 |
5th row | 1.0 |
Common Values
Value | Count | Frequency (%) |
4.0 | 95594 | |
2.0 | 61094 | |
5.0 | 48868 | |
3.0 | 46484 | |
1.0 | 42226 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
4.0 | 95594 | |
2.0 | 61094 | |
5.0 | 48868 | |
3.0 | 46484 | |
1.0 | 42226 |
Most occurring characters
Value | Count | Frequency (%) |
. | 294266 | |
0 | 294266 | |
4 | 95594 | 10.8% |
2 | 61094 | 6.9% |
5 | 48868 | 5.5% |
3 | 46484 | 5.3% |
1 | 42226 | 4.8% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 588532 | |
Other Punctuation | 294266 |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 294266 | |
4 | 95594 | 16.2% |
2 | 61094 | 10.4% |
5 | 48868 | 8.3% |
3 | 46484 | 7.9% |
1 | 42226 | 7.2% |
Other Punctuation
Value | Count | Frequency (%) |
. | 294266 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 882798 |
Most frequent character per script
Common
Value | Count | Frequency (%) |
. | 294266 | |
0 | 294266 | |
4 | 95594 | 10.8% |
2 | 61094 | 6.9% |
5 | 48868 | 5.5% |
3 | 46484 | 5.3% |
1 | 42226 | 4.8% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 882798 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
. | 294266 | |
0 | 294266 | |
4 | 95594 | 10.8% |
2 | 61094 | 6.9% |
5 | 48868 | 5.5% |
3 | 46484 | 5.3% |
1 | 42226 | 4.8% |
Length
Max length | 28 |
---|---|
Median length | 22 |
Mean length | 11.156522 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Cycling shorts |
---|---|
2nd row | Lenovo Tab |
3rd row | Sports equipment |
4th row | Utility knife |
5th row | Chocolate cookies |
Value | Count | Frequency (%) |
water | 23872 | 4.7% |
tv | 13001 | 2.6% |
juice | 11932 | 2.4% |
tee | 10751 | 2.1% |
ac | 8150 | 1.6% |
refrigerator | 7188 | 1.4% |
jeans | 5975 | 1.2% |
dress | 5952 | 1.2% |
headphones | 5921 | 1.2% |
fiction | 5806 | 1.2% |
Other values (371) | 405068 |
Most occurring characters
Value | Count | Frequency (%) |
e | 366048 | 11.1% |
r | 249555 | 7.6% |
a | 232474 | 7.1% |
o | 212932 | 6.5% |
209350 | 6.4% | |
t | 202877 | 6.2% |
i | 200979 | 6.1% |
s | 172132 | 5.2% |
n | 148906 | 4.5% |
l | 148039 | 4.5% |
Other values (44) | 1139693 |
Most occurring categories
Value | Count | Frequency (%) |
Lowercase Letter | 2655099 | |
Uppercase Letter | 395208 | 12.0% |
Space Separator | 209350 | 6.4% |
Dash Punctuation | 22160 | 0.7% |
Decimal Number | 1168 | < 0.1% |
Most frequent character per category
Lowercase Letter
Value | Count | Frequency (%) |
e | 366048 | |
r | 249555 | 9.4% |
a | 232474 | 8.8% |
o | 212932 | 8.0% |
t | 202877 | 7.6% |
i | 200979 | 7.6% |
s | 172132 | 6.5% |
n | 148906 | 5.6% |
l | 148039 | 5.6% |
c | 96798 | 3.6% |
Other values (16) | 624359 |
Uppercase Letter
Value | Count | Frequency (%) |
S | 44404 | |
C | 43907 | |
T | 34260 | 8.7% |
P | 33087 | 8.4% |
A | 27223 | 6.9% |
M | 25645 | 6.5% |
D | 23851 | 6.0% |
B | 23294 | 5.9% |
G | 18969 | 4.8% |
L | 18206 | 4.6% |
Other values (15) | 102362 |
Space Separator
Value | Count | Frequency (%) |
209350 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 22160 |
Decimal Number
Value | Count | Frequency (%) |
4 | 1168 |
Most occurring scripts
Value | Count | Frequency (%) |
Latin | 3050307 | |
Common | 232678 | 7.1% |
Most frequent character per script
Latin
Value | Count | Frequency (%) |
e | 366048 | 12.0% |
r | 249555 | 8.2% |
a | 232474 | 7.6% |
o | 212932 | 7.0% |
t | 202877 | 6.7% |
i | 200979 | 6.6% |
s | 172132 | 5.6% |
n | 148906 | 4.9% |
l | 148039 | 4.9% |
c | 96798 | 3.2% |
Other values (41) | 1019567 |
Common
Value | Count | Frequency (%) |
209350 | ||
- | 22160 | 9.5% |
4 | 1168 | 0.5% |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 3282985 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
e | 366048 | 11.1% |
r | 249555 | 7.6% |
a | 232474 | 7.1% |
o | 212932 | 6.5% |
209350 | 6.4% | |
t | 202877 | 6.2% |
i | 200979 | 6.1% |
s | 172132 | 5.2% |
n | 148906 | 4.5% |
l | 148039 | 4.5% |
Other values (44) | 1139693 |
Interactions
Correlations
Age | Amount | Country | Customer_ID | Customer_Segment | Feedback | Gender | Income | Month | Order_Status | Payment_Method | Product_Brand | Product_Category | Product_Type | Ratings | Shipping_Method | Total_Amount | Total_Purchases | Transaction_ID | Year | Zipcode | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Age | 1.000 | 0.001 | 0.149 | 0.000 | 0.221 | 0.221 | 0.112 | 0.140 | 0.157 | 0.190 | 0.056 | 0.182 | 0.121 | 0.190 | 0.158 | 0.019 | 0.028 | 0.043 | -0.001 | 0.000 | -0.000 |
Amount | 0.001 | 1.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.006 | 0.700 | 0.000 | -0.003 | 0.004 | 0.001 |
Country | 0.149 | 0.000 | 1.000 | 0.002 | 0.082 | 0.054 | 0.019 | 0.166 | 0.076 | 0.040 | 0.021 | 0.071 | 0.044 | 0.077 | 0.039 | 0.007 | 0.000 | 0.003 | 0.000 | 0.000 | 0.033 |
Customer_ID | 0.000 | 0.000 | 0.002 | 1.000 | 0.002 | 0.000 | 0.000 | 0.001 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.003 | 0.004 | 0.005 | 0.000 | -0.002 |
Customer_Segment | 0.221 | 0.000 | 0.082 | 0.002 | 1.000 | 0.078 | 0.029 | 0.119 | 0.137 | 0.125 | 0.033 | 0.102 | 0.025 | 0.103 | 0.075 | 0.008 | 0.000 | 0.004 | 0.004 | 0.000 | 0.000 |
Feedback | 0.221 | 0.003 | 0.054 | 0.000 | 0.078 | 1.000 | 0.038 | 0.049 | 0.128 | 0.057 | 0.064 | 0.196 | 0.077 | 0.203 | 0.913 | 0.018 | 0.002 | 0.001 | 0.000 | 0.000 | 0.002 |
Gender | 0.112 | 0.000 | 0.019 | 0.000 | 0.029 | 0.038 | 1.000 | 0.025 | 0.103 | 0.051 | 0.007 | 0.124 | 0.036 | 0.124 | 0.027 | 0.002 | 0.000 | 0.000 | 0.003 | 0.000 | 0.001 |
Income | 0.140 | 0.002 | 0.166 | 0.001 | 0.119 | 0.049 | 0.025 | 1.000 | 0.131 | 0.047 | 0.018 | 0.033 | 0.012 | 0.035 | 0.048 | 0.005 | 0.002 | 0.000 | 0.004 | 0.000 | 0.000 |
Month | 0.157 | 0.000 | 0.076 | 0.000 | 0.137 | 0.128 | 0.103 | 0.131 | 1.000 | 0.114 | 0.078 | 0.182 | 0.088 | 0.182 | 0.091 | 0.040 | 0.000 | 0.000 | 0.002 | 0.743 | 0.003 |
Order_Status | 0.190 | 0.000 | 0.040 | 0.004 | 0.125 | 0.057 | 0.051 | 0.047 | 0.114 | 1.000 | 0.018 | 0.158 | 0.075 | 0.159 | 0.047 | 0.014 | 0.000 | 0.002 | 0.003 | 0.002 | 0.000 |
Payment_Method | 0.056 | 0.000 | 0.021 | 0.000 | 0.033 | 0.064 | 0.007 | 0.018 | 0.078 | 0.018 | 1.000 | 0.108 | 0.029 | 0.108 | 0.055 | 0.024 | 0.000 | 0.003 | 0.000 | 0.001 | 0.002 |
Product_Brand | 0.182 | 0.000 | 0.071 | 0.000 | 0.102 | 0.196 | 0.124 | 0.033 | 0.182 | 0.158 | 0.108 | 1.000 | 1.000 | 0.842 | 0.139 | 0.093 | 0.002 | 0.000 | 0.000 | 0.004 | 0.001 |
Product_Category | 0.121 | 0.000 | 0.044 | 0.000 | 0.025 | 0.077 | 0.036 | 0.012 | 0.088 | 0.075 | 0.029 | 1.000 | 1.000 | 1.000 | 0.056 | 0.029 | 0.003 | 0.000 | 0.001 | 0.003 | 0.000 |
Product_Type | 0.190 | 0.000 | 0.077 | 0.002 | 0.103 | 0.203 | 0.124 | 0.035 | 0.182 | 0.159 | 0.108 | 0.842 | 1.000 | 1.000 | 0.144 | 0.093 | 0.000 | 0.001 | 0.002 | 0.006 | 0.000 |
Ratings | 0.158 | 0.003 | 0.039 | 0.000 | 0.075 | 0.913 | 0.027 | 0.048 | 0.091 | 0.047 | 0.055 | 0.139 | 0.056 | 0.144 | 1.000 | 0.016 | 0.003 | 0.000 | 0.000 | 0.002 | 0.000 |
Shipping_Method | 0.019 | 0.006 | 0.007 | 0.000 | 0.008 | 0.018 | 0.002 | 0.005 | 0.040 | 0.014 | 0.024 | 0.093 | 0.029 | 0.093 | 0.016 | 1.000 | 0.000 | 0.002 | 0.004 | 0.000 | 0.000 |
Total_Amount | 0.028 | 0.700 | 0.000 | 0.003 | 0.000 | 0.002 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.002 | 0.003 | 0.000 | 0.003 | 0.000 | 1.000 | 0.651 | -0.003 | 0.003 | 0.001 |
Total_Purchases | 0.043 | 0.000 | 0.003 | 0.004 | 0.004 | 0.001 | 0.000 | 0.000 | 0.000 | 0.002 | 0.003 | 0.000 | 0.000 | 0.001 | 0.000 | 0.002 | 0.651 | 1.000 | -0.002 | 0.002 | 0.001 |
Transaction_ID | -0.001 | -0.003 | 0.000 | 0.005 | 0.004 | 0.000 | 0.003 | 0.004 | 0.002 | 0.003 | 0.000 | 0.000 | 0.001 | 0.002 | 0.000 | 0.004 | -0.003 | -0.002 | 1.000 | 0.000 | -0.003 |
Year | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.743 | 0.002 | 0.001 | 0.004 | 0.003 | 0.006 | 0.002 | 0.000 | 0.003 | 0.002 | 0.000 | 1.000 | 0.005 |
Zipcode | -0.000 | 0.001 | 0.033 | -0.002 | 0.000 | 0.002 | 0.001 | 0.000 | 0.003 | 0.000 | 0.002 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 0.001 | -0.003 | 0.005 | 1.000 |
Missing values
Sample
Transaction_ID | Customer_ID | Name | Address | City | State | Zipcode | Country | Age | Gender | Income | Customer_Segment | Date | Year | Month | Time | Total_Purchases | Amount | Total_Amount | Product_Category | Product_Brand | Product_Type | Feedback | Shipping_Method | Payment_Method | Order_Status | Ratings | products | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 8691788.0 | 37249.0 | Michelle Harrington | Ebony39@gmail.com | 3959 Amanda Burgs | Dortmund | Berlin | 77985.0 | Germany | 21.0 | Male | Low | Regular | 9/18/2023 | 2023.0 | September | 22:03:55 | 3.0 | 108.028757 | 324.086270 | Clothing | Nike | Shorts | Excellent | Same-Day | Debit Card | Shipped | 5.0 | Cycling shorts |
1 | 2174773.0 | 69749.0 | Kelsey Hill | Mark36@gmail.com | 82072 Dawn Centers | Nottingham | England | 99071.0 | UK | 19.0 | Female | Low | Premium | 12/31/2023 | 2023.0 | December | 08:42:04 | 2.0 | 403.353907 | 806.707815 | Electronics | Samsung | Tablet | Excellent | Standard | Credit Card | Processing | 4.0 | Lenovo Tab |
2 | 6679610.0 | 30192.0 | Scott Jensen | Shane85@gmail.com | 4133 Young Canyon | Geelong | New South Wales | 75929.0 | Australia | 48.0 | Male | Low | Regular | 4/26/2023 | 2023.0 | April | 04:06:29 | 3.0 | 354.477600 | 1063.432799 | Books | Penguin Books | Children's | Average | Same-Day | Credit Card | Processing | 2.0 | Sports equipment |
3 | 7232460.0 | 62101.0 | Joseph Miller | Mary34@gmail.com | 8148 Thomas Creek Suite 100 | Edmonton | Ontario | 88420.0 | Canada | 56.0 | Male | High | Premium | 05-08-23 | 2023.0 | May | 14:55:17 | 7.0 | 352.407717 | 2466.854021 | Home Decor | Home Depot | Tools | Excellent | Standard | PayPal | Processing | 4.0 | Utility knife |
4 | 4983775.0 | 27901.0 | Debra Coleman | Charles30@gmail.com | 5813 Lori Ports Suite 269 | Bristol | England | 48704.0 | UK | 22.0 | Male | Low | Premium | 01-10-24 | 2024.0 | January | 16:54:07 | 2.0 | 124.276524 | 248.553049 | Grocery | Nestle | Chocolate | Bad | Standard | Cash | Shipped | 1.0 | Chocolate cookies |
5 | 6095326.0 | 41289.0 | Ryan Johnson | Haley12@gmail.com | 532 Ashley Crest Suite 014 | Brisbane | New South Wales | 74430.0 | Australia | 58.0 | Female | Medium | Premium | 9/21/2023 | 2023.0 | September | 23:24:27 | 4.0 | 296.291806 | 1185.167224 | Electronics | Apple | Tablet | Good | Express | PayPal | Pending | 4.0 | Lenovo Tab |
6 | 5434096.0 | 97285.0 | Erin Lewis | Arthur76@gmail.com | 600 Brian Prairie Suite 497 | Kitchener | Ontario | 47545.0 | Canada | 29.0 | Female | Low | New | 6/26/2023 | 2023.0 | June | 13:35:51 | 2.0 | 315.057648 | 630.115295 | Electronics | Samsung | Television | Bad | Standard | Cash | Processing | 1.0 | QLED TV |
7 | 2344675.0 | 26603.0 | Angela Fields | Tanya94@gmail.com | 237 Young Curve | Munich | Berlin | 86862.0 | Germany | 29.0 | Male | Medium | Premium | 3/24/2023 | 2023.0 | March | 10:12:56 | 1.0 | 46.588070 | 46.588070 | Clothing | Zara | Shirt | Bad | Same-Day | Cash | Processing | 1.0 | Dress shirt |
8 | 4155845.0 | 80175.0 | Diane Clark | Martin39@gmail.com | 8823 Mariah Heights Apt. 263 | Wollongong | New South Wales | 39820.0 | Australia | 46.0 | Male | Medium | New | 01-06-24 | 2024.0 | January | 14:38:26 | 8.0 | 328.839302 | 2630.714413 | Grocery | Nestle | Chocolate | Bad | Same-Day | Cash | Delivered | 1.0 | Dark chocolate |
9 | 4926148.0 | 31878.0 | Lori Bell | Jessica33@gmail.com | 6225 William Lodge | Cologne | Berlin | 64317.0 | Germany | 25.0 | Male | Medium | New | 10-04-23 | 2023.0 | October | 22:27:40 | 10.0 | 397.611229 | 3976.112295 | Home Decor | Home Depot | Decorations | Excellent | Standard | Cash | Delivered | 4.0 | Candles |
Transaction_ID | Customer_ID | Name | Address | City | State | Zipcode | Country | Age | Gender | Income | Customer_Segment | Date | Year | Month | Time | Total_Purchases | Amount | Total_Amount | Product_Category | Product_Brand | Product_Type | Feedback | Shipping_Method | Payment_Method | Order_Status | Ratings | products | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
294256 | 9862022.0 | 99656.0 | Amber Fields | Donald38@gmail.com | 50022 Antonio Valley Suite 498 | Plymouth | England | 92925.0 | UK | 43.0 | Male | Medium | New | 03-05-23 | 2023.0 | March | 14:47:57 | 7.0 | 21.686500 | 151.805498 | Grocery | Nestle | Chocolate | Bad | Express | Cash | Pending | 1.0 | Chocolate mousse |
294257 | 5561211.0 | 35974.0 | Jordan Hall | Holly86@gmail.com | 806 Alan Flats | Ballarat | New South Wales | 99633.0 | Australia | 61.0 | Male | Medium | Premium | 2/14/2024 | 2024.0 | February | 00:13:52 | 7.0 | 343.066709 | 2401.466964 | Home Decor | Bed Bath & Beyond | Bathroom | Bad | Same-Day | Cash | Processing | 1.0 | Soap dispenser |
294258 | 8961631.0 | 79479.0 | Jason Welch | Jason36@gmail.com | 764 Garcia Flat | Hamilton | Ontario | 61218.0 | Canada | 63.0 | Male | Low | New | 09-06-23 | 2023.0 | September | 17:37:41 | 6.0 | 443.329498 | 2659.976987 | Home Decor | Home Depot | Tools | Excellent | Express | Cash | Pending | 5.0 | Level |
294259 | 2844206.0 | 18799.0 | Angel Hood | Joseph24@gmail.com | 7593 Joseph Trace Suite 382 | Cairns | New South Wales | 39837.0 | Australia | 41.0 | Male | Medium | Premium | 5/28/2023 | 2023.0 | May | 13:11:33 | 6.0 | 397.452883 | 2384.717299 | Electronics | Apple | Tablet | Average | Same-Day | Cash | Pending | 2.0 | Amazon Fire Tablet |
294260 | 4833982.0 | 94117.0 | Kara Hart | Tammy37@gmail.com | 872 Robinson Harbors Apt. 328 | Charlotte | Missouri | 65301.0 | USA | 54.0 | Male | High | New | 10/14/2023 | 2023.0 | October | 15:06:09 | 5.0 | 472.424060 | 2362.120301 | Clothing | Nike | Shorts | Excellent | Standard | Cash | Delivered | 4.0 | Chino shorts |
294261 | 4246475.0 | 12104.0 | Meagan Ellis | Courtney60@gmail.com | 389 Todd Path Apt. 159 | Townsville | New South Wales | 4567.0 | Australia | 31.0 | Male | Medium | Regular | 1/20/2024 | 2024.0 | January | 23:40:29 | 5.0 | 194.792597 | 973.962984 | Books | Penguin Books | Fiction | Bad | Same-Day | Cash | Processing | 1.0 | Historical fiction |
294262 | 1197603.0 | 69772.0 | Mathew Beck | Jennifer71@gmail.com | 52809 Mark Forges | Hanover | Berlin | 16852.0 | Germany | 35.0 | Female | Low | New | 12/28/2023 | 2023.0 | December | 02:55:45 | 1.0 | 285.137301 | 285.137301 | Electronics | Apple | Laptop | Excellent | Same-Day | Cash | Processing | 5.0 | LG Gram |
294263 | 7743242.0 | 28449.0 | Daniel Lee | Christopher100@gmail.com | 407 Aaron Crossing Suite 495 | Brighton | England | 88038.0 | UK | 41.0 | Male | Low | Premium | 2/27/2024 | 2024.0 | February | 02:43:49 | 3.0 | 60.701761 | 182.105285 | Clothing | Adidas | Jacket | Average | Express | Cash | Shipped | 2.0 | Parka |
294264 | 9301950.0 | 45477.0 | Patrick Wilson | Rebecca65@gmail.com | 3204 Baird Port | Halifax | Ontario | 67608.0 | Canada | 41.0 | Male | Medium | New | 09-03-23 | 2023.0 | September | 11:20:31 | 1.0 | 120.834784 | 120.834784 | Home Decor | IKEA | Furniture | Good | Standard | Cash | Shipped | 4.0 | TV stand |
294265 | 2882826.0 | 53626.0 | Dustin Merritt | William14@gmail.com | 143 Amanda Crescent | Tucson | West Virginia | 25242.0 | USA | 28.0 | Female | Low | Premium | 01-08-24 | 2024.0 | January | 11:44:36 | 7.0 | 340.319059 | 2382.233417 | Home Decor | Home Depot | Decorations | Average | Same-Day | Cash | Shipped | 2.0 | Clocks |
Duplicate rows
Most frequently occurring
Transaction_ID | Customer_ID | Name | Address | City | State | Zipcode | Country | Age | Gender | Income | Customer_Segment | Date | Year | Month | Time | Total_Purchases | Amount | Total_Amount | Product_Category | Product_Brand | Product_Type | Feedback | Shipping_Method | Payment_Method | Order_Status | Ratings | products | # duplicates | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 3200766.0 | 49598.0 | Mikayla Mueller | Kenneth43@gmail.com | 716 Joshua Rapids Apt. 790 | Bremen | Berlin | 64747.0 | Germany | 59.0 | Male | Low | New | 11/23/2023 | 2023.0 | November | 15:35:49 | 9.0 | 272.327418 | 2450.946762 | Grocery | Pepsi | Soft Drink | Bad | Standard | Cash | Pending | 1.0 | Iced tea | 2 |
1 | 4476510.0 | 20103.0 | Christine Kim | James11@gmail.com | 8176 Randy Squares Apt. 772 | Kitchener | Ontario | 7099.0 | Canada | 54.0 | Female | Low | Regular | 12-10-23 | 2023.0 | December | 01:09:09 | 7.0 | 134.374182 | 940.619277 | Clothing | Adidas | T-shirt | Bad | Express | Credit Card | Processing | 1.0 | Off-the-shoulder tee | 2 |
2 | 4942326.0 | 25416.0 | Pamela Martin | Christine83@gmail.com | 9851 Myers Tunnel | Leicester | England | 57655.0 | UK | 63.0 | Male | Low | Regular | 05-05-23 | 2023.0 | May | 04:17:21 | 8.0 | 191.906886 | 1535.255087 | Clothing | Adidas | Jacket | Average | Same-Day | Cash | Pending | 2.0 | Varsity jacket | 2 |