Customer Credit Card Data

Analyzing Patterns and Trends in Credit Card Usage

@kaggle.fhabibimoghaddam_customer_credit_card_data

Table List

1 table(541.95 KB)

Customer Data

@kaggle.fhabibimoghaddam_customer_credit_card_data.customer_data

541.95 KB
8950 rows
18 columns

cust_id CUST ID	balance BALANCE	balance_frequency BALANCE FREQUENCY	purchases PURCHASES	one_off_purchases ONE OFF PURCHASES	installments_purchases INSTALLMENTS PURCHASES	cash_advance CASH ADVANCE	purchases_frequency PURCHASES FREQUENCY	one_off_purchases_frequency ONE OFF PURCHASES FREQUENCY	purchases_installments_frequency PURCHASES INSTALLMENTS FREQUENCY	cash_advance_frequency CASH ADVANCE FREQUENCY	cash_advance_trx CASH ADVANCE TRX	purchases_trx PURCHASES TRX	credit_limit CREDIT LIMIT	payments PAYMENTS	minimum_payments MINIMUM PAYMENTS	prc_full_payment PRC FULL PAYMENT	tenure TENURE
C10001	40.900749	0.818182	95.4		95.4		0.166667		0.083333			2	1000	201.802084	139.509787		12
C10002	3202.467416	0.909091				6442.945483				0.25	4		7000	4103.032597	1072.340217	0.222222	12
C10003	2495.148862	1	773.17	773.17			1	1				12	7500	622.066742	627.284787		12
C10004	1666.670542	0.636364	1499	1499		205.788017	0.083333	0.083333		0.083333	1	1	7500				12
C10005	817.714335	1	16	16			0.083333	0.083333				1	1200	678.334763	244.791237		12
C10006	1809.828751	1	1333.28		1333.28		0.666667		0.583333			8	1800	1400.05777	2407.246035		12
C10007	627.260806	1	7091.01	6402.63	688.38		1	1	1			64	13500	6354.314328	198.065894	1	12
C10008	1823.652743	1	436.2		436.2		1		1			12	2300	679.065082	532.03399		12
C10009	1014.926473	1	861.49	661.49	200		0.333333	0.083333	0.25			5	7000	688.278568	311.963409		12
C10010	152.225975	0.545455	1281.6	1281.6			0.166667	0.166667				3	11000	1164.770591	100.302262		12


CREATE TABLE customer_data (
  "cust_id" VARCHAR,
  "balance" DOUBLE,
  "balance_frequency" DOUBLE,
  "purchases" DOUBLE,
  "one_off_purchases" DOUBLE,
  "installments_purchases" DOUBLE,
  "cash_advance" DOUBLE,
  "purchases_frequency" DOUBLE,
  "one_off_purchases_frequency" DOUBLE,
  "purchases_installments_frequency" DOUBLE,
  "cash_advance_frequency" DOUBLE,
  "cash_advance_trx" BIGINT,
  "purchases_trx" BIGINT,
  "credit_limit" DOUBLE,
  "payments" DOUBLE,
  "minimum_payments" DOUBLE,
  "prc_full_payment" DOUBLE,
  "tenure" BIGINT
);