Business Analytics Lab Worksheet 04
CME Group Foundation Business Analytics Lab
Elio Vento
Summer, July 2017
About
R can be used to make basic visual analytics, which can be helpful in understanding the data holistically. Additionally, R can help find correlations between variables and create scatter plots.
In this lab we will delve deeper into the marketing data set with R visual analytics and use Tableau to visualize the credit risk data set.
Setup
Make sure to download the folder titled ‘bsad_lab04’ zip folder and extract the folder to unzip it. Next, we must set this folder as the working directory. The way to do this is to open R Studio, go to ‘Session’, scroll down to ‘Set Working Directory’, and click ‘To Source File Location’. Now, follow the directions to complete the lab.
Task 1
First, read in the creditrisk.csv file and make sure all the columns are captured and check the first couple of rows of the dataset “head(mydata)”
mydata = read.csv(file="data/states_purchase_orders.csv")
head(mydata)#Vendor State Data
vendorstate = mydata$VENDOR.STATE
vendorstate [1] LA LA LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA TX LA NJ LA LA LA LA LA VA VA VA VA
[30] PA PA PA , LA LA LA LA LA DC DC DC DC DC LA LA LA LA LA LA LA LA TX TX LA LA LA LA LA
[59] LA LA LA LA LA LA LA NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ
[88] NJ NJ NJ NJ NJ NJ NJ LA GA LA LA LA LA WI CA CA CA CA CA LA LA LA LA NY NY LA LA LA LA
[117] LA LA LA LA LA LA LA LA LA LA LA IL MI LA LA LA LA TX TX TX TX TX LA LA LA LA TX LA LA
[146] LA LA LA LA LA IL LA LA NJ NJ NJ NJ NJ NJ NJ NJ NJ NJ LA LA LA LA LA LA LA LA LA IA IA
[175] IA IA IA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA MS LA LA LA LA LA LA LA LA LA
[204] LA LA LA LA LA LA LA TX TX LA OH OH OH OH LA LA CA CA CA CA IA IA IA IA IA IA IA IA IA
[233] IA IA IA IA IA IA IA IA IA IA LA IA IA IA IA IA IA IA GA LA LA LA GA LA LA LA LA LA LA
[262] LA LA LA LA LA LA NJ NJ LA CA LA LA LA LA LA LA LA LA LA TX LA LA LA LA IA IA IA IA IA
[291] IA IA IA IA IA IA IA LA LA LA LA TX TX TX CA CA DC TX TX TX TX TX TX LA TX TX TX TX TX
[320] TX TX LA LA LA LA LA LA LA LA LA LA LA LA LA LA TN TN KS TX TX TX TX FL TX TX TX TX TX
[349] TX CO IL IL TX TX TX TX TX TX TX TX TX TX LA LA LA LA LA LA LA LA LA OH OH OH OH LA LA
[378] LA LA LA LA NC LA LA LA WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI WI
[407] WI WI LA LA LA LA GA GA GA GA GA GA LA LA LA LA LA LA LA LA RI RI RI RI RI RI RI RI RI
[436] RI RI RI RI LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[465] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[494] LA LA LA LA LA LA LA LA LA LA LA MO LA LA IA IA LA LA LA WA LA CA LA LA LA LA LA LA TX
[523] TX LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA
[552] LA LA LA LA LA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA
[581] CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA CA
[610] CA CA CA CA CA CA CA CA LA CA CA CA CA LA FL LA NV LA OH LA LA MA MA MA TX TX LA LA TX
[639] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA LA LA LA LA LA
[668] LA LA LA LA LA LA LA LA LA CA LA LA LA LA LA LA LA LA LA LA LA LA LA TX NJ LA LA LA LA
[697] TX TX TX TX TX TX TX TX LA LA LA FL FL LA LA TX TX TX TX TX TX TX CA CA CA CA CA CA CA
[726] CA CA CA CA CA CA LA LA LA , , , NJ LA LA LA LA LA LA LA LA LA LA LA LA GA GA GA PA
[755] PA PA PA PA CA CA CA CA CA TX TX LA LA LA LA LA LA GA GA LA KY LA LA LA LA LA LA LA LA
[784] LA LA LA MO LA LA LA LA LA LA LA LA LA LA LA CA LA LA LA LA CT LA LA LA LA LA LA LA LA
[813] LA LA LA LA LA LA LA LA LA LA LA LA LA NY NY FL FL FL LA LA LA LA LA LA LA LA VA VA VA
[842] VA VA VA VA VA VA VA VA VA VA VA VA VA VA VA VA LA LA LA LA LA LA LA LA LA LA LA LA LA
[871] LA LA LA LA LA LA LA LA LA LA LA OH LA LA LA LA LA NJ NJ LA LA LA LA LA LA LA LA LA LA
[900] LA LA LA AZ LA LA LA LA FL LA LA LA LA LA LA LA LA LA LA LA LA MN LA LA LA LA LA LA LA
[929] LA LA LA LA LA LA LA LA LA LA LA LA LA LA VA VA VA VA VA CA CA CA CA CA TX TX TX TX LA
[958] LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA LA DC LA NJ NJ NJ NJ NJ NJ NJ NJ LA
[987] TX LA LA LA LA LA LA PA PA LA LA CA CA LA
[ reached getOption("max.print") -- omitted 31452 entries ]
49 Levels: , AL AR AZ CA CD CO CT DC FL GA IA ID IL IN KS KY LA MA MD ME MI MN MO MS ... WV#Department Name Data
departmentname = mydata$DEPARTMENT.NAME
departmentname [1] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[3] ROAD REHABILITATION PROGRAM COMMUNITY DEVELOPMENT PROGRAMS
[5] ROAD REHABILITATION PROGRAM CONSTRUCTION PROJECTS
[7] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[9] CONSTRUCTION PROJECTS POLICE DEPARTMENT
[11] POLICE DEPARTMENT POLICE DEPARTMENT
[13] POLICE DEPARTMENT PARISH ATTORNEY
[15] DEPT OF FLEET MANAGEMENT ROAD REHABILITATION PROGRAM
[17] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[19] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[21] LIBRARY BOARD OF CONTROL OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
[23] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[25] DEPT OF FLEET MANAGEMENT POLICE DEPARTMENT
[27] POLICE DEPARTMENT POLICE DEPARTMENT
[29] POLICE DEPARTMENT DEPARTMENT OF PUBLIC WORKS
[31] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[33] DEPARTMENT OF PUBLIC WORKS DEPT OF FLEET MANAGEMENT
[35] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[37] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[39] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[41] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[43] EMERGENCY MEDICAL SERVICES CITY CONSTABLE
[45] CITY CONSTABLE CITY CONSTABLE
[47] CITY CONSTABLE POLICE DEPARTMENT
[49] POLICE DEPARTMENT POLICE DEPARTMENT
[51] POLICE DEPARTMENT DEPT OF TRANSPORTATION AND DRAINAGE
[53] DEPT OF TRANSPORTATION AND DRAINAGE POLICE DEPARTMENT
[55] POLICE DEPARTMENT POLICE DEPARTMENT
[57] POLICE DEPARTMENT POLICE DEPARTMENT
[59] POLICE DEPARTMENT POLICE DEPARTMENT
[61] POLICE DEPARTMENT POLICE DEPARTMENT
[63] POLICE DEPARTMENT POLICE DEPARTMENT
[65] POLICE DEPARTMENT HUMAN RESOURCES
[67] HUMAN RESOURCES HUMAN RESOURCES
[69] HUMAN RESOURCES HUMAN RESOURCES
[71] HUMAN RESOURCES HUMAN RESOURCES
[73] HUMAN RESOURCES HUMAN RESOURCES
[75] HUMAN RESOURCES HUMAN RESOURCES
[77] HUMAN RESOURCES HUMAN RESOURCES
[79] HUMAN RESOURCES HUMAN RESOURCES
[81] HUMAN RESOURCES HUMAN RESOURCES
[83] HUMAN RESOURCES HUMAN RESOURCES
[85] HUMAN RESOURCES HUMAN RESOURCES
[87] HUMAN RESOURCES HUMAN RESOURCES
[89] HUMAN RESOURCES HUMAN RESOURCES
[91] HUMAN RESOURCES HUMAN RESOURCES
[93] HUMAN RESOURCES HUMAN RESOURCES
[95] ROAD REHABILITATION PROGRAM GREATER BATON ROUGE AIRPORT DISTRICT
[97] POLICE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[99] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[101] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[103] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[105] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[107] POLICE DEPARTMENT DEPT OF MAINTENANCE
[109] CONSTRUCTION PROJECTS ROAD REHABILITATION PROGRAM
[111] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[113] DEPT OF MAINTENANCE POLICE DEPARTMENT
[115] POLICE DEPARTMENT POLICE DEPARTMENT
[117] POLICE DEPARTMENT POLICE DEPARTMENT
[119] POLICE DEPARTMENT POLICE DEPARTMENT
[121] POLICE DEPARTMENT POLICE DEPARTMENT
[123] POLICE DEPARTMENT POLICE DEPARTMENT
[125] POLICE DEPARTMENT POLICE DEPARTMENT
[127] POLICE DEPARTMENT POLICE DEPARTMENT
[129] INFORMATION SERVICES INFORMATION SERVICES
[131] INFORMATION SERVICES INFORMATION SERVICES
[133] DEPT OF TRANSPORTATION AND DRAINAGE FINANCE DEPARTMENT
[135] FINANCE DEPARTMENT FINANCE DEPARTMENT
[137] FINANCE DEPARTMENT FINANCE DEPARTMENT
[139] COUNCIL ADMINISTRATOR FINANCE DEPARTMENT
[141] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[143] FINANCE DEPARTMENT DEPT OF MAINTENANCE
[145] DEPT OF MAINTENANCE DEPARTMENT OF PUBLIC WORKS
[147] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[149] OFFICE OF THE MAYOR-PRESIDENT POLICE DEPARTMENT
[151] GREATER BATON ROUGE AIRPORT DISTRICT HUMAN DEVELOPMENT AND SERVICES
[153] HUMAN DEVELOPMENT AND SERVICES POLICE DEPARTMENT
[155] POLICE DEPARTMENT POLICE DEPARTMENT
[157] POLICE DEPARTMENT POLICE DEPARTMENT
[159] POLICE DEPARTMENT POLICE DEPARTMENT
[161] POLICE DEPARTMENT POLICE DEPARTMENT
[163] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[165] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[167] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[169] DEPARTMENT OF PUBLIC WORKS FINANCE DEPARTMENT
[171] FINANCE DEPARTMENT FINANCE DEPARTMENT
[173] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[175] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[177] DEPT OF MAINTENANCE DISTRICT COURT
[179] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[181] FIRE DEPARTMENT LIBRARY BOARD OF CONTROL
[183] LIBRARY BOARD OF CONTROL DEPT OF BUILDINGS AND GROUNDS
[185] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[187] DEPT OF FLEET MANAGEMENT DEPARTMENT OF PUBLIC WORKS
[189] DEPARTMENT OF PUBLIC WORKS COMMUNITY DEVELOPMENT PROGRAMS
[191] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[193] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[195] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[197] COMMUNITY DEVELOPMENT PROGRAMS EMERGENCY MEDICAL SERVICES
[199] EMERGENCY MEDICAL SERVICES DEPARTMENT OF PUBLIC WORKS
[201] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[203] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[205] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[207] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[209] MOSQUITO & RODENT CONTROL HUMAN DEVELOPMENT AND SERVICES
[211] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[213] HUMAN DEVELOPMENT AND SERVICES LIBRARY BOARD OF CONTROL
[215] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[217] LIBRARY BOARD OF CONTROL CONSTRUCTION PROJECTS
[219] CONSTRUCTION PROJECTS CITY COURT
[221] CITY COURT CITY COURT
[223] CITY COURT DEPT OF MAINTENANCE
[225] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[227] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[229] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[231] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[233] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[235] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[237] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[239] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[241] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[243] PARISH ATTORNEY DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[245] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[247] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[249] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[251] LIBRARY BOARD OF CONTROL DEPT OF FLEET MANAGEMENT
[253] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[255] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[257] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[259] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[261] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[263] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[265] SHERIFF'S OFFICE SHERIFF'S OFFICE
[267] SHERIFF'S OFFICE EMERGENCY MEDICAL SERVICES
[269] EMERGENCY MEDICAL SERVICES CONSTRUCTION PROJECTS
[271] DEPARTMENT OF PUBLIC WORKS POLICE DEPARTMENT
[273] POLICE DEPARTMENT POLICE DEPARTMENT
[275] POLICE DEPARTMENT POLICE DEPARTMENT
[277] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[279] COUNCIL ADMINISTRATOR LIBRARY BOARD OF CONTROL
[281] EMERGENCY MEDICAL SERVICES DEPT OF FLEET MANAGEMENT
[283] DEPT OF FLEET MANAGEMENT COUNCIL ADMINISTRATOR
[285] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[287] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[289] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[291] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[293] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[295] DEPT OF MAINTENANCE DEPT OF MAINTENANCE
[297] DEPT OF MAINTENANCE DEPT OF BUILDINGS AND GROUNDS
[299] DEPARTMENT OF PUBLIC WORKS CITY COURT
[301] CITY COURT FINANCE DEPARTMENT
[303] FINANCE DEPARTMENT FINANCE DEPARTMENT
[305] POLICE DEPARTMENT POLICE DEPARTMENT
[307] OFFICE OF THE MAYOR-PRESIDENT METROPOLITAN COUNCIL
[309] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[311] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[313] METROPOLITAN COUNCIL OFFICE OF THE MAYOR-PRESIDENT
[315] LIBRARY BOARD OF CONTROL DEPT OF TRANSPORTATION AND DRAINAGE
[317] DEPT OF TRANSPORTATION AND DRAINAGE DEPT OF TRANSPORTATION AND DRAINAGE
[319] DEPT OF TRANSPORTATION AND DRAINAGE DEPARTMENT OF PUBLIC WORKS
[321] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[323] HUMAN DEVELOPMENT AND SERVICES DEPARTMENT OF PUBLIC WORKS
[325] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[327] LIBRARY BOARD OF CONTROL POLICE DEPARTMENT
[329] POLICE DEPARTMENT POLICE DEPARTMENT
[331] POLICE DEPARTMENT POLICE DEPARTMENT
[333] DOWNTOWN DEVELOPMENT DISTRICT HUMAN DEVELOPMENT AND SERVICES
[335] HUMAN DEVELOPMENT AND SERVICES EMERGENCY MEDICAL SERVICES
[337] EMERGENCY MEDICAL SERVICES INFORMATION SERVICES
[339] ANIMAL CONTROL CENTER ANIMAL CONTROL CENTER
[341] ANIMAL CONTROL CENTER ANIMAL CONTROL CENTER
[343] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[345] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[347] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[349] HUMAN DEVELOPMENT AND SERVICES CITY COURT
[351] INFORMATION SERVICES INFORMATION SERVICES
[353] POLICE DEPARTMENT POLICE DEPARTMENT
[355] POLICE DEPARTMENT POLICE DEPARTMENT
[357] POLICE DEPARTMENT POLICE DEPARTMENT
[359] POLICE DEPARTMENT POLICE DEPARTMENT
[361] POLICE DEPARTMENT POLICE DEPARTMENT
[363] POLICE DEPARTMENT POLICE DEPARTMENT
[365] DEPARTMENT OF PUBLIC WORKS POLICE DEPARTMENT
[367] DEPT OF MAINTENANCE CONSTRUCTION PROJECTS
[369] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[371] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[373] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[375] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[377] INFORMATION SERVICES GREATER BATON ROUGE AIRPORT DISTRICT
[379] GREATER BATON ROUGE AIRPORT DISTRICT EMERGENCY MEDICAL SERVICES
[381] EMERGENCY MEDICAL SERVICES BATON ROUGE RIVER CENTER
[383] HUMAN DEVELOPMENT AND SERVICES DEPT OF BUILDINGS AND GROUNDS
[385] HUMAN DEVELOPMENT AND SERVICES DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[387] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[389] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[391] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[393] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[395] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[397] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[399] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[401] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[403] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[405] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[407] DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[409] POLICE DEPARTMENT POLICE DEPARTMENT
[411] POLICE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[413] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[415] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[417] EMERGENCY MEDICAL SERVICES EMERGENCY MEDICAL SERVICES
[419] COMMUNITY DEVELOPMENT PROGRAMS OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
[421] OFC. OF HOMELAND SECURITY & EMERGENCY PREPA COMMUNITY DEVELOPMENT PROGRAMS
[423] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[425] COMMUNITY DEVELOPMENT PROGRAMS DEPT OF TRANSPORTATION AND DRAINAGE
[427] POLICE DEPARTMENT POLICE DEPARTMENT
[429] POLICE DEPARTMENT POLICE DEPARTMENT
[431] POLICE DEPARTMENT POLICE DEPARTMENT
[433] POLICE DEPARTMENT POLICE DEPARTMENT
[435] POLICE DEPARTMENT POLICE DEPARTMENT
[437] POLICE DEPARTMENT POLICE DEPARTMENT
[439] POLICE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[441] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[443] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[445] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[447] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[449] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[451] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[453] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[455] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[457] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[459] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[461] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[463] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[465] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[467] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[469] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[471] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[473] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[475] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[477] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[479] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[481] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[483] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[485] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[487] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[489] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[491] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[493] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[495] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[497] HUMAN DEVELOPMENT AND SERVICES POLICE DEPARTMENT
[499] POLICE DEPARTMENT POLICE DEPARTMENT
[501] POLICE DEPARTMENT POLICE DEPARTMENT
[503] POLICE DEPARTMENT POLICE DEPARTMENT
[505] DEPT OF TRANSPORTATION AND DRAINAGE DEPT OF FLEET MANAGEMENT
[507] DEPT OF BUILDINGS AND GROUNDS HUMAN DEVELOPMENT AND SERVICES
[509] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[511] INFORMATION SERVICES INFORMATION SERVICES
[513] INFORMATION SERVICES EMERGENCY MEDICAL SERVICES
[515] INFORMATION SERVICES INFORMATION SERVICES
[517] GREATER BATON ROUGE AIRPORT DISTRICT INFORMATION SERVICES
[519] INFORMATION SERVICES INFORMATION SERVICES
[521] INFORMATION SERVICES GREATER BATON ROUGE AIRPORT DISTRICT
[523] POLICE DEPARTMENT POLICE DEPARTMENT
[525] POLICE DEPARTMENT POLICE DEPARTMENT
[527] POLICE DEPARTMENT POLICE DEPARTMENT
[529] CONSTRUCTION PROJECTS ROAD REHABILITATION PROGRAM
[531] FIRE DEPARTMENT FIRE DEPARTMENT
[533] FIRE DEPARTMENT FIRE DEPARTMENT
[535] FIRE DEPARTMENT FIRE DEPARTMENT
[537] FIRE DEPARTMENT FIRE DEPARTMENT
[539] FIRE DEPARTMENT FIRE DEPARTMENT
[541] FIRE DEPARTMENT FIRE DEPARTMENT
[543] FIRE DEPARTMENT FIRE DEPARTMENT
[545] FIRE DEPARTMENT FIRE DEPARTMENT
[547] FIRE DEPARTMENT FIRE DEPARTMENT
[549] FIRE DEPARTMENT FIRE DEPARTMENT
[551] FIRE DEPARTMENT FIRE DEPARTMENT
[553] FIRE DEPARTMENT FIRE DEPARTMENT
[555] FIRE DEPARTMENT FIRE DEPARTMENT
[557] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[559] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[561] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[563] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[565] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[567] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[569] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[571] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[573] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[575] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[577] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[579] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[581] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[583] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[585] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[587] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[589] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[591] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[593] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[595] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[597] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[599] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[601] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[603] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[605] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[607] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[609] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[611] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[613] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[615] BATON ROUGE RIVER CENTER BATON ROUGE RIVER CENTER
[617] BATON ROUGE RIVER CENTER DEPT OF FLEET MANAGEMENT
[619] FINANCE DEPARTMENT FINANCE DEPARTMENT
[621] FINANCE DEPARTMENT FINANCE DEPARTMENT
[623] COMMUNITY DEVELOPMENT PROGRAMS FINANCE DEPARTMENT
[625] CONSTRUCTION PROJECTS INFORMATION SERVICES
[627] DEPARTMENT OF PUBLIC WORKS LIBRARY BOARD OF CONTROL
[629] OFFICE OF THE MAYOR-PRESIDENT CONSTRUCTION PROJECTS
[631] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[633] LIBRARY BOARD OF CONTROL DEPARTMENT OF PUBLIC WORKS
[635] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[637] DEPARTMENT OF PUBLIC WORKS GREATER BATON ROUGE AIRPORT DISTRICT
[639] GREATER BATON ROUGE AIRPORT DISTRICT COMMUNITY DEVELOPMENT PROGRAMS
[641] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[643] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[645] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[647] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[649] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[651] COMMUNITY DEVELOPMENT PROGRAMS FINANCE DEPARTMENT
[653] FINANCE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[655] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[657] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[659] EMERGENCY MEDICAL SERVICES FINANCE DEPARTMENT
[661] FINANCE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[663] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[665] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[667] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[669] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[671] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[673] GREATER BATON ROUGE AIRPORT DISTRICT FINANCE DEPARTMENT
[675] FINANCE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[677] PARISH ATTORNEY HUMAN DEVELOPMENT AND SERVICES
[679] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[681] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[683] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[685] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[687] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[689] POLICE DEPARTMENT POLICE DEPARTMENT
[691] HUMAN DEVELOPMENT AND SERVICES INFORMATION SERVICES
[693] COMMUNITY DEVELOPMENT PROGRAMS EMERGENCY MEDICAL SERVICES
[695] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[697] HUMAN RESOURCES HUMAN RESOURCES
[699] HUMAN RESOURCES HUMAN RESOURCES
[701] HUMAN RESOURCES HUMAN RESOURCES
[703] HUMAN RESOURCES HUMAN RESOURCES
[705] POLICE DEPARTMENT POLICE DEPARTMENT
[707] POLICE DEPARTMENT LIBRARY BOARD OF CONTROL
[709] LIBRARY BOARD OF CONTROL OUTSIDE AGENCIES
[711] FINANCE DEPARTMENT HUMAN DEVELOPMENT AND SERVICES
[713] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[715] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[717] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[719] INFORMATION SERVICES INFORMATION SERVICES
[721] INFORMATION SERVICES INFORMATION SERVICES
[723] INFORMATION SERVICES INFORMATION SERVICES
[725] INFORMATION SERVICES INFORMATION SERVICES
[727] INFORMATION SERVICES INFORMATION SERVICES
[729] INFORMATION SERVICES INFORMATION SERVICES
[731] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[733] HUMAN DEVELOPMENT AND SERVICES HUMAN RESOURCES
[735] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[737] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[739] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[741] DEPARTMENT OF PUBLIC WORKS JUVENILE SERVICES
[743] CONSTRUCTION PROJECTS DEPT OF TRANSPORTATION AND DRAINAGE
[745] POLICE DEPARTMENT POLICE DEPARTMENT
[747] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[749] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[751] INFORMATION SERVICES INFORMATION SERVICES
[753] INFORMATION SERVICES DEPARTMENT OF PUBLIC WORKS
[755] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[757] DEPARTMENT OF PUBLIC WORKS DEPT OF FLEET MANAGEMENT
[759] INFORMATION SERVICES INFORMATION SERVICES
[761] INFORMATION SERVICES INFORMATION SERVICES
[763] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[765] HUMAN DEVELOPMENT AND SERVICES COMMUNITY DEVELOPMENT PROGRAMS
[767] COMMUNITY DEVELOPMENT PROGRAMS MOSQUITO & RODENT CONTROL
[769] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[771] HUMAN DEVELOPMENT AND SERVICES INFORMATION SERVICES
[773] INFORMATION SERVICES HUMAN DEVELOPMENT AND SERVICES
[775] COMMUNITY DEVELOPMENT PROGRAMS DEPARTMENT OF PUBLIC WORKS
[777] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[779] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[781] POLICE DEPARTMENT POLICE DEPARTMENT
[783] POLICE DEPARTMENT POLICE DEPARTMENT
[785] POLICE DEPARTMENT POLICE DEPARTMENT
[787] EMERGENCY MEDICAL SERVICES LIBRARY BOARD OF CONTROL
[789] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[791] LIBRARY BOARD OF CONTROL OFFICE OF THE MAYOR-PRESIDENT
[793] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[795] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[797] HUMAN DEVELOPMENT AND SERVICES PARISH ATTORNEY
[799] POLICE DEPARTMENT GREATER BATON ROUGE AIRPORT DISTRICT
[801] LIBRARY BOARD OF CONTROL HUMAN RESOURCES
[803] LIBRARY BOARD OF CONTROL DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[805] JUVENILE SERVICES DEPARTMENT OF PUBLIC WORKS
[807] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[809] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[811] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[813] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[815] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[817] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[819] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[821] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[823] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[825] DEPARTMENT OF PUBLIC WORKS DEPT OF TRANSPORTATION AND DRAINAGE
[827] DEPT OF TRANSPORTATION AND DRAINAGE POLICE DEPARTMENT
[829] POLICE DEPARTMENT POLICE DEPARTMENT
[831] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[833] METROPOLITAN COUNCIL METROPOLITAN COUNCIL
[835] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[837] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[839] INFORMATION SERVICES INFORMATION SERVICES
[841] INFORMATION SERVICES INFORMATION SERVICES
[843] INFORMATION SERVICES INFORMATION SERVICES
[845] INFORMATION SERVICES INFORMATION SERVICES
[847] INFORMATION SERVICES INFORMATION SERVICES
[849] INFORMATION SERVICES INFORMATION SERVICES
[851] INFORMATION SERVICES INFORMATION SERVICES
[853] INFORMATION SERVICES INFORMATION SERVICES
[855] INFORMATION SERVICES INFORMATION SERVICES
[857] INFORMATION SERVICES DEPARTMENT OF PUBLIC WORKS
[859] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[861] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[863] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[865] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[867] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[869] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[871] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[873] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[875] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[877] GREATER BATON ROUGE AIRPORT DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
[879] OFFICE OF THE MAYOR-PRESIDENT OFFICE OF THE MAYOR-PRESIDENT
[881] OFFICE OF THE MAYOR-PRESIDENT LIBRARY BOARD OF CONTROL
[883] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[885] DEPARTMENT OF PUBLIC WORKS DEPARTMENT OF PUBLIC WORKS
[887] LIBRARY BOARD OF CONTROL EMERGENCY MEDICAL SERVICES
[889] EMERGENCY MEDICAL SERVICES DEPT OF FLEET MANAGEMENT
[891] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[893] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[895] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[897] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[899] DEPT OF TRANSPORTATION AND DRAINAGE HUMAN DEVELOPMENT AND SERVICES
[901] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[903] DEPT OF BUILDINGS AND GROUNDS DEPARTMENT OF PUBLIC WORKS
[905] DEPARTMENT OF PUBLIC WORKS HUMAN DEVELOPMENT AND SERVICES
[907] MUNICIPAL FIRE & POLICE CIVIL SERVICE BOARD FINANCE DEPARTMENT
[909] JUVENILE SERVICES HUMAN DEVELOPMENT AND SERVICES
[911] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[913] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[915] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[917] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[919] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[921] ROAD REHABILITATION PROGRAM COMMUNITY DEVELOPMENT PROGRAMS
[923] DEPT OF BUILDINGS AND GROUNDS COMMUNITY DEVELOPMENT PROGRAMS
[925] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[927] COMMUNITY DEVELOPMENT PROGRAMS LIBRARY BOARD OF CONTROL
[929] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[931] COMMUNITY DEVELOPMENT PROGRAMS DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO
[933] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[935] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[937] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[939] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[941] COMMUNITY DEVELOPMENT PROGRAMS COMMUNITY DEVELOPMENT PROGRAMS
[943] CITY COURT CITY COURT
[945] CITY COURT CITY COURT
[947] CITY COURT COUNCIL ADMINISTRATOR
[949] COUNCIL ADMINISTRATOR COUNCIL ADMINISTRATOR
[951] COUNCIL ADMINISTRATOR COUNCIL ADMINISTRATOR
[953] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[955] DEPT OF FLEET MANAGEMENT DEPT OF FLEET MANAGEMENT
[957] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[959] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[961] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[963] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[965] DEPT OF FLEET MANAGEMENT CITY COURT
[967] POLICE DEPARTMENT POLICE DEPARTMENT
[969] POLICE DEPARTMENT OUTSIDE AGENCIES
[971] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[973] HUMAN DEVELOPMENT AND SERVICES HUMAN DEVELOPMENT AND SERVICES
[975] LIBRARY BOARD OF CONTROL LIBRARY BOARD OF CONTROL
[977] JUVENILE SERVICES OUTSIDE AGENCIES
[979] OUTSIDE AGENCIES DEPT OF DEVELOPMENT
[981] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[983] DEPT OF DEVELOPMENT DEPT OF DEVELOPMENT
[985] DEPT OF DEVELOPMENT JUVENILE SERVICES
[987] DEPARTMENT OF PUBLIC WORKS DEPT OF BUILDINGS AND GROUNDS
[989] DEPT OF DEVELOPMENT HUMAN DEVELOPMENT AND SERVICES
[991] CONSTRUCTION PROJECTS CONSTRUCTION PROJECTS
[993] CONSTRUCTION PROJECTS DEPARTMENT OF PUBLIC WORKS
[995] DEPARTMENT OF PUBLIC WORKS FIRE DEPARTMENT
[997] HUMAN RESOURCES EMERGENCY MEDICAL SERVICES
[999] EMERGENCY MEDICAL SERVICES DEPT OF BUILDINGS AND GROUNDS
[ reached getOption("max.print") -- omitted 31452 entries ]
45 Levels: ANIMAL CONTROL CENTER ... SHERIFF'S OFFICEFor CATEGORICAL variables it is useful to know the frequency of the different categories/levels of the variable. We can do that by using the table() function.
- Create a frequency table for the Loan Purpose and Job
# Command to create a frequency table: variable_table = table(variable)
# variable_table
vendorstate_table = table(vendorstate)
vendorstate_tablevendorstate
, AL AR AZ CA CD CO CT DC FL GA IA ID IL
2 62 400 125 189 877 1 114 99 69 418 555 1089 14 330
IN KS KY LA MA MD ME MI MN MO MS NC ND NE NH
180 76 100 20178 149 32 12 55 233 74 361 313 4 56 14
NJ NM NV NY OH OK OR PA RI SC SD TN TX UT VA
1633 3 12 210 180 9 27 401 15 41 6 152 2561 77 295
VT WA WI WV
3 60 583 3 departmentname_table = table(departmentname)
departmentname_tabledepartmentname
ANIMAL CONTROL CENTER BATON ROUGE CONVENTION & VISTORS COMMISSION
79 4
BATON ROUGE RIVER CENTER CITY CONSTABLE
134 115
CITY COURT COMMUNITY DEVELOPMENT PROGRAMS
1412 1674
CONSTRUCTION PROJECTS CORONER
2224 47
COUNCIL ADMINISTRATOR COUNCIL BUDGET OFFICE
182 84
DEPARTMENT OF PUBLIC WORKS DEPT OF BUILDINGS AND GROUNDS
5523 326
DEPT OF BUSINESS OPERATIONS AND CAPITAL PRO DEPT OF DEVELOPMENT
107 69
DEPT OF FLEET MANAGEMENT DEPT OF MAINTENANCE
325 220
DEPT OF TRANSPORTATION AND DRAINAGE DISTRICT COURT
200 20
DOWNTOWN DEVELOPMENT DISTRICT EMERGENCY MEDICAL SERVICES
182 1640
FINANCE DEPARTMENT FIRE DEPARTMENT
758 498
FIRE PROTECTION DISTRICT GREATER BATON ROUGE AIRPORT DISTRICT
217 1677
HUMAN DEVELOPMENT AND SERVICES HUMAN RESOURCES
2733 561
INFORMATION SERVICES JUVENILE COURT
1156 1
JUVENILE SERVICES LIBRARY BOARD OF CONTROL
376 2620
METROPOLITAN COUNCIL MOSQUITO & RODENT CONTROL
186 413
MUNICIPAL FIRE & POLICE CIVIL SERVICE BOARD OFC. OF HOMELAND SECURITY & EMERGENCY PREPA
11 472
OFFICE OF THE MAYOR-PRESIDENT OUTSIDE AGENCIES
386 161
PARISH ATTORNEY PLANNING COMMISSION
259 138
POLICE DEPARTMENT PUBLIC INFORMATION OFFICE
4066 94
PURCHASING REGISTRAR OF VOTERS
253 43
RETIREMENT OFFICE ROAD REHABILITATION PROGRAM
4 607
SHERIFF'S OFFICE
195 Now, we will visualize some of the veriables to observe some patterns and differences.
First create a bar chart of the loan purpose frequency table and job frequency table Remember to extract the sales variable before calling it.
VARIABLES: Job and Loan Purpose
# Plot a bar plot using the " barplot(variable) " command where variable is the extracted variable
barplot(vendorstate_table)
barplot(departmentname_table)
Next, create a histogram of loan purpose frequency table and job frequency table
# Plot a histogram using the " hist(variable) " command where variable is the extracted variable
hist(vendorstate_table)
hist(departmentname_table)
- What are some observable differences between the boxplot and the histogram? Please record your observations here.
A boxplot is best used for frequencies that are moderate in information while a histogram is used in showing the many different varities of frequencies.
Lastly, create a pie chart of Loan purpose frequency table. Plot only values greather than 10.
VARIABLE: Loan Purpose
# Plot a pie chart using:
# pie(variable) (command to make a pie chart)
vendorstatepie = pie(vendorstate_table)
vendorstatepieNULL# To get only values greather than N from a frequency table use:
# new_table = my_table[ my_table > N ] (command to select values greather than N)
new_table = vendorstatepie[vendorstatepie > 10]
new_tableNULLWhy is this visual not a good representation of the data? What makes the barplot a better representation?
This is not a good visual representation because there are no numeric values within the data. This creates problems when trying to analyze the data.
Task 2
Lets explore the Illinois Tax dataset (READ the “state_tax_illinois.csv” file) and create a scatterplot of corporate tax vs. personal income tax.
The dataset start in 1994 but we want to tax revenue since 2000 for the first quarter of the year “Q1”
VARIABLES: personal_income_tax and corporate_income_tax
mydata = read.csv(file="data/state_tax_illinois.csv")
head(mydata)# To change the way that R shows very large or small values we can use the following command:
options(scipen = 9999)
# read the dataset extract the year variable and order the dataset by year in decreasing order using the command:
# mydata = mydata[ order(year, decreasing = TRUE) , ] (! Order the data in decreasing order)
# From the ordered dataset Extract personal_income_tax variable
# From the ordered dataset Extract corporate_income_tax variable
# To change the way that R shows very large or small values we can use the following command:
options(scipen = 9999)
# read the dataset extract the year variable and order the dataset by year in decreasing order using the command:
year = mydata$year
year [1] 1994 1994 1994 1994 1995 1995 1995 1995 1996 1996 1996 1996 1997 1997 1997 1997
[17] 1998 1998 1998 1998 1999 1999 1999 1999 2000 2000 2000 2000 2001 2001 2001 2001
[33] 2002 2002 2002 2002 2003 2003 2003 2003 2004 2004 2004 2004 2005 2005 2005 2005
[49] 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009
[65] 2010 2010 2010 2010 2011 2011 2011 2011 2012 2012 2012 2012 2013 2013 2013 2013
[81] 2014 2014 2014 2014 2015 2015 2015 2015 2016 2016# mydata = mydata[ order(year, decreasing = TRUE) , ] (! Order the data in decreasing order)
mydata = mydata[ order(year, decreasing = TRUE) , ]
# From the ordered dataset Extract personal_income_tax variable
personalincometax = mydata$personal_income_tax
personalincometax [1] 3746068 3950197 3982255 4527933 3059415 3048487 4505921 4961971 3680480 3723148
[11] 4345335 5353786 3608644 3565618 4197619 4790521 3403778 3435763 3195378 4096206
[21] 3343258 3180912 2515231 2702995 2134865 2291055 2448000 2899039 2104226 2110793
[31] 2803540 3427232 2149834 1968785 2522527 3101128 2071646 2017821 2264920 2817633
[41] 1963943 1820838 2130841 2511261 1817907 1734644 1902394 2181615 1675372 1661305
[51] 1862628 2169229 1600339 1571274 1945837 2195228 1648066 1661059 1867375 2405920
[61] 1679520 1650800 2272950 2713373 1763852 1631196 1877350 1984974 1644788 1640535
[71] 1877350 1984974 1579539 1545132 1689205 1786043 1579539 1545132 1553374 1642423
[81] 1421240 1390281 1427336 1509160 1306955 1278486 1360884 1425714 1200911 1174752# From the ordered dataset Extract corporate_income_tax variable
corporateincometax = mydata$corporate_income_tax
corporateincometax [1] 903017 1163900 1055932 1425459 674725 625819 1105062 1508593 787764 785112
[11] 1028486 1764708 877978 948199 834075 1365912 778008 891425 632404 1160954
[21] 655115 639437 729180 971001 507167 504933 642923 1403105 459494 527011
[31] 790459 1225043 519552 439074 704820 1158924 537828 562274 591623 901551
[41] 556344 516272 557161 735924 438193 468903 431059 470507 324041 354688
[51] 362344 421964 222017 395572 362374 432374 261916 246964 583639 786706
[61] 274660 313983 792893 828315 433323 412970 473585 814038 476261 457064
[71] 473585 814038 370340 303603 435527 748621 370340 303603 391428 672820
[81] 340579 279205 357650 614760 306094 250934 281377 532591 279680 229280The previous task focused on visualizing one variable. A good way to visualize two variables would be a scatter plot or a correlation matrix.
# Plot personal_income_tax vs. corporate_income_tax
# personal_income_tax will be on the x-axis
# corporate_income_tax will be on the y-axis
plot(personalincometax,corporateincometax)
- Select only entries grather than year 1999
- After selecting entries greather than year 1999, select entries for quarter “Q1”
Naming Quarter
quarter = mydata$quarter
quarter [1] Q1 Q2 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
[27] Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2
[53] Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
[79] Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
Levels: Q1 Q2 Q3 Q4# To create a new_data filtering for an N NUMERIC value we can do the following
# new_data = mydata[ mydata$NUMERIC_VARIABLE > N, ]
new_data = mydata[mydata$year > 1999 , ]
# If we need to make another filter on a NON-NUMERIC we can do the following
# new_data = new_data[ new_data$CHAR_VARIABLE == "Q1", ]
new_data = new_data[new_data$quarter == "Q1" ,]
head(new_data)It might be easier to notice a trend if there was a line that fit through the points. So, lets repeat using the function ‘scatter.smooth’. This functions adds a smooth curve computed by loess, a method to locally smooth a curve.
scatter.smooth(personalincometax,corporateincometax)
Now, repeat below for total_tax_US vs. total_state, following the example that was just provided. Observe and note any trends in the scatter plots and potential relationships below. Do the same for all numeric variables.
# total_tax_US vs. total_state
totaltaxUS = mydata$total_tax_US
totaltaxUS [1] 222287206 271263780 218877926 277053403 212615988 217443823 207783584 258554691
[9] 204440284 212998203 207501165 260880904 195785584 201352044 188942321 236842680
[17] 185252300 195080471 181829622 228937671 178686442 184695636 165109821 205868100
[25] 170085231 179201087 159740520 201526713 160974777 165585529 181894597 240545336
[33] 180767288 170932192 176839082 228361858 176066516 177849972 168140829 216447550
[41] 171164001 172458009 156957207 196599615 162245445 165474617 141953121 169692044
[49] 147190204 153350871 131305076 152533357 138163664 140126145 129267848 149346624
[57] 129451673 131008319 137649419 164910108 127472720 126663650 133987401 162988584
[65] 126852612 128084166 119587068 145886283 118794468 122866643 115219000 140371196
[73] 111865625 114456862 108012557 126304908 106395324 107393718 102677692 119200042
[81] 100543930 102569374 93944974 109609563 94627837 94984540 91075715 104324554
[89] 90160343 91149689totalstate = mydata$total_state
totalstate [1] 9336875 10045643 9622256 10953294 8685450 8564364 10046029 11338476
[9] 9390536 9316965 9832505 11622644 9097693 9440340 9082749 10459078
[17] 8555361 8718812 7624965 9234900 8538565 8177370 7091648 7770695
[25] 7128096 6892476 6728486 8365087 6422330 6497882 7546742 8756653
[33] 6955768 6359947 7132023 8487980 6858279 6723925 6763926 8019376
[41] 6781697 6337485 6988957 7463948 6434580 6094696 6047406 6612900
[49] 6011795 5786577 5392903 6123292 5637669 5655878 5670224 6207903
[57] 5396931 5298567 5648355 6633372 5315230 5280986 6142447 7000901
[65] 5581641 5280512 4999164 5587108 5247786 5268964 4999164 5587107
[73] 4721429 4463584 4680894 5236808 4721429 4463584 4367395 4862738
[81] 4433669 4193211 4028215 4480566 4117755 3929430 3684023 4299796
[89] 3803301 3627632scatter.smooth(totaltaxUS,totalstate)
To quantify the data, its best to look at the correlation between two variables. What does this correlation explain?
Shhowing the relative information according to the data. .96 is very high which means it is very correlated.
Below, compute the correlation between every pair of variables (total_tax_US,total_state, personal_income_tax, corporate_income_tax, general_sales_tax, motor_fuel_tax ).
cor(totalstate,personalincometax)[1] 0.9652176Make sure to extract the variables first and then compute the correlation.
# To make a correlation table of all the NUMERIC variables you can select some columns or a range of columns, with the following command:
# corr01 = mydata[ c(3,4) ] (The command c(3,4,...) inside the brackets selects a given column )
# cor(corr01) (will give you the correlation table for variables in columns 3 and 4)
corr01 = mydata [c(3,4,5,6,7,8)]
cor(corr01) total_tax_US total_state personal_income_tax
total_tax_US 1.0000000 0.9621443 0.89216270
total_state 0.9621443 1.0000000 0.96521760
personal_income_tax 0.8921627 0.9652176 1.00000000
corporate_income_tax 0.8378959 0.8547191 0.87948231
general_sales_tax 0.8811287 0.8632035 0.73636583
motor_fuel_tax 0.2108519 0.1397864 -0.02182754
corporate_income_tax general_sales_tax motor_fuel_tax
total_tax_US 0.83789591 0.8811287 0.21085187
total_state 0.85471906 0.8632035 0.13978644
personal_income_tax 0.87948231 0.7363658 -0.02182754
corporate_income_tax 1.00000000 0.5503725 -0.05636253
general_sales_tax 0.55037249 1.0000000 0.36033009
motor_fuel_tax -0.05636253 0.3603301 1.00000000# corr02 = mydata[3:5] ( the command [3:5] selects a range of columns from 3 to 5)
# cor(corr02)
corr02 = mydata [3:8]
cor(corr02) total_tax_US total_state personal_income_tax
total_tax_US 1.0000000 0.9621443 0.89216270
total_state 0.9621443 1.0000000 0.96521760
personal_income_tax 0.8921627 0.9652176 1.00000000
corporate_income_tax 0.8378959 0.8547191 0.87948231
general_sales_tax 0.8811287 0.8632035 0.73636583
motor_fuel_tax 0.2108519 0.1397864 -0.02182754
corporate_income_tax general_sales_tax motor_fuel_tax
total_tax_US 0.83789591 0.8811287 0.21085187
total_state 0.85471906 0.8632035 0.13978644
personal_income_tax 0.87948231 0.7363658 -0.02182754
corporate_income_tax 1.00000000 0.5503725 -0.05636253
general_sales_tax 0.55037249 1.0000000 0.36033009
motor_fuel_tax -0.05636253 0.3603301 1.00000000Task 3 - TABLEAU
Follow the directions on the worksheet, download tableau academic on your personal computer or use one of the labs computers.
- Download Tablea academic here: https://www.tableau.com/academic/students
Refer to file ‘states_purchase_orders.csv’ in the data folder
Start Tableau and enter your LUC email if prompted.
Import the file into Tableau. Choose the Text File option when importing
- Under the dimensions tab located on the left side of the screen.
DOUBLE click on the ‘Department.Name’, then DOUBLE click on ‘Number of Records’ variable located on the bottom left of the screen. Note the bar like view and breakdowns.
- What department ‘bin’ has the highest count? What is the count?
- From the upper right corner of the screen select other views (select one of the other views, talk about it and post an screenshot)
# Change the image for your screenshots and MAKE COMMENTS
- Create a new sheet by clicking on the icon next to your current sheet.
Then DOUBLE click on ‘Number of Records’ variable then DOUBLE click on ‘Vendor.Zip’, then on the top left select the recommend view.
- What are the highlights on the map?
- Can you give an explanation of why there is a concentration on a particular region?
# Change the image for your screenshots and MAKE COMMENTS
LS0tCnRpdGxlOiAiQnVzaW5lc3MgQW5hbHl0aWNzIExhYiBXb3Jrc2hlZXQgMDQiCmF1dGhvcjogIkVsaW8gVmVudG8iCmRhdGU6ICJTdW1tZXIsIEp1bHkgMjAxNyIKb3V0cHV0OgogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQKICBodG1sX2RvY3VtZW50OiBkZWZhdWx0CiAgcGRmX2RvY3VtZW50OiBkZWZhdWx0CnN1YnRpdGxlOiBDTUUgR3JvdXAgRm91bmRhdGlvbiBCdXNpbmVzcyBBbmFseXRpY3MgTGFiCi0tLQoKIyMjIEFib3V0CgpSIGNhbiBiZSB1c2VkIHRvIG1ha2UgYmFzaWMgdmlzdWFsIGFuYWx5dGljcywgd2hpY2ggY2FuIGJlIGhlbHBmdWwgaW4gdW5kZXJzdGFuZGluZyB0aGUgZGF0YSBob2xpc3RpY2FsbHkuIEFkZGl0aW9uYWxseSwgUiBjYW4gaGVscCBmaW5kIGNvcnJlbGF0aW9ucyBiZXR3ZWVuIHZhcmlhYmxlcyBhbmQgY3JlYXRlIHNjYXR0ZXIgcGxvdHMuIAoKSW4gdGhpcyBsYWIgd2Ugd2lsbCBkZWx2ZSBkZWVwZXIgaW50byB0aGUgbWFya2V0aW5nIGRhdGEgc2V0IHdpdGggUiB2aXN1YWwgYW5hbHl0aWNzIGFuZCB1c2UgVGFibGVhdSB0byB2aXN1YWxpemUgdGhlIGNyZWRpdCByaXNrIGRhdGEgc2V0LiAKCiMjIyBTZXR1cAoKTWFrZSBzdXJlIHRvIGRvd25sb2FkIHRoZSBmb2xkZXIgdGl0bGVkICdic2FkX2xhYjA0JyB6aXAgZm9sZGVyIGFuZCBleHRyYWN0IHRoZSBmb2xkZXIgdG8gdW56aXAgaXQuIE5leHQsIHdlIG11c3Qgc2V0IHRoaXMgZm9sZGVyIGFzIHRoZSB3b3JraW5nIGRpcmVjdG9yeS4gVGhlIHdheSB0byBkbyB0aGlzIGlzIHRvIG9wZW4gUiBTdHVkaW8sIGdvIHRvICdTZXNzaW9uJywgc2Nyb2xsIGRvd24gdG8gJ1NldCBXb3JraW5nIERpcmVjdG9yeScsIGFuZCBjbGljayAnVG8gU291cmNlIEZpbGUgTG9jYXRpb24nLiBOb3csIGZvbGxvdyB0aGUgZGlyZWN0aW9ucyB0byBjb21wbGV0ZSB0aGUgbGFiLgoKLS0tLS0tLS0tLQoKIyMjIFRhc2sgMQoKRmlyc3QsIHJlYWQgaW4gdGhlIGBjcmVkaXRyaXNrLmNzdmAgZmlsZSBhbmQgbWFrZSBzdXJlIGFsbCB0aGUgY29sdW1ucyBhcmUgY2FwdHVyZWQgYW5kIGNoZWNrIHRoZSBmaXJzdCBjb3VwbGUgb2Ygcm93cyBvZiB0aGUgZGF0YXNldCAiaGVhZChteWRhdGEpIgoKYGBge3J9Cm15ZGF0YSA9IHJlYWQuY3N2KGZpbGU9ImRhdGEvc3RhdGVzX3B1cmNoYXNlX29yZGVycy5jc3YiKQpoZWFkKG15ZGF0YSkKYGBgCgpgYGB7cn0KI1ZlbmRvciBTdGF0ZSBEYXRhCnZlbmRvcnN0YXRlID0gbXlkYXRhJFZFTkRPUi5TVEFURQp2ZW5kb3JzdGF0ZQpgYGAKCmBgYHtyfQojRGVwYXJ0bWVudCBOYW1lIERhdGEKZGVwYXJ0bWVudG5hbWUgPSBteWRhdGEkREVQQVJUTUVOVC5OQU1FCmRlcGFydG1lbnRuYW1lCmBgYAoKCkZvciBDQVRFR09SSUNBTCB2YXJpYWJsZXMgaXQgaXMgdXNlZnVsIHRvIGtub3cgdGhlIGZyZXF1ZW5jeSBvZiB0aGUgZGlmZmVyZW50IGNhdGVnb3JpZXMvbGV2ZWxzIG9mIHRoZSB2YXJpYWJsZS4gV2UgY2FuIGRvIHRoYXQgYnkgdXNpbmcgdGhlIHRhYmxlKCkgZnVuY3Rpb24uIAoKKiBDcmVhdGUgYSBmcmVxdWVuY3kgdGFibGUgZm9yIHRoZSBMb2FuIFB1cnBvc2UgYW5kIEpvYgpgYGB7cn0KIyBDb21tYW5kIHRvIGNyZWF0ZSBhIGZyZXF1ZW5jeSB0YWJsZTogdmFyaWFibGVfdGFibGUgPSB0YWJsZSh2YXJpYWJsZSkgCiMgdmFyaWFibGVfdGFibGUKdmVuZG9yc3RhdGVfdGFibGUgPSB0YWJsZSh2ZW5kb3JzdGF0ZSkKdmVuZG9yc3RhdGVfdGFibGUKYGBgCgpgYGB7cn0KZGVwYXJ0bWVudG5hbWVfdGFibGUgPSB0YWJsZShkZXBhcnRtZW50bmFtZSkKZGVwYXJ0bWVudG5hbWVfdGFibGUKYGBgCgoKTm93LCB3ZSB3aWxsIHZpc3VhbGl6ZSBzb21lIG9mIHRoZSB2ZXJpYWJsZXMgdG8gb2JzZXJ2ZSBzb21lIHBhdHRlcm5zIGFuZCBkaWZmZXJlbmNlcy4gCgpGaXJzdCBjcmVhdGUgYSBiYXIgY2hhcnQgb2YgdGhlIGxvYW4gcHVycG9zZSBmcmVxdWVuY3kgdGFibGUgYW5kIGpvYiBmcmVxdWVuY3kgdGFibGUgUmVtZW1iZXIgdG8gZXh0cmFjdCB0aGUgc2FsZXMgdmFyaWFibGUgYmVmb3JlIGNhbGxpbmcgaXQuCgpWQVJJQUJMRVM6IEpvYiBhbmQgTG9hbiBQdXJwb3NlCgpgYGB7cn0KIyBQbG90IGEgYmFyIHBsb3QgdXNpbmcgdGhlICIgYmFycGxvdCh2YXJpYWJsZSkgIiBjb21tYW5kIHdoZXJlIHZhcmlhYmxlIGlzIHRoZSBleHRyYWN0ZWQgdmFyaWFibGUKYmFycGxvdCh2ZW5kb3JzdGF0ZV90YWJsZSkKYGBgCgpgYGB7cn0KYmFycGxvdChkZXBhcnRtZW50bmFtZV90YWJsZSkKYGBgCgoKTmV4dCwgY3JlYXRlIGEgaGlzdG9ncmFtIG9mIGxvYW4gcHVycG9zZSBmcmVxdWVuY3kgdGFibGUgYW5kIGpvYiBmcmVxdWVuY3kgdGFibGUKCmBgYHtyfQojIFBsb3QgYSBoaXN0b2dyYW0gdXNpbmcgdGhlICIgaGlzdCh2YXJpYWJsZSkgIiBjb21tYW5kIHdoZXJlIHZhcmlhYmxlIGlzIHRoZSBleHRyYWN0ZWQgdmFyaWFibGUKaGlzdCh2ZW5kb3JzdGF0ZV90YWJsZSkKYGBgCgpgYGB7cn0KaGlzdChkZXBhcnRtZW50bmFtZV90YWJsZSkKYGBgCgoKKiBXaGF0IGFyZSBzb21lIG9ic2VydmFibGUgZGlmZmVyZW5jZXMgYmV0d2VlbiB0aGUgYm94cGxvdCBhbmQgdGhlIGhpc3RvZ3JhbT8gUGxlYXNlIHJlY29yZCB5b3VyIG9ic2VydmF0aW9ucyBoZXJlLiAKCkEgYm94cGxvdCBpcyBiZXN0IHVzZWQgZm9yIGZyZXF1ZW5jaWVzIHRoYXQgYXJlIG1vZGVyYXRlIGluIGluZm9ybWF0aW9uIHdoaWxlIGEgaGlzdG9ncmFtIGlzIHVzZWQgaW4gc2hvd2luZyB0aGUgbWFueSBkaWZmZXJlbnQgdmFyaXRpZXMgb2YgZnJlcXVlbmNpZXMuCgpMYXN0bHksIGNyZWF0ZSBhIHBpZSBjaGFydCBvZiBMb2FuIHB1cnBvc2UgZnJlcXVlbmN5IHRhYmxlLiBQbG90IG9ubHkgdmFsdWVzIGdyZWF0aGVyIHRoYW4gMTAuCgpWQVJJQUJMRTogTG9hbiBQdXJwb3NlCmBgYHtyfQojIFBsb3QgYSBwaWUgY2hhcnQgdXNpbmc6CiMgcGllKHZhcmlhYmxlKSAgKGNvbW1hbmQgdG8gbWFrZSBhIHBpZSBjaGFydCkKdmVuZG9yc3RhdGVwaWUgPSBwaWUodmVuZG9yc3RhdGVfdGFibGUpCmBgYAoKYGBge3J9CnZlbmRvcnN0YXRlcGllCmBgYAoKCmBgYHtyfQojIFRvIGdldCBvbmx5IHZhbHVlcyBncmVhdGhlciB0aGFuIE4gZnJvbSBhIGZyZXF1ZW5jeSB0YWJsZSB1c2U6CiMgbmV3X3RhYmxlID0gbXlfdGFibGVbIG15X3RhYmxlID4gTiBdICAoY29tbWFuZCB0byBzZWxlY3QgdmFsdWVzIGdyZWF0aGVyIHRoYW4gTikKbmV3X3RhYmxlID0gdmVuZG9yc3RhdGVwaWVbdmVuZG9yc3RhdGVwaWUgPiAxMF0KbmV3X3RhYmxlCmBgYAoKCldoeSBpcyB0aGlzIHZpc3VhbCBub3QgYSBnb29kIHJlcHJlc2VudGF0aW9uIG9mIHRoZSBkYXRhPyBXaGF0IG1ha2VzIHRoZSBiYXJwbG90IGEgYmV0dGVyIHJlcHJlc2VudGF0aW9uPwoKVGhpcyBpcyBub3QgYSBnb29kIHZpc3VhbCByZXByZXNlbnRhdGlvbiBiZWNhdXNlIHRoZXJlIGFyZSBubyBudW1lcmljIHZhbHVlcyB3aXRoaW4gdGhlIGRhdGEuIFRoaXMgY3JlYXRlcyBwcm9ibGVtcyB3aGVuIHRyeWluZyB0byBhbmFseXplIHRoZSBkYXRhLiAKCgotLS0tLS0tLS0tCgojIyMgVGFzayAyCgpMZXRzIGV4cGxvcmUgdGhlIElsbGlub2lzIFRheCBkYXRhc2V0IChSRUFEIHRoZSAic3RhdGVfdGF4X2lsbGlub2lzLmNzdiIgZmlsZSkgYW5kIGNyZWF0ZSBhIHNjYXR0ZXJwbG90IG9mIGNvcnBvcmF0ZSB0YXggdnMuIHBlcnNvbmFsIGluY29tZSB0YXguICAKClRoZSBkYXRhc2V0IHN0YXJ0IGluIDE5OTQgYnV0IHdlIHdhbnQgdG8gdGF4IHJldmVudWUgc2luY2UgMjAwMCBmb3IgdGhlIGZpcnN0IHF1YXJ0ZXIgb2YgdGhlIHllYXIgIlExIgoKVkFSSUFCTEVTOiBwZXJzb25hbF9pbmNvbWVfdGF4IGFuZCBjb3Jwb3JhdGVfaW5jb21lX3RheAoKYGBge3J9Cm15ZGF0YSA9IHJlYWQuY3N2KGZpbGU9ImRhdGEvc3RhdGVfdGF4X2lsbGlub2lzLmNzdiIpCmhlYWQobXlkYXRhKQpgYGAKCgpgYGB7cn0KIyBUbyBjaGFuZ2UgdGhlIHdheSB0aGF0IFIgc2hvd3MgdmVyeSBsYXJnZSBvciBzbWFsbCB2YWx1ZXMgd2UgY2FuIHVzZSB0aGUgZm9sbG93aW5nIGNvbW1hbmQ6Cm9wdGlvbnMoc2NpcGVuID0gOTk5OSkKCiMgcmVhZCB0aGUgZGF0YXNldCBleHRyYWN0IHRoZSB5ZWFyIHZhcmlhYmxlIGFuZCBvcmRlciB0aGUgZGF0YXNldCBieSB5ZWFyIGluIGRlY3JlYXNpbmcgb3JkZXIgdXNpbmcgdGhlIGNvbW1hbmQ6CgojIG15ZGF0YSA9IG15ZGF0YVsgb3JkZXIoeWVhciwgZGVjcmVhc2luZyA9IFRSVUUpICwgXSAoISBPcmRlciB0aGUgZGF0YSBpbiBkZWNyZWFzaW5nIG9yZGVyKQoKIyBGcm9tIHRoZSBvcmRlcmVkIGRhdGFzZXQgRXh0cmFjdCBwZXJzb25hbF9pbmNvbWVfdGF4IHZhcmlhYmxlCgojIEZyb20gdGhlIG9yZGVyZWQgZGF0YXNldCBFeHRyYWN0IGNvcnBvcmF0ZV9pbmNvbWVfdGF4IHZhcmlhYmxlCgpgYGAKCgpgYGB7cn0KIyBUbyBjaGFuZ2UgdGhlIHdheSB0aGF0IFIgc2hvd3MgdmVyeSBsYXJnZSBvciBzbWFsbCB2YWx1ZXMgd2UgY2FuIHVzZSB0aGUgZm9sbG93aW5nIGNvbW1hbmQ6Cm9wdGlvbnMoc2NpcGVuID0gOTk5OSkKIyByZWFkIHRoZSBkYXRhc2V0IGV4dHJhY3QgdGhlIHllYXIgdmFyaWFibGUgYW5kIG9yZGVyIHRoZSBkYXRhc2V0IGJ5IHllYXIgaW4gZGVjcmVhc2luZyBvcmRlciB1c2luZyB0aGUgY29tbWFuZDoKeWVhciA9IG15ZGF0YSR5ZWFyCnllYXIKYGBgCgpgYGB7cn0KIyBteWRhdGEgPSBteWRhdGFbIG9yZGVyKHllYXIsIGRlY3JlYXNpbmcgPSBUUlVFKSAsIF0gKCEgT3JkZXIgdGhlIGRhdGEgaW4gZGVjcmVhc2luZyBvcmRlcikKbXlkYXRhID0gbXlkYXRhWyBvcmRlcih5ZWFyLCBkZWNyZWFzaW5nID0gVFJVRSkgLCBdCiMgRnJvbSB0aGUgb3JkZXJlZCBkYXRhc2V0IEV4dHJhY3QgcGVyc29uYWxfaW5jb21lX3RheCB2YXJpYWJsZQpwZXJzb25hbGluY29tZXRheCA9IG15ZGF0YSRwZXJzb25hbF9pbmNvbWVfdGF4CnBlcnNvbmFsaW5jb21ldGF4CmBgYAoKYGBge3J9CiMgRnJvbSB0aGUgb3JkZXJlZCBkYXRhc2V0IEV4dHJhY3QgY29ycG9yYXRlX2luY29tZV90YXggdmFyaWFibGUKY29ycG9yYXRlaW5jb21ldGF4ID0gbXlkYXRhJGNvcnBvcmF0ZV9pbmNvbWVfdGF4CmNvcnBvcmF0ZWluY29tZXRheApgYGAKCgpUaGUgcHJldmlvdXMgdGFzayBmb2N1c2VkIG9uIHZpc3VhbGl6aW5nIG9uZSB2YXJpYWJsZS4gQSBnb29kIHdheSB0byB2aXN1YWxpemUgdHdvIHZhcmlhYmxlcyB3b3VsZCBiZSBhIHNjYXR0ZXIgcGxvdCBvciBhIGNvcnJlbGF0aW9uIG1hdHJpeC4KCmBgYHtyfQojIFBsb3QgcGVyc29uYWxfaW5jb21lX3RheCB2cy4gY29ycG9yYXRlX2luY29tZV90YXggCiMgcGVyc29uYWxfaW5jb21lX3RheCB3aWxsIGJlIG9uIHRoZSB4LWF4aXMKIyBjb3Jwb3JhdGVfaW5jb21lX3RheCB3aWxsIGJlIG9uIHRoZSB5LWF4aXMKcGxvdChwZXJzb25hbGluY29tZXRheCxjb3Jwb3JhdGVpbmNvbWV0YXgpCgpgYGAKCiogU2VsZWN0IG9ubHkgZW50cmllcyBncmF0aGVyIHRoYW4geWVhciAxOTk5CiogQWZ0ZXIgc2VsZWN0aW5nIGVudHJpZXMgZ3JlYXRoZXIgdGhhbiB5ZWFyIDE5OTksIHNlbGVjdCBlbnRyaWVzIGZvciBxdWFydGVyICJRMSIKCk5hbWluZyBRdWFydGVyCgpgYGB7cn0KcXVhcnRlciA9IG15ZGF0YSRxdWFydGVyCnF1YXJ0ZXIKYGBgCgoKCmBgYHtyfQojIFRvIGNyZWF0ZSBhIG5ld19kYXRhIGZpbHRlcmluZyBmb3IgYW4gTiBOVU1FUklDIHZhbHVlIHdlIGNhbiBkbyB0aGUgZm9sbG93aW5nCiMgbmV3X2RhdGEgPSBteWRhdGFbIG15ZGF0YSROVU1FUklDX1ZBUklBQkxFID4gTiwgXQpuZXdfZGF0YSA9IG15ZGF0YVtteWRhdGEkeWVhciA+IDE5OTkgLCBdCiMgSWYgd2UgbmVlZCB0byBtYWtlIGFub3RoZXIgZmlsdGVyIG9uIGEgTk9OLU5VTUVSSUMgd2UgY2FuIGRvIHRoZSBmb2xsb3dpbmcKIyBuZXdfZGF0YSA9IG5ld19kYXRhWyBuZXdfZGF0YSRDSEFSX1ZBUklBQkxFID09ICJRMSIsIF0KbmV3X2RhdGEgPSBuZXdfZGF0YVtuZXdfZGF0YSRxdWFydGVyID09ICJRMSIgLF0KaGVhZChuZXdfZGF0YSkKYGBgCgpJdCBtaWdodCBiZSBlYXNpZXIgdG8gbm90aWNlIGEgdHJlbmQgaWYgdGhlcmUgd2FzIGEgbGluZSB0aGF0IGZpdCB0aHJvdWdoIHRoZSBwb2ludHMuIFNvLCBsZXRzIHJlcGVhdCB1c2luZyB0aGUgZnVuY3Rpb24gJ3NjYXR0ZXIuc21vb3RoJy4gVGhpcyBmdW5jdGlvbnMgYWRkcyBhIHNtb290aCBjdXJ2ZSBjb21wdXRlZCBieSBsb2VzcywgYSBtZXRob2QgdG8gbG9jYWxseSBzbW9vdGggYSBjdXJ2ZS4gCgpgYGB7cn0Kc2NhdHRlci5zbW9vdGgocGVyc29uYWxpbmNvbWV0YXgsY29ycG9yYXRlaW5jb21ldGF4KQpgYGAKCk5vdywgcmVwZWF0IGJlbG93IGZvciB0b3RhbF90YXhfVVMgdnMuIHRvdGFsX3N0YXRlLCBmb2xsb3dpbmcgdGhlIGV4YW1wbGUgdGhhdCB3YXMganVzdCBwcm92aWRlZC4gT2JzZXJ2ZSBhbmQgbm90ZSBhbnkgdHJlbmRzIGluIHRoZSBzY2F0dGVyIHBsb3RzIGFuZCBwb3RlbnRpYWwgcmVsYXRpb25zaGlwcyBiZWxvdy4gRG8gdGhlIHNhbWUgZm9yIGFsbCBudW1lcmljIHZhcmlhYmxlcy4KCmBgYHtyfQojIHRvdGFsX3RheF9VUyB2cy4gdG90YWxfc3RhdGUKdG90YWx0YXhVUyA9IG15ZGF0YSR0b3RhbF90YXhfVVMKdG90YWx0YXhVUwpgYGAKCgoKYGBge3J9CnRvdGFsc3RhdGUgPSBteWRhdGEkdG90YWxfc3RhdGUKdG90YWxzdGF0ZQpgYGAKCmBgYHtyfQpzY2F0dGVyLnNtb290aCh0b3RhbHRheFVTLHRvdGFsc3RhdGUpCmBgYAoKVG8gcXVhbnRpZnkgdGhlIGRhdGEsIGl0cyBiZXN0IHRvIGxvb2sgYXQgdGhlIGNvcnJlbGF0aW9uIGJldHdlZW4gdHdvIHZhcmlhYmxlcy4KV2hhdCBkb2VzIHRoaXMgY29ycmVsYXRpb24gZXhwbGFpbj8KClNoaG93aW5nIHRoZSByZWxhdGl2ZSBpbmZvcm1hdGlvbiBhY2NvcmRpbmcgdG8gdGhlIGRhdGEuIC45NiBpcyB2ZXJ5IGhpZ2ggd2hpY2ggbWVhbnMgaXQgaXMgdmVyeSBjb3JyZWxhdGVkLiAKCkJlbG93LCBjb21wdXRlIHRoZSBjb3JyZWxhdGlvbiBiZXR3ZWVuIGV2ZXJ5IHBhaXIgb2YgdmFyaWFibGVzICh0b3RhbF90YXhfVVMsdG90YWxfc3RhdGUsIHBlcnNvbmFsX2luY29tZV90YXgsIGNvcnBvcmF0ZV9pbmNvbWVfdGF4LCBnZW5lcmFsX3NhbGVzX3RheCwgbW90b3JfZnVlbF90YXggKS4gCgoKYGBge3J9CmNvcih0b3RhbHN0YXRlLHBlcnNvbmFsaW5jb21ldGF4KQpgYGAKCgoKTWFrZSBzdXJlIHRvIGV4dHJhY3QgdGhlIHZhcmlhYmxlcyBmaXJzdCBhbmQgdGhlbiBjb21wdXRlIHRoZSBjb3JyZWxhdGlvbi4gCgpgYGB7cn0KIyBUbyBtYWtlIGEgY29ycmVsYXRpb24gdGFibGUgb2YgYWxsIHRoZSBOVU1FUklDIHZhcmlhYmxlcyB5b3UgY2FuIHNlbGVjdCBzb21lIGNvbHVtbnMgb3IgYSByYW5nZSBvZiBjb2x1bW5zLCB3aXRoIHRoZSBmb2xsb3dpbmcgY29tbWFuZDoKIyBjb3JyMDEgPSBteWRhdGFbIGMoMyw0KSBdIChUaGUgY29tbWFuZCBjKDMsNCwuLi4pIGluc2lkZSB0aGUgYnJhY2tldHMgc2VsZWN0cyBhIGdpdmVuIGNvbHVtbiApCiMgY29yKGNvcnIwMSkgKHdpbGwgZ2l2ZSB5b3UgdGhlIGNvcnJlbGF0aW9uIHRhYmxlIGZvciB2YXJpYWJsZXMgaW4gY29sdW1ucyAzIGFuZCA0KQpjb3JyMDEgPSBteWRhdGEgW2MoMyw0LDUsNiw3LDgpXQpjb3IoY29ycjAxKQpgYGAKCmBgYHtyfQojIGNvcnIwMiA9IG15ZGF0YVszOjVdICggdGhlIGNvbW1hbmQgWzM6NV0gc2VsZWN0cyBhIHJhbmdlIG9mIGNvbHVtbnMgZnJvbSAzIHRvIDUpCiMgY29yKGNvcnIwMikKY29ycjAyID0gbXlkYXRhIFszOjhdCmNvcihjb3JyMDIpCmBgYAoKCgotLS0tLS0tLS0tCgojIyMgVGFzayAzIC0gVEFCTEVBVQoKRm9sbG93IHRoZSBkaXJlY3Rpb25zIG9uIHRoZSB3b3Jrc2hlZXQsIGRvd25sb2FkIHRhYmxlYXUgYWNhZGVtaWMgb24geW91ciBwZXJzb25hbCBjb21wdXRlciBvciB1c2Ugb25lIG9mIHRoZSBsYWJzIGNvbXB1dGVycy4KCiogRG93bmxvYWQgVGFibGVhIGFjYWRlbWljIGhlcmU6IGh0dHBzOi8vd3d3LnRhYmxlYXUuY29tL2FjYWRlbWljL3N0dWRlbnRzCgoxLiBSZWZlciB0byBmaWxlICdzdGF0ZXNfcHVyY2hhc2Vfb3JkZXJzLmNzdicgaW4gdGhlIGRhdGEgZm9sZGVyCgoyLiBTdGFydCBUYWJsZWF1IGFuZCBlbnRlciB5b3VyIExVQyBlbWFpbCBpZiBwcm9tcHRlZC4KCjMuIEltcG9ydCB0aGUgZmlsZSBpbnRvIFRhYmxlYXUuIENob29zZSB0aGUgVGV4dCBGaWxlIG9wdGlvbiB3aGVuIGltcG9ydGluZwoKIVtdKGltZ3MvdGFibGVhdV9pbXBvcnRmaWxlLnBuZykKCgo0LiBVbmRlciB0aGUgZGltZW5zaW9ucyB0YWIgbG9jYXRlZCBvbiB0aGUgbGVmdCBzaWRlIG9mIHRoZSBzY3JlZW4uCgohW10oaW1ncy90YWJsZWF1X3ZhcmlhYmxlcy5wbmcpCgpET1VCTEUgY2xpY2sgIG9uIHRoZSAnRGVwYXJ0bWVudC5OYW1lJywgdGhlbiBET1VCTEUgY2xpY2sgb24gJ051bWJlciBvZiBSZWNvcmRzJyB2YXJpYWJsZSBsb2NhdGVkIG9uIHRoZSBib3R0b20gbGVmdCBvZiB0aGUgc2NyZWVuLiBOb3RlIHRoZSBiYXIgbGlrZSB2aWV3IGFuZCBicmVha2Rvd25zLgoKKiBXaGF0IGRlcGFydG1lbnQgJ2JpbicgaGFzIHRoZSBoaWdoZXN0IGNvdW50PyBXaGF0IGlzIHRoZSBjb3VudD8gCiogRnJvbSB0aGUgdXBwZXIgcmlnaHQgY29ybmVyIG9mIHRoZSBzY3JlZW4gc2VsZWN0IG90aGVyIHZpZXdzIChzZWxlY3Qgb25lIG9mIHRoZSBvdGhlciB2aWV3cywgdGFsayBhYm91dCBpdCBhbmQgcG9zdCBhbiBzY3JlZW5zaG90KQoKIVtdKGltZ3MvdGFibGVhdV92aXN1YWxpemF0aW9ucy5wbmcpCgpgIyBDaGFuZ2UgdGhlIGltYWdlIGZvciB5b3VyIHNjcmVlbnNob3RzIGFuZCBNQUtFIENPTU1FTlRTYAoKNS4gQ3JlYXRlIGEgbmV3IHNoZWV0IGJ5IGNsaWNraW5nIG9uIHRoZSBpY29uIG5leHQgdG8geW91ciBjdXJyZW50IHNoZWV0LgoKIVtdKGltZ3MvdGFibGVhdV9uZXdzaGVldC5wbmcpCgpUaGVuIERPVUJMRSBjbGljayBvbiAnTnVtYmVyIG9mIFJlY29yZHMnIHZhcmlhYmxlIHRoZW4gRE9VQkxFIGNsaWNrIG9uICdWZW5kb3IuWmlwJywgdGhlbiBvbiB0aGUgdG9wIGxlZnQgc2VsZWN0IHRoZSByZWNvbW1lbmQgdmlldy4gCgoqIFdoYXQgYXJlIHRoZSBoaWdobGlnaHRzIG9uIHRoZSBtYXA/CiogQ2FuIHlvdSBnaXZlIGFuIGV4cGxhbmF0aW9uIG9mIHdoeSB0aGVyZSBpcyBhIGNvbmNlbnRyYXRpb24gb24gYSBwYXJ0aWN1bGFyIHJlZ2lvbj8KCiFbXShpbWdzL3RhYmxlYXVfc2hvd21lLnBuZykKCmAjIENoYW5nZSB0aGUgaW1hZ2UgZm9yIHlvdXIgc2NyZWVuc2hvdHMgYW5kIE1BS0UgQ09NTUVOVFNg