R data frame create a new variable which corresponds to one of the existing one
If my assumptions about CommArea_Num are correct, then:

data$community_area_clean = data$community_area_clean[data$CommAreaNum]


should remap that column. Note that the AREA_KM fields will remain in the order currently shown.