> On Jan 8, 2020, at 6:52 AM, Thomas Subia <[email protected]> wrote:
>
> Colleagues,
>
> I have two data frames which look like this.
>
> Data frame 1
>
> Serial Pre.Hole Pre.flow Pre.Date
> 1 3036 1 0.24 19-Nov-19
> 2 3036 2 0.212 19-Nov-19
> 3 3036 3 1.292 19-Nov-19
> 4 3036 4 0.262 19-Nov-19
> 5 3036 5 1.291 19-Nov-19
> 6 3036 6 0.26 19-Nov-19
>
> Data frame 2
>
> Serial Post.Hole Post.flow Post.Date
> 62323 11024 44 -0.678 11-Dec-19
> 62324 11024 45 -0.659 11-Dec-19
> 62325 11024 46 -0.654 11-Dec-19
> 62326 11024 47 -0.699 11-Dec-19
> 62327 11024 48 -0.671 11-Dec-19
> 62328 11024 49 -0.687 11-Dec-19
>
> What I want is to create a data frame whose serials numbers are common to
> data frames 1 and 2.
> The resulting data frame 1st row would look like this.
>
> Serial Post.Hole Post.flow Post.Date Pre.Hole
> Pre.flow Pre.Date
Simply try:
new.df <- merge(df1,df2)
You should be aware that those columns with dates are actually factor or
character values. R does have a Date class and you will likely want to look at
using as.Date to make them more useful.
--
David.
>
> Any ideas on how to do this would be appreciated.
>
> Thomas Subia
> Statistician / Senior Quality Engineer
>
> IMG Companies
> 225 Mountain Vista Parkway
> Livermore, CA 94551
> T. (925) 273-1106
> F. (925) 273-1111
> E. [email protected]
>
>
> Precision Manufacturing for Emerging Technologies
> imgprecision.com
>
> The contents of this message, together with any attachments, are intended
> only for the use of the individual or entity to which they are addressed and
> may contain information that is legally privileged, confidential and exempt
> from disclosure. If you are not the intended recipient, you are hereby
> notified that any dissemination, distribution, or copying of this message, or
> any attachment, is strictly prohibited. If you have received this message in
> error, please notify the original sender or IMG Companies, LLC at Tel:
> 925-273-1100 immediately by telephone or by return E-mail and delete this
> message, along with any attachments, from your computer. Thank you.
>
> ______________________________________________
> [email protected] 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.
______________________________________________
[email protected] 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.
