Baselight

Retail Transactional Dataset

Exploring Insights into Consumer Behavior and Operations in Retail Transactions

@kaggle.bhavikjikadara_retail_transactional_dataset

Retail Data
@kaggle.bhavikjikadara_retail_transactional_dataset.retail_data

  • 26.82 MB
  • 302010 rows
  • 30 columns
transaction_id

Transaction ID

customer_id

Customer ID

name

Name

email

Email

phone

Phone

address

Address

city

City

state

State

zipcode

Zipcode

country

Country

age

Age

gender

Gender

income

Income

customer_segment

Customer Segment

date

Date

year

Year

month

Month

time

Time

total_purchases

Total Purchases

amount

Amount

total_amount

Total Amount

product_category

Product Category

product_brand

Product Brand

product_type

Product Type

feedback

Feedback

shipping_method

Shipping Method

payment_method

Payment Method

order_status

Order Status

ratings

Ratings

products

Products

869178837249Michelle HarringtonEbony39@gmail.com14147868013959 Amanda BurgsDortmundBerlin77985Germany21MaleLowRegular9/18/20232023September22:03:553108.0287567324.08627ClothingNikeShortsExcellentSame-DayDebit CardShipped5Cycling shorts
217477369749Kelsey HillMark36@gmail.com685289998782072 Dawn CentersNottinghamEngland99071UK19FemaleLowPremium12/31/20232023December8:42:042403.3539073806.7078147ElectronicsSamsungTabletExcellentStandardCredit CardProcessing4Lenovo Tab
667961030192Scott JensenShane85@gmail.com83621604494133 Young CanyonGeelongNew South Wales75929Australia48MaleLowRegular4/26/20232023April4:06:293354.47759971063.432799BooksPenguin BooksChildren'sAverageSame-DayCredit CardProcessing2Sports equipment
723246062101Joseph MillerMary34@gmail.com27767517248148 Thomas Creek Suite 100EdmontonOntario88420Canada56MaleHighPremium05-08-232023May14:55:177352.40771732466.854021Home DecorHome DepotToolsExcellentStandardPayPalProcessing4Utility knife
498377527901Debra ColemanCharles30@gmail.com90982676355813 Lori Ports Suite 269BristolEngland48704UK22MaleLowPremium01-10-242024January16:54:072124.2765245248.5530491GroceryNestleChocolateBadStandardCashShipped1Chocolate cookies
609532641289Ryan JohnsonHaley12@gmail.com3292677006532 Ashley Crest Suite 014BrisbaneNew South Wales74430Australia58FemaleMediumPremium9/21/20232023September23:24:274296.29180591185.167224ElectronicsAppleTabletGoodExpressPayPalPending4Lenovo Tab
543409697285Erin LewisArthur76@gmail.com1578355423600 Brian Prairie Suite 497KitchenerOntario47545Canada29FemaleLowNew6/26/20232023June13:35:512315.0576476630.1152951ElectronicsSamsungTelevisionBadStandardCashProcessing1QLED TV
234467526603Angela FieldsTanya94@gmail.com3668096144237 Young CurveMunichBerlin86862Germany29MaleMediumPremium3/24/20232023March10:12:56146.5880703846.58807038ClothingZaraShirtBadSame-DayCashProcessing1Dress shirt
415584580175Diane ClarkMartin39@gmail.com62197795578823 Mariah Heights Apt. 263WollongongNew South Wales39820Australia46MaleMediumNew01-06-242024January14:38:268328.83930172630.714413GroceryNestleChocolateBadSame-DayCashDelivered1Dark chocolate
492614831878Lori BellJessica33@gmail.com60048950596225 William LodgeCologneBerlin64317Germany25MaleMediumNew10-04-232023October22:27:4010397.61122953976.112295Home DecorHome DepotDecorationsExcellentStandardCashDelivered4Candles

CREATE TABLE retail_data (
  "transaction_id" DOUBLE,
  "customer_id" DOUBLE,
  "name" VARCHAR,
  "email" VARCHAR,
  "phone" DOUBLE,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "country" VARCHAR,
  "age" DOUBLE,
  "gender" VARCHAR,
  "income" VARCHAR,
  "customer_segment" VARCHAR,
  "date" VARCHAR,
  "year" DOUBLE,
  "month" VARCHAR,
  "time" VARCHAR,
  "total_purchases" DOUBLE,
  "amount" DOUBLE,
  "total_amount" DOUBLE,
  "product_category" VARCHAR,
  "product_brand" VARCHAR,
  "product_type" VARCHAR,
  "feedback" VARCHAR,
  "shipping_method" VARCHAR,
  "payment_method" VARCHAR,
  "order_status" VARCHAR,
  "ratings" DOUBLE,
  "products" VARCHAR
);

Share link

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