Capstone - Credit Card Fraud Detection

Credit Card Fraud Detection by Aditya Kumar Pal

@kaggle.erak1006_capstone_credit_card_fraud_detection

Table List

1 table(69.84 MB)

Creditcard

@kaggle.erak1006_capstone_credit_card_fraud_detection.creditcard

69.84 MB
284807 rows
31 columns

time Time	v1 V1	v2 V2	v3 V3	v4 V4	v5 V5	v6 V6	v7 V7	v8 V8	v9 V9	v10 V10	v11 V11	v12 V12	v13 V13	v14 V14	v15 V15	v16 V16	v17 V17	v18 V18	v19 V19	v20 V20	v21 V21	v22 V22	v23 V23	v24 V24	v25 V25	v26 V26	v27 V27	v28 V28	amount Amount
	-1.3598071336738	-0.0727811733098497	2.53634673796914	1.37815522427443	-0.338320769942518	0.462387777762292	0.239598554061257	0.0986979012610507	0.363786969611213	0.0907941719789316	-0.551599533260813	-0.617800855762348	-0.991389847235408	-0.311169353699879	1.46817697209427	-0.470400525259478	0.207971241929242	0.0257905801985591	0.403992960255733	0.251412098239705	-0.018306777944153	0.277837575558899	-0.110473910188767	0.0669280749146731	0.128539358273528	-0.189114843888824	0.133558376740387	-0.0210530534538215	149.62
	1.19185711131486	0.26615071205963	0.16648011335321	0.448154078460911	0.0600176492822243	-0.0823608088155687	-0.0788029833323113	0.0851016549148104	-0.255425128109186	-0.166974414004614	1.61272666105479	1.06523531137287	0.48909501589608	-0.143772296441519	0.635558093258208	0.463917041022171	-0.114804663102346	-0.183361270123994	-0.145783041325259	-0.0690831352230203	-0.225775248033138	-0.638671952771851	0.101288021253234	-0.339846475529127	0.167170404418143	0.125894532368176	-0.0089830991432281	0.0147241691924927	2.69
1	-1.35835406159823	-1.34016307473609	1.77320934263119	0.379779593034328	-0.503198133318193	1.80049938079263	0.791460956450422	0.247675786588991	-1.51465432260583	0.207642865216696	0.624501459424895	0.066083685268831	0.717292731410831	-0.165945922763554	2.34586494901581	-2.89008319444231	1.10996937869599	-0.121359313195888	-2.26185709530414	0.524979725224404	0.247998153469754	0.771679401917229	0.909412262347719	-0.689280956490685	-0.327641833735251	-0.139096571514147	-0.0553527940384261	-0.0597518405929204	378.66
1	-0.966271711572087	-0.185226008082898	1.79299333957872	-0.863291275036453	-0.0103088796030823	1.24720316752486	0.23760893977178	0.377435874652262	-1.38702406270197	-0.0549519224713749	-0.226487263835401	0.178228225877303	0.507756869957169	-0.28792374549456	-0.631418117709045	-1.0596472454325	-0.684092786345479	1.96577500349538	-1.2326219700892	-0.208037781160366	-0.108300452035545	0.0052735967825345	-0.190320518742841	-1.17557533186321	0.647376034602038	-0.221928844458407	0.0627228487293033	0.0614576285006353	123.5
2	-1.15823309349523	0.877736754848451	1.548717846511	0.403033933955121	-0.407193377311653	0.0959214624684256	0.592940745385545	-0.270532677192282	0.817739308235294	0.753074431976354	-0.822842877946363	0.53819555014995	1.3458515932154	-1.11966983471731	0.175121130008994	-0.451449182813529	-0.237033239362776	-0.0381947870352842	0.803486924960175	0.408542360392758	-0.0094306971323291	0.79827849458971	-0.137458079619063	0.141266983824769	-0.206009587619756	0.502292224181569	0.219422229513348	0.215153147499206	69.99
2	-0.425965884412454	0.960523044882985	1.14110934232219	-0.168252079760302	0.42098688077219	-0.0297275516639742	0.476200948720027	0.260314333074874	-0.56867137571251	-0.371407196834471	1.34126198001957	0.359893837038039	-0.358090652573631	-0.137133700217612	0.517616806555742	0.401725895589603	-0.0581328233640131	0.0686531494425432	-0.0331937877876282	0.0849676720682049	-0.208253514656728	-0.559824796253248	-0.0263976679795373	-0.371426583174346	-0.232793816737034	0.105914779097957	0.253844224739337	0.0810802569229443	3.67
4	1.22965763450793	0.141003507049326	0.0453707735899449	1.20261273673594	0.191880988597645	0.272708122899098	-0.0051590028825098	0.0812129398830894	0.464959994783886	-0.0992543211289237	-1.41690724314928	-0.153825826253651	-0.75106271556262	0.16737196252175	0.0501435942254188	-0.443586797916727	0.002820512472347	-0.61198733994012	-0.0455750446637976	-0.21963255278686	-0.167716265815783	-0.270709726172363	-0.154103786809305	-0.780055415004671	0.75013693580659	-0.257236845917139	0.0345074297438413	0.0051677689062491	4.99
7	-0.644269442348146	1.41796354547385	1.0743803763556	-0.492199018495015	0.948934094764157	0.428118462833089	1.12063135838353	-3.80786423873589	0.615374730667027	1.24937617815176	-0.619467796121913	0.291474353088705	1.75796421396042	-1.32386521970526	0.686132504394383	-0.0761269994382006	-1.2221273453247	-0.358221569869078	0.324504731321494	-0.156741852488285	1.94346533978412	-1.01545470979971	0.057503529867291	-0.649709005559993	-0.415266566234811	-0.0516342969262494	-1.20692108094258	-1.08533918832377	40.8
7	-0.89428608220282	0.286157196276544	-0.113192212729871	-0.271526130088604	2.6695986595986	3.72181806112751	0.370145127676916	0.851084443200905	-0.392047586798604	-0.410430432848439	-0.705116586646536	-0.110452261733098	-0.286253632470583	0.0743553603016731	-0.328783050303565	-0.210077268148783	-0.499767968800267	0.118764861004217	0.57032816746536	0.0527356691149697	-0.0734251001059225	-0.268091632235551	-0.204232669947878	1.0115918018785	0.373204680146282	-0.384157307702294	0.0117473564581996	0.14240432992147	93.2
9	-0.33826175242575	1.11959337641566	1.04436655157316	-0.222187276738296	0.49936080649727	-0.24676110061991	0.651583206489972	0.0695385865186387	-0.736727316364109	-0.366845639206541	1.01761446783262	0.836389570307029	1.00684351373408	-0.443522816876142	0.150219101422635	0.739452777052119	-0.540979921943059	0.47667726004282	0.451772964394125	0.203711454727929	-0.246913936910008	-0.633752642406113	-0.12079408408185	-0.385049925313426	-0.0697330460416923	0.0941988339514961	0.246219304619926	0.0830756493473326	3.68


CREATE TABLE creditcard (
  "time" DOUBLE,
  "v1" DOUBLE,
  "v2" DOUBLE,
  "v3" DOUBLE,
  "v4" DOUBLE,
  "v5" DOUBLE,
  "v6" DOUBLE,
  "v7" DOUBLE,
  "v8" DOUBLE,
  "v9" DOUBLE,
  "v10" DOUBLE,
  "v11" DOUBLE,
  "v12" DOUBLE,
  "v13" DOUBLE,
  "v14" DOUBLE,
  "v15" DOUBLE,
  "v16" DOUBLE,
  "v17" DOUBLE,
  "v18" DOUBLE,
  "v19" DOUBLE,
  "v20" DOUBLE,
  "v21" DOUBLE,
  "v22" DOUBLE,
  "v23" DOUBLE,
  "v24" DOUBLE,
  "v25" DOUBLE,
  "v26" DOUBLE,
  "v27" DOUBLE,
  "v28" DOUBLE,
  "amount" DOUBLE,
  "class" BIGINT
);