if (!require("tidyverse")) install.packages("tidyverse")
## Loading required package: tidyverse
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.4.4 ✔ tibble 3.2.1
## ✔ lubridate 1.9.3 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
if (!require("tidycensus")) install.packages("tidycensus")
## Loading required package: tidycensus
library(tidyverse)
library(tidycensus)
TNGPData <- read.csv("https://drkblake.com/wp-content/uploads/2024/02/TNGPData.csv")
DRW_ZIPs <- read.csv("https://drkblake.com/wp-content/uploads/2024/02/DRW_ZIPs.csv")
MergedData <- left_join(DRW_ZIPs,
TNGPData,
by = join_by(ZIP == ZCTA))
head(MergedData, 10)
## ZIP GParents_E GParents_M
## 1 37013 898 245
## 2 37015 229 121
## 3 37027 72 42
## 4 37064 120 81
## 5 37072 405 161
## 6 37076 164 91
## 7 37080 33 28
## 8 37115 287 145
## 9 37122 277 139
## 10 37135 37 40