In my dataset I have data for states and years of observation for certain variables for the US. I have multiple observations per year and state. In another dataset I have a dummy variable that sets whether a particular state in a particular year implemented a law (1) or not (0). Obviously, these 2 datasets have different length, but I would like to add the dummy law variable in the "large" dataset.
Let's say my initial dataset is:
state <- c(Alabama, Alabama, Alabama, Alabama Alabama, Arkansas, Arkansas, Arkansas, Arkansas, Arizona, Arizona, Arizona, Arizona, Arizona, Arizona)
year <- c(1991, 1991, 1992, 1992, 1993, 1991, 1992, 1993, 1993, 1991, 1991, 1992, 1992, 1993, 1993)
df <- data.drame(state, year)
My second database is:
state <- c(Alabama, Alabama, Alabama, Arkansas, Arkansas, Arkansas, Arizona, Arizona, Arizona)
year <- c(1991, 1992, 1993, 1991, 1992, 1993, 1991, 1992, 1993)
law <- c(0,1,1,0,0,0,0,0,1)
df2 <- data.frame(state, year, law)
I want to obtain this:
state <- c(Alabama, Alabama, Alabama, Alabama Alabama, Arkansas, Arkansas, Arkansas, Arkansas, Arizona, Arizona, Arizona, Arizona, Arizona, Arizona)
year <- c(1991, 1991, 1992, 1992, 1993, 1991, 1992, 1993, 1993, 1991, 1991, 1992, 1992, 1993, 1993)
law <- c(0,0,1,1,1,0,0,0,0,0,0,0,0,1,1)
df <- data.frame(state, year, law)
Note that in my "real" dataframe i have way more observations and variables, so I would appreciate if the code does not include specific names of states or years,
Thanks!
