First parsing.Rmd

---
title: "R Notebook"
output: html_notebook
---

This is an [R Markdown](http://rmarkdown.rstudio.com) Notebook. When you execute code within the notebook, the results appear beneath the code. 

Try executing this chunk by clicking the *Run* button within the chunk or by placing your cursor inside it and pressing *Cmd+Shift+Enter*. 

```{r}
library(tidyverse)
library(stringr)
counties = read_tsv("Gaz_counties_national.txt") %>% mutate(county = GEOID)
subcounties = read_tsv("2016_Gaz_cousubs_national.txt") %>% mutate(county=str_sub(GEOID,0,5))

subcounties %>% select(county)
county_names = counties %>% select(county,county_name = NAME)

subcounties %>% inner_join(county_names)

files = list.files("wiki_census",pattern = ".csv",full.names = T)
files = files[!grepl("Counties2014",files)]
csvs = lapply(files,function(f) read_csv(f))

c = csvs[1]
c %>% gather(year,count,-Geography)
c
c %>% mutate()

state = read_csv("wiki_census/ALPlaces.csv")


subcounties %>%
  filter(USPS=="NJ") %>%
  ggplot() + geom_point(aes(y=INTPTLAT,x=INTPTLONG,color=county)) + coord_map()


```

Add a new chunk by clicking the *Insert Chunk* button on the toolbar or by pressing *Cmd+Option+I*.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the *Preview* button or press *Cmd+Shift+K* to preview the HTML file).