r – How to find value with condition

by

We can try with dplyr. After grouping by ‘Name’, filter the rows where the row_number() is less than or equal to 3 and then get the max of ‘Score’

library(dplyr)
df1 %>%
    group_by(Name) %>% 
    filter(row_number() <=3) %>% 
    summarise(Score = max(Score))
# A tibble: 3 × 2
#   Name Score
#  <chr> <int>
#1     A     7
#2     B     4
#3     C     4

More Related Contents:

  1. For each row return the column name of the largest value
  2. How to use a variable to specify column name in ggplot
  3. Combine legends for color and shape into a single legend
  4. subtract value from previous row by group
  5. R force local scope
  6. ggplot combining two plots from different data.frames
  7. Display a time clock in the R command line
  8. can’t execute rsDriver (connection refused)
  9. R compare multiple values with vector and return vector [duplicate]
  10. How to generate all possible combinations of vectors without caring for order?
  11. ggplot side by side geom_bar()
  12. How to escape a backslash in R? [duplicate]
  13. Change value of variable with dplyr
  14. R: ggplot2, can I set the plot title to wrap around and shrink the text to fit the plot?
  15. Concatenate several columns to comma separated strings by group
  16. How to italicize part (one or two words) of an axis title
  17. Rounding time to nearest quarter hour
  18. Read and rbind multiple csv files
  19. “import as” in R
  20. Checking if Date is Between two Dates in R
  21. Add secondary X axis labels to ggplot with one X axis
  22. data.table row-wise sum, mean, min, max like dplyr?
  23. Plot coordinates on map
  24. Triple exclamation marks on R
  25. R error which says “Models were not all fitted to the same size of dataset”
  26. Importing a big xlsx file into R?
  27. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  28. R: apt-get install r-cran-foo vs. install.packages(“foo”)
  29. fast large matrix multiplication in R
  30. Round a POSIX date (POSIXct) with base R functionality

Leave a Comment