Overview

Dataset info

Number of variables9
Number of observations5000
Missing cells66 (0.1%)
Duplicate rows7 (0.1%)
Total size in memory1.7 MiB
Average record size in memory359.7 B

Variables types

CAT5
NUM4

Reproduction info

Date of analysis2020-09-19 00:30:19.284260
Versionpandas-profiling v2.4.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download Configurationconfig.yaml
Toggle Warnings

Warnings

Dataset has 7 (0.1%) duplicate rows Warning
order_date has a high cardinality: 157 distinct values Warning
product_id has a high cardinality: 1322 distinct values Warning

Variables

order_id
Real number (ℝ≥0)

Distinct count3234
Unique (%)64.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1707213.704
Minimum1666774
Maximum1742998
Zeros0
Zeros (%)0.0%
Memory size39.2 KiB
Mini histogram
Toggle details

Quantile statistics

Minimum1666774
5-th percentile1671745
Q11688852.5
median1708448.5
Q31725622.75
95-th percentile1739225.2
Maximum1742998
Range76224
Interquartile range (IQR)36770.25

Descriptive statistics

Standard deviation21525.81671
Coefficient of variation (CV)0.01260874176
Kurtosis-1.140615918
Mean1707213.704
Median Absolute Deviation (MAD)18514.66223
Skewness-0.1439536427
Sum8536068518
Variance463360785.2
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1695451 13 0.3%
 
1720729 12 0.2%
 
1714324 11 0.2%
 
1737589 10 0.2%
 
1711465 10 0.2%
 
1726822 10 0.2%
 
1742182 9 0.2%
 
1729018 9 0.2%
 
1701550 9 0.2%
 
1707739 9 0.2%
 
Other values (3224) 4898 98.0%
 
ValueCountFrequency (%) 
1666774 1 < 0.1%
 
1666783 2 < 0.1%
 
1666813 1 < 0.1%
 
1666882 1 < 0.1%
 
1666894 2 < 0.1%
 
ValueCountFrequency (%) 
1742998 1 < 0.1%
 
1742992 2 < 0.1%
 
1742989 1 < 0.1%
 
1742953 1 < 0.1%
 
1742947 2 < 0.1%
 

order_date
Categorical

HIGH CARDINALITY
Distinct count157
Unique (%)3.1%
Missing0
Missing (%)0.0%
Memory size39.2 KiB
30/12/2019
 
70
18/12/2019
 
68
05/12/2019
 
67
01/12/2019
 
67
15/12/2019
 
66
Other values (152)
4662
Toggle details
ValueCountFrequency (%) 
30/12/2019 70 1.4%
 
18/12/2019 68 1.4%
 
05/12/2019 67 1.3%
 
01/12/2019 67 1.3%
 
15/12/2019 66 1.3%
 
04/11/2019 66 1.3%
 
24/12/2019 63 1.3%
 
24/11/2019 62 1.2%
 
22/12/2019 60 1.2%
 
11/12/2019 60 1.2%
 
Other values (147) 4351 87.0%
 

customer_id
Real number (ℝ≥0)

Distinct count1773
Unique (%)35.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15474.8326
Minimum12391
Maximum18287
Zeros0
Zeros (%)0.0%
Memory size39.2 KiB
Mini histogram
Toggle details

Quantile statistics

Minimum12391
5-th percentile12890
Q114096
median15492.5
Q316916
95-th percentile17954.15
Maximum18287
Range5896
Interquartile range (IQR)2820

Descriptive statistics

Standard deviation1650.211651
Coefficient of variation (CV)0.106638417
Kurtosis-1.217662056
Mean15474.8326
Median Absolute Deviation (MAD)1438.657936
Skewness-0.00997199229
Sum77374163
Variance2723198.495
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
17841 117 2.3%
 
14096 106 2.1%
 
12748 68 1.4%
 
14298 26 0.5%
 
14456 24 0.5%
 
14606 24 0.5%
 
13263 23 0.5%
 
16549 23 0.5%
 
13089 20 0.4%
 
18283 18 0.4%
 
Other values (1763) 4551 91.0%
 
ValueCountFrequency (%) 
12391 1 < 0.1%
 
12420 1 < 0.1%
 
12471 5 0.1%
 
12472 6 0.1%
 
12474 5 0.1%
 
ValueCountFrequency (%) 
18287 2 < 0.1%
 
18283 18 0.4%
 
18282 1 < 0.1%
 
18272 3 0.1%
 
18265 2 < 0.1%
 

city
Categorical

Distinct count19
Unique (%)0.4%
Missing16
Missing (%)0.3%
Memory size39.2 KiB
Jakarta Selatan
791
Jakarta Pusat
675
Jakarta Utara
 
433
Yogyakarta
 
392
Jakarta Barat
 
349
Other values (13)
2344
Toggle details
ValueCountFrequency (%) 
Jakarta Selatan 791 15.8%
 
Jakarta Pusat 675 13.5%
 
Jakarta Utara 433 8.7%
 
Yogyakarta 392 7.8%
 
Jakarta Barat 349 7.0%
 
Malang 296 5.9%
 
Jakarta Timur 295 5.9%
 
Surakarta 288 5.8%
 
Bogor 255 5.1%
 
Tangerang 252 5.0%
 
Other values (8) 958 19.2%
 

province
Categorical

Distinct count8
Unique (%)0.2%
Missing12
Missing (%)0.2%
Memory size39.2 KiB
DKI Jakarta
2547
Jawa Barat
822
Jawa Tengah
 
456
Jawa Timur
 
397
Yogyakarta
 
391
Other values (2)
 
375
Toggle details
ValueCountFrequency (%) 
DKI Jakarta 2547 50.9%
 
Jawa Barat 822 16.4%
 
Jawa Tengah 456 9.1%
 
Jawa Timur 397 7.9%
 
Yogyakarta 391 7.8%
 
Banten 251 5.0%
 
Bali 124 2.5%
 
(Missing) 12 0.2%
 

product_id
Categorical

HIGH CARDINALITY
Distinct count1322
Unique (%)26.4%
Missing11
Missing (%)0.2%
Memory size39.2 KiB
P4009
 
35
P1902
 
27
P0255
 
26
P2521
 
25
P2094
 
25
Other values (1316)
4851
Toggle details
ValueCountFrequency (%) 
P4009 35 0.7%
 
P1902 27 0.5%
 
P0255 26 0.5%
 
P2521 25 0.5%
 
P2094 25 0.5%
 
P2101 24 0.5%
 
P2489 23 0.5%
 
P2853 23 0.5%
 
P2445 22 0.4%
 
P2089 22 0.4%
 
Other values (1311) 4737 94.7%
 

brand
Categorical

Distinct count10
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size39.2 KiB
BRAND_S
989
BRAND_P
665
BRAND_R
627
BRAND_C
536
BRAND_A
427
Other values (5)
1756
Toggle details
ValueCountFrequency (%) 
BRAND_S 989 19.8%
 
BRAND_P 665 13.3%
 
BRAND_R 627 12.5%
 
BRAND_C 536 10.7%
 
BRAND_A 427 8.5%
 
BRAND_W 385 7.7%
 
BRAND_L 374 7.5%
 
BRAND_B 344 6.9%
 
BRAND_J 334 6.7%
 
BRAND_H 319 6.4%
 

quantity
Real number (ℝ≥0)

Distinct count65
Unique (%)1.3%
Missing14
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean11.42398716
Minimum1
Maximum720
Zeros0
Zeros (%)0.0%
Memory size39.2 KiB
Mini histogram
Toggle details

Quantile statistics

Minimum1
5-th percentile1
Q12
median5
Q312
95-th percentile36
Maximum720
Range719
Interquartile range (IQR)10

Descriptive statistics

Standard deviation29.44202501
Coefficient of variation (CV)2.577210967
Kurtosis208.764203
Mean11.42398716
Median Absolute Deviation (MAD)10.797158
Skewness12.2428929
Sum56960
Variance866.8328367
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 938 18.8%
 
2 732 14.6%
 
12 677 13.5%
 
6 457 9.1%
 
4 383 7.7%
 
3 367 7.3%
 
10 351 7.0%
 
24 277 5.5%
 
8 130 2.6%
 
5 121 2.4%
 
Other values (54) 553 11.1%
 
ValueCountFrequency (%) 
1 938 18.8%
 
2 732 14.6%
 
3 367 7.3%
 
4 383 7.7%
 
5 121 2.4%
 
ValueCountFrequency (%) 
720 1 < 0.1%
 
600 1 < 0.1%
 
576 2 < 0.1%
 
480 1 < 0.1%
 
432 2 < 0.1%
 

item_price
Real number (ℝ≥0)

Distinct count127
Unique (%)2.5%
Missing13
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean933742.7311
Minimum26000
Maximum29762000
Zeros0
Zeros (%)0.0%
Memory size39.2 KiB
Mini histogram
Toggle details

Quantile statistics

Minimum26000
5-th percentile149000
Q1450000
median604000
Q31045000
95-th percentile2795000
Maximum29762000
Range29736000
Interquartile range (IQR)595000

Descriptive statistics

Standard deviation1030829.81
Coefficient of variation (CV)1.103976263
Kurtosis137.870979
Mean933742.7311
Median Absolute Deviation (MAD)623479.205
Skewness7.099641665
Sum4656575000
Variance1.062610098e+12
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
590000 540 10.8%
 
450000 527 10.5%
 
740000 323 6.5%
 
1045000 287 5.7%
 
310000 264 5.3%
 
1745000 258 5.2%
 
159000 245 4.9%
 
747000 232 4.6%
 
1325000 196 3.9%
 
520000 177 3.5%
 
Other values (116) 1938 38.8%
 
ValueCountFrequency (%) 
26000 4 0.1%
 
33000 2 < 0.1%
 
37000 1 < 0.1%
 
40000 1 < 0.1%
 
54000 3 0.1%
 
ValueCountFrequency (%) 
29762000 1 < 0.1%
 
13995000 1 < 0.1%
 
11545000 1 < 0.1%
 
10495000 2 < 0.1%
 
8748000 1 < 0.1%
 

Missing values

Count
Matrix

Sample

First rows

order_idorder_datecustomer_idcityprovinceproduct_idbrandquantityitem_price
0170345817/10/201914004Jakarta SelatanDKI JakartaP1910BRAND_J10.0740000.0
1170681524/10/201917220Jakarta SelatanDKI JakartaP2934BRAND_R2.0604000.0
2171071803/11/201916518Jakarta UtaraDKI JakartaP0908BRAND_C8.01045000.0
3168359219/08/201916364Jakarta BaratDKI JakartaP0128BRAND_A4.0205000.0
4170257316/10/201915696Jakarta TimurDKI JakartaP2968BRAND_R2.0NaN
5167290616/07/201912748Jakarta UtaraDKI JakartaP0710BRAND_C4.0520000.0
6171139904/11/201916791Jakarta BaratDKI JakartaP0860BRAND_C1.01465000.0
7169536726/09/201913069SurakartaJawa TengahP3342BRAND_S2.0205000.0
8174184630/12/201916873Jakarta BaratDKI JakartaP3203BRAND_S32.0450000.0
9172018924/11/201914723TangerangBantenP1701BRAND_H2.0149000.0

Last rows

order_idorder_datecustomer_idcityprovinceproduct_idbrandquantityitem_price
4990167840802/08/201915182Jakarta PusatDKI JakartaP1903BRAND_J10.0740000.0
4991173650320/12/201918109TangerangBantenP2866BRAND_R3.01045000.0
4992173478718/12/201918283Jakarta SelatanDKI JakartaP0734BRAND_C2.0310000.0
4993167861504/08/201916880BekasiJawa BaratP2426BRAND_P3.0310000.0
4994170742425/10/201913021YogyakartaYogyakartaP1913BRAND_J10.0740000.0
4995172401101/12/201912838TangerangBantenP3047BRAND_R2.0450000.0
4996167630228/07/201913833BogorJawa BaratP0760BRAND_C3.01465000.0
4997170607123/10/201916332Jakarta TimurDKI JakartaP1681BRAND_H4.0747000.0
4998170362017/10/201913055Jakarta BaratDKI JakartaP0757BRAND_C8.0695000.0
4999172003624/11/201917609Jakarta PusatDKI JakartaP3334BRAND_S1.01045000.0