Dataset: Super Market Sales

About this Dataset

Super Market Sales

Here's a brief description of each of the attributes or labels in the dataset:

Invoice ID: A unique identifier for each invoice or transaction.
Branch: The branch or location where the transaction occurred.
City: The city where the branch is located.
Customer Type: Indicates whether the customer is a regular or new customer.
Gender: The gender of the customer.
Product Line: The category or type of product purchased.
Unit Price: The price of a single unit of the product.
Quantity: The number of units of the product purchased.
Tax 5%: The amount of tax (5% of the total cost) applied to the transaction.
Total: The total cost of the transaction, including tax.
Date: The date when the transaction took place.
Time: The time of day when the transaction occurred.
Payment: The payment method used (e.g., credit card, cash).
COGS (Cost of Goods Sold): The direct costs associated with producing or purchasing the products sold.
Gross Margin Percentage: The profit margin percentage for the transaction.
Gross Income: The total profit earned from the transaction.
Rating: Customer satisfaction rating or feedback on the transaction.

For instance, if you were interested in predicting customer satisfaction, Rating might be a suitable label. If you were trying to predict sales or revenue, Total or Gross Income could be a potential label.

Tables

Supermarket Sales

@kaggle.arunjangir245_super_market_sales.supermarket_sales

61.58 KB
1000 rows
17 columns


CREATE TABLE supermarket_sales (
  "invoice_id" VARCHAR,
  "branch" VARCHAR,
  "city" VARCHAR,
  "customer_type" VARCHAR,
  "gender" VARCHAR,
  "product_line" VARCHAR,
  "unit_price" DOUBLE,
  "quantity" BIGINT,
  "tax_5" DOUBLE,
  "total" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "payment" VARCHAR,
  "cogs" DOUBLE,
  "gross_margin_percentage" DOUBLE,
  "gross_income" DOUBLE,
  "rating" DOUBLE
);