Comprehensive Credit Card Transactions Dataset

Unraveling Consumer Transactions Flow: A Comprehensive Credit Card Dataset

@kaggle.rajatsurana979_comprehensive_credit_card_transactions_dataset

Table List

1 table(1.37 MB)

Credit Card Transaction Flow

@kaggle.rajatsurana979_comprehensive_credit_card_transactions_dataset.credit_card_transaction_flow

1.37 MB
50000 rows
9 columns

customer_id Customer ID	name Name	surname Surname	gender Gender	birthdate Birthdate	transaction_amount Transaction Amount	date Date	merchant_name Merchant Name	category Category
752858	Sean	Rodriguez	F	20-10-2002	35.47	03-04-2023	Smith-Russell	Cosmetic
26381	Michelle	Phelps	nan	24-10-1985	2552.72	17-07-2023	Peck, Spence and Young	Travel
305449	Jacob	Williams	M	25-10-1981	115.97	20-09-2023	Steele Inc	Clothing
988259	Nathan	Snyder	M	26-10-1977	11.31	11-01-2023	Wilson, Wilson and Russell	Cosmetic
764762	Crystal	Knapp	F	02-11-1951	62.21	13-06-2023	Palmer-Hinton	Electronics
576539	Monica	Bartlett	F	20-10-2001	99.14	24-08-2023	Tran, Torres and Joyce	Cosmetic
124681	Thomas	Shaw	nan	26-10-1976	145.94	30-08-2023	Evans, Griffin and Torres	Cosmetic
521807	Kelsey	Pena	F	28-10-1968	161.39	08-02-2023	Miller PLC	Cosmetic
504238	Denise	Porter	M	31-10-1957	77.73	12-01-2023	Jackson-Morgan	Restaurant
583532	Alexander	Richardson	F	27-10-1974	142.85	07-06-2023	Blake, Mays and Anderson	Clothing


CREATE TABLE credit_card_transaction_flow (
  "customer_id" BIGINT,
  "name" VARCHAR,
  "surname" VARCHAR,
  "gender" VARCHAR,
  "birthdate" VARCHAR,
  "transaction_amount" DOUBLE,
  "date" VARCHAR,
  "merchant_name" VARCHAR,
  "category" VARCHAR
);