Problems with Merging: 'by' must specify a uniquely valid column

r dataset yelp
SJSU2013 picture SJSU2013 · Nov 25, 2013 · Viewed 12.9k times · Source

I am having a problem mergin my datasets together. I get the above error message after I run the last line of code. However, both data sets have the same column name.

The head of avgRev2 is:

  avgRev         restaurantType
 1       33                 Afghan
 2       22                African
 3 56.84211         American (New)
 4 28.69203 American (Traditional)
 5        7              Argentine
 6 51.40909   Arts & Entertainment

The last two rows in expandedDataframe are:

isRestaurant restaurantType
X5          TRUE         Bagels
X10         TRUE     Sandwiches
X12         TRUE        Mexican
X14         TRUE          Pizza
X18         TRUE        Burgers
X23         TRUE        Buffets

I wrote the below code but it won't let me merge the data. I get the error :

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

avgRev <- tapply(expandedDataFrame$review_count,expandedDataFrame$restaurantType,mean,simplify=FALSE)

avgRev2 <- as.data.frame(avgRev,)
avgRev2$category<-row.names(avgRev2)
row.names(avgRev2)=NULL

avgRev2 <- rename(avgRev2, c(category="restaurantType"))

expandedDataFrame2<- merge(expandedDataFrame, avgRev2, by="restuarantType")

Answer

Related questions

How to delete the first row of a dataframe in R?

I have a dataset with 11 columns with over a 1000 rows each. The columns were labeled V1, V2, V11, etc.. I replaced the names with something more useful to me using the "c" command. I didn't realize that row 1 also contained …

Read More
Sort columns of a dataframe by column name

This is possibly a simple question, but I do not know how to order columns alphabetically. test = data.frame(C = c(0, 2, 4, 7, 8), A = c(4, 2, 4, 7, 8), B = c(1, 3, 8, 3, 2)) # C A B # 1 0 4 1 # 2 2 2 3 # 3 4 4 8 # 4 7 7 3 # 5 8 8 2 I like to order the columns by column names alphabetically, to achieve # …

Read More
How to add header to a dataset in R?

I need to read the ''wdbc.data' in the following data folder: http://archive.ics.uci.edu/ml/machine-learning-databases/breast-cancer-wisconsin/ Doing this in R is easy using command read.csv but as the header is missing how can I add …

Read More