Fashion E-commerce User Data

Users behavior and country-level trends in fashion e-commerce

@kaggle.utkarshx27_fashion_ecommerce_user_data

Table List

2 tables(1.54 MB)

Ds2

@kaggle.utkarshx27_fashion_ecommerce_user_data.ds2

30.53 KB
62 rows
32 columns

country Country	buyers Buyers	topbuyers Topbuyers	topbuyerratio Topbuyerratio	femalebuyers Femalebuyers	malebuyers Malebuyers	topfemalebuyers Topfemalebuyers	topmalebuyers Topmalebuyers	femalebuyersratio Femalebuyersratio	topfemalebuyersratio Topfemalebuyersratio	boughtperwishlistratio Boughtperwishlistratio	boughtperlikeratio Boughtperlikeratio	topboughtperwishlistratio Topboughtperwishlistratio	topboughtperlikeratio Topboughtperlikeratio	totalproductsbought Totalproductsbought	totalproductswished Totalproductswished	totalproductsliked Totalproductsliked	toptotalproductsbought Toptotalproductsbought	toptotalproductswished Toptotalproductswished	toptotalproductsliked Toptotalproductsliked	meanproductsbought Meanproductsbought	meanproductswished Meanproductswished	meanproductsliked Meanproductsliked	topmeanproductsbought Topmeanproductsbought	topmeanproductswished Topmeanproductswished	topmeanproductsliked Topmeanproductsliked	meanofflinedays Meanofflinedays	topmeanofflinedays Topmeanofflinedays	meanfollowers Meanfollowers	meanfollowing Meanfollowing	topmeanfollowers Topmeanfollowers	topmeanfollowing Topmeanfollowing
France	1251	53	4.2	851	400	33	20	68	62.3	26.08	14.15	36.37	23.21	3573	13700	25249	1487	4089	6406	2.9	11	20.2	28.1	77.2	120.9	321.8	75	4.8	8.8	10.1	11
Royaume-Uni	792	38	4.8	560	232	30	8	70.7	78.9	14.97	9.3	13.93	11.59	2174	14524	23378	853	6124	7362	2.7	18.3	29.5	22.4	161.2	193.7	298.3	68.2	5.4	8.8	11.1	12.2
Etats-Unis	912	31	3.4	700	212	21	10	76.8	67.7	21.84	7.92	23.35	12.44	2370	10852	29917	864	3701	6946	2.6	11.9	32.8	27.9	119.4	224.1	359.3	73	4.9	9.7	11.7	27.9
Allemagne	578	29	5	409	169	21	8	70.8	72.4	13.91	6.88	10.13	4.85	1635	11758	23761	516	5096	10648	2.8	20.3	41.1	17.8	175.7	367.2	296.6	39.3	5.1	8.6	11.2	11.3
Italie	400	21	5.3	283	117	14	7	70.8	66.7	12.56	8.6	11.86	23.91	1221	9720	14200	519	4376	2171	3.1	24.3	35.5	24.7	208.4	103.4	247.9	40.9	6.4	11.6	14.3	15.4
Espagne	255	21	8.2	189	66	18	3	74.1	85.7	12.98	6.2	11.94	6.21	1028	7918	16579	558	4673	8984	4	31.1	65	26.6	222.5	427.8	271.1	39.4	7	9.5	17.6	11.6
Pays-Bas	144	15	10.4	118	26	10	5	81.9	66.7	19.69	8.73	27.21	11.81	537	2727	6154	295	1084	2498	3.7	18.9	42.7	19.7	72.3	166.5	191.6	14.3	6.3	9	17.7	10.5
Suède	151	11	7.3	113	38	7	4	74.8	63.6	11.35	5.52	12.57	5.02	566	4987	10256	234	1862	4658	3.7	33	67.9	21.3	169.3	423.5	189.1	86	7.4	9.1	20.2	9.5
Finlande	64	10	15.6	53	11	9	1	82.8	90	35.33	9.29	42.23	24.26	331	937	3562	212	502	874	5.2	14.6	55.7	21.2	50.2	87.4	184.9	121.1	6.7	9.2	10.3	12.5
Danemark	157	9	5.7	127	30	9		80.9	100	12.89	1.66	6.85	4.03	438	3399	26413	141	2059	3499	2.8	21.6	168.2	15.7	228.8	388.8	156	19.3	5.6	8.6	11.7	9.7


CREATE TABLE ds2 (
  "country" VARCHAR,
  "buyers" BIGINT,
  "topbuyers" BIGINT,
  "topbuyerratio" DOUBLE,
  "femalebuyers" BIGINT,
  "malebuyers" BIGINT,
  "topfemalebuyers" BIGINT,
  "topmalebuyers" BIGINT,
  "femalebuyersratio" DOUBLE,
  "topfemalebuyersratio" DOUBLE,
  "boughtperwishlistratio" DOUBLE,
  "boughtperlikeratio" DOUBLE,
  "topboughtperwishlistratio" DOUBLE,
  "topboughtperlikeratio" DOUBLE,
  "totalproductsbought" BIGINT,
  "totalproductswished" BIGINT,
  "totalproductsliked" BIGINT,
  "toptotalproductsbought" BIGINT,
  "toptotalproductswished" BIGINT,
  "toptotalproductsliked" BIGINT,
  "meanproductsbought" DOUBLE,
  "meanproductswished" DOUBLE,
  "meanproductsliked" DOUBLE,
  "topmeanproductsbought" DOUBLE,
  "topmeanproductswished" DOUBLE,
  "topmeanproductsliked" DOUBLE,
  "meanofflinedays" DOUBLE,
  "topmeanofflinedays" DOUBLE,
  "meanfollowers" DOUBLE,
  "meanfollowing" DOUBLE,
  "topmeanfollowers" DOUBLE,
  "topmeanfollowing" DOUBLE
);