Subsetting and Aggregating GDELT Using dplyr and SQLite

Edit 17 Sept to reflect┬áchanges in dplyr's syntax GDELT is an incredible resource for researchers and political scientists and has been getting increasing attention in popular publications. But weighing in at more than 60 GB, it's too hefty for any kind of quick analysis in R, and is even cumbersome to subset in Python. The … Continue reading Subsetting and Aggregating GDELT Using dplyr and SQLite