merging time series and cross-section time series dataframes

Vote count:

0

I am having an issue merging 2 dataframes in R - one is a time series cross-section (i.e. a panel) and the other is a simple time series. Suppose I have two dataframes, df1 and df2, that I would like to merge. The panel dataframe df1 is given by

id year var1
1   80    3
1   81    5
1   82    7
1   83    9
2   80    5
2   81    5
2   82    7
2   83    5
3   80    9
3   81    9
3   82    7
3   83    3

while the time series dataframe df2 is given by

year var2
80   10
81   15
82   17
83   19

I would like to merge df1 and df2 into a third dataframe df, while preserving the time series cross-section row ordering of df1. However, when I use the command

df <- merge(df1, df2, by="year")

the new dataframe clusters the observations by year.

year id var1 var2
80  1    3   10
80  2    5   10
80  3    9   10
81  1    5   15
81  2    5   15
81  3    9   15
82  1    7   17
82  2    7   17
82  3    7   17
83  1    9   19
83  2    5   19
83  3    3   19

Does anyone know how I can make the row ordering in df the same as in df1? Thanks in advance!

asked 3 mins ago

Larry

8