Flipkart E-commerce Dataset
20000 Rows Data for Product Category on Flipkart
@kaggle.atharvjairath_flipkart_ecommerce_dataset
Flipkart Com Ecommerce Sample
@kaggle.atharvjairath_flipkart_ecommerce_dataset.flipkart_com_ecommerce_sample
- 8.6 MB
- 20002 rows
- 15 columns
uniq_idUniq Id | crawl_timestampCrawl Timestamp | product_urlProduct Url | product_nameProduct Name | product_category_treeProduct Category Tree | pidPid | retail_priceRetail Price | discounted_priceDiscounted Price | imageImage | is_fk_advantage_productIs FK Advantage Product | descriptionDescription | product_ratingProduct Rating | overall_ratingOverall Rating | brandBrand | product_specificationsProduct Specifications |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c2d766ca982eca8304150849735ffef9 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/alisha-solid-women-s-cycling-shorts/p/itmeh2ffvzetthbb?pid=SRTEH2FF9KEDEFGF | Alisha Solid Women's Cycling Shorts | ["Clothing >> Women's Clothing >> Lingerie, Sleep & Swimwear >> Shorts >> Alisha Shorts >> Alisha Solid Women's Cycling Shorts"] | SRTEH2FF9KEDEFGF | 999 | 379 | ["http://img5a.flixcart.com/image/short/u/4/a/altht-3p-21-alisha-38-original-imaeh2d5vm5zbtgg.jpeg", "http://img5a.flixcart.com/image/short/p/j/z/altght4p-26-alisha-38-original-imaeh2d5kbufss6n.jpeg", "http://img5a.flixcart.com/image/short/p/j/z/altght4p-26-alisha-38-original-imaeh2d5npdybzyt.jpeg",… | False | Key Features of Alisha Solid Women's Cycling Shorts Cotton Lycra Navy, Red, Navy,Specifications of Alisha Solid Women's Cycling Shorts Shorts Details Number of Contents in Sales Package Pack of 3 Fabric Cotton Lycra Type Cycling Shorts General Details Pattern Solid Ideal For Women's Fabric Care Gent… | No rating available | No rating available | Alisha | {"product_specification"=>[{"key"=>"Number of Contents in Sales Package", "value"=>"Pack of 3"}, {"key"=>"Fabric", "value"=>"Cotton Lycra"}, {"key"=>"Type", "value"=>"Cycling Shorts"}, {"key"=>"Pattern", "value"=>"Solid"}, {"key"=>"Ideal For", "value"=>"Women's"}, {"value"=>"Gentle Machine Wash in L… |
| 7f7036a6d550aaa89d34c77bd39a5e48 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/fabhomedecor-fabric-double-sofa-bed/p/itmeh3qgfamccfpy?pid=SBEEH3QGU7MFYJFY | FabHomeDecor Fabric Double Sofa Bed | ["Furniture >> Living Room Furniture >> Sofa Beds & Futons >> FabHomeDecor Fabric Double Sofa Bed (Finish Colo..."] | SBEEH3QGU7MFYJFY | 32157 | 22646 | ["http://img6a.flixcart.com/image/sofa-bed/j/f/y/fhd112-double-foam-fabhomedecor-leatherette-black-leatherette-1100x1100-imaeh3gemjjcg9ta.jpeg", "http://img6a.flixcart.com/image/sofa-bed/j/f/y/fhd112-double-foam-fabhomedecor-leatherette-black-leatherette-original-imaeh3gemjjcg9ta.jpeg", "http://img6… | False | FabHomeDecor Fabric Double Sofa Bed (Finish Color - Leatherette Black Mechanism Type - Pull Out) Price: Rs. 22,646 • Fine deep seating experience • Save Space with the all new click clack Sofa Bed • Easy to fold and vice versa with simple click clack mechanism • Chrome legs with mango wood frame for… | No rating available | No rating available | FabHomeDecor | {"product_specification"=>[{"key"=>"Installation & Demo Details", "value"=>"Installation and demo for this product is done free of cost as part of this purchase. Our service partner will visit your location within 72 business hours from the delivery of the product."}, {"value"=>"1 Sofa Bed"}, {"key"… |
| f449ec65dcbc041b6ae5e6a32717d01b | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/aw-bellies/p/itmeh4grgfbkexnt?pid=SHOEH4GRSUBJGZXE | AW Bellies | ["Footwear >> Women's Footwear >> Ballerinas >> AW Bellies"] | SHOEH4GRSUBJGZXE | 999 | 499 | ["http://img5a.flixcart.com/image/shoe/7/z/z/red-as-454-aw-11-original-imaeebfwsdf6jdf6.jpeg", "http://img6a.flixcart.com/image/shoe/7/z/z/red-as-454-aw-11-original-imaeebfwsdf6jdf6.jpeg", "http://img5a.flixcart.com/image/shoe/7/z/z/red-as-454-aw-11-original-imaeebfwt8zqc5cy.jpeg", "http://img5a.fli… | False | Key Features of AW Bellies Sandals Wedges Heel Casuals,AW Bellies Price: Rs. 499 Material: Synthetic Lifestyle: Casual Heel Type: Wedge Warranty Type: Manufacturer Product Warranty against manufacturing defects: 30 days Care instructions: Allow your pair of shoes to air and de-odorize at regular bas… | No rating available | No rating available | AW | {"product_specification"=>[{"key"=>"Ideal For", "value"=>"Women"}, {"key"=>"Occasion", "value"=>"Casual"}, {"key"=>"Color", "value"=>"Red"}, {"key"=>"Outer Material", "value"=>"Patent Leather"}, {"key"=>"Heel Height", "value"=>"1 inch"}, {"key"=>"Number of Contents in Sales Package", "value"=>"Pack … |
| 0973b37acd0c664e3de26e97e5571454 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/alisha-solid-women-s-cycling-shorts/p/itmeh2f6sdgah2pq?pid=SRTEH2F6HUZMQ6SJ | Alisha Solid Women's Cycling Shorts | ["Clothing >> Women's Clothing >> Lingerie, Sleep & Swimwear >> Shorts >> Alisha Shorts >> Alisha Solid Women's Cycling Shorts"] | SRTEH2F6HUZMQ6SJ | 699 | 267 | ["http://img5a.flixcart.com/image/short/6/2/h/altght-11-alisha-38-original-imaeh2d5uq9thnyg.jpeg", "http://img6a.flixcart.com/image/short/p/h/t/altht-3p-1-alisha-34-original-imaeh2d5jxvh4msy.jpeg", "http://img6a.flixcart.com/image/short/p/h/t/altht-3p-1-alisha-34-original-imaeh2d5yz9fcjxe.jpeg", "ht… | False | Key Features of Alisha Solid Women's Cycling Shorts Cotton Lycra Black, Red,Specifications of Alisha Solid Women's Cycling Shorts Shorts Details Number of Contents in Sales Package Pack of 2 Fabric Cotton Lycra Type Cycling Shorts General Details Pattern Solid Ideal For Women's Fabric Care Gentle Ma… | No rating available | No rating available | Alisha | {"product_specification"=>[{"key"=>"Number of Contents in Sales Package", "value"=>"Pack of 2"}, {"key"=>"Fabric", "value"=>"Cotton Lycra"}, {"key"=>"Type", "value"=>"Cycling Shorts"}, {"key"=>"Pattern", "value"=>"Solid"}, {"key"=>"Ideal For", "value"=>"Women's"}, {"value"=>"Gentle Machine Wash in L… |
| bc940ea42ee6bef5ac7cea3fb5cfbee7 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/sicons-all-purpose-arnica-dog-shampoo/p/itmeh3zyw2vhgsp5?pid=PSOEH3ZYDMSYARJ5 | Sicons All Purpose Arnica Dog Shampoo | ["Pet Supplies >> Grooming >> Skin & Coat Care >> Shampoo >> Sicons All Purpose Arnica Dog Shampoo (500 ml)"] | PSOEH3ZYDMSYARJ5 | 220 | 210 | ["http://img5a.flixcart.com/image/pet-shampoo/r/j/5/sh-df-14-sicons-500-1100x1100-imaeh3hfvav85tva.jpeg", "http://img5a.flixcart.com/image/pet-shampoo/r/j/5/sh-df-14-sicons-500-original-imaeh3hfvav85tva.jpeg"] | False | Specifications of Sicons All Purpose Arnica Dog Shampoo (500 ml) General Pet Type Dog Brand Sicons Quantity 500 ml Model Number SH.DF-14 Type All Purpose Fragrance Arnica Form Factor Liquid In the Box Sales Package Shampoo Sicons Dog Fashion Arnica | No rating available | No rating available | Sicons | {"product_specification"=>[{"key"=>"Pet Type", "value"=>"Dog"}, {"key"=>"Brand", "value"=>"Sicons"}, {"key"=>"Quantity", "value"=>"500 ml"}, {"key"=>"Model Number", "value"=>"SH.DF-14"}, {"key"=>"Type", "value"=>"All Purpose"}, {"key"=>"Fragrance", "value"=>"Arnica"}, {"key"=>"Form Factor", "value"=… |
| c2a17313954882c1dba461863e98adf2 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/eternal-gandhi-super-series-crystal-paper-weights-silver-finish/p/itmeb7h2hrfgutxb?pid=PWTEB7H2E4KCYUE3 | Eternal Gandhi Super Series Crystal Paper Weights with Silver Finish | ["Eternal Gandhi Super Series Crystal Paper Weight..."] | PWTEB7H2E4KCYUE3 | 430 | 430 | ["http://img5a.flixcart.com/image/paper-weight/u/e/3/eternal-gandhi-gandhi-paper-weight-mark-v-1100x1100-imaeb8adyf3xmqhf.jpeg", "http://img5a.flixcart.com/image/paper-weight/u/e/3/eternal-gandhi-gandhi-paper-weight-mark-v-original-imaeb8adyf3xmqhf.jpeg"] | False | Key Features of Eternal Gandhi Super Series Crystal Paper Weights with Silver Finish Crystal paper weight Product Dimensions : 8cm x 8cm x 5cm A beautiful product Material: Crystal,Eternal Gandhi Super Series Crystal Paper Weights with Silver Finish (Set Of 1, Clear) Price: Rs. 430 Your office… | No rating available | No rating available | Eternal Gandhi | {"product_specification"=>[{"key"=>"Model Name", "value"=>"Gandhi Paper Weight Mark V"}, {"key"=>"Weight", "value"=>"323 g"}, {"value"=>"Paper Weight"}, {"key"=>"Paper Weight Material", "value"=>"Crystal"}, {"key"=>"Paper Weight Finish", "value"=>"Silver Finish"}]} |
| ce5a6818f7707e2cb61fdcdbba61f5ad | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/alisha-solid-women-s-cycling-shorts/p/itmeh2ftwkzykhcg?pid=SRTEH2FVVKRBAXHB | Alisha Solid Women's Cycling Shorts | ["Clothing >> Women's Clothing >> Lingerie, Sleep & Swimwear >> Shorts >> Alisha Shorts >> Alisha Solid Women's Cycling Shorts"] | SRTEH2FVVKRBAXHB | 1199 | 479 | ["http://img6a.flixcart.com/image/short/p/j/z/altght4p-26-alisha-38-original-imaeh2d5cqtxe5gt.jpeg", "http://img5a.flixcart.com/image/short/z/j/7/altght-7-alisha-38-original-imaeh2d5jsz2ghd6.jpeg", "http://img5a.flixcart.com/image/short/p/j/z/altght4p-26-alisha-38-original-imaeh2d5kbufss6n.jpeg", "h… | False | Key Features of Alisha Solid Women's Cycling Shorts Cotton Lycra Navy, Red, White, Red,Specifications of Alisha Solid Women's Cycling Shorts Shorts Details Number of Contents in Sales Package Pack of 4 Fabric Cotton Lycra Type Cycling Shorts General Details Pattern Solid Ideal For Women's In the Box… | No rating available | No rating available | Alisha | {"product_specification"=>[{"key"=>"Number of Contents in Sales Package", "value"=>"Pack of 4"}, {"key"=>"Fabric", "value"=>"Cotton Lycra"}, {"key"=>"Type", "value"=>"Cycling Shorts"}, {"key"=>"Pattern", "value"=>"Solid"}, {"key"=>"Ideal For", "value"=>"Women's"}, {"value"=>"4 shorts"}, {"key"=>"Sty… |
| 8542703ca9e6ebdf6d742638dfb1f2ca | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/fabhomedecor-fabric-double-sofa-bed/p/itmeh3qgnxztzcvf?pid=SBEEH3QGYGHFUEXN | FabHomeDecor Fabric Double Sofa Bed | ["Furniture >> Living Room Furniture >> Sofa Beds & Futons >> FabHomeDecor Fabric Double Sofa Bed (Finish Colo..."] | SBEEH3QGYGHFUEXN | 32157 | 22646 | ["http://img6a.flixcart.com/image/sofa-bed/e/x/n/fhd107-double-foam-fabhomedecor-brown-brown-1100x1100-imaeh3geypmfrc5a.jpeg", "http://img6a.flixcart.com/image/sofa-bed/e/x/n/fhd107-double-foam-fabhomedecor-brown-brown-original-imaeh3geypmfrc5a.jpeg", "http://img6a.flixcart.com/image/sofa-bed/e/x/n/… | False | FabHomeDecor Fabric Double Sofa Bed (Finish Color - Brown Mechanism Type - Pull Out) Price: Rs. 22,646 • Fine deep seating experience • Save Space with the all new click clack Sofa Bed • Easy to fold and vice versa with simple click clack mechanism • Chrome legs with mango wood frame for long term d… | No rating available | No rating available | FabHomeDecor | {"product_specification"=>[{"key"=>"Installation & Demo Details", "value"=>"Installation and demo for this product is done free of cost as part of this purchase. Our service partner will visit your location within 72 business hours from the delivery of the product."}, {"value"=>"1 Sofa Bed"}, {"key"… |
| 29c8d290caa451f97b1c32df64477a2c | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/dilli-bazaaar-bellies-corporate-casuals-casuals/p/itmeh2paagfuhbzh?pid=SHOEH3DZBFR88SCK | dilli bazaaar Bellies, Corporate Casuals, Casuals | ["Footwear >> Women's Footwear >> Ballerinas >> dilli bazaaar Bellies, Corporate Casuals, Casuals"] | SHOEH3DZBFR88SCK | 699 | 349 | ["http://img6a.flixcart.com/image/shoe/b/p/n/pink-200db202-dilli-bazaaar-10-original-imaeh2zz4x6hnuwf.jpeg", "http://img6a.flixcart.com/image/shoe/b/p/n/pink-200db202-dilli-bazaaar-10-original-imaeh2zzxp8s7gru.jpeg", "http://img6a.flixcart.com/image/shoe/s/c/k/pink-200db202-dilli-bazaaar-9-original-… | False | Key Features of dilli bazaaar Bellies, Corporate Casuals, Casuals Material: Fabric Occasion: Ethnic, Casual, Party, Formal Color: Pink Heel Height: 0,Specifications of dilli bazaaar Bellies, Corporate Casuals, Casuals General Occasion Ethnic, Casual, Party, Formal Ideal For Women Shoe Details Weight… | No rating available | No rating available | dilli bazaaar | {"product_specification"=>[{"key"=>"Occasion", "value"=>"Ethnic, Casual, Party, Formal"}, {"key"=>"Ideal For", "value"=>"Women"}, {"key"=>"Weight", "value"=>"200 g (per single Shoe) - Weight of the product may vary depending on size."}, {"key"=>"Heel Height", "value"=>"0 inch"}, {"key"=>"Outer Mater… |
| 4044c0ac52c1ee4b28777417651faf42 | 2016-03-25 22:59:23 +0000 | http://www.flipkart.com/alisha-solid-women-s-cycling-shorts/p/itmeh2fvdphhyshh?pid=SRTEH2FVUHAAVH9X | Alisha Solid Women's Cycling Shorts | ["Clothing >> Women's Clothing >> Lingerie, Sleep & Swimwear >> Shorts >> Alisha Shorts >> Alisha Solid Women's Cycling Shorts"] | SRTEH2FVUHAAVH9X | 1199 | 479 | ["http://img5a.flixcart.com/image/short/5/z/c/altght4p-39-alisha-38-original-imaeh2d5ar6m55zd.jpeg", "http://img5a.flixcart.com/image/short/z/h/b/altght-9-alisha-36-original-imaeh2d5khxcdggw.jpeg", "http://img6a.flixcart.com/image/short/z/h/b/altght-9-alisha-36-original-imaeh2d5yj4cnjtz.jpeg", "http… | False | Key Features of Alisha Solid Women's Cycling Shorts Cotton Lycra White, Black, Red, Black,Specifications of Alisha Solid Women's Cycling Shorts Shorts Details Number of Contents in Sales Package Pack of 4 Fabric Cotton Lycra Type Cycling Shorts General Details Pattern Solid Ideal For Women's Fabric … | No rating available | No rating available | Alisha | {"product_specification"=>[{"key"=>"Number of Contents in Sales Package", "value"=>"Pack of 4"}, {"key"=>"Fabric", "value"=>"Cotton Lycra"}, {"key"=>"Type", "value"=>"Cycling Shorts"}, {"key"=>"Pattern", "value"=>"Solid"}, {"key"=>"Ideal For", "value"=>"Women's"}, {"value"=>"Gentle Machine Wash in L… |
CREATE TABLE flipkart_com_ecommerce_sample (
"uniq_id" VARCHAR,
"crawl_timestamp" VARCHAR,
"product_url" VARCHAR,
"product_name" VARCHAR,
"product_category_tree" VARCHAR,
"pid" VARCHAR,
"retail_price" DOUBLE,
"discounted_price" DOUBLE,
"image" VARCHAR,
"is_fk_advantage_product" VARCHAR,
"description" VARCHAR,
"product_rating" VARCHAR,
"overall_rating" VARCHAR,
"brand" VARCHAR,
"product_specifications" VARCHAR
);