Fashion E-commerce User Data
Users behavior and country-level trends in fashion e-commerce
@kaggle.utkarshx27_fashion_ecommerce_user_data
Users behavior and country-level trends in fashion e-commerce
@kaggle.utkarshx27_fashion_ecommerce_user_data
CREATE TABLE ds1 (
"identifierhash" BIGINT,
"type" VARCHAR,
"country" VARCHAR,
"language" VARCHAR,
"socialnbfollowers" BIGINT,
"socialnbfollows" BIGINT,
"socialproductsliked" BIGINT,
"productslisted" BIGINT,
"productssold" BIGINT,
"productspassrate" DOUBLE,
"productswished" BIGINT,
"productsbought" BIGINT,
"gender" VARCHAR,
"civilitygenderid" BIGINT,
"civilitytitle" VARCHAR,
"hasanyapp" BOOLEAN,
"hasandroidapp" BOOLEAN,
"hasiosapp" BOOLEAN,
"hasprofilepicture" BOOLEAN,
"dayssincelastlogin" BIGINT,
"seniority" BIGINT,
"seniorityasmonths" DOUBLE,
"seniorityasyears" DOUBLE,
"countrycode" VARCHAR
);
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
);
Anyone who has the link will be able to view this.