Bind spatial data frames

I have a long panel dataset (Data_Base) with the name of the 32 states in Mexico through 28 years in time (928 obs). I have in another .rds file the spatial data for these 32 states (mex.sf), in total of 32 obs. I want to bind the dataset with the spatial data. Of course the spatial data from the file mex.sf should be repeated 28 times per state due the difference in longitude of observations. I try with the following command specifying the condition to merge per name of state:

example <- merge(Data_Base, mex.sf, by=intersect(Data_Base$State,mex.sf$NAME_1))

Nevetheless I ended up with the following error message:

Error in fix.by(by.x, x) : 'by' must specify uniquely valid columns

Bellow an example of how the data looks like

enter image description here

enter image description here

Does anyone knows why cannot bind them?

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum