Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/agbocsardi/rtpm_assignment_2.
Something went wrong. Try again.
156 kB · 3985 lines
at main
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986{ "cells": [ { "cell_type": "code", "execution_count": 76, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import pm4py\n", "from datetime import datetime\n", "import numpy as np\n", "from tqdm import tqdm \n", "import math\n", "from random import sample\n", "\n", "pd.set_option('display.max_rows', None)\n", "pd.set_option('display.max_columns', None)\n", "pd.set_option('display.width', None)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "parsing log, completed traces :: 100%|██████████| 31509/31509 [00:47<00:00, 657.00it/s]\n", "parsing log, completed traces :: 100%|██████████| 42995/42995 [00:10<00:00, 4021.40it/s]\n" ] } ], "source": [ "application_log = pm4py.read_xes('BPI Challenge 2017.xes')\n", "offer_log = pm4py.read_xes('BPI Challenge 2017 - Offer log.xes')\n", "\n", "df_application = pm4py.convert_to_dataframe(application_log)\n", "df_offer = pm4py.convert_to_dataframe(offer_log)\n", "\n", "df_application.to_csv('app_logs.csv')\n", "df_offer.to_csv('offer_logs.csv')" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "df_application = pd.read_csv('./../../Assignment_2/Data/app_logs.csv')\n", "#df_offer = pd.read_csv('./../../Assignment_2/Data/offer_logs.csv')" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "declined_ids = list(df_application.loc[df_application['concept:name'] == 'A_Denied']['case:concept:name'].unique())\n", "accepted_ids = list(df_application.loc[df_application['concept:name'] == 'A_Pending']['case:concept:name'].unique())\n", "cancelled_ids = list(df_application.loc[df_application['concept:name'] == 'A_Cancelled']['case:concept:name'].unique())" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "31411" ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# 31,509 loan applications in total\n", "# 98 noise \n", "len(declined_ids)+ len(accepted_ids)+len(cancelled_ids)" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(3752, 17228, 10431)" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(declined_ids), len(accepted_ids), len(cancelled_ids)" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [], "source": [ "def get_min_max_time(ids, i):\n", " timestamps = df_application.loc[df_application['case:concept:name'] == ids[i]]['time:timestamp']\n", " return (min(timestamps), max(timestamps))" ] }, { "cell_type": "code", "execution_count": 50, "metadata": {}, "outputs": [], "source": [ "# declined_ids: 0.19175868569889576\n", "# cancelled_ids: 0.19131614654002713\n", "# approved_ids: 0.19133955289561697" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "timestamp_list = []\n", "for i in tqdm(range(len(accepted_ids))):\n", " timestamp_list.append(get_min_max_time(accepted_ids, i))\n", "#all(timestamp_list[i] <= timestamp_list[i+1] for i in range(len(timestamp_list) - 1))\n", "\n", "accepted_ids_w_st_time = sorted([(id, time) for id, time in zip(accepted_ids, timestamp_list)], key=lambda x: x[1][0])\n", "accepted_ids_w_en_time = sorted([(id, time) for id, time in zip(accepted_ids, timestamp_list)], key=lambda x: x[1][1])\n", "\n", "ids_length = len(timestamp_list)\n", "train_num = int(ids_length * 0.8)\n", "\n", "train_ids = [pair[0] for pair in accepted_ids_w_st_time[:train_num]]\n", "test_ids = [pair[0] for pair in accepted_ids_w_en_time[train_num:]]\n", "\n", "overlap = list(set(train_ids) & set(test_ids))\n", "len(overlap)\n", "\n", "print((len(test_ids)-len(overlap))/(len(timestamp_list)-len(overlap)))\n", "\n", "test_ids = list(set(test_ids) - set(overlap))\n", "\n", "train_df = df_application.loc[df_application['case:concept:name'].isin(train_ids)]\n", "test_df = df_application.loc[df_application['case:concept:name'].isin(test_ids)]\n", "\n", "train_df.to_csv('approved_train.csv')\n", "test_df.to_csv('approved_test.csv')\n", "\n", "#\n", "#train_event_log = pm4py.convert_to_event_log(train_df)\n", "#pm4py.write_xes(train_event_log, 'approved_train.xes')\n", "#\n", "#test_event_log = pm4py.convert_to_event_log(test_df)\n", "#pm4py.write_xes(test_event_log, 'approved_test.xes')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Part 1" ] }, { "cell_type": "code", "execution_count": 58, "metadata": {}, "outputs": [], "source": [ "def create_train_test(df_application, ids, outcome):\n", "\n", " timestamp_list = []\n", " for i in tqdm(range(len(ids))):\n", " timestamp_list.append(get_min_max_time(ids, i))\n", " #all(timestamp_list[i] <= timestamp_list[i+1] for i in range(len(timestamp_list) - 1))\n", " \n", " ids_w_st_time = sorted([(id, time) for id, time in zip(ids, timestamp_list)], key=lambda x: x[1][0])\n", " ids_w_et_time = sorted([(id, time) for id, time in zip(ids, timestamp_list)], key=lambda x: x[1][1])\n", " \n", " ids_length = len(timestamp_list)\n", " train_num = int(ids_length * 0.8)\n", " \n", " train_ids = [pair[0] for pair in ids_w_st_time[:train_num]]\n", " test_ids = [pair[0] for pair in ids_w_et_time[train_num:]]\n", " \n", " overlap = list(set(train_ids) & set(test_ids))\n", " \n", " print((len(test_ids)-len(overlap))/(len(timestamp_list)-len(overlap)))\n", " \n", " test_ids = list(set(test_ids) - set(overlap))\n", " \n", " train_df = df_application.loc[df_application['case:concept:name'].isin(train_ids)]\n", " test_df = df_application.loc[df_application['case:concept:name'].isin(test_ids)]\n", " \n", " train_df.to_csv(f'{outcome}_train.csv')\n", " test_df.to_csv(f'{outcome}_test.csv')\n", "\n", " return train_df, test_df\n", " \n", " " ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 3752/3752 [03:54<00:00, 16.01it/s]\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "0.19175868569889576\n" ] } ], "source": [ "d_train_df, d_test_df = create_train_test(df_application, declined_ids, 'declined')" ] }, { "cell_type": "code", "execution_count": 60, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 10431/10431 [10:48<00:00, 16.09it/s]\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "0.19131614654002713\n" ] } ], "source": [ "c_train_df, c_test_df = create_train_test(df_application, cancelled_ids, 'cancelled')" ] }, { "cell_type": "code", "execution_count": 61, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 17228/17228 [17:48<00:00, 16.12it/s]\n" ] }, { "name": "stdout", "output_type": "stream", "text": [ "0.19133955289561697\n" ] } ], "source": [ "a_train_df, a_test_df = create_train_test(df_application, accepted_ids, 'approved')" ] }, { "cell_type": "code", "execution_count": 49, "metadata": {}, "outputs": [], "source": [ "def save_xes(train_df, test_df, pre):\n", "\n", " train_event_log = pm4py.convert_to_event_log(train_df)\n", " pm4py.write_xes(train_event_log, f'{pre}_train.xes')\n", "\n", " test_event_log = pm4py.convert_to_event_log(test_df)\n", " pm4py.write_xes(test_event_log, f'{pre}_test.xes')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Part 2 building dataset" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def aggregate_df(df):\n", " \"\"\" \n", " Aggregate the df of current events in the case\n", "\n", " Output: \n", " result -> could be a pandas series\n", " \"\"\"\n", "\n", " # record the timestamp of the last activity\n", " result = df.iloc[0]\n", "\n", " return result\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "def add_to_aggregate(result, df_row):\n", " \"\"\" \n", " When a new event happens, add the event info to the current aggregated result.\n", "\n", " Input: \n", " result: the current aggregated result\n", " df_row: pandas df row representing the new event\n", " Output:\n", " result: the new aggregated result\n", " \"\"\"\n", "\n", " # record the timestamp of the last activity\n", " result = df_row.iloc[0]\n", "\n", " return result" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [], "source": [ "def create_prefix_part2(df_application, app_ids, end_event, start_event='A_Accepted'):\n", " \n", " app_id_list = list(df_application['case:concept:name'].unique())\n", "\n", " # TODO:\n", " # create a return df\n", " return_df = pd.DataFrame()\n", "\n", " # extracting prefix for each application\n", " for app_id in app_id_list:\n", " \n", " events_app = df_application.loc[df_application['case:concept:name'] == app_id]\n", " events_app.reset_index(drop=True, inplace=True)\n", "\n", " # A_Accepted happens at most 1 time in each case\n", " # Otherwise will give error - only consider the first A_Accepted\n", " cur_id = starting_row_id = events_app.loc[events_app['concept:name'] == 'A_Accepted'].index[0]\n", " pre_events = events_app.iloc[:starting_row_id]\n", " # TODO: \n", " # aggregate events_app from row 0 to starting_row_id\n", " result = aggregate_df(pre_events)\n", " \n", " ending_row_id = events_app.loc[events_app['concept:name'] == end_event].index[0]\n", " cur_id += 1\n", " \n", " while cur_id < ending_row_id:\n", " new_row = events_app.iloc[cur_id]\n", " # TODO: \n", " # add new event row info to the aggregated result\n", " result = add_to_aggregate(pre_events)\n", "\n", " # Update the return_df -> add new row\n", " # target y: end_event\n", "\n", " cur_id += 1\n", "\n", " return return_df\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Part 3 building dataset\n" ] }, { "cell_type": "code", "execution_count": 35, "metadata": {}, "outputs": [], "source": [ "#build function to retrieve minimum time \n", "def get_min_time(ids, i):\n", " \"\"\"define function to retrieve the minimum time\"\"\"\n", " return min(df_application.loc[df_application[\"case:concept:name\"] == ids[i]][\"time:timestamp\"])\n", "\n", "#get the minimum time for the accepted ids\n", "min_timestamp_list = []\n", "for i in tqdm(range(len(accepted_ids))):\n", " min_timestamp_list.append(get_min_time(accepted_ids, i))\n", "\n", "#create a list with every id and the start time, and another list with every id and the end time\n", "accepted_ids_begin = sorted([(id, time) for id, time in zip(accepted_ids, min_timestamp_list)], key=lambda x: x[1])\n", "accepted_ids_end = sorted([(id, time) for id, time in zip(accepted_ids, timestamp_list)], key=lambda x: x[1])\n", "\n", "#generate dataframe for begin and end times \n", "df_accepted_ids_time_begin = pd.DataFrame(accepted_ids_begin, columns = [\"case:concept:name\", \"begin\"])\n", "df_accepted_ids_time_end = pd.DataFrame(accepted_ids_end, columns = [\"case:concept:name\", \"end\"])\n", "\n", "#merge dataframes on case:concept:name\n", "df_accepted_timestamps = df_accepted_ids_time_begin.merge(df_accepted_ids_time_end, on = \"case:concept:name\")\n", "\n", "#keep relevant time formatting\n", "df_accepted_timestamps[\"begin\"] = df_accepted_timestamps[\"begin\"].map(lambda x: str(x)[:19])\n", "df_accepted_timestamps[\"end\"] = df_accepted_timestamps[\"end\"].map(lambda x: str(x)[:19])\n", "\n", "#create function to calculate the difference in time from a dataframe with two columns containing dates and time\n", "def calc_duration(end, begin):\n", " \"\"\"calculate the difference in time using datetime.strptime\"\"\"\n", " return (datetime.strptime(end, \"%Y-%m-%d %H:%M:%S\") - datetime.strptime(begin, \"%Y-%m-%d %H:%M:%S\")).total_seconds()\n", "\n", "#empty list to gather differences\n", "duration = []\n", "\n", "#retrieve the difference between begin and end of the trace and add to a list \n", "for i in range(0, len(df_accepted_timestamps)):\n", " duration.append(calc_duration(df_accepted_timestamps.iloc[i][\"end\"], df_accepted_timestamps.iloc[i][\"begin\"]))\n", "\n", "#add the time difference to the df \n", "df_accepted_timestamps[\"duration\"] = duration\n", "\n", "#remove all cases with case time duration 0 \n", "df_accepted_timestamps = df_accepted_timestamps.loc[df_accepted_timestamps[\"duration\"] > 0]\n", "\n", "#get indexes to filter outliers top and bottom 5%\n", "outliers_index = list(range(0, round(0.05 * len(df_accepted_timestamps)))) + list(range(round(0.95 * len(df_accepted_timestamps)), len(df_accepted_timestamps)))\n", "\n", "#sort values from small to big time difference and drop respective rows\n", "df_accepted_timestamps = df_accepted_timestamps.sort_values(by= \"duration\", ignore_index = True).drop(labels = outliers_index, axis = \"index\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "df_accepted_timestamps_begin = df_accepted_timestamps.sort_values(by = \"begin\").reset_index(drop = True)\n", "df_accepted_timestamps_end = df_accepted_timestamps.sort_values(by = \"end\").reset_index(drop = True)\n", "\n", "#test set range\n", "begin_index_test = round(0.8 * len(df_accepted_timestamps_begin))\n", "begin_time_test = df_accepted_timestamps_begin.iloc[begin_index_test][\"begin\"]\n", "x = calc_duration(max(df_accepted_timestamps[\"end\"]), begin_time_test)\n", "\n", "#train set range\n", "end_index_train = round(0.8 * len(df_accepted_timestamps_end))\n", "end_time_train = df_accepted_timestamps_end.iloc[end_index_train][\"end\"]\n", "y = calc_duration(end_time_train, min(df_accepted_timestamps[\"begin\"]))\n", " \n", "total_with_overlap = x + y\n", "total_time = calc_duration(max(df_accepted_timestamps[\"end\"]), min(df_accepted_timestamps[\"begin\"]))\n", "overlap_span = total_with_overlap - total_time\n", "\n", "overlap_train = 0.8 * overlap_span\n", "overlap_test = 0.2 * overlap_span\n", "\n", "end_time_train_with_overlap = datetime.strptime(end_time_train, \"%Y-%m-%d %H:%M:%S\") \n", "date_index_train = datetime.strftime((end_time_train_datetime - timedelta(seconds = overlap_train)), \"%Y-%m-%d %H:%M:%S\")\n", "\n", "begin_time_test_with_overlap = datetime.strptime(begin_time_test, \"%Y-%m-%d %H:%M:%S\") \n", "date_index_test = datetime.strftime((begin_time_test_datetime + timedelta(seconds = overlap_test)), \"%Y-%m-%d %H:%M:%S\")\n", "\n", "df_train = df_accepted_timestamps_end.loc[df_accepted_timestamps_end[\"end\"] < date_index_train]\n", "df_test = df_accepted_timestamps_begin.loc[df_accepted_timestamps_begin[\"begin\"] > date_index_test]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Part 4 building dataset\n", "---\n", "\n", "#### First XOR - test: \n", "\n", " W_Validate application -> A_Validating XOR W_Call incomplete files " ] }, { "cell_type": "code", "execution_count": 76, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "parsing log, completed traces :: 100%|██████████| 8344/8344 [00:22<00:00, 370.96it/s]\n", "parsing log, completed traces :: 100%|██████████| 2087/2087 [00:05<00:00, 371.85it/s]\n" ] } ], "source": [ "df_cancel_tr = pm4py.convert_to_dataframe(pm4py.read_xes('./../../Assignment_2/Data/cancelled_train.xes'))\n", "df_cancel_te = pm4py.convert_to_dataframe(pm4py.read_xes('./../../Assignment_2/Data/cancelled_test.xes'))" ] }, { "cell_type": "code", "execution_count": 77, "metadata": {}, "outputs": [], "source": [ "df_cancel_tr.to_csv('./../../Assignment_2/Data/cancelled_train.csv')\n", "df_cancel_te.to_csv('./../../Assignment_2/Data/cancelled_test.csv')" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "df_cancel_tr = pd.read_csv('./../../Assignment_2/Data/cancelled_train.csv')\n", "df_cancel_te = pd.read_csv('./../../Assignment_2/Data/cancelled_test.csv')" ] }, { "cell_type": "code", "execution_count": 57, "metadata": {}, "outputs": [], "source": [ "df_approve_tr = pd.read_csv('./../../Assignment_2/Data/approved_train.csv')\n", "df_approve_te = pd.read_csv('./../../Assignment_2/Data/approved_test.csv')" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "all_columns = list(df_cancel_tr.columns)" ] }, { "cell_type": "code", "execution_count": 139, "metadata": {}, "outputs": [], "source": [ "case_attr = all_columns[all_columns.index('FirstWithdrawalAmount'):]\n", "\n", "event_attr_cat = ['org:resource', 'concept:name', 'lifecycle:transition']\n", "event_attr_num = ['time:timestamp']\n", "\n", "result_df_columns = case_attr + ['time_to_current'] + ['last_time:timestamp']\n", "\n", "resources = list(df_cancel_tr['org:resource'].unique())\n", "\n", "df_cancel_tr['event_w_lifecycly'] = df_cancel_tr.apply(lambda row: row['concept:name'].replace(' ', '_') + '_' + row['lifecycle:transition'], axis=1)\n", "events = list(df_cancel_tr['concept:name'].unique())\n", "lifecycles = list(df_cancel_tr['lifecycle:transition'].unique())\n", "events_w_lifecycle = list(df_cancel_tr['event_w_lifecycly'].unique())\n", "\n", "result_df_columns.extend(events)\n", "result_df_columns.extend(lifecycles)\n", "result_df_columns.extend(events_w_lifecycle)\n", "\n", "return_df = pd.DataFrame(columns=result_df_columns)" ] }, { "cell_type": "code", "execution_count": 93, "metadata": {}, "outputs": [], "source": [ "def aggregate_df(df, res_cols):\n", " \"\"\" \n", " Aggregate the df of current events in the case\n", "\n", " Output: \n", " result -> could be a pandas series\n", " \"\"\"\n", " res_dict = dict.fromkeys(res_cols)\n", " \n", " for row in df.to_dict('records'):\n", "\n", " # user variable assign\n", " user = row['org:resource']\n", " # event variable assign\n", " event = row['concept:name'] + ' ' + row['lifecycle:transition']\n", "\n", " try:\n", " # first mention, turn it numeric\n", " if not res_dict[user]: res_dict[user] = 1\n", " else: res_dict[user] += 1\n", "\n", " if not res_dict[event]: res_dict[event] = 1\n", " else: res_dict[event] += 1\n", " except:\n", " # when test set has a unique resource (user) or event not in train set\n", " pass\n", "\n", " # case level cols\n", " rest_cols_1 = ['FirstWithdrawalAmount',\n", " 'NumberOfTerms', 'Accepted', 'MonthlyCost', 'Selected', 'CreditScore',\n", " 'OfferedAmount'] \n", "\n", " for col in rest_cols_1: # always get the newest record\n", " if not math.isnan(row[col]) and row[col] != res_dict[col]:\n", " res_dict[col] = row[col]\n", "\n", " \n", " # time stuff\n", " #keeping the first timestamp of the case for calculation purposes\n", " if not res_dict['first_timestamp']: res_dict['first_timestamp'] = row['time:timestamp']\n", "\n", "\n", " rest_cols_2 = ['case:LoanGoal', 'case:ApplicationType', 'case:RequestedAmount']\n", " for col in rest_cols_2:\n", " res_dict[col] = row[col] \n", " \n", " # trace duration in seconds\n", " res_dict['trace_duration'] = (np.datetime64(row['time:timestamp']) - np.datetime64(res_dict['first_timestamp'])).item().total_seconds()\n", "\n", " return res_dict" ] }, { "cell_type": "code", "execution_count": 59, "metadata": {}, "outputs": [], "source": [ "cancel_events = list(df_cancel_tr['concept:name'].unique())\n", "approve_events = list(df_approve_tr['concept:name'].unique())" ] }, { "cell_type": "code", "execution_count": 61, "metadata": {}, "outputs": [], "source": [ "common_events = set(approve_events) & set(cancel_events)\n", "only_cancel = list(set(cancel_events) - common_events)\n", "only_approve = list(set(approve_events) - common_events)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "list(common_events)" ] }, { "cell_type": "code", "execution_count": 62, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(['A_Cancelled'], ['A_Pending', 'W_Personal Loan collection', 'O_Accepted'])" ] }, "execution_count": 62, "metadata": {}, "output_type": "execute_result" } ], "source": [ "only_cancel, only_approve" ] }, { "cell_type": "code", "execution_count": 81, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(8344, 1974)" ] }, "execution_count": 81, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(df_cancel_tr['case:concept:name'].unique()), len(df_cancel_te['case:concept:name'].unique())" ] }, { "cell_type": "code", "execution_count": 82, "metadata": {}, "outputs": [], "source": [ "df_train = pd.concat([df_cancel_tr, df_approve_tr[df_approve_tr['case:concept:name'].isin(sample(list(df_approve_tr['case:concept:name'].unique()), 8000))]])\n", "df_test = pd.concat([df_cancel_te, df_approve_te[df_approve_te['case:concept:name'].isin(sample(list(df_approve_te['case:concept:name'].unique()), 2000))]])\n" ] }, { "cell_type": "code", "execution_count": 94, "metadata": {}, "outputs": [], "source": [ "def create_feature_columns(df_train):\n", " df_train['event_w_lifecycle'] = df_train['concept:name'] + ' ' + df_train['lifecycle:transition']\n", "\n", " org_resource_cols = list(df_train['org:resource'].unique())\n", " event_cols = list(df_train['event_w_lifecycle'].unique())\n", " rest_cols = ['FirstWithdrawalAmount',\n", " 'NumberOfTerms', 'Accepted', 'MonthlyCost', 'Selected', 'CreditScore',\n", " 'OfferedAmount', 'case:LoanGoal', 'case:ApplicationType', 'case:RequestedAmount']\n", " target_cols = ['first_timestamp', 'trace_duration']\n", "\n", " res_cols = org_resource_cols + event_cols + rest_cols + target_cols\n", "\n", " return res_cols" ] }, { "cell_type": "code", "execution_count": 95, "metadata": {}, "outputs": [], "source": [ "def create_dataset_part4_first_xor(df_application, current_event='A_Complete', next_event=[], result_columns=None, test=True):\n", " \"\"\"\n", " Encode original applications \n", " \"\"\"\n", " \n", " result_dict = []\n", " \n", " app_id_list = list(df_application['case:concept:name'].unique())\n", " if test: \n", " cnt = int(len(app_id_list) * 0.1)\n", " app_id_list = app_id_list[:cnt] + app_id_list[-cnt:]\n", " for app_id in tqdm(app_id_list):\n", " \n", " events_app = df_application.loc[df_application['case:concept:name'] == app_id]\n", " events_app.reset_index(drop=True, inplace=True)\n", " \n", " # same event could happen multiple times in a case\n", " starting_rows = events_app.loc[(events_app['concept:name'] == current_event) & (events_app['lifecycle:transition'] == 'complete')]\n", " starting_row_ids = list(starting_rows.index)\n", " \n", " for starting_row_id in starting_row_ids:\n", " #print(app_id)\n", " pre_events = events_app.iloc[:starting_row_id+1]\n", " pos_events = events_app.iloc[starting_row_id+1:]\n", " \n", " # aggregate events_app from row 0 to starting_row_id\n", " result = aggregate_df(pre_events, result_columns)\n", " \n", " # XOR with 2 results\n", " target = list(pos_events['concept:name'].unique())\n", " result['next_event'] = next_event[0] in target\n", " \n", " result_dict.append(result)\n", " \n", " return pd.DataFrame.from_dict(result_dict).fillna(0)\n", " \n", " \n", " " ] }, { "cell_type": "code", "execution_count": 96, "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ " 0%| | 0/3268 [00:00<?, ?it/s]/var/folders/nd/m2w3gccj0hx7zslrqlw6v9z80000gn/T/ipykernel_25522/4002999508.py:48: DeprecationWarning: parsing timezone aware datetimes is deprecated; this will raise an error in the future\n", " res_dict['trace_duration'] = (np.datetime64(row['time:timestamp']) - np.datetime64(res_dict['first_timestamp'])).item().total_seconds()\n", "100%|██████████| 3268/3268 [01:43<00:00, 31.62it/s]\n", "100%|██████████| 794/794 [00:07<00:00, 111.68it/s]\n" ] } ], "source": [ "result_columns = create_feature_columns(df_train)\n", "\n", "df_train_case = create_dataset_part4_first_xor(df_train, next_event=['A_Pending', 'A_Cancelled'], result_columns=result_columns)\n", "df_test_case = create_dataset_part4_first_xor(df_test, next_event=['A_Pending', 'A_Cancelled'], result_columns=result_columns)" ] }, { "cell_type": "code", "execution_count": 101, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(3255, 3268.8)" ] }, "execution_count": 101, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(df_train_case), len(df_train['case:concept:name'].unique()) * 0.2" ] }, { "cell_type": "code", "execution_count": 102, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(16344, 16263)" ] }, "execution_count": 102, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(df_train['case:concept:name'].unique()), len(df_train.loc[df_train['concept:name'] == 'A_Complete'])" ] }, { "cell_type": "code", "execution_count": 106, "metadata": {}, "outputs": [], "source": [ "df_train_case.to_csv('part_4_train_tt.csv', index=False)\n", "df_test_case.to_csv('part_4_test_tt.csv', index=False)" ] }, { "cell_type": "code", "execution_count": 105, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>User_1</th>\n", " <th>User_19</th>\n", " <th>User_11</th>\n", " <th>User_17</th>\n", " <th>User_8</th>\n", " <th>User_3</th>\n", " <th>User_38</th>\n", " <th>User_113</th>\n", " <th>User_100</th>\n", " <th>User_28</th>\n", " <th>User_27</th>\n", " <th>User_43</th>\n", " <th>User_15</th>\n", " <th>User_16</th>\n", " <th>User_89</th>\n", " <th>User_112</th>\n", " <th>User_4</th>\n", " <th>User_71</th>\n", " <th>User_108</th>\n", " <th>User_37</th>\n", " <th>User_85</th>\n", " <th>User_7</th>\n", " <th>User_13</th>\n", " <th>User_20</th>\n", " <th>User_52</th>\n", " <th>User_2</th>\n", " <th>User_14</th>\n", " <th>User_31</th>\n", " <th>User_6</th>\n", " <th>User_95</th>\n", " <th>User_109</th>\n", " <th>User_70</th>\n", " <th>User_10</th>\n", " <th>User_21</th>\n", " <th>User_114</th>\n", " <th>User_102</th>\n", " <th>User_87</th>\n", " <th>User_47</th>\n", " <th>User_5</th>\n", " <th>User_44</th>\n", " <th>User_33</th>\n", " <th>User_34</th>\n", " <th>User_35</th>\n", " <th>User_29</th>\n", " <th>User_26</th>\n", " <th>User_74</th>\n", " <th>User_42</th>\n", " <th>User_49</th>\n", " <th>User_99</th>\n", " <th>User_22</th>\n", " <th>User_116</th>\n", " <th>User_92</th>\n", " <th>User_68</th>\n", " <th>User_30</th>\n", " <th>User_41</th>\n", " <th>User_75</th>\n", " <th>User_24</th>\n", " <th>User_12</th>\n", " <th>User_117</th>\n", " <th>User_9</th>\n", " <th>User_110</th>\n", " <th>User_119</th>\n", " <th>User_101</th>\n", " <th>User_36</th>\n", " <th>User_115</th>\n", " <th>User_18</th>\n", " <th>User_144</th>\n", " <th>User_118</th>\n", " <th>User_120</th>\n", " <th>User_25</th>\n", " <th>User_23</th>\n", " <th>User_86</th>\n", " <th>User_90</th>\n", " <th>User_73</th>\n", " <th>User_142</th>\n", " <th>User_141</th>\n", " <th>User_76</th>\n", " <th>User_32</th>\n", " <th>User_50</th>\n", " <th>User_125</th>\n", " <th>User_145</th>\n", " <th>User_97</th>\n", " <th>User_61</th>\n", " <th>User_39</th>\n", " <th>User_148</th>\n", " <th>User_127</th>\n", " <th>User_128</th>\n", " <th>User_46</th>\n", " <th>User_121</th>\n", " <th>User_103</th>\n", " <th>User_122</th>\n", " <th>User_60</th>\n", " <th>User_83</th>\n", " <th>User_40</th>\n", " <th>User_53</th>\n", " <th>User_48</th>\n", " <th>User_146</th>\n", " <th>User_107</th>\n", " <th>User_51</th>\n", " <th>User_123</th>\n", " <th>User_143</th>\n", " <th>User_45</th>\n", " <th>User_54</th>\n", " <th>User_63</th>\n", " <th>User_124</th>\n", " <th>User_138</th>\n", " <th>User_93</th>\n", " <th>User_64</th>\n", " <th>User_126</th>\n", " <th>User_58</th>\n", " <th>User_57</th>\n", " <th>User_106</th>\n", " <th>User_79</th>\n", " <th>User_62</th>\n", " <th>User_78</th>\n", " <th>User_133</th>\n", " <th>User_82</th>\n", " <th>User_55</th>\n", " <th>User_66</th>\n", " <th>User_139</th>\n", " <th>User_56</th>\n", " <th>User_91</th>\n", " <th>User_111</th>\n", " <th>User_59</th>\n", " <th>User_132</th>\n", " <th>User_130</th>\n", " <th>User_67</th>\n", " <th>User_104</th>\n", " <th>User_131</th>\n", " <th>User_65</th>\n", " <th>User_77</th>\n", " <th>User_84</th>\n", " <th>User_80</th>\n", " <th>User_96</th>\n", " <th>User_136</th>\n", " <th>User_129</th>\n", " <th>User_69</th>\n", " <th>User_134</th>\n", " <th>A_Create Application complete</th>\n", " <th>A_Submitted complete</th>\n", " <th>W_Handle leads schedule</th>\n", " <th>W_Handle leads withdraw</th>\n", " <th>W_Complete application schedule</th>\n", " <th>A_Concept complete</th>\n", " <th>W_Complete application start</th>\n", " <th>A_Accepted complete</th>\n", " <th>O_Create Offer complete</th>\n", " <th>O_Created complete</th>\n", " <th>O_Sent (mail and online) complete</th>\n", " <th>W_Complete application complete</th>\n", " <th>W_Call after offers schedule</th>\n", " <th>W_Call after offers start</th>\n", " <th>A_Complete complete</th>\n", " <th>W_Call after offers suspend</th>\n", " <th>W_Call after offers resume</th>\n", " <th>A_Cancelled complete</th>\n", " <th>O_Cancelled complete</th>\n", " <th>W_Call after offers ate_abort</th>\n", " <th>W_Complete application suspend</th>\n", " <th>W_Complete application resume</th>\n", " <th>W_Complete application ate_abort</th>\n", " <th>W_Validate application schedule</th>\n", " <th>W_Validate application start</th>\n", " <th>A_Validating complete</th>\n", " <th>O_Returned complete</th>\n", " <th>W_Validate application suspend</th>\n", " <th>W_Validate application ate_abort</th>\n", " <th>W_Call incomplete files schedule</th>\n", " <th>W_Call incomplete files start</th>\n", " <th>A_Incomplete complete</th>\n", " <th>W_Call incomplete files suspend</th>\n", " <th>W_Call incomplete files resume</th>\n", " <th>W_Call incomplete files ate_abort</th>\n", " <th>O_Sent (online only) complete</th>\n", " <th>W_Handle leads start</th>\n", " <th>W_Handle leads complete</th>\n", " <th>W_Validate application resume</th>\n", " <th>W_Validate application complete</th>\n", " <th>W_Call incomplete files complete</th>\n", " <th>W_Complete application withdraw</th>\n", " <th>W_Call after offers complete</th>\n", " <th>W_Handle leads suspend</th>\n", " <th>W_Handle leads resume</th>\n", " <th>W_Assess potential fraud schedule</th>\n", " <th>W_Assess potential fraud start</th>\n", " <th>W_Assess potential fraud suspend</th>\n", " <th>W_Assess potential fraud resume</th>\n", " <th>W_Assess potential fraud complete</th>\n", " <th>W_Handle leads ate_abort</th>\n", " <th>W_Shortened completion schedule</th>\n", " <th>W_Shortened completion start</th>\n", " <th>W_Shortened completion suspend</th>\n", " <th>W_Shortened completion resume</th>\n", " <th>O_Accepted complete</th>\n", " <th>A_Pending complete</th>\n", " <th>W_Personal Loan collection schedule</th>\n", " <th>W_Personal Loan collection start</th>\n", " <th>W_Personal Loan collection suspend</th>\n", " <th>W_Personal Loan collection resume</th>\n", " <th>W_Assess potential fraud ate_abort</th>\n", " <th>W_Assess potential fraud withdraw</th>\n", " <th>FirstWithdrawalAmount</th>\n", " <th>NumberOfTerms</th>\n", " <th>Accepted</th>\n", " <th>MonthlyCost</th>\n", " <th>Selected</th>\n", " <th>CreditScore</th>\n", " <th>OfferedAmount</th>\n", " <th>case:LoanGoal</th>\n", " <th>case:ApplicationType</th>\n", " <th>case:RequestedAmount</th>\n", " <th>first_timestamp</th>\n", " <th>trace_duration</th>\n", " <th>next_event</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>3245</th>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>9.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>20000.0</td>\n", " <td>60.0</td>\n", " <td>True</td>\n", " <td>371.17</td>\n", " <td>True</td>\n", " <td>878.0</td>\n", " <td>20000.0</td>\n", " <td>Car</td>\n", " <td>New credit</td>\n", " <td>20000.0</td>\n", " <td>2016-10-18 08:51:42.172000+00:00</td>\n", " <td>170163.713</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3246</th>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>12.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>134.0</td>\n", " <td>True</td>\n", " <td>100.00</td>\n", " <td>True</td>\n", " <td>839.0</td>\n", " <td>10000.0</td>\n", " <td>Home improvement</td>\n", " <td>Limit raise</td>\n", " <td>10000.0</td>\n", " <td>2016-10-18 09:04:18.477000+00:00</td>\n", " <td>601.295</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3247</th>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>12.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>126.0</td>\n", " <td>True</td>\n", " <td>400.00</td>\n", " <td>True</td>\n", " <td>0.0</td>\n", " <td>40000.0</td>\n", " <td>Unknown</td>\n", " <td>Limit raise</td>\n", " <td>0.0</td>\n", " <td>2016-10-18 09:06:20.637000+00:00</td>\n", " <td>150.016</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3248</th>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>5.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>9.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>2.0</td>\n", " <td>2.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>3.0</td>\n", " <td>3.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>126.0</td>\n", " <td>False</td>\n", " <td>320.00</td>\n", " <td>True</td>\n", " <td>0.0</td>\n", " <td>32000.0</td>\n", " <td>Unknown</td>\n", " <td>Limit raise</td>\n", " <td>0.0</td>\n", " <td>2016-10-18 09:30:06.339000+00:00</td>\n", " <td>183303.148</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3249</th>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>7.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>2.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>2.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>2000.0</td>\n", " <td>134.0</td>\n", " <td>True</td>\n", " <td>130.00</td>\n", " <td>True</td>\n", " <td>775.0</td>\n", " <td>13000.0</td>\n", " <td>Car</td>\n", " <td>Limit raise</td>\n", " <td>13000.0</td>\n", " <td>2016-10-18 09:34:06.469000+00:00</td>\n", " <td>266088.593</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3250</th>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>8.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>82.0</td>\n", " <td>True</td>\n", " <td>500.00</td>\n", " <td>True</td>\n", " <td>733.0</td>\n", " <td>35000.0</td>\n", " <td>Car</td>\n", " <td>New credit</td>\n", " <td>35000.0</td>\n", " <td>2016-10-18 10:31:35.256000+00:00</td>\n", " <td>91691.652</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3251</th>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>4.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>12.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>2</td>\n", " <td>2</td>\n", " <td>2.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>2.0</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>30000.0</td>\n", " <td>125.0</td>\n", " <td>False</td>\n", " <td>650.00</td>\n", " <td>False</td>\n", " <td>0.0</td>\n", " <td>64500.0</td>\n", " <td>Other, see explanation</td>\n", " <td>New credit</td>\n", " <td>65000.0</td>\n", " <td>2016-10-18 11:12:05.182000+00:00</td>\n", " <td>167404.402</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3252</th>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>8.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>10000.0</td>\n", " <td>44.0</td>\n", " <td>True</td>\n", " <td>249.58</td>\n", " <td>True</td>\n", " <td>1083.0</td>\n", " <td>10000.0</td>\n", " <td>Car</td>\n", " <td>New credit</td>\n", " <td>10000.0</td>\n", " <td>2016-10-18 11:24:50.857000+00:00</td>\n", " <td>82687.083</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3253</th>\n", " <td>6.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>8.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>5000.0</td>\n", " <td>36.0</td>\n", " <td>True</td>\n", " <td>152.82</td>\n", " <td>True</td>\n", " <td>908.0</td>\n", " <td>5000.0</td>\n", " <td>Car</td>\n", " <td>New credit</td>\n", " <td>5000.0</td>\n", " <td>2016-10-18 12:00:33.792000+00:00</td>\n", " <td>89843.380</td>\n", " <td>True</td>\n", " </tr>\n", " <tr>\n", " <th>3254</th>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>12.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>25000.0</td>\n", " <td>60.0</td>\n", " <td>False</td>\n", " <td>461.78</td>\n", " <td>False</td>\n", " <td>0.0</td>\n", " <td>25000.0</td>\n", " <td>Car</td>\n", " <td>New credit</td>\n", " <td>25000.0</td>\n", " <td>2016-10-18 12:02:09.032000+00:00</td>\n", " <td>515.051</td>\n", " <td>True</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " User_1 User_19 User_11 User_17 User_8 User_3 User_38 User_113 \\\n", "3245 6.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3246 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3247 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3248 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3249 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3250 6.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3251 6.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3252 6.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3253 6.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "3254 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 \n", "\n", " User_100 User_28 User_27 User_43 User_15 User_16 User_89 \\\n", "3245 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3246 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3247 0 0.0 0.0 0.0 0.0 12.0 0.0 \n", "3248 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3249 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3250 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3251 0 0.0 0.0 0.0 0.0 4.0 0.0 \n", "3252 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3253 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3254 0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "\n", " User_112 User_4 User_71 User_108 User_37 User_85 User_7 User_13 \\\n", "3245 0 0.0 9.0 0.0 0.0 0.0 0.0 0.0 \n", "3246 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3247 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3248 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3249 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3250 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3251 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3252 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3253 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3254 0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "\n", " User_20 User_52 User_2 User_14 User_31 User_6 User_95 User_109 \\\n", "3245 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3246 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3247 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3248 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3249 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3250 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3251 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3252 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3253 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "3254 0.0 0.0 0.0 0.0 0.0 0.0 0 0.0 \n", "\n", " User_70 User_10 User_21 User_114 User_102 User_87 User_47 User_5 \\\n", "3245 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3246 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3247 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3248 0.0 0.0 0.0 0 0 0.0 0.0 5.0 \n", "3249 0.0 7.0 0.0 0 0 0.0 0.0 6.0 \n", "3250 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3251 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3252 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3253 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "3254 0.0 0.0 0.0 0 0 0.0 0.0 0.0 \n", "\n", " User_44 User_33 User_34 User_35 User_29 User_26 User_74 User_42 \\\n", "3245 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3246 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3247 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3248 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3249 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3250 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3251 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3252 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3253 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "3254 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 \n", "\n", " User_49 User_99 User_22 User_116 User_92 User_68 User_30 User_41 \\\n", "3245 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3246 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3247 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3248 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3249 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3250 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3251 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3252 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3253 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "3254 0.0 0.0 0.0 0 0.0 0.0 0 0.0 \n", "\n", " User_75 User_24 User_12 User_117 User_9 User_110 User_119 \\\n", "3245 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3246 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3247 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3248 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3249 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3250 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3251 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3252 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3253 0.0 0.0 0.0 0 0.0 0.0 0 \n", "3254 0.0 0.0 0.0 0 0.0 0.0 0 \n", "\n", " User_101 User_36 User_115 User_18 User_144 User_118 User_120 \\\n", "3245 0 0.0 0 0.0 0.0 0 0.0 \n", "3246 0 0.0 0 0.0 0.0 0 0.0 \n", "3247 0 0.0 0 0.0 0.0 0 0.0 \n", "3248 0 0.0 0 0.0 0.0 0 0.0 \n", "3249 0 0.0 0 0.0 0.0 0 0.0 \n", "3250 0 0.0 0 0.0 0.0 0 0.0 \n", "3251 0 0.0 0 0.0 0.0 0 0.0 \n", "3252 0 0.0 0 0.0 0.0 0 0.0 \n", "3253 0 0.0 0 0.0 0.0 0 0.0 \n", "3254 0 0.0 0 0.0 0.0 0 0.0 \n", "\n", " User_25 User_23 User_86 User_90 User_73 User_142 User_141 \\\n", "3245 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3246 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3247 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3248 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3249 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3250 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3251 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3252 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3253 0.0 0.0 0.0 0 0.0 0 0.0 \n", "3254 0.0 0.0 0.0 0 0.0 0 0.0 \n", "\n", " User_76 User_32 User_50 User_125 User_145 User_97 User_61 \\\n", "3245 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3246 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3247 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3248 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3249 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3250 0.0 0.0 0.0 0 0.0 0.0 8.0 \n", "3251 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3252 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3253 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "3254 0.0 0.0 0.0 0 0.0 0.0 0.0 \n", "\n", " User_39 User_148 User_127 User_128 User_46 User_121 User_103 \\\n", "3245 0.0 0 0 0 0.0 0 0 \n", "3246 0.0 0 0 0 0.0 0 0 \n", "3247 0.0 0 0 0 0.0 0 0 \n", "3248 0.0 0 0 0 0.0 0 0 \n", "3249 0.0 0 0 0 0.0 0 0 \n", "3250 0.0 0 0 0 0.0 0 0 \n", "3251 0.0 0 0 0 0.0 0 0 \n", "3252 0.0 0 0 0 0.0 0 0 \n", "3253 0.0 0 0 0 0.0 0 0 \n", "3254 0.0 0 0 0 0.0 0 0 \n", "\n", " User_122 User_60 User_83 User_40 User_53 User_48 User_146 \\\n", "3245 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3246 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3247 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3248 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3249 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3250 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3251 0 0.0 0.0 0.0 12.0 0.0 0 \n", "3252 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3253 0 0.0 0.0 0.0 0.0 0.0 0 \n", "3254 0 0.0 0.0 0.0 0.0 12.0 0 \n", "\n", " User_107 User_51 User_123 User_143 User_45 User_54 User_63 \\\n", "3245 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3246 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3247 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3248 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3249 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3250 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3251 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3252 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "3253 0.0 0.0 0 0.0 0.0 8.0 0.0 \n", "3254 0.0 0.0 0 0.0 0.0 0.0 0.0 \n", "\n", " User_124 User_138 User_93 User_64 User_126 User_58 User_57 \\\n", "3245 0 0.0 0 0.0 0 0.0 0.0 \n", "3246 0 0.0 0 0.0 0 0.0 0.0 \n", "3247 0 0.0 0 0.0 0 0.0 0.0 \n", "3248 0 0.0 0 0.0 0 0.0 0.0 \n", "3249 0 0.0 0 0.0 0 0.0 0.0 \n", "3250 0 0.0 0 0.0 0 0.0 0.0 \n", "3251 0 0.0 0 0.0 0 0.0 0.0 \n", "3252 0 0.0 0 0.0 0 0.0 0.0 \n", "3253 0 0.0 0 0.0 0 0.0 0.0 \n", "3254 0 0.0 0 0.0 0 0.0 0.0 \n", "\n", " User_106 User_79 User_62 User_78 User_133 User_82 User_55 \\\n", "3245 0 0.0 0.0 0.0 0 0 0.0 \n", "3246 0 0.0 0.0 0.0 0 0 0.0 \n", "3247 0 0.0 0.0 0.0 0 0 0.0 \n", "3248 0 0.0 0.0 0.0 0 0 0.0 \n", "3249 0 0.0 0.0 0.0 0 0 0.0 \n", "3250 0 0.0 0.0 0.0 0 0 0.0 \n", "3251 0 0.0 0.0 0.0 0 0 0.0 \n", "3252 0 0.0 0.0 0.0 0 0 0.0 \n", "3253 0 0.0 0.0 0.0 0 0 0.0 \n", "3254 0 0.0 0.0 0.0 0 0 0.0 \n", "\n", " User_66 User_139 User_56 User_91 User_111 User_59 User_132 \\\n", "3245 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3246 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3247 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3248 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3249 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3250 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3251 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3252 8.0 0 0.0 0.0 0 0.0 0.0 \n", "3253 0.0 0 0.0 0.0 0 0.0 0.0 \n", "3254 0.0 0 0.0 0.0 0 0.0 0.0 \n", "\n", " User_130 User_67 User_104 User_131 User_65 User_77 User_84 \\\n", "3245 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3246 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3247 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3248 0 0.0 9.0 0 0.0 0.0 2.0 \n", "3249 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3250 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3251 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3252 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3253 0 0.0 0.0 0 0.0 0.0 0.0 \n", "3254 0 0.0 0.0 0 0.0 0.0 0.0 \n", "\n", " User_80 User_96 User_136 User_129 User_69 User_134 \\\n", "3245 0.0 0.0 0 0 0 0 \n", "3246 12.0 0.0 0 0 0 0 \n", "3247 0.0 0.0 0 0 0 0 \n", "3248 2.0 0.0 0 0 0 0 \n", "3249 2.0 0.0 0 0 0 0 \n", "3250 0.0 0.0 0 0 0 0 \n", "3251 0.0 0.0 0 0 0 0 \n", "3252 0.0 0.0 0 0 0 0 \n", "3253 0.0 0.0 0 0 0 0 \n", "3254 0.0 0.0 0 0 0 0 \n", "\n", " A_Create Application complete A_Submitted complete \\\n", "3245 1 1.0 \n", "3246 1 0.0 \n", "3247 1 0.0 \n", "3248 1 0.0 \n", "3249 1 0.0 \n", "3250 1 1.0 \n", "3251 1 1.0 \n", "3252 1 1.0 \n", "3253 1 1.0 \n", "3254 1 0.0 \n", "\n", " W_Handle leads schedule W_Handle leads withdraw \\\n", "3245 1.0 1.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 1.0 1.0 \n", "3251 1.0 0.0 \n", "3252 1.0 1.0 \n", "3253 1.0 1.0 \n", "3254 0.0 0.0 \n", "\n", " W_Complete application schedule A_Concept complete \\\n", "3245 1 1 \n", "3246 1 1 \n", "3247 1 1 \n", "3248 1 1 \n", "3249 1 1 \n", "3250 1 1 \n", "3251 1 1 \n", "3252 1 1 \n", "3253 1 1 \n", "3254 1 1 \n", "\n", " W_Complete application start A_Accepted complete \\\n", "3245 1.0 1 \n", "3246 1.0 1 \n", "3247 1.0 1 \n", "3248 1.0 1 \n", "3249 1.0 1 \n", "3250 0.0 1 \n", "3251 1.0 1 \n", "3252 0.0 1 \n", "3253 0.0 1 \n", "3254 1.0 1 \n", "\n", " O_Create Offer complete O_Created complete \\\n", "3245 1 1 \n", "3246 1 1 \n", "3247 1 1 \n", "3248 1 1 \n", "3249 1 1 \n", "3250 1 1 \n", "3251 2 2 \n", "3252 1 1 \n", "3253 1 1 \n", "3254 1 1 \n", "\n", " O_Sent (mail and online) complete W_Complete application complete \\\n", "3245 1.0 1.0 \n", "3246 1.0 1.0 \n", "3247 1.0 1.0 \n", "3248 1.0 1.0 \n", "3249 1.0 0.0 \n", "3250 1.0 0.0 \n", "3251 2.0 1.0 \n", "3252 1.0 0.0 \n", "3253 1.0 0.0 \n", "3254 1.0 1.0 \n", "\n", " W_Call after offers schedule W_Call after offers start \\\n", "3245 1 1 \n", "3246 1 1 \n", "3247 1 1 \n", "3248 1 1 \n", "3249 1 1 \n", "3250 1 1 \n", "3251 1 1 \n", "3252 1 1 \n", "3253 1 1 \n", "3254 1 1 \n", "\n", " A_Complete complete W_Call after offers suspend \\\n", "3245 1 0 \n", "3246 1 0 \n", "3247 1 0 \n", "3248 1 0 \n", "3249 1 0 \n", "3250 1 0 \n", "3251 1 0 \n", "3252 1 0 \n", "3253 1 0 \n", "3254 1 0 \n", "\n", " W_Call after offers resume A_Cancelled complete O_Cancelled complete \\\n", "3245 0 0 0.0 \n", "3246 0 0 0.0 \n", "3247 0 0 0.0 \n", "3248 0 0 0.0 \n", "3249 0 0 0.0 \n", "3250 0 0 0.0 \n", "3251 0 0 0.0 \n", "3252 0 0 0.0 \n", "3253 0 0 0.0 \n", "3254 0 0 0.0 \n", "\n", " W_Call after offers ate_abort W_Complete application suspend \\\n", "3245 0 0.0 \n", "3246 0 0.0 \n", "3247 0 0.0 \n", "3248 0 3.0 \n", "3249 0 2.0 \n", "3250 0 0.0 \n", "3251 0 0.0 \n", "3252 0 0.0 \n", "3253 0 0.0 \n", "3254 0 0.0 \n", "\n", " W_Complete application resume W_Complete application ate_abort \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 3.0 0.0 \n", "3249 1.0 1.0 \n", "3250 0.0 0.0 \n", "3251 0.0 0.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Validate application schedule W_Validate application start \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " A_Validating complete O_Returned complete \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Validate application suspend W_Validate application ate_abort \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Call incomplete files schedule W_Call incomplete files start \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " A_Incomplete complete W_Call incomplete files suspend \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Call incomplete files resume W_Call incomplete files ate_abort \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " O_Sent (online only) complete W_Handle leads start \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 0.0 1.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Handle leads complete W_Validate application resume \\\n", "3245 0.0 0 \n", "3246 0.0 0 \n", "3247 0.0 0 \n", "3248 0.0 0 \n", "3249 0.0 0 \n", "3250 0.0 0 \n", "3251 0.0 0 \n", "3252 0.0 0 \n", "3253 0.0 0 \n", "3254 0.0 0 \n", "\n", " W_Validate application complete W_Call incomplete files complete \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Complete application withdraw W_Call after offers complete \\\n", "3245 0.0 0 \n", "3246 0.0 0 \n", "3247 0.0 0 \n", "3248 0.0 0 \n", "3249 0.0 0 \n", "3250 1.0 0 \n", "3251 0.0 0 \n", "3252 1.0 0 \n", "3253 1.0 0 \n", "3254 0.0 0 \n", "\n", " W_Handle leads suspend W_Handle leads resume \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 2.0 1.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Assess potential fraud schedule W_Assess potential fraud start \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 0.0 0.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Assess potential fraud suspend W_Assess potential fraud resume \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 0.0 0.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Assess potential fraud complete W_Handle leads ate_abort \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 0.0 1.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " W_Shortened completion schedule W_Shortened completion start \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Shortened completion suspend W_Shortened completion resume \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " O_Accepted complete A_Pending complete \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Personal Loan collection schedule W_Personal Loan collection start \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Personal Loan collection suspend W_Personal Loan collection resume \\\n", "3245 0 0 \n", "3246 0 0 \n", "3247 0 0 \n", "3248 0 0 \n", "3249 0 0 \n", "3250 0 0 \n", "3251 0 0 \n", "3252 0 0 \n", "3253 0 0 \n", "3254 0 0 \n", "\n", " W_Assess potential fraud ate_abort W_Assess potential fraud withdraw \\\n", "3245 0.0 0.0 \n", "3246 0.0 0.0 \n", "3247 0.0 0.0 \n", "3248 0.0 0.0 \n", "3249 0.0 0.0 \n", "3250 0.0 0.0 \n", "3251 0.0 0.0 \n", "3252 0.0 0.0 \n", "3253 0.0 0.0 \n", "3254 0.0 0.0 \n", "\n", " FirstWithdrawalAmount NumberOfTerms Accepted MonthlyCost Selected \\\n", "3245 20000.0 60.0 True 371.17 True \n", "3246 0.0 134.0 True 100.00 True \n", "3247 0.0 126.0 True 400.00 True \n", "3248 0.0 126.0 False 320.00 True \n", "3249 2000.0 134.0 True 130.00 True \n", "3250 0.0 82.0 True 500.00 True \n", "3251 30000.0 125.0 False 650.00 False \n", "3252 10000.0 44.0 True 249.58 True \n", "3253 5000.0 36.0 True 152.82 True \n", "3254 25000.0 60.0 False 461.78 False \n", "\n", " CreditScore OfferedAmount case:LoanGoal case:ApplicationType \\\n", "3245 878.0 20000.0 Car New credit \n", "3246 839.0 10000.0 Home improvement Limit raise \n", "3247 0.0 40000.0 Unknown Limit raise \n", "3248 0.0 32000.0 Unknown Limit raise \n", "3249 775.0 13000.0 Car Limit raise \n", "3250 733.0 35000.0 Car New credit \n", "3251 0.0 64500.0 Other, see explanation New credit \n", "3252 1083.0 10000.0 Car New credit \n", "3253 908.0 5000.0 Car New credit \n", "3254 0.0 25000.0 Car New credit \n", "\n", " case:RequestedAmount first_timestamp trace_duration \\\n", "3245 20000.0 2016-10-18 08:51:42.172000+00:00 170163.713 \n", "3246 10000.0 2016-10-18 09:04:18.477000+00:00 601.295 \n", "3247 0.0 2016-10-18 09:06:20.637000+00:00 150.016 \n", "3248 0.0 2016-10-18 09:30:06.339000+00:00 183303.148 \n", "3249 13000.0 2016-10-18 09:34:06.469000+00:00 266088.593 \n", "3250 35000.0 2016-10-18 10:31:35.256000+00:00 91691.652 \n", "3251 65000.0 2016-10-18 11:12:05.182000+00:00 167404.402 \n", "3252 10000.0 2016-10-18 11:24:50.857000+00:00 82687.083 \n", "3253 5000.0 2016-10-18 12:00:33.792000+00:00 89843.380 \n", "3254 25000.0 2016-10-18 12:02:09.032000+00:00 515.051 \n", "\n", " next_event \n", "3245 True \n", "3246 True \n", "3247 True \n", "3248 True \n", "3249 True \n", "3250 True \n", "3251 True \n", "3252 True \n", "3253 True \n", "3254 True " ] }, "execution_count": 105, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_train_case.tail(10)" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3.9.7 ('base')", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.7" }, "vscode": { "interpreter": { "hash": "207398d66480d5b2b9abbd127913c2d129a9922276615475dd81a0eedd9eb59f" } } }, "nbformat": 4, "nbformat_minor": 4}