I have some time series (monthly) that end in different months, for example, some end in March 2017, others in April 2017 and some until May 2017,
228 2016-12-01 1.12
229 2017-01-01 1.09
230 2017-02-01 0.87
231 2017-03-01 1.05
232 2017-04-01 0.79
233 2017-05-01 0.08
data v7827
206 2016-10-01 12.36
207 2016-11-01 12.37
208 2016-12-01 11.84
209 2017-01-01 11.11
210 2017-02-01 10.53
211 2017-03-01 9.85
data v3698
227 2016-11-01 3.3420
228 2016-12-01 3.3523
229 2017-01-01 3.1966
230 2017-02-01 3.1042
231 2017-03-01 3.1279
232 2017-04-01 3.1362
I need to merge them into a single data.frame, but using a cbind results in an error because the number of lines is different. How can I make a join between these tables to turn them into one in a simplified way? No need to be adding values on empty dates? The expected end result is this:
v7827 v3698
228 2016-12-01 1.12 11.84 3.3523
229 2017-01-01 1.09 11.11 3.1966
230 2017-02-01 0.87 10.53 3.1042
231 2017-03-01 1.05 9.85 3.1279
232 2017-04-01 0.79 3.1362
233 2017-05-01 0.08