Message-ID: <CF8037D6-D4F3-474B-B75B-4A1015120DE1@dcn.davis.ca.us>
Date: 2022-03-20T01:51:09Z
From: Jeff Newmiller
Subject: Combining data.frames
In-Reply-To: <001f01d83bf9$0be19be0$23a4d3a0$@sbcglobal.net>
Then show your code so we can focus on what you haven't yet figured out. Have you read the examples in the merge help page?
On March 19, 2022 6:23:02 PM PDT, Jeff Reichman <reichmanj at sbcglobal.net> wrote:
>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.
>
>______________________________________________
>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.
--
Sent from my phone. Please excuse my brevity.