Vlookup/Merge/Join Several CSV with No Headers in R

General
,
1

I have several csv files with no headers and the only commonality is the first column that always has the users unique ID. I want to create one csv file that combines specific information based on the user ID chosen.

So for example there is:

table 1 (which has no header but for guidance the columns are ID, Name, Birthday)

80938        	     James	              Nov-00
78397	              Tom	              Jul-20
73820	              Pam	              Sep-10

and table 2 (which has no header but for guidance the columns are ID, Product Category, Purchase in 2012, Purchase in 2013, Purchase in 2014, Purchase in 2015)

80938	      1	          500000	        600000	            700000	           800000
80938	      2	            333	             456	               567	             467
80938	      3	            444	             456	               399	             799

I want to create the combined table below

ID: 80938
Name: James
Birthday: Nov-00
Product: 1
	                2012	           2013	           2014	           2015
Purchase	      500000           	  600000	      700000	      800000
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.