Message-ID: <001d01d83bf8$00d11420$02733c60$@sbcglobal.net>
Date: 2022-03-20T01:15:34Z
From: Jeff Reichman
Subject: Combining data.frames
R-Help Community
I'm trying to combine two data.frames which each containing 10 columns of
which they each share two common fields. Here are two small test datasets.
df1 <- data.frame(date =
c("2021-1-1","2021-1-1","2021-1-1","2021-1-1","2021-1-1",
"2021-1-2","2021-1-2","2021-1-3","2021-1-3","2021-1-3"),
geo_hash =
c("abc123","abc123","abc456","abc789","abc246","abc123",
"asd123","abc789","abc890","abc123"),
ad_id = c("a12345","b12345","a12345","a12345","c12345",
"b12345","b12345","a12345","b12345","a12345"))
df2 <- data.frame(date =
c("2021-1-1","2021-1-1","2021-1-2","2021-1-3","2021-1-3"),
geo_hash =
c("abc123","abc456","abc123","abc789","abc890"),
event = c("shoting","ied","protest","riot","protest"))
I'm trying to combine them such that I get a combined data.frames such as
date geo_hash ad_id event
1/1/2021 abc123 a12345 shoting
1/1/2021 abc123 b12345
1/1/2021 abc456 a12345 ied
1/1/2021 abc789 a12345
1/1/2021 abc246 c12345
Jeff