ANZ Banking Data
Financial Data- Transactions
@kaggle.prateekmaj21_anz_banking_data
Anz
@kaggle.prateekmaj21_anz_banking_data.anz
- 988.35 KB
- 12043 rows
- 23 columns
statusStatus | card_present_flagCard Present Flag | bpay_biller_codeBpay Biller Code | accountAccount | currencyCurrency | long_latLong Lat | txn_descriptionTxn Description | merchant_idMerchant Id | merchant_codeMerchant Code | first_nameFirst Name | balanceBalance | dateDate | genderGender | ageAge | merchant_suburbMerchant Suburb | merchant_stateMerchant State | extractionExtraction | amountAmount | transaction_idTransaction Id | countryCountry | customer_idCustomer Id | merchant_long_latMerchant Long Lat | movementMovement |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);