R use of where to select rows by matching an element from a list

Question

I'm trying to utilise R's "where" function in a loop to select a certain row from two datasets based on a matching element, and then plot the two together in a scatterplot. The row names of the two dataframes, as well as the loop, are provided in the code sample below. There are more counties in each dataframe than are listed in "mycounties."

I have used the "where" function in a loop exactly like this before, but this time R is returning the error message that "where" doesn't exist? I know "where" exists! My question is, how do I make R recognize this "where" structure, or is there a better way to pick out the rows I want to plot?

Answer 1

There is no location function, as Jeff and the comments have stated. the R version of which.

You don't require which at all in this case, though:

x <- pm

PM$County == MyCountries[i], 2:48

dt$county == mycounties[i], 2:48; y - dt$county

A further if statement in your example is:

In the event that (mat$county[i] percent in percent dt5$county))

dt5[dt5$county == mat$county[i], 2:58] = mat[i,2:58]

}

That is presuming that each mat$county in your dt5$county only has one matching county. You'll receive an error if you don't.