Message-ID: <001f01d83bf9$0be19be0$23a4d3a0$@sbcglobal.net>
Date: 2022-03-20T01:23:02Z
From: Jeff Reichman
Subject: Combining data.frames
In-Reply-To: <ae4664a2c2a8d9ab0931cb620c88242a@ontargettek.com>
Evening Tom
Yest I've been playing with the merge function. But haven't been able to
achieve what I need. Could maybe the way to to and it might be my syntax
-----Original Message-----
From: Tom Woolman <twoolman at ontargettek.com>
Sent: Saturday, March 19, 2022 8:20 PM
To: reichmanj at sbcglobal.net
Cc: r-help at r-project.org
Subject: Re: [R] Combining data.frames
Have you looked at the merge function in base R?
https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/merge
On 2022-03-19 21:15, Jeff Reichman wrote:
> 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
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.