Is there a way to find the minimum value across multiple data frames? [closed]

by

If the data frames are DF1, DF2, …, DF20 then assuming you want the data frame DF such that DF[i, j] = min(DF1[i, j], DF2[i, j], …, DF20[i, j]) then:

L <- list(DF1, DF2, DF3, DF4, DF5, DF6, DF7, DF8, DF9, DF10,
          DF11, DF12, DF13, DF14, DF15, DF16, DF17, DF18, DF19, DF20)
Reduce(pmin, L)

or

do.call(pmin, L)

or

pmin(DF1, DF2, DF3, DF4, DF5, DF6, DF7, DF8, DF9, DF10,
          DF11, DF12, DF13, DF14, DF15, DF16, DF17, DF18, DF19, DF20)

We can get L in a number of ways other than writing it out:

  1. if we have the names of the data frames in a character vector Names then L <- mget(Names, .GlobalEnv) and if we knew that the data frames all have names DF followed by digits then we can form Names using Names <- ls(pattern = "^DF\\d+$")

  2. if the only data frames in the global environment are DF1, DF2, …, DFn then we can form L like this:

    m <- mget(ls(), envir = .GlobalEnv, mode = "list", ifnotfound = NA)
L <- Filter(is.data.frame, m)

More Related Contents:

  1. Using ggplot2, can I insert a break in the axis?
  2. Installing older version of R package
  3. How to subset matrix to one column, maintain matrix data type, maintain row/column names?
  4. Filter multiple values on a string column in dplyr
  5. Fixing the order of facets in ggplot
  6. Loop in R to read many files
  7. Change the class from factor to numeric of many columns in a data frame
  8. Plot with conditional colors based on values in R [duplicate]
  9. Forcing garbage collection to run in R with the gc() command
  10. R: How to handle times without dates?
  11. Converting nested list to dataframe
  12. Align ggplot2 plots vertically
  13. How to count the frequency of a string for each row in R
  14. Problems installing the devtools package
  15. It is possible to create inset graphs?
  16. Why TRUE == “TRUE” is TRUE in R?
  17. R + ggplot2 => add labels on facet pie chart [duplicate]
  18. Linear Regression with a known fixed intercept in R
  19. Formatting reactive data.frames in Shiny
  20. How can I document data sets with roxygen?
  21. constrained optimization in R
  22. Calculate correlation with cor(), only for numerical columns
  23. Can I use a list as a hash in R? If so, why is it so slow?
  24. Find rows in a data frame where two columns are equal
  25. min for each row in a data frame
  26. How to change angle of line in customized legend in ggplot2
  27. Use outer instead of expand.grid
  28. Calculating Time Difference between two columns
  29. How can I access dimensions of labels plotted by `geom_text` in `ggplot2`?
  30. How to order my dataframe lexicographicaly

Leave a Comment