Online Retail Data II
A real online retail transaction data set of two years.
@kaggle.whenamancodes_online_retail_data_ii
A real online retail transaction data set of two years.
@kaggle.whenamancodes_online_retail_data_ii
This Online Retail Data II contains all the transactions occurring for a UK-based and registered, non-store online retail between 01/12/2009 and 09/12/2011.The company mainly sells unique all-occasion gift-ware. Many customers of the company are wholesalers.
| Columns | Description |
|---|---|
| InvoiceNo | Invoice number (Nominal. A 6-digit integral number uniquely assigned to each transaction. If this code starts with the letter 'c', it indicates a cancellation.) |
| StockCode | Product (item) code (Nominal. A 5-digit integral number uniquely assigned to each distinct product.) |
| Description | Product (item) name |
| Quantity | The quantities of each product (item) per transaction |
| InvoiceDate | Invoice date and time |
| UnitPrice | Product price per unit in sterling (£) |
| CustomerID | Customer number (Nominal. A 5-digit integral number uniquely assigned to each customer.) |
| Country | The name of the country where a customer resides. |
More
CREATE TABLE online_retail_data_year_2009_2010_2011 (
"invoice" VARCHAR,
"stockcode" VARCHAR,
"description" VARCHAR,
"quantity" BIGINT,
"invoicedate" VARCHAR,
"price" DOUBLE,
"customer_id" DOUBLE,
"country" VARCHAR
);Anyone who has the link will be able to view this.