table(PAD_Data_safedash_offenses$Zip_Code)[1:10]
## 
## 78201 78202 78203 78204 78205 78206 78207 78208 78209 78210 
## 15879  7096  2679  6502 13600     7 25833  2295 11028 13426
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(pastecs)
## 
## Attaching package: 'pastecs'
## The following objects are masked from 'package:dplyr':
## 
##     first, last
zip_offenses <- PAD_Data_safedash_offenses %>%
filter(!is.na(Zip_Code), Zip_Code != "") %>%
count(Zip_Code, name = "offense_count")

head(zip_offenses)
##   Zip_Code offense_count
## 1    78201         15879
## 2    78202          7096
## 3    78203          2679
## 4    78204          6502
## 5    78205         13600
## 6    78206             7