Credit Card Fraud
Python analysis applied to Fraud detection
@kaggle.oscaryezfeijo_credit_card_fraud
Creditcardfraud
@kaggle.oscaryezfeijo_credit_card_fraud.creditcardfraud
- 13.59 MB
- 49692 rows
- 31 columns
timeTime | v1V1 | v2V2 | v3V3 | v4V4 | v5V5 | v6V6 | v7V7 | v8V8 | v9V9 | v10V10 | v11V11 | v12V12 | v13V13 | v14V14 | v15V15 | v16V16 | v17V17 | v18V18 | v19V19 | v20V20 | v21V21 | v22V22 | v23V23 | v24V24 | v25V25 | v26V26 | v27V27 | v28V28 | amountAmount | classClass |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 406 | -2.312226542 | 1.951992011 | -1.609850732 | 3.997905588 | -0.522187865 | -1.426545319 | -2.537387306 | 1.391657248 | -2.770089277 | -2.772272145 | 3.202033207 | -2.899907388 | -0.595221881 | -4.289253782 | 0.38972412 | -1.14074718 | -2.830055675 | -0.016822468 | 0.416955705 | 0.126910559 | 0.517232371 | -0.035049369 | -0.465211076 | 0.320198199 | 0.044519167 | 0.177839798 | 0.261145003 | -0.143275875 | yes | |
| 472 | -3.043540624 | -3.157307121 | 1.08846278 | 2.288643618 | 1.35980513 | -1.064822523 | 0.325574266 | -0.067793653 | -0.270952836 | -0.838586565 | -0.414575448 | -0.50314086 | 0.676501545 | -1.692028933 | 2.000634839 | 0.666779696 | 0.599717414 | 1.725321007 | 0.28334483 | 2.102338793 | 0.661695925 | 0.435477209 | 1.375965743 | -0.293803153 | 0.279798032 | -0.145361715 | -0.252773123 | 0.035764225 | 529 | yes |
| 4462 | -2.303349568 | 1.75924746 | -0.359744743 | 2.330243051 | -0.821628328 | -0.075787571 | 0.562319782 | -0.399146578 | -0.238253368 | -1.525411627 | 2.032912158 | -6.560124295 | 0.022937323 | -1.470101536 | -0.698826069 | -2.282193829 | -4.781830856 | -2.615664945 | -1.334441067 | -0.430021867 | -0.294166318 | -0.932391057 | 0.172726296 | -0.087329538 | -0.156114265 | -0.542627889 | 0.039565989 | -0.153028797 | 239.93 | yes |
| 6986 | -4.397974442 | 1.358367028 | -2.592844218 | 2.679786967 | -1.128130942 | -1.706536388 | -3.496197293 | -0.248777743 | -0.247767899 | -4.801637406 | 4.895844223 | -10.91281932 | 0.184371686 | -6.771096725 | -0.007326183 | -7.358083221 | -12.59841854 | -5.131548628 | 0.308333946 | -0.171607879 | 0.573574068 | 0.176967718 | -0.436206884 | -0.053501865 | 0.252405262 | -0.657487755 | -0.827135715 | 0.84957338 | 59 | yes |
| 7519 | 1.234235046 | 3.019740421 | -4.304596885 | 4.73279513 | 3.624200831 | -1.357745663 | 1.713444988 | -0.496358487 | -1.28285782 | -2.447469255 | 2.101343865 | -4.609628391 | 1.464377625 | -6.079337193 | -0.339237373 | 2.581850954 | 6.739384385 | 3.042493178 | -2.721853122 | 0.009060836 | -0.379068307 | -0.704181032 | -0.656804756 | -1.632652957 | 1.488901448 | 0.566797273 | -0.010016223 | 0.146792735 | 1 | yes |
| 7526 | 0.008430365 | 4.137836835 | -6.240696572 | 6.675732163 | 0.768307025 | -3.353059548 | -1.631734673 | 0.154612448 | -2.795892464 | -6.18789063 | 5.664394709 | -9.854484823 | -0.306166658 | -10.69119621 | -0.638498193 | -2.041973791 | -1.129055877 | 0.116452521 | -1.934665739 | 0.488378221 | 0.36451421 | -0.608057134 | -0.539527942 | 0.128939983 | 1.48848121 | 0.507962678 | 0.735821636 | 0.513573741 | 1 | yes |
| 7535 | 0.026779226 | 4.132463897 | -6.560599968 | 6.348556673 | 1.329665669 | -2.513478848 | -1.6891022 | 0.303252801 | -3.139409057 | -6.045467798 | 6.754625448 | -8.948178579 | 0.702724998 | -10.7338541 | -1.379519857 | -1.638960115 | -1.746350136 | 0.776744098 | -1.327356635 | 0.587743219 | 0.370508651 | -0.576752473 | -0.669605372 | -0.75990753 | 1.60505555 | 0.540675396 | 0.737040382 | 0.496699108 | 1 | yes |
| 7543 | 0.329594333 | 3.712889295 | -5.775935108 | 6.078265506 | 1.667359013 | -2.420168414 | -0.812891249 | 0.133080118 | -2.214311312 | -5.134454471 | 4.560720106 | -8.873748362 | -0.7974836 | -9.17716637 | -0.257024775 | -0.87168849 | 1.313013629 | 0.773913873 | -2.370599451 | 0.269772776 | 0.156617169 | -0.652450441 | -0.551572219 | -0.716521635 | 1.415716615 | 0.55526474 | 0.530507389 | 0.404474055 | 1 | yes |
| 7551 | 0.316459 | 3.809075947 | -5.615159011 | 6.047445102 | 1.554025957 | -2.651353112 | -0.746579273 | 0.055586311 | -2.678678542 | -4.959492912 | 6.439053352 | -7.520117393 | 0.386351667 | -9.252307247 | -1.365188415 | -0.502362191 | 0.784426598 | 1.494304607 | -1.808012159 | 0.388307428 | 0.208828369 | -0.511746619 | -0.583813221 | -0.219845029 | 1.474752584 | 0.491191926 | 0.518868285 | 0.402528068 | 1 | yes |
| 7610 | 0.72564574 | 2.300894438 | -5.329976183 | 4.007682805 | -1.73041059 | -1.732192568 | -3.968592618 | 1.063728153 | -0.486096552 | -4.624984954 | 5.588723915 | -7.148242636 | 1.680450741 | -6.210257747 | 0.495282118 | -3.599540209 | -4.830324242 | -0.64909012 | 2.250123249 | 0.504646226 | 0.589669127 | 0.109541319 | 0.601045277 | -0.364700278 | -1.843077692 | 0.351909298 | 0.594549978 | 0.099372236 | 1 | yes |
CREATE TABLE creditcardfraud (
"time" BIGINT,
"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" VARCHAR
);