Baselight

Fashion E-commerce User Data

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

@kaggle.utkarshx27_fashion_ecommerce_user_data

Loading...
Loading...

About this Dataset

Fashion E-commerce User Data

```
➡️The dataset provided consists of two parts: Dataset 1 and Dataset 2, containing information related to fashion e-commerce users.

#### Columns in dataset 1(ds1.csv) has 98913 rows and 24 columns:

| Column | Description |
| --- | --- |
| identifierHash | Unique identifier hash for each entry. |
| type | Type of user. |
| country | Country of the user. |
| language | Language preference of the user. |
| socialNbFollowers | Number of social media followers of the user. |
| socialNbFollows | Number of social media accounts the user follows. |
| socialProductsLiked | Number of social media products liked by the user. |
| productsListed | Number of products listed by the user. |
| productsSold | Number of products sold by the user. |
| productsPassRate | Pass rate of the user's products. |
| productsWished | Number of products wished by the user. |
| productsBought | Number of products bought by the user. |
| gender | Gender of the user. |
| civilityGenderId | Civility gender identifier. |
| civilityTitle | Civility title of the user. |
| hasAnyApp | Indicates if the user has any mobile app. |
| hasAndroidApp | Indicates if the user has an Android app. |
| hasIosApp | Indicates if the user has an iOS app. |
| hasProfilePicture | Indicates if the user has a profile picture. |
| daysSinceLastLogin | Number of days since the user's last login. |
| seniority | User's seniority. |
| seniorityAsMonths | User's seniority in months. |
| seniorityAsYears | User's seniority in years. |
| countryCode | Country code of the user's country. |




#### Columns in dataset 2(ds2) has 62 rows and 32 columns:

| Column | Description |
| --- | --- |
| country | Country name |
| buyers | Total number of buyers in the country |
| topbuyers | Number of top buyers in the country |
| topbuyerratio | Ratio of top buyers in the country |
| femalebuyers | Number of female buyers in the country |
| malebuyers | Number of male buyers in the country |
| topfemalebuyers | Number of top female buyers in the country |
| topmalebuyers | Number of top male buyers in the country |
| femalebuyersratio | Ratio of female buyers in the country |
| topfemalebuyersratio | Ratio of top female buyers in the country |
| boughtperwishlistratio | Ratio of products bought per wishlist in the country |
| boughtperlikeratio | Ratio of products bought per liked product in the country |
| topboughtperwishlistratio | Ratio of products bought per wishlist for top buyers in the country |
| topboughtperlikeratio | Ratio of products bought per liked product for top buyers in the country |
| totalproductsbought | Total number of products bought in the country |
| totalproductswished | Total number of products wished in the country |
| totalproductsliked | Total number of products liked in the country |
| toptotalproductsbought | Total number of products bought by top buyers in the country |
| toptotalproductswished | Total number of products wished by top buyers in the country |
| toptotalproductsliked | Total number of products liked by top buyers in the country |
| meanproductsbought | Mean number of products bought per buyer in the country |
| meanproductswished | Mean number of products wished per buyer in the country |
| meanproductsliked | Mean number of products liked per buyer in the country |
| topmeanproductsbought | Mean number of products bought per buyer for top buyers in the country |
| topmeanproductswished | Mean number of products wished per buyer for top buyers in the country |
| topmeanproductsliked | Mean number of products liked per buyer for top buyers in the country |
| meanofflinedays | Mean number of offline days for buyers in the country |
| topmeanofflinedays | Mean number of offline days for top buyers in the country |
| meanfollowers | Mean number of social media followers for buyers in the country |
| meanfollowing | Mean number of social media accounts followed by buyers in the country |
| topmeanfollowers | Mean number of social media followers for top buyers in the country |
| topmeanfollowing | Mean number of social media accounts followed by top buyers in the country |

Tables

Ds1

@kaggle.utkarshx27_fashion_ecommerce_user_data.ds1
  • 1.51 MB
  • 98913 rows
  • 24 columns
Loading...

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
);

Ds2

@kaggle.utkarshx27_fashion_ecommerce_user_data.ds2
  • 30.53 KB
  • 62 rows
  • 32 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.