shooting<-shooting %>% select(1:13) %>% mutate(Date=mdy(Date),year=year(Date))shooting$Gender<-if_else(shooting$Gender=="M","Male",shooting$Gender)shooting$Race<-if_else(str_detect(shooting$Race,"Black American or African American"),"Black",shooting$Race)shooting$Race<-if_else(str_detect(shooting$Race,"White American or European American"),"White",shooting$Race)shooting$Race<-if_else(str_detect(shooting$Race,"Asian American"),"Asian",shooting$Race)shooting$Race<-if_else(str_detect(shooting$Race,"Some other race"),"Other",shooting$Race)shooting$Race<-if_else(str_detect(shooting$Race,"Native American or Alaska Native"),"Native American",shooting$Race)shooting$yearcut<-cut(shooting$year,breaks = 10)shooting[align=left][color=#595757][backcolor=#ffffff][/backcolor][/color][/align]Mental Health Issues`<-if_else(str_detect(shooting[align=left][color=#595757][backcolor=#ffffff][/backcolor][/color][/align]Mental Health Issues`,"Un"),"Unknown",shooting[align=left][color=#595757][backcolor=#ffffff][/backcolor][/color][/align]Mental Health Issues`)shooting$Race<-str_to_upper(shooting$Race)shooting[align=left][color=#595757][backcolor=#ffffff][/backcolor][/color][/align]Mental Health Issues`<-str_to_upper(shooting[align=left][color=#595757][backcolor=#ffffff][/backcolor][/color][/align]Mental Health Issues`)#将location分成city和state两个变量shooting$city<-sapply(shooting$Location,function(x){ return(unlist(str_split(x,","))[1 %>% str_trim())})shooting$state<-sapply(shooting$Location,function(x){ return(unlist(str_split(x,","))[2 %>% str_trim())})