Please help to modify the whole Lab 03 code follow the Introduction, thank you so much!

Lab 3 code:

bank-Detail.csv

ID12101,48,FEMALE,INNER_CITY,22467,YES,0,YES,YES,NO,YES,YES ID12102,40,MALE,TOWN,32825,NO,3,NO,YES,YES,NO,YES ID12103,51,FEMALE,INNER_CITY,16575.4,NO,1,NO,NO,YES,YES,YES ID12104,23,FEMALE,TOWN,20375.4,NO,0,YES,YES,YES,YES,NO ID12105,57,FEMALE,RURAL,50576.3,NO,2,YES,NO,NO,YES,NO ID12106,57,FEMALE,TOWN,37869.6,YES,3,NO,YES,YES,YES,YES ID12107,22,MALE,RURAL,8877.07,YES,1,YES,NO,YES,NO,YES ID12108,58,MALE,TOWN,24946.6,NO,2,NO,YES,YES,NO,NO ID12109,37,FEMALE,SUBURBAN,25304.3,YES,3,NO,NO,NO,NO,NO ID12110,54,MALE,TOWN,24212.1,YES,2,YES,YES,YES,NO,NO ID12111,66,FEMALE,TOWN,59803.9,YES,0,NO,YES,YES,NO,NO ID12112,52,FEMALE,INNER_CITY,266222.8,NO,0,YES,YES,YES,YES,NO ID12113,44,FEMALE,TOWN,15735.8,YES,1,NO,YES,YES,YES,YES ID12114,66,FEMALE,TOWN,55204.7,YES,1,YES,YES,YES,YES,YES ID12115,36,MALE,RURAL,19474.6,YES,0,NO,YES,YES,YES,NO ID12116,38,FEMALE,INNER_CITY,22342.1,YES,0,YES,YES,YES,YES,NO ID12117,37,FEMALE,TOWN,17729.8,YES,2,NO,NO,NO,YES,NO ID12118,46,FEMALE,SUBURBAN,41016,YES,0,NO,YES,NO,YES,NO ID12119,62,FEMALE,INNER_CITY,26909.2,YES,0,NO,YES,NO,NO,YES ID12120,31,MALE,TOWN,22522.8,YES,0,YES,YES,YES,NO,NO ID12121,61,MALE,INNER_CITY,57880.7,YES,2,NO,YES,NO,NO,YES ID12122,50,MALE,TOWN,16497.3,YES,2,NO,YES,YES,NO,NO ID12123,54,MALE,INNER_CITY,38446.6,YES,0,NO,YES,YES,NO,NO ID12124,27,FEMALE,TOWN,15538.8,NO,0,YES,YES,YES,YES,NO ID12125,22,MALE,INNER_CITY,12640.3,NO,2,YES,YES,YES,NO,NO ID12126,56,MALE,INNER_CITY,41034,YES,0,YES,YES,YES,YES,NO ID12127,45,MALE,INNER_CITY,20809.7,YES,0,NO,YES,YES,YES,NO ID12128,39,FEMALE,TOWN,20114,YES,1,NO,NO,YES,NO,YES ID12129,39,FEMALE,INNER_CITY,29359.1,NO,3,YES,NO,YES,YES,NO ID12130,61,MALE,RURAL,24270.1,YES,1,NO,NO,YES,NO,YES ID12131,61,FEMALE,RURAL,22942.9,YES,2,NO,YES,YES,NO,NO ID12132,20,FEMALE,TOWN,16325.8,YES,2,NO,YES,NO,NO,NO ID12133,45,MALE,SUBURBAN,23443.2,YES,1,YES,YES,YES,NO,YES ID12134,33,FEMALE,INNER_CITY,29921.3,NO,3,YES,YES,NO,NO,NO ID12135,43,MALE,SUBURBAN,37521.9,NO,0,NO,YES,YES,NO,YES ID12136,27,FEMALE,INNER_CITY,19868,YES,2,NO,YES,YES,NO,NO ID12137,19,MALE,RURAL,10953,YES,3,YES,YES,YES,NO,NO ID12138,36,FEMALE,RURAL,13381,NO,0,YES,NO,YES,NO,YES ID12139,43,FEMALE,TOWN,18504.3,YES,0,YES,YES,YES,NO,NO ID12140,66,FEMALE,SUBURBAN,25391.5,NO,2,NO,NO,YES,NO,NO ID12141,55,MALE,TOWN,26774.2,YES,0,NO,NO,YES,YES,YES ID12142,47,FEMALE,INNER_CITY,26952.6,YES,0,YES,NO,YES,NO,NO ID12143,67,MALE,TOWN,55716.5,NO,2,YES,YES,NO,NO,YES ID12144,32,FEMALE,TOWN,27571.5,YES,0,YES,NO,YES,YES,NO ID12145,20,MALE,INNER_CITY,13740,NO,2,YES,YES,YES,YES,NO ID12146,64,MALE,INNER_CITY,52670.6,YES,2,NO,YES,YES,YES,YES ID12147,50,FEMALE,INNER_CITY,13283.9,NO,1,YES,YES,YES,NO,YES ID12148,29,MALE,INNER_CITY,13106.6,NO,2,NO,YES,YES,YES,YES ID12149,52,MALE,INNER_CITY,39547.8,NO,2,YES,NO,YES,NO,YES ID12150,47,FEMALE,RURAL,17867.3,YES,2,YES,YES,NO,NO,NO ID12151,24,MALE,TOWN,14309.7,NO,2,YES,YES,NO,NO,NO ID12152,36,MALE,TOWN,23894.8,YES,0,NO,NO,NO,NO,NO ID12153,43,MALE,TOWN,16259.7,YES,1,NO,YES,YES,NO,YES ID12154,48,MALE,SUBURBAN,29794.1,NO,1,NO,YES,YES,NO,YES ID12155,63,MALE,TOWN,56842.5,YES,0,NO,YES,YES,YES,NO ID12156,52,FEMALE,RURAL,47835.8,NO,3,NO,YES,NO,NO,YES ID12157,58,FEMALE,INNER_CITY,24977.5,NO,0,NO,NO,YES,NO,YES ID12158,28,MALE,INNER_CITY,23124.9,YES,0,NO,YES,YES,NO,YES ID12159,29,FEMALE,INNER_CITY,15143.8,YES,0,NO,NO,YES,NO,NO ID12160,34,MALE,INNER_CITY,25334.3,NO,1,YES,YES,YES,YES,YES ID12161,42,FEMALE,INNER_CITY,24763.3,YES,1,NO,YES,YES,YES,YES ID12162,65,FEMALE,INNER_CITY,36589,NO,1,YES,NO,YES,NO,YES ID12163,47,MALE,INNER_CITY,27022.6,YES,2,NO,YES,YES,NO,NO ID12164,20,MALE,INNER_CITY,11700.4,YES,0,NO,YES,NO,NO,NO ID12165,21,MALE,TOWN,5014.21,NO,0,YES,YES,YES,YES,NO ID12166,42,MALE,INNER_CITY,17390.1,YES,0,NO,YES,YES,NO,NO ID12167,19,MALE,TOWN,10861,NO,2,NO,YES,YES,NO,NO ID12168,41,FEMALE,TOWN,34892.9,NO,0,NO,YES,YES,YES,NO ID12169,30,MALE,TOWN,19403.1,NO,2,NO,YES,YES,NO,NO ID12170,31,FEMALE,RURAL,10441.9,YES,2,NO,NO,YES,NO,YES ID12171,25,MALE,INNER_CITY,14064.9,YES,3,YES,YES,YES,NO,NO ID12172,21,MALE,INNER_CITY,8062.73,NO,0,NO,NO,YES,NO,YES ID12173,36,MALE,INNER_CITY,31982,YES,3,YES,YES,YES,YES,YES ID12174,58,FEMALE,INNER_CITY,23197.5,YES,2,NO,YES,NO,YES,NO ID12175,64,FEMALE,INNER_CITY,52674,NO,2,YES,YES,YES,NO,YES ID12176,59,FEMALE,RURAL,35610.5,NO,2,YES,NO,NO,NO,YES ID12177,45,FEMALE,TOWN,26948,NO,0,NO,YES,YES,YES,NO ID12178,61,MALE,INNER_CITY,49456.7,YES,1,YES,YES,YES,YES,YES ID12179,30,FEMALE,INNER_CITY,14724.5,YES,0,YES,NO,YES,NO,NO ID12180,58,FEMALE,TOWN,34524.9,YES,2,YES,YES,NO,NO,YES ID12181,50,FEMALE,TOWN,22052.1,NO,3,NO,YES,YES,NO,YES ID12182,30,MALE,INNER_CITY,27808.1,NO,3,NO,NO,YES,NO,NO ID12183,29,FEMALE,INNER_CITY,12591.4,YES,1,NO,YES,YES,NO,NO ID12184,35,MALE,INNER_CITY,16394.4,YES,1,NO,YES,YES,NO,YES ID12185,62,MALE,INNER_CITY,24026.1,YES,0,NO,NO,YES,YES,YES ID12186,36,MALE,INNER_CITY,31683.1,YES,1,YES,YES,YES,NO,YES ID12187,25,FEMALE,INNER_CITY,15525,YES,0,NO,YES,YES,NO,NO ID12188,66,FEMALE,TOWN,22562.2,NO,0,YES,YES,YES,YES,NO ID12189,30,MALE,SUBURBAN,15848.7,YES,0,YES,YES,NO,YES,NO ID12190,54,FEMALE,INNER_CITY,31095.6,YES,2,NO,NO,YES,NO,YES ID12191,37,MALE,TOWN,24814.5,YES,1,YES,NO,YES,YES,YES ID12192,28,FEMALE,INNER_CITY,25429.3,NO,2,NO,YES,YES,YES,NO ID12193,53,FEMALE,RURAL,34866.5,NO,0,NO,NO,YES,NO,YES ID12194,61,MALE,INNER_CITY,42579.1,YES,2,YES,YES,YES,NO,NO ID12195,61,FEMALE,INNER_CITY,41127.4,YES,0,YES,YES,NO,NO,NO ID12196,18,FEMALE,INNER_CITY,9990.11,YES,0,NO,YES,YES,NO,NO ID12197,22,MALE,INNER_CITY,7948.62,YES,1,NO,NO,NO,YES,NO ID12198,34,MALE,TOWN,30870.8,YES,2,YES,YES,YES,YES,YES ID12199,35,FEMALE,INNER_CITY,12125.8,NO,2,NO,YES,YES,NO,NO ID12200,18,FEMALE,RURAL,15348.9,YES,0,YES,NO,YES,NO,NO ID12201,54,MALE,INNER_CITY,26707.9,YES,1,NO,YES,YES,YES,YES ID12202,27,FEMALE,INNER_CITY,11604.4,YES,2,YES,YES,YES,NO,NO ID12203,42,MALE,INNER_CITY,15499.9,YES,0,YES,NO,YES,YES,YES ID12204,43,MALE,TOWN,33088.5,NO,0,NO,YES,YES,YES,NO ID12205,64,FEMALE,INNER_CITY,34513.6,YES,1,NO,YES,YES,NO,YES ID12206,43,MALE,TOWN,32395.5,YES,3,YES,YES,YES,NO,NO ID12207,49,MALE,RURAL,46633,YES,0,YES,YES,NO,NO,NO ID12208,23,MALE,INNER_CITY,13039.9,YES,0,NO,NO,YES,NO,NO ID12209,23,MALE,INNER_CITY,12681.9,NO,0,NO,YES,YES,NO,YES ID12210,30,FEMALE,INNER_CITY,24031.5,YES,2,YES,YES,YES,YES,NO ID12211,36,MALE,TOWN,37330.5,NO,2,NO,YES,YES,NO,YES ID12212,34,MALE,INNER_CITY,25333.2,YES,3,YES,NO,NO,YES,NO ID12213,51,FEMALE,INNER_CITY,37094.2,YES,0,YES,NO,YES,NO,NO ID12214,36,MALE,TOWN,33630.6,NO,2,YES,YES,YES,NO,YES ID12215,56,MALE,INNER_CITY,43228.2,YES,1,YES,YES,YES,NO,YES ID12216,54,FEMALE,INNER_CITY,47796.8,YES,0,NO,YES,YES,NO,NO ID12217,56,FEMALE,TOWN,21730.3,YES,2,NO,YES,NO,NO,NO ID12218,26,MALE,INNER_CITY,10044.1,YES,3,NO,YES,YES,YES,NO ID12219,39,MALE,TOWN,17270.1,NO,0,YES,NO,NO,NO,YES ID12220,64,FEMALE,RURAL,45765,YES,3,YES,YES,YES,NO,YES ID12221,46,MALE,RURAL,29525.5,NO,2,NO,YES,NO,YES,NO ID12222,62,FEMALE,RURAL,54863.8,YES,1,YES,YES,YES,NO,YES ID12223,36,FEMALE,TOWN,20799,YES,1,NO,YES,NO,YES,YES ID12224,35,FEMALE,RURAL,33028.3,NO,1,NO,YES,YES,NO,YES ID12225,47,MALE,RURAL,45031.9,NO,3,YES,YES,NO,NO,YES ID12226,47,MALE,INNER_CITY,39010.8,YES,2,NO,NO,YES,NO,YES ID12227,37,FEMALE,TOWN,25257.7,YES,0,YES,YES,YES,NO,NO ID12228,48,FEMALE,INNER_CITY,42603.9,YES,0,NO,YES,YES,NO,NO ID12229,41,MALE,TOWN,14092.7,YES,3,YES,YES,YES,NO,NO ID12230,27,FEMALE,RURAL,21350.3,NO,0,YES,YES,YES,NO,YES ID12231,43,MALE,INNER_CITY,23246.4,NO,2,NO,NO,YES,NO,NO ID12232,61,MALE,RURAL,41609.5,YES,3,NO,YES,YES,YES,NO ID12233,52,FEMALE,SUBURBAN,16716.1,NO,2,YES,YES,YES,NO,NO ID12234,64,FEMALE,SUBURBAN,36436.4,YES,0,YES,NO,YES,NO,NO ID12235,66,FEMALE,TOWN,59503.8,YES,2,YES,YES,YES,YES,YES ID12236,53,FEMALE,TOWN,31334.8,YES,1,YES,YES,YES,NO,YES ID12237,20,FEMALE,INNER_CITY,14048.9,YES,2,YES,NO,YES,YES,NO ID12238,57,FEMALE,INNER_CITY,39205.3,NO,0,NO,YES,YES,NO,YES ID12239,65,FEMALE,RURAL,42173.9,YES,0,NO,YES,YES,NO,NO ID12240,64,FEMALE,INNER_CITY,55263,NO,1,NO,YES,YES,NO,YES ID12241,52,MALE,INNER_CITY,37095.2,YES,3,NO,YES,YES,NO,NO ID12242,47,FEMALE,INNER_CITY,22791.4,YES,0,NO,NO,YES,NO,NO ID12243,28,FEMALE,TOWN,17240.6,YES,1,YES,NO,NO,YES,NO ID12244,64,MALE,TOWN,48974.8,YES,0,YES,YES,YES,YES,NO ID12245,25,MALE,INNER_CITY,18923,YES,1,NO,YES,YES,NO,YES ID12246,58,MALE,SUBURBAN,51204.2,YES,0,NO,YES,NO,YES,YES ID12247,34,MALE,TOWN,20236.2,YES,2,YES,NO,YES,NO,NO ID12248,20,FEMALE,INNER_CITY,18860.3,NO,2,NO,YES,YES,NO,NO ID12249,63,MALE,RURAL,25732.5,YES,0,YES,YES,NO,NO,NO ID12250,30,FEMALE,SUBURBAN,28240.4,YES,3,YES,YES,YES,NO,NO ID12251,53,MALE,RURAL,28193.6,YES,1,YES,YES,YES,NO,YES ID12252,43,MALE,TOWN,36432.8,NO,2,YES,NO,YES,NO,YES ID12253,63,MALE,TOWN,54618.8,YES,2,NO,YES,NO,YES,YES ID12254,33,MALE,INNER_CITY,24760.8,YES,1,NO,YES,YES,YES,YES ID12255,41,MALE,RURAL,23356.1,NO,2,YES,NO,NO,NO,NO ID12256,20,FEMALE,SUBURBAN,8143.75,YES,2,NO,YES,YES,NO,YES ID12257,50,MALE,TOWN,26462.5,YES,0,YES,YES,YES,NO,NO ID12258,24,MALE,RURAL,20467.3,YES,2,YES,YES,YES,NO,NO ID12259,60,FEMALE,TOWN,21506.2,YES,0,NO,NO,YES,NO,YES ID12260,44,FEMALE,TOWN,15315.3,YES,1,NO,YES,YES,NO,YES ID12261,23,MALE,INNER_CITY,18875.7,YES,2,YES,YES,YES,NO,NO ID12262,40,FEMALE,INNER_CITY,12977.2,YES,0,NO,NO,NO,NO,NO ID12263,49,FEMALE,TOWN,20708.5,NO,3,NO,NO,YES,NO,NO ID12264,21,FEMALE,TOWN,7549.38,NO,1,YES,NO,YES,NO,NO ID12265,40,FEMALE,INNER_CITY,24904,YES,0,NO,NO,NO,NO,NO ID12266,26,MALE,RURAL,24071.8,YES,1,NO,NO,YES,YES,YES ID12267,20,MALE,TOWN,9589.91,NO,1,NO,YES,YES,YES,NO ID12268,24,MALE,INNER_CITY,8562.86,NO,1,NO,NO,NO,YES,NO ID12269,37,FEMALE,TOWN,26707.5,NO,0,YES,YES,YES,NO,NO ID12270,56,MALE,INNER_CITY,34020.5,YES,0,NO,NO,YES,NO,NO ID12271,52,MALE,INNER_CITY,49175.7,YES,0,YES,YES,YES,NO,NO ID12272,22,MALE,INNER_CITY,19726.3,YES,2,NO,NO,YES,NO,NO ID12273,35,MALE,INNER_CITY,24346.6,YES,3,YES,YES,YES,NO,NO ID12274,34,MALE,RURAL,26999.4,YES,1,YES,YES,YES,NO,YES ID12275,67,FEMALE,TOWN,41558.1,YES,2,NO,YES,YES,NO,YES ID12276,58,FEMALE,INNER_CITY,56340.3,NO,0,NO,YES,YES,NO,YES ID12277,40,MALE,TOWN,37558.5,YES,0,YES,YES,YES,NO,NO ID12278,41,FEMALE,INNER_CITY,30099.3,YES,0,YES,YES,YES,YES,YES ID12279,43,MALE,INNER_CITY,15254.8,YES,0,NO,NO,NO,NO,YES ID12280,63,MALE,INNER_CITY,36086.1,YES,2,NO,NO,YES,NO,YES ID12281,22,FEMALE,INNER_CITY,17655,YES,1,NO,YES,YES,YES,YES ID12282,60,MALE,RURAL,56658.9,NO,0,NO,YES,YES,NO,YES ID12283,65,FEMALE,INNER_CITY,37706.5,NO,0,YES,YES,YES,YES,NO ID12284,48,FEMALE,INNER_CITY,18516,YES,2,YES,YES,YES,YES,NO ID12285,38,FEMALE,INNER_CITY,29622,NO,0,YES,YES,NO,YES,NO ID12286,49,MALE,RURAL,32669.9,YES,1,YES,YES,YES,YES,YES ID12287,20,FEMALE,INNER_CITY,18275.5,YES,0,NO,NO,NO,YES,YES ID12288,48,FEMALE,TOWN,34410,YES,1,NO,NO,YES,NO,YES ID12289,38,MALE,INNER_CITY,34866.9,YES,2,YES,NO,YES,YES,NO ID12290,41,FEMALE,INNER_CITY,21796.6,YES,0,NO,NO,YES,NO,NO ID12291,67,FEMALE,SUBURBAN,63130.1,YES,2,YES,YES,YES,NO,YES ID12292,39,MALE,INNER_CITY,14996.4,YES,1,YES,YES,NO,NO,NO ID12293,64,FEMALE,RURAL,49024.9,YES,3,NO,YES,YES,NO,YES ID12294,41,MALE,INNER_CITY,16249.8,YES,0,YES,NO,YES,YES,YES ID12295,55,MALE,SUBURBAN,36192.1,YES,2,YES,NO,YES,NO,YES ID12296,52,MALE,INNER_CITY,17839.9,YES,1,NO,YES,NO,YES,YES ID12297,30,FEMALE,INNER_CITY,18802.4,NO,0,NO,NO,YES,YES,YES ID12298,52,MALE,INNER_CITY,48720.3,YES,2,YES,YES,YES,NO,YES ID12299,26,MALE,INNER_CITY,14585.9,NO,2,NO,NO,YES,YES,NO ID12300,26,FEMALE,INNER_CITY,20819,YES,0,NO,YES,YES,NO,YES ID12301,46,MALE,TOWN,26077.8,YES,1,YES,YES,YES,NO,YES ID12302,46,FEMALE,TOWN,41627.1,YES,0,NO,YES,YES,YES,NO ID12303,52,MALE,INNER_CITY,16977.3,YES,0,NO,NO,YES,NO,NO ID12304,37,MALE,INNER_CITY,19012.8,NO,3,YES,NO,YES,NO,NO ID12305,22,MALE,INNER_CITY,12764.8,YES,1,NO,YES,YES,YES,YES ID12306,18,MALE,INNER_CITY,14388.6,NO,0,YES,NO,YES,YES,YES ID12307,63,MALE,INNER_CITY,59409.1,NO,0,YES,YES,YES,NO,YES ID12308,25,FEMALE,INNER_CITY,14960.2,YES,0,NO,YES,YES,YES,NO ID12309,67,MALE,INNER_CITY,39666.6,YES,0,YES,YES,YES,NO,NO ID12310,27,MALE,INNER_CITY,20771.9,NO,0,NO,YES,NO,NO,YES ID12311,61,MALE,INNER_CITY,24474.1,NO,0,YES,NO,NO,NO,YES ID12312,58,MALE,TOWN,33123.7,YES,1,YES,YES,YES,NO,YES ID12313,22,MALE,INNER_CITY,14433.4,YES,0,YES,YES,YES,NO,YES ID12314,28,MALE,TOWN,13175.5,NO,1,NO,NO,YES,NO,YES ID12315,23,MALE,INNER_CITY,9824.37,YES,0,NO,YES,YES,NO,NO ID12316,27,MALE,SUBURBAN,17610.3,YES,0,NO,YES,YES,NO,NO ID12317,27,FEMALE,SUBURBAN,15156.2,YES,0,YES,NO,YES,NO,NO ID12318,40,FEMALE,INNER_CITY,31774.1,YES,3,YES,YES,YES,YES,NO ID12319,39,MALE,TOWN,31693.5,NO,0,YES,YES,NO,NO,YES ID12320,35,FEMALE,INNER_CITY,28598.7,YES,0,YES,YES,YES,NO,NO ID12321,37,FEMALE,INNER_CITY,26261.7,NO,2,YES,NO,NO,NO,NO ID12322,47,MALE,INNER_CITY,42124.1,YES,2,NO,YES,YES,NO,YES ID12323,42,FEMALE,INNER_CITY,39308.7,YES,1,NO,YES,YES,NO,YES ID12324,67,FEMALE,INNER_CITY,43530,YES,0,NO,YES,YES,YES,NO ID12325,57,MALE,RURAL,49874.4,YES,3,NO,YES,YES,NO,YES ID12326,47,FEMALE,RURAL,27434.8,NO,0,YES,YES,YES,NO,YES ID12327,67,MALE,INNER_CITY,50474.6,YES,2,YES,YES,YES,NO,YES ID12328,56,MALE,TOWN,24888.2,NO,0,NO,YES,YES,NO,YES ID12329,37,MALE,RURAL,28021.6,NO,0,YES,NO,YES,YES,YES ID12330,27,MALE,INNER_CITY,12279.5,NO,0,YES,NO,NO,NO,YES ID12331,59,FEMALE,INNER_CITY,30189.4,YES,0,YES,NO,YES,YES,YES ID12332,31,MALE,INNER_CITY,28969.4,NO,1,NO,NO,YES,YES,NO ID12333,31,MALE,SUBURBAN,14058.5,YES,0,NO,NO,YES,YES,YES ID12334,32,FEMALE,TOWN,30404.3,YES,0,YES,YES,YES,NO,NO ID12335,57,FEMALE,RURAL,41438.2,NO,3,NO,YES,NO,NO,NO ID12336,49,FEMALE,INNER_CITY,16711.3,NO,1,NO,YES,YES,YES,YES ID12337,65,MALE,TOWN,52255.9,NO,2,YES,YES,YES,NO,YES ID12338,22,FEMALE,INNER_CITY,17866.9,YES,2,NO,YES,YES,YES,NO ID12339,26,FEMALE,RURAL,18067.5,YES,2,NO,YES,NO,NO,NO ID12340,23,MALE,INNER_CITY,12823.7,YES,0,YES,YES,YES,NO,NO ID12341,26,FEMALE,RURAL,11299.3,YES,2,YES,NO,NO,NO,NO ID12342,59,FEMALE,INNER_CITY,56031.1,NO,0,YES,YES,YES,NO,YES ID12343,67,MALE,INNER_CITY,35263.5,YES,1,YES,YES,YES,NO,YES ID12344,34,FEMALE,INNER_CITY,19968.1,YES,0,YES,YES,YES,NO,NO ID12345,50,MALE,RURAL,27825.5,YES,2,YES,YES,NO,NO,NO ID12346,46,MALE,SUBURBAN,37773.9,NO,0,YES,YES,YES,YES,NO ID12347,23,FEMALE,INNER_CITY,7606.25,NO,3,YES,NO,NO,NO,NO ID12348,26,MALE,RURAL,21384.4,YES,0,NO,NO,YES,NO,NO ID12349,40,MALE,TOWN,20347,YES,3,NO,YES,YES,NO,NO ID12350,36,MALE,TOWN,21332.3,YES,3,YES,NO,YES,NO,NO ID12351,65,MALE,INNER_CITY,57671.7,NO,0,NO,YES,YES,YES,NO ID12352,45,FEMALE,TOWN,36057.8,YES,1,YES,YES,YES,YES,YES ID12353,23,MALE,INNER_CITY,14290.5,YES,2,NO,NO,YES,YES,NO ID12354,42,FEMALE,TOWN,17882.9,YES,1,NO,NO,NO,NO,YES ID12355,21,FEMALE,RURAL,10629.1,NO,3,NO,YES,YES,YES,NO ID12356,62,FEMALE,INNER_CITY,24262.8,NO,0,YES,NO,YES,NO,YES ID12357,49,FEMALE,SUBURBAN,26097.9,NO,2,NO,YES,YES,NO,NO ID12358,28,FEMALE,TOWN,23371,YES,2,NO,NO,YES,YES,NO ID12359,38,FEMALE,TOWN,21495.6,NO,3,NO,NO,YES,YES,NO ID12360,36,MALE,TOWN,12166.9,NO,0,NO,NO,NO,NO,NO ID12361,22,MALE,SUBURBAN,17180.2,YES,0,NO,YES,YES,NO,NO ID12362,40,FEMALE,TOWN,28882.3,YES,1,NO,YES,YES,YES,YES ID12363,40,FEMALE,TOWN,21612.2,YES,0,NO,NO,YES,NO,NO ID12364,60,FEMALE,INNER_CITY,46358.4,YES,0,YES,YES,YES,YES,NO ID12365,23,MALE,INNER_CITY,19166,NO,0,YES,YES,NO,NO,YES ID12366,21,MALE,INNER_CITY,17921.8,YES,1,YES,NO,NO,NO,YES ID12367,58,MALE,TOWN,33229,NO,0,YES,YES,YES,NO,YES ID12368,48,FEMALE,SUBURBAN,30396.1,NO,0,NO,YES,YES,NO,YES ID12369,63,FEMALE,TOWN,34625.2,YES,0,YES,NO,YES,NO,NO ID12370,20,MALE,TOWN,16672.8,NO,3,YES,NO,YES,YES,NO ID12371,67,FEMALE,SUBURBAN,60747.5,NO,2,NO,YES,YES,YES,YES ID12372,62,FEMALE,INNER_CITY,56394.3,NO,0,YES,YES,YES,NO,YES ID12373,36,MALE,TOWN,13236.4,YES,0,NO,YES,YES,NO,NO ID12374,31,MALE,INNER_CITY,28409.4,YES,1,YES,NO,YES,NO,YES ID12375,42,FEMALE,INNER_CITY,27056.5,YES,0,YES,YES,YES,NO,NO ID12376,18,MALE,RURAL,9362.58,YES,0,YES,NO,YES,YES,YES ID12377,46,FEMALE,SUBURBAN,28702.7,NO,1,NO,YES,YES,YES,YES ID12378,25,MALE,TOWN,22366.1,YES,1,YES,YES,YES,NO,YES ID12379,65,FEMALE,RURAL,24477.5,NO,0,NO,YES,NO,YES,NO ID12380,40,MALE,TOWN,36972.4,YES,1,NO,NO,YES,YES,YES ID12381,32,MALE,INNER_CITY,22327.8,YES,1,NO,NO,NO,NO,YES ID12382,18,FEMALE,INNER_CITY,15610.2,YES,0,NO,YES,YES,NO,NO ID12383,64,MALE,INNER_CITY,54314.5,YES,1,YES,YES,NO,NO,YES ID12384,43,FEMALE,INNER_CITY,39175.8,YES,3,NO,YES,YES,YES,NO ID12385,22,FEMALE,INNER_CITY,13739,YES,3,NO,YES,YES,NO,NO ID12386,25,MALE,TOWN,9485.84,YES,0,NO,NO,NO,NO,NO ID12387,39,MALE,INNER_CITY,24675.7,YES,1,YES,YES,YES,YES,YES ID12388,58,FEMALE,INNER_CITY,28253.6,YES,3,NO,NO,YES,NO,NO ID12389,33,MALE,INNER_CITY,14136.5,YES,1,NO,YES,NO,NO,NO ID12390,52,FEMALE,RURAL,37162.1,YES,1,YES,YES,YES,NO,YES ID12391,23,MALE,INNER_CITY,13519.2,NO,0,NO,YES,YES,NO,YES ID12392,44,FEMALE,INNER_CITY,39253.6,NO,0,YES,YES,NO,NO,YES ID12393,51,MALE,RURAL,46323.8,YES,2,YES,YES,YES,YES,YES ID12394,26,FEMALE,TOWN,20950.7,YES,0,NO,YES,YES,NO,NO ID12395,42,MALE,TOWN,22495.7,YES,0,NO,YES,NO,YES,NO ID12396,34,MALE,TOWN,32548.9,YES,0,YES,YES,YES,YES,NO ID12397,54,FEMALE,RURAL,24583.4,NO,2,YES,YES,YES,YES,NO ID12398,18,MALE,RURAL,8639.24,YES,2,NO,NO,NO,NO,NO ID12399,47,FEMALE,INNER_CITY,17139.5,NO,2,YES,NO,YES,NO,NO ID12400,24,FEMALE,INNER_CITY,13667.7,YES,0,NO,YES,YES,NO,NO ID12401,19,FEMALE,INNER_CITY,8162.42,YES,1,YES,YES,YES,YES,NO ID12402,37,FEMALE,TOWN,15349.6,YES,0,NO,YES,NO,NO,NO ID12403,45,FEMALE,TOWN,29231.4,YES,0,NO,YES,NO,NO,NO ID12404,49,MALE,RURAL,41462.3,YES,3,NO,YES,YES,YES,NO ID12405,67,FEMALE,RURAL,57398.1,NO,3,NO,YES,YES,NO,YES ID12406,35,FEMALE,RURAL,11520.8,YES,0,NO,NO,YES,NO,NO ID12407,63,MALE,INNER_CITY,52117.3,NO,2,YES,YES,YES,NO,YES ID12408,38,MALE,RURAL,26281.4,NO,0,YES,YES,YES,NO,YES ID12409,48,MALE,TOWN,25683.4,NO,2,YES,YES,YES,NO,NO ID12410,28,FEMALE,INNER_CITY,11920.7,NO,1,NO,YES,YES,NO,NO ID12411,46,MALE,TOWN,30658.7,YES,0,NO,YES,YES,NO,NO ID12412,66,MALE,INNER_CITY,36646.4,NO,1,NO,YES,YES,NO,YES ID12413,61,FEMALE,TOWN,30760.4,NO,2,YES,NO,YES,NO,YES ID12414,18,FEMALE,RURAL,16109.9,NO,2,YES,YES,YES,NO,NO ID12415,54,FEMALE,TOWN,18036.7,YES,0,YES,YES,NO,NO,NO ID12416,45,MALE,RURAL,42628.3,NO,0,YES,YES,YES,YES,NO ID12417,60,MALE,INNER_CITY,22110.1,NO,2,YES,YES,YES,NO,NO ID12418,45,FEMALE,TOWN,37689.1,NO,1,NO,YES,YES,YES,YES ID12419,31,FEMALE,INNER_CITY,23171.8,NO,2,NO,YES,NO,NO,NO ID12420,39,MALE,SUBURBAN,21951.3,NO,0,YES,YES,YES,YES,NO ID12421,53,MALE,INNER_CITY,38103.4,NO,2,YES,YES,YES,NO,YES ID12422,35,MALE,RURAL,22882.9,YES,0,YES,NO,NO,YES,YES ID12423,25,FEMALE,TOWN,11043.7,YES,1,YES,YES,NO,YES,NO ID12424,32,MALE,TOWN,24027.6,NO,0,NO,YES,YES,NO,YES ID12425,36,MALE,SUBURBAN,28495.1,YES,0,NO,YES,YES,NO,NO ID12426,24,FEMALE,TOWN,9465.21,NO,0,NO,NO,YES,NO,YES ID12427,39,MALE,INNER_CITY,34852.3,YES,1,NO,YES,NO,YES,YES ID12428,24,MALE,INNER_CITY,21268.4,YES,0,NO,NO,YES,YES,YES ID12429,57,FEMALE,RURAL,50849.2,NO,1,NO,YES,NO,YES,YES ID12430,27,FEMALE,TOWN,18555.9,YES,3,NO,NO,YES,NO,NO ID12431,66,FEMALE,RURAL,52769.9,YES,3,YES,YES,YES,NO,YES ID12432,18,FEMALE,INNER_CITY,11601.4,YES,2,NO,YES,YES,YES,NO ID12433,33,FEMALE,TOWN,29541.7,YES,0,NO,YES,NO,NO,NO ID12434,48,MALE,SUBURBAN,17861,YES,2,NO,YES,YES,NO,NO ID12435,23,FEMALE,SUBURBAN,21042,YES,1,NO,NO,YES,NO,YES ID12436,44,MALE,TOWN,26688.1,YES,1,NO,YES,NO,YES,YES ID12437,39,MALE,INNER_CITY,26900.6,YES,2,NO,NO,NO,YES,NO ID12438,65,MALE,INNER_CITY,38080.9,YES,1,YES,YES,NO,YES,NO ID12439,60,MALE,SUBURBAN,37554.1,YES,2,YES,YES,YES,YES,YES ID12440,20,MALE,INNER_CITY,18184.6,YES,0,NO,NO,YES,YES,YES ID12441,45,FEMALE,SUBURBAN,28864.9,YES,0,NO,YES,YES,NO,NO ID12442,66,MALE,RURAL,48346.1,YES,1,YES,YES,NO,NO,YES ID12443,64,MALE,INNER_CITY,53104.3,YES,0,YES,YES,YES,NO,NO ID12444,51,FEMALE,INNER_CITY,19416.8,YES,0,NO,YES,YES,NO,NO ID12445,34,MALE,RURAL,23638.1,YES,2,YES,YES,YES,NO,NO ID12446,65,FEMALE,TOWN,42378.2,YES,1,NO,YES,YES,NO,YES ID12447,50,MALE,RURAL,39745.3,YES,0,YES,YES,NO,YES,NO ID12448,66,FEMALE,INNER_CITY,45189.8,YES,0,NO,YES,NO,NO,NO ID12449,63,MALE,INNER_CITY,37930.9,YES,0,NO,YES,NO,YES,NO ID12450,53,FEMALE,INNER_CITY,24042,NO,1,NO,NO,YES,NO,YES ID12451,33,FEMALE,INNER_CITY,31207.1,NO,0,YES,NO,YES,YES,YES ID12452,38,MALE,TOWN,24424.3,YES,0,NO,YES,YES,YES,NO ID12453,56,FEMALE,RURAL,24607.8,NO,1,NO,YES,YES,YES,NO ID12454,48,MALE,TOWN,43057,NO,1,YES,YES,YES,NO,YES ID12455,49,FEMALE,SUBURBAN,30198.5,YES,0,YES,NO,YES,YES,YES ID12456,54,FEMALE,RURAL,50186.1,YES,2,NO,YES,YES,YES,YES ID12457,41,FEMALE,SUBURBAN,22916.1,YES,0,NO,NO,YES,NO,NO ID12458,19,MALE,RURAL,9592.73,NO,0,NO,YES,YES,NO,YES ID12459,52,FEMALE,INNER_CITY,34253.6,NO,3,YES,NO,YES,NO,NO ID12460,52,FEMALE,INNER_CITY,22792.3,YES,1,YES,YES,NO,NO,YES ID12461,64,FEMALE,TOWN,51620.8,NO,2,YES,YES,YES,NO,YES ID12462,56,MALE,TOWN,19918.9,YES,3,NO,YES,YES,YES,NO ID12463,56,MALE,TOWN,29625.1,YES,2,NO,NO,YES,NO,NO ID12464,19,FEMALE,TOWN,12549,YES,0,NO,YES,YES,NO,NO ID12465,56,FEMALE,TOWN,51299.3,YES,1,YES,YES,NO,NO,YES ID12466,27,MALE,INNER_CITY,17364.8,YES,2,YES,YES,NO,NO,YES ID12467,59,FEMALE,INNER_CITY,29866.9,NO,1,YES,NO,YES,NO,YES ID12468,56,MALE,INNER_CITY,47750.2,YES,0,YES,YES,YES,YES,NO ID12469,21,MALE,TOWN,11281.5,YES,0,NO,YES,YES,YES,NO ID12470,64,MALE,INNER_CITY,34073.8,YES,3,NO,YES,NO,YES,NO ID12471,62,MALE,INNER_CITY,46870.4,YES,0,NO,YES,YES,NO,NO ID12472,44,FEMALE,INNER_CITY,38453.7,NO,2,NO,YES,YES,NO,YES ID12473,24,FEMALE,INNER_CITY,7756.36,NO,0,NO,NO,NO,NO,YES ID12474,52,FEMALE,INNER_CITY,28413.8,YES,0,NO,NO,YES,NO,NO ID12475,67,FEMALE,SUBURBAN,47198.6,YES,2,NO,YES,YES,NO,YES ID12476,41,MALE,INNER_CITY,20866.3,YES,0,YES,YES,YES,NO,NO ID12477,58,FEMALE,TOWN,33204.3,NO,1,NO,NO,NO,YES,YES ID12478,40,MALE,INNER_CITY,24823.5,NO,2,NO,NO,YES,NO,NO ID12479,19,MALE,SUBURBAN,17986.8,YES,0,NO,NO,YES,YES,YES ID12480,20,FEMALE,INNER_CITY,9909.82,YES,3,NO,NO,YES,NO,NO ID12481,56,FEMALE,TOWN,26542.8,NO,0,YES,YES,YES,NO,YES ID12482,46,FEMALE,INNER_CITY,32583.5,YES,2,YES,YES,YES,NO,NO ID12483,30,MALE,INNER_CITY,14606.6,YES,1,NO,NO,YES,NO,NO ID12484,40,FEMALE,TOWN,34836.8,YES,1,YES,YES,YES,NO,YES ID12485,36,FEMALE,TOWN,26920.8,YES,0,NO,NO,YES,NO,NO ID12486,57,FEMALE,INNER_CITY,38248.3,NO,3,YES,NO,YES,YES,NO ID12487,49,MALE,INNER_CITY,15689.1,NO,0,NO,NO,YES,NO,NO ID12488,61,MALE,INNER_CITY,30157.7,NO,1,YES,NO,NO,NO,YES ID12489,29,MALE,INNER_CITY,14642.2,NO,0,YES,NO,YES,NO,YES ID12490,48,FEMALE,INNER_CITY,15933.3,YES,0,NO,YES,NO,NO,NO ID12491,56,FEMALE,INNER_CITY,44288.3,YES,0,NO,YES,YES,NO,NO ID12492,40,MALE,TOWN,22197.1,NO,0,YES,NO,YES,NO,YES ID12493,58,FEMALE,TOWN,38248.3,YES,3,YES,YES,NO,NO,NO ID12494,60,FEMALE,INNER_CITY,22053.2,YES,2,YES,YES,NO,YES,NO ID12495,58,FEMALE,SUBURBAN,25468.5,NO,0,YES,NO,NO,YES,YES ID12496,67,FEMALE,TOWN,23485.9,YES,3,YES,NO,NO,YES,NO ID12497,40,MALE,RURAL,25768.6,YES,0,YES,YES,NO,NO,NO ID12498,48,MALE,INNER_CITY,34182.2,YES,2,NO,YES,YES,NO,YES ID12499,64,FEMALE,INNER_CITY,57444.5,NO,1,NO,YES,YES,NO,YES ID12500,43,MALE,TOWN,38059.8,YES,0,YES,YES,NO,YES,NO ID12501,34,FEMALE,RURAL,19481.3,NO,0,NO,NO,YES,YES,YES ID12502,26,MALE,RURAL,19563.8,NO,3,YES,NO,NO,YES,NO ID12503,48,MALE,INNER_CITY,38598.4,YES,0,YES,NO,YES,NO,NO ID12504,35,MALE,INNER_CITY,20754.3,NO,0,NO,NO,NO,YES,YES ID12505,24,FEMALE,INNER_CITY,13864.6,YES,3,NO,YES,YES,NO,YES ID12506,47,MALE,SUBURBAN,36599,YES,3,YES,YES,YES,NO,YES ID12507,52,MALE,SUBURBAN,45856.1,NO,1,NO,YES,YES,NO,YES ID12508,31,MALE,SUBURBAN,22362.3,NO,0,NO,YES,YES,NO,YES ID12509,41,FEMALE,SUBURBAN,21984,YES,1,YES,NO,NO,NO,YES ID12510,23,MALE,SUBURBAN,11073,YES,2,NO,YES,NO,NO,NO ID12511,27,FEMALE,INNER_CITY,18158.5,NO,1,YES,NO,YES,YES,YES ID12512,22,MALE,INNER_CITY,7304.2,NO,0,YES,YES,YES,YES,NO ID12513,67,FEMALE,INNER_CITY,58092,NO,2,YES,YES,YES,NO,YES ID12514,26,FEMALE,INNER_CITY,16518.6,YES,0,YES,NO,YES,NO,YES ID12515,58,FEMALE,SUBURBAN,46461.5,YES,0,NO,YES,YES,NO,NO ID12516,27,MALE,RURAL,20058.7,YES,0,NO,YES,YES,YES,NO ID12517,36,MALE,INNER_CITY,12533.2,NO,1,NO,YES,NO,YES,NO ID12518,31,MALE,RURAL,22848.5,YES,1,YES,NO,NO,NO,YES ID12519,28,FEMALE,TOWN,25699.4,YES,2,YES,YES,NO,NO,YES ID12520,57,MALE,TOWN,21612.6,YES,0,NO,YES,YES,YES,NO ID12521,64,MALE,INNER_CITY,48950.9,YES,0,YES,YES,YES,YES,NO ID12522,49,MALE,INNER_CITY,41438,NO,1,NO,YES,NO,NO,YES ID12523,22,MALE,INNER_CITY,11411,YES,1,YES,NO,YES,NO,NO ID12524,58,FEMALE,INNER_CITY,43940.6,YES,0,YES,YES,YES,NO,NO ID12525,20,MALE,TOWN,17239.5,NO,1,YES,NO,YES,NO,YES ID12526,44,FEMALE,RURAL,30488.7,YES,0,NO,YES,YES,NO,NO ID12527,65,FEMALE,TOWN,29866.3,YES,3,NO,YES,NO,NO,NO ID12528,53,FEMALE,INNER_CITY,32184.4,YES,2,YES,NO,NO,NO,YES ID12529,34,FEMALE,INNER_CITY,17308.7,YES,1,YES,NO,YES,YES,YES ID12530,35,MALE,RURAL,27863.9,NO,2,NO,YES,YES,YES,NO ID12531,48,MALE,TOWN,28920.6,YES,0,NO,YES,NO,YES,NO ID12532,64,FEMALE,TOWN,58367.3,YES,1,YES,YES,YES,NO,YES ID12533,46,MALE,TOWN,16849.3,NO,0,YES,YES,YES,YES,NO ID12534,42,FEMALE,RURAL,28138.5,YES,0,NO,NO,YES,YES,YES ID12535,47,MALE,INNER_CITY,23038.2,YES,0,YES,YES,NO,NO,NO ID12536,23,MALE,TOWN,11736.9,NO,2,YES,YES,YES,YES,NO ID12537,35,MALE,INNER_CITY,16479.5,YES,0,YES,NO,NO,YES,YES ID12538,64,FEMALE,INNER_CITY,31415.7,NO,1,YES,YES,NO,YES,YES ID12539,18,FEMALE,SUBURBAN,12117.3,YES,1,NO,NO,YES,NO,NO ID12540,19,MALE,INNER_CITY,15417.1,YES,1,YES,NO,YES,NO,NO ID12541,40,MALE,INNER_CITY,29414.6,YES,1,NO,YES,NO,YES,YES ID12542,47,MALE,INNER_CITY,44682.1,YES,0,YES,YES,YES,NO,NO ID12543,43,FEMALE,RURAL,36281,YES,0,YES,YES,YES,NO,NO ID12544,38,MALE,TOWN,33302.8,NO,0,YES,NO,YES,YES,YES ID12545,21,FEMALE,RURAL,15797.1,YES,0,NO,YES,YES,NO,YES ID12546,40,MALE,RURAL,31864.8,YES,0,YES,YES,YES,NO,NO ID12547,52,FEMALE,TOWN,43719.5,YES,0,NO,YES,YES,NO,NO ID12548,35,FEMALE,TOWN,30799.5,YES,2,NO,NO,YES,NO,YES ID12549,53,MALE,RURAL,48971.6,YES,3,YES,YES,NO,NO,YES ID12550,38,FEMALE,RURAL,34061.4,NO,0,YES,YES,YES,NO,YES ID12551,42,MALE,INNER_CITY,28938.6,YES,3,YES,NO,NO,NO,NO ID12552,43,MALE,TOWN,38540,NO,0,YES,YES,NO,YES,NO ID12553,59,FEMALE,INNER_CITY,27045.1,NO,0,NO,NO,YES,NO,YES ID12554,59,FEMALE,RURAL,51284.3,NO,0,YES,YES,YES,YES,NO ID12555,24,MALE,INNER_CITY,16352.2,NO,0,NO,YES,YES,YES,NO ID12556,27,FEMALE,INNER_CITY,11866.4,YES,0,YES,YES,YES,NO,NO ID12557,32,FEMALE,TOWN,13267.6,YES,0,YES,YES,YES,YES,NO ID12558,65,FEMALE,INNER_CITY,61554.6,YES,0,NO,YES,YES,NO,NO ID12559,18,MALE,SUBURBAN,13700.2,NO,1,NO,YES,YES,NO,NO ID12560,66,MALE,TOWN,46963.9,YES,1,NO,YES,YES,NO,YES ID12561,41,MALE,INNER_CITY,23475.6,YES,0,YES,NO,YES,YES,YES ID12562,64,FEMALE,SUBURBAN,24554.1,YES,0,YES,YES,NO,YES,NO ID12563,23,FEMALE,INNER_CITY,18050,YES,0,YES,NO,YES,YES,YES ID12564,29,FEMALE,RURAL,15237.6,YES,2,YES,NO,YES,NO,NO ID12565,28,MALE,TOWN,20555,NO,0,YES,YES,YES,NO,YES ID12566,57,FEMALE,TOWN,28421.7,YES,2,YES,YES,YES,YES,NO ID12567,38,MALE,INNER_CITY,21876.5,YES,0,NO,NO,YES,NO,NO ID12568,34,FEMALE,SUBURBAN,12810.2,NO,3,NO,YES,YES,NO,YES ID12569,43,MALE,SUBURBAN,15109.4,YES,0,NO,NO,YES,NO,YES ID12570,63,MALE,TOWN,37414.7,NO,3,YES,YES,YES,NO,NO ID12571,62,FEMALE,INNER_CITY,41521.6,YES,0,NO,YES,YES,YES,NO ID12572,51,FEMALE,INNER_CITY,25372.8,YES,0,YES,YES,YES,NO,NO ID12573,61,MALE,INNER_CITY,21139.8,YES,2,YES,YES,NO,NO,NO ID12574,41,FEMALE,TOWN,27757.6,NO,0,NO,YES,YES,NO,YES ID12575,31,FEMALE,TOWN,22678.1,NO,1,YES,YES,YES,YES,YES ID12576,33,FEMALE,TOWN,12178.5,YES,2,NO,YES,YES,YES,NO ID12577,43,MALE,RURAL,26106.7,NO,1,NO,NO,YES,NO,YES ID12578,40,MALE,INNER_CITY,27417.6,YES,0,NO,YES,YES,YES,NO ID12579,47,MALE,TOWN,23337.2,YES,2,NO,YES,YES,YES,NO ID12580,46,MALE,TOWN,43395.5,NO,1,YES,YES,YES,NO,YES ID12581,30,MALE,RURAL,11536.2,YES,2,NO,NO,YES,YES,NO ID12582,47,MALE,INNER_CITY,44658.6,NO,2,YES,YES,YES,NO,YES ID12583,44,MALE,RURAL,32762.5,NO,0,NO,YES,YES,YES,NO ID12584,23,MALE,RURAL,16403.8,YES,0,YES,YES,NO,NO,NO ID12585,28,FEMALE,INNER_CITY,21184.7,YES,1,YES,YES,YES,NO,YES ID12586,64,FEMALE,INNER_CITY,49917.3,YES,0,YES,YES,YES,YES,NO ID12587,35,FEMALE,TOWN,21623.8,YES,0,NO,YES,NO,YES,NO ID12588,19,MALE,RURAL,16625.9,YES,1,NO,NO,YES,NO,YES ID12589,27,FEMALE,TOWN,14014.5,YES,3,NO,YES,NO,NO,NO ID12590,27,MALE,INNER_CITY,20409.3,YES,2,NO,YES,NO,NO,YES ID12591,58,FEMALE,INNER_CITY,31671.3,YES,1,YES,YES,NO,YES,YES ID12592,46,FEMALE,TOWN,17149.2,NO,1,YES,YES,YES,NO,YES ID12593,61,FEMALE,TOWN,27756.3,YES,0,YES,YES,NO,YES,YES ID12594,59,MALE,INNER_CITY,40949.9,NO,0,NO,YES,YES,NO,YES ID12595,47,FEMALE,RURAL,43743.2,YES,3,NO,YES,YES,NO,NO ID12596,44,MALE,INNER_CITY,38459.9,YES,0,NO,NO,NO,YES,YES ID12597,50,MALE,TOWN,40972.9,NO,2,YES,YES,YES,YES,YES ID12598,64,MALE,INNER_CITY,46587.9,NO,0,NO,YES,YES,NO,YES ID12599,51,FEMALE,TOWN,43799.6,NO,0,NO,YES,YES,YES,NO ID12600,46,FEMALE,TOWN,18912.2,YES,0,YES,NO,YES,NO,YES ID12601,39,FEMALE,INNER_CITY,27765.8,YES,3,YES,YES,NO,NO,NO ID12602,58,FEMALE,INNER_CITY,33007.3,NO,1,YES,NO,YES,NO,YES ID12603,32,FEMALE,TOWN,26325.3,YES,0,YES,NO,NO,NO,NO ID12604,22,FEMALE,INNER_CITY,15308.2,NO,0,YES,YES,YES,YES,NO ID12605,63,FEMALE,INNER_CITY,59805.6,YES,1,YES,YES,YES,NO,YES ID12606,35,FEMALE,TOWN,28658.3,YES,0,YES,YES,YES,NO,NO ID12607,59,FEMALE,INNER_CITY,23175,YES,0,NO,NO,NO,YES,YES ID12608,22,FEMALE,SUBURBAN,11595.4,NO,0,YES,YES,YES,NO,YES ID12609,60,MALE,SUBURBAN,50409.9,NO,2,NO,YES,YES,YES,YES ID12610,23,FEMALE,RURAL,11215.3,YES,2,YES,YES,YES,NO,YES ID12611,29,FEMALE,TOWN,13327.8,YES,0,NO,YES,NO,NO,NO ID12612,44,MALE,INNER_CITY,16088.8,YES,3,NO,YES,YES,NO,NO ID12613,63,FEMALE,TOWN,43943,YES,0,YES,YES,YES,YES,NO ID12614,25,FEMALE,RURAL,14505.3,NO,3,NO,YES,YES,NO,NO ID12615,37,MALE,INNER_CITY,33886.4,NO,0,YES,YES,NO,NO,YES ID12616,48,FEMALE,INNER_CITY,16662.5,YES,1,NO,YES,YES,NO,YES ID12617,35,FEMALE,TOWN,20262.6,NO,0,NO,YES,NO,NO,YES ID12618,51,MALE,TOWN,33615.4,YES,1,NO,YES,NO,YES,YES ID12619,27,FEMALE,TOWN,22007.1,NO,3,NO,NO,YES,NO,NO ID12620,56,FEMALE,INNER_CITY,28981.1,YES,3,YES,YES,YES,YES,NO ID12621,38,FEMALE,INNER_CITY,12163.9,YES,2,YES,NO,YES,NO,YES ID12622,36,FEMALE,TOWN,17247.7,YES,2,YES,YES,YES,NO,NO ID12623,27,MALE,SUBURBAN,12683.6,NO,3,NO,YES,YES,YES,NO ID12624,34,FEMALE,TOWN,16291,YES,0,YES,YES,NO,YES,NO ID12625,44,MALE,SUBURBAN,18707.3,YES,0,YES,YES,YES,YES,YES ID12626,43,FEMALE,INNER_CITY,19326.9,YES,1,NO,NO,YES,NO,YES ID12627,32,MALE,INNER_CITY,14511.8,NO,2,NO,YES,NO,YES,NO ID12628,21,FEMALE,TOWN,10672,NO,1,NO,YES,YES,YES,NO ID12629,30,FEMALE,INNER_CITY,25830.5,YES,2,NO,NO,YES,NO,NO ID12630,55,MALE,RURAL,43499.5,YES,1,YES,YES,YES,NO,NO ID12631,64,MALE,SUBURBAN,59175.1,YES,1,NO,YES,YES,NO,YES ID12632,36,FEMALE,INNER_CITY,27642.9,NO,1,YES,NO,NO,NO,YES ID12633,59,MALE,INNER_CITY,30067.5,NO,1,NO,YES,YES,NO,YES ID12634,60,MALE,INNER_CITY,29714.4,YES,0,YES,NO,YES,YES,YES ID12635,27,FEMALE,TOWN,13950.4,NO,1,YES,YES,YES,YES,NO ID12636,29,MALE,INNER_CITY,10072.6,YES,0,NO,NO,YES,NO,NO ID12637,53,FEMALE,INNER_CITY,37850.6,NO,1,NO,YES,YES,NO,YES ID12638,61,FEMALE,RURAL,57176.4,NO,2,NO,YES,YES,NO,YES ID12639,43,FEMALE,INNER_CITY,38784,YES,0,NO,YES,YES,NO,NO ID12640,19,MALE,INNER_CITY,10191.8,YES,0,NO,YES,YES,YES,YES ID12641,48,FEMALE,INNER_CITY,21821.4,YES,1,YES,YES,NO,YES,YES ID12642,39,MALE,RURAL,37389,YES,2,NO,YES,YES,NO,YES ID12643,32,MALE,INNER_CITY,14627.9,YES,2,YES,YES,YES,NO,NO ID12644,63,MALE,SUBURBAN,48770.5,YES,1,YES,YES,NO,YES,YES ID12645,46,MALE,RURAL,21096.2,YES,1,YES,YES,YES,NO,YES ID12646,40,MALE,INNER_CITY,36256.9,NO,0,NO,NO,YES,YES,YES ID12647,27,FEMALE,INNER_CITY,15281.8,NO,0,YES,NO,NO,YES,YES ID12648,22,MALE,SUBURBAN,9316.98,YES,2,YES,YES,YES,NO,NO ID12649,42,MALE,RURAL,20736.2,YES,1,YES,YES,YES,NO,YES ID12650,58,FEMALE,TOWN,52662.5,YES,1,YES,YES,YES,YES,YES ID12651,23,FEMALE,INNER_CITY,8020.19,YES,1,YES,NO,YES,NO,NO ID12652,58,MALE,SUBURBAN,32245.4,YES,3,NO,NO,NO,NO,NO ID12653,45,MALE,INNER_CITY,41107.2,YES,2,YES,YES,YES,NO,NO ID12654,49,FEMALE,SUBURBAN,39358.3,YES,0,YES,NO,NO,YES,NO ID12655,67,FEMALE,INNER_CITY,36095.9,YES,3,YES,YES,YES,NO,NO ID12656,20,FEMALE,TOWN,7723.93,YES,2,YES,YES,YES,NO,NO ID12657,43,FEMALE,RURAL,18565.8,YES,1,YES,YES,YES,YES,YES ID12658,41,MALE,RURAL,25132.9,YES,0,NO,NO,YES,NO,NO ID12659,38,FEMALE,SUBURBAN,31290.6,YES,0,NO,YES,YES,NO,NO ID12660,67,FEMALE,SUBURBAN,24858.4,YES,0,NO,NO,YES,YES,YES ID12661,40,MALE,INNER_CITY,16398.8,NO,1,NO,YES,YES,NO,YES ID12662,25,FEMALE,SUBURBAN,23287.9,NO,0,NO,NO,YES,YES,YES ID12663,57,FEMALE,RURAL,50897.6,YES,0,NO,YES,YES,NO,NO ID12664,32,FEMALE,INNER_CITY,22446.5,NO,1,NO,NO,YES,YES,YES ID12665,44,MALE,SUBURBAN,23092.1,YES,0,YES,NO,YES,YES,YES ID12666,30,MALE,TOWN,24867.6,YES,0,YES,YES,NO,NO,NO ID12667,43,MALE,TOWN,22234.7,YES,0,NO,NO,YES,YES,NO ID12668,19,FEMALE,INNER_CITY,17371.1,YES,2,YES,YES,YES,NO,NO ID12669,37,FEMALE,TOWN,29574,YES,0,YES,YES,YES,NO,NO ID12670,49,MALE,INNER_CITY,17944.2,NO,1,YES,YES,YES,YES,YES ID12671,49,FEMALE,RURAL,33665.5,NO,3,YES,NO,YES,NO,NO ID12672,40,MALE,INNER_CITY,36166.2,YES,0,NO,NO,NO,NO,NO ID12673,33,FEMALE,SUBURBAN,27712.9,NO,2,NO,YES,YES,NO,YES ID12674,39,MALE,TOWN,22400.7,YES,2,YES,YES,YES,NO,NO ID12675,43,FEMALE,INNER_CITY,28469.9,YES,0,YES,YES,YES,NO,NO ID12676,37,MALE,TOWN,30488,YES,0,NO,YES,YES,YES,NO ID12677,24,FEMALE,TOWN,19160.3,YES,1,YES,YES,YES,NO,YES ID12678,62,MALE,TOWN,45342.5,YES,0,YES,YES,NO,NO,YES ID12679,18,MALE,INNER_CITY,6294.21,NO,0,NO,YES,YES,YES,NO ID12680,47,FEMALE,TOWN,25127.7,YES,0,YES,NO,NO,NO,NO ID12681,63,MALE,SUBURBAN,51879.3,YES,2,YES,YES,NO,YES,YES ID12682,20,MALE,TOWN,12644.9,YES,2,YES,NO,YES,YES,NO ID12683,46,FEMALE,TOWN,21984.4,NO,3,NO,YES,NO,NO,NO ID12684,47,FEMALE,RURAL,29093.1,NO,2,YES,YES,YES,NO,NO ID12685,33,MALE,TOWN,23528.4,YES,1,NO,YES,YES,YES,YES ID12686,20,MALE,TOWN,9516.91,NO,3,YES,YES,YES,NO,NO ID12687,20,MALE,INNER_CITY,18364.9,YES,1,NO,NO,YES,NO,YES ID12688,43,FEMALE,TOWN,31273.8,NO,1,YES,YES,NO,NO,YES ID12689,58,MALE,RURAL,49673.6,YES,0,NO,YES,YES,NO,NO ID12690,29,MALE,SUBURBAN,12623.4,YES,1,YES,YES,YES,NO,NO ID12691,25,MALE,INNER_CITY,23818.6,YES,0,NO,NO,NO,NO,NO ID12692,40,FEMALE,INNER_CITY,31473.9,NO,2,NO,YES,YES,YES,YES ID12693,48,MALE,TOWN,20268,YES,0,NO,YES,YES,NO,NO ID12694,65,MALE,SUBURBAN,51417,YES,2,NO,YES,YES,NO,YES ID12695,59,FEMALE,RURAL,30971.8,YES,3,YES,YES,YES,YES,NO ID12696,61,FEMALE,INNER_CITY,47025,NO,2,YES,YES,YES,YES,NO ID12697,30,FEMALE,INNER_CITY,9672.25,YES,0,YES,YES,YES,NO,NO ID12698,31,FEMALE,TOWN,15976.3,YES,0,YES,YES,NO,NO,YES ID12699,29,MALE,INNER_CITY,14711.8,YES,0,NO,YES,NO,YES,NO ID12700,38,MALE,TOWN,26671.6,NO,0,YES,NO,YES,YES,YES

Bank Record.java

import java.io.BufferedReader; import java.io.File; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.IOException; import java.util.ArrayList; import java.util.Arrays; import java.util.List;

public class BankRecords extends Client { // static objects for IO processing static BankRecords robjs[] = new BankRecords[600]; // arraylist to hold spreadsheet rows & columns static ArrayList> array = new ArrayList<>();

// instance fields private String id; private int age; private String sex; protected String region; private double income; private String married; private int children; private String car; private String save_act; private String current_act; private String mortgage; private String pep;

// read data from file public void readData() { BufferedReader br; String line;

try { // initialize reader object and set file path to root of project br = new BufferedReader(new FileReader(new File("bank-Detail.csv")));

// read each record in csv file while ((line = br.readLine()) != null) {

array.add(Arrays.asList(line.split(","))); } }

catch (FileNotFoundException e) { System.out.println("File not found"); }

catch (IOException e) { e.printStackTrace(); } // System.out.println(array.get(0)); processData(); // call function for processing record data }

// process data public void processData() { // create index for array while iterating thru arraylist int index = 0;

for (List rowData : array) {

robjs[index] = new BankRecords(); // call setters and populate them, item by item robjs[index].setId(rowData.get(0)); robjs[index].setAge(Integer.parseInt(rowData.get(1))); robjs[index].setSex(rowData.get(2)); robjs[index].setRegion(rowData.get(3)); robjs[index].setIncome(Double.parseDouble(rowData.get(4))); robjs[index].setMarried(rowData.get(5)); robjs[index].setChildren(Integer.parseInt(rowData.get(6))); robjs[index].setCar(rowData.get(7)); robjs[index].setSave_act(rowData.get(8)); robjs[index].setCurrent_act(rowData.get(9)); robjs[index].setMortgage(rowData.get(10)); robjs[index].setPep(rowData.get(11)); index++;

} // calling function to print objects held in memory }

public String getId() { return id; }

public void setId(String id) { this.id = id; }

public int getAge() { return age; }

public void setAge(int age) { this.age = age; }

public String getSex() { return sex; }

public void setSex(String sex) { this.sex = sex; }

public String getRegion() { return region; }

public void setRegion(String region) { this.region = region; }

public double getIncome() { return income; }

public void setIncome(double income) { this.income = income; }

public String getMarried() { return married; }

public void setMarried(String married) { this.married = married; }

public int getChildren() { return children; }

public void setChildren(int children) { this.children = children; }

public String getCar() { return car; }

public void setCar(String car) { this.car = car; }

public String getSave_act() { return save_act; }

public void setSave_act(String save_act) { this.save_act = save_act; }

public String getCurrent_act() { return current_act; }

public void setCurrent_act(String current_act) { this.current_act = current_act; }

public String getMortgage() { return mortgage; }

public void setMortgage(String mortgage) { this.mortgage = mortgage; }

public String getPep() { return pep; }

public void setPep(String pep) { this.pep = pep; }

// main to run the application public static void main(String[] args) { BankRecords br = new BankRecords(); br.readData();

} }

Record.java

import java.io.IOException; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.io.FileWriter; import java.util.*;

public class Records extends BankRecords {

static FileWriter file = null;

public Records() { try { file = new FileWriter("BankRecords.txt"); } catch (IOException e) { e.printStackTrace(); } }

public static void main(String[] args) {

Records records = new Records(); records.readData(); // calling function to perform analytics femaleComparator();// analyze avg income maleComparator();// analyze avg income averageComparator();// analyze avg income

// closing file try { file.close(); } catch (IOException e) { e.printStackTrace(); } String timeStamp = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(Calendar.getInstance().getTime()); }

// method to find females with savings account and mortgage: public static void femaleComparator() {

Arrays.sort(robjs, new GenderComparator());

int femaleSum = 0;

for (int i = 0; i < robjs.length; i++) { if (robjs[i].getSex().equals("FEMALE") && robjs[i].getMortgage().equals("YES") && robjs[i].getSave_act().equals("YES")) { femaleSum++; } } // console: print results System.out.println("Data analytic results: " + " "); System.out.println(" Number of females with mortgage and saving account: " + femaleSum ); // write results to a file try {

file.write("Numbers of females with mortgage and saving account: " + femaleSum + " "); } catch (IOException e) { e.printStackTrace(); }

}

// method to find number of males with car and children living in different // areas: public static void maleComparator() {

Arrays.sort(robjs, new AverageComparator()); int rural = 0; int inner = 0; int town = 0; int suburbs = 0;

// males with car and children rural for (int i = 0; i < robjs.length; i++) { if (robjs[i].getSex().equals("MALE") && robjs[i].getRegion().equals("RURAL") && robjs[i].getCar().equals("YES") && robjs[i].getChildren() == 1) {

rural++; } } // console: print results System.out.println("Number of males living in rural region with car and children: " + rural);

// males with car and children inner city for (int i = 0; i < robjs.length; i++) { if (robjs[i].getSex().equals("MALE") && robjs[i].getRegion().equals("INNER_CITY") && robjs[i].getCar().equals("YES") && robjs[i].getChildren() == 1) {

inner++; } } // console: print results System.out.println(" Number of males living in inner city region with car and children: " + inner);

// males with car and children town for (int i = 0; i < robjs.length; i++) { if (robjs[i].getSex().equals("MALE") && robjs[i].getRegion().equals("TOWN") && robjs[i].getCar().equals("YES") && robjs[i].getChildren() == 1) {

town++; } } // console: print results System.out.println("Number of males living in town region with car and children: " + town);

// males with car and children suburbs for (int i = 0; i < robjs.length; i++) { if (robjs[i].getSex().equals("MALE") && robjs[i].getRegion().equals("SUBURBAN") && robjs[i].getCar().equals("YES") && robjs[i].getChildren() == 1) {

suburbs++; } } // console: print results System.out.println("Number of males living in suburban region with car and children: " + suburbs + " ");

// write results to a file try { file.write("Number of males living in rural region with a car and children: " + rural + " "); file.write("Number of males living in inner city region with a car and children: " + inner + " "); file.write("Number of males living in town region with a car and children: " + town + " "); file.write("Number of males living in suburban region with a car and children: " + suburbs + " "); } catch (IOException e) { e.printStackTrace(); } }

// method to find average income for females and males public static void averageComparator() { Arrays.sort(robjs, new GenderComparator()); Arrays.sort(robjs, new AverageComparator()); // formating output to 2 decimal places DecimalFormat df = new DecimalFormat("###.##");

double incomeFemale = 0, averageFemale = 0; double incomeMale = 0, averageMale = 0; int femaleCount = 0, maleCount = 0;

for (int i = 0; i < robjs.length; i++) {

if (robjs[i].getSex().equals("FEMALE")) {

incomeFemale += robjs[i].getIncome(); femaleCount++; } else { incomeMale += robjs[i].getIncome(); maleCount++; }

} // calculating average averageFemale = incomeFemale / femaleCount; averageMale = incomeMale / maleCount; System.out.println("The Average Income(Female VS Male):" + " "); System.out.println("The average income of female: " + df.format(averageFemale)); System.out.println("The average income of male: " + df.format(averageMale)); // write results to a file try { file.write("The average income of female: " + df.format(averageFemale) + " "); file.write("The average income of male: " + df.format(averageMale) + " ");

} catch (IOException e) { e.printStackTrace(); }

}

}

Client.java

public abstract class Client { //abstract methods inheritable for BankRecords class public abstract void readData();//read data public abstract void processData();//process data //public abstract void printData();//print data

}

=========================================================================================

Introduction:

For this lab you will continue using your current project folder created for labs 2 & 3 and create 3 new source files. Files are as follows:

File DbConnect: to allow an object to connect / close a database connection.

File Dao: where Dao stands for Data Access Object. This will allow for database connectivity and CRUD (Create Read Update Delete) like operations. Ref: for CRUD-> Tutorialspoint.

File LoanProcessing: acts as a driver file (i.e., includes main function) to call your database CRUD methods and create some resulting output.

To start working with a database you will need a JDBC driver to allow for any connectivity within your app.

To include a driver for your MySQL database, you need to create a folder called libs within your project. The MySQL driver for JDBC connections packages in the form of a jar file which you can download here:

You will find a JDBC driver for connecting to a MySQL database located here:

https://dev.mysql.com/downloads/connector/j/

Depending on your OS you will need to download a windows zip file or a tar file if you are a Mac/Linux user. Click the button given your choice, and you will be taken to a page to begin your download. Go to the bottom of the page and click on the

No thanks, just start my download link. Unzip or untar the downloaded file and locate the needed .jar file ( mysql-connector-java-5.1.46-bin.jar ) and copy it into into your libs folder.

Make sure to include the jar file in your Build Path by right clicking on your project folder and then choose Build Path > Configure Build Path....

Once the dialog box opens make sure to click on the Libraries tab then click

Add JARs

Drill down to the libs folder within your project and then choose the jar file to add.

Click OK to commit. Then click Apply and Close.

Code requirment

Include the following helper code for your 3 files. (note- if some assignment statements in the spec continue to wrap to another line, you may want to adjust your source editor to include the assignment onto one line).

DBConnect.java

DB_URL = "jdbc:mysql://www.papademas.net/411labs?autoReconnect=true&useSSL=false";

// Database credentials

USER = "db411", PASS = "411";

Dao.java

-Include the following class fields, constructor

//Declare DB objects

DBConnect conn = null;

Statement stmt = null;

// constructor

public Dao() { //create db object instance

conn = new DBConnect();

}

-Include a method to create a database table called createTable. createTable merely

creates a table when the method is called. Include the fields pid, id, income and pep

when building your table setup. A PRIMARY KEY which ensures record uniqueness is included for your build for the pid field which is shown below.

[ Note when creating a table, it is IMPERATIVE to include the following name:

yourFirstinitial_First4LettersOfYourLastName_tab ]

Notice carefully that comments are put in code as well the display of relevant information to the console. For future methods continue this way (note- see snapshot at the last page).

-Include a method to insert records called insertRecords().

Note for brevity purposes, future starter code will EXCLUDE try / catch blocks. Add in your own try / catch blocks were applicable.

-Include a method to retrieve records for display called retrieveRecords().

Methods breakdown

insertRecords(BankRecords [] arrayName) will allow for the array of BankRecord objects, to be passed to your method which will allow for the insertion of all the id, income and pep data from your BankRecords array (or whatever you named it) into your database table when called.

retrieveRecords() will return a ResultSet object used for creating output. The result set contains record data including your id, income and pep table fields.

*Code tweak: Make sure to sort the pep field in descending order to allow for premium loan candidates to appear first in the record set for reporting purposes (i.e., those with data values of YES). The resultset query string to build can be something like:

String sql =

"select id,income, pep from yourTableName_tab order by pep desc";

As a quick note: make sure to always close out of your connections and any statements when through with any processing!

Make sure to include error trapping using SQLException handling for all your database operations and connection logic.

Again, include messages to the console when your methods trigger. Ex. Table created, Inserting records into database, etc.

A super great resource to assist you with all your JDBC-CRUD operations for your methods can be found at this site: http://www.tutorialspoint.com/jdbc/, as well as the Chapter 23 PowerPoint from Gaddis. Remember though to phrase coding the best you can using your own object names, method naming and variable names, including coding syntax and even comments, if referencing any material from tutorialspoint so your lab work is unique.

Lastly code your LoanProcessing class file.

For your LoanProcessing source file make sure to extend BankRecords.

Include the following methods for your file.

Include in main() your readData() method call which will process your BankRecord objects. Then instantiate a Dao object and trigger your createTable() method, your insertRecords(your BankRecords array object) method and retrieveRecords() method in that order. Of course you can comment out your createTable / insertRecords once youve accomplished that to test how your output statements appear. Logic for that follows next.

Once you have retrieved a recordset, print out all the records from the recordset to the console in a nice columnar format included with heading names for id, income and pep. Doesnt hurt to have a title too, like Loan Analysis Report.