Women Fashion Trend Dataset

Are you interested in shopping ?

@kaggle.durgeshrao9993_dataset

Table List

1 table(469.65 KB)

Summer Products

@kaggle.durgeshrao9993_dataset.summer_products

469.65 KB
1573 rows
43 columns

title Title	title_orig Title Orig	price Price	retail_price Retail Price	currency_buyer Currency Buyer	units_sold Units Sold	uses_ad_boosts Uses Ad Boosts	rating Rating	rating_count Rating Count	rating_five_count Rating Five Count	rating_four_count Rating Four Count	rating_three_count Rating Three Count	rating_two_count Rating Two Count	rating_one_count Rating One Count	tags Tags	product_color Product Color	product_variation_size_id Product Variation Size Id	product_variation_inventory Product Variation Inventory	shipping_option_name Shipping Option Name	shipping_option_price Shipping Option Price	countries_shipped_to Countries Shipped To	inventory_total Inventory Total	has_urgency_banner Has Urgency Banner	urgency_text Urgency Text	origin_country Origin Country	merchant_title Merchant Title	merchant_name Merchant Name	merchant_info_subtitle Merchant Info Subtitle	merchant_rating_count Merchant Rating Count	merchant_rating Merchant Rating	merchant_id Merchant Id	merchant_has_profile_picture Merchant Has Profile Picture	merchant_profile_picture Merchant Profile Picture	product_url Product Url	product_picture Product Picture	product_id Product Id	theme Theme	crawl_month Crawl Month
2020 Summer Vintage Flamingo Print Pajamas Set Casual Loose T Shirt Top And Elastic Shorts Women Sleepwear Night Wear Loungewear Sets	2020 Summer Vintage Flamingo Print Pajamas Set Casual Loose T Shirt Top And Elastic Shorts Women Sleepwear Night Wear Loungewear Sets	16	14	EUR	100		3.76	54	26	8	10	1	9	Summer,Fashion,womenunderwearsuit,printedpajamasset,womencasualshort,Women's Fashion,flamingo,loungewearset,Casual,Shirt,casualsleepwear,Shorts,flamingotshirt,Elastic,Vintage,Tops,tshirtandshortsset,Women,Sleepwear,Print,womenpajamasset,womennightwear,Pajamas,womensleepwearset	white	M	50	Livraison standard	4	34	50	1	Quantité limitée !	CN	zgrdejia	zgrdejia	(568 notes)	568	4.128521126760563	595097d6a26f6e070cb878d1		nan	https://www.wish.com/c/5e9ae51d43d6a96e303acdb0	https://contestimg.wish.com/api/webimage/5e9ae51d43d6a96e303acdb0-medium.jpg	5e9ae51d43d6a96e303acdb0	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
SSHOUSE Summer Casual Sleeveless Soirée Party Soirée sans manches Vêtements de plage sexy Mini robe femme wshC1612242400387A21	Women's Casual Summer Sleeveless Sexy Mini Dress	8	22	EUR	20000	1	3.45	6135	2269	1027	1118	644	1077	Mini,womens dresses,Summer,Patchwork,fashion dress,Dress,Mini dress,Women's Fashion,Women S Clothing,backless,party,summer dresses,sleeveless,sexy,Casual	green	XS	50	Livraison standard	2	41	50	1	Quantité limitée !	CN	SaraHouse	sarahouse	83 % avis positifs (17,752 notes)	17752	3.8996732762505633	56458aa03a698c35c9050988		nan	https://www.wish.com/c/58940d436a0d3d5da4e95a38	https://contestimg.wish.com/api/webimage/58940d436a0d3d5da4e95a38-medium.jpg	58940d436a0d3d5da4e95a38	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
2020 Nouvelle Arrivée Femmes Printemps et Été Plage Porter Longue Mince Cardigan Ouvert Avant Kimono Vert Feuille Imprimé En Mousseline de Soie Cardigan S-5XL	2020 New Arrival Women Spring and Summer Beach Wear Long Thin Cardigan Open Front Kimono Green Leaf Printed Chiffon Cardigan S-5XL	8	43	EUR	100		3.57	14	5	4	2		3	Summer,cardigan,women beachwear,chiffon,Sexy women,Coat,summercardigan,openfront,short sleeves,Swimsuit,Women's Fashion,leaf,Green,printed,Spring,longcardigan,Women,Beach,kimono	leopardprint	XS	1	Livraison standard	3	36	50	1	Quantité limitée !	CN	hxt520	hxt520	86 % avis positifs (295 notes)	295	3.989830508474576	5d464a1ffdf7bc44ee933c65		nan	https://www.wish.com/c/5ea10e2c617580260d55310a	https://contestimg.wish.com/api/webimage/5ea10e2c617580260d55310a-medium.jpg	5ea10e2c617580260d55310a	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Hot Summer Cool T-shirt pour les femmes Mode Tops Abeille Lettres imprimées Manches courtes O Neck Coton T-shirts Tops Tee Vêtements	Hot Summer Cool T Shirt for Women Fashion Tops Bee Printed Letters Short Sleeve O Neck Cotton T-shirts Tops Tee Clothing	8	8	EUR	5000	1	4.03	579	295	119	87	42	36	Summer,Shorts,Cotton,Cotton T Shirt,Sleeve,printedletterstop,Clothing,Tops,Necks,short sleeves,Women's Fashion,Women Clothing,printed,Women,tshirtforwomen,Fashion,T Shirts,Shirt	black	M	50	Livraison standard	2	41	50		nan	CN	allenfan	allenfan	(23,832 notes)	23832	4.020434709634105	58cfdefdacb37b556efdff7c		nan	https://www.wish.com/c/5cedf17ad1d44c52c59e4aca	https://contestimg.wish.com/api/webimage/5cedf17ad1d44c52c59e4aca-medium.jpg	5cedf17ad1d44c52c59e4aca	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Femmes Shorts d'été à lacets taille élastique lâche mince pantalon décontracté, plus la taille S-8XL	Women Summer Shorts Lace Up Elastic Waistband Loose Thin Casual Pants Plus Size S-8XL	2.72	3	EUR	100	1	3.1	20	6	4	2	2	6	Summer,Plus Size,Lace,Casual pants,Bottom,pants,Loose,Women's Fashion,Shorts,Lace Up,Elastic,Casual,Women	yellow	S	1	Livraison standard	1	35	50	1	Quantité limitée !	CN	youngpeopleshop	happyhorses	85 % avis positifs (14,482 notes)	14482	4.001588178428394	5ab3b592c3911a095ad5dadb		nan	https://www.wish.com/c/5ebf5819ebac372b070b0e70	https://contestimg.wish.com/api/webimage/5ebf5819ebac372b070b0e70-medium.jpg	5ebf5819ebac372b070b0e70	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Plus la taille d'été femmes décontracté sans manches barboteuses combinaisons combinaison de couleur unie jarretelles pantalons lâche salopette	Plus Size Summer Women Casual Sleeveless Rompers Jumpsuits Solid Color Suspender Ttrousers Loose Overalls	3.92	9	EUR	10		5	1	1					Deep V-Neck,Summer,Plus Size,Spaghetti Strap,Overalls,Women's Fashion,sleeveless,Women,Casual,jumpsuit	navyblue	Size-XS	1	Livraison standard	1	40	50		nan	CN	zhoulinglinga	zhoulinglinga	75 % avis positifs (65 notes)	65	3.507692307692308	5e4b9c3801ba9d210036fc5a		nan	https://www.wish.com/c/5ec645bafd107a02279c8c54	https://contestimg.wish.com/api/webimage/5ec645bafd107a02279c8c54-medium.jpg	5ec645bafd107a02279c8c54	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Women Fashion Loose Lace Blouse Blouse V Neck Bat Sleeves T Shirt Hollow Out Tops Plus Grande Taille XS-8XL	Women Fashion Loose Lace Blouse V Neck Bat Sleeves T Shirt Hollow Out Tops Plus Size XS-8XL	7	6	EUR	50000		3.84	6742	3172	1352	971	490	757	blouse,Women,lace t shirt,summer t-shirts,Lace,Sleeve,Women Blouse,loose shirt,Short Sleeve Blouses,Pure Color,Womens Blouse,Bat,lace shirts,Necks,Women's Fashion,Plus Size,loose t-shirt,Short Sleeve T-Shirt,Fashion,Tops,Shirt	white	XS	50	Livraison standard	2	31	50		nan	CN	Unique Li Fashion Shop	uniquelifashionshopbb657bfe91d211e598c7063a14dc88b5	86 % avis positifs (10,194 notes)	10194	4.076515597410241	5652f4053a698c76dc9a3f37	1	https://s3-us-west-1.amazonaws.com/sweeper-production-merchantimage/dp_5652f4053a698c76dc9a3f37.jpg	https://www.wish.com/c/5c63a337d5e2ce4bbb3152cf	https://contestimg.wish.com/api/webimage/5c63a337d5e2ce4bbb3152cf-medium.jpg	5c63a337d5e2ce4bbb3152cf	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Robe tunique ample femme Robe d'été Robe en jean Robe chemise en jean Robe droite	Women's Baggy Tunic Dress Summer Dress Denim Dress Denim Shirt Dress Shift Dress	12	11	EUR	1000		3.76	286	120	56	61	18	31	Jeans,Fashion,tunic,Shirt,Summer,Dress,Denim,summer dress,denimjeansdres,short sleeves,casual dresses,Women's Fashion,Tunic dress,minishirtdres,Lines,mididre	blue	M.	50	Livraison standard	3	139	50		nan	CN	So Band	soband	(342 notes)	342	3.681286549707602	5d45349676befe65691dcfbb		nan	https://www.wish.com/c/5e0ae5ebc2efb76ccf0a3391	https://contestimg.wish.com/api/webimage/5e0ae5ebc2efb76ccf0a3391-medium.jpg	5e0ae5ebc2efb76ccf0a3391	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Robe d'été décontractée à manches courtes pour femmes	Women's Summer Casual Dress Fashion Short Sleeve Slim Dress	11	84	EUR	100	1	3.47	15	6	2	3	1	3	slim dress,summer dress,womenshortsleevedre,Sleeve,Summer,Dress,slim,short sleeves,Women's Fashion,Shorts,boho dress,slimfitdre,Fashion,Casual	black	M	50	Livraison standard	2	36	50	1	Quantité limitée !	CN	chenxiangjunjun	chenxiangjunjun	82 % avis positifs (330 notes)	330	3.803030303030303	5d42980e8388970d32294ddc		nan	https://www.wish.com/c/5e6f1fb7fe4a5bb4b8bf36e5	https://contestimg.wish.com/api/webimage/5e6f1fb7fe4a5bb4b8bf36e5-medium.jpg	5e6f1fb7fe4a5bb4b8bf36e5	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
Femmes d'été, plus la taille décontractée lâche col en V à manches courtes imprimé floral Blouse Tops	Summer Women Plus Size Casual Loose V Neck Short Sleeve Floral Printed Blouse Tops	5.78	22	EUR	5000		3.6	687	287	128	92	68	112	blouse,Summer,Plus Size,Floral print,Necks,Sleeve,summer shirt,Loose,short sleeves,Casual,T Shirts,Shorts,Fashion,Floral,Women,Women's Fashion,Tops,printed	beige	S	50	Livraison standard	2	33	50		nan	CN	Luowei clothe	luoweiclothe	85 % avis positifs (5,534 notes)	5534	3.999819298879653	5ba2251b4315d12ebce873fa		nan	https://www.wish.com/c/5ccfaf238a8d535cec2dfb47	https://contestimg.wish.com/api/webimage/5ccfaf238a8d535cec2dfb47-medium.jpg	5ccfaf238a8d535cec2dfb47	summer	Sat Aug 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE summer_products (
  "title" VARCHAR,
  "title_orig" VARCHAR,
  "price" DOUBLE,
  "retail_price" BIGINT,
  "currency_buyer" VARCHAR,
  "units_sold" BIGINT,
  "uses_ad_boosts" BIGINT,
  "rating" DOUBLE,
  "rating_count" BIGINT,
  "rating_five_count" DOUBLE,
  "rating_four_count" DOUBLE,
  "rating_three_count" DOUBLE,
  "rating_two_count" DOUBLE,
  "rating_one_count" DOUBLE,
  "badges_count" BIGINT,
  "badge_local_product" BIGINT,
  "badge_product_quality" BIGINT,
  "badge_fast_shipping" BIGINT,
  "tags" VARCHAR,
  "product_color" VARCHAR,
  "product_variation_size_id" VARCHAR,
  "product_variation_inventory" BIGINT,
  "shipping_option_name" VARCHAR,
  "shipping_option_price" BIGINT,
  "shipping_is_express" BIGINT,
  "countries_shipped_to" BIGINT,
  "inventory_total" BIGINT,
  "has_urgency_banner" DOUBLE,
  "urgency_text" VARCHAR,
  "origin_country" VARCHAR,
  "merchant_title" VARCHAR,
  "merchant_name" VARCHAR,
  "merchant_info_subtitle" VARCHAR,
  "merchant_rating_count" BIGINT,
  "merchant_rating" DOUBLE,
  "merchant_id" VARCHAR,
  "merchant_has_profile_picture" BIGINT,
  "merchant_profile_picture" VARCHAR,
  "product_url" VARCHAR,
  "product_picture" VARCHAR,
  "product_id" VARCHAR,
  "theme" VARCHAR,
  "crawl_month" TIMESTAMP
);