Question: Using the following dataset, clean up the data, and make some type of visualization to show the different relationships, models or plot types. ori,county,latitude,longitude,state_abbr,state,agency_name,agency_type,is_nibrs,nibrs_start_date AL0430200,LEE,32.604064,-85.353048,AL,Alabama,Opelika
Using the following dataset, clean up the data, and make some type of visualization to show the different relationships, models or plot types.
ori,county,latitude,longitude,state_abbr,state,agency_name,agency_type,is_nibrs,nibrs_start_date AL0430200,LEE,32.604064,-85.353048,AL,Alabama,Opelika Police Department,City,TRUE,2021-01-01 AL0430100,LEE,32.608086,-85.475136,AL,Alabama,Auburn Police Department,City,TRUE,2020-12-01 AL0430000,LEE,32.604064,-85.353048,AL,Alabama,Lee County Sheriff's Office,County,TRUE,2012-04-01 AL0070100,BIBB,33.015893,-87.127148,AL,Alabama,Centreville Police Department,City,TRUE,2020-01-01 AL0070000,BIBB,32.939995,-87.11683,AL,Alabama,Bibb County Sheriff's Office,County,TRUE,2021-01-01 AL0070300,BIBB,33.015893,-87.127148,AL,Alabama,West Blocton Police Department,City,TRUE,2020-01-01 AL0070200,BIBB,33.015893,-87.127148,AL,Alabama,Brent Police Department,City,TRUE,2020-01-01 AL0170000,CLAY,33.267809,-85.862051,AL,Alabama,Clay County Sheriff's Office,County,TRUE,2021-01-01 AL0170200,CLAY,33.267809,-85.862051,AL,Alabama,Lineville Police Department,City,TRUE,2020-01-01 AL0170100,CLAY,33.267809,-85.862051,AL,Alabama,Ashland Police Department,City,TRUE,2015-08-01 AL0260900,DALE,31.23572,-85.72021,AL,Alabama,Clayhatchee Police Department,City,TRUE,2020-10-01 AL0260000,DALE,31.430654,-85.609476,AL,Alabama,Dale County Sheriff's Office,County,TRUE,2006-01-01 AL0260100,DALE,31.430654,-85.609476,AL,Alabama,Ozark Police Department,City,TRUE,2015-11-01 AL0260200,DALE,31.430654,-85.609476,AL,Alabama,Daleville Police Department,City,TRUE,2021-01-01 AL0260300,DALE,31.430654,-85.609476,AL,Alabama,Level Plains Police Department,City,TRUE,2021-01-01
CO0340200,NOT SPECIFIED,37.287367,-107.839718,CO,Colorado,Southern Ute Tribal,Tribal,TRUE,2021-01-01 COCBI0000,NOT SPECIFIED,39.727325,-105.10969,CO,Colorado,Colorado Bureau of Investigation,Other State Agency,TRUE,2008-01-01 COCSP0000,NOT SPECIFIED,39.72749,-105.10969,CO,Colorado,State Patrol,State Police,TRUE,2006-01-01 CODI01100,NOT SPECIFIED,37.338025,-108.595786,CO,Colorado,Ute Mountain Tribal,Tribal,TRUE,2021-01-01 CO0210900,"EL PASO, TELLER",38.827383,-104.527472,CO,Colorado,Green Mountain Falls Police Department,City,TRUE,2012-01-01 CO0010500,"ADAMS, JEFFERSON",39.86312,-105.050415,CO,Colorado,Westminster Police Department,City,TRUE,1997-01-01 CO0300100,"ADAMS, JEFFERSON",39.802036,-105.08734,CO,Colorado,Arvada Police Department,City,TRUE,2006-01-01 CO0030600,"ARAPAHOE, JEFFERSON",39.619427,-105.04605,CO,Colorado,Bow Mar Police Department,City,TRUE,1997-01-01 CO0550100,"RIO GRANDE, SAGUACHE",38.031651,-106.234666,CO,Colorado,Center Police Department,City,TRUE,1997-01-01 CO0010100,"ADAMS, ARAPAHOE, DOUGLAS",39.70955,-104.81493,CO,Colorado,Aurora Police Department,City,TRUE,1985-01-01 CO0030200,"ARAPAHOE, DOUGLAS, JEFFERSON",39.616898,-105.01454,CO,Colorado,Littleton Police Department,City,TRUE,2011-01-01 CT0018000,NOT SPECIFIED,41.806053,-72.732916,CT,Connecticut,Connecticut Department of Motor Vehicles,Other State Agency,TRUE,2016-08-01 CTDI00200,NOT SPECIFIED,41.472651,-72.108633,CT,Connecticut,Mashantucket Pequot Tribal,Tribal,TRUE,2017-01-01 CT0018300,NOT SPECIFIED,NA,NA,CT,Connecticut,Department of Energy and Environmental Protection,NA,TRUE,2019-01-01
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
