[R] Dataframe by Serial ID

[Thomas Subia]

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. tsubia using 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.