Merge two data frames while keeping the original row order

by

You just need to create a variable which gives the row number in df.2. Then, once you have merged your data, you sort the new data set according to this variable. Here is an example : 

df.1<-data.frame(class=c(1,2,3), prob=c(0.5,0.7,0.3))
df.2<-data.frame(object=c('A','B','D','F','C'), class=c(2,1,2,3,1))
df.2$id  <- 1:nrow(df.2)
out  <- merge(df.2,df.1, by = "class")
out[order(out$id), ]

More Related Contents:

  1. Sort (order) data frame rows by multiple columns
  2. Simultaneously merge multiple data.frames in a list
  3. Order data frame rows according to vector with specific order
  4. Compare two data.frames to find the rows in data.frame 1 that are not present in data.frame 2
  5. How does one reorder columns in a data frame?
  6. Merging a lot of data.frames [duplicate]
  7. How to quickly form groups (quartiles, deciles, etc) by ordering column(s) in a data frame
  8. How do I combine two data-frames based on two columns? [duplicate]
  9. Merge unequal dataframes and replace missing rows with 0
  10. How to sort a data frame in R
  11. How to append rows to an R data frame
  12. How to sort a data frame by date
  13. Read and rbind multiple csv files
  14. Select rows from one data.frame that are not present in a second data.frame
  15. Merge data frames based on rownames in R
  16. Merge or combine by rownames
  17. How to sort all dataframes in a list of dataframes on the same column?
  18. Identify records in data frame A not contained in data frame B [closed]
  19. How can I merge more than 2 dataframes in R by rownames?
  20. Move NAs to the end of each column in a data frame
  21. Data.frame Merge and Selection of values which are common in 2 Data.frames
  22. How to add a row to a data frame in R?
  23. Replace all particular values in a data frame
  24. Merge rows in a dataframe where the rows are disjoint and contain NAs
  25. Re-ordering bars in R’s barplot()
  26. How to delete rows where all the columns are zero
  27. Transposing a dataframe maintaining the first column as heading
  28. Filter data frame rows based on values in vector
  29. Replace values in data frame based on other data frame in R
  30. What you can do with a data.frame that you can’t with a data.table?

Leave a Comment