Baselight

AmazonSalesReport

In this project I am doing basic EDA on Amazon Sales .

@kaggle.arpit2712_amazonsalesreport

Amazon Sale Report
@kaggle.arpit2712_amazonsalesreport.amazon_sale_report

  • 3.78 MB
  • 128976 rows
  • 21 columns
index

Index

order_id

Order ID

date

Date

status

Status

fulfilment

Fulfilment

sales_channel

Sales Channel

ship_service_level

Ship-service-level

category

Category

size

Size

courier_status

Courier Status

qty

Qty

currency

Currency

amount

Amount

ship_city

Ship-city

ship_state

Ship-state

ship_postal_code

Ship-postal-code

ship_country

Ship-country

b2b

B2B

fulfilled_by

Fulfilled-by

new

New

pendings

PendingS

405-8078784-573154504-30-22CancelledMerchantAmazon.inStandardT-shirtSOn the WayINR647.62MUMBAIMAHARASHTRA400081INEasy Ship
1171-9198151-110114604-30-22Shipped - Delivered to BuyerMerchantAmazon.inStandardShirt3XLShipped1INR406BENGALURUKARNATAKA560085INEasy Ship
2404-0687676-727314604-30-22ShippedAmazonAmazon.inExpeditedShirtXLShipped1INR329NAVI MUMBAIMAHARASHTRA410210INtruenan
3403-9615377-813395104-30-22CancelledMerchantAmazon.inStandardBlazzerLOn the WayINR753.33PUDUCHERRYPUDUCHERRY605008INEasy Ship
4407-1069790-724032004-30-22ShippedAmazonAmazon.inExpeditedTrousers3XLShipped1INR574CHENNAITAMIL NADU600073INnan
5404-1490984-457876504-30-22ShippedAmazonAmazon.inExpeditedT-shirtXLShipped1INR824GHAZIABADUTTAR PRADESH201102INnan
6408-5748499-685955504-30-22ShippedAmazonAmazon.inExpeditedT-shirtLShipped1INR653CHANDIGARHCHANDIGARH160036INnan
7406-7807733-378594504-30-22Shipped - Delivered to BuyerMerchantAmazon.inStandardShirtSShipped1INR399HYDERABADTELANGANA500032INEasy Ship
8407-5443024-523316804-30-22CancelledAmazonAmazon.inExpeditedT-shirt3XLCancellednanHYDERABADTELANGANA500008INnan
9402-4393761-031152004-30-22ShippedAmazonAmazon.inExpeditedShirtXXLShipped1INR363ChennaiTAMIL NADU600041INnan

CREATE TABLE amazon_sale_report (
  "index" BIGINT,
  "order_id" VARCHAR,
  "date" VARCHAR,
  "status" VARCHAR,
  "fulfilment" VARCHAR,
  "sales_channel" VARCHAR,
  "ship_service_level" VARCHAR,
  "category" VARCHAR,
  "size" VARCHAR,
  "courier_status" VARCHAR,
  "qty" BIGINT,
  "currency" VARCHAR,
  "amount" DOUBLE,
  "ship_city" VARCHAR,
  "ship_state" VARCHAR,
  "ship_postal_code" DOUBLE,
  "ship_country" VARCHAR,
  "b2b" BOOLEAN,
  "fulfilled_by" VARCHAR,
  "new" VARCHAR,
  "pendings" VARCHAR
);

Share link

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