ANZ Data@ANZ Program

Dataset from InsideSherpa's virtual experience program

@kaggle.ashraf1997_anz_synthesised_transaction_dataset

Table List

1 table(988.35 KB)

Anz

@kaggle.ashraf1997_anz_synthesised_transaction_dataset.anz

988.35 KB
12043 rows
23 columns

status Status	card_present_flag Card Present Flag	bpay_biller_code Bpay Biller Code	account Account	currency Currency	long_lat Long Lat	txn_description Txn Description	merchant_id Merchant Id	first_name First Name	balance Balance	date Date	gender Gender	age Age	merchant_suburb Merchant Suburb	merchant_state Merchant State	extraction Extraction	amount Amount	transaction_id Transaction Id	country Country	customer_id Customer Id	merchant_long_lat Merchant Long Lat	movement Movement
authorized	1	nan	ACC-1598451071	AUD	153.41 -27.95	POS	81c48296-73be-44a7-befa-d053f48ce7cd	Diana	35.39	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	26	Ashmore	QLD	2018-08-01T01:01:15.000+0000	16.25	a623070bfead4541a6b0fff8a09e706c	Australia	CUS-2487424745	153.38 -27.99	debit
authorized		nan	ACC-1598451071	AUD	153.41 -27.95	SALES-POS	830a451c-316e-4a6a-bf25-e37caedca49e	Diana	21.2	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	26	Sydney	NSW	2018-08-01T01:13:45.000+0000	14.19	13270a2a902145da9db4c951e04b51b9	Australia	CUS-2487424745	151.21 -33.87	debit
authorized	1	nan	ACC-1222300524	AUD	151.23 -33.94	POS	835c231d-8cdf-4e96-859d-e9d571760cf0	Michael	5.71	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	M	38	Sydney	NSW	2018-08-01T01:26:15.000+0000	6.42	feb79e7ecd7048a5a36ec889d1a94270	Australia	CUS-2142601169	151.21 -33.87	debit
authorized	1	nan	ACC-1037050564	AUD	153.10 -27.66	SALES-POS	48514682-c78a-4a88-b0da-2d6302e64673	Rhonda	2117.22	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	40	Buderim	QLD	2018-08-01T01:38:45.000+0000	40.9	2698170da3704fd981b15e64a006079e	Australia	CUS-1614226872	153.05 -26.68	debit
authorized	1	nan	ACC-1598451071	AUD	153.41 -27.95	SALES-POS	b4e02c10-0852-4273-b8fd-7b3395e32eb0	Diana	17.95	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	26	Mermaid Beach	QLD	2018-08-01T01:51:15.000+0000	3.25	329adf79878c4cf0aeb4188b4691c266	Australia	CUS-2487424745	153.44 -28.06	debit
posted		nan	ACC-1608363396	AUD	151.22 -33.87	PAYMENT	nan	Robert	1705.43	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	M	20	nan	nan	2018-08-01T02:00:00.000+0000	163	1005b48a6eda4ffd85e9b649dc9467d3	Australia	CUS-2688605418	nan	debit
authorized	1	nan	ACC-2776252858	AUD	144.95 -37.76	SALES-POS	3aa18033-a0a9-4190-a117-b7caaf4d07e3	Kristin	1248.36	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	43	Kalkallo	VIC	2018-08-01T02:23:04.000+0000	61.06	b79ca208099c4c28aa5dae966096d842	Australia	CUS-4123612273	144.95 -37.53	debit
authorized	1	nan	ACC-2776252858	AUD	144.95 -37.76	POS	ee58145d-26e8-4b01-9cd9-62378014f21d	Kristin	1232.75	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	43	Melbourne	VIC	2018-08-01T04:11:25.000+0000	15.61	e1c4a50d6a0549cbb3710a62a2fa00d5	Australia	CUS-4123612273	144.96 -37.81	debit
authorized	1	nan	ACC-182446574	AUD	116.06 -32.00	POS	cfbf535e-caa8-499f-9d41-bbdc2b836d85	Tonya	213.16	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	F	27	Yokine	WA	2018-08-01T04:40:00.000+0000	19.25	799e39eb2c1b411185424b0f2cd18bda	Australia	CUS-3026014945	115.85 -31.9	debit
posted		nan	ACC-602667573	AUD	151.23 -33.96	INTER BANK	nan	Michael	466.58	Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	M	40	nan	nan	2018-08-01T06:00:00.000+0000	21	798a77869014441b840a7a8a23408332	Australia	CUS-2031327464	nan	debit


CREATE TABLE anz (
  "status" VARCHAR,
  "card_present_flag" DOUBLE,
  "bpay_biller_code" VARCHAR,
  "account" VARCHAR,
  "currency" VARCHAR,
  "long_lat" VARCHAR,
  "txn_description" VARCHAR,
  "merchant_id" VARCHAR,
  "merchant_code" DOUBLE,
  "first_name" VARCHAR,
  "balance" DOUBLE,
  "date" TIMESTAMP,
  "gender" VARCHAR,
  "age" BIGINT,
  "merchant_suburb" VARCHAR,
  "merchant_state" VARCHAR,
  "extraction" VARCHAR,
  "amount" DOUBLE,
  "transaction_id" VARCHAR,
  "country" VARCHAR,
  "customer_id" VARCHAR,
  "merchant_long_lat" VARCHAR,
  "movement" VARCHAR
);