Menu
I have two large data frames(df1 and df2). I want to combine them using rbind function:
df<-rbind(df1,df2)
However, I get an error:
Error in match.names(clabs, names(xi)) :
names do not match previous names
There more than 100 variables in the data frames. I know most names match. One or two names may not match. How can I find unmatched column names of df1 and df2. I will be very glad for any help. Thanks a lot.
862
How to Find Unmatched Records in R?, To retrieve all rows in one data frame that do not have matching values in another data frame, use R's anti_join() function from the dplyr package.
We can compare two columns in R by using ifelse(). This statement is used to check the condition given and return the data accordingly. where, df is the input dataframe.
For cbind ( rbind ) the column (row) names are taken from the colnames ( rownames ) of the arguments if these are matrix-like. Otherwise from the names of the arguments or where those are not supplied and deparse.
To access a specific column in a dataframe by name, you use the $ operator in the form df$name where df is the name of the dataframe, and name is the name of the column you are interested in. This operation will then return the column you want as a vector.
You could use setdiff:
a <- c("a", "b", "c")
b <- c("b", "c", "d")
setdiff(a, b)
#[1] "a"
setdiff(b, a)
#[1] "d"
where a is, e.g., names(df1).
189
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
