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

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. tsu...@imgprecision.com


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.

______________________________________________
R-help@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.

Reply via email to