Digital Wallet Transactions

This a synthetic dataset for a digital wallet company.

@kaggle.harunrai_digital_wallet_transactions

Table List

1 table(420.35 KB)

Digital Wallet Transactions

@kaggle.harunrai_digital_wallet_transactions.digital_wallet_transactions

420.35 KB
5000 rows
16 columns

idx Idx	transaction_id Transaction Id	user_id User Id	transaction_date Transaction Date	product_category Product Category	product_name Product Name	merchant_name Merchant Name	product_amount Product Amount	transaction_fee Transaction Fee	cashback Cashback	loyalty_points Loyalty Points	payment_method Payment Method	transaction_status Transaction Status	merchant_id Merchant Id	device_type Device Type	location Location
1	4dac3ea3-6492-46ec-80b8-dc45c3ad0b14	USER_05159	Sat Aug 19 2023 03:32:00 GMT+0000 (Coordinated Universal Time)	Rent Payment	2BHK Flat Deposit	Airbnb	1525.39	36.69	19.19	186	Debit Card	Successful	MERCH_0083	iOS	Urban
2	a903ed9f-eb84-47e7-b8aa-fd1786c919cf	USER_07204	Sat Aug 19 2023 04:37:00 GMT+0000 (Coordinated Universal Time)	Gas Bill	Commercial Gas Connection	Adani Gas	1495.4	28.19	89.99	182	UPI	Successful	MERCH_0163	iOS	Urban
3	2a393013-733c-4add-9f09-bed1eeb33676	USER_00903	Sat Aug 19 2023 05:52:00 GMT+0000 (Coordinated Universal Time)	Bus Ticket	Semi-Sleeper	MakeMyTrip Bus	1267.71	11.36	95.7	994	UPI	Successful	MERCH_0320	iOS	Urban
4	9a07ad19-4673-4794-9cd2-9b139f39c715	USER_01769	Sat Aug 19 2023 06:35:00 GMT+0000 (Coordinated Universal Time)	Internet Bill	4G Unlimited Plan	Airtel Broadband	9202.63	6.41	82.24	409	Debit Card	Successful	MERCH_0194	Android	Urban
5	76418260-c985-4011-979d-0914604d0d68	USER_03544	Sat Aug 19 2023 06:36:00 GMT+0000 (Coordinated Universal Time)	Loan Repayment	Home Loan EMI	Axis Bank	3100.58	41.15	40.47	837	Debit Card	Successful	MERCH_0504	Android	Urban
6	2ee6c8d8-9e9e-47b6-95e8-932af851ca43	USER_07548	Sat Aug 19 2023 06:46:00 GMT+0000 (Coordinated Universal Time)	Flight Booking	Delhi to Mumbai	Yatra	8430.75	44.55	52.61	269	UPI	Successful	MERCH_0476	Android	Urban
7	89df83e5-98d3-4c0f-b273-59b0d057fc34	USER_05280	Sat Aug 19 2023 07:15:00 GMT+0000 (Coordinated Universal Time)	Hotel Booking	Villa	Treebo	6688.17	49.62	22.18	58	UPI	Successful	MERCH_0441	Android	Urban
8	1a8ab910-657a-4e57-90ec-90420290e8a1	USER_03459	Sat Aug 19 2023 07:57:00 GMT+0000 (Coordinated Universal Time)	Gas Bill	Piped Natural Gas	Adani Gas	1802.28	0.11	14.56	950	UPI	Successful	MERCH_0938	iOS	Urban
9	48fc902d-0952-4a20-9d57-b54663affe79	USER_04329	Sat Aug 19 2023 09:14:00 GMT+0000 (Coordinated Universal Time)	Internet Bill	Broadband 50Mbps Plan	Airtel Broadband	4262.28	2.66	67.63	675	UPI	Successful	MERCH_0156	iOS	Urban
10	19c7d2d5-8566-42ba-95aa-8d803cfeeffd	USER_07264	Sat Aug 19 2023 10:01:00 GMT+0000 (Coordinated Universal Time)	Insurance Premium	Term Life Policy	Max Life	2207.9	45.7	21.87	129	Wallet Balance	Successful	MERCH_0245	iOS	Urban


CREATE TABLE digital_wallet_transactions (
  "idx" BIGINT,
  "transaction_id" VARCHAR,
  "user_id" VARCHAR,
  "transaction_date" TIMESTAMP,
  "product_category" VARCHAR,
  "product_name" VARCHAR,
  "merchant_name" VARCHAR,
  "product_amount" DOUBLE,
  "transaction_fee" DOUBLE,
  "cashback" DOUBLE,
  "loyalty_points" BIGINT,
  "payment_method" VARCHAR,
  "transaction_status" VARCHAR,
  "merchant_id" VARCHAR,
  "device_type" VARCHAR,
  "location" VARCHAR
);